What are the responsibilities and job description for the Sr. Database Engineer position at Vertafore Career Center?
$120000 - $135000 / year
Vertafore is a leading technology company whose innovative software solutions 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 Sr. Database Engineer, you will be responsible for database engineering, administration, design, development, and support applications available systems. You will be responsible for continuously enhancing the automation process of the database and should have an interest in DevOps to help us improve our software engineering practices. You will be required to work closely with multiple stakeholders in order to understand their database needs. After understanding their needs, you will make recommendations and provide self-services offerings that will allow stakeholders to deploy, monitor, and maintain the correct databases for their business.
You will work with fast-paced, skilled team of engineers and developers across multiple high-profile projects. You will also participate in IT projects from inception of the project up and through the daily maintenance phase of a project. You should have good understanding of cloud concepts. If you are a top-notch Database Administrator and looking for the next challenge, apply now!
Core Requirements and Responsibilities:
Essential job functions included but are not limited to the following:
Primary Skill - SQL Server DBA: Secondary Skill – PostgreSQL, MongoDB DBA
· Required: Experience with SQL Server database administration, deployments on on-premises and Cloud infrastructure preferably on AWS
· Collaborate on Database Automation activities to improve process efficiency and risk compliance
· Drive Stability initiatives by proactively reviewing and addressing Database performance and capacity trends
· Configure and administer database replication between servers, across Local Area Network and Wide Area Network for high availability and disaster recovery.
· Determine the most effective way to increase performance including hardware purchases, server configuration changes, or index/query changes.
· Ensure centralized 24x7 Database Monitoring and Auditing Tools in place and effective in operation
· Resolve complex problems by investigating and devising solutions for database operations. May include installations, configuration, tuning, identifying/resolving complex query bottlenecks and maintenance of database management
· Identify ways to improve data platform, solutions to complex problems; effectively propose paths forward to drive outcomes.
· Hands-on end-to-end Database Development encompassing Database Design and Development working with cross-functional teams.
· Should be able to debug application code written in PL SQL and T SQL for different applications.
· Develop automation frameworks (Infrastructure as code, CI/CD pipelines) and tooling that will be consumed by the entire engineering organization.
· Understand the business priorities and requirements; architect/develop solutions to meet the business need and lead execution.
· Work as an individual contributor and collaborate with multiple teams/vendors/consultants in an effective manner.
· Advanced knowledge in Transactional Replication, Clustering, SQL Always-on
· Experience with High Availability (HA) and Disaster Recovery (DR) options for SQL Server
· Experience in infrastructure automation through Powershell, Terraform, Chef, Ansible, Puppet or other automation tool is highly advantageous
Salary : $120,000 - $135,000
