SUMMARY

• 8 + years of experience as Oracle DBA. Worked extensively on Oracle 12c, 11g and 10g involving database administration, production support, installation, configuration, upgrades, patches, migration, backup and recovery, performance tuning, cloning, space management and security.
• Build and managed Active Data Guard
• Mentors the team on technology concepts and ensures team compliance to best practices for design
• Managed database using command line as well as 11g and 12c OEM
• Experience in applying CPU and PSU Patching
• Worked on Migration projects.
• Worked on Upgrade projects.
• Possess experience in SQL Server Database Administration.
• Worked as a lead in Data Centre Consolidation on large database systems.
• Worked as a primary support for database related issues with clients.
• Worked on multiple projects in parallel to daily DBA activities.
• Worked with RMAN on various backup policies
• Performed Database Tuning & Performance, Storage Management, Plan growth and changes (capacity planning), Database Monitoring, Security Management, and Tuning SQL queries.
• Used tools like TOAD, DB Console, Confio, and Grid Control to monitor database performance.
• Data loading using SQL*Loader, Logical backups using full export and DATAPUMP
• Worked as a team member to provide 24x7 on - call production database support
• Database replication using snapshots, materialized views, and advanced Replication methods
• Excellent communication and interpersonal skills
• Worked on High availability of the databases including RAC, ASM and Data Guard on Oracle Exadata
• Worked extensively on all database administration tasks on 10g and 11g R2 DBs
• Build and administer SQL Server 2005/2008 standalone and cluster databases.
• Evaluated Oracle features and Oracle related products to leverage existing hardware/software/incenses.
• Worked on Performance tuning of databases on Exadata
• Have familiarity with RAID configurations.
• Worked on Oracle Security using Oracle Vault, Wallet and TDE.
• Good knowledge of Oracle Dictionary Views.
• Installed databases using silent install.
• Provided 24/7 support on on-call rotation.
• 11g R2 Administration included:
• Installation of RHEL5, set up group/users, installing Linux packages and setting kernel parameters
• Upgrade from 10g R2 to 11g R2
• Build 11g R2 RAC from scratch including Linux OS installation.
• Installed11g R2, upgraded and performed Hot Patching
• Partitioning - system partition, virtual column base partition, reference partition, composite partition, and range-range partition
• Data modelling exp
• New features and enhancements of RMAN, Flashback and logminer
• Data recovery advisors
• SQL Access Advisor, Performance Analyser, Plan Manager, Automatic SQL Tuning, SQL performance analyser, Table compression and SQL access advisor, SQL plan management and Database replay
• Table compression enhancement.
• Build Unidirectional and bi directional GoldenGate replication.

TECHNICAL SKILLS

Operating Systems: RHEL, HPUX, AIX, Sun and Windows

RDBMS: Oracle 12c, 11/10g, 9i, SQL Server 2005 / 2008

High Availability: RAC, Data Guard, ASM, GoldenGate, Materialize Views.

Languages: SQL, PL/SQL, UNIX

Shell scriptingTools: RMAN, OEM, sqlldr, exp, imp, expdp, impdp, TOAD, dbconsole, asmcmd

Tuning Tools: tkprof, EXPLAIN PLAN, STATSPACK, SQL Advisor.

PROFESSIONAL EXPERIENCE

Oracle DBA

Confidential, San Francisco, CA

Responsibilities:

• Responsibilities include maintaining databases, monitor daily database activity, implement customer requirements, coordination, performance tuning.
• Silent install 10g, 11g databases and 12c databases.
• Installed 2 node and 4 node clusters on Exadata
• Migrated databases
• Build Unidirectional and bi directional GoldenGate replication.
• Worked closely with offshore DBAs
• Worked closely with Storage Admins to space build ASM database servers
• Designed and Implemented database security using Oracle roles and privileges.
• Maintenance of the RMAN repository database and configuration of backup policies.
• Installed and administered RAC databases.
• Setup monitoring using 11g grid control and12c cloud control.
• Implemented Data Guard for DR purpose
• Implemented Incident rule creation, Mail Server registration, Email subscription from OEM
• Converted the single instance dbs to RAC clusters
• Worked on instance and SQL tuning
• Written shell scripts
• Creating Indexes, rebuilding indexes, analysing indexes to improve the performance of query.
• Monitored the various database activities by developing shell scripts and using various tools.
• Worked closely with Developers
• Upgraded Databases from Oracle 10g to 11g
• Worked on Flash Recovery Area
• Data modelling exp
• Performed DR switchover / failover practices using Data Broker.
• Patched Oracle databases using opatch utility.
• Worked on monitoring Database health, Bottlenecks, session information, table privileges and permissions.
• Monitored scheduled jobs for backups, gathering statistics, AWR reports, data guard status reports, disk space utilization report
• Generated triggers for data integrity, created views to resolve complex queries.
• Used RMAN duplicated database to clone.
• Used export import and Data pump to refresh schemas.
• Identifying the poorly performing queries using Explain Plan, TKPROF, and assisting the developers in optimizing and tuning the SQL and PL/SQL code using SQL trace.
• Worked on Materialize views
• Provided 24/7 on-call support.

Oracle DBA

Confidential, Volo, IL

Responsibilities:

• Supported Oracle 11g, 10g and 9i databases
• Installed and created 11g databases
• Performed upgrades from Oracle 10g (10.2.0.3) to 11g (11.1.0.1) on Intel and HP boxes
• Successfully migrated databases from Intel boxes (Win2000 and Win2003 servers) running Oracle 10g over to HP Itanium boxes running Oracle 11g
• Installed Oracle 10g RAC software with ASM & OCFS2 file systems
• Configuration, maintenance and tuning of 10g RAC
• Setup of Disaster Recovery databases (Data Guard)
• Refresh schema-using Export/Import. Creating the database, table spaces, tables, indexes, setting privileges and user logins
• Installing and Configuring Recovery Manager (RMAN)
• Extensive Performance Tuning, Memory (SGA) Tuning, Net backup, EMC (Time finder and SRDF), RAID, RAW Devices
• Performed Database and SQL tuning by using various tools like STATSPACK, AWR, ADDM, TKPROF, EXPLAIN PLAN, and Optimizer hints
• Experienced in migrating databases to higher releases including incremental migrations
• Migrated database from 9i to 10g and 11g supporting various incremental releases
• Planned version control of production source code using Clear case.
• Writing SQL scripts, stored procedures, functions, and transactions analysis for performance tuning
• Security User Management, Privileges, Role, Auditing, Profiling, Autantication
• Made performance improvements to the database by building Partitioned tables, Index organized Tables, Materialized Views, and Bitmap Indexes
• Created database maintenance plans, including updating statistics, re-indexing, structure modifications, Capacity plans, and index analysis
• Storage Management Managing Space, Table Spaces, Segments and Extents, Rollback Segments & Data Dictionary.
• Analysis and management of Oracle problems/defects using SRs and/or Metalink with Oracle Corporation and installation of patches.
• Used Oracle Internet Directory to leverage the scalability, high availability, and security features of the Oracle Database.
• Used RMAN for Backups
• Data Modelling, Database Design and Creation using Erwin.
• Created Triggers for multi-master replication.

Oracle DBA

Confidential, Downers Grove, IL

Responsibilities:

• Installation, configuration and troubleshooting of Oracle Database Software 9i and 10g on RHEL 3.0 and 4.0 environment and RAC setup with ASM.
• Upgrading database from Oracle version 9i to 10g and migration of data.
• Worked on backup, recovery and disaster recovery strategy using RMAN.
• Configured and maintained RAC clusters on both ASM and non-ASM file management
• Involved in upgrading data warehouse database version from 10g to 11g.
• Monitored Oracle databases using Oracle Enterprise Grid Control.
• Implemented Oracle Failsafe to setup RAC environment on windows platform.
• Responsible for completing Database Refresh requests on both Oracle and SQL Server databases.
• Involved in User Management, creating new user ids, assigning them roles and privileges, monitoring their activity.
• Experience with Star Schema simulated the functions of a multidimensional database and data warehousing.
• Working with the automated DMA patching process which includes identifying, staging Patch Binaries, applying and rollback Patches.
• Written Stored Procedures and Triggers for database maintenance and management using PL/SQL.
• Integrated the Backup status reporting for the entire database in the enterprise to enable the web reporting using Oracle SQL, PL/SQL, SQL performance tuning and korn shells, Unix shell Scripting.
• Managing Instances redo log files, Tablespaces, Data files, Indexes, Undo Segments, and Temporary segments.
• Extracted data from Oracle database into XML format for EDI requirement.
• Worked on logical backup using and full/ partial export/import and Data Pump.
• Involved in disaster recovery planning; detailed out the processes and procedures of implementing disaster recovery; implemented database backups and disaster recovery strategies using RMAN.
• Involved in applying patches as per the requirements of the client and upgrade Oracle and DBMS software under Oracle and SQL server.