DatabaseArchitect_Expert (14929)

Provide a short description of the Position:
This project is to modernize aging Data Warehouse and Data Analytic systems utilizing new on-premises cloud- and container-based technologies.

Provide a list of the day to day tasks to be performed by the Selected Candidate:

• Responsible for analysis, design, support, development and reengineering of database structures in Sybase, SQLServer and DB2.
• Provide performance analysis and tuning, troubleshooting, capacity planning, benchmark design.
• Design methodologies for data synchronization from various operational data stores (Mainframe DB2, Windows SQL Server, Sybase on Solaris, DB2 on AIX and OpenShift) to a zLinux DB2 data warehouse.
• Planning, interfacing, and usage between z/OS and LUW DB2 application databases, data warehouse, Cognos, Identity Insight, and DataStage.
• Act as liaison between Data Management, business customers, and application development staff to ensure that recommended performance considerations are included in reviews, designs, development, and implementation of applications.
• Create cost effective and timely solutions to strategic business requirements utilizing database structures, application methodologies, and coding techniques.

Position Mandatory Qualification (Per Attachment 7, Section 1.2.4)

Position Job Title:
Database Architect

Determines database structural requirements by analyzing client operations, applications, and programming; reviews objectives with clients; evaluates current systems; provides database support by coding utilities, responding to user questions, and resolving problems.

Position Skill Level:
Expert

84+ Months: Candidate is able to provide guidance to large teams and/or has extensive industry experience and is considered at the top of his/her field.

Position Requested Qualifications (Per Attachment 7, Section 1.2.5)

• 84 months experience installing and configuring Sybase and SQL Server.
• 84 months experience monitoring system performance and implementing performance tuning measures for Sybase and SQLServer databases.
• 84 months experience managing and implementing database maintenance (reorgs, statistics, ensuring database is running optimally) in a server environment with Sybase and SQL Server databases.
• 84 months experience documenting system configurations, procedures, and troubleshooting guidelines for Sybase and SQLServer Databases in a server environment.
• 84 months experience applying upgrades and security patches to critical operational databases.
• 84 months experience using ERWin to create and maintain data models.
• 84 months experience with Tableau or Cognos Analytics.
• 84 months experience with data migration and conversion in relational databases.

Required Documentation

• Re sume
• Copy of Candidate Identification (i.e., Driver's License/Green Card/Visa and Passport if applicable)
• Any documents referenced in the above Requested Qualifications (i.e., professional certifications, degrees, etc.)

Additional Information Requests:

Are there additional security requirements for the Authorized User? Yes
If YES, include the additional security requirements:
Mandatory ITS Security Agreements and Fingerprint-based Background Check.

Will additional training potentially be required during the Engagement? Yes
If YES, provide description of anticipated training:
Candidate will attend all New York State/GOER and agency mandated training programs, including Internal Controls, Prevention of Workplace Violence, Sexual Harassment Prevention, Information Security, etc.

Is travel anticipated during the Engagement? No