Software Engineer II (Oracle)

Company: IDI Consulting
Location: Pittsburgh
Posted on: November 20, 2020

Job Description:

Responsibilities Develop Oracle PLSQL procedures and packages Develop Unix Shell scripts Develop Transact-SQL procedures and packages (nice to have) 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 Required Skills Requires a four-year degree in Computer ScienceInformation Technology, ComputerElectrical Engineering or equivalent experience Minimum of five 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, Red Hat Linux, and SQL Server 14 Experience with the following languages PLSQL, LinuxUNIX shell scripting, Transact-SQL Experience with the following platforms Linux, AIX, Window 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

Keywords: IDI Consulting, Pittsburgh , Software Engineer II (Oracle), Other , Pittsburgh, Pennsylvania