Job
Description
As a SQL Tech Lead, you will play a crucial role in overseeing the management and optimization of SQL databases to ensure optimal performance, security, and reliability. Key Responsibilities: - Managing and maintaining Azure SQL Database and Azure SQL Managed Instances. - Performing regular backup and restore operations to guarantee data integrity and availability, including testing recovery strategies and automating backup processes. - Writing, optimizing, and troubleshooting stored procedures to enhance database functionality and performance, ensuring efficient query execution plans and minimizing resource usage. - Overseeing the management and maintenance of database clusters, including setup, configuration, and monitoring of cluster health and performance. - Implementing and managing comprehensive user and role management strategies along with Role-Based Access Control (RBAC) to ensure secure access and compliance with internal policies. - Setting up, configuring, and managing Disaster Recovery (DR) and High Availability (HA) solutions to ensure business continuity, including regular testing and documentation of DR plans. - Planning and executing the migration of SQL databases to newer environments or cloud platforms, ensuring minimal downtime and data loss. - Optimizing and maintaining databases using advanced techniques such as indexing, partitioning, and query optimization to improve performance and efficiency. - Working with on-premises SQL Servers 2014, 2016, and 2022, ensuring their optimal performance and security through regular updates, patching, and monitoring. - Conducting query optimization and performance tuning to enhance database performance, including analyzing query execution plans, identifying bottlenecks, and implementing improvements. - Scheduling and managing database jobs to automate routine tasks and maintenance, ensuring timely execution and monitoring of job outcomes. - Collaborating with development teams to design and implement database solutions that meet application requirements and performance goals. - Monitoring database performance and providing proactive recommendations for improvements, including capacity planning and trend analysis. - Providing technical leadership and mentorship to junior DBAs and other team members, fostering a culture of continuous learning and improvement. - Staying current with industry trends and best practices in database administration and management and applying this knowledge to improve our database systems. Qualifications and Experience: - Bachelor's degree in computer science, Information Technology, or a related field. - 12+ years of total experience in the field of database administration and management. - 6-8 years of relevant experience working with SQL databases, particularly with 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 and implementing user and role management with RBAC. - Expertise in setting up DR and HA solutions. - Proven experience in migrating SQL databases and optimizing their performance. - Strong knowledge of on-premises SQL Servers 2014, 2016, and 2022. - Advanced skills in query optimization, performance tuning, and job scheduling. - Excellent problem-solving and analytical skills. - Strong communication and teamwork abilities. Preferred Skills: - Certification in SQL Server or related technologies. - Familiarity with cloud platforms other than Azure, such as AWS or Google Cloud Platform. - Knowledge of additional database systems and technologies. - Experience with database security best practices.,
