Cloud Database Administrator Senior

SAIC•Ashburn, VA

4d•Hybrid

About The Position

SAIC is seeking an experienced mid-level Database Administrator to manage and optimize Oracle and NoSQL databases. The project uses Oracle RDS and AWS-managed databases, including PostgreSQL, DocumentDB, and MongoDB. The role calls for understanding the benefits and tradeoffs of NoSQL compared with relational databases, as well as differences between Oracle Exadata and Aurora PostgreSQL RDS. The administrator will work on database performance, availability, and security; complex query debugging; backups and recovery; and migrations from on-premises environments to AWS. The role also supports Oracle production issues and includes carrying the Oracle duty phone on a rotating basis. The position is hybrid, with on-site visits in Ashburn, Virginia, one day per week and when mission needs require. An on-call schedule may require travel to a datacenter site. Applicants must be U.S. citizens and able to obtain and hold a public trust position, subject to favorable suitability based on a CBP Background Investigation.

Requirements

Bachelor’s degree in Computer Science, Information Technology, or a related field and at least 5 years of relevant experience; additional years of experience may substitute for the degree.
Proven DBA experience with Oracle and NoSQL databases, including MongoDB.
Extensive experience with AWS DocumentDB or MongoDB database services.
Solid experience with database failover, recovery procedures, and disaster recovery planning.
Programming experience and ability to maintain, enhance, and develop tools; experience with languages such as C++, PL/SQL, Python, and Java.
Demonstrated experience migrating on-premises databases to AWS.
Proficiency in MongoDB Query Language (MQL), database design, and data modeling.
Familiarity with AWS CLI, SDKs, and CloudWatch.
Excellent verbal and written communication skills.
Must be a U.S. citizen.
Must be able to obtain and hold a public trust position and receive favorable suitability based on a CBP Background Investigation.

Nice To Haves

AWS or relevant database certifications, such as Oracle Certified Professional or AWS Associate Architect.
Experience with scripting languages such as Python or Bash for database task automation.
Deep familiarity with database monitoring tools, especially AWS CloudWatch, for performance monitoring and alerting.
Experience with large enterprise database design, implementation, and optimization, such as Oracle RDS on Exadata.
Experience with Oracle Real Application Clusters (RAC).
Experience with BigQuery.
Master’s degree or higher in computer science or a related field.

Responsibilities

Administer, maintain, and implement database permissions, policies, and procedures to ensure secure connectivity and database integrity.
Monitor database performance, make changes, and apply patches and version updates to maintain optimal performance.
Work with application teams to optimize application interactions with NoSQL databases.
Design and execute database backup and recovery strategies, including failover planning and testing.
Lead database migration and upgrade projects, including migrations from on-premises databases to AWS and from relational databases to NoSQL; plan, execute, and validate migrations.
Maintain, enhance, and develop custom performance, monitoring, and security tools.
Ensure database security measures, including access controls and audit logging, and comply with applicable data privacy laws and regulations.
Manage and optimize AWS Redshift instances and other data warehousing solutions.
Use AWS CloudWatch and other monitoring tools to monitor database health and performance and automate scaling and notifications.
Troubleshoot and resolve complex database issues, including integrity, performance, blocking and deadlocking, replication, and log shipping issues.
Handle Oracle production issues and carry the Oracle duty phone on a rotational basis.