Oracle PL/SQL Database Software Engineer
Pivotal Solutions
Salary undisclosed
Need a reasonable accommodation to apply or interview? Contact us.
JobMinglr uses automated technology to recommend jobs based on profile information and job preferences. Match Score does not determine eligibility for a position, prevent a user from viewing or applying to a job, or make hiring decisions on behalf of an employer.
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
Benefits
- remote work
About this role
Pivotal Solutions is seeking a database engineer to take ownership of core data management platform work across the full technology stack. You'll design and build Oracle and SQL Server database systems at scale, write PL/SQL and Transact-SQL procedures, develop supporting automation in Unix shell scripting and C, and handle the complete lifecycle from architecture through tuning and operations. This is a hands-on role that requires both technical depth—you'll be the primary contact for logical and physical database design—and breadth across OLTP systems, data warehousing, backup and recovery, and security.
The position demands eight years of IT experience overall, with at least four years specifically designing and administering large Oracle and SQL Server environments. You'll need fluency in PL/SQL, Transact-SQL, shell scripting, and C, plus working knowledge of Oracle 12.x and 19, SQL Server 14, and Linux/Unix platforms. Strong analytical and troubleshooting skills are essential, as you'll be solving complex data flow and architecture problems independently while also contributing to team-wide system design decisions.
This is a hybrid contract role based in Pittsburgh, with most work remote but occasional in-office presence required. Candidates must already be in the region or willing to relocate for those occasional meetings.
This role's local market on JobMinglr
Pay for this role
The employer didn't post a pay range for this role. That usually means pay is set in negotiation, which favors whoever arrives with numbers. Check ranges on comparable Oracle PL/SQL Database Software Engineer postings in Pittsburgh, and analyze any offer before you accept it.
Before you apply, worth reading
How JobMinglr reads this job
Every listing here is scored against your profile before you apply: skills overlap, experience level, location and work arrangement, each weighted and explained. You see the score and the reasons, not just a list. How the matching works.