HamburgerMenu
hirist

Reflections Info Systems - Senior Database Administrator

Reflections Info Systems P LTD
Kerala
8 - 10 Years
star-icon
3.9white-divider85+ Reviews

Posted on: 02/12/2025

Job Description

Description :

Responsibilities include :


- 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.


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


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


- High Availability : 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).


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


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


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


- Cloud Cost Management : 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.

Certifications :


- 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.


- 8+ years of hands-on experience in Microsoft SQL Server administration


- Bachelors degree in Computer Science or related field


- SQL certifications (MTA / MCSA / MCSE) are a plus


info-icon

Did you find something suspicious?