Oracle PL/SQL Developer

Title: Oracle PL/SQL Developer
Location - Edison, NJ - Min 2 days mandatory

Type- Contract
Oracle PL/SQL Developer w/ capital markets domain expertise

Senior Technical Specialist with Oracle PL/SQL

Job Summary

The Senior Technical Specialist in Oracle PL/SQL will be responsible for the technical design, development, and maintenance of Oracle PL/SQL code. They will contribute to the implementation and enhancement of Oracle databases, ensuring optimal performance and data integrity. (1.) Key Responsibilities

1. Develop and maintain complex oracle pl/sql procedures, functions, packages, and triggers

2. Collaborate with cross functional teams to analyze requirements and design efficient database solutions

3. Optimize sql queries and database code for performance improvements

4. Troubleshoot and resolve database issues in a timely manner

5. Implement data security protocols and ensure compliance with data protection regulations

6. Perform database tuning and capacity planning activities

7. Create technical documentation and provide guidance to junior team members

Skill Requirements

1. Proficient in oracle pl/sql programming, including stored procedures, functions, and triggers

2. Strong experience in designing and optimizing oracle databases

3. Knowledge of performance tuning techniques for sql queries

4. Familiarity with data security and compliance standards

5. Excellent problem-solving skills and attention to detail

6. Good communication and teamwork abilities

7. Bachelor's degree in computer science, engineering, or a related field

Certifications: Oracle Certified Professional (OCP) Oracle PL/SQL Developer Certification

Skill

Years of Experience

Level of Competence

Oracle PL/SQL

10-15 yrs

Proficient

Snowflake

4-5 Yrs Relevant

Competent

SQL

10-15 yrs

Proficient

Python

10-15 yrs

Proficient

AWS

4-5 Yrs Relevant

Intermediate

JD Responsibilities:

· Design, develop, and maintain applications using strong Oracle SQL and PL/SQL, Python and Unix technologies.

· Collaborate with cross-functional teams to define, design, and ship new features.

· Optimize application performance and ensure scalability.

· Troubleshoot, debug, and upgrade existing systems.

· Write clean, maintainable, and efficient code.

Requirements:

· 12 years of experience building solutions using Oracle, Python and shell scripting.

· Proficiency in Oracle PL/SQL and SQL.

· Experience in Translating functional and technical requirements into detailed design

· Experience in Coding and unit testing, support SIT, UAT and Production deployments

· Must have good database programming skills covering Design/development of Stored Procedures, -Functions, Tables, and Triggers and tuning SQL queries for optimal performance.

· Develop ETL processes using Informatica to manage data integration tasks.

· Proficiency in shell scripting

· Experience with performance tuning and optimization of Oracle databases

· Document system configurations, procedures, and best practices

· Excellent problem-solving skills and attention to detail.

· Ability to work collaboratively in a team environment.

Preferred Qualifications:

· Experience with Tivoli Workload Scheduler (TWS)

· Experience with cloud services preferably AWS

· Experience with Snowflake

· Knowledge of DevOps practices and tools.

· Familiarity with Agile methodologies.

Thanks & Regards,

Gaurav Gautam

ValiantIQ Inc.

"Searching Best Minds Searching Best Minds"

Email: ggautam@valiantiq.com

Disclaimer: If you are not interested in receiving our e-mails then please reply with a "REMOVE" in the subject line for automatic removal. And mention all the e-mail addresses to be removed with any e-mail addresses, which might be diverting the e-mails to you. We are sorry for the inconvenience.

Job Type: Contract

Pay: $55.00 - $60.00 per hour

Expected hours: 40 per week

Schedule:

• 8 hour shift

Ability to Commute:

• Edison, NJ 08837 (Required)

Ability to Relocate:

• Edison, NJ 08837: Relocate before starting work (Required)

Work Location: In person

Salary : $55 - $60