"Alerted.org

Interview Type: In Person Interview Only *** Very long term project; expect to go for 4+ years ***w2 or 1099 or c2c *** Onsite as needed

Description:

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.

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.

Required Skills:

+ Hands on administrative experience with SQL Server RDBMS. 6 Years

+ Hands on experience in managing backup, recovery and high availability scenarios. 6 Years

+ Hands on development and tuning of databases in SQL Server with Performance Tuning. 6 Years

+ Hands on experience in Microsoft Operating Systems and SQL Server clustered environments required. and Optimization and TSQL programming. 6 Years

+ Hands on query experience with SQL and scripting skills. 6 Years

+ Strong knowledge and experience on Always ON High Availability groups. 4 Years

+ Strong Knowledge and Experience on Migrations 4 Years

+ SQL Server database space management/storage design and capacity planning according to best practices. 3 Years

+ Demonstrate ability to effectively communicate verbally and in writing with all levels of staff and management. 4 Years

+ Demonstrate ability to generate entity relationship diagrams, create database documentation, data dictionaries and document system architecture. 3 Years

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.