Senior Cloud Database Administrator - SAS

Sparibis - Suitland, MD

Full-time - Senior

Suitland, MD

Administrative and Support Services

About the position

The Senior Cloud Database Administrator will be responsible for managing and transitioning SAS data sets to relational databases, particularly PostgreSQL, within a cloud environment. This role requires strong expertise in database administration, performance tuning, and cloud technologies, specifically AWS and Azure. The position involves operational responsibilities, including database monitoring, troubleshooting, and ensuring compliance with security requirements. The ideal candidate will work closely with clients to understand their data needs and implement effective solutions for database management and migration.

Responsibilities

• Review and work with clients to understand their current SAS data sets and develop a transition plan to move data to a cloud relational database.
• Develop PostgreSQL PL/pgSQL code optimized for enterprise large data sets.
• Supervise performance of database installations, configurations, and migrations as required.
• Proactively diagnose and resolve problems affecting database systems.
• Maintain database configurations in compliance with release management and security requirements.
• Perform daily production support and continuous database monitoring activities.
• Deploy database recovery techniques as needed.
• Understand the full application stack from the OS through custom applications in Amazon cloud environments.
• Participate in planning, implementation, and growth of infrastructure on AWS Gov Cloud or Azure.
• Implement migration efforts with application teams, including data migration.
• Identify and recommend improvements for poor database performance.
• Support troubleshooting incidents and improve points of failure in infrastructure/applications.
• Collaborate with architects and engineers to design scalable software services and systems.
• Review and provide input to policies and standard operating procedures.

Requirements

• 7+ years of professional experience in database administration.
• Bachelor's degree in computer science, computer engineering, cyber security, or a relevant IT field.
• Ability to obtain a Public Trust security clearance.
• Strong experience with SAS data sets and transitioning data to relational databases, preferably PostgreSQL.
• Experience in PostgreSQL PL/pgSQL programming and performance tuning in enterprise environments.
• Experience with cloud database administration (AWS or Azure) including Postgres, MS SQL, and Oracle.
• Experience with DBA activities such as patching, backup/recovery, maintenance, troubleshooting, and monitoring.
• Experience with migration to the cloud and automation/infrastructure as code (CloudWatch/Terraform).
• AWS, Azure, and/or Oracle Certification required.

Nice-to-haves

• Python programming experience.
• Experience with RDS databases (Oracle, Postgres, MS SQL, Maria) and Aurora databases (MySQL, Postgres).
• Experience with CI/CD tools such as Jenkins, Docker, Ansible, Puppet, Chef, Maven, GitHub, Artifactory, SonarQube.
• Experience with automation and infrastructure as code such as CloudFormation/Terraform.
• Experience monitoring production database workloads using CloudWatch, OMS, etc.

Benefits

• Health insurance
• 401k plan
• Paid holidays
• Flexible scheduling
• Professional development opportunities