Develop, debug, and optimize PL/SQL scripts for data transformation and integration
Rewriting queries and PL/SQL code to improve efficiency, scalability, and response time
Write and maintain scripts for data extraction, transformation, and loading (ETL) between various databases and systems.
Perform data migration, ensuring data integrity during the process.
Perform root cause analysis and troubleshoot database issues, including application performance, errors, and system downtime.
What You Know
A minimum 6+ years of PL/SQL Developer experience is required.
This role is purely for handling oracle data and preparation of SQL scripts for data updates, migration
Resolve database-related issues by performing recovery, patching, and upgrading.
Work closely with other developers, DBAs (Database Administrators), business analysts, and project managers to deliver high-quality solutions.
Participate in code reviews, peer programming, and provide mentoring to junior developers
Deep understanding of Oracle Database (version 11g, 12c, or higher), its architecture, and features like tablespaces, indexes, constraints, etc.
Experience working with Oracle database tools like SQL*Plus, SQL Developer, TOAD, and Oracle Enterprise Manager.
Excellent written and verbal communication skills.
Nice to have Java programming knowledge
Education
Bachelor’s degree in Computer Science/Engineering or equivalent work experience
Benefits
In addition to competitive salaries and benefits packages, Nisum India offers its employees some unique and fun extras:
Continuous Learning - Year-round training sessions are offered as part of skill enhancement certifications sponsored by the company on a need basis. We support our team to excel in their field.
Parental Medical Insurance - Nisum believes our team is the heart of our business and we want to make sure to take care of the heart of theirs. We offer opt-in parental medical insurance in addition to our medical benefits.
Activities - From the Nisum Premier League's cricket tournaments to hosted Hack-a-thon, Nisum employees can participate in a variety of team-building activities such as skits, and dances performance in addition to festival celebrations.
Free Meals - Free snacks and dinner is provided on a daily basis, in addition to subsidized lunch.