Database Architect

For more details, please connect with Praveen H at [email protected] or call at 609-766-2733.

Direct Client: State Of New York- Office of Temporary and Disability Assistance

Job Title: Database Architect

Duration: 30 Months

Location: Albany, NY

Hours Per Week: 40 Hours

Interview Type: Onsite/Webcam

Ceipal ID: SNY_ORAC842_PH

Job Code: HBITS-07-14842

Scope of Project:

This project involves the modernization of the State of New York's Homeless Management Information System (HMIS) by upgrading and consolidating multiple aging legacy systems into a single, comprehensive platform. The goal is to improve data management, system performance, reliability, security, and data integrity while providing a centralized solution to support homeless services programs. The selected Database Architect will play a key role in designing, implementing, maintaining, and securing Oracle databases, supporting ETL processes, and enhancing reporting and dashboard capabilities. The project also focuses on improving data governance through proper documentation, metadata management, and data lineage, enabling better business operations, strategic decision-making, and long-term scalability of the HMIS environment.

Responsibilities:

• Collaborate with business stakeholders, developers, analysts, and IT teams to understand data requirements and provide updates on data-related activities.
• Participate in meetings to gather business and technical requirements and support project planning and execution.
• Maintain detailed logs of data management activities, issues, and resolutions to ensure proper documentation and tracking.
• Ensure compliance with organizational data policies, security standards, and industry best practices.
• Continuously learn and adopt new data management tools, technologies, and processes as required by the project.
• Assist in documenting data sources, data definitions, metadata, and data lineage to support data governance initiatives.
• Develop and execute complex SQL queries to extract, validate, and analyze data for reporting and business needs.
• Support the generation and distribution of reports and dashboards by providing accurate and reliable data.
• Monitor data quality, integrity, and consistency across systems and identify potential issues or discrepancies.
• Complete assigned project and operational tasks within established timelines and quality standards.
• Troubleshoot and resolve data-related issues to support business operations and project objectives.
• Ensure database and data management activities align with project goals and contribute to the successful delivery of the HMIS modernization initiative.

Required/Preferred Skills:

• 7+ Years experience in designing logical and physical database models.
• 7+ Years experience designing oracle databases including triggers and packages.
• 7+ Years experience in performing Extract, Transform, and Load (ETL) techniques and flagging any failures.
• 5+ Years experience with SSIS design and development.
• 5+ Years experience in SQL programming including writing complex queries utilizing JSON in Oracle.
• 5+ Years experience using SQL Reporting Services (SSRS).
• 3+ Years experience with participating in meetings to understand data needs and communicate updates on data status. Maintaining detailed logs of data management activities and issues.

V Group Inc. is a NJ-based IT Services and Products Company with its business strategically categorized in various Business Units including Public Sector, Enterprise Solutions, Professional Services, Ecommerce, Projects, and Products. Within Public Sector business unit, we cater IT Professional Services to Federal, State and Local. We have multiple awards/ contracts with 30+ states, including but not limited to NY, CA, FL, GA, MD, MI, NC, OH, OR, CO, CT, TN, PA, TX, VA, NM, VT, and WA.

If you are considering applying for a position with V Group, or in partnering with us on a position, please feel free to contact me for any questions you may have regarding our services and the advantages we can offer you as a consultant.

Please share my contact information with others working in Information Technology.

Website: https://www.vgroupinc.com/publicsector

LinkedIn: https://www.linkedin.com/company/v-group/

Facebook: https://www.facebook.com/VGroupIT

Twitter: https://www.twitter.com/vgroupinc