Orace PL/Sql Developer

Pyramid Consulting, Inc; Plano (TX); Hybrid; USD 90,000 - 120,000; Full time

Benefits offered by this job

Long-term/Short-term Disability

Health and Dependent Care Reimburse- m

Insurance (Accident, Critical Illness,

Hospital Indemnity, Legal)

401(k) plan and contributions

Job summary

Pyramid Consulting, Inc. seeks an Oracle PL/SQL Developer for a full-time role spanning Charlotte, NC and Plano, TX in a hybrid setup. The candidate will participate in end-to-end SDLC, contribute to design discussions, and implement code with focus on reliability and quality.

Responsibilities include documenting requirements, performing code reviews, and coordinating testing strategies to ensure data integrity and seamless deployments.

Qualifications

• Must have hands-on Oracle/Exadata experience.
• Strong PL/SQL development and performance tuning skills.
• Experience with ETL/ELT frameworks for data warehousing.
• Excellent communication and collaboration across teams.

Responsibilities

• Document business requirements and help elicit specifications.
• Facilitate design discussions and document decisions for the technical team.
• Code and integrate new features while preserving system stability.
• Perform code reviews and maintain source control repositories.

Skills

Oracle Exadata

PL/SQL

ETL/ELT

Communication skills

SDLC knowledge

Education

Bachelor's degree

Job description

Immediate need for a talented Orace PL/Sql Developer. This is a Fulltime opportunity with long-term potential and is located in Charlotte, NC and Plano, TX (Hybrid).

Job ID:26-26150

Benefits- Along with competitive pay, as a full-time employee you are also eligible for the following benefits:

• Long-term/Short-term Disability
• Health and Dependent Care Reimbursement Accounts
• Insurance (Accident, Critical Illness , Hospital Indemnity, Legal)
• 401(k) plan and contributions dependent on salary level

Key Responsibilities:

• Contribute to the requirements elicitation process by documenting assigned parts of business requirements, in line with guidance provided
• Facilitate software application design discussions, and document design decisions to guide the technical team towards building software solutions
• Participate in coding and integrate new features or updates into existing applications, with a focus on maintaining system stability
• Conduct code reviews, do changes to the codebase and maintain code repositories
• Implement test strategies, analyse results, and coordinate bug fixes to uphold the software quality standards
• Develop user training programs, documentation, and support frameworks to ensure a smooth transition to new software applications
• Actively participate in resolving production issues and recommend preventive strategies to enhance system reliability
• Maintain detailed records of code, testing techniques, and support activities to enrich the knowledge base and assist other similar projects

Key Requirements and Technology Experience:

• Must have skills: - Oracle Exadata, PL/SQL, ETL/ELT
• Visa- US Citizen, Green Card, and H4-EAD Only
• A collaborative spirit and excellent communication skills.
• The ability to handle end to end SDLC phases from requirement gathering to implementation.
• A knack for translating complex requirements into actionable development tasks.
• A passion for design and hands-on coding experience
• A proactive approach to testing, troubleshooting, and refining our applications.
• The ability to work with cross-functional teams and do software integration.
• Required Skill and Experience
• Hands on Experience with Oracle and Oracle Exadata.
• Sound knowledge of advanaced PL/SQL Programming
• Good Knowledge of SQL Development, Performance Tuning, Data Analysis and trouble shooting
• Good experience in end-to-end implementation of DW BI projects, especially in data warehouse and mart developments
• Good understanding of Data integration, Data Quality and data architecture """
• Experience to Big data technologies is preferred.
• Experience in preparing test scripts and test cases to validate data and maintaining data quality
• Experience with design and implementation of ETL/ELT framework for complex warehouses/marts.
• Knowledge of large data sets and experience with performance tuning and troubleshooting
• Hands-on development, with a willingness to troubleshoot and solve complex problems
• CI / CD exposure
• Bachelor’s degree or foreign equivalent required from an accredited institution. Will also consider three years of progressive experience in the specialty in lieu of every year of education.
• This position may require relocation and/or travel to work/project location.
• Candidates authorized to work for any employer in the United States without employer-based visa sponsorship are welcome to apply.

Our client is a leading IT Industry and we are currently interviewing to fill this and other similar fulltime positions.

Pyramid Consulting, Inc. provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws.