Oracle dba
Resume:
Venkata Devireddy
Sr. Oracle DBA (Oracle DBA-Senior Oracle Database Administrator)
********.***@*****.***
Over 8 years of experience as an Oracle DBAproviding 24/7 support to Oracle
o
RAC and non RACDatabases(OLTP and Data Warehouse)with ASM and non ASM
storage in development, production and testing environmentson various platforms like
HP-UX, Sun Solaris, RHEL.
Over 5 years of experience working with Oracle RAC (Real Application Cluster)
o
& have successfully done 3 projects on Oracle RAC - Configure, implement, and
support
Over 5 years of experience working with Oracle Data Guard (Physical &
o
Logical)& have successfully completed 3 projects using Oracle Data Guard - Implement
& support
Over 3 years of experience working with Oracle Golden Gate and 5 years of
o
experience with Oracle streams with complete end-to-end support for Basic & Advanced
Replication - Configure, Setup, Install, & support
Over 8 years of experience in performance tuning of production and
o
development databases
Over 8 years of experience in developing efficient database backup & recovery
o
strategies
Over 2 years of experience installing, configuring and administering 12c Cloud
o
Control
Over 5 years of experience in writing PL/SQL procedures, packages, SQL
o
triggers for code deployment on non-production and production environments.
Excelling experience in Installation, Setup and configuration of Oracle 12c,
o
11g, 10g in HP-UX, SUN SOLARIS and UNIX/LINUX environment
Proficient in Database Administration activities such as Upgrades, Patches,
o
CPUs, PSUs, TAR support, Cloning, duplicating, Backup and Recovery, Performance
Tuning, capacity planning, script development, and documentation
Experience in using Oracle 12c,11g and 10g RAC features like - Flex ASM,
o
Table recovery from RMAN backup, RAT, Database Replay, SPA, SPM, Real-Time SQL
Monitoring, Data Pump, Flashback technology, Cloud Control, Recycle Bin and
Transportable Tablespaces
Experience using enhanced features in 12c like - Real Application Testing, Table
o
and partition recovery using RMAN, Invisible columns, DDL Logging.
Experience using 12c pluggable and container databases (PDBs and CDBs).
o
Experience in configuring and managing Golden Gate on multi-node RAC
o
environment.
Experience in performing History pull to synch-up data between Oracle to Non-
o
Oracle databases using Golden Gate.
Experience in setting up DDL/Bi-directional replication between source and
o
target databases using Golden Gate.
Experience in configuring Integrated Extract and Co-ordinated Replicat after
o
upgrading Golden gate software to 12.1
Built Oracle MAA PhysicalStandby and Logical Standby and configure Data
o
Guard Broker for High Availability/Disaster Recovery purpose
Provide DBA support with proactive monitoring, identifying areas that need to be
o
improved in the application and databases using Statspack, AWR, ASH
ADDM,SQL_TRACE, TKPROF and OEM Grid Monitoring.
Experience in using SQLPerformance Analyzer to tune the database.
o
Knowledge in using Database Repair Advisor - a wizard/expert system that
o
guides DBAs through the fault diagnosis and resolution process.
Excellent experience in using OEM, TOAD, Data Migrations using
o
Export/Import,Data Pump benchmarking using load testing tools.
Highly proficient in SQL, PL/SQLCoding and tuning
o
DevelopedShell Scripts for backup and recovery, Imported and exported
o
procedure, implementing transportable table paces and for Automating database periodic
maintenance and activities
Management of schemas, objects & Partitioning the tables & indexes.
o
Performed backups and tested crash recoveries using conventional cold, hot &
o
RMAN backupsto Disks and Tapes.
Effective troubleshooting of database and performance problems.
o
Knowledge on Oracle Support processes for technical requests through Metalink
o
and other Support Procedures
Known Technologies:
Operating Systems: HP-UX 10.x, 11.x, Sun Solaris 8, 9, 10, RHEL 4.x, 5.x, 6.x
RDBMS: Oracle 9i, Oracle 10g RAC, Oracle 11g RAC, Oracle 12c RAC
Languages: SQL, PL/SQL, C, Java, UNIX Shell Scripting PERL Scripting
Tuning Tools: TKPROF, EXPLAIN PLAN, STATSPACK, AWR, ADDM, ASH
Tools & Utilities RMAN, OAM, OEM, EXP, IMP, Data Pump, TOAD, SRDF,
SQL*Loader, Oracle Golden Gate, Oracle Streams, Shareplex, Data Guard Broker,
RMAN
Work Experience
Sr. Oracle DBA (Oracle DBA-Senior Oracle Database Administrator)
Alliance Bernstein NYC Nov 2012 to
Present
Responsibilities:
Oracle HA Stack: Install, Configure, Setup, Maintain and Support Oracle 11gR1,
o
11gR2, 12c RAC, Physical and Logical Standby database for Test, Development and
Production for various home-developed applications like Portfolio Management Systems
and vendor applications like SAP Business solutions
Involve in 24x7 on-call support for 11g and 12c RAC Production databases
o
using Oracle 12c Cloud Control for Alert Monitoring and Notification
Develop upgrade roadmap and perform upgrade DBs from 11.2.0.4 to 12.1.
o
Installing and configuring12c Cloud Control and Enterprise Backup Utility.
o
Installing ASM environment and migrating database from NON-ASM to ASM.
o
Thorough understanding of architecture and operational mechanism of CRS,
o
GNS, GPNP.
Configured SCAN as a cluster alias for load balancing and as a client connection
o
failover mechanism
Upgraded Golden Gate from 11.2 to 12.1.2.1.0
o
Used Oracle Golden Gate for Basic and Advanced Data Replication between
o
Oracle Database Servers and Legacy Databases
PerformedHistory pull to synch-up data between Oracle to Non-
o
Oracle(Tandem, SQL Server) databases using Golden Gate
Responsible in setting up DDL/Bi-directional replication
o
Storage Migration: Migrated OCR, VD and ASM data from one SAN storage
o
array to another
Built Oracle MAA Physical Standby and Logical Standby and configure Data
o
Guard Broker for High Availability/Disaster Recovery purpose.
High Level Evaluation and Performance Tuning, Load Balance and TAF Failover.
o
DR Exercise: Perform planned switchover and failover to physical standby
o
database with and without Data Guard Broker and SRDF Failovers to ensure high
availability.
Extensively usedOracle 11gR2 features - Real Application Testing, automatic
o
SGA tuning, enhanced RMAN with Flash Recovery Area, Block Change Tracking,
Merge backup, Oracle Data Pump, big file tablespaces, new EM Grid Control, Database
Control, Studio Control, AWR, ADDM, SQL Tuning/Access Advisors, SQL
Performance Analyzer, Database Replay, SQL Plan Management, SQL tuning
Automation, Flashback Database, compression techniques and several others
Performance Tuning of Oracle Database Objects using tools like EXPLAIN
o
PLAN, SQL*TRACE, TKPROF, STATSPACK for optimized results
Rebuilding of Indexes for better performance, maintenance of Oracle Database,
o
Creating and Managing Tablespaces with different block-sizes to prevent row chaining.
Write and automate UNIX shell, SQL scripts, and Grid Control for ease in
o
administrative tasks and monitor databases to optimize performance, resource use, and
physical implementations of databases
WrotePL/SQL procedures, packages, SQL triggers for code deployment on non-
o
production and production environments
Installing and configuring Recovery Manager (RMAN) efficient backup strategy
o
to disks and tapes using best business practices
Setting and Installing Oracle 11g Enterprise Manager (OEM).
o
Setting up new Development & Production environments.
o
Generated scripts for daily maintenance activity like analyzing the
o
tables/indexes, and monitoring their growth rate.
Automation of Startup Shutdown on all Production and Development Database
o
Worked on Capacity Planning, Space Management, Security Management,
o
Auditing, Shell scripting, Memory and Tuning.
Working with Application Development team to address any issues they
o
encounter and provide support and resolution action plan.
Resolve lock/latch and resource contention issues during production hours
o
Addressing and supporting both Test and Development tickets in co-ordination
o
with Application Development Team
Environment: Oracle11g/12c with RAC, Oracle Golden Gate, Oracle Data Guard, HP-
UX 11i v3, Sun Solaris 10, RHEL 6.x, TOAD, SUSE 10,11.
Oracle DBA (Oracle DBA-Senior Oracle Database Administrator)
Inovalon Inc - Herndon, VA March 2011 to Oct
2012
Responsibilities:
Oracle MAA: Installed, Configured, Setup, Maintained and Supported Oracle
o
10gR1, 10gR2, 11gR1, 11gR2 RAC with ASM, Physical and Logical Standby database
for Test, Development and Production
Involved in 24x7 on-call support for production 10g and 11g RAC database using
o
Oracle Enterprise Manager Grid Control Alert Monitoring and Notification System
Install, configure and support Oracle Databases for SAP Applications like MDM,
o
BW, EP
Upgrade Oracle Databases and Client software for SAP Applications from 10gR2,
o
11gR2, applying SBPs and using BR*Tools for administration
Addressing and supporting both Test and Development tickets in co-ordination
o
with Application Development Team
Upgrading of Database from 10.2.0.5 to 11.2.0.1
o
Apply Patch set update to 11.2.0.2
o
Upgraded Golden Gate from v10.4 to v11.1
o
Installed, Setup, Configured Oracle version 11g Release2 64 Bit on SLES 10
o
Migrating from Oracle 10g Sun Solaris 10 to Oracle 11g SUSE Linux (SLES) 10
o
Supported 15 Terabyte Oracle Data Warehouse (Oracle 10g). Used Sybase
o
Power Designer for development and support of Data Warehouse
Built Oracle MAA Physical Standby and Logical Standby and configure Data
o
Guard Broker for High Availability/Disaster Recovery purpose
Perform planned switchover and failover to physical standby database with and
o
without Data Guard Broker to verify availability status
Extensively used Oracle 11gR2 features automatic SGA tuning, enhanced
o
RMAN with Flash Recovery Area, Block Change Tracking, Merge backup, Oracle Data
Pump, big file tablespaces, new EM Grid Control, Database Control, Studio Control,
AWR, ADDM, SQL Tuning/Access Advisors, Flashback Database and several others
Monitoring and Troubleshooting of Database Replication issues
o
Performance Tuning of Oracle Database Objects using tools like EXPLAIN
o
PLAN, SQL*TRACE, TKPROF, STATSPACK for optimized results
Working with Application Development team to address any issues they encounter
o
and provide support and resolution action plan
Resolve lock/latch and resource contention issues during production hours
o
Performed database Cloning to setup test and development database
o
Rebuilding of Indexes for better performance, maintenance of Oracle Database
o
Creating and Managing Tablespaces with different block-sizes to prevent row
o
chaining.
Wrote UNIX shell scripting to automate tasks and crontab and
o
dbms_scheduler for scheduling job
Write SQL scripts to monitor table space and extent growth
o
Applying Critical Patch Update (CPUs) every quarter in rolling mode with no
o
downtime
Data refresh from production to test and development
o
Installing and configuring Recovery Manager (RMAN) efficient backup
o
strategy to disks and tapes using best business practices
Setting and Installing Oracle Enterprise Manager (OEM) and Enterprise Backup
o
Utility
Setting up new Development & Production environments.
o
Generated scripts for daily maintenance activity like analyzing the tables/indexes,
o
and monitoring their growth rate
Automation of Startup Shutdown on all Production and Development Database
o
SQL Tuning for Performance of Objects
o
Environment: Oracle 10g /11gR1/11gR2 with RAC, Oracle Golden Gate, Oracle Data
Guard, HP-UX 11, Sun Solaris 10, RHEL 5.x, TOAD, SUSE 9,10
Oracle DBA (Oracle DBA-Senior Oracle Database Administrator)
Aviva, IO Nov 2009 to Feb
2011
Responsibilities:
Involved in 24x7 support for production RAC and Non RAC database with on-
o
call pager
Worked with Application Development team on Test and Production tickets
o
Setting up 9i Oracle Parallel server and 10g RAC for Development and
o
Production Environment
Installation and creation of 9i and 10g databases on Testing Environment.
o
Installed, Setup, Configured Oracle 10.2.0.4 64 Bit on RHEL 4.8
o
Upgrading of Database from 9i to10g
o
Installed, Configured, Setup, Maintenance and Supported Oracle 10g RAC,
o
Physical Standby database
Installed, Configured and setup Oracle Streams between Oracle Servers
o
Used Oracle Streams for Basic and Advanced Data Replication between Oracle
o
Database Servers and Legacy Databases
Used Oracle 10gR2 features viz Oracle 10g Real Application Clusters (RAC),
o
Data Guard, Oracle Streams / Replication, automatic SGA tuning, enhanced RMAN with
flash recovery area, Oracle data pump, big file table spaces, new EM Grid Control,
Database Control, Studio Control, AWR, ADDM, SQL Tuning/ Access Advisors, Flash
Back Database and several others
Monitoring and Troubleshooting of Database Replication issues
o
Performance Tuning of Oracle Database Objects
o
Implemented DATA GUARD (Standby) for high availability/disaster recovery
o
purpose
Performed database Cloning to setup test and development database
o
Rebuilding of Indexes for better performance, administer database objects
o
Creating and Managing Tablespaces with different block-sizes to prevent row
o
chaining
Write SQL scripts to monitor table space and extent growth
o
Performance tuning for optimized results using tools like EXPLAIN PLAN,
o
SQL*TRACE, TKPROF, STATSPACK
Applying patches whenever required
o
Data refresh from production to test and development
o
Was involved in developing a Disaster Recovery (DR) plan & implemented a DR
o
exercise
Installing and configuring Recovery Manager (RMAN)
o
Setting and Installing Oracle Enterprise Manager (OEM) and Enterprise Backup
o
Utility
Setting up new Development & Production environments.
o
Generated scripts for daily maintenance activity like analyzing the tables/indexes,
o
and monitoring their growth rate
Automation of Startup Shutdown on all Production and Development Database
o
SQL Tuning for Performance of Objects
o
Providing Solutions to the Problem Faced by end Users Or Programmers
o
Oracle DBA (Oracle DBA-Senior Oracle Database Administrator)
ICICI Bank - Bangalore, Karnataka June 2006 to Aug
2009
Responsibilities:
Installation of oracle 9i & 10g databases in production, development and test
o
environments depending on project requirements.
Refreshing development/test database from production using Export/Import
o
&RMAN backups.
Making structural changes to the databases. Sizing database objects for effective
o
space management and optimal performance.
Managing database security.
o
Creating and assigning appropriate roles and privileges to users depending on the
o
user activity.
Defragmentation of tables and indexes for improved performance and effective
o
space management.
All Database Maintenance Activities to achieve optimum database uptime.
o
Configuration of Listener and Tnsnames.
o
Doing the regular activities like monitoring the alert logs, redo log status, listener.
o
Log and checking the space for normal segments, rollback segments and tablespaces.
Created database link between two databases to access the table data from one
o
local database to remote database using distributed database feature.
Planned database backups (operating system, full/partial backups, and
o
export/import) using various types of backups and designed the backup methodology for
the organization.
Performed other Oracle DBA responsibilities performance tuning, monitoring
o
tablespaces, monitoring users, etc. as well as much problem solving.
Designed Logical and physical database for business transaction functionality.
o
Provide production support for the deployed project till it is stabilized.
o
Written SQL scripts to create database objects like tables, views and sequences.
o
Created procedures and functions using PL/SQL.
o
Preparation of High Level & Low Level Design documents
o
Contact this candidate