Apply Now

Oracle PL/SQL Database Software Engineer

Pittsburgh, PA, US • Posted 30+ days ago • Updated 10 hours ago

Full Time

On-site

Fitment

Dice Job Match Score™

🔢 Crunching numbers...

Job Details

Skills

OLTP
SAN
Process Flow
Leadership
SQL
Shell
Scripting
Automic
Workflow
Database Administration
Microsoft SQL Server DBA
Data Processing
Streaming
Data Flow
Data Warehouse
Reporting
Stored Procedures
Documentation
Backup
Recovery
Query Optimization
Computer Science
Electrical Engineering
Information Technology
Systems Analysis
Modeling
Software Development
Database
Oracle
Red Hat Linux
Microsoft SQL Server
PL/SQL
Unix
Shell Scripting
Transact-SQL
C
Linux
IBM AIX
Microsoft Windows
Microsoft Office
Microsoft Visual SourceSafe
JIRA
Software Development Methodology
Data Architecture
Data Management
Analytical Skill
Communication

OLTP
SAN
Process Flow
Leadership
SQL
Shell
Scripting
Automic
Workflow
Database Administration
Microsoft SQL Server DBA
Data Processing
Streaming
Data Flow
Data Warehouse
Reporting
Stored Procedures
Documentation
Backup
Recovery
Query Optimization
Computer Science
Electrical Engineering
Information Technology
Systems Analysis
Modeling
Software Development
Database
Oracle
Red Hat Linux
Microsoft SQL Server
PL/SQL
Unix
Shell Scripting
Transact-SQL
C
Linux
IBM AIX
Microsoft Windows
Microsoft Office
Microsoft Visual SourceSafe
JIRA
Software Development Methodology
Data Architecture
Data Management
Analytical Skill
Communication

Summary

Job Description
Job Summary:

In this role, you will assist in the design, development, and maintenance of the data management platform. A successful candidate must have knowledge and experience with large-scale OLTP from multiple perspectives:database, compute, information, performance, storage, network, process, flow, integration, security and application.This position will provide vision, leadership and strategy as well as actively participate in the design, implementation and subsequent operations.

Responsibilities:

Develop SQL Oracle PL/SQL procedures and packages
Develop Unix Shell scripts
Develop Transact-SQL procedures and packages
Develop and maintain application written in C
Support Automic Automation Workflow
Participate in all aspects of the System Development Life Cycle
Design, Develop and Implement technical solutions based on business requirements
Develop new and support existing software applications
Provide Oracle DBA and SQL Server DBA services for one or more projects
Define, design and implement data processing streams and database architectures
Assure efficient data flow, beginning with numerous raw data sources and ending with a highly tuned data warehouse providing web based report delivery
Design, implement and maintain complex functions of database systems including stored procedures, transformation services, triggers
Responsible for creating and maintaining all relevant documentation
Primary contact for the development of logical and physical database designs
Assists in all database functions including access, allocations, validity checks, security
Conducts backup, recovery and query tuning
Hybrid in-office and remote work with majority of time being remote.Candidates must currently live in the Pittsburgh region or be willing to relocate due to occasional in-office work

Required Skills

Requires a four-year degree in Computer Science/Information Technology, Computer/Electrical Engineering or equivalent experience
Minimum of eight years overall information technology experience. Has the experience to work, train and lead at the highest technical level of all phases of systems analysis and programming activity, including modeling language, across the full scope of software development cycle.
Minimum of four years of experience with design, implementation, tuning and administration of large Oracle database systems
Minimum of four years of experience with design, implementation, tuning and administration of SQL Server database applications
Experience with the following database technologies:Oracle 12.x, Oracle 19, Red Hat Linux, and SQL Server 14
Experience with the following languages:PL/SQL, Linux/UNIX shell scripting, Transact-SQL, C
Experience with the following platforms:Linux, AIX, Windows
Experience with the following development tools: Microsoft Office,Visual Source Safe, JIRA
Knowledge and experience in all aspects of the software development process.
Experience addressing unique issues of data architecture and data management
Strong analytical, troubleshooting, communication and interpersonal skills
Ability to work independently on multiple tasks

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.

Dice Id: 80183366
Position Id: 39cf3b6c1d688588f40781e2201a646
Posted 30+ days ago

Create job alert

Never miss an opportunity! Create an alert based on the job you applied for.

Similar Jobs

PLC Programmer

Pittsburgh, Pennsylvania

•

11d ago

A client of Innova Solutions is immediately hiring for a PLC Programmer Position type: Full-time, contract Duration: 18 months Location: Pittsburgh Pennsylvania 15203 About the Role: We're looking for a PLC Programmer who thrives on solving complex data challenges, streamlining integrations, and turning business needs into scalable technical solutions. In this role, you'll be at the heart of our data ecosystem, designing robust Oracle database applications, developing ETL pipelines, and enabli

Easy Apply

Contract

Depends on Experience

Oracle PL/SQL Developer

New Jersey

•

Today

Role: Oracle PL/SQL Developer Location: Westlake, TX (primary) or Jersey City, NJ or Smithfield, RI (onsite every other week) Key Requirements: 7-10 years of solid database development experience. Expert-level proficiency in Oracle PL/SQL and performance tuning. Strong hands-on experience with Informatica ETL. Previous experience in the financial services or banking domain is highly preferred. Strong skills in quantitative, multi-dimensional analysis, working with data and data tools Demonstrat

Easy Apply

Full-time

Database Administrator

No location provided

•

Today

Job Description Database Administrator Provide administration, maintenance, monitoring, and support for enterprise Oracle, PostgreSQL, and Microsoft SQL Server database environments. Perform database installation, configuration, health monitoring, backup validation, troubleshooting, patching, and performance optimization while ensuring the availability, integrity, and security of mission-critical systems supporting federal customers. Compensation & Benefits: Estimated Starting Salary Range f

Full-time

USD 110,000.00 - 120,000.00 per year

Oracle PL/SQL Developer

Remote

•

14d ago

Oracle PL/SQL Developer | 100% Remote Clearance Required-Existing DoD, Public Trust or Secret clearance (or can obtain one)Position SummaryWe are seeking a highly experiencedSenior Oracle PL/SQL Developer / Database Architectto support the development, modernization, and ongoing maintenance of mission-critical enterprise applications and Oracle database environments. The ideal candidate will bring5+ years of hands-on Oracle PL/SQL development experience, along with strong database architecture

Easy Apply

Contract

$60 - $70

Search all similar jobs

More jobs at Pivotal Solutions in Pittsburgh, PA