Adaptive Solutions Group is a premier provider of information technology personnel. We provide a variety of technical professionals available for contract, contract to hire, or direct placement positions to companies in and around the St. Louis, Kansas City, and Denver Areas.
We are currently looking for a Senior SQL Database Developer to join our team.
We are seeking a Senior Database Developer that loves working with large transactional database systems powering SaaS platforms. This candidate must be able to work alongside other DBA’ s and Senior Software Engineers to coach, implement and review all database related activities. They will work with a variety of software stakeholders to implement known best patterns and practices in database design.
Design and develop database objects, tables, stored procedures, views, triggers and SSIS packages.
Implement, review and tune table indexes as needed.
Performance tuning the stored procedures and T-SQL.
Assist developers with complex query tuning and schema refinement.
Analyze, solve, and correct issues on production systems in real time, providing problem resolution end-to-end.
Help developers improve the performance of queries by tweaking it or modifying indexes.
Bachelor’ s degree in Computer Science or equivalent.
In-depth knowledge of standard concepts, practices and procedures related to database management.
7+ years of experience in software development, using Microsoft SQL Server, T-SQL, and T-SQL language (queries, views, procedures), SQL Server Database Design, Stored Procedure Design and implementation.
Proven analytical problem solving and debugging skills.
Experience in troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues etc.
Experience in Performance Tuning, Query Optimization, using Performance Monitor, SQL Profiler and other related monitoring and troubleshooting tools.
Providing database support for development and deployment of database scripts in Development, Test, and Production environments.
Monitoring performance and managing parameters to provide fast query responses to front-end users.
Familiarity with BI technologies (e.g. Microsoft Power BI).
Familiarity with Database tuning tools (e.g. SQL Sentry, SolarWinds DPA).
Excellent English communication skills (written and verbal).
Adaptive Solutions Group is an equal opportunity employer. All applicants will be considered for employment without attention to race, color, religion, sex, sexual orientation, gender identity, national origin, and veteran or disability status.
Adaptive Solutions Group offers a competitive compensation and benefits package that includes medical, dental, STD/LTD, life insurance coverage, 401k, paid vacation and holidays.