Oracle PL / SQL Database Software Engineer

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