Database Developer(Oracle (PL/SQL) + PostgreSQL)

Database Developer(Oracle (PL/SQL) + PostgreSQL)

Posted 2 weeks ago by 1754981315

Apply
Negotiable
Outside
Remote
USA
Apply
.NET Framework Amazon Web Services (AWS) Application Programming Interface (API) Business Operations Cloud Applications Cloud Computing Cloud Database Cloud Technology Database Management Database Management Systems Database Models Data Migration Foreign Keys Generic Programming Information Technology JSON Management Management Systems Mobile App Mobile Devices PL/SQL PostgreSQL Primary Keys Query Optimisation Software Coding Software Development SQL (Programming Language)

Summary: The Database Developer role focuses on analyzing, designing, developing, and implementing data solutions for OPHE applications using Oracle and PostgreSQL databases. The position involves participation in the development and support of web and mobile applications, as well as the creation of complex database objects and processes. The role requires significant experience with SQL and database management systems, particularly in a healthcare context. The position is remote, allowing for flexibility in work arrangements.

Key Responsibilities:

  • Participate in the development and support of .Net/Tableau Web and Mobile Applications and services as specified by OPHE.
  • Develop stored procedures, packages, cursors, and triggers in Oracle and PostgreSQL to support applications and integrate in-house applications with cloud-based apps.
  • Develop new batch processes for data migration, transformation, and integrate additional data sources.
  • Experience with Cloud database technologies, preferably AWS.
  • Participate in coding and enhancements.
  • Tune, script, and extract, transform, and load.
  • Support daily business operations related to complex OPHE systems.
  • Run systems manually (test files, re-runs, troubleshoot) for exception cases.

Key Skills:

  • At least 5+ years of experience with Oracle, PostgreSQL, and PL/SQL.
  • Experience creating tables, packages, types, stored procedures, cursors, triggers, views, arrays, collections, and other objects.
  • At least 5+ years of experience with SQL, PostgreSQL, and Oracle PL/SQL utilizing JSON data and Advanced Queuing to support web API and applications.
  • Experience designing and implementing logical and physical database models, including indexes, primary keys, foreign keys, and constraints.
  • Proficiency in database management systems such as Oracle and PostgreSQL.
  • Strong SQL programming skills and experience with query optimization techniques.
  • Proficiency in JSON and PostgreSQL support for JSON.
  • Exposure to healthcare domain and .NET is an added advantage.
  • Bachelor's degree in computer or information technology.

Salary (Rate): undetermined

City: undetermined

Country: USA

Working Arrangements: remote

IR35 Status: outside IR35

Seniority Level: undetermined

Industry: IT

Detailed Description From Employer:

Database Developer (Oracle (PL/SQL) + PostgreSQL)

Analyze, design, develop, and delivery/implement data solutions for OPHE applications using complex Oracle and PostgreSQL databases.

Location: Albany, NY (remote)

Responsibilities :

Participate in the development and support of .Net/Tableau Web and Mobile Applications and services as specified by OPHE.
Develop stored procedures, packages, cursors and triggers in Oracle and PostgreSQL to support applications and integrate in-house applications with cloud-based apps.
Develop new batch processes for data migration, transformation and integrate additional data sources.
Experience with Cloud database technologies, preferably AWS
Participate in coding and enhancements.
Tune, script, and extract, transform, and load.
Support daily business operations related complex OPHE systems.
Run systems manually (test files, re-runs, troubleshoot) for exception cases.

Qualifications

Minimum Qualifications

At least 5+ years of experience with Oracle, PostgreSQL, and PL/SQL. Experience should include creating tables, Packages, Types, stored procedures, cursors, triggers, views, arrays, collections and other objects.
At least 5+ years of experience with SQL, PostgreSQL and Oracle PL/SQL utilizing JSON data and Advanced Queuing to support web API and applications.
Experience designing and implementing logical and physical database models, including indexes, primary keys, foreign keys, and constraints.
Proficiency in database management systems such as Oracle and PostgreSQL
Strong SQL programming skills and experience with query optimization techniques
Proficiency in JSON and PostgreSQL support for JSON.
Exposure to healthcare domain and .net are an added advantage.
Bachelor's degree in computer or information technology

Apply
Similar Jobs
Loading data...