SQL Query Performance Developer

Main Responsibilities

• Manage SQL Server databases through all product environments, from development toproduction systems- Configure and maintain database servers and processes, including monitoring of systemhealth and performance, to ensure high levels of performance, availability, and security- Own database architecture, document technical specifications, and utilize best practicesin load testing to ensure rapid scalability- Provide 24x7 support for critical production systems; identify root causes of any databaserelated issues and resolve them- Write and performance tune SQL queries, stored procedures, indexes, and views- Serve as the primary peer reviewer for any SQL written by application engineers- Apply data modeling techniques to ensure schema meets performance expectations- Work with cross functional agile teams to determine the amount of effort required forcompleting projects- Collaborate closely with application engineers to implement requirements and providenecessary guidance to testers during the QA process- Develop, document, and maintain policies and procedures for ensuring database healthand performance- Share domain and technical expertise, providing technical mentorship and cross-trainingto other peers and team members

Technical skills

• 7+ years of experience in the design, development and implementation of SQL Serverdatabases- Proven experience as a Senior or Lead SQL Developer- 4+ years of experience in a Microsoft Azure Cloud environment- Hands-on familiarity with the architecture, setup, and maintenance of Microsoft AzureSQL service tiers including General Purpose, Business Critical, and HyperScale- Strong database programming experience including complex stored procedures andviews, query optimization, data modeling, and performance tuning- In-depth knowledge of best practices in database design and data modeling- Ability to monitor, maintain, and provide visibility into database health and performanceusing Azure Metrics and other tools, experience with DataDog a strong plus- Familiarity with using the Azure portal to view and optimize database costs acrossmultiple environments and subscriptions- Strong project delivery, organizational, and communication skills- Self-motivated individual with a proven ability to get things done with minimalsupervision- Experience supporting and working with Agile Scrum cross-functional teams in a dynamicenvironment- Experience with C# or Domo BI a plus- Bachelor's degree in a related field preferred, such as computer science or business

Key Skills

• SQL