Advanced SQL Database Administrator

ISN; Dallas (TX); Hybrid; USD 120,000 - 160,000; Full time

Benefits offered by this job

100% company-paid premiums

4% retirement matching

PTO 15–30 days

13 paid holidays

Cell phone reimbursement

Parking or DART reimbursement

Team events & volunteering

Job summary

ISN is seeking an Advanced Database Administrator to maintain SQL Server databases across production and cloud environments, including Azure Cosmos DB and Azure SQL services. The role supports development deployments, tuning requests, and uptime assurance for ISN’s web applications.

Requirements include a CS degree, Azure certs, and 3+ years in SQL Server availability, backups, and job management, with 1+ year on Azure VMs and Cosmos DB/Managed Instances.

Qualifications

• Bachelor's degree in Computer Science or related field
• Azure certifications are strongly preferred (AZ-900, DP-300)
• 3+ years troubleshooting SQL Server availability issues (Always On, clustering, replication)
• 3+ years managing SQL jobs (backups, index maintenance)
• 1+ years administering SQL Server on Azure Virtual Machines
• 1+ years administering Azure Cosmos DB/Azure SQL Database/Managed Instance
• 1+ years managing SQL Servers using PowerShell
• Strong knowledge of high availability, data movement technologies, and disaster recovery concepts (RPO/RTO)

Responsibilities

• Maintain, monitor, and manage SQL Server databases across environments
• Troubleshoot availability issues related to clustering, Always On, replication, and Failover Groups
• Diagnose performance, locking, blocking, tempdb, and resource contention in SQL Server
• Manage SQL Server jobs and Windows scheduled tasks
• Perform safe upgrades and migrations for IaaS-based SQL Servers
• Automate tasks and alerts using PowerShell, SQL, or .NET

Skills

Troubleshooting SQL Server

SQL jobs management

Azure SQL on VM

Cosmos DB & Azure SQL DB

PowerShell

HA/Disaster recovery

Education

Bachelor's degree in Computer Science or related field

Azure certifications (AZ-900, DP-300)

Tools

Azure Cosmos DB

Azure SQL Database

Azure SQL Managed Instance

SQL Server Management/Automation

Job description

Our Company:

ISN was established in 2001 and is a global leader in contractor and supplier management. We work closely with a variety of household-name clients in the US, Canada, Europe, Australia, Latin America, and the Middle East to connect them with safe and reliable contractors and suppliers and incorporate a level of due diligence in the contractor management process.

The Position:

The Advanced Database Administrator is responsible for maintaining ISN’s SQL Servers and SQL Databases (both virtual machine-based and cloud-based), Azure Cosmos DB, migrating IaaS-based workloads and systems to PaaS/SaaS, helping development teams with deployments, and helping maintain uptime for ISN’s application environments. ISN has multiple large web applications written in ASP. Net, and the DBA team supports over 300 individual SQL Server databases in Production environments. This position is responsible for maintaining the environment, supporting and maintaining the SQL Server databases, and promptly responding to the ISN Products team’s requests for tuning, optimization, and other database support.

Who should apply?

• Bachelor’s degree in Computer Science or related field from an accredited university and/or equivalent work experience
• Azure certifications are strongly preferred (AZ-900, DP-300)
• 3+ years of experience in troubleshooting SQL Server availability issues related to clustering, Always On, SQL replication
• 3+ years of experience managing SQL jobs, including database maintenance jobs (backups, index maintenance)
• 1+ years of experience in administering SQL Server on Azure Virtual Machines
• 1+ years of experience in administering and supporting Azure Cosmos DB, Azure SQL Database, Azure SQL Managed Instance, and, ensuring reliability, performance, and security.
• 1+ years managing SQL Servers using Powershell
• Strong knowledge of high availability and data movement technologies such as AlwaysOn Availability Groups, Change Data Capture, SQL Replication, SQL Clustering, along with disaster recovery concepts (RPO/RTO).

Primary Duties & Responsibilities

• Maintain, monitor, and manage the SQL Server databases in all application environments
• Troubleshoot availability issues related to clustering on Windows Server, SQL Server on Virtual Machines, Azure SQL Server Managed Instances, AlwaysOn Readable Secondaries, AlwaysOn Availability Groups, SQL replication, SQL Failover Groups
• Troubleshoot performance, locking, and blocking issues within SQL Server databases, tempdb, virtual machines
• Proactively and reactively resolve database performance and capacity issues, including managing indexes, SQL trace data, Extended Events, audits, and alerting
• Manage SQL Server jobs and Windows scheduled tasks
• Perform safe upgrades and migrations for IaaS-based SQL Servers
• Automate routine tasks, alert response using PowerShell, SQL, .NET, or other tools

Job Location:

3232 McKinney Ave Ste 1500, Dallas, TX 75204.

• Employees must be within a commutable distance to the Dallas, TX office. Relocation is required for candidates not already local to the DFW area.
• In-office attendance up to two times per week for the first 90 days of employment.
• After 90 days completion, you will have an option to work remotely with at least 1 in-person engagement required monthly (team collaboration day, ISN events, team events, performance reviews, etc.).

ISN Benefits*

• 100% company-paid monthly insurance premiums for employees and dependents
  • Medical, Dental, Vision, and Life Insurance
• Employee assistance program
• 4% retirement matching
• Long-Term & Short-Term Disability Coverage
• Paid time off
  • 0-1 year – 15 day (pro-rated first year)
  • 1-5 years – 20 days
  • 5-10 years – 25 days
  • 10+ years – 30 days
• Holidays – 13 paid holidays
• Monthly cell phone reimbursement
• Complimentary parking space or monthly reimbursement for DART public transportation
• Team-building activities and events, including quarterly kick-off meetings and community volunteer day
• Matching charitable gift program
• Professional development & training opportunities
• Wellness Program: Focuses on community, financial, mental, nutrition, physical and social health
• Business casual, jeans allowed
• All benefits are subject to change with notice to the employee

All job offers will be contingent on successful completion of a drug screen and background check.

ISN is an equal opportunity employer. All applicants will be considered for employment without attention to race, color, religion, sex, sexual orientation, gender identity, national origin, veteran or disability status.