Job Summary
We are seeking an experienced SQL Database Administrator (SQL DBA) to manage, optimize, and support enterprise Microsoft SQL Server environments. The ideal candidate will have strong expertise in SQL Server administration, database performance tuning, T-SQL optimization, high availability solutions, and troubleshooting. Experience working closely with application development teams in enterprise environments is highly preferred.
Key Responsibilities
Analyze and optimize T-SQL queries for improved database performance.
Review execution plans and leverage Query Store to identify and enforce optimal execution plans.
Perform index maintenance, including statistics updates and index rebuilds.
Design and manage table and index partitioning strategies.
Investigate database blocking, deadlocks, and perform impact analysis.
Optimize stored procedures and ad-hoc SQL queries based on execution patterns and performance metrics.
Collaborate with application development teams to improve database efficiency and application performance.
Install, configure, upgrade, and maintain Microsoft SQL Server (2016/2017/2019/2022).
Apply cumulative updates (CUs), patches, and service packs.
Manage database storage, capacity planning, and volume space utilization.
Monitor database health, performance, availability, and scalability.
Administer SQL Server Always On Availability Groups and Replication.
Monitor CPU, memory, disk utilization, and TempDB performance.
Manage database security, user roles, permissions, and access controls.
Administer SQL Server Agent jobs and SSIS packages.
Troubleshoot database performance issues and implement proactive solutions.
Required Skills
Strong experience with Microsoft SQL Server Administration (2016/2017/2019/2022).
Expertise in T-SQL query tuning and performance optimization.
Experience analyzing execution plans and using Query Store.
Knowledge of index optimization, statistics maintenance, and partitioning.
Experience with Always On Availability Groups and SQL Server Replication.
Strong understanding of database performance monitoring and troubleshooting.
Experience managing SQL Server Agent Jobs and SSIS.
Knowledge of database security, backup/recovery, and disaster recovery best practices.
Experience working in application development environments.
Preferred Skills
Operational knowledge of:
SolarWinds
SolarWinds Database Performance Analyzer (DPA)
Dynatrace (API and database call tracing)
Qualifications
Bachelor's degree in Computer Science, Information Technology, or a related field (or equivalent experience).
Strong analytical, troubleshooting, and problem-solving skills.
Excellent communication and collaboration abilities.
Since 1996, RJT has provided successful SAP, Oracle, and IT consulting solutions and staffing services to clients around the world. The new Apolis brings you the same personalized service fortified with a greater array of IT solutions, global expertise, and cost-management strategies.
We are a global IT consultancy that seamlessly integrates experts and leading-edge solutions into your organization so you can focus on what really matters.
Skills
Access Controlunmatched
Analysis Skillsunmatched
Application Programming Interface (API)unmatched
Best Practicesunmatched
CPU (Central Processing Unit)unmatched
Capacity Managementunmatched
Communication Skillsunmatched
Computer Scienceunmatched
Data Recoveryunmatched
Database Administrationunmatched
Database Analysisunmatched
Database Backupunmatched
Database Replicationunmatched
Disaster Recoveryunmatched
High Availabilityunmatched
Identify Issuesunmatched
Information Technology & Information Systemsunmatched
Information/Data Security (InfoSec)unmatched
Memory Hardwareunmatched
Microsoft SQL Serverunmatched
Microsoft SQL Server DBA (Database Administration)unmatched
Microsoft Transact-SQL (T-SQL)unmatched
Performance Analysisunmatched
Performance Managementunmatched
Performance Metricsunmatched
Performance Tuning/Optimizationunmatched
Problem Solving Skillsunmatched
Replication and Remote Mirroringunmatched
SQL (Structured Query Language)unmatched
SQL Databasesunmatched
SQL Server Integration Services (SSIS)unmatched
Security Monitoringunmatched
Software Developmentunmatched
Software Patchesunmatched
Statisticsunmatched
Stored Proceduresunmatched
Systems Administration/Managementunmatched
Team Playerunmatched
Volume Planningunmatched
🎯
Be found by employers
5,500+ employers search our resume database daily. Add yours to get found by recruiters looking for candidates like you.
Level up your application
Professional resume templates
Browse dozens of recruiter approved resume templates, layouts and formats. Choose your favorite and make it your own in minutes.