Database Architect

Title :  Expert Database Architect

Location: Albany, NY

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:

Daily Tasks will include but are not limited to the following:

·       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, Congo’s, Identity Insight, and Data Stage.

·       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. 

·       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.

·       Experience installing and configuring Sybase and SQL Server.

·       Experience monitoring system performance and implementing performance tuning measures for Sybase and SQLserver databases.

·       Experience managing and implementing database maintenance (reorgs, statistics, ensuring database is running optimally) in a server environment with Sybase and SQL Server databases.

·       Experience documenting system configurations, procedures, and troubleshooting guidelines for Sybase and SQLserver Databases in a server environment.

·       Experience applying upgrades and security patches to critical operational databases.

·       Experience using Erwin to create and maintain data models.

·       Experience with Tableau or Congo’s Analytics.

·       Experience with data migration and conversion in relational databases.