Cloud Database Administrator Senior

SAIC•Ashburn, VA

5d•Hybrid

About The Position

SAIC is seeking a skilled, experienced mid-level Database Administrator to manage and optimize Oracle and NoSQL databases. Project teams use Oracle RDS and AWS-managed databases, including PostgreSQL, DocumentDB, and MongoDB. The role calls for an understanding of NoSQL’s advantages and disadvantages relative to relational databases, as well as differences between Oracle Exadata and Aurora PostgreSQL RDS. The administrator will work with failover and recovery, backups, migrations of on-premises databases to AWS, and AWS services, with a focus on database performance, availability, security, and troubleshooting complex queries and issues across large databases. The position administers database permissions, policies, and procedures; monitors and tunes performance; plans and tests backup, recovery, and failover; and leads database migrations and upgrades. It also involves maintaining and developing performance, monitoring, and security tools, supporting compliance and data privacy requirements, managing AWS Redshift and other data warehousing solutions, and using AWS CloudWatch and other tools to monitor database health and automate scaling and notifications. The role supports complex integrity, performance, blocking, deadlocking, replication, and log-shipping issues. The candidate must be able to handle Oracle production issues and carry the Oracle duty phone on a rotational basis. The position is hybrid, with on-site visits in Ashburn, Virginia, one day per week and as mission needs require. An on-call schedule may require travel to a datacenter. Candidates must be U.S. citizens and able to obtain and hold a public trust position with 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 and expertise 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.
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.
Ability to obtain and hold a public trust position and favorable suitability based on a CBP Background Investigation.
Must be a U.S. citizen.

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 Big Query.
Master’s degree or higher in computer science or a related field.

Responsibilities

Administer, maintain, and implement permissions, policies, and procedures to ensure secure database connectivity and integrity.
Monitor database performance, implement changes, and apply patches and versions to maintain optimal performance.
Work with application teams to optimize application interaction with NoSQL databases.
Design and execute database backup and recovery strategies, including failover planning and testing.
Lead migrations from on-premises databases to AWS and from relational databases to NoSQL, including planning, execution, and validation of migrations and upgrades.
Maintain and enhance custom performance, monitoring, and security tools, and develop new tools using languages such as C++, PL/SQL, Python, and Java.
Ensure database security, 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 ensure database health and performance and automate scaling and notifications.
Troubleshoot and resolve complex database integrity, performance, blocking, deadlocking, replication, and log-shipping issues.
Handle Oracle production issues and carry the Oracle duty phone on a rotational basis.