Description
This project is to modernize aging Data Warehouse and Data Analytic systems utilizing new on-premises cloud- and container-based technologies.
Duties
- 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 Requirements
- Experience (15+ Years)
- 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.
Requirements
- This is an 100% Onsite.
- 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.
- 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.)
Sign in
To continue your applicationor continue with email
By continuing you agree to our Terms & Privacy Policy.
Similar jobs
Show more