12 Sep
|
Applied Systems India Private
|
Bengaluru
12 Sep
Applied Systems India Private
Bengaluru
External Job Ad:
We are hiring Database Administrator for Bengaluru location
Role - Database Administrator
Exp - 5 -7 years
Work Timing - 2:00 PM - 11:00 PM
About the Role
Key Responsibilities
- Manage and maintain PostgreSQL and Microsoft SQL Server to ensure availability, performance, and security.
- Monitor database health, troubleshoot incidents, and deliver root‑cause analysis with preventative fixes; participate in an on‑call rotation.
- Design and optimize schemas, indexes, and queries in partnership with product and engineering teams.
- Operate robust backup, restore, and disaster recovery processes aligned to RPO/RTO, including regular failover/restore tests.
- Perform installations, upgrades, and migrations across on‑premise and managed services (MS SQL, RDS/Aurora, Azure SQL, Cloud SQL).
Requirements (Must‑haves)
- Bachelor’s degree in Computer Science, Information Technology, or equivalent practical experience.
- 3-5 years as a production DBA with PostgreSQL and Microsoft SQL Server.
- Hands‑on experience with on-premise and AWS,
Azure, or GCP managed database services (MS SQL, RDS/Aurora, Azure SQL, Cloud SQL, etc.).
- Strong fundamentals in database design, indexing, transactions, and performance tuning using query plans/DMVs/pg_stat_statements.
- Proven backup, recovery, and HA/DR experience with executed tests (not just documented plans).
- Incident response experience in high‑impact environments and transparent communication with technical and non‑technical stakeholders.
Nice to Have
- Experience with observability tools: Solarwinds Database Performance Analyzer (DPA), Redgate SQL Monitor, CloudWatch, Azure Monitor, GCP Monitoring, and DataDog.
- Automation/IaC for database operations (PowerShell, Python, Terraform, Ansible; Flyway/Liquibase or similar versioned migration frameworks).
- Experience with insurance or financial services and PII‑handling, or prior exposure to Applied Systems products.
📌 Database Administrator (Bengaluru)
🏢 Applied Systems India Private
📍 Bengaluru