Sr. DBA (Postgres) || Remote

Qualifications:

·         Bachelor’s degree from an accredited college in a related discipline, or equivalent experience/combined education, with 6 - 8 years of relevant professional experience; or 4 - 6 years of relevant professional experience with a related Masters degree. Considered an emerging authority. Experience may be substituted in lieu of degree.

·         Advanced scripting expertise including bash and Python for database administration and CloudFormation for deployments.

·         Demonstrated experience with developing logical and physical data models, data/information exchange models, standards, or tools in a PostgreSQL database environment.

·         Extensive database administration experience with PostgreSQL running on Amazon RDS.

·         Database administration experience with one or more of MySQL, Microsoft SQL Server, and Oracle.

·         Experience in evaluating data architecture & data models and communicating recommendations to the program team.

·         Experience managing database replication and Change Data Capture (CDC) preferably in PostgreSQL using AWS Database Migration Service (DMS).

·         Solid understanding of High Availability and Resiliency architecture (Multi-AZ and Multi-Region deployment architecture)

·         Advanced experience in a Linux environment.

·         Experience in an AWS environment.

·         Strong verbal and written communications skills.

·         Experience with database security and compliance controls, including FISMA/FedRAMP requirements, encryption at rest and in transit (SSL/TLS), role-based access control (RBAC), and audit logging using pgAudit.

·         Advanced expertise with PostgreSQL query performance tuning, including use of EXPLAIN, index design and optimization, and autovacuum configuration.

·         Experience with version control (Git) and CI/CD pipelines (e.g., Jenkins, GitHub Actions, GitLab CI, or AWS CodePipeline) for database deployments; familiarity with database migration tools such as Liquibase or Flyway.

·         Demonstrated performance leading IT services delivery and achieving service level agreements.

·         Strong focus on automation and documentation.

Desired Skills:

·         Experience creating and administering AWS Glue databases and Athena tables.

·         Experience developing software using other AWS services such as Lambda, Lake Formation, QuickSight, DynamoDB, Redshift, MSK/Kafka, Kinesis, ElastiCache, and OpenSearch.

·         Experience with containerization technologies such as Docker or Kubernetes, including running PostgreSQL and MySQL workloads in containerized environments (e.g., Amazon ECS, Amazon EKS) or using RDS Proxy.

·         Experience supporting Java and PySpark applications.

·         Experience developing and executing Ansible scripts.