Technical Lead - Database Engineer (SQL DBA)
IN-Hyderabad
- Apply
-
-
How Do You Want to Share?
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. Whether you’re interested in engineering or development, marketing or sales, or something else – if this sounds like you, then we’d love to hear from you!
We are headquartered in Denver, Colorado, with offices in the US, Canada, and India.
JOB DESCRIPTION
As a SQL Server Tech Lead Database Administrator, you will design, implement and administrator highly available systems in a 24/7 AWS environment. Our DBAs are responsible for the health, care and feeding of all databases used by Vertafore. 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. If you are a top-notch DBA 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 set: SQL Server
Secondary Skillset: PostgreSQL, MongoDB
- Create, maintain, and administer SQL Server databases on AWS and On-premises.
- Automation Mindset- required to have PowerShell, Python scripting and automation.
- Expertise in SQL performance tuning in MS SQL Server, Postgres, or Oracle
- Experience in working with AWS or Microsoft Azure
- Ensure the databases are highly secure, available, and recoverable.
- Proactively monitor and tune the databases for maximum performance.
- Install, configure, and patch database software and complete database migrations and upgrades.
- Support web application development, with a focus on helping the team interact with the database in the most efficient and productive way possible.
- Troubleshoot and solve database and application coding problems
- Deploy the database components for new versions of our web applications to test and production environments.
- Implement or advise on implementation of high availability (HA) and disaster recovery (DR) solutions especially SQL native replication along with CT and CDC technologies.
- specialized in transactional replication setup, monitoring and troubleshooting
- Perform SQL Server version upgrades.
- Perform SQL Server migrations from on- premises to cloud preferably on AWS
Knowledge, Skills and Abilities:
- 6 - 8 years of experience in SQL Server database administration
- 3+ years of experience in AWS database technologies
- Strong performance tuning skills in a very large database environment
- Ability to run trace reports and analyze results, then to recommend options for problem resolution
- Proficient with Transact-SQL (T-SQL) and PowerShell scripting
- Familiarity with SQL Server DTS/SQL Server SSIS packages
- Expertise in scripting like PowerShell.
- Expertise in SQL Server native replication topologies (Transactional and Merge replication) configuration and troubleshooting
- Expertise in CT/ CDC in SQL Server and provision monitoring tools for them
- Expertise in running very large clusters in a SAN environment
- Deep understanding of database installation and configuration
- Experience with database encryption and backup/recovery methodologies
- Familiarity with SQL Server Availability Groups in a Geo-redundant data center mode
- Strong experience in SQL Server 2017, 2019, 2022 is required
- 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.
Preferences:
· AWS Certified Database
· AWS Certified Solutions Architect
Why Vertafore is the place for you: *Canada Only
- The opportunity to work in a space where modern technology meets a stable and vital industry
- Medical, vision & dental plans
- Life, AD&D
- Short Term and Long Term Disability
- Pension Plan & Employer Match
- Maternity, Paternity and Parental Leave
- Employee and Family Assistance Program (EFAP)
- Education Assistance
- Additional programs - Employee Referral and Internal Recognition
Why Vertafore is the place for you: *US Only
- The opportunity to work in a space where modern technology meets a stable and vital industry
- Vertafore is a Flexible First working environment which allows team members to work from home as often as you’d like, while using our offices as a place for collaboration, community, and teambuilding. There are times you may be asked to come into an office and/or travel for specific meetings for a specific business purpose and this varies by job responsibilities.
- Medical, vision & dental plans
- PPO & high-deductible options
- Health Savings Account & Flexible Spending Accounts Options:
- Health Care FSA
- Dental & Vision FSA
- Dependent Care FSA
- Commuter FSA
- Life, AD&D (Basic & Supplemental), and Disability
- 401(k) Retirement Savings Plain & Employer Match
- Supplemental Plans - Pet insurance, Hospital Indemnity, and Accident Insurance
- Parental Leave & Adoption Assistance
- Employee Assistance Program (EAP)
- Education & Legal Assistance
- Additional programs - Tuition Reimbursement, Employee Referral, Internal Recognition, and Wellness
- Commuter Benefits (Denver)
The selected candidate must be legally authorized to work in the United States.
The above statements are intended to describe the general nature and level of work being performed by people assigned to this job. They are not intended to be an exhaustive list of all the job responsibilities, duties, skill, or working conditions. In addition, this document does not create an employment contract, implied or otherwise, other than an "at will" relationship.
Vertafore strongly supports equal employment opportunity for all applicants regardless of race, color, religion, sex, gender identity, pregnancy, national origin, ancestry, citizenship, age, marital status, physical disability, mental disability, medical condition, sexual orientation, genetic information, or any other characteristic protected by state or federal law.
The Professional Services (PS) and Customer Success (CX) bonus plans are a quarterly monetary bonus plan based upon individual and practice performance against specific business metrics. Eligibility is determined by several factors including: start date, good standing in the company, and actives status at time of payout.
The Vertafore Incentive Plan (VIP) is an annual monetary bonus for eligible employees based on both individual and company performance. Eligibility is determined by several factors including: start date, good standing in the company, and actives status at time of payout.
Commission plans are tailored to each sales role but common components include quota, MBO's and ABPMs. Salespeople receive their formal compensation plan within 30 days of hire.
Vertafore is a drug free workplace and conducts preemployment drug and background screenings.
We do not accept resumes from agencies, headhunters or other suppliers who have not signed a formal agreement with us.
We want to make sure our recruiting process is accessible for everyone. if you would like to contact us regarding the accessibility of our website or need assistance completing the application process, please contact recruiting@vertafore.com
Just a note, this contact information is for accommodation requests only.