Develops and optimizes Oracle SQL and PL/SQL code, including complex queries, indexes, dynamic SQL, packages, procedures, functions, cursors, and collections. Performs DML and DDL operations, exception handling, logging, debugging, and performance tuning in production environments. Collaborates with application teams on database integration and may support modernization or migration projects.
Job Title: Oracle PL/SQL Developer
Location: Chennai
Experience: 4–6 Years
Work Mode: Work From Office
Open Positions: 5
Notice Period: Immediate to 15 Days
Job Overview:
We are seeking an experienced Oracle PL/SQL Developer with strong expertise in SQL development, performance tuning, and database programming. The role requires hands-on experience in writing complex queries, optimizing performance, and managing database objects in a production environment.
Key Responsibilities:
- Develop and optimize complex SQL queries involving multiple table joins
- Design and implement indexing strategies to improve query performance
- Write and execute dynamic SQL for DML and DDL operations
- Develop and maintain database objects such as packages, procedures, and functions
- Handle large datasets using cursors, loops, and collections
- Perform DML operations (INSERT, UPDATE, DELETE) and DDL operations (CREATE, DROP)
- Implement exception handling and error logging mechanisms
- Debug, troubleshoot, and optimize PL/SQL code
- Collaborate with application teams for database integration
Required Skills:
Core Skills:
- Strong experience in Oracle SQL and PL/SQL
- Expertise in complex joins and multi-table query design
- Query optimization and indexing techniques
- Experience with dynamic SQL
Technical Skills:
- Cursor types: Implicit, Explicit, REF CURSOR, SYS_REFCURSOR
- CASE and DECODE statements
- Packages, stored procedures, loops, and collections
- Exception handling and logging mechanisms
- Strong debugging and performance tuning capabilities
Good to Have:
- Experience with Java or backend integration
- Exposure to migration or modernization projects
- Familiarity with version control tools such as Git
- Experience working in Agile/Scrum environments
Soft Skills:
- Strong attention to detail
- Proactive and ownership-driven approach
- Good communication and stakeholder management skills
- Ability to work in a fast-paced environment
Application:
Interested candidates can share their resumes at: [email protected]
Similar Jobs
Digital Media • Information Technology • News + Entertainment
Provides senior technical leadership across data engineering, platform engineering, and application development initiatives. Responsibilities include architecture and design governance, engineering standards, modernization, cloud and AI adoption, production incident escalation, reliability improvement, and mentorship of engineers. The role drives technical strategy, system scalability, performance, security, operational stability, and delivery excellence across enterprise platforms.
Top Skills:
Ai/Ml PlatformsApache AirflowApache HiveSparkAWSCi/CdData LakesData WarehousingDatabricksDevOpsJavaKafkaObservability And Monitoring ToolsPysparkPythonSQL
Digital Media • Information Technology • News + Entertainment
Analyzes business and user needs, defines system requirements, prepares technical specifications, evaluates system impacts, and supports software solution integration. Maintains national code assignments and control tables, ensures data quality, collaborates with IT, vendors, testing teams, and business users, troubleshoots defects, supports audits, and extracts data using SQL queries.
Top Skills:
AIExcelMS OfficeMicrosoft PowerpointMicrosoft WordProcess AutomationSQL
Digital Media • Information Technology • News + Entertainment
Designs, develops, and integrates software solutions; analyzes requirements, customizes applications, supports releases and updates, troubleshoots technical issues, and partners with Quality Assurance. Mentors junior engineers, provides technical leadership, conducts application-user training, and uses market and industry research to inform project strategies. Requires independent judgment, reliable attendance, and flexibility for nights and weekends.
What you need to know about the Chennai Tech Scene
To locals, it's no secret that South India is leading the charge in big data infrastructure. While the environmental impact of data centers has long been a concern, emerging hubs like Chennai are favored by companies seeking ready access to renewable energy resources, which provide more sustainable and cost-effective solutions. As a result, Chennai, along with neighboring Bengaluru and Hyderabad, is poised for significant growth, with a projected 65 percent increase in data center capacity over the next decade.
