Oracle Database Administrator, Level 3

JOB DESCRIPTION:

As an Oracle Database Administrator (DBA) you will provide expert database administration support to our customer within the DMV area. You will be responsible for managing and optimizing Oracle databases in high-security environments, including Sensitive Compartmented Information Facilities (SCIFs).

The Oracle DBA will play a critical role in maintaining the availability, integrity, and security of highly sensitive production databases, ensuring they operate efficiently and securely in support of the customer's mission. Responsibilities include installing, configuring, and optimizing Oracle database systems, managing complex backup and recovery operations, and implementing high availability and disaster recovery solutions. You will will collaborate closely with development, business, and operations teams to address performance issues, apply Oracle database STIGs, and ensure the overall security and compliance of database environments. Additionally, the role will involve troubleshooting complex technical issues, including resolving database performance bottlenecks and database errors, as well as overseeing routine database maintenance and patching processes. You will be relied upon to apply industry-leading best practices and security standards to safeguard the integrity of critical data, maintain the highest levels of database performance, and provide recommendations for improving system architecture and scalability.

Job Duties include:

Database Administration & Management

• • Install, configure, provision, operate, and administer Oracle database management systems (DBMS) and associated backend server hardware.
  • Perform daily database administration tasks, including patching, troubleshooting, backups, and ensuring high data availability.
  • Monitor, maintain, and performance-tune production databases to meet business requirements for availability, scalability, and reliability.
  • Ensure database integrity, availability, and security, particularly in a high-security environment (SCIF).
  • Apply database STIGs (Security Technical Implementation Guides) and adhere to security best practices to ensure database compliance.
  • Implement and manage backup and disaster recovery strategies for Oracle database environments.
  • Upgrade major database instances independently and ensure all patches and updates are applied to minimize vulnerabilities and downtime.

Technical Support & Performance Tuning

• • Troubleshoot and resolve database performance issues, ensuring minimal downtime and optimal database performance.
  • Conduct performance tuning for databases, including queries, indexes, stored procedures, and hardware resources.
  • Provide support for database-related infrastructure, including backend storage, hardware platforms, and network configurations.
  • Design and implement database schema, tables, and indexes for new applications or enhancements.
  • Perform capacity planning and utilization monitoring for databases, ensuring scalability for future needs.
  • Support development teams in writing and optimizing SQL and PL/SQL queries, as well as generating system data reports.

Collaboration & Documentation

• • Collaborate with development, business, and operations teams to ensure that database systems align with organizational and mission needs.
  • Document database configurations, procedures, and troubleshooting steps, creating standard operating procedures (SOPs).
  • Participate in team meetings, reviewing database performance and availability issues, and providing solutions for improvement.
  • Assist in the development and improvement of database-related policies and procedures, ensuring consistency and operational efficiency.

Security & Compliance

• • Ensure compliance with database security requirements, including auditing, access control, and encryption standards.
  • Ensure timely patching and resolution of security vulnerabilities within the database systems.
  • Work with the information security team to review and apply database security policies and standards.

Additional Duties

• • Participate in on-call support rotation for after-hours database troubleshooting and performance issues.
  • Stay up-to-date with Oracle DBMS enhancements, industry best practices, and relevant technologies like cloud services and virtualization (e.g., AWS, VMware).
  • Assist in the migration of database environments to the cloud (AWS, Oracle Cloud) when applicable.
  • Provide technical guidance and mentorship to junior DBA staff or team members.