AT&T has flagged the Senior Applications DBA (Database and Application Administration) job as unavailable. Let’s keep looking.

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
Confirmed 8 hours ago. Posted a month ago.

Discover Similar Jobs

Suggested Articles