Senior Principle Oracle Database Administrator

Giridhar Sadu

571-215-3075


girisadu@hotmail.com



 



 


Senior Software Consultant with more than 20 years of experience in various skills like development, administration and management, More than 15 years in Oracle Database Administration with different versions 12c/11g/10g/9.x/8.x/7.x. Deep hands on experience in working on Exadata platform implementing database solutions including configuration, bench marking, optimization, and setting up high availability solutions. Exceptional Proficiency in Data Modeling, Oracle Installation, Configuration, Backup and Recovery skills and 24X7 support functions. Extensive experience in writing shell scripts, deploying and debugging functions, procedures, triggers, packages etc.


 


 


Known for Innate ability to understand the big picture and apply database technology solutions very effectively to solve key business issues.


 


 


 


Skills










































Languages


SQL, PL/SQL, C, and Shell Scripting.



RDBMS



Oracle 12c/11g/10g/9i/8i/8/7.x, Sybase, and SQL Server 6.5



Middleware



Oracle Middleware: WebLogic 11g, Oracle Application Server



Operating Systems



Linux, HP Unix 10.2/11, Sun Solaris 2.5/2.6/2.8, AIX, Windows NT, and Windows 2008



Hardware



Oracle EXADATA, HP 9000, SUN V1280, 420R, and E3500



GUI



Developer 2000, Power Builder, and Visual Basic



Database Tools



Oracle Enterprise Manager (OEM), Embarcadero DBArtisan, TOAD and Recovery Manager (RMAN).



Utilities



SQL*Loader, UTL_FILE, EXPDP



Tools



OBIEE, Oracle Data Integrator (ODI), Infomatica, COGNOS, Embarcadero ER Studio, Erwin, Designer 2000.



 


Education:  Master in Computer Applications (MCA)

 


Work Status: US CITIZEN


 


Professional Experience

 


Accenture Federal Services Inc.                                    Oct 2011 to Present


Client      : DHS / CBP


Sr. Oracle DBA


 


Responsibilities:


 



  • Led the efforts to design solutions to migrate oracle databases on legacy systems to EXADATA.

  • Upgraded the 11g databases to 12c in order to utilize latest available features of Oracle.

  • Led the effort in creating and configuring the Oracle 11g Databases on Oracle EXADATA platform as part of the consolidation efforts for the agency.

  • Extensively used GoldenGate in migration efforts for systems hosted on ZLinux and Non Oracle databases (SQL Server)

  • Involved in the Database consolidations and migrations to Oracle EXADATA from other systems in timely manner to reduce the TCO for the agency.

  • Oracle11g Grid Infrastructure (RAC) Setup and maintenance.

  • Setup DataGuard for multiple standby using one primary database.

  • Designed, planned and implemented the Disaster Recovery (DR) setup.

  • Performed Oracle11g databases Upgrades from Oracle10g and Oracle9i.

  • Vast Experience with RMAN to implement Backup/Recovery strategies and clear understanding of the data structures and architecture provided by Oracle for Recovery in all kinds of Disasters.

  • Involved in Database Performance Tuning activity.

  • Implemented Oracle Grid Control for Database Admin. And monitoring.

  • Developed multiple shell scripts for monitoring database

  • Involved in WebLogic Administration Support and production support for various releases of Application.


Environment: Oracle EXADATA, GoldenGate, OBIEE, Sun Solaris, AIX, Linux and Windows 2008, Oracle 11g and 12c, WebLogic Middleware, Shell Scripting, SQL Scripting, PL/SQL, SQL*Loader, Oracle Grid Control/Enterprise Manager, TOAD, SQL Developer.


 


Deloitte Consulting LLP.                                      June 2010 to Oct 2011


Client      : Bureau of Engraving and Printing (BEP)


Sr. Oracle DBA


 


Responsibilities:



  • Installation and Maintenance of Oracle10g and 11g Enterprise Edition.

  • Oracle11g Grid Infrastructure (RAC) Setup and maintenance.

  • Performed Oracle11g databases Upgrades from Oracle10g and Oracle9i.

  • Creating and maintenance of Disaster Recovery (DR) site using Oracle Data Guard Technology.

  • 24x7 Active Production Support and day-to-day Oracle DBA functions.

  • Experienced in Installation, Configuration, Deployment and cloning of Oracle E- Business Suite R12.

  • Responsible for installation, upgrades, patches, TAR/SR support, database tuning, concurrent manager administration, cloning and Oracle Apps SYSADMIN functions.

  • Experienced in configuration and tuning of the EBS environment including concurrent managers, work flow, application servers and databases.

  • Expertise in using ADPATCH, ADADMIN, ADCTRL, ADRELINK, ADIDENT, ADMERGE, ADCONFIG, ADMRGPCH, ADLICMGR & PTS tools

  • Experienced in applying product specific fix patches, family packs and maintenance packs.

  • Troubleshooting expertise for all tiers (Apache, Forms, Concurrent, Admin and database)

  • Heavy Emphasis on reviewing and researching oracle Security Alerts and recommending and implementing security patches and Ensuring the security requirements

  • Vast Experience with RMAN to implement Backup/Recovery strategies and clear understanding of the data structures and architecture provided by Oracle for Recovery in all kinds of Disasters Extensively

  • Involved in Database Performance Tuning activity.

  • Implemented Oracle Grid Control for Database Admin. And monitoring.

  • Developed multiple shell scripts for monitoring databases, such as Database up, Tablespace, and Alert log.

  • Implemented SOX and Federal Agency Security compliance and Audit reporting.

  • Involved in WebLogic Administration Support and production support for various releases of Application.

  • Supporting Oracle Data Integrator (ODI) setup and maintenance. Project maintenance support: Moving Application releases to Production environment.


 


Environment: Sun Solaris, AIX, Linux and Windows 2008, Oracle 10g and 11g, WebLogic Middleware, Oracle Data Integrator (ODI), Shell Scripting, SQL Scripting, PL/SQL, SQL*Loader, Oracle Grid Control/Enterprise Manager, TOAD, SQL Developer.


 


Neustar Inc.                                                                   Jun 2007 to Jun 2010


Sr. Oracle DBA


 


Responsibilities:



  • Implemented Multi Master Advanced Replication in Neustar Projects.

  • Implemented heterogeneous database migration using GoldenGate technologies.

  • Installation and Maintenance of Oracle9i and 10g Enterprise Edition.

  • 24/7 Production Support and day-to-day Oracle DBA functions.

  • Involved in database Upgrade process to Oracle 10g from Oracle 9i.

  • Worked in a team environment to implement and manage the RAC, and ASM.

  • Involved in Configuring and maintaining the Standby database and Oracle Data Guard.

  • Heavy Emphasis on reviewing and researching oracle Security Alerts and recommending and implementing security patches and Ensuring the security requirements

  • Extensive experience with RMAN to implement Backup/Recovery strategies.

  • Fine tune Transaction intensive servers i.e. OLTP situations (I/O bottlenecks, SGA, Pinning objects, Sort space, literal SQL, Redo logs). Execution plan and tune queries, using Indexes, hints etc. Vast experience in using TKPROF and STATSPACK and AWR reports.

  • Implemented Oracle Grid Control for Database Admin. And monitoring.

  • Developed multiple shell scripts for monitoring databases, such as Database up, Tablespace, and Alert log.

  • Implemented SOX compliance Audit reporting.


 


Environment: Sun Solaris, AIX, Linux and Windows 2000, Oracle 9i and 10g, Shell Scripting, SQL Scripting, PL/SQL, SQL*Loader, Oracle Grid Control/Enterprise Manager, TOAD, ERStudio and DBArtisan.


 


 


Enclipse Corp.                                                                Jan 2007 to Jun 2007


Client     : Kaiser Permanente, MD


Sr. Oracle DBA


 


Responsibilities:



  • Involved in Data Warehousing design & implementation.

  • Installed and Maintained 8i, 9i and 10g Enterprise Edition.

  • 24/7 Support and day-to-day Oracle DBA functions such as creation of multiple database instances for Development, Testing, Production and Training environments.

  • Led in database Upgrade process to Oracle 10g from Oracle 9i.

  • Led in Configuring and maintaining the Standby database and Oracle Data Guard.

  • Heavy Emphasis on reviewing and researching oracle Security Alerts and recommending and implementing security patches and Ensuring the security requirements

  • Applied Patches to Upgrade to Oracle 10gR2 from Oracle 10.1.x

  • Designed and Created the logical and physical data models

  • Involved in Informatica development to support Data warehousing Project.

  • Analyzed and Implemented Partitions and Indexes.

  • Vast Experience with RMAN to implement Backup/Recovery strategies and clear understanding of the data structures and architecture provided by oracle for Recovery in all kinds of Disasters Extensively

  • Fine tune Transaction intensive servers i.e. OLTP situations (I/O bottlenecks, SGA, Pinning objects, Sort space, literal SQL, Redo logs). Execution plan and tune queries, using Indexes, hints etc. Vast experience in using TKPROF and STATSPACK.

  • Developed and tuned the complex PL/SQL objects - packages, triggers, Functions, and procedures.

  • Involved in data uploading using SQL*Loader and other utilities.


 


Environment: Sun Solaris, AIX, Linux and Windows 2000, Oracle 8.1.7, Oracle 9i and 10g, Shell Scripting, SQL Scripting, PL/SQL, SQL*Loader, Oracle Enterprise Manager, TOAD, ERStudio and DBArtisan.


 


TEK Systems Inc.                                                          Aug 2006 to Jan 2007


Client     : FannieMae


Sr. Oracle DBA


 


Responsibilities:



  • Installed, configured and maintained 9i and 10g Enterprise Edition.

  • Production Support and day-to-day Oracle DBA functions such as creation of multiple database instances for Development, Testing, Production and Training environments.

  • Involved in database Upgrade process to Oracle 10g from Oracle 9i.

  • Developing and tuning the complex PL/SQL objects - packages, triggers, Functions, and procedures.

  • Extensively used RMAN to support database backups Hot and Cold.

  • Involved in database tuning and performance optimization at application/database level using tools such as STATSPACK, TKPROF and EXPLAIN PLAN.


 


Environment: Sun Solaris, HP UX 11.00, and Windows 2000, Oracle 9i and 10g, Shell Scripting, SQL Scripting, PL/SQL, SQL*Loader, Oracle Enterprise Manager, TOAD, ERStudio and DBArtisan.


 


 


CGI Federal Inc.                                                           Mar 2006 to July 2006


Client: Center For Medicare and Medicaid Services (United States Department of Health & Human Services)


Sr. Oracle DBA


 


Responsibilities:



  • Designed and Created logical and physical data models

  • Production Support and day-to-day Oracle DBA functions such as creation of multiple database instances for Development, Testing, Production and Training environments.

  • Involved in database Upgrade process to Oracle 10g from Oracle 9i.

  • Developed tuning solutions to complex PL/SQL objects - packages, triggers, Functions, and procedures.

  • Involved in Application Process design.

  • Formulating Database Backup and Recovery Strategies; Physical Backup (Cold and Hot backup) using Rman and Logical Backup Using Import/Export Utilities. Database cloning using Rman.

  • Extensively Involved in data uploading using SQL*Loader and other utilities.

  • Involved in database tuning and performance optimization at application/database level using tools such as STATSPACK, TKPROF and EXPLAIN PLAN.

  • Designed and maintained shell scripts to Database backups.

  • Developed and automated Centralized database monitoring scripts, such as Tablespace Monitoring, Database Heart beat Monitoring, and Active user sessions monitoring.

  • Tracking application DDL versions and review for efficiency and standards adherence.

  • Involved in Development and maintenance of corporate wide Oracle Names Server.

  • Involved in maintenance of Sybase Extract server.


 


Environment: Sun Solaris, HP UX 11.00, and Windows 2000, Oracle 9i and 10g, Shell Scripting, SQL Scripting, PL/SQL, SQL*Loader, Oracle Enterprise Manager, TOAD, ERStudio and DBArtisan.


 


Xspedius Communications. VA                                     Apr 2000 to Mar 2006


Sr. Oracle DBA


 


Responsibilities:



  • Maintained highly visible PeopleSoft Finance and HR databases with zero unplanned downtime. 

  • Installation and configuration of Oracle Application Server.

  • Involved in VERITAS Clustering implementation on Database Servers.

  • Installation and Maintenance of Oracle 8.x/9i and 10g Enterprise Edition.

  • Designed and Created logical and physical data models

  • Implemented Partitioning (Range and Hash partition) and partition pruning.

  • Providing 24/7 Production Support and day-to-day Oracle DBA functions such as creation of multiple database instances for Development, Testing, Production and Training environments.

  • Upgraded databases to Oracle 9i and implemented Oracle 9i features.

  • Formulated Database Backup and Recovery Strategies for the organization.

    • Physical Backup (Cold and Hot backup)

    • Logical Backup Using Import/Export Utilities.

    • RMAN Implementation, Maintenance and Administration.

    • Database cloning using Rman.

    • Involved in database tuning and performance optimization at application/database level using tools such as STATSPACK, TKPROF and EXPLAIN PLAN.

    • Designed and maintained shell scripts to Database backups.

    • Developed and automated Centralized database monitoring scripts, such as Tablespace Monitoring, Database Heart beat Monitoring, and Active user sessions monitoring.

    • Tracking application DDL versions and review for efficiency and standards adherence.

    • Developed Database standards and check list for database and object design and development.

    • Responsible for Database capacity planning and management.

    • Involved in Development and maintenance of corporate wide Oracle Names Server.

    • Involve in maintenance of Sybase Extract server.




 


Environment: Sun Solaris, HP UX 11.00, Linux, and Windows 2000, Oracle 8i/9i/10g, Shell Scripting, SQL Scripting, PL/SQL, SQL*Loader, Oracle Enterprise Manager, TOAD, ERStudio and DBArtisan.


 


BigStar.com, NY.                                                         Jan 2000 to Apr 2000


DBA


 


Responsibilities:


  • Database creation and Migration from Oracle 8.0 to Oracle 8.1.6.

  • User creation and assigning roles and privileges to them.

  • Formulating Database Backup and Recovery Strategy: Physical Backup (Cold and Hot backup) Logical Backup Using Import/Export Utilities. Establishing the scripts for Cold and Hot backup.

  • Involved in automation of Database startup and shutdown using scripts.

  • Extensively Involved in data uploading using SQL*Loader and other utilities.

  • Performed extensive database tuning and performance optimization

  • Involved in Data Warehousing design & implementation.


 


Environment: Windows NT, Solaris 2.6, Windows 95, Oracle 8i, Shell Scripting, SQL Scripting, PL/SQL, SQL*Loader, and Oracle Enterprise Manager.


 


NIIT, Delhi, India  


Worked as Oracle DBA/Developer on multiple projects with different clients


 


TOSHIBA ASIA PACIFIC PTE., SINGAPORE                       Apr’98  to Dec’99


CONTINENTAL OIL COMPANY (CONOCO), LONDON         Oct’97  to  Apr’98


CYPRUS GOVERNAMENT, CYPRUS                                Mar’97 to  Oct’97


MINISTRY OF DEFENCE (MINDEF), SINGAPORE            July’96 to Feb’97


OUTWARD BOUND SINGAPORE (OBS), SINGAPORE      Jan’96 to July’96


 


Responsibilities:



  • Performed various database administration activities. Responsible for Oracle installation, Creation of instances, Migration of data, Backups and Table space management. Developed SQL scripts and Shell scripts to automate routine tasks. Utilized Oracle Enterprise Manager to perform routine administration tasks. Interacted with application development team to improve the performance of the applications. Analyzed the SQL trace and created additional indexes to improve performance.



  • Setup and monitoring automated daily backups. Identifying and dealing with row chaining, migration and disk fragmentation, Recompiling Objects. Generating administration reports of Database on free space statistics, cache statistics and database file info.  Involved in back end programming such as creating Stored Procedures, Functions, and Triggers using PL/SQL. Designing and implementing application security.

  • Database Creation. Developed several Stored Procedures, Triggers and Functions. Creating Table spaces. Creating database users and assigning system privileges to them and maintaining system security by controlling and monitoring user access to database. Involved in Development of Forms and reports. Backups and Recovery i.e. exports/imports, hot archive log backups and cold backups. Performance SQL tuning.

  • Responsible for Design & Development of HLD, LLD, Construction of Master Maintenance screens, Transaction screens, Reports and PL/SQL Procedures, Functions, Triggers.  Test cases Preparation and Involved in Quality Reviews and Unit Testing.


 


Environment: Windows NT, HP-UX 10.2, Windows 95, Oracle 7.3/7.1,HP 9000, Forms (4.5), Shell Scripting, SQL Scripting, SQL*Loader, PL/SQL 2.x, SQL*Plus, SQL*Net


 


KARVY CONSULTANTS LTD.                                                Mar 93 to DEC 95

 



  • Worked as Software Programmer using Foxpro and Power Builder.


 

  • ID#: 129965
  • Location: Chantilly, VA , 20152

Don't Be Fooled

  • When selling, do not put your home address in your ad.
  • To avoid scams, buy and sell with people you can meet locally, in person.
  • When meeting with someone you don't know, meet in a public place. If that's not possible, have a buddy with you. Also, carry a cell phone; if you feel unsafe, you can call a trusted friend, and stay on the line.
  • Never give out financial or private information like account numbers, PayPal login, or social security number.
  • If an offer sounds too good to be true, it is. Walk away!

Look Who's Hiring!

Oracle Database Administrator and Engineer
Manassas, VA Swift
ORACLE Database Administrator
Portsmouth, VA NANA Regional Corporation
Oracle Database Administrator/analyst, Dahlgre...
Dahlgren, VA CACI International Inc.
Oracle Database Administrator (DBA) Technical ...
Mc Lean, VA Vencore
Oracle Database Administrator / DB Developer
Fairfax, VA CACI International Inc.