Job Description :
The purpose of the Oracle Database Developer is to contribute, as part of the Data Team, detailed design, coding of packages, stored procedures & functions, and testing for Oracle-based applications using Oracle SQL and PL / SQL in a Solaris / Linux environment.
Essential Functions of The Position :
- Develop solutions using database development tools and languages such as Oracle PL / SQL.
- Follow coding standards detailed in database developer handbook.
- Developing design documentation.
- Review technical documents to ensure consistency, accuracy, and compliance with enterprise direction and security standards.
- Schedule and participate in code walkthroughs.
- Provide assistance to other teams as needed,
- Investigate and resolve all assigned defects.
- Represent Data Team in requirement and design sessions.
- Recommend database design elements with data architects or data manager.
- Collaborate with clients, business analyst, technical staff, and project team members to plan, design, develop, implement, and enhance applications, scripts, procedures, and metadata for relational databases.
- Work with our Finance Source partners to provide guidance and direction during the enrollment process.
- Business Operations Level Support / on call responsibilities.
- Maintain safety, security, and privacy standards throughout all areas of responsibility.
Essential Requirements for The Position :
Bachelor's degree in computer science, or related fieldMinimum of years' Experience in Oracle databases in the role of Database DeveloperMinimum of years' experience with SQL / PL / SQLExperience in Unix / Linux shell scripting and Perl ScriptingExperience in Web-Based ArchitectureMinimum of year Logical / physical database design experience is a plusFamiliarity with TOAD / SQL Navigator / Oracle SQL DeveloperExperience with using Oracle client toolsets such as SQL Plus and SQL LoaderExperience with BI Tools like Cognos and Tableau is a plus.Non-Essential Requirements for The Position :
Experience with Oracle performance tuning techniquesExperience in working in an Agile Scrum team is preferredJava / JEE experienceKnowledge of XML / XSL / XSLT technologiesLDAP experienceOther RBDMS experience (MS-SQL Server, PostgreSQL, MySQL, etc)Knowledge of Oracle Application Express