Note: The job is a remote job and is open to candidates in USA. ISN is hiring an Advanced Database Administrator to maintain its SQL Server databases and Azure database environments, migrate IaaS workloads to PaaS/SaaS, and support application deployments and uptime. The role also provides database tuning, optimization, and support to development and product teams.
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
Skills
- Bachelor's degree in Computer Science or related field from an accredited university and/or equivalent work experience
- 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)
- Azure certifications are strongly preferred (AZ-900, DP-300)
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 days (pro-rated first year); 1-5 years – 20 days; 5-10 years – 25 days; 10+ years – 30 days
- 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 focused on community, financial, mental, nutrition, physical and social health
- Business casual; jeans allowed
- After 90 days of employment, option to work remotely, with at least 1 in-person engagement required monthly
Company Overview