Sql Developer Oracle Dba

Sanjay Dharmadhikari

Clarksburg, Maryland (C) 240-***-**** e-mail: ***********@*******.***

Education: Bachelor in Mechanical Engineering, PUNE University, India

Summary:

** **** *****’ experience in IT industry.

Oracle PL/SQL Developer. Expertise in PL/SQL programming, Performance Tuning of SQL queries, Writing Stored Procedures, Functions,Triggers and ETL programs.

Oracle certified DBA with expertise in Oracle DB Installation, Backup and Recovery, Performance tuning, Data Guard

Expertise in AWS RDS Oracle DB, AWS RDS Postgres DB, DMS,SCT, AWS CLI

Experienced Postgres DBA, PL/PGSQL developer

CI/CD using Jenkins and Flyway

CAREER SKILLS/KNOWLEDGE

Languages: PL/SQL, Pl/PgSql, KORN Shell, C, PRO*C

Databases: ORACLE (10g, 11gR2, 12c, 19c), Postgres

Operating Systems: UNIX, Red-Hat Linux, and Windows 2019

Jenkins, Github, Flyway

Tools: Oracle APEX, ERWIN, TOAD, PL/SQL Developer, SQL

Developer, Git, Confluence, Microsoft office

Certifications: Oracle Certified DBA(12c, 11g, 19c)

CAREER ACHIEVEMENTS

Led a team of PL/SQL Developers to write ETL programs to load data into a data warehouse. By using various features of PL/SQL, such as, Bulk Collection, Ref Cursor, Dynamic SQL, FOR ALL Statements, VARRAYS, NESTED Tables etc., the performance of ETL programs was optimized resulting in higher customer satisfaction.

Single-handedly lead the effort to migrate United States Citizenship and Immigration Services (USCIS) DB for scheduling appointments from Linux Server to Amazon Web Service (AWS) Cloud. This involved Creation of DB in the Amazon Cloud, Setting up DB backup schedules, Maintenance of DB and Data Migration.

Lead a small team of DBAs to set up a data mart for reporting and running ad-hoc queries by replicating data from various applications used by Unites States Citizenship and Immigration services.

CAREER EXPERIENCE

Harmonia Holdings LLC, Mclean, VA

September 2021 to April 2025

Role: PL/SQL Developer and Oracle DBA Team Lead

Wrote Stored Procedures functions, triggers using PL/SQL. Used various features of PL/SQL such as, Bulk Collection, Multi-Table Insert, Ref-Cursors, Dynamic SQL, VARRAYS, Nested Tables etc.

Lead the task of Performance tuning of complex SQLPlus Queries using AWR reports, Explain Plan and Autotrace

Wrote Packages, stored procedures, functions to process data, retrieve data for reports and on-line queries.

Used PL/SQL procedures to generate AWR reports.

Wrote triggers to monitor logins and logouts, extracting the data into files and making it available to the management as and when needed.

Used UTL_FILE to create files to write and extract data to flat files.

Used Exceptions to handle errors

Created DB objects like Tables, Sequences, Indexes, External Tables

Used Global Temporary tables to store data temporarily

Partitioned tables using Values and Ranged based partitioning schemes

Used Hints extensively to optimize query performance

Used HTML to create web pages

Used Java script to retrieve and display data

Used Agile Kanban method of System Development Life Cycle methodology

Migration of Oracle Database from Data Center to Amazon Cloud.

Migration of Data using DMS.

Creation of AWS RDS DB.

Amazon Cloud Infrastructure Setup

Creating AWS S3 buckets, managing access to S3 buckets using Roles,

Creating EC2 instances.

Development using Oracle Apex 22. Experience in developing forms based on views, tables in tabular layouts. Used JavaScript, HTML to manipulate the contents.

Migration of Oracle Database from Oracle 12c to Oracle 19c.

Creation of Physical Standby Databases using Data Guard

Peraton Corporation (Formerly Perspecta) Arlington, VA

June 2019 to Sep 2021

Role: PL/SQL Developer and Oracle DBA Team Lead

Wrote Stored Procedures functions, triggers using PL/SQL. Used various features of PL/SQL such as, Bulk Collection, Multi-Table Insert, Ref-Cursors, Dynamic SQL, VARRAYS, Nested Tables etc.

Used SqlLoader, Data Pump exports/imports to extract and load data.

Involved in continuous enhancements and fixing production issues.

Created PL/SQL Stored procedures, functions to move data from one database to another.

Performed SQL, PL/SWL tuning using Explain Plan, SQL Trace TKPROF, Autotrace and AWR reports

Extensively used hints to optimize query execution

Extensively used Bulk collection to improve performance.

Used FOR ALL clauses to reduce context switching

Used Pragma Autonomous Transaction to commit transactions independently from the main transaction

Extensively used Dynamic SQL to generate SQL queries based on certain conditions

Migration of Oracle Database from Data Center to Amazon Cloud.

Migration of Data using DMS.

Creation of AWS RDS DB.

Amazon Cloud Infrastructure Setup

Creating AWS S3 buckets, managing access to S3 buckets using Roles,

Creating EC2 instances.

Maintenance of On-Premise Databases.

Automation of DB script execution using Jenkins and Flyway

Creating Oracle and Postgres Databases.

Day-to-day Oracle DB maintenance activities like creating tables, indexes, users, granting access etc.

Writing AWS CLI command to transfer files to S3 buckets.

Monitoring DB performance using AWR reports and Oracle OEM.

Fairfax County, Fairfax, VA

Apr 2019 to June 2019

Role: PL/SQL Developer

Conversion of IBM Mainframe Cobol Code to Oracle PL/SQL

Writing Stored Procedures functions, triggers using PL/SQL. Used various features of PL/SQL such as, Bulk Collection, Multi-Table Insert, Ref-Cursors, Dynamic SQL, VARRAYS, Nested Tables etc.

Loading Data using SQL Loader.

Creating Tables, Indexes, Sequences.

Performance tuning of SQL queries. Used EXPLAIN PLAN, Added Indexes, avoided expensive joins using Global Temporary tables etc.

Software: Oracle 12c R1/R2, PL/SQL

FINRA, Rockville, MD

May 2018 to Mar 2019

Role: Oracle Application DBA, PL/SQL Developer

Migration of Database from Data Center to Amazon Cloud.

Migration of Data and Metadata to Amazon cloud using Data Pump and Data Migration Services (DMS).

Writing PL/SQL stored procedures to compare source and Target schema

Writing PL/SQL procedure to create, rename or modify Database objects using Dynamic SQL

Writing Stored Procedures functions, triggers using PL/SQL. Used various features of PL/SQL such as, Bulk Collection, Multi-Table Insert, Ref-Cursors, Dynamic SQL, VARRAYS, Nested Tables etc.

Writing Bash shell scripts to automate execution of jobs.

GRSi, Windsor Mill, MD

September 2017 to May 2018

Role: Oracle DBA, PL/SQL Developer, Data Modeler

Client: Center for Medicare and Medicaid Services (CMS):

Oracle DBA, PL/SQL Developer for Electronic Submission of Medical Documents (esMD). Responsibilities Included:

Writing Stored Procedures functions, triggers using PL/SQL. Used various features of PL/SQL such as, Bulk Collection, Multi-Table Insert, Ref-Cursors, Dynamic SQL, VARRAYS, Nested Tables etc.

Redesigning the DB to remove redundancies

Data Migration from old schema to new schema

DBA for the data mart. Responsible for:

Installing Oracle DB.

Creating DB objects

Tuning SQL queries for performance

Monitoring DB performance

Automation of day-to-day DBA tasks

Establishing secure connection using Wallet

Data Encryption using Transparent Data Encryption(TDE)

GDIT (formerly CSRA, Computer Science Corporation (CSC)), Falls Church, VA

December 2006 to September 2017

Role: PL/SQL Developer, Oracle DBA, Data Architect, Data Modeler

Client: Center for Medicare and Medicaid Services (CMS):

April 2017 to September 2017

DBA and PL/SQL Developer for CMS Hospital Quality Reporting System (HQRS) Responsibilities Included:

DBA for the data mart. Responsible for:

Oracle DB installation.

Creating DB objects and tuning SQL queries for performance.

Data Encryption using Transparent Data Encryption(TDE)

Data Masking using Data Redaction (DBMS_REDACT)

Writing Stored Procedures, functions, triggers using PL/SQL. Used various features of PL/SQL such as, Bulk Collection, Multi-Table Insert, Ref-Cursors, Dynamic PL/SQL, FOR ALL, VARRAYS, Nested Tables, NOCOPY, DETERMINISTIC Functions etc.

Client: Transportation Security Administration (TSA):

December 2016 to April 2017Present

Oracle DBA and Data Architect for TSA HRAccess Application. Responsibilities Included:

Creating and Maintaining DB objects (Tables, Sequences, Materialized Views).

Writing Stored Procedures and functions using PL/SQL. Using appropriate features of PL/SQL, such as, Bulk processing, Dynamic SQL, REF Cursors, NOCOPY hints, FOR ALL statements, Multi Table Inserts etc. for optimal performance.

Performance Tuning of SQL queries

Logical and Physical Data Modeling using Erwin

Client: Center for Medicare and Medicaid Services (CMS):

April 2016 to December 2016

Oracle DBA and Data Architect for CMS Physician Quality Reporting System (PQRS) Data Mart. Responsibilities Included:

Writing Stored Procedures and functions using PL/SQL for data processing and data migration.

Performance tuning of PL/SQL code using Bulk collection, FOR ALL statements, REF Cursors, Collections, DETERMINISTIC function etc.

Re-designing the data mart to store the data more efficiently. Changed the table layouts to store and retrieve data more efficiently.

Logical and Physical Data Modeling using Erwin

Establishing secure connections using Wallet

Data Encryption using Transparent Data Encryption(TDE)

Data Masking using Data Redaction (DBMS_REDACT)

Client: United States Citizenship and Immigration Services (USCIS):

January 2010 to March 2016

Oracle DBA and Data Architect for USCIS Appointment Scheduling application and Development of Data Mart. Responsibilities Included:

Installation, Maintenance, Backup and Recovery and Performance Tuning of Oracle DB.

Writing Stored Procedures and functions using PL/SQL

Logical and Physical Data Modeling using Erwin

Evaluating different options for data replication (Streams, Data Guard and Materialized Views) and choosing an appropriate replication method for development of data mart.

Evaluating use of Oracle RAC for high availability option. Created a 2 node RAC as a proof of concept.

Migration of Oracle DB from Linux Server to Amazon Web Service cloud.

Contact this candidate