SQL DBA with LifePro with Life Insurance - Domain Remote

ESR Healthcare; United States; Remote; USD 90,000 - 130,000; Full time

Job summary

An established industry player is seeking a seasoned SQL DBA with extensive experience in managing SQL Server databases. This role involves ensuring optimal performance, security, and availability of databases while implementing effective backup and recovery strategies. You will utilize advanced diagnostic tools and collaborate with development teams on database design. If you thrive in fast-paced environments and have a passion for database management, this opportunity is perfect for you to make a significant impact in a dynamic organization.

Qualifications

• 10+ years of SQL Server DBA experience with strong T-SQL and PowerShell skills.
• Proficient in SQL Server management tools and performance tuning.

Responsibilities

• Manage SQL Server databases ensuring performance, security, and availability.
• Implement backup and recovery strategies using SQL Server tools.

Skills

SQL Server DBA Experience

T-SQL

PowerShell

Performance Tuning

Security Management

Communication Skills

Education

BS/BA in a related technical discipline

Tools

SQL Server Management Studio

Visual Studio

DTS/SSIS

SQL Profiler

Job description

SQL DBA with LifePro Experience - Domain Remote

Job Responsibilities:

• Manage SQL Server databases, ensuring performance, security, and availability.
• Implement and maintain backup, recovery, and archival strategies using native SQL Server tools.
• Utilize diagnostic and maintenance tools such as DBCC, SQLDiag, SQL Profiler, and third-party diagnostics.
• Design and manage partitioning architecture.
• Handle multiple processing schedules and notification strategies.
• Develop and optimize T-SQL scripts, PowerShell scripts, and perform tuning and debugging.
• Manage SQL Server replication and mirroring.
• Implement security and access strategies for diverse user groups.
• Collaborate with development and infrastructure teams on database design and changes.
• Understand and implement high availability and disaster recovery solutions.

Job Requirements:

• Minimum 10+ years of SQL Server DBA experience.
• Experience with SQL Server versions 2005, 2008, and 2012, with knowledge of benefits of newer versions.
• Experience in database data management, including backups, ETL, and archiving.
• Proficiency with SQL Server management tools such as SQL Server Management Studio, Visual Studio, DTS/SSIS, Profiler, and command-line utilities.
• Strong skills in T-SQL, DOS, PowerShell, and performance tuning.
• Experience with security/access management for varied user groups.
• Excellent communication and interpersonal skills.
• Ability to work under pressure, prioritize tasks, and work independently.
• Adaptability to fast-paced environments.
• Understanding of high availability and disaster recovery requirements.

Preferred Qualifications:

• Microsoft Certified Database Administrator (MCDBA) or higher certifications on SQL Server 2005, 2008, or 2012.
• Experience in data modeling and metadata management.

Education:

BS/BA degree in a related technical discipline.