SQL Server DBA - In person interview - Direct Client
*SQL Server DBA - * *In person interview - Direct Client **Immediate Interview and Start ASAP!!!* *Please send resume to 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* *Thanks, Sam CNC Consulting, Inc. 201-546-3096 s...@cncconsulting.com * -- You received this message because you are subscribed to the Google Groups "Citrix and Sap problems" group. To unsubscribe from this group and stop receiving emails from it, send an email to citrix-and-sap-problems+unsubscr...@googlegroups.com. To post to this group, send email to citrix-and-sap-problems@googlegroups.com. Visit this group at http://groups.google.com/group/citrix-and-sap-problems. For more options, visit https://groups.google.com/d/optout.
SQL Server DBA - In person interview - Direct Client
*SQL Server DBA - * *In person interview - Direct Client **Immediate Interview and Start ASAP!!! * *Please send resume to s...@cncconsulting.com * *Job title: SQL Server DBALocation: Cleveland, OHDuration: 4 MonthsDirect Client PositionIn person interviewThe Database Administrator is responsible for data analysis and database management. Database Administrators typically are involved in maintenance, enhancement, designing of data dictionaries, physical and logical database models, and performance tuning. Database Administrators have a range of skills and knowledge of the utilities and production tools used for data storage management to support the Application Team.Install and configure new SQL Servers Required 7 Years Resolve SQL Server performance issues Required 7 Years Configure and use SQL Server monitoring utilities to minimize problems Required 7 Years Document database environment Required 7 Years Troubleshoot SQL Server service outages as they occur, including after-hours and weekends Required 7 Years Ensure all database servers are backed up properly, and backups are tested. Required 7 Years When performance issues arise, determine the most effective way to increase performance including hardware purchases, server configuration changes Required 7 Years Experience in Agile (Scrum) SDLC methodologies Highly desired 2 Years Experience with Sharepoint as a repository Highly desired 2 Years Experience with Microsoft .NET development environments Highly desired 2 Years Experience reading , writing and Debug code written in VB.NET <http://VB.NET> in a Web Based environment Nice to have 2 Years Oracle DBA Experience Highly desired 3 Years Experience setting up Kerberos Nice to have 2 Years Please send resume to s...@cncconsulting.com* *Thanks, Sam CNC Consulting, Inc. 201-546-3096 s...@cncconsulting.com * -- You received this message because you are subscribed to the Google Groups "Citrix and Sap problems" group. To unsubscribe from this group and stop receiving emails from it, send an email to citrix-and-sap-problems+unsubscr...@googlegroups.com. To post to this group, send email to citrix-and-sap-problems@googlegroups.com. Visit this group at http://groups.google.com/group/citrix-and-sap-problems. For more options, visit https://groups.google.com/d/optout.
SQL Server DBA - In person interview - Direct Client
*SQL Server DBA - **In person interview - Direct Client * *Immediate Interview and Start ASAP!!!* *Please send resume to s...@cncconsulting.com * Job title: SQL Server DBA Location: Columbus, OH Duration: 10 months Direct Client Position In person interview Rate: $55/hr on C2C Experience as a SQL Server Database Administrator (SQL Server 2008/2012/2014) Required 8 Years Experience writing new or existing SSIS packages to facilitate (writing T SQL, stored procedures, optimizing queries by execution plan etc Required 5 Years Experience in data cleansing/conversion using scripts in SQL server 2008/2012/2014 Required 4 Years Experience in ETL/automation using SSIS 2008,2012,2014 Required 4 Years Experience in Data Warehouse using SQL server 2008/2012 Required 2 Years MUST be able to understand and enforce SQL server standards in creation and deployment of new database objects Required 3 Years Experience in SQL Server security and maintenance of security objects Required 3 Years Experience with object promotion strategies between databases in different environments-dev, test, QA,production Required 4 Years Experience in working with large databases of 300 GB or greater Required 4 Years Experience working with backup/restore in large databases, DMVs(data management views ) to troubleshoot performance issues Required 5 Years Experience with database file layouts, managing indexes including Columnstore Indexes Required 5 Years Experience with query execution plans, transactions and concurrency Required 5 Years Excellent communication skills both oral and written Required *Please send resume to s...@cncconsulting.com * Thanks, Sam CNC Consulting, Inc. 201-546-3096 s...@cncconsulting.com -- You received this message because you are subscribed to the Google Groups "Citrix and Sap problems" group. To unsubscribe from this group and stop receiving emails from it, send an email to citrix-and-sap-problems+unsubscr...@googlegroups.com. To post to this group, send email to citrix-and-sap-problems@googlegroups.com. Visit this group at http://groups.google.com/group/citrix-and-sap-problems. For more options, visit https://groups.google.com/d/optout.
SQL Server DBA - in person Interview - Direct Client
*SQL Server DBA - **in person Interview - Direct Client * *Immediate Interview and Start ASAP!!!* *Please send resume to s...@cncconsulting.com * Job Title: SQL Server DBA Location: Des Moines, IA Duration: 12 Months Direct Client Position in person Interview Day-to-Day Activities The successful candidate will spend a good portion of their time working with source system data owners and analytics developers to design and develop dimensional databases and associated ETL packages. While working on projects, the candidate is expected to propose, design, and develop solutions in concert with the other staff to fulfill the request. The candidate will also be responsible for system testing and working with the business users during acceptance testing. The successful candidate will be required to follow standard practices for migrating changes to the test and production environments and provide post production support. When not working on enhancement requests or problem reports, the candidate would concentrate on performance tuning. Senior level Database Administrator may work with more than one database architecture or have deep knowledge in a specific application database or set of databases to support architectural or decision support activities. The Database Administrator (DBA) is responsible for data analysis and database management. DBAs are typically involved in maintenance, enhancement, designing of data dictionaries, physical and logical database models, and performance tuning. DBA’s have a range of skills and knowledge of the utilities and production tools used for data storage management to support the Application Team. DBAs must be able to work in a team environment, follow quality standards and have strong written and verbal communication skills. DBAs coordinate physical changes to computer data bases; and codes, tests, and implements physical data base, applying knowledge of data base management system: Designs logical and physical data bases reviews description of changes to data base design to understand how changes to be made affect physical data base (how data is stored in terms of physical characteristics, such as location, amount of space, and access method). Establishes physical data base parameters. Codes data base descriptions and specifies identifiers of data base to data base management system or directs others in coding data base descriptions. Calculates optimum values for data base parameters, such as amount of computer memory to be used by data base, following manuals and using calculator. Specifies user access level for each segment of one or more data items, such as insert, replace, retrieve, or delete data. Specifies which users can access data bases and what data can be accessed by user. Estimates time and cost required to accomplish project. Directs programmers and analysts to make changes to data base management system. Reviews and corrects programs. Answers user questions. Confers with coworkers to determine impact of data base changes on other systems and staff cost for making changes to data base. Modifies data base programs to increase processing performance, referred to as performance tuning. Workers typically specialize in one or more types of data base management systems. May train users. Skill Required / Desired Amount of Experience Expertise Rating Experience in working with SQL Server 2005 and 2008 R2, Familiarity with SQL 2012 Required 5 Years Expert knowledge of T-SQL Required 5 Years Experience in developing and optimizing complex stored procedures Required 5 Years Experience developing data extract (SSIS) packages from source normalized databases. Required 5 Years Database modeling and design, specifically dimensional database modeling/STAR Schema’s Required 5 Years Knowledge of SQL best practices Required 5 Years Knowledge of SQL best practices in regards Data Warehousing and Decision Support Required 5 Years Experience in building ETL processes using SQL Server Integration Services(SSIS) Required 5 Years Excellent problem solving skills (for debugging problem reports) Required 5 Years Experience in working with big databases ( over 100 GB) Required 5 Years Experience in working closely with Analytics developers Required 5 Years Knowledge of Business Intelligence Tools (e.g. OBIEE, Business Objects) Required 5 Years Experience with SDLC and Agile development practices Required 5 Years *Please send resume to s...@cncconsulting.com * Thanks, Sam CNC Consulting, Inc. 201-546-3096 s...@cncconsulting.com -- You received this message because you are subscribed to the Google Groups "Citrix and Sap problems" group. To unsubscribe from this group and stop receiving emails from it, send an email to citrix-and-sap-problems+unsubscr...@googlegroups.com. To post to this group, send email to citrix-and-sap-problems@googlegroups.com. Visit this group at http://groups.google.com/group/citrix-and-sap-problems. For more options, v
SQL Server DBA - In person Interview - Direct Client
*SQL Server DBA - **In person Interview - Direct Client * *Immediate Interview and Start ASAP!!!* *Please send resume to s...@cncconsulting.com * Job Title: SQL Server DBA Location: Hot Springs, AR Duration: 10 Months Direct Client Position *In person Interview* *Position located in Hot Springs, ARTravel Required - travel expenses reimbursed.Valid Driver's LicenseCurrent Vehicle Insurance CertificatesLocal Candidates: In-person interviews in Little Rock* The primary responsibility includes data migration from the legacy system Health Management System to the new system using Crystal Reporting and ODBC. After the migration the DBA will begin more typical DAB duties that will include assisting with application development, support and maintenance initiatives, from a database perspective, and is responsible for database configuration, debugging and optimization activities. This position will also include part-time support of the Help Desk in solving end user desktop, laptop, peripheral, and network issues. Bachelor's Degree in Information Technology, Computer Science, Engineering, or related discipline, or equivalent work experience is required. Qualifications Data migration and project management SQL Server Database Administration (2000/2005/2008 R2 and/or 2012) Experience in troubleshooting and resolving database problems including performance, integrity, blocking and deadlocking and security issues Experience in Performance Tuning and Optimization (PTO), using native monitoring and troubleshooting tools Experience with backups, restores and recovery models DB2 Develop and enhance stored procedures, triggers, functions, views and other database objects. Setting up and Managing ODBC Connections. MS Access (As a front end tool for compiling data) Resolve database production issues, code troubleshooting.. Skill Required / Desired Amount of Experience Expertise Rating Database Migration Required 4 Years SQL Server Database Administration (2000/2005/2008 R2 and/or 2012) Required 4 Years Crystal Reports Required 4 Years DB2 Required 3 Years Setting up and Managing ODBC Connections Required 4 Years MS Access (As a front end tool for compiling data) Required 4 Years Troubleshooting and resolving database problems Required 4 Years Integrity, blocking, Deadlocking and Security Issues Required 4 Years Performance Tuning and Optimization (PTO) Required 4 Years *Please send resume to s...@cncconsulting.com * Thanks, Sam CNC Consulting, Inc. 201-546-3096 s...@cncconsulting.com -- You received this message because you are subscribed to the Google Groups "Citrix and Sap problems" group. To unsubscribe from this group and stop receiving emails from it, send an email to citrix-and-sap-problems+unsubscr...@googlegroups.com. To post to this group, send email to citrix-and-sap-problems@googlegroups.com. Visit this group at http://groups.google.com/group/citrix-and-sap-problems. For more options, visit https://groups.google.com/groups/opt_out.
SQL Server DBA - In person interview - Direct Client
*SQL Server DBA - **In person interview - Direct Client * *Immediate Interview and Start ASAP!!!* *Please send resume to s...@cncconsulting.com * Job title: SQL Server DBA Location: Richmond, VA Duration: 9 months Direct Client Position In person interview Experience with SQL Server 2000 database administration Required 2 Years Experience with SQL Server 2005 database administration Required 2 Years Experience with SQL Server 2008 database administration Required 4 Years Experience with Database performance monitoring Required 4 Years Experience managing backend database and related infrastructure Required 5 Years Experience with SQL 2012 'Always On' for High Availability and Disaster Recovery Highly desired 1 Years Experience working with and knowledge of system requirements development, data models and architecture Highly desired 3 Years Experience supporting a SQL Server Production Environment Required 3 Years *Please send resume to s...@cncconsulting.com * Thanks, Sam CNC Consulting, Inc. 201-546-3096 s...@cncconsulting.com -- You received this message because you are subscribed to the Google Groups "Citrix and Sap problems" group. To unsubscribe from this group and stop receiving emails from it, send an email to citrix-and-sap-problems+unsubscr...@googlegroups.com. To post to this group, send email to citrix-and-sap-problems@googlegroups.com. Visit this group at http://groups.google.com/group/citrix-and-sap-problems. For more options, visit https://groups.google.com/groups/opt_out.