Manager Oracle
Resume:
M u r a r i Meesala
Oracle DBA
mur a r i.ora83@gmai l.com
Summa ry:
Over 8+ years of experience as an Oracle D atabase Administrator having hands
on experience in d atabase administration and performed different tasks like
i nstallation, configuration, upgrades, patches, pe rformance tuning,
b ackup and recovery, production support, cloning, space management,
d atabase security.
● Experience in Installation, Configuration and Monitoring of Oracle Server on
U N IX, L inux, AIX and Windows Environments.
● Experience in Installation of O racle Real Application Cluster (RAC) w ith ASM
and manage RAC instances using CRSCTL and SRVCTL Utili ty.
● M igrating databases to Oracle Exadata Database Machine for different
c lients
● Analyzing database performance and tuning database on Oracle Exadata
using Real Application Testing (RAT)
● I nstalling, configuring and maintaining Ente rp r ise Manager Cloud
Cont rol to monitor and manage Exadata and regula r databases.
● Configuring and implementing Oracle ASM on U N IX, L inux, and Windows
p latforms.
● Configure high availability systems like Data Guard and R AC environments.
● Installation, Configuration and Maintenance of L ogical/Physical standby
d atabases i n D ataguard.
● Experience in Implementing BACKUP and R ECOVERY s trategies using R MAN .
● Providing DBA support to multiple Cluster, Non Cluster and ASM Database in
p roduction, development and Testing Servers in UN IX, AIX & Windows
E nvironments.
● Installation and configuration of R ecovery Catalog for multiple Databases.
● Experience in taking logical backup of the database using D ATAPU MP
( Expdp/Impdp).
● Experience in O racle Patching for 9i, 10G and 11G.
● Experience in SQL tuning using E xplain Plans, H ints and developing ad-hoc
queries.
● Experience in P erformance T uning for better performance.
● Configuring O racle Golden Gate for replications.
● Configured multiple database instances using a single ASM instance .
● Experience working with I B M-T IVOL I.
● Implemented R MAN backups t hrough T IVOL I.
● Having Experience in MS SQL Server database Administration..
● Generate and interpret A utomatic Workload Repository (AWR), Active Session
H istory (ASH) and A utomatic Database D iagnostic Monitor (ADDM) reports.
● Experience in performing database related activities using O racle Enterp r ise
M anager Grid (OE M Grid) .
● Experience in U N IX Bash Shell Scripting .
Technical Skills:
Databases : Oracle 11gR2, 10g, 9i, SQL Server 2005 and 2008
Oracle P roducts : Oracle10g (Grid Control), OEM (Oracle Enterprise
Manager), RMAN,OEM 12C, SQL* Loader, Import
and Export
(EXPdp/IMPdp), ASM, TKPROF, SRVCTL, SQL*
Loader
A nd SQL * Net.
Operating System : RHEL 4, RHEL 5, OEL 4, WIN
N T/2003/2008, Solaris 10,
H P-UX I tanium, IBM AIX
Languages : SQL, PL/SQL, UN IX Shell Scripting.
O ther Tools : TOAD, Putty, SQL Developer, Erwin.
Client: E MC-PNC, Chicago, I llinois J uly
2013 – Till date
R ole: Oracle DBA
Responsibilities:
● I nstallation, Configuration and maintenance of O racle11g database on UN IX.
● Maintain and followup on Oracle RMAN (Recovery Manager) of hot backup issues
using TSM/Tivoli and Networker/Legato based backup systems.
● Involved in the implementation of New Avamar backup project involving
i nfrastructure and newly developed scripted backup/ restore methods using dynamic
features of the Oracle recovery manager and D ata Boost technologies.
● 24 X 7 P roduction d atabase administration, support and monitoring to
ensure Proactive problem recognition and resolution of database issues.
● Expertise in handling and O racle Ente rp r ise Manager on daily basis observing
t he p erformance of the production database using OE M .
● Configured and installed standalone DR servers on ASM (RAC One Node).
● Applied patches to Oracle Databases using O patch utility and upgraded
databases manually.
● Implemented U p-gradation of databases f rom 10.2.0.x to 11.2.0.x.
● Created databases in R AC envi ronment using DBCA and involved in moving
databases from N ON ASM to ASM environment.
● Involved in m igrating H P-Unix databases from 10g/11g to 11gR2 Red hat-
Linux.
● Involved in configuration of parameter files for extract process i n p r ima ry
and r eplica process i n standby using Golden Gate .
● Installed Golden Gate for replication of d atabase on 11gR2 RAC environment. .
● Implemented D isaster Recovery (DR) and HA using R AC and Data Guard.
● Configured parameters for the B i-di rectional replication using Golden-Gate .
● Extensively implemented and used 11gR2 Data-guard new featu res.
● Implemented D isaster recovery for production databases using D ata guard .
● Have hands on experience in creating p hysical standby databases, and involved in
converting physical to snapshot standby, and also Active Data-guard .
● Configured D ata guard-broker and involved in r egistering of databases in
D ata guard broker using utili ty D G MGR L .
● Involved in creating l isteners and T NS manually in D ata-guard Envi ronment .
● Extensively used d ata-pump at schema level and Database level for moving
d ata f rom Solaris to L inux du r ing migration
● Performed d atabase refresh f rom production to test/dev environment in both R AC
a nd NON RAC environment using R MA N.
● configured and implemented B ackup & Recovery p rocedures using R MAN .
● Performed B lock Recovery, data file recovery a nd T uned R MAN for better
p erformance.
● Troubleshooting R MAN whenever backup is failed and r esolved issues.
● Configured R MA N retention policy, archive log deletion policy for Production
databases.
● Maintained catalog server and registered databases i n catalog server . .
● Involved in Management of schemas, objects par titioning the tables &
i ndexes.
● Performed D atabase refresh using R MAN active cloning and data-pump.
● Responsible for setting and managing user accounts, Granting required privileges
to users.
● Perform other regular D BA activities i ncluding space management and
p erformance marketing.
● Granted and R evoked user privileges and r oles as per requirement and killed
b locking session and performed database refresh from P roduction to test
environment using R MAN cloning and Exports and imports.
● Creating the d atabase, table spaces, tables, indexes, settings privileges and
user logins for prod/dev/test databases and Involved in gathering requi rements
f rom end users.
● Estimated growth of d atabase size by detail analysis of the company's future
policies and generating repor ts for the m anagement to act in advance .
● Performed Oracle Database m onitoring, t roubleshoot and resolved t he issues.
● Extensive Performance Tuning, M emory (SGA) T uning, N et backup, R A I D,
RAW Devices.
● Recovery of D atabase (Recovering from Media Failu re, Recovering tables
d ropped accidentally, Recovering data files, Recovering from Block
Cor ruption ).
● Taking p eriodic Backup of the D atabase and the softwa re using R MAN and
supporting V ER I TAS Net-backup Team.
● Involved in Writing S QL scripts to monitor table space and extent growth.
● Involved in SQL tuning by generating explain plan, ADD M, AWR and TKPROF .
● Involved in P erformance tuning which includes creating indexes, analyze,
explain plan, optimizer hints.
● Provided support to Application Database Administrators i n d esigning the
d atabase.
Environment:Oracle 10g, 11g, SQL, Oracle Grid Control, Oracle Enterprise
M anager, RAC Database Control, TOAD, OEM 12c, ASM, AIX, Goldengate, Tivoli,
Avamar, Data Boost
Client: Avanade, Chicago, I llinois A pr 2013
– J un 2013
R ole: Oracle/MS-SQL DBA
Responsibilities:
● I nstallation, Configuration and maintenance of O racle11g database on UN IX.
● I nstallation, Configuration of MSSQLSERVER 2008 on Windows 2008R2
server.
● I nstallation, Configuration of Oracle Goldengate on UN IX and Windows
2008R2
● I mplemented I n i tail load and Change Data Capture from Oracle 8i to
M SSQLSERVER 2008.
● Responsible for creating a better plan for upgrading oracle forms 6i to updated
versions.
● Involved in requirement gathering meetings, brainstorming sessions and detailed
design meets.
● Worked through all the project life cycle SDLC
Environment : O racle 8i, 11g, SQL, Oracle Enterprise Manager, ASM, AIX,
GoldenGate, MSSQL server 2008, Oracle forms/reports 6i, TOAD, OEM 12c,
ASM, AIX, Goldengate, Tivoli
Client: E nterprise, St.Louis, Missouri Nov 2012
– A pr 2013
R ole: Oracle DBA
Responsibilities:
● I nstallation, configuration and maintenance of O racle 10g and 11g database
on AIX.
● Monitoring Day-to-Day Backups, Log’s & recovering t hem as per the
requirement.
● Successfully implemented B ackup & Recovery using R MA N, Hot and Cold
b ackups.
● Taking the R MAN incremental and cumulative backups.
● Scheduling the databases backup using C ron tab.
● Implemented D ata Guard w ith m aximum availability, protection and
p erformance configurations and worked with D ata Guard Fail over and
S witch over cases.
● Monitoring the O racle I nstances, Users, Tables, Tablespaces, Memory
structu res, and Rollback segments, Redo logs, Archived Redo logs and
A lerts.
● Creation of Users and granting them the required R oles and P r ivileges
accordingly.
● Involvement in space management, rectification of lock problems, managed
q uotas.
● Configuration of L istener and Net Service names using N E TCA.
● Created, monitoring database objects like T ables, I ndexes, Views, Users, and
D B Lin ks etc.
● Migrated databases from filesystem to ASM using R MAN .
● Cloned schemas, objects and data on new server using D ata pump .
● Responsible for capacity planning, recovery planning and installing patches
● Conducted t ime to t ime analysis and monitoring of the software and hardware
requirements and act accordingly.
● Configured D atagaurd for disaster recovery purposes.
● Installed 12c agents on hosts and d iscovered ta rgets.
● C reated new G roups, Templates, I ncident Rule sets i n O E M 12C .
● Configured new T h resholds for M et r ics.
● Automated gather stas as a c loud job i n O E M 12c.
● Shell script to a djust dblinks a fter database refresh from prod to dev.
● Shell script to change d b user passwords a fter refresh from prod to dev.
● Designed and tested p atching t hrough O E M 12C.
● Configured and implemented O racle Golden Gate replication.
Environment :Oracle 10g, 11g, SQL, Oracle Grid Control, Oracle Enterprise
M anager Database Control, TOAD, OEM 12c, ASM, AIX, Goldengate, Tivoli
Client: Vanguard, Malvern, PA Jan 2012 – Nov
2012
R ole: Oracle DBA
Responsibilities:
● I nstallation, configuration and maintenance of O racle 10g and 11g database
on OEL.
● Involved in construction of D R sites for all the Production databases.
● Involved with installation and maintenance of O RACLE RAC for high availability.
● Upgraded the O racle 10g database to 11g version and also applied p atch set and
i nter im patches w henever required to make the database software up to date.
● Monitoring Day-to-Day Backups, Log’s & recovering t hem as per the
requirement.
● Successfully implemented B ackup & Recovery using R MA N, Hot and Cold
b ackups.
● Taking the R MAN incremental and cumulative backups.
● Scheduling the databases backup using C ron tab and VER I TAS net backup.
● Extensive experience in R MAN recovery in RAC and stand alone database.
● Created a C lone Database using R MAN on remote Server and used S RVCTL
commands for Real Application Cluster (RAC) Databases.
● Implemented D ata Guard w ith m aximum availability, protection and
p erformance configurations and worked with D ata Guard Fail over and
S witch over cases a t the times of up gradation and migration.
● Monitoring the O racle I nstances, Users, Tables, Tablespaces, Memory
structu res, and Rollback segments, Redo logs, Archived Redo logs and
A lerts.
● Creation of Users and granting them the required R oles and P r ivileges
accordingly.
● Involvement in space management, rectification of lock problems, managed
q uotas.
● Configuration of L istener and Net Service names using N E TCA.
● Created, monitoring database objects like T ables, I ndexes, Views, Users, and
D B Lin ks etc.
● Cloned schemas, objects and data on new server using D ata pump .
● Responsible for capacity planning, recovery planning and installing patches
● Worked extensively on monitoring 10G grid control database, configuration of error
notifications, installing listeners, and adding them to the grid control.
● Conducted t ime to t ime analysis and monitoring of the software and hardware
requirements and act accordingly.
Environment:Oracle 10g, 11g, SQL, Oracle Grid Control, Oracle Enterprise
M anager Database Control, TOAD, SQL Developer, SQL* Loader, Red Hat
E nterprise Linux, ASM.
AAA I nsurance, M t.laurel N J J an 2011– Dec 2011
Role: Oracle DBA
Responsibilities:
● Involved in monitoring the Database related activities using Oracle Enterprise
M anager 11g Grid Control (OE M Grid ) and monitoring the backup jobs scheduled
i n OEM Grid.
● Performed configuration of Oracle ASM on H P-UX, R H E L .
● Performed Installation, Configuration and Monitoring of Oracle 11gR2, 11gR1, 10g
on U N IX, L inux AIX, H P-UX and W indows environments.
● Installed, configured and monitored O racle RAC11gR2 and 10gwith ASM.
● Configured and implemented Oracle 11gR2 Data Guard for Database disaster
recovery.
● Performed oracle Database data refreshes using export/import f rom production to
test Servers.
● Involved in performance tuning by general health checks and maintenance for
Database using AWR and A DD M reports by finding wait events.
● Performed logical backup of the database and Schemas using D ATAPU MP
( Expdp/Impdp ) as per the requirement.
● M igration of databases from MS SQL server 2008 and O racle 11g.
● Involved in implementation and support of 10g and 11g migrations and
u pgrades f rom Oracle 9i and 10g databases on HP-UX and L inux.
● Involved in applying C PU and P SU patches for Oracle Server.
● Involved in wri ting U N IX Shell Scripts for maintains tasks for oracle database.
● Worked on Data modeling Using Oracle SQL Developer Data Modeler.
● Configured and implemented O racle Golden Gate replication.
● Involved in P L SQL programming and Performance tuning for oracle Database by
generating AWR and A DD M r eports
● Performed Database activities using In tegrated Development tools like S QL
D eveloper and T OAD .
Environment:
Oracle 10g/11g, Linux, SQL Server 2008, Oracle Enterprise Manager Database
Control, RDBMS, TOAD, PL/SQL, Shell Scripting, ASM, Data guard.
TCF Bank Wayzata, M N N ov 2008
– D ec 2010
Role: Oracle DBA
Responsibilities:
● Configuration and maintenance of a T wo node RAC on O racle 10g.
● Configuration of ASM w ith n ormal and e xternal redundancy.
● Responsible for p lanning, testing and i mplementing different backup and
r ecovery strategies.
● Responsible for scheduling backups.
● Taking I ncremental backup using R MAN.
● Alert monitoring and T icketing.
● Performing a nalysis and d iagnosis of database performance statistics.
● T uning performance using A dvisors, AWR, ADD M, SQL tuning etc.
● Performing O nline and O ffline backups w ith RMAN as well as User managed.
● I nstallation of O racle 10g on R H E L 4.
● Used S hell Scripting to backup database.
● Physical and logical d ata modeling using E r w in tool.
● Responsible for g ranting required p rivileges and r oles to users.
● T uning SQL queries w hen the performance is poor .
● Restoration of p urged tables using F lashback.
● Implementation of l ogical backups using L og M iner.
● Upgrading databases f rom 10.0.1.0 to 10.0.4.0 using P atch sets.
● Scheduling Oracle Jobs in the database.
● Implemented Point in time recovery using R MA N.
● Responsible for Space m anagement.
● Responsible to provide 24 x 7 database administrative activities over
d ifferent database servers .
Environment:
Oracle 10.2.0.3/11.1.0.6/.7, Linux, Solaris 10,Window 2003, Oracle
E nterprise Manager Database Control, RDBMS, TOAD, PL/SQL, Shell
Scripting, ASM, Data guard.
Cigna Healthcare, Sunrise, F L Nov 2007 -
Oct 2008
Role: Oracle DBA
● In charge of maintaining DPH and EPA Production and Development Oracle
databases.
● Managed and monitored the O racle Real Application Cluster (2 node
R AC)
● Supporting more than 125 production and development databases 10.2.0.4.
● Created and maintained f ailover logical standby database.
● Migrated databases from 10g to 11g using t ransportable table space and data pump.
● Using Oracle D ata-Pump for export and import.
● Involved in m igration of databases from standalone (ASM) to cluster
E nvironment.
● Using Automatic Shared Memory Management ( ASM M) for optimal use of
available SGA memory.
● Maintained catalog server.
● Using SQL Tuning Advisor and SQL Access Advisor to fix the SQL
s tatements.
● Installed and configured O racle Enterp r ise Manager 10g Grid Control.
● Worked on P erformance Tuning Oracle D BA (11g &10g) on Solaris 10,
A IX 5.2.
● Installed and u pgraded O racle 10.2.0.1 database to 10.2.0.4.
● Developed a bunch of I ndex monitoring scripts i n order to sort out the unused
space occupied in table spaces.
● Implemented advanced features of O racle 10g such as A utomatic Database
D iagnostic Monitor ( ADD M), A utomatic Workload Repository (AWR) for
monitoring database performance. Modified and updated the P erformance
t uning scripts.
● Tested database performance issues (monitoring and tuning) to ensure database
optimization.
● Performed T uning, coding and M onitoring for O racle R eal Application
C lusters (RAC) n odes, P roduction Standalone Servers via T oad .
● Creation of materialized views and fine-tuned them for better performance.
● I nvolved i n Oracle Golden Gate configuration and t roubleshooting
● Working Experience with latest T OAD having new features like PLSQL & SQL
Script Debugger, Database Health Checkup, ASM Manager, Diagnose Extents,
Segment Advisor, SGA Trace, Query Builder.
● Tuning SQL statements using E xplain Plan and S TATSPACK .
● Modified SQL*Loader control scripts for example to eliminate spaces
generally used for data loading.
● Created b it-map I ndexes for d ata wa rehouse databases.
● Configured P hysical and L ogical Standby database for reporting
environment.
● Performed administrative maintenance, monitoring on O racle database systems
i n a global 24x7 operational environment.
Environment:
O racle 11g/10g RAC on Solaris/Linux, RMAN, Data Guard, UN IX Shell Scripting,
Quest Performance Analysis, Quest Space Management tool, DB Artisan, Toad,
P L/SQL Developer, OEM, Windows NT/XP.
BSNL Telecommunications, H yderabad, I ndia M ay
2006 – Oct 2007
Role: Oracle DBA
Responsibilities:
● Provide backup/recovery, problem diagnosis, performance tuning, data
reorganization and database upgrade support for approximately 40
O racle databases.
● Installed, configured and maintained O racle 10g R eal Application Cluster
( RAC).
● Installation and maintenance of O racle 10g D ata Guard for Database
D isaster Recovery.
● Involved in backup and recovery using RMAN.
● Providing technical support to Application Support team for performance and
database related issues.
● Performed Logical backup using and full/partial export/import and D ata
P ump .
● Database Restore using R MAN, Cold Backup and Export/ Import.
● Responsible for planning, testing and implementing different b ackup and
r ecovery strategies.
● Creating and managing the database objects such as tables, indexes and
v iews.
● Table Partitioning, creating Index Organized tables, Creating Locally
managed Table spaces.
● Responsible in configuring and backing up database using h ot backups,
Cold backups and L ogical backups.
● M ig ration / Up-gradations of Databases.
● Patched O racle Database Server 10g using O patch .
● Implemented scripts for daily monitoring like d b status, no of extents, free
space etc.
● Upgrading/migrating O racle databases from 8i/9i to 10g.
● Performance tuning on production databases supporting the application
using stats pack/AWR.
● Develop, document, and implement security configuration
for O racle software and database instances to comply with existing standards.
● Refresh development/test databases from copies of production.
● Performance tuning via O E M, STATSPACK/AWR for 9i/10g.
● 24x7 Production-on call supports for all the production databases
w ith O racle 10g/9i.
Environment:
Oracle 10g/9i, SQL, PL/SQL, SQL plus, TOAD, Import/Export Oracle
E nterprise Manager, Windows NT/2000, Sun Solaris 2.5/2.6, Red Hat L inux
2.1
Contact this candidate