What are the responsibilities and job description for the DFA Sr. SQL DBA position at Hmsnt?
-Positionis available for extensions.
-NOTE: Some SQL shops have multiple members with each member performing specific functions. This position requires candidates that have recent experience in ALL aspects of SQL DBA Administration.Performing routine database maintenance
o Rebuilding indexes
o Consistency checks
SQL Server native tools and services
o Index Tuning Advisor
o Extended Events
o Dynamic Management View
o Linked Servers
o SQL Server System Databases
o SQL Server Health Checks and Policies
o User security
o Authentication methods
o Encryption at rest, transit, and backup
o Maintaining and managing SQL Serverdisk space to ensure storage is properly utilized
o Managing disk storage for WindowsFailover Cluster Service (WFSC)
o Establishing standards and schedulesfor database backups
o Restoring databases with point in timerecovery
Proficient in TSQL coding, tuning, and ETL methodologies
o Mirroring
Building and maintaining Windows Host and Guest Servers
Nessus configuration and vulnerability scans
Utilizing PowerShell for administration tasks
Windows Server Roles and Features
Familiarity with industry security standards (PUB1075, FIPS, and PII)
- F5 administration
SAN, RAID Controller, and other storage device maintenance knowledge
Email, SMTP, and Proxy Server troubleshooting
Availability to provide 24 hour support