Job Description: MS SQL Server Analyst / Administrator

The MS SQL Server Analyst / Administrator is responsible for building, configuring, maintaining, and supporting SQL Server database environments and underlying database systems. This role includes server installations, database configuration, performance monitoring, record locking management, transaction logging, troubleshooting, and ensuring system stability, security, and availability.

Key Responsibilities:

• Build, configure, and maintain Microsoft SQL Server database servers and environments.

• Manage database installations, configurations, upgrades, and system maintenance.

• Monitor server performance, system resources, disk utilization, and database activity.

• Analyze and troubleshoot record locking, blocking, deadlocks, and concurrency issues.

• Monitor and manage SQL Server transaction logs, error logs, and system logging.

• Configure and maintain database backups, restores, and recovery procedures.

• Monitor database health, job schedules, alerts, and automated maintenance processes.

• Identify and resolve database performance and system-related issues.

• Manage database security, user accounts, roles, and access permissions.

• Support server builds, migrations, database deployments, and infrastructure changes.

• Monitor system processes and ensure database services remain available and reliable.

• Maintain technical documentation, system configurations, and operational procedures.

• Collaborate with infrastructure, application, and development teams to resolve technical issues.

Required Technical Skills:

• Microsoft SQL Server installation, configuration, and administration.

• SQL Server Management Studio (SSMS) and T-SQL.

• Windows Server environments and server configuration.

• Database locking, blocking, deadlock analysis, and performance tuning.

• Transaction log management and SQL Server error log analysis.

• Backup and recovery, database maintenance, and disaster recovery.

• SQL Server Agent jobs, monitoring, and alert management.

• Knowledge of CPU, memory, storage, disk I/O, and system resource utilization.

• Troubleshooting database, server, and application connectivity issues.

Overall Objective:

Ensure SQL Server database servers and supporting systems are properly built, configured, monitored, and maintained. Maintain optimal system performance, minimize downtime, proactively identify and resolve locking and logging issues, and ensure the reliability, availability, and security of enterprise database environments.