The Database Administrator is responsible for data analysis and database management. Database Administrators typically are involved in maintenance, enhancement, designing of data dictionaries, physical and logical database models, and performance tuning. Database Administrators have a range of skills and knowledge of the utilities and production tools used for data storage management to support the Application Team. 

Specifically, this position will aid the delivery of database platforms and work on enhancing the team’s readiness to manage SQL Server. 

The person in this role will perform project-specific activities such as: 

• Add and manage data for the SQL Server inventory for PostGres. 
• Evaluate databases and identify those with special security considerations, external components, SQL Agent Jobs, etc. and notify L&I DBA for a remediation plan 
  
• Assist in testing changes and application deployments 
  
• Communicate effectively verbally and in writing with regular status reports 
  
• Perform routine SQL Server Administration and Maintenance Tasks 
  
• Migrate databases from development and production environments 
  
• Evaluate and identify database performance issues and outline opportunities for improvement 
  
• Ensure migrated databases are successfully, backed up and maintain backup documentation 
  
• Respond to events and incidents updating documentation and response 
  

SKILL / REQUIRED – DESIRED / NUMBER OF YEARS 

• General SQL Server Database Administration Required – 3 Years. 
• Coordinate technical and administrative/project management activities is Highly desired – 3 Years. 
• Evaluation of database operating conditions for agency compliance is Highly desired – 3 Years.