Database Architect
Job in
City of Albany, Albany, Albany County, New York, 12201, USA
Listed on 2026-06-06
Listing for:
SIRITECH SOLUTIONS CORP
Full Time
position Listed on 2026-06-06
Job specializations:
-
IT/Tech
Data Engineer, Data Warehousing, Data Analyst, Database Administrator
Job Description & How to Apply Below
Total Required Experience in Years: Minimum 7+ Years
Mode of Work: Hybrid (50% Telecommuting | Minimum 2 Days Onsite Weekly | Albany, NY)
Job DescriptionSeeking an experienced Database Architect to design, develop, and support enterprise data warehouse, integration, and modernization initiatives supporting strategic transportation and enterprise data programs. The ideal candidate should possess strong expertise in data warehouse architecture, ETL/ELT frameworks, Oracle Data Integrator (ODI), enterprise data modeling, SQL development, and large-scale data integration environments. This role requires designing scalable data solutions, supporting governance and quality initiatives, and driving enterprise data management strategies across mission‑critical systems.
Key Responsibilities- Design and implement enterprise data warehouse and large-scale data integration solutions
- Develop data integration frameworks, ETL/ELT pipelines, and workflow automation solutions
- Design logical and physical data models and enterprise database architectures
- Implement scalable ETL and ELT solutions supporting enterprise reporting and analytics initiatives
- Coordinate with business stakeholders, vendors, and technical teams to support enterprise data initiatives
- Develop data quality, governance, and master data management processes
- Participate in Secure Software Development Life Cycle (SSDLC) activities and compliance initiatives
- Design enterprise system integrations and workflow automation processes
- Perform database performance tuning, optimization, and query enhancement activities
- Support architecture planning and modernization efforts for enterprise data systems
- Manage incidents, service requests, and change management activities
- Develop testing, validation, and system quality assurance plans
- Refactor, optimize, and improve existing database code and ETL processes
- Produce architecture documentation, technical specifications, and system designs
- Support milestone planning, project execution, and enterprise delivery initiatives
- Strong expertise in SQL and enterprise database architecture
- Experience with enterprise data warehouse architecture, ETL, and ELT frameworks
- Oracle Data Integrator (ODI) implementation and administration experience
- Data modeling and enterprise data integration expertise
- Strong understanding of database performance tuning and optimization
- Experience supporting enterprise‑scale reporting and analytics environments
- Strong technical documentation and stakeholder collaboration skills
- Master Data Management (MDM) experience
- Workflow automation and process optimization experience
- Data governance and data quality management expertise
- SSDLC and enterprise compliance framework knowledge
- Enterprise reporting and analytics support experience
- Experience implementing enterprise data warehouse solutions required
- Experience collaborating with State agencies preferred
- Experience designing enterprise data integration frameworks required
- Experience working with business and technical teams across enterprise environments preferred
To View & Apply for jobs on this site that accept applications from your location or country, tap the button below to make a Search.
(If this job is in fact in your jurisdiction, then you may be using a Proxy or VPN to access this site, and to progress further, you should change your connectivity to another mobile device or PC).
(If this job is in fact in your jurisdiction, then you may be using a Proxy or VPN to access this site, and to progress further, you should change your connectivity to another mobile device or PC).
Search for further Jobs Here:
×