Reflections Info Systems - Senior Database Administrator - SQL Server (8-12 yrs)

We are looking for 8+years experienced candidates for this role.

Job Description :

The primary job role of a Senior Database Administrator (DBA) includes overseeing the management, maintenance, and optimization of databases within the organization. Works on strategic initiatives to align the database infrastructure with long-term business goals and ensures that best practices in database management are consistently followed.

Main duties/responsibilities :

- Optimize database queries to ensure fast and efficient data retrieval, particularly for complex or high volume operations.

- Design and implement effective indexing strategies to reduce query execution times and improve overall database performance.

- Monitor and profile slow or inefficient queries and recommend best practices for rewriting or re-architecting queries.

- Continuously analyze execution plans for SQL queries to identify bottlenecks and optimize them.

- Database Maintenance : Schedule and execute regular maintenance tasks, including backups, consistency checks, and index rebuilding.

- Implement automated monitoring systems to track database performance, availability, and critical parameters such as CPU usage, memory, disk I/O, and replication status.

- Diagnose and resolve database issues (e.g., locking, deadlocks, data corruption) proactively, before they impact users or operations.

- Implement and manage database clustering, replication, and failover strategies to ensure high availability and disaster recovery (e.g., using tools like SQL Server Always On, Oracle RAC, MySQL Group Replication).

- Monitor resource consumption and plan for growth to ensure the database can scale effectively with increasing data volume and transaction load.

- Analyze and optimize resource usage (CPU, memory, disk, network) to reduce operational costs.

- Ensure that database licensing models are properly adhered to and identify opportunities for reducing licensing costs.

- Use cost analysis tools (e.g., AWS Cost Explorer, Azure Cost Management) to monitor and optimize cloud database spend, identifying opportunities for right sizing or reserving instances.

Experience : 5 to 7 years of experience in Microsoft SQL Server administration

Qualifications :

- Bachelor's degree in computer science, software engineering or a related field

- Microsoft SQL certifications (MTA Database, MCSA: SQL Server, MCSE: Data Management and Analytics) will be an advantage.

Technical skills :

- Experience in MySQL, PostgreSQL, and Oracle database administration.

- Exposure to Data Lake, Hadoop, and Azure technologies

- Exposure to DevOps or ITIL

Behavioral competencies :

- Communication

- Teamwork

- Digital Mindset

- Operational Excellence

- Analytical Ability

- Customer Centricity

- Business and Market Acumen

- Empathy

- Growth Mindset