YUDHIR GURUNG
********@*****.***
An Oracle Database Developer and Administrator with 7+ years of strong experience, specializing in PL/SQL, SQL, Database Design, and Data modeling, including 4+ years of experience in a healthcare environment in the US. Professional Summary
• Strong experience in developing and optimizing PL/SQL packages, procedures, functions, and triggers.
• Excellent in designing and implementing database objects and structures including tables, views, and indexes.
• Strong experience in SQL performance tuning and query optimization using indexes, explain plans and hints.
• Proficient in Data loading and migration techniques and utilities such as data pump, and external tables.
• Excellent in Data Modeling and Database Design in both the OLTP and OLAP environments.
• Hands-on DBA experience in Linux systems, including managing instances and storage, creating databases and users, performing database backup and recovery, and database performance monitoring and tuning. Key Skills
• Oracle, PL/SQL, SQL, Data Modeling, Database Design, Database Administration, Linux, SQL Loader, Data Pump, SQL Developer, TOAD, OEM, SQL*Plus, Agile Methodology Education
Master of Science in Database Technology
Regis University, Denver, CO
Training
• Global IT Training: Oracle Database Administration (2024)
• Balky Howell PL/SQL training (2015)
• Rocky Mountain Oracle Users Group (RMOUG) (2014, 2015) Relevant Experience
Oracle Database Administration Workshop
Global Information Technology, Southfield, Michigan November 2023 – Jan 2024
• Experience in managing instances, starting and shutting down databases in different modes.
• Experience in storage management and moving data using data pump, SQL Loader, and external tables.
• Created database backups and performed recovery of databases.
• Involved in monitoring and tuning database performance. Database Developer
Himalayan Automation Office, Pokhara, Nepal Jan 2021 - Jan 2022
• Responsible for developing database programs for data manipulation, validation, and reporting.
• Implemented the overall database design, and physical and logical data models for our clients.
• Responsible for database, software, and hardware installation, upgrades, network, and security. System Administrator
Nepal Medical Hospital, Kathmandu, Nepal June 2020 - December 2020
• Monitored and optimized the performance of Oracle and SQL server databases.
• Wrote SQL queries for troubleshooting data issues, data validation and reporting.
• Responsible for planning for backup and recovery of databases. Database Developer
SmartPalika, Kathmandu, Nepal May 2018 - August 2019
• Developed database code for data processing, loading, transformation, and manipulation.
• Reduced the application load times by a significant factor using indexes and optimizing queries.
• Utilized expertise to help improve the performance and scalability of databases by a significant factor. Oracle Database Developer
SPI Nepal, a US-based company, Kathmandu, Nepal January 2017 - April 2018
• Supported the application by writing and optimizing PL/SQL packages, procedures and functions.
• Identified several high-load SQL queries and improved their performance by using explain plans and indexes.
• Trained junior developers on Oracle database and writing efficient SQL and PL/SQL. Oracle Database Developer
Truven Health Analytics, IBM Watson Health, Denver, Colorado April 2012 - February 2016
• Supported the Data Factory by developing and optimizing PL/SQL packages, procedures, and functions.
• Regularly wrote SQL queries for data reporting, troubleshooting data issues, and creating test data.
• Migrated data from offline to online environments using SQL Loader, data pump, and external tables.
• Performed DBA tasks using Linux scripts and working together with the DBA team.
• Provided support to DevOps, OA, and the development team across the Agile Methodology.