Senior Oracle Developer

ICE Data Services; Hyderabad; On-site; INR 1,000,000 - 1,500,000; Full time

Job summary

ICE Data Services in Hyderabad is seeking an experienced database developer who can work independently and handle multiple tasks. The ideal candidate will possess strong skills in PL/SQL and SQL, with at least 7 years of experience in database application development.

The role includes database administration, optimization, and supporting QA and development systems. Candidates should be comfortable with on-call duties and communicating effectively within teams.

Qualifications

• At least 7 years of experience developing database applications.
• Strong communication skills and ability to work independently.
• Familiarity with on-call support and willing to work nights and weekends.

Responsibilities

• Develop database applications using PL/SQL.
• Conduct administrative work to support production systems.
• Optimize database systems for better performance.
• Provide QA and development system support.

Skills

PL/SQL

SQL

Unix/Linux

Shell scripting

Perl

Oracle Apex

Database optimization

Problem-solving

Team collaboration

GIT

Education

B.S. in Computer Science or related

Tools

Oracle 19c

Bitbucket

Job description

Job Purpose

The candidate should be able to work independently, handle multiple simultaneous tasks and be adept at prioritizing their work. The candidate will be able to focus on the project priorities to deliver the required product at the scheduled time. They should be comfortable collaborating with business analysts, product managers, quality assurance groups and client services to refine requirements and plan implementation strategies.

The applicant will have experience in problem solving, planning, and estimating development efforts and have strong communication skills. Most importantly they should demonstrate the ability to show initiative and be able to move projects forward to completion with minimal supervision.

The candidate will be expected to be involved in the full life cycle of the systems development from requirement gathering through development and testing to on-going support and maintenance. The position will involve some on-call support outside of regular business hours, nights and weekends.

Responsibilities

• Use and review PL/SQL or SQL development to solve business problems
• Conduct database administrative work to support for production systems
• Provide support for QA and Development systems
• Identify opportunities to fine-tune and optimize database systems

Knowledge and Experience

• B.S. or higher in Computer Science, Information Systems, Engineering or related discipline or equivalent work experience
• At least 7+ years of experience developing database applications in PL/SQL-Triggers, Packages, Functions, Procedures, SQL, Analytical functions, Oracle Collection, Object Types knowledge and experience
• Must have experience working in Unix/Linux environment. RAC experience is a plus
• Some Shell scripting and Perl experience
• Frontend application development using Oracle Apex is a plus.
• SQL Query tuning and understanding of query plan management.
• Experience with partition management and parallel processing
• Experience with Oracle VPD is a plus.
• Oracle 19c experience a must
• Excellent problem solving, issue identification, analytical and technical documentation skills
• Strong interpersonal skills and ability to work well in a team environment
• Good written and verbal communication skill
• Familiarity with GIT and Bitbucket is a plus.
• Willing to take on-call rotation and occasional weekend work