Job
Description
As a SQL Tech Lead, your role will involve overseeing various DBA tasks to ensure optimal performance, security, and reliability of SQL databases. Your responsibilities will include: - Managing and maintaining Azure SQL Database and Azure SQL Managed Instances. - Performing regular backup and restore operations, including testing recovery strategies and automating backup processes. - Writing, optimizing, and troubleshooting stored procedures to enhance database functionality and performance. - Overseeing the management and maintenance of database clusters, including setup, configuration, and monitoring of cluster health. - Implementing comprehensive user and role management strategies with Role-Based Access Control (RBAC). - Setting up Disaster Recovery (DR) and High Availability (HA) solutions to ensure business continuity. - Planning and executing the migration of SQL databases to newer environments or cloud platforms. - Optimizing and maintaining databases using advanced techniques like indexing, partitioning, and query optimization. - Working with on-premises SQL Servers 2014, 2016, and 2022, ensuring optimal performance and security through regular updates and monitoring. - Conducting query optimization and performance tuning to enhance database performance. - Collaborating with development teams to design and implement database solutions that meet application requirements. - Monitoring database performance and providing proactive recommendations for improvements. - Providing technical leadership and mentorship to junior DBAs and team members. - Staying current with industry trends and best practices in database administration. Qualifications and Experience: - Bachelor's degree in computer science, Information Technology, or a related field. - 12+ years of total experience in database administration and management. - 6-8 years of relevant experience working with SQL databases, particularly Azure SQL DB and Azure SQL Managed Instances. - In-depth knowledge of database backup, restore, and recovery procedures. - Proficiency in writing and troubleshooting stored procedures. - Experience in managing database clusters, implementing user and role management with RBAC, and setting up DR and HA solutions. - Proven experience in migrating SQL databases, optimizing performance, and working with on-premises SQL Servers. - Advanced skills in query optimization, performance tuning, and job scheduling. - Strong problem-solving, analytical, communication, and teamwork abilities. Preferred Skills: - Certification in SQL Server or related technologies. - Familiarity with cloud platforms other than Azure. - Knowledge of additional database systems and technologies. - Experience with database security best practices. As a SQL Tech Lead, your role will involve overseeing various DBA tasks to ensure optimal performance, security, and reliability of SQL databases. Your responsibilities will include: - Managing and maintaining Azure SQL Database and Azure SQL Managed Instances. - Performing regular backup and restore operations, including testing recovery strategies and automating backup processes. - Writing, optimizing, and troubleshooting stored procedures to enhance database functionality and performance. - Overseeing the management and maintenance of database clusters, including setup, configuration, and monitoring of cluster health. - Implementing comprehensive user and role management strategies with Role-Based Access Control (RBAC). - Setting up Disaster Recovery (DR) and High Availability (HA) solutions to ensure business continuity. - Planning and executing the migration of SQL databases to newer environments or cloud platforms. - Optimizing and maintaining databases using advanced techniques like indexing, partitioning, and query optimization. - Working with on-premises SQL Servers 2014, 2016, and 2022, ensuring optimal performance and security through regular updates and monitoring. - Conducting query optimization and performance tuning to enhance database performance. - Collaborating with development teams to design and implement database solutions that meet application requirements. - Monitoring database performance and providing proactive recommendations for improvements. - Providing technical leadership and mentorship to junior DBAs and team members. - Staying current with industry trends and best practices in database administration. Qualifications and Experience: - Bachelor's degree in computer science, Information Technology, or a related field. - 12+ years of total experience in database administration and management. - 6-8 years of relevant experience working with SQL databases, particularly Azure SQL DB and Azure SQL Managed Instances. - In-depth knowledge of database backup, restore, and recovery procedures. - Proficiency in writing and troubleshooting stored procedures. - Experience in managing database clusters, implementing user and role management with RBAC, and setting up DR and HA solutions.
