Our client is looking Oracle PL/SQL Developer for Long term project in Richardson, TX (Looking for Local) below is the detailed requirements.
Job Title : Oracle PL/SQL Developer
Location : Richardson, TX (Looking for Local)
Duration : Long term
Job description:
- Bachelor's degree in Computer science or equivalent, with minimum 10+ Years of relevant experience.
You should have Ability to analyze, design and support implementation of Oracle PL/SQL Packages, Procedures, Functions, Views, create/alter database tables and PL/SQL collections based on business requirements and specifications
Must enjoy working in a fast-paced environment and able to adapt easily to change.
Experience writing advanced Oracle SQL and PL/SQL on large Oracle databases version 12c (currently on 19c) and above on RAC (Real Application Clusters) and EXADATA platforms.
Ability to translate business and functional requirements into technical specifications.
Experience with Functional Programming.
Highly competent working with large data transfers, batch processing and writing highly scalable and performant SQL and PL/SQL code.
Proficient in Table partitioning and Indexing strategies.
Experience creating, managing, and developing using Oracle Advanced Queues.
Data analysis skills to debug, trace and fix performance and production issues.
Strong understanding of Oracle database architecture and experience in database modelling of OLTP systems.
Strong experience with SQL and PL/SQL tuning. Not limited to running explain plans and adding query hints.
Experience writing automated PL/SQL unit tests using frameworks like utPLSql.
Proficient in version control tools like GIT to manage versions of scripts.
Experience working with CICD tools and managing automated deployments and builds for databases.
Process and detailed oriented. Ability to do perform code reviews and mentor junior developers on technical skills.
Must have good English written and verbal communication skills.
Self-motivated and able to work from home productively.
Able to work extended hours during critical deliveries.
Plus: Knowledge or Experience working in Oracle Cloud Infrastructure (OCI) and Services (Oracle Golden Gate, Oracle Analytics Cloud, Oracle BI Publisher, OpenSearch (ElasticSearch)).
Plus: Knowledge and capabilities with other software technologies. (Java, Python, Control-M, shell scripting, docker, Jira, Confluence).
- Demonstrate excellent communication skills including the ability to effectively communicate with internal and external customers.
- Ability to use strong industry knowledge to relate to customer needs and dissolve customer concerns and high level of focus and attention to detail.