Job
Description
Job-Summary We are seeking a highly skilled and experienced SQL Tech Lead to join our dynamic team. The ideal candidate will have a strong background in database administration and management, with a total experience of over 12 years, including 6-8 years of relevant experience. The SQL Tech Lead will be responsible for overseeing various DBA related tasks and ensuring the optimal performance, security, and reliability of our SQL databases. Key Responsibilities The key focus areas of this role are: Manage and maintain Azure SQL Database and Azure SQL Managed Instances. Perform regular backup and restore operations to ensure data integrity and availability, including testing recovery strategies and automating backup processes. Write, optimize, and troubleshoot stored procedures to enhance database functionality and performance, ensuring efficient query execution plans and minimizing resource usage. Oversee the management and maintenance of database clusters, including setup, configuration, and monitoring of cluster health and performance. Implement and manage comprehensive user and role management strategies along with Role-Based Access Control (RBAC) to ensure secure access and compliance with internal policies. Set up, configure, and manage Disaster Recovery (DR) and High Availability (HA) solutions to ensure business continuity, including regular testing and documentation of DR plans. Plan and execute the migration of SQL databases to newer environments or cloud platforms, ensuring minimal downtime and data loss. Optimize and maintain databases using advanced techniques such as indexing, partitioning, and query optimization to improve performance and efficiency. Work with on-premises SQL Servers 2014, 2016, and 2022, ensuring their optimal performance and security through regular updates, patching, and monitoring. Conduct query optimization and performance tuning to enhance database performance, including analyzing query execution plans, identifying bottlenecks, and implementing improvements. Schedule and manage database jobs to automate routine tasks and maintenance, ensuring timely execution and monitoring of job outcomes. Collaborate with development teams to design and implement database solutions that meet application requirements and performance goals. Monitor database performance and provide proactive recommendations for improvements, including capacity planning and trend analysis. Provide technical leadership and mentorship to junior DBAs and other team members, fostering a culture of continuous learning and improvement. Stay current with industry trends and best practices in database administration and management and apply this knowledge to improve our database systems. Qualification & 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. Skills: performance tuning,teamwork,on-premises sql servers,stored procedures,database administration,sql managed instances,database,communication,query execution plans,user and role management (rbac),problem-solving,stored procedure optimization,database clusters management,azure sql database,query optimization,role-based access control (rbac),database backup and restore,aws,on-premises sql servers (2014, 2016, 2022),database migration,partitioning,sql,google cloud,backup and restore operations,dba,sql database migration,high availability (ha),azure sql managed instances,indexing,sql database administration,job scheduling,management,disaster recovery (dr) Show more Show less
