Advanced SQL Database Administrator

ISN•Dallas, TX

2d•Hybrid

About The Position

The Advanced Database Administrator maintains ISN’s SQL Servers and databases in virtual machine-based and cloud-based environments, as well as Azure Cosmos DB. The role supports over 300 individual SQL Server databases in production for ISN’s large ASP.NET web applications and helps maintain uptime across application environments. Responsibilities also include migrating IaaS-based workloads and systems to PaaS/SaaS, supporting development-team deployments, and responding to requests from the ISN Products team for database tuning, optimization, and other support. The role is based near ISN’s Dallas, Texas office. Employees must live within commuting distance; relocation is required for candidates who are not already local to the Dallas–Fort Worth area. In-office attendance is required up to twice per week during the first 90 days. After that period, remote work is an option, with at least one in-person engagement each month.

Requirements

Bachelor’s degree in Computer Science or a related field from an accredited university and/or equivalent work experience.
At least 3 years of experience troubleshooting SQL Server availability issues related to clustering, Always On, and SQL replication.
At least 3 years of experience managing SQL jobs, including database maintenance jobs such as backups and index maintenance.
At least 1 year of experience administering SQL Server on Azure Virtual Machines.
At least 1 year of experience administering and supporting Azure Cosmos DB, Azure SQL Database, and Azure SQL Managed Instance, ensuring reliability, performance, and security.
Experience managing SQL Servers using PowerShell.
Strong knowledge of high-availability and data-movement technologies, including Always On Availability Groups, Change Data Capture, SQL replication, and SQL clustering, as well as disaster recovery concepts such as RPO/RTO.
Must be within commuting distance of the Dallas, Texas office or relocate to the Dallas–Fort Worth area.
Successful completion of a drug screen and background check is required for all job offers.

Nice To Haves

Azure certifications are strongly preferred, including AZ-900 and DP-300.

Responsibilities

Maintain, monitor, and manage SQL Server databases across all application environments.
Troubleshoot availability issues involving Windows Server clustering, SQL Server on Virtual Machines, Azure SQL Managed Instances, Always On Readable Secondaries, Always On Availability Groups, SQL replication, and SQL Failover Groups.
Troubleshoot database performance, locking, and blocking issues involving SQL Server databases, tempdb, and 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 and alert responses using PowerShell, SQL, .NET, or other tools.
Support development-team deployments and respond to requests for database tuning, optimization, and other database support.
Help maintain uptime for ISN’s application environments.

Benefits

Company-paid monthly insurance premiums for employees and dependents: medical, dental, vision, and life insurance.
Employee assistance program.
4% retirement matching.
Long-term and short-term disability coverage.
Paid time off, ranging from 15 to 30 days based on tenure, with first-year time off prorated.
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 a community volunteer day.
Matching charitable gift program.
Professional development and training opportunities.
Wellness program focused on community, financial, mental, nutrition, physical, and social health.
Business-casual dress; jeans are allowed.