Position Summary:
Designs, develops, and delivers database components of software applications using procedural language extension PL/SQL to all other Oracle tools and technology, and troubleshoots any problems with them. Technical leadership skills in Oracle PL/SQL, Oracle Forms, XML, BI Publisher, Linux. Develops, modifies, and tests the codes, scripts, and forms that allow a system to run different types of applications. Executes trial runs of software applications, reviews programs, and performs system analysis.
Position Responsibilities:
- 7 to 15 years of experience
- Interacts with business teams to clarify requirements and business needs.
- Collaborates with other developers, architects, and quality assurance teams to determine optimal solution architecture, efficiency, maintainability, and scalability.
- Troubleshoots, corrects errors in programs, and optimizes code to ensure performance and security requirements.
- Prepares and maintains documents, code documentation, workflow charts, and diagrams as needed to describe the program’s intended functionality, the data flow, the logic used, and any significant considerations made.
- Writes complex queries, stored procedures, software packages, and triggers.
- Implements the data model that the required applications require, the rules for data integrity, and the specified functions for accessing and manipulating the application data.
- Ensures the databases are accessible to all users and ensures the databases can store the information that is put into the compute
Top Two Skills that the candidate must have
- Must be able to write complex SQL queries (PL/SQL) in an Oracle Database
- During the interview process candidates must demonstrate that they have the ability to write these complex queries – white board interview
- Must have CURRENT experience working with Oracle / Backend Database for School District is Oracle.
Although both Oracle and SQL Database systems use a version of Structured Query Language, or SQL, MS SQL Server uses Transact SQL, or T-SQL. Oracle, meanwhile, uses PL/SQL, or Procedural Language/SQL.
% breakdown of responsibilities:
- 90% head down coder – Writing complex SQL Queries in an Oracle DB 11g version and above