PL/SQL Developer

Rays TechServ; Ahmedabad District; On-site; INR 1,800,000 - 2,400,000; Full time

Job summary

Rays TechServ in Ahmedabad is seeking an experienced Oracle DBA to manage and optimise enterprise Oracle Server Databases. You will design, develop, and tune PL/SQL code, procedures, packages, and triggers to implement business logic and ensure data integrity.

The role requires strong analytical skills, documentation experience, and ability to work independently or within a team. Collaboration with data architecture and reporting teams is essential.

Qualifications

• 6+ years of experience with Oracle Server Databases in an enterprise environment.
• 6+ years experience in RDBMS, including PL/SQL, Stored Procedures, SQL Loader, with JSONs.
• 4 - 6 years’ experience developing PL/SQL procedures, functions, packages, triggers.
• Experience with Reporting tools like Oracle Reports, Jasper Reports or BI Publisher.

Responsibilities

• Develop and optimise stored procedures, functions, packages and triggers.
• Create tables, views, indexes, and other database objects as needed.
• Query optimisation and performance tuning.
• Support the data architecture with some data integration.
• Develop technical operations documentation and standard operating procedures.

Skills

Oracle DB

PL/SQL

Stored Procedures

SQL Loader

JSONs

Reporting Tools

BI Publisher

Jasper Reports

Tools

SQL Loader

JSON

BI Publisher

Jasper Reports

Oracle Reports

Job description

OverviewAround five to six years of experience in working with Oracle or other RDBMS tools, SQL, and PL/SQL, including analysis, design, coding, and unit testing.Experience in creating comprehensive technical operations documentation (e.g., standard operations processes, preventative maintenance procedures), process and CMMI documentationCreate tables, views, indexes, triggers, types, packages and other database objects as needed and Query optimisationDevelop, tune, execute, and manage Oracle PL/SQL stored procedures, functions, packages and database triggersSupport the data architecture with some data integrationDeveloping and amending stored procedures and PL/SQL code to implement business logicNo. of Vacancies1Specific Skills6+ years’ experience with Oracle Server Databases in an enterprise environment6+ years’ experience in RDBMS, including PL/SQL, Stored Procedures, SQL Loader, with JSONs4 - 6 years’ experience developing PL/SQL procedures, functions, packages, triggersExperience with Reporting tools like Oracle Reports, Jasper Reports or BI PublisherResponsible ForAbility to develop a resolution for complex problems that require a creative approach.Regularly contribute to the development of new concepts, techniques, and standardsApply expertise and possess knowledge of related disciplinesEstablish functional and technical specificationsEnsure integration of the entire system or subsystemDevelop solutions to a variety of complex problemsParticipate in planning schedules and arranging own activitiesUnderstanding of the following technical concepts/tools/etcSoftware lifecycle methodologyBasic relational database conceptsSoftware development and implementation - web and client-server technologiesData modelling and development toolsAdditional RequirementsStrong written and verbal communication skillsDemonstrate strong analytical and problem-solving skills, including debugging code, Critical and logical thinking.Ability to work independently and as part of a team. Follow through with commitmentsProactively seek opportunities to broaden and deepen knowledge base and proficienciesConduct seminars and presentations on topics of interest to the Software Development GroupJob NatureFull TimeExperience Requirements6+ yearsJob LocationAhmedabadJob LevelSr. PositionHow to ApplyInterested candidates can send their resumes to [e-mail] mentioning \"Job Title\" in the subject line.