Oracle PL/SQL Database Software Engineer

Pivotal Solutions
Pittsburgh, PA
Job Description
In this role, you will assist in the design, development, and maintenance of the data management platform. You will have knowledge and experience with large-scale OLTP from multiple perspectives, including database, compute, information, performance, storage, network, process, flow, integration, security and application.

Requirements

  • 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
  • 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
]]>