Database Architect Expert

Found in: Talent US C2 - 3 weeks ago

Albany, United States PSI International Full time
HBITS-05-13380 Database Architect Expert
Agency Name: Information Technology Services (ITS)
Is this a Project/Program specific Position? Yes
If YES, list the Project/Program Name:
Enterprise Data Warehouse and various Health Cluster projects within the agency.
provide a short description of the Position:
Data warehouse database and ETL(Extract, Transform, Load) process redesign and implementation.
Provide a list of the day to day tasks to be performed by the Selected Candidate: Design and implement an Enterprise Data Warehouse solution using the Kimball methodology of data warehouse Star schema and dimensional data modeling.
Implement and maintain Fine Grain Access Control Audit (FGACA) and Oracle Virtual Private Database(VPD) to protect Health Care data such as Medicaid, Pharmacy, and HIPAA Protected Health Information (PHI).
Guide the ETL team in shaping the ETL architecture and must be able to resolve difficult design and build issues. Expert level experience with the Informatica toolset is required to develop and maintain current and future data marts.
Extract and Analyze data from numerous heterogenous patient and staffing data systems, used for the design, implementation and maintenance of complex reporting data marts.
Liaison between technical staff, non-technical staff and business clients to gather business requirements needed to build and implement complex data warehouse database structures.
Identify, troubleshoot, and resolve difficult data warehouse technical issues, including Production break/fix problems.
Number of Form 2 Candidate Responses allowed per Contractor, per Position? 1
Target Start Date: 2024-06-17
Engagement Length in Months: 30. 0
Is this a Full or Part-Time Position?
(Full-Time is 40 Hours Per Week) Full Time
If Part-Time, enter approximate number of hours per Week:
What are the daily work hours?
(Note if negotiable or list preferred start and end time): Between 8:00 AM 9:00 AM and 4:30 PM- 5:30 PM with 1D2 hour for lunch
Where is the physical work office located? 800 North Pearl Street, Menands, NY, 12204
Is telecommuting allowed for this position?
(As designated by the Authorized User) Yes
If YES, note if negotiable or list the percentage allowed/number of days allowed per week 50%
What is the format of the Candidate interview? Webcasting
If Webcasting, is Candidate required to be on camera? Yes
What type of software is typically used by the Agency? Oracle; Informatica; SQL Server; IDERA
What type of hardware is typically used by the Agency? Client UNIX

Position Mandatory Qualification
Position Job Title:
Database Architect
Determines database structural requirements by analyzing client operations, applications, and programming; reviews objectives with clients; evaluates current systems; provides database support by coding utilities, responding to user questions, and resolving problems.
OGS HBITS Determination
Position Skill Level:
Expert
84+ Months: Candidate is able to provide guidance to large teams and/or has extensive industry experience and is considered at the top of his/her field.

Position Requested Qualifications
1. 84 months of experience designing and implementing Enterprise Data warehouse architecture solutions using the Kimball methodology of dimensional modeling.
2. 84 months of experience designing and implementing Oracle Virtual Private Database (VPD) and Oracle Fine grained Auditing in an Enterprise Data Warehouse environment.
3. 84 months of experience in collaborating with ETL (Extract, Transform, Load) developers as a team lead in designing Informatica ETL process and data warehouse database architecture.
4. 84 months of experience working with non-technical and business clients to gather, analyze, and
5. 84 months of experience analyzing, interpreting, and outputting patient mental health data from numerous heterogenous systems including pharmacy, Medicaid, incident, patient movement, and human resource systems.
6. 84 months of experience in relational data management disciplines and design and development experience using Oracle technologies.
7. Bachelor's Degree 6

Additional Information Requests:
Are there additional security requirements for the Authorized User? Yes
If YES, include the additional security requirements: Mandatory ITS Security Agreements and Fingerprint-based Background Check.
Will additional training potentially be required during the Engagement? Yes

  • Database Architect- Expert

    Found in: Lensa US P 2 C2 - 2 hours ago

    Albany, United States Mindlance Full time

    Provide a short description of the Position: Act as Expert Database Architect working for NYS Information Technology Services on behalf of the NYS Department of Transportation to fulfill the duties as described below. Provide a list of the day-to-day tasks to be performed by the Selected Candidate: Interact with Agency/business subject matter experts to...

  • Database Architect Expert

    2 weeks ago

    Albany, United States PSI International Full time

    HBITS-05-13380 Database Architect Expert Agency Name: Information Technology Services (ITS) Is this a Project/Program specific Position? Yes If YES, list the Project/Program Name: Enterprise Data Warehouse and various Health Cluster projects within the agency. provide a short description of the Position: Data warehouse database and ETL(Extract, Transform,...

  • Database Administrator Expert

    2 weeks ago

    Albany, United States Princeton IT Services Full time

    Job DescriptionJob DescriptionJob Title: Database Administrator ExpertLocation: Albany, NYRole Type: ContractJob Overview:The Database Administrator Expert will play a pivotal role in supporting the priorities and initiatives. This position will be integral to the project portfolio, particularly in supplementing the staff for initiatives resulting from the...

  • Expert Software Architect

    5 days ago

    Albany, United States Castletop Logistics LLC Full time

    Job Overview: We are seeking a talented Expert Software Architect HBITS-05-13394. Required to work on site starting day 1. **DURATION**:21 Months **LOCATION**: Albany, NY - _Onsite_ This position will be in support of the NYS Tax Modernization Program. This program will encompass multiple projects to modernize legacy systems within the NYS Department of...

  • Software Architect Expert

    2 weeks ago

    Albany, United States CareerBuilder Full time

    Cedar Park Group is looking for an Expert Software Architect. 50% Remote. Full-time. 7.30AM-4.00PM and 9AM-5.30PM. 30 month contract. Duties: Staff augmentation providing application development, enhancement, support, ongoing maintenance, mentoring and architecting expertise in an Oracle Java application environment and related Secure Software Development...

  • Software Architect Expert

    Found in: Lensa US P 2 C2 - 4 hours ago

    Albany, United States Cedar Park Group Full time

    Cedar Park Group is looking for an Expert Software Architect. 50% Remote. Full-time. 7.30AM-4.00PM and 9AM-5.30PM. 30 month contract. Duties: Staff augmentation providing application development, enhancement, support, ongoing maintenance, mentoring and architecting expertise in an Oracle Java application environment and related Secure Software Development...

  • Software Architect Expert

    4 days ago

    Albany, United States Great Tech Global Full time

    Job DescriptionJob DescriptionJob Title: Software Architect ExpertSoftware Architect Expert - Hybrid/Albany, NY (40% Remote; In office Tues./Wed./Thurs.) / ContractClient: NYS ITS (NYS Information Technology Services - ITS)Location: W A Harriman Campus Bldg. 8, Albany, NY 12227 (40% Remote; In office Tues./Wed./Thurs.)DURATION: 30 Months HOURS: 40 hrs. per...

  • Systems Architect Expert

    Found in: beBee jobs US - 2 weeks ago

    Albany, New York, United States Quality Healthcare Staffing Full time

    Job Title: Systems Architect ExpertLocation: Albany, New YorkPayrate: $53 - $58 per hourSchedule: 8:00 A.M. - 5 P.M, Monday to FridayDue Date: 04/15/2024Responsibilities:Architect technology solutions aligning with business requirements and standards.Troubleshoot OS configurations, storage, and networking of business applications.Collaborate with vendors for...

  • Database Administrator- Expert

    Found in: Lensa US P 2 C2 - 4 hours ago

    Albany, United States Mindlance Full time

    Provide a short description of the Position: The APD project is designed to deliver an integrated health care data warehouse and analytic platform to provide policymakers, researchers, and consumers with a comprehensive repository of health care information. The NY APD will be used for quality measurement, population health monitoring, value-based...

  • Software Architect Expert

    Found in: Careerbuilder One Red US C2 - 3 days ago

    Albany, NY, United States Godspeed Group Full time

    Job Title: Software Architect ExpertLocation: 40% Remote; In office Tues./Wed./Thurs.Duration: 30 MonthsHours: 40 hrs. per week / Mon-Fri, 8:30am to 5pm ET (negotiable)Position Skill Level: 84+ Months: Candidate is able to provide guidance to large teams and/or has extensive industry experience and is considered at the top of his/her field.Requested...

  • Database Architect

    2 weeks ago

    Albany, United States LanceSoft Full time

    Responsibilities: Working with large and complex Oracle data warehouses, data marts and OLTP databases. Overseeing the creation/modification of Oracle database tables of the appropriate type for the situation. Writing/executing SQL for querying various Oracle databases as well as the Informatica Metadata Repository for validating unit and QA testing,...

  • Database Administrator

    4 days ago

    Albany, United States Absolute Staffing & Consulting Solutions Full time

    Job DescriptionJob DescriptionAbsolute Staffing is searching for a Database Administrator to work with our client. Location: Albany, NY (12207)Duration: 24 Months Job Description:84 months of Experience designing and developing logical and physical data models, and creating DDL scripts for tables, views, indexes, triggers, stored procedures.84 months of...

  • Database Administrator

    4 days ago

    Albany, United States Absolute Staffing & Consulting Solutions Full time

    Job DescriptionJob DescriptionAbsolute Staffing is searching for a Database Administrator to work with our client. Location: Albany, NY (12207)Duration: 24 Months Job Description:84 months of Experience designing and developing logical and physical data models, and creating DDL scripts for tables, views, indexes, triggers, stored procedures.84 months of...

  • Systems Developer Expert

    Found in: Lensa US P 2 C2 - 3 hours ago

    Albany, United States Cedar Park Group Full time

    Cedar Park Group is looking for an Expert Systems Developer. 50% Remote. Full-time. 8AM-5PM. 11 month contract. Duties: Develops and implements applications and programs for the backend processing systems used in businesses and organizations. Work in coordination with a team of developers to write the new Facility Application Management system in ASP.net...

  • Software Architect

    Found in: Lensa US P 2 C2 - 2 hours ago

    Albany, United States Five Cubes, Inc. Full time

    Job Title: Software Architect - 13184 Location: Albany, NY Duration: 30 Months Direct ClientJob Description: Daily Tasks include but not limited to the following: Evaluate existing and emerging technology, business requirements for the purpose of architecting efficient, portable and scalable solutions. Analysis, modeling, design, coding, testing and...

  • Systems Architect

    2 weeks ago

    Albany, United States DCM INFOTECH LIMITED Full time

    Daily Tasks Will Include As integration architect helping NYS agency application development teams to architect, design/develop and implement reusable IT assets as web services and APIs. Administration and configurations for the NYS API Management (gateway) shared services primarily on Akana platform. Resolving various consumer requests (via ITSM tickets) to...

  • Software Architect

    Found in: Lensa US P 2 C2 - 4 hours ago

    Albany, United States Mindlance Full time

    Provide a short description of the Position: The Software Analyst will analyze and document OMH applications, workflow processes, and other strategy, standards and best practices for the NYS Office of Mental Health and other agency needs. The Optimize OMH Applications project is an initiative to update the Office of Mental Health's (OMH) ITS supported...

  • Database Architect

    7 days ago

    Albany, United States CareerBuilder Full time

    This is a 30-month opportunity on the Hourly-Based IT Services (HBITS) Contract at the State of New York. (Possibility of extension). Required Experience: 84 Months Experience writing complex SQL, PL/SQL (stored procedures/functions), with Oracle 12c or higher, including 19c, to Informatica mappings 48 months of Experience developing Rhapsody routes,...

  • Oracle ETL Architect- C2C Contract Position

    2 weeks ago

    Albany, United States Fortuna BMC Full time

    Are you passionate about architecting efficient data solutions within the Oracle ecosystem? Do you thrive in designing and optimizing Extract, Transform, Load (ETL) processes to drive data-driven insights and decision-making? As an Oracle ETL Architect, you will play a pivotal role in designing, implementing, and optimizing ETL solutions using Oracle...

  • Java / JEE Architect

    Found in: Talent US C2 - 1 week ago

    Albany, United States Trigyn Technologies Full time

    Job Description: Trigyn's direct government client has an immediate need for a Java / JEE Architect in Albany, NY. Description: The consultant will design and assist with the implementation of both small and large-scale software systems. The Software Architect will design, develop, implement, support, and enhance, custom applications written in...