I have a very urgent DIRECT CLIENT requirement for SQL Server DBA in Columbus, OH. Please Let Me Know If you have available candidate, please reply with their word resume, location, rate and contact number.
Please send the resumes at su...@cncconsulting.com Job Title: SQL Server DBA Location: Columbus, OH Duration: 10 months In person interview The selected Consultants will work closely with the designated I.T. supervisor, project managers, database administrators ,other developers and other team members in an iterative development environment. The work scope of the consultant will includes: working with backup/restores large databases, Data management views (DMVs) to troubleshoot performance related issues, database security, database file layouts, managing indexes, (including ColumnStore indexes) , query execution plans, transactions and concurrency. The day to day scope includes but not limited to: Write new or modify existing SSIS packages to facilitate conversion process (complexity level medium – skill set neeed SSIS) Write various tasks in SSIS, and stored procedures using T-SQL used by SSIS tasks (complexity level medium to high – skill set needed - SSIS combined with SQL Server developer) Troubleshoot performance issues which may occur within SSIS, stored procedures or in the database (skills medium to high – skill set need DBA – how to make use of DMVs available in SQL Server to get to root cause of the problem) Deploy conversion database in ATPS Blue in different environments, and support such as security, performance issues, etc. (complexity level medium – skill set needed DBA) Manage, and deploy packages, database projects to start the conversion process (complexity level medium – skill set needed TFS, PowerShell, SSIS Project deployment model) The selected resource will also assist IT in our rewrite of the Automated Title Processing System (ATPS) databases from Oracle 9i to SQL Server 2012 using .NET technologies. The position will assist IT staff in data migration process (using SSIS as a primary tool), and rewriting of ATPS application. SQL Server 2014 is being used in the conversion process. Strong communication/ leadership skills. Strong influence, collaboration and negotiation experience. Ability to collaborate with supporting resources across business and/or functional lines. Have excellent oral and written skills/possess strong meeting and work session facilitation skills. Have the ability to work independently and as part of a team, the ability to manage time and resources to meet assigned deadlines. Have strong understanding of prioritization stemming from the elicitation of system and/or user requirements. Have excellent organizational skills, proven analytical, planning, problem solving, and decision-making skills. Must be knowledgeable in the English language/speak clearly and understandably using the English language. Eight (8) years of verifiable total Information Technology (IT) as a SQL Server database administrator (SQL Server 2008/2012/2014). Five (5) years of verifiable experience as SQL Server database developer (writing T-SQL, stored procedures, optimizing queries by using execution plan, etc.). Four (4) years of verifiable experience in data cleansing/conversion using scripts in SQL Server (SQL Server 2008/2012/2014). Four (4) years of verifiable experience in ETL/Automation using Integration Services (SSIS 2008/2012/2014). Two (2) years of verifiable experience in Data Warehouse using SQL Server 2008/2012. Must be able to understand and enforce SQL Server standards in creation and deployment of new database objects. Three (3) years verifiable experience in SQL Server security and maintenance of security objects. A demonstrable understand of object promotion strategies between databases in different development environments (Dev, Test, QA, Production) Experienced in working with large databases of 300 GB or greater. 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 Thanks, Sunny Roy 480-463-3006 Phone su...@cncconsulting.com -- You received this message because you are subscribed to the Google Groups "SAP BASIS" group. To unsubscribe from this group and stop receiving emails from it, send an email to sap-basis+unsubscr...@googlegroups.com. To post to this group, send email to sap-basis@googlegroups.com. Visit this group at http://groups.google.com/group/sap-basis. For more options, visit https://groups.google.com/d/optout.