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