Job Description :
Role: MS SQL Server Database Administrator (MS SQL DBA)
Location: Linthicum, MD
MOI: Face-to-face
Duration: 3-5 years

Duties / Responsibilities:
Provide technical expertise and support in the use of DBMS.
Design and implement automation of SQL Server Installation using scripts. Define file organization, indexing methods, and security procedures for specific user applications.
Create and maintain database objects such as tables, views, index, constraints, etc. for data platform and custom applications.
Develop, implement, and maintain database backup and recovery procedures for the processing environments, and ensures that data integrity, security, and recoverability are built into the DBMS applications.
Evaluate and recommend available DBMS products to support validated user requirements.
Ensuring optimal database performance through exhaustive pro-active testing and ongoing real-time monitoring.
Monitor and maintain the backups for database recoverability for all production databases.

Required Skills:
At least five (5) years of experience in administering on-prem/cloud based multi user environment with expertise in planning, designing, building, and implementing complex database systems.
In depth knowledge of the MS SQL Server DB architecture.
Prior AWS cloud base SQL Servers database administration experience.
Drive end to end availability, performance monitoring, and capacity planning for MS SQL server, using native and 3rd party tools.
Implemented industry best practices for consistent installation and configuration of MS SQL Server for production, pre-production and non-production environments.
Conducted technical reviews and walkthroughs of system design documentation with development and design team members.
Experienced with MS SQL Server database administration throughout the non-production (Sandbox, development, test, UAT, Training), pre-production (Staging) and production lifecycles in an AWS environment.
Testing database security and enterprise policy guidelines according to established best practices.
Must be proficient in scripting.

Client : Confidential