Senior Database Administrator, Oracle, PostgreSQL, AWS

This is a fully remote position, open to applicants in United States.

📋 Description

• Oversee production Oracle environments and AWS-managed databases, including PostgreSQL and MySQL.

• Install, configure, patch, upgrade, administer, and troubleshoot Oracle 19c and later versions across development, test, and production settings.

• Manage and enhance Amazon RDS for Oracle, PostgreSQL, and MySQL, as well as Oracle on Amazon EC2 where applicable.

• Establish database permissions, policies, standards, and procedures ensuring secure connectivity, availability, and data integrity.

• Plan and implement migrations from on-premise data centers to AWS, encompassing runbooks, cutover and rollback strategies, data validation, and post-migration confirmation.

• Facilitate Oracle-to-Oracle and Oracle-to-PostgreSQL/open-source modernization efforts.

• Optimize database and SQL performance using AWR, ASH, execution plans, indexing, memory and storage configuration, along with PostgreSQL/MySQL performance tools.

• Design and uphold backup, recovery, high availability, and failover strategies utilizing RMAN, Data Guard, RAC, ASM, Multi-AZ, snapshots, automated backups, and replication.

• Conduct regular disaster recovery testing.

• Secure databases in accordance with NIST SP 800-53 controls and DISA STIGs, which includes account and role management, auditing, logging, encryption, and Oracle TDE.

• Assist with ATO, vulnerability remediation, and compliance initiatives.

• Monitor database health, capacity, availability, replication, storage, backups, and performance using Oracle Enterprise Manager, AWS CloudWatch, and other enterprise monitoring solutions.

• Address incidents and spearhead root cause analysis.

• Manage and optimize Amazon Redshift along with other supported data warehouse solutions.

• Automate administration, operational checks, and maintenance using Bash, Python, SQL, and PL/SQL.

• Provide support to application teams with schema modifications, releases, data fixes, query optimization, and production troubleshooting through change-control procedures.

• Generate technical documentation, architecture details, migration and recovery runbooks, operating procedures, and system security plan inputs.

• Collaborate with platform engineers, application teams, data teams, and cybersecurity personnel.

⛳️ Requirements

• U.S. citizenship is required.

• Must be able to obtain and maintain a CBP Public Trust background investigation.

• A minimum of eight (8) years of database administration experience supporting production systems.

• Extensive hands-on experience as an Oracle DBA.

• Practical knowledge of Oracle 19c, RAC, Data Guard, RMAN, and ASM.

• Strong experience in PostgreSQL administration.

• Familiarity with MySQL in production or AWS-managed environments.

• Demonstrated experience in database and SQL performance tuning, including Oracle AWR/ASH analysis and query/index optimization.

• Experience with Amazon RDS and the migration of databases between on-premise and cloud environments.

• Profound understanding of database backup, recovery, failover, disaster recovery, security, and high availability.

• Practical knowledge of Linux/Unix administration and shell scripting.

• Experience in database automation using Bash, Python, SQL, or PL/SQL.

• Background in troubleshooting complex production issues across databases, applications, operating systems, storage, networking, and cloud services.

• Ability to work remotely on East Coast hours and travel approximately once per quarter.

• A bachelor's degree in a related field is preferred; relevant experience may substitute for a degree.

• Oracle Certified Professional (OCP) and AWS certification are beneficial.

• Experience with Amazon RDS for Oracle, PostgreSQL, and MySQL; Oracle on Amazon EC2; AWS Database Migration Service; or Oracle GoldenGate is desirable.

• Experience migrating Oracle workloads to PostgreSQL or other open-source databases is desirable.

• Experience with Amazon Redshift, enterprise data warehouses, and large-scale data integration or analytics workloads is desirable.

• Familiarity with AWS CloudWatch and enterprise database monitoring and alerting platforms is desirable.

• Experience with NoSQL databases and optimizing application/data-access patterns across relational and NoSQL platforms is desirable.

• Experience supporting DHS or CBP systems, or other federal agencies under an ATO, is desirable.

• A current DHS Public Trust is preferred.

🏝️ Benefits

• Flexible remote work arrangement.

• Travel approximately once per quarter.

• Immediate start following a favorable suitability determination and customer onboarding.

• Exposure to AWS, Azure, and Google Cloud projects.

• Work on a four-year U.S. Customs and Border Protection program.

• Opportunities for professional development through mission-critical cloud modernization, security, compliance, DevOps, and data analytics initiatives.