We looking for a Senior SQL Database Architect who has in-depth experience with SQL Server, specifically 2012/2014 and ideally 2016. The successful candidate will be an experienced Developer with extensive enterprise background using MS SQL Server. The Senior SQL Database Architect will be required to identify business requirements, develop data models, perform data analysis, write advanced SQL queries, design and code complex stored procedures, and performance tune existing database processes.
Responsibilities and Duties
Design and develop database objects, tables, stored procedures, views, triggers and SSIS packages
Performance tuning the stored procedures and T-SQL.
Assist developers with complex query tuning and schema refinement.
Independently analyze, solve, and correct issues in real time, providing problem resolution end-to-end.
When users complain about the performance of a particular query, help developers improve the performance of that query by tweaking it or modifying indexes
Tuning T-SQL queries to improve performance
Qualifications and Skills
Bachelor’s degree in Computer Science or equivalent.
In-depth knowledge of standard concepts, practices and procedures related to database management
Required 8 years solid experience with SQL Server 2008 R2 and above. Must know SQL inside and out.
Required 8 years T-SQL language (queries, views, procedures)
Required 8 years SQL Server Database Design, Stored Procedure Design and implementation
Experience coding complex stored procedures (using T-SQL).
Experience with developing SSIS packages
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, Pre-Production and Production environments
Monitoring performance and managing parameters to provide fast query responses to front-end users
Familiarity with BI technologies (e.g. Power BI)
Excellent English communications skills (written and verbal)
15 of PTO
8 paid predetermined holiday
Full health benefits, including dental and vision
Expansion and growth with one of the top insurance technology companies in the nation
Professional team atmosphere with motivated, career-driven professionals as co-workers
H1B sponsorship available
Job Type: Full-time
SQL Database Development: 8 years
SQL Database Administration: 8 years