Reshma Dhaya

Oracle SQL/PL-SQL Developer and Production Support Engineer with 3.7 years of experience across database development and enterprise application support. Proficient in SQL and PL/SQL development, database objects, data analysis, production troubleshooting, incident resolution, and performance optimization. Experienced in requirement analysis, technical coordination, testing, release execution, and stakeholder communication, with a strong focus on delivering reliable database solutions and maintaining application availability.

Oracle SQL/PL-SQL Developer & Production Support Engineer - Sardonyx Technologies Pvt Ltd

• Design, develop, and maintain Oracle SQL and PL/SQL components, including stored procedures, functions, packages, triggers, cursors, and other database objects.
• Write and optimize complex SQL queries involving joins, sub-queries, analytical functions, and views to support reporting and application logic.
• Investigate production incidents by analyzing application behavior, database transactions, and data conditions to determine appropriate resolutions.
• Execute change requests through requirement analysis, technical impact assessment, implementation, and validation.
• Perform SQL and PL/SQL optimization using execution plan analysis, indexing strategies to improve efficiency and database performance.
• Conduct data reconciliation and validation to identify discrepancies and support dependable business processing.
• Coordinate with clients, business users, QA teams, developers, and stakeholders to clarify requirements and resolve technical issues.
• Execute unit testing and provide SIT/UAT support for enhancements, fixes, and application changes.
• Manage release activities including application readiness checks, deployment coordination, verification, and post-release monitoring.
• Maintain technical, testing, release, and support documentation required for development and operational activities.
• Identify recurring issues and contribute to root cause analysis and preventive actions to improve application stability.

Bachelor of Engineering - B.E. - Saranathan College of Engineering (2019)