Lead SQL DBA

Overview

Hybrid
$120,000 - $130,000
Full Time
No Travel Required

Skills

Backup Administration
Microsoft SQL Server
Performance Tuning
Performance Monitoring
Migration
Database Administration
Database Migration
Database Performance Tuning
Microsoft SSIS
Microsoft SSRS
Management
SQL

Job Details

NOTE: Prefer candidates within commutable distance from Princeton, NJ

Job Description
As an MS SQL Administrator (Level 3), responsibility includes overseeing the administration, configuration, and maintenance of MS SQL Server databases. The role encompasses ensuring optimal performance, security, and reliability in both environments, collaborating closely with the IT team to meet business requirements.

Key Responsibilities:
Administer and maintain MS SQL Server databases, including installation, configuration, backup, recovery, and troubleshooting.
Perform regular database maintenance tasks such as index maintenance, database optimization, and query tuning to ensure optimal performance.
Monitor MS SQL Server performance and resource utilization, identifying and resolving performance bottlenecks.
Implement and maintain database security measures, including user access controls, encryption, and data masking.
Plan and execute MS SQL Server upgrades, patches, and migrations, minimizing downtime and disruptions to business operations.
Collaborate with application developers to design and implement database solutions that meet business requirements.
Provide technical support and troubleshooting assistance to users and developers, resolving database-related issues in a timely manner.

Technical expertise (MS SQL):
10+ years of experience in MS SQL administration
Experience with SQL Server features such as AlwaysOn Availability Groups, Database Mirroring, and Log Shipping.
Proficiency in SQL Server Performance Tuning and Query Optimization techniques.
Familiarity with SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), and SQL Server Analysis Services (SSAS).
Knowledge of database migration tools and techniques for seamless data movement between environments.
Experience with database security auditing and compliance requirements, including GDPR, HIPAA.
Understanding of database backup and recovery strategies, including full, differential, and transaction log backups.

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.