Database Architect (Hybrid)

HEPCO, Inc. is seeking a senior-level Database Architect for a 30-month assignment in Albany, NY. This role will support a major modernization initiative focused on upgrading aging data warehouse and analytics platforms using new on-premises cloud and container-based technologies.

Responsibilities

• Analyze, design, develop, support, and reengineer database structures across Sybase, SQL Server, and DB2 environments.
• Conduct database performance analysis, tuning, troubleshooting, capacity planning, and benchmark design.
• Design methodologies for synchronizing data from multiple operational data stores into a zLinux DB2 data warehouse.
• Plan and support integrations among z/OS and LUW DB2 application databases, the data warehouse, Cognos, Identity Insight, and DataStage.
• Serve as a liaison among data management teams, business stakeholders, and application development teams.
• Ensure database performance, scalability, and design considerations are incorporated into application implementations.
• Develop cost-effective and timely database and application solutions aligned with strategic business objectives.
• Document database configurations, procedures, and troubleshooting guidelines.
• Apply upgrades and security patches to critical operational databases.

Requirements

• At least 84 months of experience monitoring system performance and implementing performance-tuning measures for Sybase and SQL Server databases.
• At least 84 months of experience managing database maintenance activities, including reorganizations, statistics, and optimization, within Sybase and SQL Server environments.
• At least 84 months of experience documenting configurations, procedures, and troubleshooting guidelines for Sybase and SQL Server databases.
• At least 84 months of experience applying upgrades and security patches to critical operational databases.
• At least 84 months of experience using ERwin to create and maintain data models.
• At least 84 months of experience with Tableau or Cognos Analytics.
• At least 84 months of experience performing data migrations and conversions within relational database environments.

Preferred Qualifications

The ideal candidate will have extensive experience with legacy and enterprise database platforms, strong data warehouse modernization capabilities, and the ability to collaborate across infrastructure, data management, application development, and business teams. Experience supporting large-scale analytics and reporting environments within government or another highly regulated industry is strongly preferred.

Assignment Details

Location: W. A. Harriman Campus, Building 8, Albany, NY 12227
Work arrangement: Hybrid/on-site schedule based on project requirements
Duration: 30 months
Schedule: 40 hours per week
Interview format: Video interview
Employment type: Contract

Benefits

• Health insurance
• Sick time
• 401(k) retirement plan

Pay

$60.00 - $70.00 per hour (Depending on experience and qualifications)