Mastech Digital

Mastech Digital delivers IT staffing services and digital transformation services for companies across the United States and beyond. The specialist staffing com

Database Developer - Extract, Transform, and Load

Location

Rhode Island

Posted

17 days ago

Salary

$0 / year

Seniority

Senior

Bachelor Degree

Job Description

Database Developer - Extract, Transform, and Load

Mastech Digital

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.

Related Categories

Related Job Pages

More Database Administrator Jobs

AssetWorks Inc logo

Senior Oracle Database Administrator

AssetWorks Inc

We provide innovative and practical solutions to help our customers, and the people they serve, thrive.

Full TimeRemoteTeam 5,001-10,000H1B Sponsor

• 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.

Pennsylvania

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.

United States
$120.6K - $196.0K / year
Accenture logo

Database Administrator - DBAs (Oracle)

Accenture

Accenture is a leading global professional services company that helps the world’s leading businesses, governments and other organizations build their digital core, optimize their operations, accelerate revenue growth and enhance citizen services—creating tangible value at speed and scale. We are a talent- and innovation-led company with approximately 791,000 people serving clients in more than 120 countries. Technology is at the core of change today, and we are one of the world’s leaders in helping drive that change, with strong ecosystem relationships. We combine our strength in technology and leadership in cloud, data and AI with unmatched industry experience, functional expertise and global delivery capability. Our broad range of services, solutions and assets across Strategy & Consulting, Technology, Operations, Industry X and Song, together with our culture of shared success and commitment to creating 360° value, enable us to help our clients reinvent and build trusted, lasting relationships. We measure our success by the 360° value we create for our clients, each other, our shareholders, partners and communities. Visit us at www.accenture.com Equal Employment Opportunity Statement: We believe that no one should be discriminated against because of their differences. All employment decisions shall be made without regard to age, race, creed, color, religion, sex, national origin, ancestry, disability status, military veteran status, sexual orientation, gender identity or expression, genetic information, marital status, citizenship status or any other basis as protected by applicable law. Our rich diversity makes us more innovative, more competitive, and more creative, which helps us better serve our clients and our communities.

Full TimeRemoteTeam 10,001+H1B Sponsor

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.

Colombia
Microchip Technology Inc. logo

Principal Database Administrator

Microchip Technology Inc.

Microchip Technology Inc. is a leading semiconductor supplier of smart, connected and secure embedded control solutions.

Full TimeRemoteTeam 10,001+Since 1989H1B No Sponsor

Role Description The Principal Database Administrator – Oracle is responsible for the architecture, reliability, performance, security, and lifecycle management of enterprise Oracle database platforms. This role serves as the senior technical authority for Oracle database operations, high availability, disaster recovery, patching, upgrades, automation, standards, and production support. The Principal DBA will lead complex database initiatives, guide other DBAs, establish best practices, and work closely with infrastructure, application, security, and data platform teams to ensure Oracle environments are stable, scalable, secure, and aligned with business requirements. Responsibilities - Administer and support Oracle databases across production, DR, test, and development environments. - Install, configure, patch, upgrade, clone, refresh, and maintain Oracle database environments. - Manage Oracle 11g, 12c, 19c, and newer versions, including single-instance and CDB/PDB environments. - Support Oracle Data Guard, including standby databases, redo transport, apply lag, switchover, failover, and recovery. - Develop and maintain backup and recovery strategies using RMAN and related enterprise backup tools. - Monitor and tune database performance using AWR, ASH, SQL Monitor, execution plans, wait events, and Oracle dynamic performance views. - Troubleshoot production issues related to availability, performance, storage, backup failures, locking, replication, and connectivity. - Manage database security, users, roles, privileges, auditing, encryption, and compliance-related controls. - Create and maintain automation scripts for routine DBA tasks, health checks, monitoring, refreshes, and maintenance. - Define and enforce database standards, operational procedures, documentation, and runbooks. - Lead database projects including migrations, upgrades, DR testing, monitoring improvements, and platform modernization. - Provide technical leadership, mentoring, and escalation support to other DBAs and technical teams. - Participate in change management, incident response, root cause analysis, and on-call support. Qualifications - 10+ years of hands-on Oracle Database Administration experience in enterprise production environments. - Strong experience with Oracle 11g, 12c, and 19c. - Strong knowledge of Oracle architecture, backup/recovery, performance tuning, security, and operational best practices. - Hands-on experience with RMAN backup and recovery. - Hands-on experience with Oracle Data Guard administration and troubleshooting. - Strong SQL and PL/SQL troubleshooting skills. - Experience with Oracle patching, upgrades, OPatch, datapatch, and release/update planning. - Experience tuning Oracle databases using AWR, ASH, ADDM, SQL Monitor, execution plans, and wait events. - Experience supporting large, business-critical databases with formal change control and incident management. - Strong Linux/Unix skills, including shell scripting and system-level troubleshooting. - Ability to write clear technical documentation, runbooks, standards, and root cause analysis reports. - Strong communication skills and ability to work with application, infrastructure, security, and business teams. Preferred Qualifications - Oracle certification or equivalent demonstrated expertise. - Experience with Oracle ASM and Grid Infrastructure. - Experience with Oracle RAC, SEHA, or other high availability architectures. - Experience with Oracle Multitenant, including CDB/PDB administration. - Experience with Oracle Enterprise Edition features such as Diagnostics Pack, Tuning Pack, Partitioning, Advanced Security, or Advanced Compression. - Experience with VMware, enterprise storage, or clustered infrastructure. - Experience with database replication or CDC tools such as Qlik Replicate, GoldenGate, Debezium, or similar platforms. - Experience with monitoring tools such as OEM, Prometheus, Grafana, Splunk, Datadog, or similar tools. - Experience with automation and CI/CD tools such as Ansible, Git, Azure DevOps, Jenkins, or Terraform. - Experience with PostgreSQL, SQL Server, MySQL, or other database platforms is a plus. - Familiarity with Oracle licensing considerations and database platform modernization. Travel Time - 0% - 25% To all recruitment agencies Microchip Technology Inc. does not accept unsolicited agency resumes. Please do not forward resumes to our recruiting team or other Microchip employees. Microchip is not responsible for any fees related to unsolicited resumes.

Malaysia
Job Closed