Job Description :
Need Senior SQL Server Production Support DBA (Architect Level) in New York, NY/ In-Person is required

Role: Senior SQL Server Production Support DBA (Architect Level)
Location: New York, NY
Duration: 24 Month+
Rate: $60-70/hr C2C
Interview: Initial Phone + In-Person (Absolutely Required)

Need candidates local to NJ/NY who can interview and start ASAP

Senior SQL Server Production Support DBADescription:
The ideal candidate will be experienced in all aspects of SQL Server administration including build, administer, clustering, disaster recovery and security best practices. Candidate will manage and support current and future database environments and initiatives whileproactively evaluating and implementing new technology and solutions to business requirements. Candidate will research and create best practices for the implementation of new SQL features and solutions to high volume performance issues. Help develop and enhance mechanisms to centralize the management of SQL instances to reduce the overhead of maintenance.

Senior SQL Server Production Support DBA Responsibilities:
Production support DBA for large sized mission critical databases
Implement High availability & DR solutions and support periodic testing
Architect database environments to support very large sized databases (OLTP & DW)
Experience working with SQL 2005 / 2008 / 2008R2 / SQL 2012 (SQL 2014 is a plus)
Database Patching / Upgrade experience
Database recoverability including backups, restores, log shipping, mirroring, replication etc.
Recommending tactical and strategic solutions
Expertise in troubleshooting all aspects of SQL Server technologies and working with clients and other vendors
Performing database performance and query tuning
Proactively monitoring and maintaining production databases
Perform logical database design review and physical database implementations
Work with development teams on all aspects of database design including tables, views, stored procedures and permissions. Document and provide development best practices
Independently manage own projects from a dB perspective. Responsible for end to end solution for projects assigned
Respond to production and/or mission-critical issues and needs on 24/7 basis
Cognos Center Framework Manager experience helpful
Experience with design / architecture for in-memory database in 2014 is a plus
Some experience with SQL fertilization helpful

Senior SQL Server Production Support DBA Preferred Skills:
Candidate will possess experience with clustering, replication and mirroring
Strong knowledge of database performance tuning and configuration tools in MS SQL Server
SAN knowledge related to SQL configuration, performance and replication
Thorough knowledge of data backup, recovery, and rollback planning/implementation
Proficiency in SQL Server 2005/2008/2008R2/2012 & 2014 optimization, fine-tuning, and scalability techniques
Knowledge of SSIS
Microsoft certifications a plus
Knowledge of other RDBMS is a plus

E: srikanthm at vertigonconsulting dot com