(SQL Server Developer ,Database Design & Architecture, Programming, performance tuning, T-SQL)

Vertafore is a leading technology company whose innovative software solution are advancing the insurance industry. Our suite of products provides solutions to our customers that help them better manage their business boost their productivity and efficiencies and lower costs while strengthening relationships.

Our mission is to move InsurTech forward by putting people at the heart of the industry. We are leading the way with product innovation technology partnerships and focusing on customer success.

Our fast-paced and collaborative environment inspires us to create think and challenge each other in ways that make our solutions and our teams better.

We are headquartered in Denver Colorado with offices across the U.S. Canada and India.

JOB DESCRIPTION

As a SQL Server Senior you will design implement develop and fine-tune. You will work with a fast-paced skilled team of engineers and developers across multiple high-profile projects. You will also participate in IT projects from the inception of the project through the daily maintenance phase of a project. If you are a top-notch SQL Developer with Performance tunning and looking for the next challenge apply now!

Core Requirements and Responsibilities:

Essential job functions included but are not limited to the following:

• SQL Server Developer
• Strong expertise in TSQL query optimization and execution plan analysis andPerformance Tuning.
• Knowledge of SQL Server internals (locking isolation levels transaction management).
• Design develop and optimize complex stored procedures functions triggers and views.
• Implement best practices for TSQL coding standards and query optimization.
• Work with developers to review and improve databasedriven application code.
• Diagnose and resolve performance issues using execution plans DMVs and query statistics.
• Optimize indexes partitioning and schema design for OLTP and reporting workloads.
• Address issues such as parameter sniffing blocking and deadlocks.

Knowledge Skills and Abilities:

• • 4 - 5 years of experience in SQL Server database engineer
  • SQL Server Database Design & Architecture Programming
  • Strong performance tuning skills in a very large database environment
  • Ability to run trace reports and analyse results then to recommend options for problem resolution
  • Proficient with Transact-SQL (T-SQL)
  • Familiarity with SQL Server DTS/SQL Server SSIS packages
  • Expertise in scripting like PowerShell.
  • Understanding of database installation and configuration
  • Strong experience in SQL Server 2017 is a plus
  • Demonstrated desire and ability to learn technologies quickly
  • Possesses good oral and written communication skills.
  • Contributes to a positive team environment.
  • Enjoys finding and implementing solutions to new challenges.
  • Sets goals and focuses on results.
  • Proactively asks questions and learns about our products.
  • Effectively multi-tasks and adapts to change.
  • Strong problem-solving and troubleshooting abilities.
  • Ability to work productively on various projects simultaneously.

Qualifications:

• Qualification B.E/MCA/MTech.

THE VERTAFORE STORY

Over the past 50 years Vertafore has advanced the entire insurance distribution channel with the best software solutions in the industry. Today were proud to say hundreds of thousands of Vertafore users rely on our solutions to write business faster reduce costs and fuel growth by increasing collaboration and streamlining processes. Vertafore leads the industry with secure cloud-based mobile products that provide superior reporting and analytics delivering actionable insight right when customers need it most. We partner with other leading technology companies to deliver comprehensive solutions to improve the way our customers do business and serve their customers.

The Vertafore Way

Insurance is about relationships and technology should make those relationships stronger. Thats why at Vertafore its our mission to transform the way the industry operates by putting people at the heart of insurance technology. By focusing on our customers becoming better every day and delivering results you can see we provide the level oftrustandsecuritythat insurance is all about.

Bias to Action:Were united by an innate drive to take action and make a difference in the technology and insurance spaces.

Win Together:We work together as one team showing empathy and respect along the way.

Show Up Curious:We work to challenge one another to push boundaries and think beyond the box.

Say It Do It:We honor every one of our commitments because integrity is important to us.

Customer Success is Our Success:We cultivate authentic relationships and follow up by actively listening to their needs.

We Love Insurance:We appreciate the impact insurance has on the world.

Is this role not an exact fit for you Keep an eye on ourCareers Pagefor other positions!

Vertafore conducts preemployment background screenings.

We do not accept resumes from agencies headhunters or other suppliers who have not signed a formal agreement with us.

Knowledge Skills and Abilities:

• • 4 - 5 years of experience in SQL Server database engineer
  • SQL Server Database Design & Architecture Programming
  • Strong performance tuning skills in a very large database environment
  • Ability to run trace reports and analyse results then to recommend options for problem resolution
  • Proficient with Transact-SQL (T-SQL)
  • Familiarity with SQL Server DTS/SQL Server SSIS packages
  • Expertise in scripting like PowerShell.
    Understanding of database installation and configuration
  • Understanding with database encryption and backup/recovery methodologies
  • Strong experience in SQL Server 2017 is a plus
  • Demonstrated desire and ability to learn technologies quickly
  • Possesses good oral and written communication skills.
  • Contributes to a positive team environment.
  • Enjoys finding and implementing solutions to new challenges.
  • Sets goals and focuses on results.
  • Proactively asks questions and learns about our products.
  • Effectively multi-tasks and adapts to change.
  • Strong problem solving and troubleshooting abilities.
  • Ability to work productively on various projects simultaneously.

Qualifications:

• Qualification B.E/MCA/MTech.

THE VERTAFORE STORY

Over the past 50 years Vertafore has advanced the entire insurance distribution channel with the best software solutions in the industry. Today were proud to say hundreds of thousands of Vertafore users rely on our solutions to write business faster reduce costs and fuel growth by increasing collaboration and streamlining processes. Vertafore leads the industry with secure cloud-based mobile products that provide superior reporting and analytics delivering actionable insight right when customers need it most. We partner with other leading technology companies to deliver comprehensive solutions to improve the way our customers do business and serve their customers.

The Vertafore Way

Insurance is about relationships and technology should make those relationships stronger. Thats why at Vertafore its our mission to transform the way the industry operates by putting people at the heart of insurance technology. By focusing on our customers becoming better every day and delivering results you can see we provide the level oftrustandsecuritythat insurance is all about.

Bias to Action:Were united by an innate drive to take action and make a difference in the technology and insurance spaces.

Win Together:We work together as one team showing empathy and respect along the way.

Show Up Curious:We work to challenge one another to push boundaries and think beyond the box.

Say It Do It:We honor every one of our commitments because integrity is important to us.

Customer Success is Our Success:We cultivate authentic relationships and follow up by actively listening to their needs.

We Love Insurance:We appreciate the impact insurance has on the world.

Is this role not an exact fit for you Keep an eye on ourCareers Pagefor other positions!

Vertafore conducts preemployment background screenings.

We do not accept resumes from agencies headhunters or other suppliers who have not signed a formal agreement with us.