Magesh E Email & Phone Number

Over 4 years and 3 months of hands-on experience in OracleDevelopment and Production support.Proficiency across the entire Software Development Life Cycle (SDLC),including analysis, design, development, testing, implementation, andmaintenance.Expertise in crafting intricate SQL queries leveraging AnalyticalFunctions, Aggregate Functions, Joins, Set Operators, and Sub Querieswithin Oracle environments.Experience with Views, Materialized Views, Oracle packages, andindexes to optimize database performance.Competent in designing and managing Global Temporary Tables,Sequences, and Synonyms for enhanced database functionality.Adept at creating, modifying, and effectively utilizing database objectslike Tables, Constraints, and Indexes to maintain data integrity andperformance.Specialization in handling large data volumes through Bulk data loadingand performance tuning using PL/SQL Collections and Records.Expertise in developing and managing Stored Procedures, Functions,Packages, and Triggers to automate and streamline database operations.Proficient in utilizing PRAGMA AUTONOMOUS_TRANSACTION foroptimized transaction management.Proven track record in resolving production issues and meeting supportservice level agreements for applications.Skilled in handling errors using Exception handling techniques.Quick and eager learner of new and emerging technologies, stayingabreast of industry trends and advancements.

• Software Engineer

  Autozo Technologies Pvt Ltd

  Jun 2020 - Present

  Analyzed, designed, data-modeled, and implemented business applications using the Oracle Relational Database Management System (RDBMS). Made code changes in packages, functions, and stored procedures to meet new business capabilities, including developing new cursors to fetch appropriate data. Conducted unit testing of completed development to ensure code changes met business needs before deployment in development and other lower environments. Deployed code into development servers and other lower environments for testing and staging purposes by creating a pipeline using Jenkins. Mocked up data in the test environment to conduct complete end-to-end functional testing, ensuring code changes functioned as expected in the production environment before deployment. Created indexes on tables for faster data retrieval to enhance database performance. Developed SQL*Loader scripts to load data into custom tables. Created materialized views and regular views as required by business needs. Used PRAGMA AUTONOMOUS_TRANSACTION to avoid mutating problems in database triggers. Fine-tuned procedures and SQL queries for maximum efficiency in various databases using Oracle Hints for rule-based optimization. Extensively handled errors using exception handling for easier debugging and displaying error messages in the application.

• 

  Thiruvallur University

  Computer Science