Database Architect

Albany, NY

Instant Apply

Today

Job Description

Job Title: Database Architect Expert
Task ID: HBITS-08-15035
Position Duration: 30 Months
Client: State of NY
Agency: Office of Mental Health

Please call (703) 466-0951 | (571) 351-1868 | (703) 348-3018 or email at

nysreqs@ilinksolutions.com

Description

Write queries in PL/SQL
Write database migration scripts to move forward any changes to database structures and data from the Development platform to the QA and Production platforms.
Develop scripts for automating support and maintenance; Compare databases on different platforms (Development, QA, Production) for differences in structure and produce database scripts to make the databases the same, structure-wise;
Troubleshoot and performance tune database queries;
Develop and troubleshoot processes that exchange data with other systems such as Statewide Financial System (SFS);
Implement work-arounds on the database side for failed processes in applications while the application side is being fixed;
Assist other developers working on database related items;
Interact with business users to translate requirements into technical models

Mandatory Qualifications

1	36 months experience upgrading legacy Oracle databases to current supported versions, and splitting up Oracle database instances that contain schemas for multiple applications into separate Oracle instances, one per application, while also preserving user accounts and roles and maintaining any access that was present between database schemas, using data facades or links.
2	84 months experience doing Oracle performance tuning by reviewing slow performing SQL and creating partitions, indexes, new table structures or SQL rewrites to ensure fast data retrieval. This includes regular checks of application databases for any SQL that is performing full table scans when accessing data and the implementation of indexes to avoid full table scans. All of this includes measuring the performance, before and after.
3	84 months experience with Oracle: Database design, PL SQL coding, stored procedures, packages, indexes, triggers, creating tables, etc.
4	84 months experience building and maintaining Oracle tables that contain Protected Health Information (PHI) within a health care environment.
5	84 months experience creating and maintaining Oracle database tables containing complex government financial data, specifically budgets, encumbrances, and payments within a government organization with an affected budget of 2 billion dollars or more.
6	84 months experience maintaining/supporting a Medicare D billing system including the creation and maintenance of NCPDP transactions such as B1, B2, B3, & E1.
7	60 months experience designing, building and maintaining data interfaces to Peoplesoft financial systems.
8	60 months experience working on a cost reporting application that supplies data for Medicare/Medicaid Cost Reports.
Required Documentation	" Re sume " Copy of Candidate Identification (i.e., Driver's License/Green Card/Visa and Passport if applicable) " Any documents referenced in the above Requested Qualifications (i.e., professional certifications, degrees, etc.)

i-Link Solutions requires a Bachelor's Degree or its equivalent in Computer Science, Computer Information Systems, Information Systems or a closely related field of study for all positions.

Disclaimer: i-Link Solutions Inc. provides equal employment opportunities (EEO) to all employees and applicants for employment without regard to race, color, religion, gender, sexual orientation, gender identity or expression, national origin, age, disability, genetic information, marital status, amnesty, or status as a covered veteran in accordance with applicable federal, state and local laws. We especially invite women, minorities, veterans, and individuals with disabilities to apply. EEO/AA/M/F/Vet/Disability

Numbers & Facts

Location

Albany, NY

Skills

Billingunmatched
Budgetingunmatched
Computer Scienceunmatched
Data Processingunmatched
Data Recoveryunmatched
Database Administrationunmatched
Database Architectureunmatched
Database Designunmatched
Database Programmingunmatched
Database Technologyunmatched
Editingunmatched
Financial Systemsunmatched
Governmentunmatched
Government Organizationsunmatched
Healthcareunmatched
Identify Issuesunmatched
Information Technology & Information Systemsunmatched
Information/Data Security (InfoSec)unmatched
Medical Billingunmatched
Medicareunmatched
Microsoft FASTunmatched
Oracleunmatched
Oracle Databaseunmatched
Oracle PL-SQLunmatched
PeopleSoft Financialsunmatched
Performance Tuning/Optimizationunmatched
Psychiatry and Mental Healthunmatched
Quality Assuranceunmatched
Requirements Managementunmatched
SQL (Structured Query Language)unmatched
Scripting (Scripting Languages)unmatched
Stored Proceduresunmatched

Level up your application

Professional resume templates

Browse dozens of recruiter approved resume templates, layouts and formats. Choose your favorite and make it your own in minutes.

Free resume templates

Resume Builder

Improve your existing resume or start from scratch and create a standout, ATS-friendly resume. Add job-specific content, download and apply.

Resume Builder