SQL Database Administrator

SQL Database Administrator Job Description Template

Our company is looking for a SQL Database Administrator to join our team.

Responsibilities:

  • Perform scheduled maintenance and support release deployment activities after hours;
  • Refine and automate regular processes, track issues, and document changes;
  • Share domain and technical expertise, providing technical mentorship and cross-training to other peers and team members;
  • Provide 24×7 support for critical production systems;
  • Manage SQL Server databases through multiple product lifecycle environments, from development to mission-critical production systems;
  • Independently analyze, solve, and correct issues in real time, providing problem resolution end-to-end;
  • Apply data modeling techniques to ensure development and implementation support efforts meet integration and performance expectations;
  • Assist developers with complex query tuning and schema refinement;
  • Support of production environment;
  • Replication setup/maintenance;
  • Identify pain points and bottlenecks and recommend solutions;
  • Database Mirroring and database level High Availability;
  • Data Modeling;
  • Documentation, Scripting, Writing complex Stored Procedures;
  • Analysis of database performance and performance tuning.

Requirements:

  • Experience developing and working with MS BI Stack tools such as SSRS, SSIS and SSAS a plus;
  • Experience with Performance Tuning and Optimization (PTO), using native monitoring and troubleshooting tools;
  • Ability to work in a rapidly changing environment;
  • 5+ years MS SQL Server Administration experience required;
  • MCTS, MCITP, and/or MVP certifications a plus;
  • Flexible, team player, “get-it-done” personality;
  • Experience writing Stored Procedures, Queries, Tuning, Scripts;
  • Experience with Data Modeling and High Availability;
  • Prior military experience preferred;
  • 5+ years of SQL server database administration expertise;
  • Strong experience with Extract,Transform& Load (ETL) design and operations, such as, SQL Server Integration Services (SSIS);
  • Experience in a Windows 2008 / Windows 7 /Windows 2012 +Windows 2016 development environment;
  • Any oracle database administration knowledge would be nice to have;
  • Informatica ETL experience is highly desired;
  • Experience with virtual environments and clustered environments.