Senior Database Administrator
About The Position
Provides advanced database administration across SQL Server, Oracle, and PostgreSQL platforms supporting grid and market systems. This 12-month contract role is a hands-on operational delivery resource responsible for complex and standard database work, escalations, and technical guidance to peers as needed. The role focuses on advanced troubleshooting, escalation handling, replication management—particularly Oracle GoldenGate—proactive monitoring and tuning through Oracle Enterprise Manager (OEM), performance optimization, and disaster recovery execution. The position collaborates with application, infrastructure, and compliance teams and coordinates operational changes within a regulated environment. The role is hybrid, with 2–3 days in the office; remote candidates will not be considered. After-hours support is required for incidents, maintenance, and recovery events as needed. Candidates must be authorized to work in the United States; visa sponsorship is not available. Candidates must pass a background check and drug screening.
Requirements
- Five to eight years of progressively responsible database administration experience in multi-platform environments involving Oracle, SQL Server, and PostgreSQL.
- Hands-on Oracle GoldenGate replication administration and proactive monitoring and tuning through Oracle Enterprise Manager (OEM).
- Experience with advanced troubleshooting, high availability and disaster recovery, backup and recovery, performance tuning, and patching coordination in a production environment supporting business-critical applications.
- Proficiency with scripting and automation, including Python and shell scripting.
- Bachelor's degree in Computer Science, Information Technology, Information Systems, or a related field, or an equivalent combination of education and experience.
- Authorization to work in the United States.
- Ability to pass a background check and drug screening.
Nice To Haves
- Experience in an environment regulated by NERC CIP or SOC is strongly preferred.
- Experience with configuration-management and infrastructure-as-code tools such as Ansible and Terraform is a plus.
- Familiarity with the ServiceNow IT service management platform is a plus.
- Oracle Certified Professional – Database Administrator certification.
- Oracle GoldenGate certification or demonstrated equivalent experience.
- Microsoft Certified: Azure Database Administrator Associate certification.
- PostgreSQL certification, such as EDB PostgreSQL Associate/Professional, or demonstrated equivalent experience.
- HashiCorp Terraform Associate or equivalent infrastructure-as-code certification.
Responsibilities
- Troubleshoot and resolve database outages, performance degradation, replication failures, backup exceptions, and availability events across SQL Server, Oracle, and PostgreSQL.
- Administer Oracle GoldenGate replication, including heterogeneous configurations across Oracle, SQL Server, and PostgreSQL; monitor extracts and replicats; analyze lag; handle conflicts and trails; and support switchovers.
- Support high-availability and disaster-recovery configurations, including Oracle Data Guard, SQL Server Always On Availability Groups, and PostgreSQL streaming replication and high-availability clustering; prepare for, execute, and validate failovers.
- Monitor, analyze, and tune databases using Oracle Enterprise Manager, Oracle Automatic Workload Repository, Active Session History, SQL Server Management Studio, and PostgreSQL monitoring tools; address query performance, resource contention, and capacity constraints.
- Execute database backup, recovery, and disaster recovery activities using Rubrik Cloud Data Management and native backup utilities, ensuring defined RPO and RTO targets are met and recovery procedures are tested and validated on schedule.
- Plan and execute database patching, security updates, and version upgrades through ServiceNow change management, including risk assessment, testing coordination, rollback planning, and post-change validation.
- Coordinate schema changes with application development teams, including index optimization, deployment sequencing, and environment refreshes supporting application release cycles.
- Support database access reviews, least-privilege enforcement, and compliance evidence collection for NERC CIP and SOC audit requirements; provide database-service expertise for compliance assessments.
- Develop automation using Ansible, Python, shell scripting, PowerShell, PL/SQL, and Transact-SQL, and contribute to infrastructure-as-code practices using Terraform and Git where applicable.
- Perform assigned database tasks during monthly data center site switchover exercises, coordinating failover execution, replication validation, and post-switchover verification.
- Maintain and improve knowledge articles, runbooks, operational standards, and support documentation.
- Manage incidents, service requests, and change records in ServiceNow; coordinate vendor support tickets with Oracle, Microsoft, and PostgreSQL support channels through resolution.
- Contribute to capacity planning and lifecycle management by analyzing database growth, storage utilization, and platform lifecycle timelines.
- Participate in incident post-mortem reviews and contribute to root cause analysis and corrective action planning.
- Provide cross-training to team members and operational partners.
Benefits
- Medical coverage through Florida Blue.
- Dental coverage through Florida Blue.
- Vision coverage through Florida Blue.
- Short- and long-term disability coverage.
- Employer-paid life insurance.
- Participation in the MWResource 401K plan for US-based consultants.
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Senior
