PL/SQL Developer
Pyramid Consulting Inc.
Jersey City, United States of America
yesterday
Role details
Contract type
Temporary contract Employment type
Full-time (> 32 hours) Working hours
Regular working hours Languages
English Compensation
$ 141KJob location
Jersey City, United States of America
Tech stack
Data analysis
CA Workload Automation Ae
Bash
Batch Processing
Big Data
Code Review
Databases
Data Validation
Data Integrity
Software Debugging
Job Scheduling
Korn Shell
Shell
Oracle SQL Developer
Performance Tuning
Systems Development Life Cycle
Shell Script
Software Deployment
PL-SQL
SQL Databases
Subversion
GIT
Information Technology
Job description
- Design, develop, and optimize complex Oracle PL/SQL packages, procedures, functions, and triggers.
- Write efficient SQL queries and tune performance for large datasets.
- Work with business and technical teams to gather and analyze requirements.
- Perform data analysis, data validation, and troubleshooting of production issues.
- Develop and maintain Unix shell scripts for automation and batch processing.
- Ensure data integrity, security, and adherence to banking compliance standards.
- Support production deployments and release activities.
- Monitor and manage AutoSys job schedules, troubleshoot job failures, and ensure successful batch processing.
- Participate in code reviews and follow SDLC best practices.
Requirements
- Strong experience in Oracle SQL & PL/SQL.
- Hands-on experience with AutoSys job scheduling and monitoring.
- Good knowledge of Unix/Linux operating systems.
- Strong Shell Scripting skills (Korn/Bash preferred).
- Experience in SQL query and PL/SQL performance tuning.
- Ability to debug production issues in batch processing environments.
- Strong analytical and problem-solving skills.
- Banking or financial domain experience.
- Experience with large-scale enterprise database systems.
- Knowledge of job scheduling and workload automation tools.
- Basic understanding of version control tools (Git, SVN).
- Bachelor's degree in Computer Science, Information Technology, or a related field.
Benefits & conditions
Pay Range: $65 - $68/hour. Employee benefits include, but are not limited to, health insurance (medical, dental, vision), 401(k) plan, and paid sick leave (depending on work location).
About the company
Our client is a leading Banking Industry, and we are currently interviewing to fill this and other similar contract positions. If you are interested in this position, please apply online for immediate consideration.
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, colour, 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.
By applying to our jobs you agree to receive calls, AI-generated calls, text messages, or emails from Pyramid Consulting, Inc. and its affiliates, and contracted partners. Frequency varies for text messages. Message and data rates may apply. Carriers are not liable for delayed or undelivered messages. You can reply STOP to cancel and HELP for help. You can access our privacy policy .