Database Architect in Albany, NY.(Onsite)

Hi,

One of our clients is looking for Database Architect in Albany, NY.(Onsite)

Title: Database Architect  

Location: Albany, NY.(Onsite)

Duration: 30 Months

Initial 4 months of 100% on-site to learn tools and applications and ensuring all needed accesses are in place and 50% remote after that.

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

Required Qualifications:

• 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