SQL Database Administrator

Posted 3hrs ago

Employment Information

Education
Salary
Experience
Job Type

Report this job

Job expired or something wrong with this job?

Job Description

Senior SQL Server DBA managing AmeriSave’s high-volume mortgage-finance database platform. Improving reliability, performance, observability, security, and production support across on-premises and Azure environments.

Responsibilities:

  • Manage SQL Server databases on-premises and in Azure cloud environments (IaaS/PaaS)
  • Recommend short-term and long-term strategic plans for database infrastructure
  • Define and propose policies, procedures, and maintenance plans for DBMS resource administration
  • Configure and maintain database servers and processes
  • Monitor system health and performance
  • Ensure high levels of performance, availability, sustainability, and security
  • Analyze, solve, and correct issues in real time
  • Provide suggestions for solutions
  • Refine and automate regular processes, track issues, and document changes
  • Assist developers with query tuning and schema refinement
  • Provide 24x7 support for critical production systems
  • Perform scheduled maintenance and support release deployment activities after hours
  • Participate in an off-hours production support call rotation

Requirements:

  • 7+ years of experience as a SQL Server DBA
  • SSIS, SSAS, and SSRS administration
  • Experience with Performance Tuning and Optimization
  • Database stored procedure, trigger, and index creation and tuning
  • Experience with backups, restores and recovery models
  • Experience of High Availability (HA) and Disaster Recovery (DR) options for SQL Server
  • Experience supporting a development team in a production environment
  • Strong troubleshooting with SQL Server Profiler, Database Engine Tuning Advisor, Performance Monitor, and Query Store
  • Failover Clustering (Always On: FCI & AG) design and configuration
  • High-speed internet required for remote work, Cable or Fiber ONLY with the ability to connect via Ethernet
  • Minimum internet speeds: 70/30 Mbps (basic), 200-300/35-70 Mbps (shared), 500-1,000/100+ Mbps (heavy use)
  • Experience with Azure SQL, preferred
  • Experience with Foglight, Redgate, and other SQL Server 3rd party tools, preferred
  • Certifications are a plus

Benefits:

  • 401(k)
  • Dental insurance
  • Disability insurance
  • Employee discounts
  • Health insurance
  • Life insurance
  • Paid time off
  • 12 paid holidays per year
  • Paid training
  • Referral program
  • Vision insurance
  • Referral bonuses