Oracle PL/SQL Developer
- Siri Info Solutions Inc.
14 Days Ago
NA
Yearly
Charlotte NC-NC
6-10 Years
Required Skills: Oracle PL/SQL Development, Oracle Database, 8i/9i/10g/11g, Advanced SQL Programming, Stored Procedures, Functions, Packages & Triggers, Query Performance Tuning & Optimization Explain Plan, SQL Hints & Index Tuning , ERWIN, TOAD Data Modeler, ER Diagrams, SQL*Loader , Oracle Forms & Reports, TOAD, PL/SQL Developer & SQL Navigator, UNIX Shell Scripting Database Design, Development & Production Support
Job Description
Primary Skills: Oracle PL/SQL Development, Oracle Database (8i/9i/10g/11g and above), Advanced SQL Programming, Stored Procedures, Functions, Packages & Triggers, Query Performance Tuning & Optimization Explain Plan, SQL Hints & Index Tuning , Data Modeling (ERWIN, TOAD Data Modeler, ER Diagrams) SQL*Loader , Oracle Forms & Reports, TOAD, PL/SQL Developer & SQL Navigator, UNIX Shell Scripting Database Design, Development & Production Support
Roles & Responsibilities
- Design, develop, test, and maintain complex Oracle PL/SQL packages, procedures, functions, triggers, views, and database objects.
- Analyze business requirements and translate them into scalable and efficient database solutions.
- Develop and optimize complex SQL queries, PL/SQL code, and batch processes for high-performance applications. o Perform database performance tuning using Explain Plan, SQL Hints, Indexing strategies, and query optimization techniques.
- Design and maintain logical and physical data models using ERWIN, TOAD Data Modeler, and ER diagrams.
- Develop and support data migration, data loading, and ETL processes using SQL*Loader and related tools.
- Work closely with application developers, business analysts, architects, and QA teams throughout the SDLC lifecycle.
- Troubleshoot production issues, analyze root causes, and implement permanent solutions to ensure system stability.
- Support database deployments, release activities, and change management processes across multiple environments.
- Develop UNIX/Linux shell scripts to automate database monitoring, maintenance, and batch processing activities.
- Create and maintain technical design documents, code reviews, and database development standards.
- Work with reporting and analytics tools such as Tableau, Trino, Hue, and Collibra to support business reporting requirements.
- Monitor database health, ensure data integrity, and implement backup and recovery best practices.
- Mentor junior developers and provide technical guidance on Oracle database development and tuning best practices.
- Participate in Agile ceremonies including sprint planning, estimation, backlog refinement, code reviews, and retrospective meetings.
- Collaborate with cross-functional teams to deliver secure, scalable, and high-quality database solutions.
- Ensure compliance with organizational security, audit, and regulatory requirements, particularly in BFSI environments.
- Provide L2/L3 production support and work on critical incidents, problem management, and service improvement initiatives.
Responsibilities Include:
- Lead Oracle database design and d evelopment activities for enterprise applications.
- Review solution architecture and recommend best practices for database design and performance.
- Coordinate with onsite/offshore teams and stakeholders to ensure successful project delivery.
- Act as the Subject Matter Expert (SME) for Oracle PL/SQL development, performance tuning, and database optimization.
