Job Title: Senior Oracle Database Administrator (Sr. Oracle DBA)
Company: Arch Systems
Client: U.S. Federal Government
Location: Remote
Employment Type: Full-Time
Position Summary
Arch Systems is seeking an experienced Senior Oracle Database Administrator (Sr. Oracle DBA) to support a U.S. Federal Government client. The ideal candidate will have strong hands-on expertise in Oracle database administration, architecture, performance tuning, security, reliability, and modernization.
In this role, you will lead database administration activities across production, test, and development environments, ensuring optimal database performance, availability, security, and compliance with federal information security requirements. You will collaborate with application developers, ETL teams, systems administrators, and other technical stakeholders to support data integration, resolve complex database issues, and continuously improve database operations.
Key Responsibilities
Lead Oracle database administration, architecture, configuration, and maintenance across production, test, and development environments.
Monitor, analyze, and optimize Oracle database performance, including advanced SQL queries, PL/SQL procedures, and database workloads.
Perform database and server performance tuning, capacity planning, resource utilization analysis, and troubleshooting.
Manage database backups, recovery procedures, patching, upgrades, and routine maintenance to ensure reliability and availability.
Administer database users, roles, permissions, authentication, and access controls in accordance with security policies.
Review and recommend improvements to database schemas, data models, structures, and indexing strategies.
Support ETL processes, data loading, and data integration activities by identifying and resolving database performance bottlenecks.
Troubleshoot complex database issues, support incident response, and coordinate resolution of critical production problems.
Maintain database configuration records, operational procedures, technical documentation, and security-related artifacts.
Support federal security and compliance activities, including FISMA-related documentation, NIST security controls, Authority to Operate (ATO) documentation, and Plans of Action and Milestones (POA&Ms), as applicable.
Collaborate with application development, graph database, ETL, and systems administration teams to ensure reliable end-to-end system performance.
Provide technical guidance to junior database administrators and recommend database modernization, optimization, and process improvements.
Required Qualifications
Minimum of 3 years of relevant Oracle database administration experience, with demonstrated senior-level technical leadership capabilities.
Strong hands-on experience administering and supporting Oracle Database 11g, 12c, or later versions.
Advanced knowledge of SQL and PL/SQL, including query optimization, stored procedures, and performance troubleshooting.
Experience with database architecture, data modeling, indexing, and database structure optimization.
Experience managing database backup, recovery, patching, maintenance, user administration, and security controls.
Working knowledge of Red Hat Enterprise Linux (RHEL) or other Linux environments.
Experience supporting ETL processes, data warehousing, and database-related data integration activities.
Ability to troubleshoot complex technical issues, analyze database performance, and recommend effective solutions.
Strong documentation, analytical, communication, and cross-functional collaboration skills.
Federal Security and Compliance Requirements
Ability to successfully complete the required federal background investigation and obtain the necessary staff-like access.
Ability to meet applicable HSPD-12 and Personal Identity Verification (PIV) requirements.
Familiarity with federal information security and privacy requirements, including FISMA, NIST SP 800-53, and IRS Publication 1075.
Understanding of security controls for Sensitive But Unclassified (SBU) information, Personally Identifiable Information (PII), and Federal Tax Information (FTI).
Ability to support applicable Authority to Operate (ATO) and Plans of Action and Milestones (POA&M) activities.
Preferred Qualifications
Experience supporting federal government database environments.
Experience working in security-sensitive environments with strict data protection and access control requirements.
Familiarity with graph databases and integration with application, ETL, and data processing platforms.
Experience with database modernization, operational improvement, and performance optimization initiatives.
Education and Certifications
Relevant education or equivalent professional experience in Computer Science, Information Technology, Database Administration, or a related field is preferred.
No specific professional certification is mandated for this position.