L2 SQL Server Database Engineer

AgreeYa Solutions • Phoenix, AZ

21d • Onsite

About The Position

AgreeYa is a global Systems Integrator and is seeking an experienced SQL Server Database Engineer to join our growing team. This role requires a skilled professional to provide comprehensive SQL Server support and ensure high availability for mission-critical systems. The Database Engineer will play a key part in maintaining performance, capacity, and compliance while participating in cloud migration and modernization projects.

Requirements

• 7+ years of experience with SQL Server Technologies.
• 3+ years working specifically with MS SQL Server 2016 and 2017.
• Solid experience in performance tuning, troubleshooting, and optimizing database systems.
• Experience supporting databases in production and non-production environments, including resolving deadlocks, blocking, memory, CPU, and I/O issues.
• Proficient in configuring and maintaining HADR solutions (Always On, Mirroring, Replication).
• Hands-on experience with Azure cloud migration for databases.
• Strong analytical and incident management skills in complex SQL Server environments.

Nice To Haves

• Experience managing databases ranging from 10GB to 5TB (VLDB).
• Familiarity with database diagnostic and compliance management tools.
• Exposure to capacity planning and automation of DBA activities.

Responsibilities

• Provide database platform-level support for MS SQL Server environments.
• Manage databases at the infrastructure level, including patching, upgrades, and participation in DR exercises.
• Monitor and troubleshoot SQL Server systems, quickly resolving infrastructure and production issues.
• Establish and maintain high availability and disaster recovery (HADR) solutions using technologies such as Always On and Mirroring.
• Coordinate and resolve database access requests, incidents, and compliance remediation tasks.
• Analyze and report on database operational performance in relation to key metrics.
• Implement and maintain SQL maintenance jobs and backup/recovery strategies.
• Participate in database cloud migration (Azure PaaS & IaaS) initiatives.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Number of Employees: 1,001-5,000 employees