Microsoft SQL Server Database Analyst / Admin

Information Consulting Services; Atlantic City (NJ); On-site; USD 90,000 - 150,000; Full time

Job summary

Information Consulting Services in Atlantic City, NJ is seeking a Microsoft SQL Server Database Analyst/Administrator for onsite, full-time engagement. ASAP start. U.S.

Citizens Only. Responsible for building, configuring, and maintaining SQL Server environments across servers, databases, and related services. The role focuses on performance tuning, monitoring, and proactive maintenance, including backups, disaster recovery, and security management.

Qualifications

• Experience installing, configuring, and administering MS SQL Server.
• Strong knowledge of SSMS and T-SQL.
• Experience with backups, restores, and disaster recovery planning.

Responsibilities

• Build, configure, and maintain SQL Server database servers and environments.
• Monitor performance, system resources, disk utilization, and database activity.
• Analyze and troubleshoot locking, blocking, deadlocks, and concurrency issues.
• Monitor and manage transaction logs, error logs, and system logging.
• Configure and maintain backups, restores, and recovery procedures.
• Monitor health, jobs, alerts, and automated maintenance processes.
• Ensure security, user accounts, roles, and access permissions.
• Collaborate with infrastructure, application, and development teams.

Skills

SQL Server installation and admin

SSMS & T-SQL

Windows Server administration

Performance tuning

Backup and disaster recovery

Job scheduling and alerts

Security and access control

Tools

SSMS

T-SQL

Job description

Microsoft SQL Server Database Analyst / Administrator

Atlantic City, NJ (Onsite – 5 Days/Week)

Full-Time / Direct Hire

ASAP

U.S. Citizens Only

Overview

Job Description: MS SQL Server Analyst / Administrator

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.
• 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.