Database Architect (Senior)

ONLY CONSIDERING CANDIDATES WITH 5 YEARS OF EXPERIENCE WHO RESIDE WITHIN A COMMUTABLE DISTANCE TO ALBANY NY NOT OPEN TO RELOCATION

Join GD Resources for dynamic opportunities in business management and IT where innovation meets excellence.

About the Company

GD Resources is a Veteran Women-Owned Business Management and Information Technology company committed to excellence. GD Resources provides dynamic opportunities for veterans and professionals alike to contribute to innovative projects and drive success in a collaborative and supportive environment. Join us to make a difference advance your career and grow with a company that values integrity diversity and continuous improvement.

Job Title: Senior Database Architect

Task Order: HBITS
Agency: State of New York Office of Information Technology Services (ITS)
Location: Hybrid Albany NY
Duration: 12 Months
Rate: Depends on experience

Position Overview

This HBITS role supports the Reporting team with MENA enhancements and other enterprise reporting duties. The Senior Database Architect determines database structural requirements by analyzing client operations applications and programming; reviews objectives with clients; evaluates current systems; and provides database support by coding utilities responding to user questions and resolving problems. The candidate must be able to work independently without assistance and provide guidance to others and may have an advanced education.

Responsibilities

• Manage ODI SQL scripts for transferring loading and editing data between databases
• Manage a data warehouse to hold LATS and WFA (Work Force Analytics) data
• Manage scripts for loading LATS and WFA data from extracts into Oracle tables using UNIX
• Convert UNIX scripts into ODI
• Convert Crystal Reports into OAS/OBIEE
• Manage OBIEE reports and dashboards

Qualifications

• Senior-level experience (5 7 years); candidate is able to work independently without assistance and provides guidance to others; may have an advanced education
• 5 years of experience with Oracle Business Intelligence Enterprise Edition (OBIEE) / Oracle Analytics Server (OAS)
• 5 years of experience with Oracle Data Integrator (ODI)
• 5 years of experience with UNIX
• 5 years of experience with SQL or PL/SQL

Required Documents

• R sum
• Copy of candidate identification (drivers license passport visa if applicable)
• Degree/certifications (if applicable)
• Three professional references
• Completed Form 2

GDR is an Equal Opportunity Employer. We consider all qualified applicants without regard to race color religion sex gender identity national origin age disability veteran status or any other protected status under applicable law. We are committed to equal opportunity in all aspects of employment including hiring promotion compensation and benefits.