Oracle Management
Resume:
SREE INFOTECH, LLC.
******@**********.***
Phone: 972-***-****
YOGANAND
Professional Summary:
Experienced professional with over 8 years of experience in Oracle Database
Administration in very large Production, test and development environments
in diversified domains, on various versions of UNIX/LINUX and Windows
operating systems.
. Oracle DBA proficiency in installation, upgrading, patching,
administration of multiple Oracle Enterprise Edition 9i, 10g, 11g
databases running on Red Hat Enterprise Linux, Sun Solaris, HP-UX,
IBM-AIX and Windows.
. Good experience in installation, configuration and administration
of Oracle 11g RAC, 10g RAC, Standby Databases for High Availability
and Disaster Recovery purpose.
. Exceptional Knowledge of various states of Software Development
Life Cycle (SDLC) i.e. System Analysis, Applications Design,
Development, Integration & System Testing Support of Oracle 8i,9i,
10g, 11g in Production, Staging, and Development environments.
. Developed backup and recovery policy and used new
features/technologies to optimize system maintenance and extensive
knowledge on Partitions and Oracle Streams.
. Proficient in implementation, maintenance of Database Security
(Users, Roles, Privileges), space management of logical structures
(i.e. table spaces, rollback segments) and auditingof users.
. Proficient in using Oracle utilities i.e export/import Data
Pump,Flash Back Recovery, SQL Loader, Data Guard, ASM and OEM.
. Expert in effective troubleshooting of production, development
database environments on daily basis with Proactive performance
monitoring for better performance in applications database using
AWR and Oracle Enterprise Manager (OEM).
. Experienced in performance tuning of various aspects of the
database by using oracle utilities like TKPROF, EXPLAIN PLAN, STATS
PACK, SQL_TRACE,TOAD and Automatic Database Diagnostic Monitor
(ADDM).
. Expert in Optimization of SQL queries, PL/SQL,Stored Procedures,
Functions, Database Triggers and Shell scriptingandworked with the
users to meet business requirements
. Extensive experience in designing, tuning and managing
. Strong ability to script the database models into SQL to create the
database objects including tables, views, triggers, indexes,
foreign keys and sequence counters.
. Working and installation of Real Application Testing(RAT) to bring
back the database in normal state
. Performed and monitored Hot and cold database backups and
implemented backup and recovery using RMAN and Knowledge of storage
technologies SAN, NAS
Technical Skills:
Databases :Oracle 11g R2RAC, 10gR2RAC, 9i, 8i, 7.x, MS SQL Server
2005/2008.
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
Tuning Tools :TKPROF, EXPLAIN PLAN, STATSPACK, AWR, ADDM
ETL Tools : Informatica 5.1, Cognos,Business objects.
Other : EMC, Net App, VERITAS
Education: Bachelor of Technology in Computer Science & Engineering from
JNTU.
Professional Experience:
Citi Group, Dallas,TX
Oct 09 -
Present
Sr. Oracle DBA
Responsibilities:
. Database Administration support (24x7) for large mission critical
production databases
. Database Security Management involving managing Users, Roles and
Privileges Expert in troubleshooting problems
. Installation, configuration and administration of Oracle 11g RAC, 10g
RAC, Standby Databases for High Availability and Disaster Recovery
purpose.
. Space management of logical structures (i.e. table spaces, rollback
segments) and auditingof users
. Optimization of SQL queries, PL/SQL,Stored Procedures, Functions,
Database Triggers and Shell scriptingandworked with the users to meet
business requirements.
. Responsible for Upgrading the Database from 9i to 10g, 9i, 10g to 11g.
. Responsible for SQL query tuning, optimization. Performance tuning
using tools such as SQLTRACE, Tkprof, STATSPACK, Explain Plan, AWR and
ADDM.
. Automatic Health Monitoring, security, SQL Performance Analyzer.
. Responsible for using Flashback query mechanism along with automatic
undo management.
. Refresh/Cloning of Database from production environment to test
environment and application of patches.Security Patches downloaded
from Metalink.
. Loading Data using import/export, DataPump and SQL loader utilities.
. Responsible for automation of startup, shutdown, cloning and backup
. Administration, Optimization, Monitoring, Tuning of Oracle Databases.
. Knowledge of storage technologies SAN, NAS andGolden Gate Replication.
. Table Space management, Database Refreshes, and User Administration..
. Involved in scheduling transaction log backups and notifications.
. Involved in export and import of database objects in order to copy
them from one database to another & copying the export dump file to
tape.
. Proficient in using Oracle utilities i.e. export/import, Data Pump,
Flash Back Recovery, SQL Loader, Data Guard, ASMand OEM.
. Performed and monitored Hot and cold database backups and implemented
recovery scenarios.
. Responsible for monitoring and administration of RAC environment.
. Implemented RMAN incremental backups.
. Responsible for continuous Monitoring of CPU usage, I/O contention,
memory paging and identify the resource and performance bottleneck and
reorganization for ensuring performance.
. Responsible for all database activities such as space management,
database security management, rollback segments & creation of DB links
between two oracle servers.
Environments: Oracle 11g RAC, 10g RAC/9i, IBM AIX, HP-UX, RedHat Linux,
Sun Solaris, Windows XP, SQL*Plus, SQL*Loader, PL/SQL Developer,
Import/Export, Data Pump, TOAD, Oracle Data Guard.
FedEx, Memphis, TN May 08 - Sep 09
Oracle DBA
Responsibilities:
. Database Administration support (24x7) for large mission critical
production databases
. Installation, configuration and administration of Oracle 11g RAC, 10g
RAC, Standby Databases for High Availability and Disaster Recovery
purpose.
. Responsible for Creation and maintenance tablespaces,datafiles,redo
logfiles and renaming/relocating of data files on servers based on OFA
model.
. Oracle 10g & 11g Databases maintenance and troubleshooting.
. Upgraded from 9i to 10g, 10g to 11g database and applied critical
patches update (CPU) for latest versions.Good experience in managing
Very Large OLTP and Datawarehousing databases.
. Database Security Management involving managing Users, Roles and
Privileges
. Involved in setting up, maintenance of Standby Database with Data
Guard for Disaster recovery.
. Cloning of database for development and test environments.
. Proficient in using Oracle utilities i.e. export/import, Data Pump,
Flash Back Recovery, SQL Loader, Data Guard, ASM and OEM
. Table Space management, Database Refreshes, and User Administration
. Responsible for implementing backup procedures using RMAN. Responsible
for creating RMAN catalog Database and Registering the Databases in
Catalog Database. Implemented strong backup and recovery strategies
and monitored backups.
. Performance tuning using SQL Trace, TKPROF, EXPLAIN PLAN, AWR, ADDM
for Monitoring queries with high response time, high disk read per
execution (Top SQLs).
. Managed Oracle Net Configuration, monitoring Alert Log Files, Listener
Log and trace files of databases.
. Involved in checking and managing table space growth, monitoring the
data file growth and extents.
. Written PL/SQL,Stored Procedures, Packages, Functions, Database
Triggers and Shell scripting.
Environments: Oracle 9i,10gRAC&11gRAC,Sun Solaris,HP-UX, RHEL, Windows
2000/XP, RMAN, TOAD, DataPump, TKPROF, EXPLAIN PLAN, STATSPACK, AWR, ADDM.
WellsFargo, San Francisco, CA Nov 06
- Apr 08
Oracle DBA
Responsibilities:
. Installation and configuration of Oracle 9i & 10gRAC database and
Performed DBA tasks
. Supporting large mission critical databases in a 24x7 environment.
. Migration of database from Oracle 9i to Oracle 10g.
. Working with database Monitoring and Tuning. Lead efforts to
develop and improve procedures for automating monitoring.
. Integrated the Backup status reporting for the entire database in
the enterprise to enable the web reporting using Oracle SQL, PL/SQL
and korn shells, Unix shell Scripting.
. Cloning of databases from production to development and test
databases
. Used RMAN for Backup & Recovery.
. Performance Tuning of application by identifying the SQL, which are
not written well, providing inputs to the application programmer,
correcting and implementing the right components
. Reviewing performance stats and recommended changes for tuning SQL
queries, database, server, and storage configurations.
. Participating in periodic backup audits, including test restores
ensuring all databases and associated logs are being backed-up
. Actively involved in Backup Management of Disaster Crash recovery
supporting 24-7 assurance.
. Performing day-to day DBA activities like Patching, Performance
Tuning, Space Management, Backup and Recovery, Users and Security
Management, Query Optimization, testing, implementation and Shell
scripting.
. Coordinate interaction with vendors in critical database problem
situations.
. Submitting Tickets using remedy communicating with other groups
like UNIX, Configuration Team.
. Oracle utilities i.e. export/import Data Pump, Flash Back Recovery,
SQL Loader, Data Guard, ASM and OEM.
. Actively involved in Backup Management of Disaster Crash recovery
supporting 24-7 assurance.
Environment:Oracle 10g RAC/9i, Sun Solaris, AIX, PL/SQL, Oracle Streams,
DATAGUARD, Import Export, TOAD, OLTP, LDAP, RMAN, Remedy, Shell Script.
Prudential Insurance, Iselin, NJ Jan 06
- Oct 06
Oracle DBA
Responsibilities:
. Part of INM DBA Support team for the Production/UAT databases
pertaining to various entities of the HSBC Group.
. 24x7 support for Critical Applications on Global Banking and Check
Transaction System.
. Installed and Configured Oracle 9i/10g on different operationg
systems.
. Performed Backup and Recovery using RMAN.
. Worked as Production Support for Oracle based systems and Unix
based Server environments.
. Managed Users access control and security by creating appropriate
roles and profiles.
. Involved in designing and creating the Oracle 9i database.
. Enforced security by creating roles, giving grants on the tables,
stored procedures, and other database objects depending on role.
. Implemented automated backup strategy using the UNIX shell script
and CRON Utility.
. Used SQL*Loader to load data from flat files to Oracle database.
. Created database links for data transfer to support distributed
transactions.
. Migration of database from Oracle 9i to Oracle 10g.
. Actively involved in Backup Management of Disaster Crash recovery
supporting 24-7 assurance.
. DBA activities including creation, management, startup and shutdown
of Oracle databases, management of data files, redo log files,
control files, tablespaces, segments, extents and data blocks &
physical storage, creation, monitoring and management of database
users, granting/revoking of system/object privileges, management of
roles & resources and setting of init.ora parameters.
Environments: Oracle 9i, 10g, HP-UX, RedHat Linux, RMAN, TOAD, Data Pump,
EXPLAIN PLAN,STATSPACK, TKPROF.
ICICI Bank, Bangalore, India
Jun 04 - Dec 05
Oracle DBA
Responsibilities:
. Responsible for installation, Maintenance, Backup, Recovery of Oracle
9i database on Sun Solaris and setting up and maintaining user
accounts and profiles
. Ensured proper online and off line Backups on scheduled time and
Monitoring Scheduled Backups.
. Creating and dropping of users, granting and revoking privileges when
required.
. Involved in Database logical Designing (Table spaces and Rollback
Segments).
. Monitoring of database objects like rollback segments, temp segments
and table spaces.
. Performed Backup and Recovery using RMAN.
. Storage and space management including table space growth, monitoring
data files additions, extent growth
. Constantly monitor the performance of the Databases by viewing Alert
log files & Trace files.
. Monitoring of database for growth, data fragmentation and correcting
them for better performance
. Partitioned large tables to increase the performance.
. Defined backup procedures using daily hot backups and weekly cold
backup.
. Using TKPROF, EXPLAIN PLAN for the better performance tuning.
Environments: Oracle 9i, SQL, PL/SQL, Sun Solaris, TKPROF, EXPLAIN PLAN,
STATSPACK.
Reliance Communications, Hyderabad, India
Jun 03 - May 04
Oracle DBA/Developer
Responsibilities:
. Involved in 24x7 production database maintenance and on-call
support.
. Responsible for administering and supporting production and
development Oracle 8i databases. Migrated production and
development environments from Oracle 8i to Oracle 9i environment.
. Responsible for installing, upgrade and configuring the Oracle
server, creating databases, storage structures and objects;
database backup and recovery, monitoring and optimizing database
performance.
. Designed backup and recovery procedures for OLTP system. Conducted
periodic cold and hot backups. Data Pump Utilities to move the data
between different databases and for backups
. Instance cloning done to create test and training environments.
. Created PL/SQL procedures (jobs) to automate maintenance tasks.
. Partitioned large tables to increase the performance.
. Configured scripts to monitor activity with database.
. Generated scripts for daily maintenance activity like analyzing the
tables/indexes, and monitoring their growth rate.
. Developed PL/SQL Functions, Procedures, Packages and Triggers.
. Created tables, indexes, synonyms, views, database links,
tablespaces
. Worked on re-organization of tables.
Environment: SQL*Loader, SQL*Plus, Shell Scripting, Windows-NT, HP-UX,
Oracle 9i/8i. EDUCATION
Contact this candidate