Job Title

IntroductionWe are looking for candidates with 8+ years of experience for this role.Project Duration: 6+ Months, - Based on the performance and Productivity.Max Budget: 12 - 12.2 LPA fixed. Job Description/ Primary job roleThe primary job role of a Senior Database Administrator (DBA) includes overseeing themanagement, maintenance, and optimization of databases within the organization. Works onstrategic initiatives to align the database infrastructure with long-term business goals andensures that best practices in database management are consistently followed.Main duties/responsibilities• Optimize database queries to ensure fast and efficient data retrieval, particularly forcomplex or high-volume operations.• Design and implement effective indexing strategies to reduce query execution times andimprove overall database performance.• Monitor and profile slow or inefficient queries and recommend best practices forrewriting or re-architecting queries.• Continuously analyze execution plans for SQL queries to identify bottlenecks andoptimize them.• Database Maintenance: Schedule and execute regular maintenance tasks, includingbackups, consistency checks, and index rebuilding.• Health Monitoring: Implement automated monitoring systems to track databaseperformance, 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 failoverstrategies to ensure high availability and disaster recovery (e.g., using tools like SQLServer Always On, Oracle RAC, MySQL Group Replication).• Capacity Planning: Monitor resource consumption and plan for growth to ensure thedatabase 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 correctly adhered toand identify opportunities for reducing licensing costs.• Cloud Cost Management: Use cost analysis tools (e.g., AWS Cost Explorer, Azure CostManagement) to monitor and optimize cloud database spend, identifying opportunitiesfor right sizing or reserving instances.Primary skills• 8-10 years of experience in Microsoft SQL Server administrationQualifications• Bachelor's degree in computer science, software engineering or a related field• Microsoft SQL certifications (MTA Database, MCSA: SQL Server, MCSE: DataManagement and Analytics) will be an advantage.Secondary Skills• Experience in MySQL, PostgreSQL, and Oracle database administration.• Exposure to Data Lake, Hadoop, and Azure technologies• Exposure to DevOps or ITILBehavioral competencies• Communication• Teamwork• Digital Mindset• Operational Excellence• Analytical Ability• Customer Centricity• Business and Market Acumen• Empathy• Growth Mindset