Oracle Dba Sql Developer
Resume:
Sanjay Dharmadhikari
***** ****** **** ***** **********, MD 20871 (H) 240-***-**** (C) 240-***-**** e-mail: ***********@*******.***
Bachelor in Mechanical Engineering, PUNE University, India
Summary: 31 Plus years’ experience in IT industry. Oracle certified DBA. Expertise in Oracle DB Installation, Backup and Recovery, Performance tuning, Data Guard, Amazon AWS RDS, PL/SQL programming, Performance Tuning of SQL queries, KORN Shell scripting, UNIX/Linux Operating Systems.
CAREER SKILLS/KNOWLEDGE
Certifications: Oracle Certified DBA(12c, 11g)
Languages: PL/SQL, SQLPLUS, KORN Shell, C, PRO*C, Perl, Cobol
Databases: ORACLE (11gR2, 12c, 19c)
Operating Systems: UNIX, Red-Hat Linux, Open VMS, Windows XP and
Windows 7
Tools: ERWIN, TOAD, PL/SQL Developer, SQL Developer
Hardware: HP-9000, RS-6000, DEC (Compaq) Alpha, DEC VAX
Training: INFORMATICA (Power Center 8.1.2), GoldenGate
CAREER ACHIEVEMENTS
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.
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.
As an Oracle DBA and PL/SQL developer, helped the clients of Computer Science Corporation (CSC) with setting up Data Guard, Backup and Recovery of Oracle databases, performance tuning of the SQL queries, health check of Oracle databases.
Led a group of programmers in Requirement Analysis, Coding, Testing and Implementation of a complex Real Time application, using ORACLE RDBMS on Open VMS platform for a spare parts warehouse for Caterpillar Inc., which resulted in 15% increase in the shipments of spare parts.
CAREER EXPERIENCE
Harmonia Holdings LLC, Mclean, VA
September 2021 to April 2025
Role: Oracle DBA Team Lead
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.
Migration of Oracle Database from Oracle 12c to Oracle 19c.
Creation of Physical Standby Databases using Data Guard
Fixing security vulnerabilities of Oracle Databases
Mentoring Junior members of the DBA Team
Maintenance of On-Premise Databases.
Automation of DB script execution using Flyway
Creating Oracle and Postgres Databases.
Day-to-day Oracle DB maintenance activities like creating tables, indexes, users, granting access etc.
Backup and Recovery of On-Premise Oracle Databases.
Configuring Physical standby DB using Oracle Data Guard.
Writing AWS CLI command to transfer files to S3 buckets.
Monitoring DB performance using AWR reports and Oracle OEM.
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.
Moderate level of Expertise in AWS RDS Aurora Postgres DB, AWS Dynamo DB DB.
Software: Oracle 19c, PL/SQL, PostgresSQL 12, AWS CLI
Peraton Corporation (Formerly Perspecta) Arlington, VA
June 2019 to Present
Role: Oracle DBA Team Lead
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.
FLEXPOD/VM Storage Configuration
Worked with NetApp storage experts to find out configuration changes to storage layer on FLEXPOD servers and virtual VM servers for optimal database performance. This involved making recommendations for adding multiple LUNS to the storage layer, changing the block size of storage layer and conducting performance tests, analyzing the AWR reports to get maximum IOPS from the storage.
Recommending solution for redundant storage, weighing PROS and CONS of risk VS performance to configure a storage layer that gives disk redundancy and optimal performance.
Maintenance of On-Premise Databases.
Automation of DB script execution using Flyway
Creating Oracle and Postgres Databases.
Day-to-day Oracle DB maintenance activities like creating tables, indexes, users, granting access etc.
Backup and Recovery of On-Premise Oracle Databases.
Configuring Physical standby DB using Oracle Data Guard.
Evaluating use of Oracle RAC for high availability option. Only for Proof of Concept.
Writing AWS CLI command to transfer files to S3 buckets.
Monitoring DB performance using AWR reports and Oracle OEM.
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.
Software: Oracle 12c R1/R2, PL/SQL, PostgresSQL 10
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.
Software: Oracle 12c R1, PL/SQL
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:
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)
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
Software: Oracle 12c R2, PL/SQL
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.
Software: Oracle 12c R1, PL/SQL
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
Software/Hardware: Oracle 11g R2, PL/SQL, Erwin, Linux
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)
Software/Hardware: Oracle 11g R2, PL/SQL, Erwin, Solaris
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.
Software/Hardware: Oracle 11g R2, PL/SQL, Erwin, Linux, Amazon Web Service Relation Database Service (AWS RDS)
Client: GlaxoSmithKline:
April 2009 to January 2010
Oracle DBA, PL/SQL Developer and Data Modeler for a data warehousing project for GlaxoSmithKline. Responsibilities included:
Installation, Maintenance and performance tuning of the Oracle database.
Development of PL/SQL ETL programs.
Data Modeling using ERWIN.
Software/Hardware: Oracle 10g, PL/SQL, Erwin, Sun-Solaris
Client: CSC:
Nov’ 2008 – April 2009
Worked on an internal project for CSC to develop manufacturing vertical portal for CSC’s clients. The application was aimed at helping clients to manage their engineering change process. Responsibilities included:
Installation, Maintenance, Backup/Recovery and performance tuning of the Oracle database.
Data Modeling using ERWIN.
Software/Hardware: Oracle 10g R2, PL/SQL, Erwin, Linux
Client: Gerdau-AmeriSteel:
October 2008-Nov 2008
Oracle DBA for the health check of client’s Oracle 9i DB. Responsibilities included:
Analysis of AWR Reports of the DB to find out performance bottlenecks.
Making recommendations for reducing load on the DB by creating a logical standby DB or replicating the data using Streams Replication for generating reports and running ad-hoc queries.
Client: Consortium of Healthcare Providers (BCBS, United, Aetna, Cigna etc.):
April 2007 to August 2008
This was a data warehousing project for a consortium of healthcare companies. The application processed claims data to help healthcare companies rate physicians and hospitals based on cost and duration of the treatment. Responsibilities included:
Development of PL/SQL procedures for Extraction of the data.
Physical Data Modeling using ERWIN.
Client: America Online (AOL)
March 2007 to April 2007
Performance Tuning/Health-check of the Oracle 10g Database. Generation and Analysis of AWR report to find out performance bottlenecks and make recommendations in terms of database configuration changes to enhance the performance.
Software/Hardware: Oracle 10g R2, HP-UNIX
Client: T. Row Price
February 2007 to March 2007
Performance tuning of SQL queries to retrieve data from mutual fund database within the specified time frame.
Software/Hardware: Oracle 10g R2
Client: Family Dollar
December 2006 to January 2007
Performance tuning of the client’s Oracle database. This involved performance tuning of the SQL queries, Analysis of the Database Configuration and AWR report to make recommendations to improve the performance of the database.
Software/Hardware: Oracle 10g R2, HP-UNIX
Conduent (formerly Xerox,Affiliated Computer Services (ACS)), Germantown, MD
Electronic Toll Collection System: March 2003 to December 2006
Role: Developer/Analyst
This application is used for toll collection in the E-Z pass lanes on toll roads.
Development and Maintenance of online and batch program using an object oriented language Forte.
Created Database Objects such as Tables, Views, Triggers, Procedure and Functions using SQL, SQL Plus and PL/SQL.
Coding of Data Processing program using C, Pro*C, Embedded SQL.
Preparing functional and technical specifications for new requirements.
Writing Perl scripts for FTP transmission of data files
Software/Hardware: Oracle, C, Unix, Sun Forte, Linux, DEC-Alpha
Thomson Financial, Rockville, MD
Performance and Analysis Systems: Sep’2001 to Aug’2002
Role: Oracle Developer/Analyst
Responsible for taking over the Funds and Stocks data warehouse application from the other branch of Thomson Financial. This involved interacting with users and programmers to understand the functionality, documentation, Requirement Analysis, Preparing Functional and Technical specifications, Database Design.
Development of PL/SQL Procedures, Database Triggers, PRO*C and Developer 2000 Forms 5.0 programs.
Writing PERL scripts to modify the data in plain text files.
Reverse Engineering and Data Modeling using ERWIN.
Performance Tuning of SQL queries and Database.
Software/Hardware: Oracle RDBMS 8.1.7, 8.1.9, Developer 2000, ERWIN, UNIX,
PL/SQL, KORN Shell script, PRO*C, DEC-Alpha, PERL,
TOAD
Nationwide Insurance (Gates-McDonald), Hilliard, OH
Time Off Planning System: Oct’2000 to June’2001
Role: Analyst/Oracle PL/SQL Developer/Development Database Application DBA
Responsible for the back end of client –server application written in Java.
Requirement Analysis, Systems Analysis and Database Design, Preparing Functional and Technical specifications.
Coding of PL/SQL scripts, Database Triggers.
Automation of Reports and batch programs that resulted in a timely generation and delivery of all the reports and batch processing programs. Reduced the errors that were occurring because of the manual execution of programs.
Responsible for implementation of application for new clients, American Greetings & AVAYA. Implemented the application for the new clients within a month and half after starting at Gates-McDonald. We were able to meet the deadline on this “time-critical” project.
Application DBA for the development database. Performance tuning of SQL scripts and database which resulted in a better response time of the application.
Used PVCS for Version Control and Code Management.
Software/Hardware: UNIX, Oracle RDBMS 8i, PL/SQL, SQLPLUS, KORN Shell
Script, PVCS, HP-9000, PVCS
Caterpillar Inc., Morton, IL
Enhanced IWS System: Jan ’00-Oct’ 00
Role: Analyst/Oracle, PRO*C, PL/SQL UNIX Developer/ Java, JSP, Java Script Developer
Enhancement of the functionality of application using C, Java, JSP, VISUALAGE for Java, UNIX, NT which resulted in getting all the information from DB2 database to Oracle database. The application could now be run if DB2 database was down which increased the shipments of spare parts.
Performance enhancement of client server application using JDBC, PL/SQL database procedures. The resource intensive queries that were replaced by database procedures ran with 50% better response time.
Application DBA for the group. Responsibilities for Database Design, Creating Tables, Sequences, Indexes, Roles and Granting Privileges and Performance tuning of SQL queries using proper indexes on tables.
Systems Analysis, Design.
Software/Hardware: C, PRO*C, PL/SQL, ORACLE 8.1.7, UNIX (AIX), KORN
Shell, Java, JSP, Java Script, JDBC, HTML, NT, RS-6000
Automated Warehouse Control System: July’96-Dec’96
Role: Analyst/Development Team Leader/Oracle, PL/SQL, PRO*C Developer
Requirement Study, System Analysis, Design, Coding, Testing, Implementation and Support of a real time application.
Analysis and Modification of the application for Y2K compliance.
Application Database Administration. Creating Oracle tables, Sequences, Indexes and performance tuning of SQL queries.
Writing DCL procedures.
Setting up CMS for version control.
Implemented procedures for Code Changes, Code Walk-through, and Production Implementation.
Hardware/Software: C, PRO*C, Oracle RDBMS 8, PL/SQL, SQLPLUS, Open
VMS, DCL, DEC-ALPHA
Intel Corporation, Albuquerque, NM
Loss Code System: Aug’93-Apr’96
Role: Systems Analyst/ Programmer/Business Analyst
System Analysis, Design, Coding, Testing and Implementation.
Enhancements and Modifications to suit the needs of all the manufacturing plants of Intel.
Wrote command procedure using DCL.
Coding and Implementation of communication module for data transfer between UNIX Workstations and VAX machine.
Software/Hardware: DEC-COBOL, DEC-C, INGRES, VIFRED, ABF, VMS, DCL,
VAX, MS-ACCESS
Digital Equipment Corporation, Acton, MA
Warranty Registration System: April’92-Feb’93
Role: Programming Team Leader/Analyst/Developer
Application Requirement study, System Design and Analysis, Coding, Testing.
Writing DCL procedures.
Screen generation using FMS.
Setting up CMS for version control.
Lead a team of programmers.
Software/Hardware: DEC-COBOL, VMS, DCL, CMS, MMS, FMS, RDB, VAX
Bajaj Auto Ltd., India
Vehicle Sales System/ Spare Parts Inventory/ Marketing & Sales Application: Aug’87-Nov’91
Role: Programmer/Analyst
Analysis, Design, Coding and Implementation of Sales and Marketing applications.
As a one-member team, coded numerous programs using ORACLE front-end tools such as SQL Forms and Report writer.
Wrote several Data Processing and Data entry programs using DEC-COBOL, TDMS.
Report generation using DTR.
Software/Hardware: DEC-COBOL, MF-COBOL, VMS, DCL, ORACLE,
SQL Forms, Report Writer, PRO*COBOL, TDMS, VAX
REFERENCES AVAILABLE UPON REQUEST
Contact this candidate