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
Skills & RequirementsKnowledge, Skills and Abilities:
- 5 - 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
Read Full Description