Oracle PL/SQL Database Software Engineer

Pivotal Solutions - Pittsburgh, PA

Full-time

Remote - Pittsburgh, PA

Professional, Scientific, and Technical Services

About the position

The Oracle PL/SQL Database Software Engineer at Pivotal Solutions, Inc. is responsible for the design, development, and maintenance of the data management platform. This role requires a deep understanding of large-scale OLTP systems from various perspectives, including database, compute, and security. The successful candidate will provide leadership and strategy while actively participating in the implementation and operations of the platform.

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

Requirements

• Requires a four-year degree in Computer Science/Information Technology, Computer/Electrical Engineering or equivalent experience
• Minimum of eight years overall information technology experience
• 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 Oracle 12.x, Oracle 19, Red Hat Linux, and SQL Server 14
• Experience with PL/SQL, Linux/UNIX shell scripting, Transact-SQL, C
• Experience with Linux, AIX, Windows platforms
• Experience with 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