Oracle DBA
Resume:
Sree Infotech LLC
******@************.***
DEEPAK 972-
***-*****116
Professional Summary
Eight years of experience in the Information Technology field as Oracle
Database Administrator having hands on experience in database
administration, development, production support, installation,
configuration, upgrades, patches, performance tuning, backup and recovery,
cloning, space management, database security on various environment like
Sun Solaris, RHEL, HP-UX, AIX, LINUX and Windows.
. Extensive knowledge on database administration for Oracle 11g RAC/10g
RAC/9i/8i.
. Experience in Configuring Single Instance, Oracle Real Application
Clusters(RAC) and Automatic Storage Management(ASM).
. Expert in backup/recovery, installation, configuration, apply patches,
troubleshooting, performance monitoring, cloning, upgrading and
migration of oracle software and tools.
. Solid experience on Upgrading Oracle databases for Oracle 11g RAC/10g
RAC /9i.
. Solid experience in Oracle Recovery Manager (RMAN), and standby
database using Data Guard.
. Expertise in the database infrastructure design which also include Real
Applications Clusters (RAC), Standby Databases (Data Gaurd).
. Data transferring with export/import utilities and Data Pump and SQL*
Loader.
. Good experience in SQL, PL/SQL Programming (Functions, procedures,
packages and triggers).
. Developed SQL, UNIX and LINUX shell scripts to automate DBA functions.
Diagnosed problems and implement corrective actions.
. Extensive knowledge of Oracle Architecture, SGA, PGA, Listener, TNS
Names, SQL*Net.
. Experience working with Oracle Data Integrator (ODI).
. Maintained large production as well as development/test/stage databases
which involve Data warehousing and OLTP applications.
. Hands on experience in build and Design of Databases for Oracle 10g and
11g.
. Installation of various SOA features like Encryption, SSO, Secure
Socket Layer, Data Integration.
. Proficient with OEM, Erwin, SQL Developer, RMAN and Toad.
. Exposure to Oracle Utilities and Tools like OEM 12C, Import-Export,
Auditing, RMAN
. Experience in implementing Oracle Streams and in installation and
administration of GoldenGate.
. Experience in Capacity Planning and Bench Marking.
. Experience in all facets of the systems development lifecycle, from
requirement development, architecture design, testing, and post
implementation revisions.
. Experience in working with Big Data Appliance with Oracle Exadata
Machines.
. Capable of working under pressure and stiff deadlines with 24/7
Database support.
. Experience in analyzing, translating business requirements to technical
requirements and architecture.
. Experienced in performance tuning of various aspects of the database by
using oracle utilities like TKPROF, EXPLAIN PACK PLAN, STATS,
SQL_TRACE, TOAD and Automatic Database Diagnostic Monitor (ADDM).
TECHNICAL SKILLS
Databases : Oracle 11g R2 RAC, 10gR2RAC, 9i, 8i, 7.x, Server
2012/2008/2005, IBM DB2.
Operating Systems : HP-UX, Sun Solaris, AIX, Linux and Windows.
Languages : SQL, PL/SQL, Java, C, UNIX Shell Scripting.
Tools : RMAN, OEM, SQL*Loader, EXP, IMP, Data Pump, Erwin, TOAD,
DB Artisan.
Tuning Tools : TKPROF, EXPLAIN PLAN, STATSPACK, AWR, OEM
12C, Grid Control
ETL Tools : Informatica 5.1, Data pump, Data warehousing
Other : EMC, Net App, VERITAS
EDUCATION
Bachelor of Engineering, OU, Hyderabad
PROFESSIONAL EXPERIENCE
Client: TIAA-CREF/HCL, Cary, NC Aug
2014 to Present
Oracle RAC DBA
Responsibilities:
. Worked on this project as Oracle Core DBA. Planning and scheduling
Backups, Database Recovery, taking Logical Backups (with Export
/Import), Database backup (Hot & cold).
. Worked in AES encryption in oracle 10g and 11g by using DBMS_Crypto
package.
. Worked on Features: Data Pump, ASM and RMAN. Data Base Recovery
(complete & Incomplete).
. Proficient in managing Oracle Instance, database storage structure,
schema objects.
. Experienced with SRVCTL, OCR and Voting Disk of 10g,11g RAC.
. Involved & performed Production Change Requests for PRD major DB
changes. New DB creation, Existing DB deletion, various DB Housekeeping
activities. Implemented 10g RAC on a test basis.
. Administration of all database objects, including tables, Indexes,
views, sequences, packages and procedures.
. Performed and monitored Hot and cold database backups and implemented
backup and recovery using RMAN and Knowledge of storage technologies
SAN, NAS.
. Experience in Planning Database, Sizing table space, Create database,
scripts, Monitor databases, Interact with developers, Oracle Install,
Upgrade, 24x7 production support.
. Apparently perform SQL tuning and baseline tuning. Experience Flash
back .
. Skilled with STATSPACK, AWR, ADDM, SAR to check health of database &
hardware.
. Adding the required User Logins, Groups and Users, Granting and
Revoking Permission to/from the users. Co-coordinating with on-site
counterpart as well as Clients and understanding requirements.
. Experience in providing Real time data feeds, heterogeity and
transactional integrity by using Golden Gate.
. Experience in Performance and Tuning databases using various
techniques. Collected performance statistics memory usage, data
storage.
. Generating Statspack reports and AWR and ADDM reports for Database for
Application tuning and also database Partitioning.
. Experience in Data Migration Working with Oracle 10g and 11g.
. Experience in proprietary change management processes to prevent
production disruptions and outages.
. Experience in implement a variety of solutions for improving the
availability, accessibility, performance, and integration of critical
data across the enterprise with Golden Gate.
. Extensively used PL/SQL for designing packages, stored procedures,
functions and database triggers.
. Created Cluster database, Cloning of Cluster database on Linux, start
and stop Cluster database services.
. Experience to Continuous availability and disaster tolerance of
critical data systems is more than "after-the-fact" data recovery by
using Golden Gate.
. Experience in quality support and delivery to the end-user.
. Designed and developed Database structures (Database triggers,
Procedures, Functions to implement business Rules). Loaded data into
Database using external tables.
. Exposure to Oracle Utilities and Tools like OEM 12C, Import-Export,
Auditing, RMAN.
Environment: Operating Systems: IBM-AIX, SunSparcSolaris64bit, and Redhat
Linux.
RDBMS: Oracle Database Server 10g/11g,Golden Gate, Programming
Language/Tools: TOAD, PL/SQL.
Client: Tennessee Valley Authority (TVA), Knoxville, TN
Oct 2011 to Jul 2014
Database Administrator
Responsibilities:
. Installation and configuration of the Development, Test and Production
databases.
. Installation, configuration and administration of Oracle Real
Application Clusters (Oracle 11g RAC/Oracle 10g RAC) and Standby
Databases for High Availability and Disaster Recovery purpose
Performed database logical and physical design, maintenance,
archiving, cloning, administration and upgrades for Oracle.
. Upgrade/Migrated the production and development databases from 9i to
10g.
. Upgrade/Migrated the production and development databases from RAC
/10g to RAC /11g.
. Performed and monitored Hot and cold database backups and implemented
backup and recovery using RMAN and Knowledge of storage technologies
SAN, NAS.
. Experience working with Oracle Data Integrator (ODI).
. Worked extensively in Build and design for oracle database for People
Soft Applications.
. Installation and Configuration of Web Logic Server on Sun Solaris for
People Soft HCM Migration.
. Migration of ADP HR to People Soft HCM.
. Installation and configuration of People Soft HCM and CRM. Modules.
. Installation and Configuration of Golden Gate. Done data replication
using Golden Gate software.
. Involved in the Design of Backup and Recovery Strategies using RMAN
and traditional backup methods.
. Provided 24/7 Production Database and Applications support.
. Maintenance of 8 TB EDW Data warehousing environment.
. Worked closely with Business Intelligence Developers to extract data
From EDW using Informatica.
. Worked on large and complex databases SQL Server 2012, SQL Server 2008
and 2005.
. Implemented new SQL Server 2012 mechanisms like data compressions,
online indexing, contained databases, security principles and AAG.
. Implemented and Configured Standby database (Data guard) for disaster
Recovery
. Involved in performance-tuning activities to improve performance of
the Oracle database. Tune database through initialization parameter,
SQL/PLSQL statement, error checking and memory by performing routine
checks of the SGA, CPU, logical and physical I/Os and contention.
. Involved in capacity and resource planning. Estimated the size of data
files and redo log files considering transactions rate, transaction
records size, transaction type, recovery time allowed etc.
. Applied patches and updates to the Oracle database.
. Installation of various ASO environments Featuring Encryption, SSO,
Secure Scoket Layer, Data Integration
. Provided documentation as well as training on process and procedures
for infrastructure architecture.
. Worked on Design for a project using Exadata Machines.
. Worked on Setup, configuration, performance tuning, troubleshooting on
Exadata machines.
. Worked on Oracle Big Data Appliance on Exadata Machines to capture and
analyze the data.
. Worked on Shell scripts to automate system and database administration
tasks.
. Designed data files, log files and control files layout across disks.
. Developed PL/SQL Packages, procedures and triggers to implement
various functionalities.
. Support and ensure the high availability of all the databases
especially on Clustered Databases.
. Implemented Oracle Real Application Clusters (RAC).
. Generated and analyzed STATSPACK, AWR, ADDM, Explain Plan reports and
monitored statistics for performance tuning of the database.
. Experience in setting up and administering Oracle Streams. Configured
replication based on Oracle Streams.
. Export and import of database objects using Data pump utilities EXPDP
and IMPDP.
. Used Erwin database design tool and Oracle Enterprise Manager (OEM).
. Troubleshooting for Production database issues/Performance issues
based on Remedial tickets.
. Documentation of RAC Database Setup, Stream Replication and
administration of Server Environment.
Environment: Oracle 11gRAC/10g RAC, 9i, SQL Server 2012/2008/2005, AIX, HP-
UX, LINUX,SUN SOLARIS, WINDOWS, Grid Control, RMAN, SQL*Loader, SQL*Plus,
Data Pump, ERWIN.
Verizon Wireless, Irving, TX
Oct 2009 to Sep 2011
Senior Oracle DBA
Responsibilities:
. 24/7 Production Database support of multi-terabyte Oracle 11g database.
. Performed all aspects of database administration including
Installation, Configuration, Patches, Monitoring, Import/Export,
Cloning, etc.
. Upgrade/Migrated the production and development databases from RAC /10g
to RAC /11g.
. Installation, configuration and administration of Oracle Real
Application Clusters (Oracle 11g RAC/Oracle 10g RAC) and Standby
Databases for High Availability and Disaster Recovery purpose.
. Plan, implement, and troubleshooting Oracle RMAN backup, restore, and
recovery.
. Provide performance tuning, problem diagnosis, data reorganization and
database upgrade support.
. Monitor and tune Oracle database for optimum performance. Assist in
capacity planning of Oracle database servers.
. Responsible for Creating, Constructing, Operating and maintaining
Interfaces using ODI.
. Generated and analyzed STATSPACK, AWR, ADDM, Explain Plan reports,
error checking and monitored statistics for performance tuning of the
database.
. Performed Data replication and Data transformation.
. Export and import of database objects using Data pump utilities EXPDP
and IMPDP.
. Performed data loads using SQL*LOADER.
. Developed PL/SQL Packages, functions and triggers to implement various
functionalities.
. Experience in Managing work repositories and creating reports.
. Installation and administration of GoldenGate.
. Wrote UNIX Shell Scripts for Backup and cloning.
. Tune SQL, PL/SQL statements found in the reporting utilities and
queries.
. Involved in the maintenance and trouble shooting of RAC Databases.
. Monitored and managed the space usage and table partitioning.
. Implemented and Configured Standby database (Data guard) for disaster
Recovery.
. Primary point of contact between customer and core development team.
Environment: Oracle 11g RAC/10g RAC, RedHat Linux, Sun Solaris, HP-UX, AIX,
Windows, Oracle Data Integrator, GoldenGate, SQL, PL/SQL, RMAN,
SQL*Loader, Import/Export, Data Pump, Data guard, AWR, ADDM.
Bank of America, Dallas, TX
Aug 2008 to Sep 2009
Database Administrator
Responsibilities:
. Installation and configuration of the Development, Test and Production
databases.
. Installation, configuration and administration of Oracle Real
Application Clusters (Oracle 11g RAC/Oracle 10g RAC) and Standby
Databases for High Availability and Disaster Recovery purpose.
. Performed database logical and physical design, maintenance,
archiving, cloning, administration and upgrades for Oracle.
. 24/7 Production Database and Applications support.
. Experience working with Oracle Data Integrator (ODI).
. Performed and monitored Hot and cold database backups and implemented
backup and recovery using RMAN and Knowledge of storage technologies
SAN, NAS.
. Designed data files, log files and control files layout across disks.
. Upgrade/Migrated the production and development databases from 9i to
10g.
. Involved in the Design of Backup and Recovery Strategies using RMAN
and traditional backup methods.
. Provided documentation as well as training on process and procedures
for infrastructure architecture.
. Applied patches and updates to the Oracle database.
. Support and ensure the high availability of all the databases
especially on Clustered Databases.
. Implemented Oracle Real Application Clusters (RAC).
. Worked on Shell scripts to automate system and database administration
tasks.
. Involved in capacity and resource planning. Estimated the size of data
files and redo log files considering transactions rate, transaction
records size, transaction type, recovery time allowed etc.
. Developed PL/SQL Packages, procedures and triggers to implement
various functionalities.
. Experience in setting up and administering Oracle Streams. Configured
replication based on Oracle Streams.
. Involved in performance-tuning activities to improve performance of
the Oracle database. Tune database through initialization parameter,
SQL/PLSQL statement, and memory by performing routine checks of the
SGA, CPU, logical and physical I/Os and contention.
. Generated and analyzed STATSPACK, AWR, ADDM, Explain Plan reports and
monitored statistics for performance tuning of the database.
. Export and import of database objects using Data pump utilities EXPDP
and IMPDP.
. Used Erwin database design tool and Oracle Enterprise Manager (OEM).
. Troubleshooting for Production database issues/Performance issues
based on Remedial tickets.
. Documentation of RAC Database Setup, Stream Replication and
administration of Server.
Environment: Oracle Database 10g RAC/9i, RedHat Linux, HP-UX, Sun
Solaris, AIX, OEM Grid Control, TOAD, RMAN, Data Pump, SQL*Loader, Erwin.
General Insurance Corporation of India, Hyderabad, INDIA
Jan 2008 to Jul 2008
Oracle DBA
Responsibilities:
. Part of a 5 member DBA team which was involved in the maintenance of
the Oracle 9i/8i databases for the Production as well as the
development environments.
. 24x7 Production database and applications support.
. Implementation and configuration of OEM Grid, Oracle Management Server
for maintenance and monitoring data.
. Configuring RMAN backup to various databases.
. Setup and configured Oracle Physical Standby database (Data Guard) for
disaster recovery as well as to offload the running of huge reports.
. Experience working with Oracle Data Integrator (ODI).
. Generated and analyzed STATSPACK, AWR, ADDM reports and monitored
statistics for performance tuning of the database.
. Review alert logs and dump files to check for any problems related to
the database.
. Database cloning to setup identical databases in the production and
development environments.
. Create and maintain users, roles and privileges & Auditing Triggers.
. Upgrade/Migrated the production and development databases from 8i to
9i.
. Oracle 9i Streams Replication setup and Configuration.
. Setup and configured 2 node Oracle 10g RAC with ASM.
. Back end Programming/scripting using SQL and PL / SQL.
. Created table partition and index partition.
. Troubleshooting for Production database issues/Performance issues.
Environment: Oracle 10g RAC9i/8i, HP-UNIX, Linux SUSE, SQL, Oracle
Replication, Explain Plan, Toad
Shantha Biotechnics, Hyderabad, INDIA
Mar 2007 to Dec 2007
Oracle DBA/Developer
Responsibilities:
. Installation and Configuration of Oracle 9i/8i.
. Plan and build database instances and objects.
. Performed Periodical backups.
. Restoration and Recovery.
. 24x7 Production database and applications support.
. Performed all aspects of cloning, partitioning, troubleshooting,
applying patches and database monitoring.
. Used Explain Plan and oracle optimizer hints to enhance performance of
SQL statements.
. Performance Tuning of queries using EXPLAIN PLAN, TKPROF and SQL TRACE
tuning of other objects in the database, tuning of database, tune the
memory structure.
. Creation and maintenance of user accounts and system & user level
database objects.
. Creation of the required objects for the application.
. Back end Programming using SQL and PL / SQL.
. Conversant with logical and physical design, configuring and layout of
database.
. Understood the application architecture and suggested steps for
improved performance.
. Responsible for porting data from the existing billing using data
migration tools along with SQL Loader and Import/Export and
consistency checking.
. Configuring TNSNAMES.ORA and LISTENER.ORA for Client Server
Connections.
Environment: Oracle 9i/8i, SQL, PL/SQL, Sun Solaris, HP-UX, RHEL, SQL
Loader.
Contact this candidate