Advanced SQL Database Administrator

ISN Software Corporation•Dallas, TX

3d•Hybrid

About The Position

The Advanced Database Administrator maintains ISN’s SQL Servers and SQL databases, including virtual machine-based and cloud-based environments, and Azure Cosmos DB. The role supports migration of IaaS-based workloads and systems to PaaS/SaaS, assists development teams with deployments, and helps maintain uptime for application environments. ISN’s DBA team supports more than 300 individual SQL Server databases in production across multiple large ASP.NET web applications. The position maintains the database environment and responds to the ISN Products team’s requests for database tuning, optimization, and other support. The role is based at ISN’s Dallas, Texas office, and employees must live within commuting distance. Candidates who are not local to the DFW area must relocate. In-office attendance is required up to twice weekly for the first 90 days. After completing that period, employees may work remotely, with at least one in-person engagement required 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.
At least 1 year of 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; relocation is required for candidates not already local to the DFW area.
Successful completion of a drug screen and background check is required for a job offer.

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 performance, locking, and blocking issues within SQL Server databases, tempdb, and virtual machines.
Resolve database performance and capacity issues proactively and reactively, 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 response using PowerShell, SQL, .NET, or other tools.
Support development teams with deployments and respond to requests for tuning, optimization, and other database support.
Help maintain uptime for ISN’s application environments.

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 and short-term disability coverage.
Paid time off, ranging from 15 to 30 days based on tenure, with first-year time 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.