Oracle DBA, Data Architect, PL/SQL Developer, Aws Rds(Oracle) DBA

Sanjay Dharmadhikari

***** ****** **** ***** **********, MD 20871 (H) 240-***-**** (C) 240-***-**** e-mail: ac1lwe@r.postjobfree.com

Bachelor in Mechanical Engineering, PUNE University, India

Clearance: DHS Public Trust, DHS HQ

Summary: 28 Plus years’ experience in IT industry. Oracle certified DBA. Expertise in Oracle DB Installation, Backup and Recovery, Performance tuning, Oracle RAC, 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), PMP, AWS Certified

Solutions Architect-Associate

Languages: PL/SQL, SQLPLUS, KORN Shell, C, PRO*C, COBOL

Databases: ORACLE (11gR2, 12c)

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. Used various replicating tools/utilities like Data Guard, Materialized Views and Streams etc.

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

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

December 2006 to Present

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

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

April 2017 to Present

Oracle DBA, PL/SQL Developer for CMS hospital Quality Reporting System (HQRS) Responsibilities Included:

DBA for the data mart. Creating DB objects and tuned SQL queries for performance.

DB backup and Recovery.

Writing Stored Procedures and functions using PL/SQL

Software/Hardware: Oracle 12c, 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).

DB Backup and Recovery.

Creating and maintaining Oracle Physical Standby Database.

Writing Stored Procedures and functions using PL/SQL.

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:

DBA for the data mart. Maintaining Database, Creating DB objects and tuning SQL queries for performance.

Installation and Maintenance of 2 node Oracle RAC

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

Writing Stored Procedures and functions using PL/SQL

Logical and Physical Data Modeling using Erwin

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.

Creating and Maintaining Logical/Physical Standby databases.

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.

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, Backup/Recovery 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:

Installation, Maintenance, Backup/Recovery and performance tuning of the Oracle database.

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

XEROX (formerly 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.

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