Cloud Database Administrator Senior

SAIC; Ashburn (VA); Híbrido; USD 110.000 - 140.000; Jornada completa

Descripción de la vacante

SAIC is seeking a mid-level Database Administrator to manage Oracle and NoSQL databases, including DocumentDB and MongoDB, on AWS. Responsibilities include performance tuning, failover planning, and migrations from on-prem to AWS, with emphasis on security and data integrity. Proficiency in C++, Python, and Java is beneficial.

Hybrid work with Ashburn visits is expected. The role requires strong problem-solving skills, experience with AWS services, and the ability to support large databases and

Formación

• Bachelor's degree in CS/IT or related field with 5+ years of relevant experience.
• Experience as a DBA with Oracle and NoSQL databases (MongoDB).
• Extensive experience with AWS DocumentDB or MongoDB services.
• Strong in migration from on-prem to AWS and in designing backup/recovery strategies.
• Proficient in MongoDB Query Language (MQL) and data modeling.
• Experience with AWS CLI, SDKs, and CloudWatch.

Responsabilidades

• Administer, maintain, and enforce permissions and policies for secure DB connectivity and integrity.
• Monitor performance and optimize interactions with NoSQL databases.
• Design and test backup and recovery strategies, including failover planning.
• Lead migrations from on-prem to AWS and upgrades to NoSQL/relational databases.
• Develop and enhance monitoring and security tooling for databases.

Conocimientos

Oracle DBA

NoSQL databases

AWS Cloud

Python

SQL/PLSQL

Java

Educación

Bachelor's degree in Computer Science/Information Technology

Herramientas

MongoDB

DocumentDB

AWS Redshift

AWS CloudWatch

Oracle RDS

Postgres

Descripción del empleo

SAIC is seeking a 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. This role requires a thorough understanding of the advantages of NoSQL databases such as the scalability, flexibility, and performance gains, the disadvantages compared to relational databases, and the significant differences between Oracle Exadata and Aurora Postgres RDS. 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 queries, challenges and handling large databases.

Job Responsibilities

• Database Management: Administer, maintain, and implement permissions, policies and procedures for ensuring the secure connectivity and integrity of databases.
• Performance Tuning: 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.
• Failover and Recovery: Design and execute database backup and recovery strategies, including failover planning and testing.
• Migration and Upgrade: Lead migration projects from on-premises databases to AWS, relational databases to NoSQL, including planning, execution, and validation of database migrations and upgrades.
• Development: Maintain and enhance custom performance, monitoring and security tools. Experienced with 3rd and 4th generation languages such as C++, PL/SQL, Python and Java.
• Security and Compliance: Ensure database security measures are in place, including access controls and audit logging. Comply with all applicable data privacy laws and regulations.
• Data Warehousing: Manage and optimize AWS Redshift instances and other data warehousing solutions for scalable and efficient data storage and analysis.
• Monitoring: Utilize AWS CloudWatch and other monitoring tools to ensure database health, performance, and to automate scaling and notifications.
• Troubleshooting and Support: 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.

Required Skills and Experience

• Looking for a candidate with the ability to handle Oracle Prod issues and carry the Oracle Duty Phone on a rotational basis. The candidate must have solid NoSQL (DocumentDB and MongoDB) skills as more applications are leveraging NoSQL databases.
• Solid experience of migrating databases from on-prem to cloud is a must.
• Bachelor's degree in Computer Science, Information Technology, or related field and at least 5 years of relevant experience. Will accept additional years of experience in lieu of degree.
• Database Expertise: Proven experience as a DBA with expertise in Oracle and NoSQL databases (MongoDB).
• AWS Managed Databases: Extensive experience with AWS DocumentDB or MongoDB database services.
• Failover and Recovery: Solid experience in database failover, recovery procedures, and disaster recovery planning.
• Programming experience and the ability to maintain, enhance and develop new tools.
• Migration Experience: Demonstrated experience with migrating on-premises databases to AWS
• Technical Skills: Proficient in MongoDB Query Language (MQL), database design, and data modeling. Familiarity with AWS CLI, SDKs, and CloudWatch.
• Communication Skills: Excellent verbal and written communication skills.

Desired Skills and Experience

• Certifications: AWS or relevant database certifications (e.g., Oracle Certified Professional, AWS Associate Architect).
• Scripting Skills: Experience with scripting languages (e.g., Python, Bash) for automation of database tasks.
• Monitoring Tools: Deep familiarity with database monitoring tools, especially AWS CloudWatch, for performance monitoring and alerting.
• Enterprise Database Management: 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.
• Master's degree (or higher) in computer science or related field is a plus.

Customer Requirements

• Clearance - Ability to obtain and hold a public trust position and favorable suitability based on a CBP Background Investigation.
• Citizenship - Must be a US Citizen.
• Location - Hybrid with on-site (Ashburn, VA) visits 1 day per week and if a mission need. *This team utilizes an on-call schedule which may require travel to the datacenter site.