YUDHIR GURUNG

adz5lo@r.postjobfree.com

517-***-****

An Oracle Database Developer and Administrator with 5+ years of strong experience, specializing in PL/SQL, SQL, Linux, Database Administration, and Data modeling. Relevant Work Experience

Oracle Database Developer

Truven Health Analytics, IBM Watson Health, Denver, Colorado April 2012 - April 2016

• Developed and maintained Oracle database objects such as packages, stored procedures, functions, views, materialized views, and triggers.

• Regularly wrote ad hoc static and dynamic SQL queries for testing and troubleshooting data issues.

• Extensively used SQL Loader, data pump utilities, and external tables for loading data into Oracle tables.

• Enhanced SQL performance by using explain plans, hints, indexes, and rewriting queries.

• Enhanced PL/SQL performance using bulk binding, bind variables, table functions, and ref cursors.

• Provided support to DevOps, QA, and the development team across the Agile Methodology. Oracle Database Developer

SPI Nepal, a US-based company, Kathmandu, Nepal January 2017 - December 2017

• Developed and maintained PL/SQL packages, procedures and functions.

• Identified several high-load SQL queries, and improved their performance by studying execution plans and applying hints and indexes.

• Monitored and optimized the performance of the database.

• Trained junior developers on Oracle database and writing better SQL and PL/SQL.

• Participated in all phases of the Agile SDLC.

Database Developer

SmartPalika, Kathmandu, Nepal August 2018 - May 2019

• Lead the team in the Database design of the application.

• Developed stored procedures, functions, tables, views, and triggers.

• Reduced the application load times by a significant factor using indexes and optimizing queries.

• Developed ERD diagrams, normalized existing data and created data structures for existing and new data. System Administrator

Nepal Medical Hospital, Kathmandu, Nepal June 2020 - December 2020

• Involved in Database installation, upgrades, network, and security.

• Monitored and optimized the performance of Oracle and SQL server databases.

• Responsible for planning for backup and recovery of databases. System Administrator

Himalayan Automation Office, Pokhara, Nepal Jan 2021 - Jan 2022

• Responsible for database, software, and hardware installation, upgrades, network, and security.

• Created database design, data modeling, and database objects for many different clients.

• Responsible for data transformation, data migration, and loading from different sources. Education

Master of Science in Database Technology

Regis University, Denver, CO

Date of Graduation: December 2011

Training

• Balky Howell PL/SQL training (2015)

• Rocky Mountain Oracle Users Group (RMOUG) (2014, 2015) Key Skills

• PL/SQL, SQL, Data Modeling, Database Design, Data Loading, Database Administration, ETL, Software Development Lifecycles (SDLC)

Contact this candidate