Overview
Hybrid
$120,000 - $130,000
Full Time
Skills
MySQL
MS SQL
Job Details
As an MS SQL Administrator (Level 3), responsibility includes overseeing the administration, configuration, and maintenance of both 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):
- 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,
- 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.