Hybrid Oracle PL/SQL DB Engineer - Remote-friendly

Pivotal Solutions; Pittsburgh (Allegheny County); Hybrid; USD 90,000 - 130,000; Full time

Job summary

Pivotal Solutions in Pittsburgh, PA, seeks an Oracle PL/SQL Database Software Engineer to design, develop, and maintain a data management platform. The role emphasizes large-scale OLTP systems and security, with leadership across the SDLC.

Responsibilities include developing Oracle PL/SQL and T-SQL procedures, Unix scripts, C applications, and providing DBA services across projects, with a strong focus on data processing streams and data warehouse delivery.

Qualifications

• Four-year degree in Computer Science/IT or equivalent.
• Minimum eight years IT experience in systems analysis and programming.
• Experience with Oracle and SQL Server DB design and administration.
• Experience with large OLTP and data warehouse environments.

Responsibilities

• Develop SQL Oracle PL/SQL procedures and packages
• Develop Unix Shell scripts
• Develop Transact-SQL procedures and packages
• Develop and maintain applications written in C
• Provide Oracle DBA and SQL Server DBA services for projects
• Design, implement and maintain data processing streams and database architectures
• Assure efficient data flow and tune queries
• Hybrid in-office and remote work with Pittsburgh region relocation as needed

Skills

Oracle PL/SQL

SQL Server

UNIX Shell Scripting

C

Data Warehousing

SDLC

Performance Tuning

Communication

Education

Bachelor's degree in Computer Science/IT or related field

Tools

OracleDB

Visual Source Safe

JIRA

Job description

Pivotal Solutions in Pittsburgh, PA, seeks an Oracle PL/SQL Database Software Engineer to design, develop, and maintain a data management platform. The role emphasizes large-scale OLTP systems and security, with leadership across the SDLC.

Responsibilities include developing Oracle PL/SQL and T-SQL procedures, Unix scripts, C applications, and providing DBA services across projects, with a strong focus on data processing streams and data warehouse delivery.