Lead Staff Engineer - Database Administration (8-12 yrs)

Role & Responsibilities :

- Manage multiple RDBMS platforms (MSSQL (Primary), MySQL, and Postgres, etc.) through multiple product lifecycle environments, from development to mission-critical production systems.

- Configure and maintain database servers and processes, including monitoring system health and performance to ensure high levels of performance, availability, and security.

- Apply data modeling techniques to ensure development and implementation support efforts meet integration and performance expectations.

- Independently analyze, solve, and correct issues in real-time, providing problem resolution end-to-end.

- Refine and automate regular processes, track issues, and document changes.

- Assist developers with complex query tuning and schema refinement.

- Share domain and technical expertise, providing technical mentorship and cross-training to other peers and team members.

- Provide rotation-based 24/7 on-call support for unplanned outages and planned maintenance/release events.

- Collect and report database performance KPIs on a regular basis.

Ideal Candidate :

- Bachelor's degree in information technology or a related discipline.

- 8+ years of database administration experience, preferably in MSSQL (primary), MySQL, and Postgres.

- At least 2 years of cloud-based database administration experience.

- Experience in troubleshooting and resolving database problems.

- Experience in implementing operational automation using scripts.

- Hands-on experience with SSIS, SSRS, SSAS, and PowerShell.

- Extensive experience with Windows/SQL Server Clustering (On Physical & Cloud-based VMs), Always On, Replication, and Mirroring.

- Experience with Performance Tuning and Optimization (PaaS & IaaS).

- Experience with backups, restores, and recovery models.

- Knowledge of High Availability (HA) and Disaster Recovery (DR) options for SQL Server.

- Experience working with Windows Server, including Active Directory.

- Excellent written and verbal communication.

- Flexible team player with a "get-it-done" personality.

- Ability to organize and plan work independently.

- Ability to work in a rapidly changing environment.

- Ability to multi-task and context-switch effectively between different activities and teams.