27 Sep
|
pannu tower
|
Chandigarh
27 Sep
pannu tower
Chandigarh
We are looking for an experienced Oracle Developer responsible for designing, developing, testing, and maintaining Oracle database applications. The candidate should have robust expertise in Oracle SQL, PL/SQL, stored procedures, functions, packages, triggers, and performance tuning.
Key Responsibilities
- Develop, maintain, and optimize Oracle database applications.
- Write complex SQL queries and PL/SQL programs.
- Develop and maintain stored procedures, functions, packages, triggers, and views.
- Design and modify database tables, schemas, indexes, and constraints.
- Analyze and optimize SQL queries and database performance.
- Perform database troubleshooting and resolve application/database issues.
- Develop data migration and data transformation scripts.
- Work with development teams to integrate Oracle databases with applications.
- Perform unit testing, debugging, and code optimization.
- Participate in database design and application development projects.
- Prepare technical documentation for database objects and processes.
- Monitor database performance and identify potential bottlenecks.
- Ensure data integrity, security, and availability.
- Support production deployments and resolve critical database issues.
- Collaborate with business analysts, developers, DBAs, and other technical teams.
Required Technical Skills
- Strong knowledge of Oracle Database.
- Excellent knowledge of SQL and PL/SQL.
- Hands-on experience with:
- Stored Procedures
- Functions
- Packages
- Triggers
- Cursors
- Views
- Indexes
- Constraints
- Joins and subqueries
- Experience in SQL query optimization and performance tuning.
- Knowledge of database normalization and relational database concepts.
- Experience with data migration and ETL processes.
- Knowledge of Oracle tools such as SQL Developer.
- Understanding of database security, backup, and recovery concepts.
- Knowledge of Unix/Linux scripting is an advantage.
- Experience with Oracle Forms/Reports or Oracle APEX is an advantage.
- Knowledge of cloud databases such as Oracle Cloud / OCI is a plus.
Preferred Certifications
- Oracle Database SQL Certified Associate
- Oracle Database PL/SQL Developer Certified Professional
- Oracle Database Administration certification
- Oracle Cloud Infrastructure (OCI) certification
Educational Qualification
Bachelor's degree in Computer Science, Information Technology, Engineering, or a related field.
Key Skills
Oracle | SQL | PL/SQL | Stored Procedures | Functions | Packages | Triggers | Query Optimization | Performance Tuning | Database Design | Data Migration | Oracle SQL Developer | Unix/Linux
Soft Skills
- Strong analytical and problem-solving skills.
- Good communication and interpersonal skills.
- Ability to work independently and within a team.
- Good debugging and troubleshooting abilities.
- Ability to manage multiple tasks and meet project deadlines.
Certification Requirement
Oracle SQL/PL-SQL certification is preferred. Relevant Oracle certification will be an added advantage.
Pay: ₹30,000.00 - ₹40,000.00 per month
Benefits
- Flexible schedule
- Paid time off
Work Location: In person
📌 Oracle Developer (Chandigarh)
🏢 pannu tower
📍 Chandigarh