Database Administrator

Project Role : Database Administrator
Project Role Description : Administer, develop, test, or demonstrate databases. Perform many related database functions across one or more teams or clients, including designing, implementing and maintaining new databases, backup/recovery and configuration management. Install database management systems (DBMS) and provide input for modification of procedures and documentation used for problem resolution and day-to-day maintenance.
Must have skills : Microsoft SQL Server Administration
Good to have skills : NA
Minimum 5 year(s) of experience is required
Educational Qualification : 15 years full time education

Must have skills - 1. Experience: Minimum 6 years of hands-on experience as an SQL Database Administrator (SQL DBA). 2. Technical Expertise: Proficiency in High Availability (HA) and Disaster Recovery (DR) solutions for SQL Server. Solid experience in performance tuning and query optimization, including troubleshooting and resolving database performance issues. 3. Communication Skills: Strong verbal and written communication skills, with the ability to collaborate effectively within teams and with stakeholders. 4. Work Tenure: A consistent career track record, with an average of at least 2 years spent in each previous organization. 5. Work Flexibility: Willingness to work in a 24x7 environment as needed, adapting to rotational shifts. 6. Escalation Handling and Customer Interaction: Experience in managing escalations and interacting directly with customers to resolve issues and ensure client satisfaction. Strong understanding of multi-geographic support environments, effectively addressing diverse customer needs while ensuring consistent, high-quality database support. Technical expertise: • Expertise in SQL Server Administration, with proficiency in high availability (HA) and disaster recovery (DR) solutions such as replication, mirroring, Always On, log shipping, Distributed AG, and clustering. • Proficient in SQL Server performance optimization and tuning to ensure optimal database performance and responsiveness for critical systems. • Skilled in planning and executing SQL Server instance upgrades and migrations across various environments, minimizing downtime and ensuring seamless transitions. • Familiarity with cloud technologies for database-related components, with a preference for hands-on experience. • Proficient in T-SQL or PowerShell scripting for automation and task optimization. • Experience managing and supporting SQL Server BI components, ensuring reliable analytics and reporting functionalities. • Strong troubleshooting skills on Windows platforms. • In-depth knowledge of backup and recovery processes, ensuring data integrity and availability in critical situations. • Good understanding of ITIL processes, ensuring structured incident management, change control, and service delivery. • Demonstrate strong customer handling skills, with the ability to interact directly with clients, understand their requirements, and contribute to delivering tailored database solutions and strategic recommendations. Roles & Responsibilities: • Handle all P1, P2, P3, and P4 incidents, changes, and service requests related to SQL Server administration, ensuring prompt and efficient resolution within SLAs. • Manage day-to-day database operations, including backup/restore, health checks, performance tuning, and resource optimization. • Proactively monitor database systems using tools like Zabbix, CheckMK, or Extended Events, ensuring optimal performance and uptime. • Implement and manage high availability (HA) and disaster recovery (DR) solutions such as Always On Availability Groups, clustering, replication, and log shipping. • Perform SQL Server upgrades, patching, migrations, and configuration changes with minimal disruption to business operations. Technical Expertise and Problem Solving: • Troubleshoot and resolve complex database issues, collaborating with other senior team members or SMEs when necessary. • Perform root cause analysis for recurring incidents and propose preventive measures to avoid future occurrences. • Optimize database performance by identifying and addressing bottlenecks, inefficient queries, or hardware limitations. • Utilize automation tools, T-SQL, and PowerShell scripts to reduce manual interventions and streamline repetitive tasks. Customer Interaction and Coordination: • Act as the first point of contact for all SQL Server-related issues allocated to your team, ensuring professional and timely communication with customers. • Collaborate with the SME/Team Manager for escalations, providing detailed analysis and proposed resolutions. • Provide guidance to customers on best practices, database strategies, and technical solutions when needed. Mentorship and Collaboration: • Assist junior DBAs in resolving complex tickets, enhancing their troubleshooting skills, and providing technical guidance. • Share knowledge with peers and juniors through training sessions, documentation, or informal mentoring. • Coordinate effectively with other DBAs, SMEs, and Team Managers to ensure seamless operations across shifts and teams. Process Adherence and Reporting: • Follow established processes, including ITIL-based incident, change, and problem management workflows, to maintain service quality. • Maintain and update documentation for assigned tasks, incidents, and solutions for future reference and audits. • Regularly review and contribute to process improvements and knowledge-sharing initiatives. Continuous Learning and Development: • Stay updated on emerging SQL Server technologies, tools, and best practices to enhance technical expertise. • Participate in training, certifications, and workshops to remain proficient in SQL Server administration.