PL/SQL Developer with Production Support
Why This Role Stands Out
This remote, contract role offers you the chance to leverage your extensive PL/SQL expertise in production support and development, contributing to critical manufacturing systems. You'll thrive here if you possess strong Oracle database skills and a passion for performance optimization, with ample opportunity to enhance your technical leadership within an Agile framework. Apply today to join a dynamic project with a reputable client!
Quick Overview
Job Description
Hello
PFA
Job Title: PL/SQL Developer with Production Support
Client: TCS
Location: Remote
Job Type: Contract
Job Summary
TCS is seeking an experienced PL/SQL Developer / Lead / Architect with strong expertise in Oracle Database development, performance tuning, and production support. The ideal candidate should have experience designing, developing, and optimizing complex PL/SQL applications while collaborating with cross-functional teams in an Agile environment.
Key Responsibilities
- Design, develop, and maintain Oracle PL/SQL packages, procedures, functions, triggers, and views.
- Optimize SQL queries and PL/SQL code for high performance and scalability.
- Analyze and resolve production issues, ensuring minimal downtime.
- Perform query tuning, indexing, partitioning, and execution plan analysis.
- Develop and maintain database objects, data models, and ETL processes.
- Collaborate with application developers, business analysts, and DBAs to deliver robust solutions.
- Participate in code reviews and enforce coding standards and best practices.
- Support database deployments, releases, and production maintenance.
- Work in an Agile/Scrum environment and provide technical leadership when required.
Required Skills
- 8+ years of experience in Oracle PL/SQL development.
- Strong expertise in Oracle Database (11g/12c/19c or later).
- Hands-on experience with SQL, PL/SQL, Stored Procedures, Functions, Packages, Triggers, and Cursors.
- Experience with SQL performance tuning, query optimization, indexing, and partitioning.
- Strong understanding of Oracle execution plans and database performance analysis.
- Experience with Unix/Linux shell scripting.
- Knowledge of Git, Jira, and CI/CD practices.
- Excellent troubleshooting and production support experience.
- Strong communication and problem-solving skills.
Preferred Skills
- Experience with Oracle APEX, Oracle Forms/Reports, or Oracle Cloud.
- Knowledge of ETL tools such as Informatica or ODI.
- Experience with data migration and large-scale database implementations.
- Prior experience leading development teams or working as a Technical Lead/Architect.
Nice to Have
- Banking, Healthcare, Insurance, or Retail domain experience.
- Experience working with distributed teams and enterprise applications.
| Sahil Verma
| E: |
Skills
Similar jobs
Angular Developer
ElevaIT Solutions · Charlotte, United States
11 minutes agoAS400 Developer
VHL Technologies · King of Prussia, United States
11 minutes agoCertified Senior Salesforce Platform Developer II- Must be a local candidate
Fourans · Nashville, United States
11 minutes agoServiceNow Developer - IAM Integrations #3632781
Axiom Path · Charlotte, United States
11 minutes agoFull Stack Java Developer, Senior
Cayuse Holdings, LLC · Washington, United States
11 minutes ago$145k - $151.3k/yrAngular Developer
Photon · Durham, United States
13 minutes ago