SUMMARY

• Results driven information technology professional with over 6 years of progressive experience in Oracle database administration. Proven track record of providing strategic direction while deploying tactical technical solutions. Exceptional analytical and problem solving skills. Excellent ability to look at problems from a macro level and a detailed level; always keeping the appropriate business prospective.
• Oracle 10g & 11g RAC, ASM, Stream, Data Guard (Physical, Logical standby), Enterprise Manager (EM) Grid Control, RMAN, Installation, Upgrades, Migrations, Performance Tuning Recent Experience.
• Troubleshooting the production databases (RAC, Non - RAC) within less time.
• Highly Experience in Tuning database in RAC / Non-RAC environment for better Performance.
• Proactive Monitoring identifying areas that need to be improved performance in the application and database using 11g/10gOEM Grid Monitoring.
• Performance tuning of the database (Memory Allocation Tuning, I/O Tuning, and Tuning Contentions) using TKPROF, EXPLAIN PLAN, STATSPACK, AWR, ADDM.
• Creating extracts, data pumps and replicats on production servers, splitting replicats for efficient data transfer between servers, performance tuning using BATCHSQL, KEYCOLS, HANDLECOLLISIONS, CHECKPOINTSECS & troubleshooting extract/replicat ABEND issues.
• Database Upgradation, Migrations using traditional way (DBUA, Manual and export/import) as well as non-traditional way (Transportable table spaces).
• Oracle Database Administration (11g/10g/9i/8i) experience in variety of different environments Such as Linux, HP-Unix, AIX, SUN SOLARIS and Windows.
• Experience with RMAN to implement Backup/Recovery strategies and clear understanding of the data structures and architecture provided by Oracle for Recovery in all kinds of Disasters.
• Experience with data pump, export and import utilities to backup and recovery database.
• Involve in Change Management process, Documenting, reviewing and approvals of the database change at various levels.
• Worked as a team member to provide 24x7 on-call production database support.
• Strong analytical and problem solving skills with ability to work within team and independently.
• Experience in Oracle Support processes for technical requests through Metalink and other Support Procedures.

TECHNICAL SKILLS:

Databases: Oracle 8.x/9i/10g,11gRAC, SQL SERVER2000/2005, MySQL, MongoDB

Developer Tools: Oracle WebLogic Server, Oracle Application server 9i/10g, Oracle Developer 6i (Forms, Reports), Oracle Developer Suite 10g, EXP, IMP, DATAPUMP, RMAN, OEM Grid Control, Data Guard, Stream, Goldengate, ASM, SQL*Loader, Exadata, Oracle Warehouse Builder, Oracle Discoverer, TOAD, SQL Navigator, SQL Developer, ERWin, MS Visio, MS Project.

Monitoring Tools: Spotlight, Nagio, BMC Patrol, Application managers, OS Watcher, OEM GRID.

Languages: SQL, PL/SQL, UNIX Shell Scripting.

Platforms: HP-UNIX 10.x, 11.x, AIX, Sun Solaris 10, Red Hat Linux RHEL 3.x, 4.x,5.x,6.x, Oracle Linux 6.x and Windows.

PROFESSIONAL EXPERIENCE:

Confidential, MA

Oracle DBA

Responsibilities:

• Responsible for administration and supporting Oracle 10g and 11g databases.
• 24x7 Production database administration, support and monitoring to ensure a proactive problem recognition and resolution of database issues.
• Successfully migrated databases from windows2000/2003 running oracle 9i over to Linux boxes 10g.
• Installation, Upgrade and Configuration of Oracle 10g and 11g Databases.
• Involved in designing of disaster recovery plan using Data Guard, and High Availability using RAC.
• Schemas refresh using Export/Import Pump, Creating the database table spaces, tables, indexes, setting privileges and user logins.
• Configuration, Administration and tuning of Oracle 10g RAC.
• Used cross platform transportable table space (TTS) to transport tablespaces across platforms.
• Data Refresh in Test and Integration Databases using Transportable Table spaces.
• Performed Setup Recovery Manager (RMAN) and Flash Recovery in RAC Environment.
• Oracle Streams Bi-Directional replication implementation at Table, Schema and Database Level.
• Implemented backup strategies using hot/cold, exp/imp used on the business req.
• Cloning databases using scripts as well as RMAN and performed Tablespace point in time recovery (TSPITR) using RMAN.
• Implemented Streams replication between RAC and non RAC database environments.
• Installed Oracle 10g Enterprise Manager (Grid Control) for diagnosing and monitoring performance related problems and configured with Application servers on test databases.
• Assisted a team of DBA’s in migration of databases from Oracle 9i Release 2 to Oracle 10g Release 2.
• Worked on Automatic Storage Management (ASM) with SAN Storage for managing data in EMC Symmetrix.
• Monitoring and tuning using tools like Enterprise Manager GRID, Oracle cost Based optimizer (CBO), SQL analyzer, automatic checkpoint tuning, SQL Advisors, Performance Manager, and Statspack.
• Performed conversion single instance to Real Application Cluster (RAC) database instances.
• Utilized Oracle Streams to capture, propagate, and apply the transfer of data, transactions, and events within managed databases.
• Provided database/application tuning including as reducing lock contention, analyzing objects.
• Downsizing and defragmenting the Very Large Databases by export / import, cloning those using RMAN duplicate features and then upgrading them to Oracle 10g and Production to development refresh.
• Storage Management Managing Space, Table spaces, Segments and Extents, Rollback Segments & Data Dictionary.
• Experienced on Database Security by monitoring User Management, Privileges, Roles, Auditing, Profiling, Authentication and Risk management.

Environment: HP-UX 11, Red Hat Linux4, Windows 2000/2003, Oracle 9.2.0.8/10.2.0.3/11 g, DB2, Enterprise Manager GRID and SQL*Plus.

Confidential, Grand Rapids, MI

ORACLE DBA

Responsibilities:

• Installed and configured Oracle Enterprise Manager 10G Grid Control for Enterprise.
• Configured and managed physical standby database using Data Guard for disaster recovery on a different node for different production servers.
• Performed Data Guard switchover/failover as per the requirements.
• Created monitoring scripts to send alerts in case standby is out of sync.
• Configuring and Managing two nodes UNIX RAC environment for high availability, highly busy databases.
• Worked in Oracle 10g RAC environment.
• Worked with Developers and change management team to ensure smooth life cycle progress from development through testing and production implementation.
• Backup and recovery via RMAN scripts and troubleshooting.
• Day to day troubleshooting like adding space in data files, rebuilding indexes, check alert log file and monitoring of system.
• Cloned databases on same node and also on different server nodes using custom shell script with hot and cold backups of source database.
• Upgraded and patched Oracle binaries in the development environment and production environment.
• Coding and optimizing objects for data access.
• Responsible for setting up production, development, performance and staging database environments.
• Reorganized existing database to standardize the placement of various databases related files.
• Managed logical/physical backups for these databases depending on the nature of database set up either full export, partial export or export of just the structure of schema objects.
• Monitored and audited database access for unauthorized access.
• Worked as part of team and provide 24x7 supports when required.
• Have Applied Patches to existing versions.
• Created tablespaces and managed tablespaces adding/deleting/ resizing data files.
• Utilized SQL*Loader (ETL) to perform bulk data loads into database tables from external data files.
• Use of Crontab, DBMS JOBS to automate the monitoring jobs.
• 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.
• Administered all database installation, creation, modification, and tuning issues of Oracle.
• Performed SQL tuning by using Explain Plan and TKPROF.
• Generated workingdocumentationfor the DBA team use.
• Analysis of alert logfor error tracing.
• Resolved different locking issues.
• Worked on daily DBA activities.

Environment: Oracle 9.0.1.5/9.2.0.6 , Sun Solaris, HP-UX 10, TOAD, OEM, Statpack, tkprof, SQL, RMAN.

Confidential, Minneapolis, MN

Oracle DBA

Responsibilities:

• Installation, Administration, Maintenance and Configuration of Oracle Databases 8i, 9i, 10g.
• Created and maintained different database entities included Tablespaces, data files, redo log files, rollback segments and renaming/relocating of data files on servers.
• Provided on-call support regarding production-related database problems.
• Used RMAN for backup and recovery strategy.
• Tuning of databases which includes Server side tuning and application tuning.
• Capacity planning of the databases / applications.
• Upgraded database from Oracle 8i/9i to 9i/10g
• Refreshing test and development environments (Oracle) from production databases as and when required.
• Optimized different SQL queries to insure faster response time
• Worked with Oracle Enterprise Manager.
• Work with Oracle Support to resolve different database related issues.
• Used Transportable table space, Data pump, RMAN for database migration between different platforms like Solaris to AIX.

Environment: Oracle 8i,9i,10g, RH Linux, Solaris, Installation, Migration, Upgradation, OEM, RAC, RMAN, ADDM, AWR, Statspack.

Confidential, Concord, CA

Oracle DBA

Responsibilities:

• Creation of users, Implemented database auditing, data security.
• Partitioning tables by determining the suitable methodology to improve performance and manageability.
• Generated scripts for daily maintenance activities like analyzing the tables/indexes, growth rate and SGA use.
• Performed Hot, Cold, Table space level backups and Detection of corrupted blocks by using utilities like DBVERIFY and with RMAN Block corruption.
• Creation and migration of DB and other related Objects including schema objects
• Created scripts for hot backup and export on a daily basis scheduled with cronjobs.
• Plan for system and monitor capacity usage for new hardware and software requirements
• Automation of Startup Shutdown on all Production and Development Database.
• Interfacing with oracle corporation for technical support(METALINK)
• Modified the listener port number and to archive log mode for one of the existing database
• Clone and refresh environments to create patch test, development and QA environments.
• Conducted multiple test runs to gather timings for production upgrades.
• Implemented Disaster recovery (standby database 9i), documented database and application validation steps.
• Automate monitoring jobs, backups and alerts using UNIX shell scripts.
• Applying Upgrade, CPU Patch and bug fix patch.
• Loading data using SqlLoader.
• De-fragment tables and indexes for improved performance and effective space management.
• On-going SQL tuning using Explain Plan and SQL Trace.

Environment: Oracle 9i, 10g R2, Oracle Enterprise Manager, Oracle Grid control, RHEL, AIX, RMAN, DATA PUMP, DATA GUARD, RAC, PL/SQL, TOAD and SQL *Plus.

Confidential

Jr. Oracle DBA

Responsibilities:

• Database activities include allocation and maintenance of Rollback Segments, Automatic Undo Management, table spaces, data files and redo log files.
• Creation of tablespaces, Rollback segments, Redo log groups.
• Enrolling the users, and maintaining the system security.
• Configuration of Sql*Net through tnsnames.ora and listener.ora.
• Established constraints to ensure data integrity and consistency.
• Reorganizing the Database for every three months ensuring performance growth.
• Worked with RMAN (Recovery Manager) tool for taking backups (Database level and Incremental sets) with ORACLE 10g as database. Practically aware of most recovery operations to be performed using RMAN tool.
• Creation of users with passwords and assigning them tablespaces like user data and temporary, granting privileges (system and object) through roles and profiles.
• Schedule backups using Autosys scheduler, also work with VERITAS net backup team for backup failures/issues.
• Archiving backups and maintaining backup’s library.

Environment: Oracle 9i 10g, RMAN, Dataguard, AIX 5.3, Windows 2003, Toad, Remedy, EMC SAN/HBA, USD, NFS, DB on file system and RAW devices.