Ref No.: 18-01332
Location: Yonkers, New York
Position Type:Contract to Hire
1 year contract to hire
Yonkers, NY
SQL DBA Manages, modifies and administers existing databases and tests new database software. Participates in development of optimal hardware and software configurations. Produces specialized and tailored reports that are security compliant and specific to user.
SQL DBA Manages, modifies and administers existing databases. Install, patch, and maintain database software. Test new database software and upgrades to be put into production. Work with systems administrators to develop optimal hardware and software configurations. Analyze database data and make recommendations to improve performance and efficiency of data storage and other database features. Establish and maintain backup and recovery policies and procedures. Analyze, design, and create new databases that meet user and business needs. Perform data modeling and optimize the data schemas. Assist and coach developers in writing scripts that optimize efficiency and abide by best practices standards. Monitor and administer RDBMS security for compliance with data security policies and procedures. Add/remove users, assign user privileges, administer quotas, audit and check for security problems. Research and evaluate database and testing tools. Provide timely, effective, and professional customer support on a 24x7 rotating basis. Work with help desk and support personnel to identify problems and resolve them.
-SQL Server 2012, 2014, 2016 required
-TSQL required
-Clustering, Replication, performance tuning required  
-Any experience with SQL Profiler is a huge plus