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.

Position Overview

The Database Architect will analyze, design, develop, support, and reengineer database structures across Sybase, SQL Server, and DB2 environments. The ideal candidate will bring extensive experience with database performance, data migration, enterprise analytics, and data warehouse modernization.

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

Required Experience

• 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 Candidate Profile

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 Range: $60.00 - $70.00 per hour (Depending on experience and qualifications)

By applying for this job, you agree to receive calls, AI-generated calls, text messages, or emails from HEPCO, Inc. and its affiliates and contracted partners. Frequency varies for text messages. Message and data rates may apply. Carriers are not liable for delayed or undelivered messages. You can reply STOP to cancel and HELP for help. You can access our privacy policy at https://www.hepcoinc.com/privacy/

All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, gender expression, marital status, national origin, age, veteran status, disability, or any other protected class.