Manager Oracle
Resume:
AJAY VARMA ? 415-***-****
Oracle DBA * ************@*****.***
Employment Authorization: U.S. Citizen
EXPERIENCE SUMMARY
Over 4+ years of experience in Installing, Administering, Maintaining,
Migrating, Tuning & Troubleshooting of Oracle Databases on Linux, AIX,
Unix, Solaris & Windows Systems as Oracle DBA on Telecom, Manufacturing &
Financial Projects.
. Expertise in Oracle Database Administration, Database Architecture.
. Strong experience with Oracle 11g/10g/9i/8i Installation,
Configuration, Monitoring, Upgrades, Migrations, Patching, Performance
Tuning, Database Backup & Recovery, Cloning, Space Management,
Troubleshooting, Physical and Logical database design.
. Hands on experience in maintaining high availability of databases for
24/7 global operation using Oracle RAC with ASM and Data Guard/Standby
databases.
. Worked on various Oracle replication solutions like Oracle Data Guard,
Golden Gate, Oracle Streams and Cloning of Database. Proficiency using
Oracle GoldenGate replication, tuning and capacity planning.
. Expertise in Backup and Recovery operations ((Physical, Logical) using
conventional hot & cold backups and RMAN.
. Strong knowledge and experience of managing Oracle 9i,10g and 11g RAC
environments using the OEM Grid Control.
. Good knowledge in logical backups, Hot/Cold Backup and Recovery and
Cloning of databases using RMAN, IBM Tivoli Storage Manager (TSM),
VERITAS Net Backup.
. Supported Production and Development 11g/10g/9i/8i databases in
various platforms including Linux, AIX, Solaris and Windows.
. Proficient in SQL, PL/SQL, and developing various Database objects:
Triggers, Stored procedures, Functions, Sequences, Views, etc.
. Expertise in Oracle Database Performance Tuning & Optimization on
Oracle 9i, 10g &11g.
. Experience in System Management Tools: Oracle Enterprise Manager (OEM), RMAN, ASM, AWR, ADDM, Flash-Back Recovery, Data Pump, Recycle Bin,
Quest Software (TOAD), SQL loader, Data Migrations using
Export/Import, BMC Remedy Tool.
. Experience in implementing 10g/11g Grid monitoring application to
monitor the Oracle Applications and Database.
. Good experience in Shell Scripting, Partitioning, Data modeling,
Logical and Physical Database Design.
. Good experience with OLTP/OLAP/DSS database systems, implementing and
managing large Oracle databases. Loaded data from OLTP systems into
data warehouse databases.
. Expertise in analyzing SQL query and performance tuning using
STATSPACK, EXPLAIN PLAN, SQL TRACE, TKPROF, AWR and ADDM reports.
. Excellent experience in cloning oracle databases for development and
testing.
. Good experience in resolving the issues related to installation,
upgrades and patches.
. Proficient in recovery of Databases (Recovering from Media Failure,
Recovering tables dropped accidentally, Recovering data files,
Recovering from Block Corruption etc.).
. Expertise in creating and scheduling jobs through OEM.
. Proficient with 11g new features: Active Datagaurd, configuring
Snapshot standby database.
. Experience in Oracle Security Administration & User Management.
. Experienced in analyzing and translating business requirements into
creation of database objects: tables, indexes, constraints, packages,
stored procedures and functions using Oracle tools.
. Quick and efficient in responses to various database events, alerts,
warnings, errors.
TECHINICAL SKILLS
Operating HP-UX 10.x/11.x, AIX 4.3x/5.1/5.2,6.1,7.1, WINDOWS
Systems NT/2000/2003 Server, RHEL 2.1/3.x/4.x,5.2,6.1,7.0, Sun
Solaris 8/9/10
Relational Oracle 11g /10g /9i /8i
Databases
DB Utilities Grid Control, 10g/11g Data Pump, SQL Loader, Datagaurd,
TKPROF, Export/Import, DBVerify, DBMS_Repair, DBMS_XPLAN,
DBMS_SPM, DBMS_STATS, Oracle Streams, VERITAS Net Backup,
VMware
High RAC 10g/11g Release 2 with ASM, OEM(9i, 10g, 11g),
Availability & Data-Guard (9i, 10g & 11g),Database Cloning (Manual,
Tuning / RMAN),Standby Databases (Manual, RMAN) (Physical &
Monitoring Logical),RMAN (9i, 10g & 11g),AWR, ADDM, ASSM & Statspack
Reports EXPLAIN PLAN, STATSPACK
Languages SQL, PL/SQL, UNIX Shell Scripting
System Oracle Enterprise Manager, TOAD 8.5, SQL Developer, Putty,
Management F-Secure Client, Hummingbird, SQL*PLUS, SQL- Navigator,
Tools ERWIN, Golden Gate, Database Replay, Log Miner and
Flashback Data Archive, RMAN,LDAP, Telnet, Secure CRT, FTP
Microsoft Microsoft Word / Excel / PowerPoint / Visio / MS Project
Office
PROJECTS EXPERIENCE
Client: T Mobile Inc., Atlanta, GA
Role: Oracle Database Administrator
Duration: 04/2013 to till date
Project Description: T-Mobile Inc. provides wireless voice, messaging, and
data services in the United States. This project Involves Data Migrations
and replications between multiple vendor systems with zero downtime. It
includes gathering requirements from app team and Installation of RAC
databases, troubleshooting the oracle database issues and working with
oracle global support.
Environment: Oracle 10g/11g databases, Golden Gate 10/11, Data Guard
10g/11g, RAC 10g/11g, Data pump, Export/Import, SQL*Loader, Physical
Backups, Red Hat Enterprise Linux 4, TCP/IP, LDAP,IBM-AIX 5.3/6.1, Sun
Solaris 9/10,HP-UX 11.23,Oracle Enterprise Manager 10g/11g, SQL, RMAN,
SQL* Net, SQL* Plus, UNIX, Statspack
Responsibilities:
. Provided 24x7on call support for the production and development databases
. Installed and Configured Oracle Database 11g stand-alone and RAC
Databases.
. Configured Oracle Database backups for Test/Dev Environment using RMAN
combined with Veritas Net Backup.
. Monitoring of Oracle databases using OEM 11g.
. Installation, configuration and maintenance of Oracle Replication Tool
Oracle Golden Gate.
. Upgrade Enterprise Manager and Agent from 10g to 11g.
. Administering ORACLE Databases 10g (10.2.0.2), 11g (11.1.0.7) with over 2
TB in size
. Installed and Configured the GoldenGate software and created manager,
extract, replicate trail files.
. Performance Troubleshooting using different oracle tools AWR, ASH, ADDM
and SQL Tuning, Advisor, SPM, SQLT and Real Time Sql Monitoring Using
OEM.
. Troubleshooting operational issues and documenting detailed resolution
steps.
. Utilized 11g new features like Real Application Testing (RAT) and
Database Replay (DB Replay) to validate database performance on new
Hardware.
. Optimizer statistics collection using DBMS_STATS package and Optimizer
tuning using relevant init.ora parameters, Hints, SQL Profiles and SQL
PLAN MANAGEMENT (SPM).
. Tuning SQL statements using Explain Plan, Execution Plan, SQL Baselines
and SQLT tool.
. Root cause analysis of Database performance issues.
. Worked on upgrading RAC environment from 11.2.0.3 to 11.2.0.4
. Worked on applying Latest PSU on top 11.2.0.3 and 11.2.0.4 binaries.
. Migrating data between different database instances whenever required,
using Datapump or exp/imp utilities and RMAN cloning.
. Cross Platform migration and upgrade of databases.
. Performed huge amount of Data movements between Databases using
Transportable Table spaces.
. Working off hours at times supporting issues when encountered in
Production Environment.
. Worked on upgrading of oracle databases from 10g to 11g
. Working closely with upstream and downstream clients in migrating data
using oracle replication tool Golden Gate.
. Support of back-end logic for business applications, e.g.
procedures/functions/packages and triggers.
. Supporting Change and Release Management of database objects, code and
data.
. Troubleshooting and performing reorganization of tables/indexes.
Reorganization of Table spaces to reduce fragmentation.
. Tuning SGA, troubleshooting I/O bottlenecks, identifying contention,
waits and locks.
. Management of Archived logs, UNDO table spaces, Flashback logs.
. Online Incremental Backup of Database using RMAN and Oracle Secure backup
(Scheduling backups depending upon Business Strategy: Daily, weekly and
merged backups etc.)
. Recovery of Database using RMAN (Recovering from Media Failure,
Recovering tables dropped accidentally, Recovering data files, recovering
from Block Corruption).
. Backup of Archive Logs, Control Files and SPFile on Tapes to Ensure
Complete Recovery can be achieved.
. Placement of Oracle Files (Control Files, Redo Logs, Rollback Segments,
System Data Files, etc) for Optimized Performance, Backup and Recovery.
. Worked on Table Partitioning (Range Partitioning) to simplify maintenance
and improve Query Performance of very Large History Tables.
. Working closely with development team in providing the required support
from Database standpoint like creating required roles, granting required
privileges and creating new schemas as and when required.
. Modification of the database structure, as necessary, per directions
given by the application developers. Candidate should be able to advise
development staff on implications of any proposed changes.
. Collecting Diagnostic information using tools like RDA, Oradebug utility
and OSWatcher.
. Contacting Oracle Support for technical assistance in resolving problems
in a timely fashion.
. Design, implementation and maintenance of database security procedures.
Ensures compliance with Oracle License agreement.
. Document backup and recovery policy of RMAN Backups
. Implemented Oracle 11g Active Data guard for Disaster Recovery Solution.
. Participated in requirements gathering meetings with customer while
building out new db environments.
. Prioritizing db related tasks on daily basis and completing them as per
the schedule.
. Security User Management, Privileges, Roles, Auditing, Profiling,
Authentication.
. Develop and maintain hot and cold backup scripts. Perform complete and
incomplete database recovery. Plan and perform Disaster/Recovery testing.
. Identified bugs and worked with Oracle Support to get the required
patches.
. Refresh Dev, Test, Pre-Prod databases from Prod on a regular basis using
RMAN.
. Creating and sizing of database objects (table spaces, tables, and
indexes).
. Diagnose the bottlenecks and problems causing poor performance
. Performing Database reorganization to minimize fragmentation.
. Rebuilding indexes for faster access and to reduce disk I/O.
. Data extraction and Loading using Export/Import and SQL*Loader
. Worked extensively on Tidal Tool in scheduling jobs, moving jobs in
Crontab to Tidal
Client: DTCC, Dallas, TX
Role: Oracle Database Administrator
Duration: 10/2011 to 03/2013
Project Description: The Depository Trust & Clearing Corporation is a US
post-trade financial services company providing clearing and settlement
services to the financial markets. Duties include all aspects of Oracle
Database Administration including performance and tuning, Oracle
Installation and Oracle upgrade, database maintenance and database
recovery.
Environment: Oracle 9i/10g/11g RAC/stand alone databases, LINUX- Redhat
4/5, Solaris 9.0/10.0/11.0,10g/11g Data Guard, Golden Gate 10g/11g, RAC
10g/11g, ASM 10g/11g, 10g Data pump, Export/Import, Physical Backups,
Oracle Enterprise Manager, 10g/11g, Autosys, DBArtisan, SQL, RMAN, SQL*
Loader
Responsibilities:
. Provided 24x7on call support for the production and development
databases.
. Responsible for Database Administration of Oracle RAC10g/11g and non RAC
databases on ASM with 1 TB size of databases.
. Managed Physical & Logical standby databases in RAC and non-RAC
environments.
. Implemented 10g/11g Data guard with one physical database using RMAN
duplicate.
. Designed, configured and maintained backup and recovery policies
including RMAN backups.
. Implemented Oracle Flashback features for Application Upgrades as backup
and recovery strategy.
. Performed Performance Tuning, Application Tuning and Monitoring.
. Performed Oracle database upgrade from 10g to 11g in Linux RAC
environment.
. Performed SQL query tuning using tools like Explain Plan, SQL*Trace,
TKPROF and Statspack, OEM.
. Proactively monitored and did capacity planning for future database and
server growth.
. Utilized Oracle Streams to capture, propagate, and apply the transfer of
data, transactions, and events within managed databases.
. Installed, configured and maintained ASM enabled RAC10g database.
. Implemented streams and Logical standby replication.
. Performed Cross platform migration using transportable table spaces and
RMAN.
. Configured schema level logical backups (datapump).
. Installed and configured Oracle Golden Gate 11, debugging GoldenGate
issues such as ABEND.
. Worked extensively on Autosys in configuring, deleting, preparing and
editing JIL for jobs, moving jobs in Crontab to Autosys.
. Resolved Datagaurd DR site sync issues
. Upgraded databases from 10.2.0.4 to 10.2.0.5 and 11.2.0.1 to 11.2.0.2
using dbua/manual method.
. Designed and implemented database backup/restore methodologies,
responsible for Troubleshooting performance and networking issues.
. Checked database performance on a regular interval, which includes
checking various log files.
. Implemented & maintained ASM.
. Migrated and upgraded the Oracle 9i database to Oracle 10g and
incorporating the changes in the database design.
. Configured and automated RMAN backups through Grid Control.
. Performed database cloning and re- location activities.
. Managed table spaces, data files, redo logs, tables and its segments
. Reviewed and tuned SQL queries, stored procedures, views, triggers.
. Added, modified or removed users, roles and privileges, profiles, and
other accesses.
Client: KCI Inc., San Antonio, TX
Role: Oracle Database Administrator
Duration: 01/2010 to 09/2011
Project Description: Kinetic Concepts, Inc. (KCI) is an U.S-
based multinational corporation that produces medical technology related
to wounds and wound healing including therapeutic beds, wound care and
tissue regeneration technology.
Environment: Redhat Linux 4/5, IBM AIX 5/6, Oracle 9i, 10g, RMAN, Data
Guard, GoldenGate
Responsibilities:
. Configured RMAN Backups and Clones using scripts.
. Production Assessment Tests and maintained to the global standards
. Planning and Administration of backup and recovery strategies.
. Creating and Managing Primary Objects like Custom tables, Procedures,
Cursors, Packages, Triggers, Alerts & Functions, Views, Materialized
Views, Indexes, user accounts, roles, grants and performing day-to-day
operations.
. Database Upgrade from 9i to 10g.
. Rebuilding Database indexes and tables.
. Monitoring tablespace usages.
. Using TKPROF, EXPLAIN PLAN and AWR for the Better performance.
. Transferring files by using SCP, SFTP, FTP and PSCP.
. Partitioning strategies for very large tables.
. Diagnose and troubleshoot Database problems and failures
. Creating and refreshing materialized views.
. Performing SQL*Loader jobs for data loading.
. Monitoring of database for growth and performance.
. Ensuring proper online and offline backup. Periodical reading and
checking of backups taken.
. Monitoring Growth of tables and undertaking necessary re-organization of
database as and when required.
. Involved in Database sizing, Capacity Planning.
. Performed Space Management & Troubleshooting the database issues.
. Actively involved in monitoring the lock processes, releasing locks in
case of resource blockage and gathering statistics.
. Setup and configured Oracle Physical Standby database (Data Guard) for
disaster recovery.
. 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/exp/imp tables to setup identical databases in the
production and development environments.
. Performed Cloning/Refresh to setup Test and Development database.
. Create and maintain users, roles and privileges & Auditing Triggers.
. Upgrade/Migrated the production and development databases from 9i to 10g.
. Responsible for setting and managing user accounts, Granting required
privileges to users.
. Transformed logical database designs into physical databases.
. Build and implemented test, quality assurance, production databases and
environments.
. Coordinated strategies to move data between databases.
. Ensured data is being maintained effectively by monitoring data
maintenance.
. Performed version upgrades and patch installs.
. Automate Logical Backups using export/import, data pump on applications
through grid control.
. Implemented and maintained database security (created and maintained
users and roles, assign privileges).
. Documenting and maintaining the process related to oracle database
installations, patching, migrations and upgrading.
. Worked with oracle global support/metalink team for various oracle
database issues and software version bugs.
. Followed the oracle metalink standard documents and procedures for
various database related deployments and changes.
. Communicated with external and internal teams on various database related
projects.
. Followed the change board management policies for deploying changes in
oracle databases.
. Worked with application support teams to gather requirements and document
them properly.
EDUCATION
Bachelor's Degree in Business Administration (BBA)
References: Available upon request.
Contact this candidate