Innovations technological

Hi,

Please find the below position and respond back to me at praveenk@xperttech.com

Job Title: SQL Server Application DBA Architect

Location: Hartford, CT

Duration: 6-12+ Months

Billing Rate: $DOE/Hour

Interview: INPERSON MUST LOCAL CANDIDATES ONLY)

EXPERIENCE SKILL MATRIX:

Total years of Experience in IT: years

Total years of US Experience: years

1. COMPLETE SKILL MATRIX (YEARS OF EXPERIENCE IN EACH SKILL):

1.       SQL Server DBA: years

2.       Architect: years

3.       Microsoft SQL Server 2008-2014: years

4.       Logical/physical data modeling and design: years

5.       Dimensional design: years

6.       Agile, Kimball and Inmon methodologies: years

7.       SAP Business Objects Data Services (BODS): years

8.       Data management (SAP, HADOOP, MDM etc.): years

Job Description:

SQL Server Application Database Administrator (DBA) Architect will be responsible for SQL Server 2008-2014 Database Administration, Modeling and Design using SSIS, SSRS & SSAS. This role requires strong data architecture and information architecture skills and a high degree of technical acumen, excellent communication and interpersonal skills as well as the requisite technical skills within Microsoft SQL Server and data software tools.

1.       Employs appropriate RDBMS technologies to best fit application requirements, and provides technical and SQL assistance to application staff using the DBMS.

2.       Provides troubleshooting, problem solving, monitoring and optimization of DBMS performance. Ensures security of the DBMS data, manages schema, database users.

3.       Provides assistance to application staff in database design based on technical knowledge.

4.       Assists in the management of hardware & software models and architecture as related to the overall Information Architecture.

5.       Understands data management components, practices, and principles and can assist in the development of an information architecture: data governance, business glossary, data architecture, Master Data Management (MDM), data security, data integration, business intelligence and analytics, document and content management, metadata management, data quality.

6.       Recommends strategies related to database management for transactional and analytics/business intelligence environments, such hardware upgrades, virtualization technologies, HortonWorks, SAS High Performance Analytics, HADOOP, SAP HANA, ELT, and analytics solutions.

7.       Assures Data Quality by using database design and development best practices.

8.       Develops standardized programming and data documentation procedures relevant to data systems.

Qualifications:

1.       SQL Server Database Administrator (DBA) Architect with 5+ years of experience in Microsoft SQL Server 2008-2014 database admin, including SSIS, SSRS, SSAS, replication, indexing, and Change Data Capture.

2.       Must have advanced troubleshooting skills to resolve SQL Server related issues in a Microsoft Windows environment.

3.       SQL Server database modeling / logical & physical database design experience using ERWin or PowerDesigner, as well as database software and tools support experience are required.

4.       Advanced skills in Transact-SQL (T-SQL) coding are required.

5.       Experience using Agile software development methodology as well as Kimball and Inmon methodologies required.

6.       SAS and SAS High Performance Analytics- tool installation and configuration a plus.

7.       SAP Business Objects Data Services Data Quality/Data Integration/BI suite, and SAP SharePoint integration a plus.

8.       SAP HANA, HADOOP, NoSQL, PowerShell, HortonWorks, and DB2 for z/OS a plus.

9.       Strong team and interpersonal skills.

10.   Ability to take initiative and lead projects.

11.   Excellent verbal and written communication skills.

12.   Bachelor's degree in Computer Science.

Thanks/Regards,

Praveen Kumar

400 W Cummings Park

Suite#2850

Woburn, MA-01801

Email: praveenk@xperttech.com

Phone: 781-797-1042

Fax: 978-405-5040

www.xperttech.com