Job responsibilities
- Support the review of controls to ensure sufficient protection of enterprise data.
- Advise and make custom configuration changes in one to two tools to generate a product at the business or customer request.
- Update logical or physical data models based on new use cases.
- Frequently use SQL and understand NoSQL databases and their niche in the marketplace.
- Implement backup, recovery, and disaster recovery (DR) plans.
- Monitor database capacity, space, logs, and performance metrics.
- Manage database security, access control, and user privilege management.
- Conduct database health checks, troubleshoot, and resolve issues in real-time.
- Script using Shell and Python, and utilize database tools.
- Configure and maintain MongoDB replica sets, sharding, and failover mechanisms.
Required qualifications, capabilities, and skills
- Formal training or certification in software engineering concepts and 3+ years of applied experience.
- Experience across the data lifecycle
- Advanced at SQL (e.g., joins and aggregations)
- Working understanding of NoSQL databases
- Expertise in PostgreSQL & MongoDB DBA.
- Strong expertise in SQL, PL/pgSQL, and NoSQL (MongoDB queries, aggregation, and indexing).
- Hands-on experience with PostgreSQL replication, partitioning, and tuning.
- Experience managing MongoDB Atlas, Sharded Clusters, and Performance tuning.
- Familiarity with database monitoring tools such as Prometheus, Grafana, or CloudWatch.
- Strong knowledge of database security best practices and encryption techniques.
- Experience in automating DB tasks using Bash, Python, or Ansible.
Preferred qualifications, capabilities, and skills
- MongoDB Certified DBA
- PostgreSQL Professional Certification
- AWS Certified Database – Specialty / Data Engineer (preferred but not mandatory)
- Experience working with cloud-based databases (AWS RDS, Azure Cosmos DB, GCP Cloud SQL) is a plus.