Database Architect

Job Title: Database Architect - Expert

Task ID: HBITS-08-14929

Position Duration: 30 Months

Client: State of NY

Agency: Information Technology Services

Please call (703) 466-0951 | (571) 351-1868 | (703) 348-3018 or email at [email protected]

Description

• 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 operational data stores 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.

Mandatory Qualifications 1 84 months experience installing and configuring Sybase and SQL Server. 2 84 months experience monitoring system performance and implementing performance tuning measures for Sybase and SQLServer databases. 3 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. 4 84 months experience documenting system configurations, procedures, and troubleshooting guidelines for Sybase and SQLServer Databases in a server environment. 5 84 months experience applying upgrades and security patches to critical operational databases. 6 84 months experience using ERWin to create and maintain data models. 7 84 months experience with Tableau or Cognos Analytics. 8 84 months experience with data migration and conversion in relational databases. Required Documentation

• Résumé
• 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.)

Disclaimer: i-Link Solutions Inc. provides equal employment opportunities (EEO) to all employees and applicants for employment without regard to race, color, religion, gender, sexual orientation, gender identity or expression, national origin, age, disability, genetic information, marital status, amnesty, or status as a covered veteran in accordance with applicable federal, state and local laws. We especially invite women, minorities, veterans, and individuals with disabilities to apply. EEO/AA/M/F/Vet/Disability