ECS is seeking a
SQL Database Admin (Intermediate) to work in our
Pittsburgh, PA office.
Please Note: This position is contingent upon contract award.
ECS is seeking a qualified SQL Database Admin (Intermediate) to support transformative science and technology solutions for the Department of Energy.
Job Description
The DBA will work across two agile scrum teams, one for SharePoint and one of Dynamics, to maintain the health of the environment and complete various customer ticket requests at the database level. This will include patching, monitoring, maintenance, customer requests and reports, and keeping up the health of the farm. The DBA will participate in various scrum and security meetings as well as be prepared to provide solutions and track work.
Duties
- Manage Availability Groups (i.e. Add/Remove db's, ensure primary/secondary are synced)
- Backup/Restore databases between SQL Clusters
- Monitor Backup jobs and restart if necessary
- Optimize SQL cluster performance and DBs
- Monitor DB/Log Disk Space and Ensure DB Auto-Growth Settings are Optimized
- Create New SQL Cluster Nodes and Manage them in related Availability Groups
- Be familiar with optimizing SQL Server for a SharePoint environment
- Be familiar with automation concepts as it related to SQL Server and Database Management in Azure