*Sr. SQL Server DBA * *Location- NYC,NY*
*Mode- Must go to face to face interviews In NYC* *Duration- Long-term* *Local Candidate ( Tristate) preferred* *SURE SHOT CLOSURE, we have full control* *but excellent communication skills* * Immediate Start please note Job Description: * The ideal candidate will be experienced in all aspects of SQL Server administration including build, administer, clustering, disaster recovery and security best practices. * You will manage and support current and future database environments and initiatives while proactively evaluating and implementing new technology and solutions to business requirements. * You 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. 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 / 2008, R2 / 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 Microsoft 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<x-apple-data-detectors://36> 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 Preferred:- * You 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 / 2008, R2 / 2012 & 2014 optimization, fine-tuning, and scalability techniques. * Knowledge of SSIS. * Microsoft certifications a plus. * Knowledge of other RDBMS is a plus* -- Best Regards, Samarth Mishra sama...@apetan.com 201 620 9700x125 -- You received this message because you are subscribed to the Google Groups "Vendors" group. To unsubscribe from this group and stop receiving emails from it, send an email to vendors+unsubscr...@googlegroups.com. To post to this group, send email to vendors@googlegroups.com. Visit this group at https://groups.google.com/group/vendors. For more options, visit https://groups.google.com/d/optout.