Senior Database Engineer
1
1KosmosIdentity security
Remote, based in India.Full-TimeSenior
Salary not disclosed
Apply NowOpens the employer's application page
Job Details
- Experience
- 5+ years of experience administering production databases.
- Required Skills
- AWSPostgreSQLPythonSQLBashGitMongoDB
Requirements
- Bachelor’s or Master’s degree in Computer Science, Engineering, or a related field, or equivalent experience.
- 5+ years of experience administering production databases.
- Hands-on production experience with MongoDB or Amazon DocumentDB, including replica sets, indexing, TTL, and upgrades.
- Hands-on production experience with PostgreSQL.
- Strong SQL and experience with Amazon Redshift or a comparable analytical query engine.
- Experience assessing application impact before production database upgrades.
- Experience designing indexes and tuning queries using profiler and explain plan output.
- Experience running schema and data migrations as part of a release process.
- Production experience with backup, restore, and replication, including tested recovery.
- Strong experience with AWS database and supporting services, including RDS or Aurora, DocumentDB, DynamoDB, S3, IAM, Secrets Manager, and CloudWatch.
- Proficiency in Python or Bash for automation.
- Experience with Git and CI-based change workflows.
- Experience handling PII and customer data under SOC 2, GDPR, or similar requirements.
- Willingness to participate in an on-call rotation.
Responsibilities
- Operate MongoDB, Amazon DocumentDB, PostgreSQL, DynamoDB, and Amazon Redshift, including health checks, capacity, connections, and storage growth.
- Plan and execute database upgrades, assessing driver compatibility, deprecated features, and query behavior against application code before production changes.
- Profile workloads, read explain plans, and design, add, or retire indexes based on query patterns.
- Run pre-deployment schema and data migrations with pre-checks, result verification, and tested rollbacks.
- Manage versioned database migrations in Git and apply reviewed changes through CI with GitHub Actions.
- Handle customer data extracts, reports, corrections, and deletion requests with approvals and an audit trail.
- Maintain Redshift reporting access over Iceberg tables in S3, including external schemas, Spectrum, Glue Data Catalog, views, grants, and query performance.
- Own backups, point-in-time restores, and failover; rehearse and document restore procedures.
- Manage database access, monitoring, alerting, and database incidents, including root-cause analysis and follow-up fixes.
- Automate repetitive DBA work with Python or Bash and collaborate with Development, Customer Success, ML, and DevSecOps teams.
View Full Description & ApplyYou'll be redirected to the employer's site
