Sr. SQL Server Developer

Sr. SQL Server Database Developer Onsite - Kansas City, MO (4days/week in office) Full Time: Base + Annual Bonus + Benefits Job Functions: Gain expertise in current Database Schema and domain data flows end to end from front end to Batch Processing Work with the Software Engineering team to design new database objects (Stored procedures, functions, views, and tables) Assist the Database Administrators and Development teams in writing complex SQL code and troubleshooting support incidents Assist with the creation and maintenance of documentation of database systems Perform code reviews on code submitted by the development teams Proactively locate areas where there is an opportunity for performance improvement in our existing systems. Work on highly complex projects with minimal supervision and proactively raise issues/concerns to management as needed Provide 2nd and 3rd tier support of database systems as needed Participate in on-call rotation as needed Required Experience: 5+ years’ experience with database development using SQL Server Expert knowledge of ANSI Standard Transact-SQL and latest Transact-SQL query language enhancements. Strong experience maintaining enterprise-level databases including optimization, indexing, troubleshooting performance issues, and tuning Experience with delivering and supporting large, high-performance databases across multiple SQL Instances Experience using query store and DMVs to identify issues and performance tuning opportunities SQL Server SQL Agent and other Automation tools Strong written and verbal communication skills Experience with automated deploys and version control of SQL objects using SSDT. Experience In the Following Areas Is a Plus Experience deploying and maintaining SQL databases in Azure Bachelor’s degree in software engineering, Computer Science, or similar field of study Experience working with databases in Azure in a PaaS and/or IaaS environment. Experience working with GIT version control systems and ADO. Experience working with performance monitoring tools such as SolarWinds DPA and SQLSentry products Experience developing and supporting SSRS and/or PowerBI reports. Job Type: Full-time Pay: $100,000.00 - $115,000.00 per year Benefits: 401(k) Dental insurance Health insurance Experience: SQL Server Development: 5 years (Required) ANSI T-SQL: 5 years (Required) Ability to Commute: Kansas City, MO 64105 (Required) Work Location: Hybrid remote in Kansas City, MO 64105