AWS Database Administrator - Oracle and MongoDB

SAIC•Ashburn, VA

3d•Hybrid

About The Position

SAIC is seeking a highly skilled and experienced mid-level Database Administrator (DBA) to join our team. The ideal candidate will have a strong background in managing and optimizing both Oracle and NoSQL databases. Project teams utilize Oracle RDS and AWS managed databases including Postgres and DocumentDB, and MongoDB, also hosted in AWS. This role requires a thorough understanding of the advantages of NoSQL databases such as the scalability, flexibility, and performance gains and the disadvantages compared to relational databases. The ideal candidate will also have hands-on experience with failover and recovery, backups, migration of on-premises databases to AWS, and proficiency with AWS services. The successful candidate should be passionate about ensuring database performance, availability, and security, and experienced in debugging complex challenges and handling data warehouses. This position is hybrid-remote and requires 2 days on-site in Ashburn, VA. Must be local or willing to relocate.

Requirements

Ability to handle Oracle Prod issues after hours and carry the Oracle Duty Phone on a rotational basis.
Solid NoSQL (preferably MongoDB) skills.
Experience of migrating databases (+Terabytes) from on-prem to cloud and hands-on production experience is a must.
Bachelor’s degree in Computer Science, Information Technology, or related field and at least 5 years of relevant experience.
Proven experience as a DBA with expertise in Oracle (new versions) and NoSQL databases (MongoDB).
Experience with AWS DocumentDB database services.
Experience with relational database management system, PostgreSQL/Postgres.
Solid experience in database failover, recovery procedures, and disaster recovery planning.
Demonstrated experience with migrating on-premises databases to AWS.
Proficient 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 US Citizen.

Nice To Haves

AWS or relevant database certifications (e.g., Oracle Certified Professional, AWS Associate Architect).
Experience with scripting languages (e.g., Python, Bash) for automation of database tasks.
Deep familiarity with database monitoring tools, especially AWS CloudWatch, for performance monitoring and alerting.
Experience with large enterprise database design, implementation, and optimization, for example, Oracle RDS on Exadata.
Experience with Oracle Real Application Clusters (RAC).
Experience with Big Query is a plus.
Demonstrated ability to think critically and creatively to develop innovative solutions to software problems.
High level of self-motivation, desire to deliver stellar solutions and willingness to work in a distributed team environment.
Master’s degree (or higher) in computer science or related field is a plus.

Responsibilities

Administer, maintain, and implement permissions, policies and procedures for ensuring the secure connectivity and integrity of databases.
Monitor database performance, implement changes and apply new patches and versions when required to ensure optimal performance. Work closely with the application teams to optimize the application interaction with NoSQL.
Design and execute database backup and recovery strategies, including failover planning and testing.
Lead migration projects from on-premises databases to AWS, relational databases to NoSQL, including planning, execution, and validation of database migrations and upgrades.
Ensure database security measures are in place, including access controls and audit logging. Comply with all applicable data privacy laws and regulations.
Manage and optimize AWS Redshift instances and other data warehousing solutions for scalable and efficient data storage and analysis.
Utilize AWS CloudWatch and other monitoring tools to ensure database health, performance, and to automate scaling and notifications.
Provide support for complex database issues, including troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues, replication issues, log shipping issues, etc.