Experience Inc. Jobs

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