29 Aug
|
Sapizon Technologies
|
Bengaluru
29 Aug
Sapizon Technologies
Bengaluru
Qualifications & Experience
- Bachelor's degree in Computer Science, Engineering, or a related field (or equivalent practical experience).
- 8+ years of hands-on experience administering PostgreSQL and SQL Server databases in production, covering both EC2-hosted and RDS-managed deployments.
- 3+ years of hands-on experience running database workloads on AWS.
- AWS certifications (e.g., AWS Certified Database Specialty, Solutions Architect) and Microsoft/PostgreSQL certifications are a plus.
- Experience with 24x7 production support, on-call rotations, and change/incident management processes (ITIL familiarity a plus).
Key Responsibilities
- Administer, monitor, and tune production PostgreSQL and SQL Server estates installation, configuration, patching, upgrades, backup/recovery, high availability, and disaster recovery.
- Design and implement HA/DR solutions: PostgreSQL streaming replication and failover, SQL Server Always On Availability Groups, log shipping, and Multi-AZ read-replica topologies on AWS RDS and Aurora.
- Perform advanced query tuning and performance troubleshooting using execution plans, wait statistics, indexing strategies, and workload analysis in both PostgreSQL and SQL Server.
- Provision, operate, and optimize AWS database infrastructure RDS, EC2-hosted databases, S3 (backups/exports), EBS storage tiers, VPC networking, security groups, and IAM-based access controls.
- Plan and execute database migrations (homogeneous and heterogeneous) using AWS DMS and native tooling, including schema conversion, data validation, and cutover planning.
- Automate routine DBA operations (provisioning, patching, backups, health checks, capacity reporting) using scripting and infrastructure-as-code.
- Implement and maintain database monitoring and alerting; drive proactive capacity planning, incident response, and root-cause analysis for production issues.
- Enforce database security best practices encryption at rest/in transit, least-privilege access, auditing, and compliance requirements.
- Contribute to FinOps efforts: right-sizing instances, storage optimization, and reserved capacity planning to control AWS database spend.
- Collaborate with application, DevOps, and infrastructure teams on schema design, release management, and CI/CD integration for database changes.
- Mentor junior engineers and produce high-quality runbooks, SOPs, and operational documentation.
- PostgreSQL Database Administration (On-prem & RDS) - administration of both self-managed (EC2-hosted) and Amazon RDS/Aurora PostgreSQL instances: installation, configuration, replication, vacuum/bloat management, backup and PITR (pg_basebackup, pgB
Location - Mumbai, Delhi NCR, Bengaluru , Kolkata, Chennai, Hyderabad, Ahmedabad, Pune, Remote
📌 Senior Database Engineer (Bengaluru)
🏢 Sapizon Technologies
📍 Bengaluru