What are the responsibilities and job description for the SENIOR SQL DATABASE ADMINISTRATOR position at Johnson Technology Systems Inc?
Position Requirements:
This position is for a Microsoft SQL Server database administrator. The successful candidate will maintain SQL Server database environments in an enterprise environment consisting of approximately 800 Windows servers. This position will be responsible for development and sustainment of Windows Server 2012 database clusters and migration of various disparate SQL Server environments onto new clusters. The successful candidate will also standardize, consolidate, and optimize the existing SQL Server environments and monitor and maintain database performance. The successful candidate will also adhere to ITIL (Information Technology Infrastructure Library) practices for Change Management, collaborate with internal and external customers to gather requirements for special processing, and work and track issues to resolution using an in-house ticket system.
- Responsible for design, installation, configuration, security, and maintenance of highly available enterprise database systems
- Monitor backup jobs on all enterprise databases and perform routine disaster recovery scenarios
- Troubleshoot and maintain database performance, including the proposal of short term fixes, long term solutions, and the regular scheduling of index maintenance and database integrity checks
- Establish and maintain database policies and standards
- Generate database schema definitions and modifications as required
- Refresh data from one environment to another at the request of the application development staff
- Develop, follow, and maintain in-house documentation for repeatable processes, including database feature installation, disaster recovery, and common problem resolution
- Follow ITIL (Information Technology Infrastructure Library) practices for Change Management
Required skills:
- Ten or more years of experience with SQL Server Enterprise Edition and all facets of database administration.
- Five or more years of experience with SQL Server High Availability features: Failover Clustering, Log Shipping, Database Mirroring, AlwaysOn Availability Groups.
- Five or more years of experience with Windows Server 2008 R2 (and above) and Microsoft Failover Clusters.
- Installation and configuration experience with SQL Server 2008 (and higher), SQL Server Service Packs and Cumulative Updates
- Experience with PowerShell 4.0 (or higher)
- Strong documentation skills
- Strong performance tuning skills
- Strong interpersonal skills and willing to be a team player
- Participate in 7x24 on-call support rotation and expected to work during mission critical situations
Desired Skills:
- Working knowledge of DoD Security Technical Implementation Guides (STIGs), Security Readiness Review (SRR) scripts, and Information Assurance Vulnerability Management (IAVM)
- Experience with SQL Server 2016 (or higher)
- Experience with SQL Server Integration Services (SSIS)
- Experience with SQL Server Reporting Services (SSRS)
- Experience with SQL Server Analysis Services (SSAS)
- Experience with Microsoft Azure