Post Job Free
Sign in

Oracle Database Developer

Location:
Jackson, MI
Posted:
January 20, 2025

Contact this candidate

Resume:

YUDHIR GURUNG

********@*****.***

517-***-****

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.



Contact this candidate