09 Oct
|
SG Lottery India
|
Bengaluru
09 Oct
SG Lottery India
Bengaluru
Qualified Summary
Oracle SQL/PLSQL Developer with experience in designing, developing, and maintaining database applications using Oracle SQL and PL/SQL. Skilled in database programming, performance tuning, data analysis, production support, and application enhancement within enterprise environments.
Roles & Responsibilities
- Develop, test, and maintain Oracle SQL queries, stored procedures, functions, packages, and triggers.
- Analyze business requirements and design efficient database solutions.
- Create complex SQL queries, views, and database objects to support application requirements.
- Optimize SQL queries and PL/SQL code for performance and scalability.
- Troubleshoot and resolve database-related issues, defects, and production incidents.
- Perform data analysis, data validation, and data migration activities.
- Develop and maintain database documentation, technical specifications, and code reviews.
- Work closely with application developers, business analysts, and QA teams throughout the SDLC.
- Ensure database security, data integrity, and adherence to coding standards.
- Participate in change request implementation, deployment, and production support activities.
Required Skills
- Oracle SQL
- Oracle PL/SQL
- Packages, Procedures, Functions, Triggers
- Cursors and Collections
- Query Optimization & Performance Tuning
- Data Modeling
- Exception Handling
- Oracle SQL Developer / TOAD
- Version Control (CVS/SVN/Git)
- Production Support & Bug Fixing
Preferred Skills
- Oracle Forms & Reports
- Jira / Agile Methodology
- Release & Deployment Processes
- Database Performance Monitoring
📌 PLSQL Developer (Bengaluru)
🏢 SG Lottery India
📍 Bengaluru