Lead Staff Engineer - Database Administration

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. (ref:hirist.tech)

Location: in, IN

Posted Date: 11/26/2024