Sr. DBA (PostgreSQL & AWS)

Job Description

As a Senior Database Administrator (DBA) at Nium, you will be responsible for leading the architecture, performance, and reliability of PostgreSQL, MongoDB, RedShift, and other database platforms hosted on AWS, primarily RDS/Aurora. Your role is crucial in enabling modern, automated, and resilient database operations to support the engineering and analytics teams.**Key Responsibilities:**- Architect, manage, and scale cloud-native PostgreSQL and MongoDB clusters (primarily AWS RDS/Aurora, MongoDB Atlas)- Implement and maintain schema change automation using tools like Liquibase, Flyway, or equivalent- Collaborate with engineering teams on schema design, query optimization, indexing strategies, and ORM tuning- Establish and evolve database CI/CD pipelines integrated with GitOps practices- Monitor database health and performance using observability tools such as CloudWatch, Datadog, Prometheus/Grafana, or pg_stat_statements- Drive automation for routine operations: failover, backup validation, data masking, role management, etc.- Manage and secure database environments with IAM, KMS, and encrypted connections- Plan and execute migration strategies (engine-to-engine, sharded or replicated setups)- Document architecture, runbooks, schema evolution, and disaster recovery plans- Support compliance needs (e.g., audit logging, PCI-DSS, GDPR/data retention policies)- Coach developers and data analysts on best practices for schema evolution, query design, and performance debugging**Qualifications Required:**- 5 years of production experience with PostgreSQL, MongoDB, and MySQL including high-availability and disaster recovery setups- Proven experience with cloud-managed databases (e.g., AWS RDS, Aurora, DocumentDB)- Strong SQL and NoSQL tuning skills; deep knowledge of query plans, vacuum/analyze, index strategies- Hands-on with Liquibase, Flyway, or similar tools for version-controlled schema management- Proficient in scripting with Python, Bash, or Go for automation- Familiarity with AWS CLI/SDK, Terraform, or CloudFormation for database IaC- Experience with monitoring, alerting, and performance dashboards- Robust understanding of replication, sharding, WAL tuning, and data lifecycle managementAt Nium, you will be rewarded with competitive salaries, performance bonuses, sales commissions, equity for specific roles, and recognition programs. Your wellness is a top priority, and we offer medical coverage, employee assistance programs, generous vacation programs, and a flexible hybrid working environment. Additionally, we focus on upskilling our employees through role-specific training, internal workshops, and a learning stipend. Nium constantly innovates and celebrates together with company-wide social events, team bonding activities, and more. We thrive with diversity and provide a safe and welcoming environment for everyone.For more detailed region-specific benefits, you can visit [Nium Careers Perks](https://www.nium.com/careers#careers-perks). If you are interested in joining a global company that values innovation and diversity, visit [www.nium.com](https://www.nium.com). As a Senior Database Administrator (DBA) at Nium, you will be responsible for leading the architecture, performance, and reliability of PostgreSQL, MongoDB, RedShift, and other database platforms hosted on AWS, primarily RDS/Aurora. Your role is crucial in enabling modern, automated, and resilient database operations to support the engineering and analytics teams.**Key Responsibilities:**- Architect, manage, and scale cloud-native PostgreSQL and MongoDB clusters (primarily AWS RDS/Aurora, MongoDB Atlas)- Implement and maintain schema change automation using tools like Liquibase, Flyway, or equivalent- Collaborate with engineering teams on schema design, query optimization, indexing strategies, and ORM tuning- Establish and evolve database CI/CD pipelines integrated with GitOps practices- Monitor database health and performance using observability tools such as CloudWatch, Datadog, Prometheus/Grafana, or pg_stat_statements- Drive automation for routine operations: failover, backup validation, data masking, role management, etc.- Manage and secure database environments with IAM, KMS, and encrypted connections- Plan and execute migration strategies (engine-to-engine, sharded or replicated setups)- Document architecture, runbooks, schema evolution, and disaster recovery plans- Support compliance needs (e.g., audit logging, PCI-DSS, GDPR/data retention policies)- Coach developers and data analysts on best practices for schema evolution, query design, and performance debugging**Qualifications Required:**- 5 years of production experience with PostgreSQL, MongoDB, and MySQL including high-availability and disaster recovery setups- Proven experience with cloud-managed databases (e.g., AWS RDS, Aurora, DocumentDB)- Strong SQL and NoSQL tuning skills; deep knowledge of query plans, vacuum/analyze, index stra

Keyskills :
PostgreSQLMongoDBAWSLiquibaseDevOpsSQLNoSQLPythonBashmonitoringperformance dashboardsreplicationRedShiftRDSAuroraDBOpsschema versioninginfrastructureascodedatabase CICDFlywayGitOpsSREsTerraformCloudFormationalertingshardingWAL