Short Description:
The agency is looking for a resource with Strong DBA skills , SQL server internals and familiarity with windows server administration, SSIS,TFS,SQL development
Complete Description:
IN PERSON INTERVIEWS no exceptions. Interviews are going to be held on the 27th of August at 12:30, 1:30 and 2:30. Resumes are due to the manager on Monday the 25th.
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.
1. Strong communication/ leadership skills.
2. Strong influence, collaboration and negotiation experience.
3. Ability to collaborate with supporting resources across business and/or functional lines.
4. Have excellent oral and written skills/possess strong meeting and work session facilitation skills.
5. Have the ability to work independently and as part of a team, the ability to manage time and resources to meet assigned deadlines.
6. Have strong understanding of prioritization stemming from the elicitation of system and/or user requirements.
7. Have excellent organizational skills, proven analytical, planning, problem solving, and decision-making skills.
8. Must be knowledgeable in the English language/speak clearly and understandably using the English language.
1. Eight (8) years of verifiable total Information Technology (IT) as a SQL Server database administrator (SQL Server 2008/2012/2014).
2. Five (5) years of verifiable experience as SQL Server database developer (writing T-SQL, stored procedures, optimizing queries by using execution plan, etc.).
3. Four (4) years of verifiable experience in data cleansing/conversion using scripts in SQL Server (SQL Server
2008/2012/2014).
4. Four (4) years of verifiable experience in ETL/Automation using Integration Services (SSIS 2008/2012/2014).
5. Two (2) years of verifiable experience in Data Warehouse using SQL Server 2008/2012.
6. Must be able to understand and enforce SQL Server standards in creation and deployment of new database objects.
7. Three (3) years verifiable experience in SQL Server security and maintenance of security objects.
8. A demonstrable understand of object promotion strategies between databases in different development environments (Dev, Test, QA, Production)
9. Experienced in working with large databases of 300 GB or greater.
Skills:
Skill
Required / Desired
Amount
of Experience
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