Looking for a job

Aarun User

@aarunuser

Message

Oracle PL/SQL Developer at Tech Mahindra, optimizing database queries and building reliable database solutions.

Canada

Message

At Tech Mahindra, I design, develop, and maintain Oracle PL/SQL database objects, including schemas, procedures, functions, packages, and triggers. I also troubleshoot production issues and work with application developers to integrate database solutions with front-end applications.

At Tech Mahindra in Pune, I created records, tables, and collections that reduced context switching and improved query performance by 18%. Extensive exception handling also eased debugging and reduced debugging time by 15%.

At Bhilwara Infotech, I used Oracle PL/SQL and shell scripts to extract data from different databases and load it into Teradata for analytical use. I also maintained script versions and changed Teradata database user objects for a new Teradata version.

Earlier, I developed Oracle PL/SQL objects and UNIX scripts at Epsilon, and helped migrate database and application objects from Oracle 6 to Oracle 11g at Vforce Infotech. My work has also included query optimization, technical designs, unit testing, production support, and documentation.

Experience

Work history, roles, and key accomplishments

Current

Project Lead

Current

Tech Mahindra

May 2022 - Present (4 years 5 months)

Design, develop, and maintain database schemas, tables, procedures, functions, packages, and triggers in Oracle PL/SQL. Optimize and troubleshoot SQL queries and PL/SQL code to improve performance and scalability.

Pl SQL SQL Tuning Explain Plan Indexes Table Partitioning Dynamic SQL Instantly JSON CLOB Pivots Angular Java Python Debugging Documentation

Sr. Software Engineer

Bhilwara Infotech

Jun 2019 - Apr 2020 (10 months)

Worked with Oracle PL/SQL using Toad to run extract and load from different databases. Used shell scripts to fetch data from ODI server and load into Teradata for analytical purposes.

Pl SQL Toad Shell Scripts ODI Teradata Jira Git Bitbucket Confluence Tivoli

Sr. PL/SQL Developer

Adept Scripts

May 2017 - Feb 2019 (1 year 9 months)

Developed Oracle PL/SQL objects to incorporate business logic and requirements. Performed query optimizations to improve run time of queries generated by other developers.

Pl SQL Query Optimization Database Objects

Sr. Database Developer

Epsilon

Aug 2013 - May 2017 (3 years 9 months)

Created Oracle PL/SQL objects and UNIX scripts to implement business logic and scheduling. Involved in development, unit testing, production support, documentation, and training of the team.

Pl SQL UNIX Shell Scripting Solution Design Technical Design Unit Testing Production Support Documentation Training

Programmer Analyst

Vforce Infotech

Feb 2012 - Aug 2013 (1 year 6 months)

Migrated Oracle 6 to Oracle 11g by re-creating database, Oracle PL/SQL, Oracle Forms, and Oracle reports objects. Dissolved old C++ scripts and created new UNIX scripts to perform the same tasks.