Database Administrator 4

Job Description

Job Description

Job Summary:

Under limited supervision, coordinates, designs, and secures computer databases to store, track, and maintain a large volume of critical business information. Serves as highest advanced-level subject matter expert, providing authoritative guidance for professional staff. May also serve in a lead role.

Local Candidates Only.

Job Responsibilities:

Manage all aspects of physical database administration including schema management; security, setup, installations, upgrades, patches, backup and recovery, space management, performance tuning and capacity planning for SQL Server.

- Support application teams and their projects to enhance, troubleshoot and performance tune
- Support SQL Server databases in Production, Test and Development environments and within Microsoft
SharePoint farm
- Install, upgrade, configure ALWAYS ON, test and deploy complex database software
- Develop and implement database recovery plans and procedures
- Analyze the performance of databases and recommends tuning and application changes
- Implement user authentication and validate databases security protocols across systems
- Reviews system design and develop new database systems as needed
- Modifying database structure or deploying schema changes as a result of new requirements
- Scripting batch data loads and operational job automation
- Working Knowledge of Cohesity Backup Appliance.
- Working Knowledge of Cloud Technology and governance.

Qualifications:

Bachelor's degree in computer science or a related field from an accredited college or university AND Seven years of experience in support of an operating system, database management system or a related field

Skills Required :

• 6+ years of hands-on administrative experience with SQL Server RDBMS

• 6+ years of hands-on experience managing backup, recovery, and high-availability scenarios

• 6+ years of hands-on experience in SQL Server database development and performance tuning

• 6+ years of hands-on experience with Microsoft Operating Systems , SQL Server clustered environments , database optimization , and T-SQL programming

• 6+ years of strong SQL query development and scripting experience

• 4+ years of strong knowledge and hands-on experience with Always On High Availability Groups

• 4+ years of strong experience with SQL Server migrations

• 3+ years of experience in database space management , storage design , and capacity planning following best practices

• 4+ years of demonstrated ability to communicate effectively , both verbally and in writing, with technical teams and management

• 3+ years of experience creating entity relationship diagrams (ERDs) , database documentation , data dictionaries , and system architecture documentation