Title: Database Developer - Extract, Transform, and Load Location: Smithfield, RI Job Code:301977 Description: Mastech Digital provides digital and mainstream technology staff as well as Digital Transformation Services for all American Corporations. We are currently seeking a Database Developer/ETL for our client in the Financial Services domain. We value our professionals, providing comprehensive benefits and the opportunity for growth. This is a Contract position, and the client is looking for someone to start immediately. Duration: 12+ Months Contract (possible extension/ conversion) Location: Smithfield, RI (Hybrid) 2 weeks onsite per month/ alternate weeks, rest remote Salary: Up to $130,000/Annually or $65.00/Hourly Role: Database Developer/ETL Primary Skills: Database Development Role Description: The Database Developer/ETL must have 5+ years of experience. Primary Responsibilities: - Database Development, primarily in Oracle PL/SQL. - Must be strong in writing Complex Queries. - Writing PL/SQL functions and packages. - The ability to Diagnose data issues and performance matrix; ETL, specifically Informatica, experience also strongly preferred. Must Haves: - PL/SQL - Expert - ETL - Informatica - Oracle - Expert - Development background - Packaging - Expert Nice To Have Skills: - Enterprise Data Lake experience - Modeling nice to Have - Financial background - Cloud exposure The Skills that are Key to this role: - Demonstrative experience in Oracle/ PL-SQL and Informatica ETL including packages, procedures, function, and triggers. - Ability to optimize sophisticated queries and compose efficient solutions. - Experience working in enterprise environments with version control and deployment standards. - Excellent Analytical and problem-solving skills with detail-oriented mindset. - Extensive experience in Data engineering, Data modeling and Data analysis - Experience in ETL invent and development. - Experience with data base such as Oracle (Primary), SQL server. - Experience of working in Agile methodology. - Knowledge of Containerization and cloud deployment related to Database. - Ability to build communication and rapport with partners and stakeholders. - Ability to adapt, in a changing environment and be effective in many different business settings. - Ability to take initiative, define vision for improvement of products, and execute at high level of quality The skills that are good to have for this role: - Ability to plan and work with geographically spread-out teams - Strong presentation and interpersonal skills. - Curiosity to constantly relearn/explore new processes/technologies The Value You Deliver: - Developing and crafting robust high per-performance database solutions. - Assessing and researching current implementations of the platform and determining the course of action required to elevate the platform to meet customer needs. - Taking the business requirements coupled with existing architecture to set a technical vision for features and major components and clearly articulating the evolutionary steps to achieve it. Education: Bachelor’s degree Experience: Minimum 5+ years of experience Relocation: This position will not cover relocation expenses Travel: No Local Preferred: Yes Note: Must be able to work on a W2 basis (No C2C) Benefits: We have various coverages and additional benefits to choose from: - Medical, Dental (Including Ortho) & Vision Insurance (Option to Enroll). - Paid Leaves (Wherever applicable). - Life & Disability Coverage (Upon eligibility). - 401K Option, Education Assistance Program and more. Mastech Digital is an Equal Opportunity Employer - All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or protected veteran status.

• Administer and manage Oracle databases on Exadata infrastructure (ExaCC / on-premise) and Linux-hosted Standard Edition environments. • Monitor database health, availability, and capacity across multiple hosted customer environments. • Manage Oracle RAC (Real Application Clusters) and Data Guard configurations on Exadata. • Coordinate planned maintenance, failover testing, and disaster recovery activities. • Manage ASM (Automatic Storage Management) diskgroups and storage configurations on Exadata. • Conduct proactive and reactive performance analysis using AWR, ADDM, ASH, and Statspack reports. • Identify and resolve database bottlenecks related to SQL execution plans, memory allocation (SGA/PGA), I/O, and locking contention. • Tune SQL statements, indexes, and schema objects to improve application response times. • Provide written performance improvement recommendations and root cause analysis to stakeholders and customers. • Monitor and tune Exadata-specific features: Smart Scan offloading, Flash Cache, Hybrid Columnar Compression (HCC), and IORM. • Plan and execute Oracle quarterly PSU/RU patching for Standard Edition databases on Linux. • Manage full-stack patching on Exadata platform, including DB home patches, GI patches, Exadata Bundle Patches (ExaBP), and cell patches. • Coordinate patching activities through the Change Advisory Board (CAB) process, ensuring minimal customer downtime. • Test patches in lower environments prior to production rollout and maintain detailed patching runbooks. • Track Oracle patch schedules, Critical Patch Updates (CPUs), and security advisories. • Develop and maintain Shell (Bash), Python, and PL/SQL scripts to automate routine DBA tasks including health checks, space monitoring, alert log parsing, and report generation. • Build and enhance automation for patching workflows, backup verification, and performance data collection. • Integrate DBA automation scripts with CI/CD pipelines (Azure DevOps, GitHub Actions) where applicable. • Contribute to Infrastructure as Code (IaC) initiatives related to database provisioning and configuration management. • Design, implement, and maintain Oracle RMAN backup strategies for Exadata and SE environments, including full, incremental, and archived log backup policies. • Perform and validate periodic recovery tests to confirm backup integrity and meet RTO/RPO objectives. • Manage Data Pump (expdp/impdp) exports for logical backups, environment refreshes, and data migration. • Maintain backup and recovery runbooks, escalation procedures, and incident documentation. • Respond to and lead database recovery efforts during incidents, ensuring minimal data loss and rapid restoration. • Partner with application teams, infrastructure engineers, and customer success managers to resolve database-related issues. • Contribute to internal knowledge base and Confluence documentation for SOPs, runbooks, and architecture references. • Participate in on-call rotation to support production databases during off-hours incidents. • Mentor junior DBA team members and provide technical guidance on best practices.

Role Description At Fearless, we are seeking a Senior Database Administrator as part of our Senior Consultant, Engineering and Technical Services career path to provide technical leadership for enterprise database systems supporting federal law enforcement and investigative operations. This role serves as the database architect for production, development, testing, and disaster recovery environments while supporting critical data migration activities. You will manage the administration, security, optimization, and lifecycle of Microsoft SQL Server databases that enable mission-critical investigative systems serving the federal government. This role is fully remote. This Senior Consultant collaborates with cross-functional teams to align the technical vision, implementation, and quality of software systems across development, reliability, testing, and operations. This role will possess the skills to bridge business objectives with technical execution in software development, infrastructure, security, and testing at an advanced application level of proficiency. The Sr. Consultant role will work on projects that allow them to ensure scalable, secure, and reliable solutions while mentoring engineers, fostering collaboration, and aligning stakeholders with product and project goals. Responsibilities - Administer enterprise Microsoft SQL Server environments, ensuring database availability, integrity, and performance across production and non-production systems. - Design database structures and schemas that support mission-critical applications and investigative workflows. - Develop and maintain backup, recovery, and disaster recovery procedures to ensure data resilience and business continuity. - Optimize database performance through indexing strategies, query tuning, and resource monitoring. - Lead database security administration, implementing access controls, auditing mechanisms, and compliance with federal data protection standards. - Support ETL processes and coordinate data migration activities, including legacy data integration into modernized case management platforms. - Develop stored procedures, views, and database utilities that streamline data access and reporting workflows. - Coordinate database changes and deployments during production releases, ensuring minimal disruption to investigative operations. Impact - Fosters collaboration with cross-functional teams by taking the initiative and driving conversations. - Coaches, mentors, and develops peers that elevate team capability and technical expertise using clear and persuasive communication of engineering solutions to both technical and non-technical audiences. - Earns the trust of customers and teammates by delivering world-class services. - Drives accountability and delivery by ensuring project objectives are met on time and aligned with client priorities and Fearless standards of excellence. - Anticipates risks and implements proactive solutions to keep initiatives on track. - Takes ownership of risk management by monitoring deliverables across the team, identifying issues early, and coaching teammates on mitigation strategies while keeping leadership informed. - Shapes client engagement and intelligence-gathering efforts by actively cultivating relationships with stakeholders, synthesizing insights across the client organization and partner ecosystem, and providing Fearless leaders with actionable recommendations that inform strategy and strengthen delivery outcomes. Qualifications - Minimum of 7 years of experience administering Microsoft SQL Server in enterprise environments. - Bachelor's degree in Computer Science, Data Engineering, Information Systems, or related field, or equivalent work experience. - Ability to obtain and maintain Public Trust clearance. - Proven experience with SQL Server Management Studio, T-SQL, and database architecture design. - Demonstrated expertise in performance tuning, backup and recovery, and database security practices. - Experience supporting ETL processes, data migration projects, and disaster recovery planning. - Proficiency with Business Intelligence reporting tools, including Crystal Reports and Business Objects. Preferred Qualifications - Current or recent Public Trust BI clearance within the last 3 years. - Experience supporting IRS Criminal Investigations or similar federal law enforcement systems. - Familiarity with IRS Internal Revenue Manuals (IRMs) and OneSDLC processes. Skills and Competencies - Analytical Thinking: The ability to observe and interpret information, break down complex problems into parts, identify patterns/relationships and draw logical conclusions to develop effective solutions. - Synthetic Thinking: The ability to combine different ideas, information, or concepts to create a new, complex understanding or solution by integrating disparate elements into a new, meaningful whole. - Adaptability: Comfort with change, flexibility in the face of shifting demands and resilience to setbacks. - Ownership & Accountability: Committed to taking responsibility for outcomes, ensuring that all commitments are met with a focus on enhancing service delivery. - Consultative Advising: Identifies and articulates client challenges, scopes projects and aligns recommendations to business goals and client expectations. - Communicating with Influence: Capable of crafting and delivering clear, persuasive messages that integrate data insights and structured narratives, tailored to the strategic needs of diverse audiences to drive effective decision-making. - Managing Priorities & Client Alignment: Skillfully negotiates and manages conflicting priorities to strategically align decisions, enhancing service delivery and client satisfaction. Physical Requirements - Ability to sit for extended periods while working on a computer or during meetings. - Must be able to travel occasionally to client sites or company meetings, which may involve driving or flying. - Ability to communicate effectively via phone, email, and in-person, requiring clear speech, listening, and written communication skills. - Ability to move within an office environment, including reaching for files, using office equipment, and occasional light lifting (up to 10 pounds). Benefits - Flexible, life-friendly schedules. - 100% coverage for our medical HSA plan + HSA contributions. - Dental & vision covered 100% for you and your dependents. - Competitive premiums for HMO/PPO and dependent coverage. - 401(k) with 4% match & immediate vesting. - Paid Parental Leave and 12 weeks paid FMLA. - Generous PTO, 11 Federal Holidays, a Birthday Holiday, and Sick Leave. - Up to 15 days for Jury Duty and Bereavement Leave. - Education, wellness, and tech allowances. - Referral bonus: $6K–$12K for each successful referral. - Pet insurance & discount plans. - Employee Assistance Program (EAP). - Legal support, life insurance, disability coverage. - Performance-Based Bonuses.

Role Description Buscamos un administrador de bases de datos Oracle con perfil júnior para integrarse al equipo de Resolution Groups – Base de datos. El profesional dará soporte operativo a los perfiles más experimentados en la administración de instancias Oracle Database Cloud Service en OCI, participando en actividades de monitoreo, ejecución de tareas operativas y resolución de incidentes de menor complejidad. Es una excelente oportunidad para desarrollar experiencia en Oracle Cloud Infrastructure dentro de un proyecto de gran escala para el sector financiero colombiano. Responsabilidades principales - Ejecutar tareas operativas diarias: verificaciones de salud, limpieza de archivos de registro y traza, y verificación de respaldos. - Monitorear instancias Oracle Database en OCI mediante herramientas de observabilidad (Nagios, OEM, GenWizard). - Apoyar la resolución de incidentes P3/P4 bajo la supervisión de perfiles sénior. - Aplicar cambios de configuración aprobados en instancias de base de datos. - Gestionar de manera básica los espacios de tabla y el espacio en disco. - Reiniciar instancias según los procedimientos documentados. - Registrar y documentar las actividades operativas en la plataforma ServiceNow Aurora. - Participar en las actividades de transferencia de conocimiento (KT) durante la fase de movilización. - Apoyar la ejecución de parches de seguridad en ambientes no productivos. - Generar reportes del estado de la plataforma para el equipo de gobernanza. Qualifications - 1 a 2 años de experiencia como administrador de Oracle o en roles de soporte de bases de datos. - Conocimiento de Oracle Database 12c o superior (instancia, tablespace, redo logs). - Conocimiento básico de RMAN para verificación de respaldos. - Manejo de SQL y PL/SQL para consultas de diagnóstico. - Familiaridad introductoria con Oracle Cloud Infrastructure (OCI), o interés en obtener certificación. - Experiencia con herramientas de gestión de tickets (ServiceNow, Jira o similares). - Inglés técnico básico para lectura de documentación. Requirements - Actitud proactiva de aprendizaje y desarrollo técnico continuo. - Atención al detalle y disciplina en la ejecución de procedimientos operativos. - Buena comunicación y disposición para el trabajo en equipo con perfiles sénior. - Disponibilidad para participar en esquemas de guardia on-call rotativa junto a perfiles sénior. Company Description Accenture es una compañía global líder en servicios profesionales, con una amplia oferta en estrategia y consultoría, tecnología, operaciones y capacidades digitales. Acompañamos a nuestros clientes en su evolución para alcanzar su máximo rendimiento mediante soluciones innovadoras y de alto impacto.