*SQL Server DBA - * *In person interview - Direct Client **Immediate Interview and Start ASAP!!!*
*Please send resume to s...@cncconsulting.com <s...@cncconsulting.com> * *Job Title: SQL Server DBA (2 positions)Location: NYC Duration: 3 MonthsDirect Client PositionIn person interview/35 hr/wkThe Department’s leverages SQL on a large scale. SQL databases hold’s most of the Department’s most sensitive information and feeds the vast majority of its most critical applications. The requested resources will work on verifying the resiliency and recoverability of the SQL deployments, ensuring they are in a state that will allow the migration to be executed while maintaining data integrity and continuity of services.SCOPE OF SERVICES:Responsible for analyzing the existing SQL environment, providing remediation recommendations, and planning the phases of the physical relocation of this equipmentOptimize, monitor, and performance tune databases and serversAssistance with migrations to SQL 2012 and 2014 from legacy versionsDeliver “as is” and future state designs. Provide technical design and troubleshooting efforts as appropriate to ensure overall project success Prepare time estimates for phases of technical projects. Develop and maintain project tasks for large and medium projects. Document all aspects of projects to assure other administrators can support the environment easily. Help define standard engineering designs, templates, processes, and procedures for implementing projects.Interface with Project Manager to ensure requirements are gathered for projects and that project status is communicated. Analyze system performance, modifying parameters to improve throughput and effectively utilize system resources. Provide recommendations to resolve future performance needs.Migration of existing services to new hardware / virtual machines MANDATORY SKILLS / EXPERIENCE: Note: candidates who do not have the mandatory skills will not be considered.At least 6 years of experience in migration, operations, administration and maintenance of Microsoft SQL Server 2008/2012Knowledge of High Availability (HA) and Disaster Recovery (DR) options for SQL Server including Replication, Mirroring and Clustering. Specifically, experience implementing and configuring SQL “Always on” Understanding of, and experience with relational database environments.Experience with installation, configuration and upgrades of SQL Server.Experience migrating large scale data systems on a global scale.Optimize, monitor, and performance tune databases and serversExperience tuning SQL Server databases, and implementing SQL Server database security measuresExperience in Performance Tuning and Optimization, using native monitoring and troubleshooting tools including Profiler and Performance Monitor.Ability to detect and troubleshoot SQL Server related CPU, memory, I/O, disk space and other resource contention.Scripting skills in writing T-SQL involving tuning queries for performance and creating and maintaining stored procedures, triggers, views and functions.Experience with SQL Server Reporting Services, Analysis Services and Integration Services.DESIRABLE SKILLS/EXPERIENCE: Microsoft Certified IT Professional (MCITP) SQL Server 2008; MCSA (Microsoft Certified Solutions Associate) SQL Server 2012Experience with IBM DB2, DB2 Connect and Data Studio a plusB.S. degree in Computer Science or related IT field Please send resume to s...@cncconsulting.com <s...@cncconsulting.com> * *Thanks, Sam CNC Consulting, Inc. 201-546-3096 s...@cncconsulting.com <s...@cncconsulting.com>* -- You received this message because you are subscribed to the Google Groups "oraapps" group. To unsubscribe from this group and stop receiving emails from it, send an email to oraapps+unsubscr...@googlegroups.com. To post to this group, send email to oraapps@googlegroups.com. Visit this group at http://groups.google.com/group/oraapps. For more options, visit https://groups.google.com/d/optout.