Oracle Sql
Resume:
AnilKumar Gunda
*****.****@*****.***
PROFESSIONAL SUMMARY
o Over 7+ years of professional experience in Oracle Database
administration
o Expert in areas of Oracle 11g/10g/9i/8i, PL/SQL, SQL, SQL*Plus,
SQL*Loader.
o Experience with Building RAC, Data Guard, ASM, Flashback and RMAN
o Experience in Various Flavors of UNIX - Linux, Sun Solaris, HP-Unix and
IBM - AIX.
o Implemented 10g RAC with ASM file system using Oracle clusterware.
o RAC Environment: 3 Node RAC on Oracle Enterprise Linux 5 with 10g rdbms
using ASM file system with 5 disk groups and Oracle clusterware.
o Configured TAF / FAN / Load Balancing (Client / Server side) also
Application Partition for better performance for cluster databases.
o Implemented Data guard (Physical Standby) for RAC databases.
o Participated in DR exercise for the last 3 quarters.
o Migrated Non ASM databases to ASM.
o Experience with High Availability features ( RAC/ DG/ ASM / Flashback /
RMAN)
o Implemented uni-directional table level replication using Oracle Streams.
o Upgraded 10g databases and clients to 11g.
o Good knowledge of 11g new features.
o Experienced in Oracle installations, up grades, migration, designing
logical/physical architecture, SQL*Net, Tuning, Capacity planning,
database access and Security and auditing.
o Troubleshooting of Performance and Tuning problems in Oracle database
using tools like AWR, ADDM, Statspack, OEM Grid Control and manual
scripts.
o Refresh and Cloning using Datapump and RMAN with Commvault, VERITAS Net
Backup & TSM.
o Expertise in Maintenance, Patching, Cloning and troubleshooting.
o Excellent knowledge in User Managed / RMAN backups and Recovery.
o Experienced in Database Point in Time Recovery and Tablespace Point in
Time recovery.
o Enforcing security by creating roles, granting system and object
privileges on the Tables, and stored procedures with DBA concepts.
o Good understanding of oracle Data Dictionary and Normalization
Techniques.
o Created and modified Database objects like Tables, Indexes, Views,
Sequences, Functions, Procedures, Triggers, Stored Procedures and
Packages.
o Experience in Working with Oracle Support to resolve issues and open TAR
/ SR
o Enforcing data integrity using integrity constraints & database triggers.
o Good experience in SQL, PL/SQL, Shell Scripting, Perl Scripting,
Partitioning, Data modeling, OLAP, Logical and Physical Database Design,
Backup and Recovery procedures.
o Excellent Analytical, Communication and Presentation skills.
o 24x7 support provided during on-call schedules.
TECHNICAL SKILLS
Languages : PL/SQL, SQL, SQL*PLUS, C, Java, Shell Scripting
Database : Oracle 11g/10g/9i/8.x, MS Access
Operating System : UNIX, Solaris, AIX, HP-Unix, Linux, Windows
2005/2003/XP/2000/NT
Tools : SQL*PLUS, SQL Developer, TOAD, Sql Navigator,
PUTTY, OEM, RMAN, SQL* LOADER, Imp/Exp and
Data pump, Aqua Data Studio 4.7, Humming Bird
Connectivity, Cygwin -X.
Other Technologies : ODBC, Crystal Reports, MS Office, SFDM, Erwin
4.0/4.2/7.6, Relational Database
Design.
PROFESSIONAL EXPERIENCE
American Express, Plantation, FL
Sep 09 -Till date
Role: Oracle DBA
Environment :
Oracle 10g/11g, SQL,PL/SQL, SQL*PLUS, EXPDP/IMPDP, OEM, RMAN, Cygwin -X,
Linux, Windows, Data guard, Toad 10.1, Aqua Data Studio 4.7,SQL Server
Management Studio.
Responsibilities:-
> Implemented and configured 10g RAC with ASM file system using Oracle
clusterware.
> Configured TAF / FAN / Load Balancing (Client / Server side) also
Application Partition for better performance for cluster databases
> Migrated NON ASM databases to ASM databases.
> Maintained Data Guard to ensure high availability, data protection and
disaster recovery for enterprise data.
> Created Streams environment in unidirectional and table level for
replication of data.
> configured and used Oracle FlashBack for minor recovery of objects in the
database.
> Installed and configured OEM Grid control and intensively used Diagnostic
& tuning packs along with AWR & ADDM reports.
> Implemented Oracle Backup and recovery procedures using RMAN &
Import/Export.
> Configured RMAN backups for TSM and Commvault and also resolved backup
issues.
> Restoring Database's from Backups on testing environments.
> Effectively uses database replication, security and availability
solutions.
> Upgrade and Migration of Database's from 10.2.0.5 to 11.2.0.2 and
applying patches whenever required.
> Applying Quarterly patches and CPU,PSU,One-Off Patches to upadate Oracle
version and to fix the bugs using Opatch utility.
> Configured Alerts from O.E.M by creating rules.
> Effectively uses platform-specific, as well as enterprise, monitoring
tools to provide fault and pre-fault performance notifications.
> Provides platform-specific performance tuning, installation and
configuration.
> Monitors and manages back-up and recovery as well as capacity planning
for all Database platforms
> Works with management, peers and vendors to design and implement
hardware/software configurations, logical models, operational management
models and business continuity plans for systems under management.
> Works with management, peers and vendors to provide ongoing monitoring,
performance tuning, implementation and fault root cause analysis.
> Creates design, troubleshooting and operational documentation for all
systems under management.
> Authors and peer-reviews knowledgebase articles documenting fault root
causes and their respective resolutions.
> Provides and receives cross-discipline training in order to ensure
maximum availability of systems under management.
> Carries and responds to off-hours communications device in order to
provide 24x7 support.
> Actively pursues opportunities, as an individual and as part of a group,
to improve knowledge, tools and processes.
> Performance Tuning of Databases, Oracle instances, and Applications.
Finding Performance bottlenecks using STATSPACK,
UTLBSTAT,UTLESTAT,ESTIMATE,ASH,ANALYSE, EXPLAINPLAN, SQLTRACE and TKPROF
> Worked on Instance Tuning, Memory Tuning and SQL Tuning.
> Performed database Point in Time Recovery and Table Space Point in Time
Recovery using Transportable TableSpaces.
Fannie Mae, Dallas TX
Jul 07 - Aug 09
Role: Oracle DBA
Environment
Oracle 11g/10g, SQL, PL/SQL, SQL*PLUS, EXPDP/IMPDP, OEM, Toad 9.0, RMAN,
DBCA, Erwin,
Linux, Windows.
Responsibilities:-
> Successfully Maintained RAC environments of 3Nodes with ASM file system
using cluster ware.
> Involved in Design and implementation of oracle 10g Data Guard both
physical/logical standby databases for high availability and disaster
recovery.
> Implemented Oracle streams for replication and configured tablespaces for
streams administration at database and table level.
> Configuring and using Oracle Log miner and Oracle Flash Back for
recovery of the objects.
> Upgrade and Migration of Database's from 10.2.0.4 to 11.1.0.6 and
applying patches whenever required.
> Installed and controlled Grid Control to monitor RAC and Non RAC
instances patched and upgraded the grid control
> Monitored Production Database Using O.E.M and Toad DBA Monitor tools.
> Recovering the database from any kind of crash with the minimum data
loss.
> Database Recovery (both complete and incomplete) from different types of
failure.
> Used RMAN for backup and recovery. Performed backup validations using
RMAN.
> Responsible for maintaining Every Day Backups and also to maintain ASM
and Disk Space.
> Performed Database Point in Time Recovery and Table Space Point in Time
Recovery with the use of Transportable Table space.
> Applying patches quarterly (PSU,CPU,ONE-OFF) for security and to fix the
bugs.
> Responsible for supporting the Oracle databases and ensuring their
Performance, Availability and Security.
> Planning the size of the Database, Creation of Database and location of
initial data files, redo log files and multiplexing them, editing
database initialization parameter file whenever required.
> Implementation and release of Database changes as submitted by the
development team.
> Create Production Support databases for testing every Week for developers
using Data pump Impdp from Production Backups.
> Maintaining all database objects including Schemas, Tables, Indexes,
Triggers, Sequences, Primary and Foreign keys, Views, and all
Constraints.
> Performance Tuning of Databases, Oracle instances, and Applications.
Finding Performance bottlenecks using STATSPACK, UTLBSTAT, UTLESTAT,
ESTIMATE, ANALYSE, ADDM,AWR,EXPLAINPLAN, SQLTRACE and TKPROF.
> Maintaining Erwin for all the new database changes Implemented during
each release.
> Responsible for the Database Builds on Test, Development databases and
Monitor Production database during builds.
> Worked with cross-functional team of marketing team, engineers, and
production planners to understand business process and develop functional
specifications.
> Written Shell scripts to Monitor activates like availability of Database
& Listeners, Space utilization, Gathering statistic for the cost base
optimizer, Index rebuilding .
> Good exposure to oracle technologies like AWR, ASM, Flashback and Data
Pump Import/Export.
> Worked on External tables for Loading Flat files into Database and also
created flat files of existing tables for loading into different
environment.
> Used DBCA for Creating, configuring and Deleting Databases.
> Provided 24x7 support for Production, Development, and test database.
Godrej Industries Ltd,Mumbai
Sep 05 - May 07
Role: Oracle DBA
Environmen
Oracle 9i/10g, OEM Grid Control, RMAN, RAC, Imp/Exp, Data Guard, SQL,
PL/SQL, SQL*PLUS, Perl, Shell Scripting, HP-UX PA RISC.
Responsibilities:-
> Migration of all Oracle 9i databases/clients to 10g.
> Applying Quarterly patches and Version change patch bundles.
> Implemented backup and recovery procedures using RMAN & Import/Export.
> Configuring Data Guard to ensure high availability, data protection and
disaster recovery for enterprise data.
> Performance Tuning of Databases, Oracle instances, and Applications.
Finding Performance bottlenecks using STATSPACK, UTLBSTAT, UTLESTAT,
ESTIMATE, ANALYSE, EXPLAINPLAN, SQLTRACE and TKPROF.
> Installation and supporting RAC.
> Worked on Instance Tuning, Memory Tuning and SQL Tuning.
> Written Shell scripts to Monitor activities like availability of database
& listeners, space utilization, gathering statistic for the cost base
optimizer, index rebuilding.
> Good exposure to oracle technologies like AWR,ASM,Flashback and data
pump import/export
> Installed and configured OEM Grid control and intensively used Diagnostic
& tuning packs along with AWR & ADDM reports.
> Written Shell scripts to Monitor activates like availability of database
& listeners, space utilization, gathering statistic for the cost base
optimizer, index rebuilding etc.
> Building and Configuring RMAN with Netback up, Legato Backup & HP Data
Protector.
> Successfully providing 24x7 support for production, development, and test
database.
> As part of a pilot project to transfer the database administrative
activity to overseas, I have documented and coordinated with the people
overseas
> Performance Tuning of Databases, Oracle instances, and Applications.
Finding Performance bottlenecks using STATSPACK, UTLBSTAT, UTLESTAT,
ESTIMATE, ANALYSE, EXPLAINPLAN, SQLTRACE, and TKPROF.
> Created users, roles and granted privileges according to the business
requirements.
> Provided 24x7 support for Production, Development, and test database.
Hyderabad chemicals Ltd, Hyderabad.
Feb 04 - Aug 05
Role: Oracle DBA
Environment :
Oracle 9i/8.x, SQL, PL/SQL, SQL*PLUS, SQL*Loader, Import/Export, OEM, RMAN,
Crystal Reports,
Developer/2000, Erwin, Shell Scripting, Solaris, HP-Unix, Windows 2000.
Responsibilities:-
> Responsible for installing Oracle Database, setup Instance Creation,
Database Space Management.
> Installed patches and upgrades for various bugs.
> Implemented traditional Hot and Cold Backups & Recovery.
> Distributed the data in different Tablespaces by table partitioning to
get the high performance and I/O balancing.
> Performance tuning of Database, SQL queries.
> Performed Export/Import and full database scanning.
> Monitoring and resizing tablespace, relocating data files for better disk
I/O.
> Maintained standby databases for production and staging environments.
> Created roles and users and Managed there privileges.
> Responsible for monitoring & resizing Oracle database objects
(Tablespaces, Tables, Indexes etc.)
> Responsible for managing Redo logs, Archive logs, Data files.
> Troubleshooting of the database.
> Documented the problems and solution in the failures of production
databases.
> Responsible for extensive use of SQL, PL/SQL, SQL*PLUS
EDUCATION & CERTIFICATIONS:
V B.Tech COMPUTER SCIENCE & ENGG.
V 10g Oracle Certified Associate (OCA).
Contact this candidate