Arisant is looking for a motivated individual to join our DevOps team as Mid/Senior PL/SQL Developer. In this role, you will work in a team environment to design and build PL/SQL ETL/batch oriented solutions to process large volumes of data. You will make design decisions around implementing functionality in a Oracle RAC environment. The ideal candidate will have an understanding of latch contention specific to RAC and cache fusion / interconnect considerations and their implication to system performance.
To be successful in this role, you will need to follow existing development processes to interpret requirements, author detailed design documents, develop and test software modules and produce well-written technical documentation. Additionally, you will need to be able to talk about when to use triggers, procedures, packages, functions, other constructs to implement specific use cases.
Ability to discuss which features are implemented in PL/SQL and SQL execution contexts and the impact to performance of execution context switching.
Ability to do relational database modeling and implement scripts to create, modify and delete objects.
Ability to write DDL statements to support new features and functions promoting functionality to other environments.
Ability to complete performance tuning of Oracle SQL Statements using Explain Plan and TKPROF.
Ability to diagnose performance problems, come up with solutions such as adding indexes or re-writing code.
Ability to interface with QA and BA analysts to define and refine designs and implementations.
Understanding of common analytical functions and when to best use them.
Ability to do advanced debugging including using tools that ultimately interface with DBMS_DEBUG.
Must have strong application design, PL/SQL programming skills, and advanced SQL skills – ANSI and Oracle.
Must have strong interpersonal and leadership skills while being able to multitask and handle conflicting priorities.
VLDB and Data Warehouse experience.
Experience working in a Linux environment.
Ability to interpret requirements, create design documents and turn design into code.
Oracle SQL tuning.
Data Modeling experience including dimensional modeling.
Experience with the Following is a Plus:
Development and Production DBA experience
No relocation expenses, travel expenses, or visa sponsorship are offered. NO THIRD-PARTY RECRUITERS.
Arisant is an Affirmative Action-Equal Employment Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, sexual orientation, gender identity, disability, protected veterans’ status, age, or any other characteristic protected by law.