- Hybrid (3 days onsite: Tuesday, Wednesday, Thursday; 2 days remote: Monday, Friday).
- Location: Baltimore, MD highly preferred (secondary location: Chicago & third preferred: Philadelphia)
Overview:
Work with a leading energy and utility organization managing critical electric and gas infrastructure. We are seeking a Mid-Level Database Administrator to join our Tier 2 Operations team. This team provides high-impact, enterprise-level support across hundreds of production databases. You will collaborate with onshore and offshore teams to ensure optimal database performance, robust monitoring, and seamless data replication.
Primary Team Objective: Serving as a high-level tier-2 operational resource capable of executing advanced data replication and managing complex corporate database frameworks.
Key Responsibilities
- Monitor, maintain, and support hundreds of enterprise Oracle databases across on-premises and Oracle Cloud Infrastructure (OCI) environments.
- Support critical utility infrastructure within a highly secure environment subject to NERC SIP compliance standards.
- Participate in a Tier 2 on-call weekly rotation, serving as an escalation point for the offshore Tier 1 team, with a strict 15-minute response window for critical incidents.
- Drive the reduction of Mean Time to Resolution (MTTR) by diagnosing complex database alerts and executing immediate resolutions.
- Support environment backups and perform critical data restores to ensure operational functionality and data reliability.
- Assist the primary administrator in managing, configuring, and expanding Oracle Enterprise Manager (OEM) to monitor database infrastructure.
- Write custom administrative scripts and programs to automate operational tasks and improve environmental efficiency.
- Manage data replication and data shipping across distinct platforms using Oracle Golden Gate.
- Administer complex database clusters utilizing Oracle RAC and Oracle Exadata systems.
- Provide technical Oracle database and GoldenGate expertise and support for maintaining performance and reliability of enterprise database solutions.
- Undertake database projects requiring specialized technical knowledge.
- Makes well-thought-out decisions on moderately complex or ambiguous database issues and effectively develops, presents and implements .
- Collaborate efficiently and proactively within team and with other teams to improve reliability, optimize costs, enforce standards and compliance, and support requests from customers.
- Participate in on-call rotation, effectively troubleshoot issues to prevent and resolve incidents.
Required Qualifications
- Bachelores Degree in IT, Computer Science or related field.
- Minimum of 5+ years of hands-on database administration experience.
- Hands-on experience utilizing Oracle Enterprise Manager (OEM).
- Must possess extensive experience with Oracle Golden Gate for data replication and shipping data between distinct databases.
- Requires deep technical experience with Oracle Real Application Clusters (RAC) and Oracle Exadata platforms.
- Must have proven experience managing database architectures across both on-premises environments and Oracle Cloud Infrastructure (OCI).
- Expected to have strong SQL querying capabilities standard for an enterprise-level DBA.
- Responsible for high-level troubleshooting, database performance tuning, and optimizing infrastructure backups/restores.
- Must possess enterprise-scale environment experience (handling hundreds of databases for large companies) rather than small-scale environments.
- Must have enterprise experience supporting, building, documenting, monitoring and maintaining Oracle databases and GoldenGate, performance analysis and capacity planning.
- Experience working with Unix type operating systems, shell scripting and of course be strong with writing, troubleshooting and optimizing SQL queries.
Preferred Qualifications
- Official Oracle Database Administrator certifications are highly preferred.
- Prior experience working within a heavily regulated ecosystem, such as a Fortune 500 financial institution or a major utility provider.
- Direct experience writing automated tasks to optimize database backup and recovery infrastructure.