[Remote] Senior Oracle Database Administrator
Note: The job is a remote job and is open to candidates in USA. Ardent Eagle Solutions is seeking a Senior Oracle Database Administrator to support the NICHD Office of OIT in planning and technical support for IT application and website development. The role involves administering enterprise Oracle database environments, managing both cloud and on-premises databases, and ensuring high availability and security of critical applications.
Responsibilities
- Administer, maintain, and optimize enterprise Oracle database environments supporting mission-critical federal applications in development, test, and production
- Manage Oracle databases hosted in Microsoft Azure cloud and on-premises Linux environments, including standalone and multitenant architectures
- Perform database installation, configuration, upgrades, patching, security updates, and technology refreshes to maintain secure and reliable environments
- Implement and maintain high availability and disaster recovery solutions using Oracle Data Guard, Oracle GoldenGate, RMAN, and other enterprise technologies
- Monitor database performance, troubleshoot complex issues, and perform performance tuning to ensure optimal availability, scalability, and reliability
- Develop and execute backup and recovery strategies utilizing RMAN, Oracle Data Pump (Export/Import), Cohesity, Azure Blob Storage, and other enterprise backup solutions
- Manage database security by administering user accounts, roles, privileges, encryption, and access controls in accordance with federal cybersecurity requirements
- Support enterprise data integration by developing and maintaining database interfaces, web service connections, and data synchronization between Oracle and external systems
- Design, develop, and optimize SQL, PL/SQL, stored procedures, views, triggers, and database objects to support enterprise applications and reporting
- Collaborate with application development, infrastructure, cybersecurity, and cloud engineering teams to support production releases, database deployments, and system integrations
- Support Oracle Enterprise Manager (OEM) for database monitoring, job scheduling, automation, and performance management
- Execute database schema modifications, data migrations, DDL and DML activities, and environment refreshes to support development and production operations
- Develop and maintain enterprise data marts and database views to support business intelligence, analytics, and reporting solutions, including Power BI and Qlik Sense
- Retrieve, integrate, and manage data from enterprise data warehouses and external federal systems to support reporting and business operations
- Monitor daily database health, replication, scheduled jobs, and automated data loads to ensure data integrity and system availability
- Evaluate emerging database technologies and recommend enhancements that improve performance, security, scalability, and operational efficiency
- Develop, maintain, and update Standard Operating Procedures (SOPs), technical documentation, installation guides, and operational runbooks following federal lifecycle management standards
- Support application teams by providing database troubleshooting, production release support, test environment refreshes, and database recovery services
- Ensure compliance with federal security, privacy, and data protection requirements, including encryption of sensitive data at rest and in transit
- Participate in capacity planning, database architecture reviews, and long-term infrastructure planning to support future business needs
- Mentor junior database administrators and provide technical leadership, best practices, and knowledge sharing across the database administration team
Skills
- More than 10 years of experience in conducting Oracle database administration
- Extensive experience in administering Oracle database in standalone and multitenant architecture on Windows/Linux/Unix on premises and in cloud environments
- Extensive experience in Oracle data guard implementation, RMAN backups, export/import, GoldenGate setup and configuration, and job scheduling and monitoring
- Strong SQL and PL/SQL, performance tuning, and troubleshooting skills
- Experience with Oracle client
- Requires BS/BA degree in related field (or equivalent)
- Experiences with Oracle version 19c, Oracle on Linux, and MySQL on Ubuntu are preferred
Benefits
- Medical/Dental/Vision Coverage
- Matching 401(k) Plan
- Continuing Education Assistance
- Paid Time Off
- Free parking is available for the night shift Operations Watch Officers
Company Overview