SUMMARY

• An Oracle DBA with 7 plus years of IT experience in oracle (9i,10g,11g), (11g,10g) RAC, streams, data guard, installation, migration, designing, backup, recovery, scripting, performance tuning etc, spanning in different industries.
• Hands on experience in administering 24*7 mission on critical production environments on UNIX and Windows based systems.
• Expertise in installation, configuration and administration of Oracle 11g/10g/9i in very large scale database environment (VLDB) and mission critical OLTP and DSS systems
• Hands on experience in Oracle Database Administration activities such as production support,Database design, Installation, Configuration, Upgrades, Patches, Performance Tuning, Backup and Recovery.
• Implemented Oracle 11g/10g Real Application Clusters (RAC), Oracle Automatic Storage Management (ASM), Cluster Interconnects, Load balancing and designing failover systems on UNIX platforms.
• Experience in configuring Automatic Storage Management (ASM) to administer teh oracle related files, Upgrading and Migrating of teh Databases
• Planned and implemented Disaster Recovery (DR) & high availability solutions using physical Standby Databases, 10g & 11g Oracle Data Guard.
• Installation and proactive Monitoring of oracle databases using OEM grid control.
• Hands on experience in Cloning, Oracle Streams, Space Management, Database Security, Auditing, Troubleshooting,TAR/SR Support and Documentation. Advanced Queuing. Power Designer for Data Modeling
• Experienced in using 11g features Data pump, Flash - Back Recovery, AWR, ADDM, Grid Monitoring, and Recycle Bin.
• Performed TSPITR, duplicating database using RMAN Involved in Disaster Recovery Planning.
• Developed Shell scripts for day-to-day database administration tasks dat include various Cron jobs for alert logs and performance, Backups, Restores and Recoverability.
• Experience with RMAN cloning from active Databases.
• Experience with Oracle partitions (Ranage & List)
• Experience in Writing Shell Scripting, ksh and bash scripting and Partitioning.
• Experience in cloning and refreshing lower environment databases from production databases.
• Hands on experience in implementing security policies at user level and database objects level.
• Experience in applying oracle patch set, Patches, Critical Patch Update (CPU)/Patch Set Update (PSU) and One-off Patches using OPatch and runInstaller under UNIX and Windows.
• Expertise in Database upgrading and migration of Oracle server (9i, 10g, 11g).
• Hands on experience in tuning teh database objects to resolve teh row chaining, row migration and fragmentation
• Performance tuning experience, specializing in SQL Tuning, Database/Instance Tuning, STATSPACK, TKPROF, SQL Trace and Explain Plan,ADDM,AWR.
• Extensive performance tuning experience, specializing in instance tuning, Oracle9i and 10g RAC tuning and SQL optimization
• Strong Knowledge of creating Tables, Indexes, Views, Materialized views, Synonyms, DBlinks, Packages, Procedures, Functions, Cursors, Triggers
• Strong experience in using SQL developer,External Tables,SQL*Loader, Exp, Imp, Datapump (Expdp, Impdp), Putty, TOAD, Oracle Enterprise Manager (OEM), SQL*Plus tools.
• Scheduling jobs through Oracle Job Scheduler, Crontab (Unix), and Autosys.
• Resolved database network problems using Oracle Net Configuration Assistant, Oracle Net Manager, Netstat and ping utility
• Provided 24 x 7 support during on call rotation.
• Strong ability to handle multiple projects simultaneously through completion and ability to work independently or in a team environment and ability to function successfully in a highly stressful environment.
• Experience in working with Oracle support Services to troubleshoot teh problems and issue.

TECHNICAL SKILLS

Operating Systems: HP-UX, Sun Solaris 2.6/8/9/10, Red Hat Linux and IBM AIX 4.x,5L, Windows NT/00/XP/Vista, Oracle Linux

RDBMS: Oracle 9i, 10g, 11g, 9i RAC and 10g/11g RAC

Languages: SQL, PL/SQL, .NET, Java, C, C++, UNIX Shell Scripting

Tools: RMAN, OEM, SQL*Loader, ETL Sql Developer, Sql Navigator, Toad, DataPump, Gloden Gate, Data Guard, Oracle Streams, TOAD, Shareplex,Oracle APEX

Tuning tools: TKPROF, EXPLAIN PLAN, STATSPACK, SQL*TRACE, AWR, ADDM

Confidential, Irving TX

DBA

Environment: Solaris, Linux, MSSQL server, SQL, PL/SQL,Oracle 10g/11g,RAC, UnixShell Scripting,ASM, TOAD, Dataguard Oracle APEX,OEM, SQL*loader.

Responsibilities:

• Worked in a Datacenter hosted with 250+ databases on various flavors of UNIX environment with 100+ Production servers, 80+ Development Boxes, 60 Test Box.
• Worked in a environment with 280+ instances (both RAC and Dedicated Servers).
• Experience in handling large database upto 4TB in size and largest table of size 60GB with 145 million records.
• Installed, configured and supported Oracle 11gR2 databases on various platforms (SOLARIS, IBM-AIX, HP-UX 64 bit).
• Installation, Configuration of Oracle Clusterware, created ASM, RAC databases, Adding Services and maintaining GRID control.
• Implemented Tables in both Range and List partition basing on teh Business requirement.
• Migrated databases from 9i and 10g to 11g R2 using utilities like EXPORT/IMPORT, DATAPUMP and TRANSPORTABLE TABLESPACE.
• Configured client/server side load balancing using TAF and ROUND ROBIN.
• Extensively used SRVCTL, CRCTL, CLUVFY, OCRCONFIG, DGMGRL and GRID control.
• Design, Development & Implementation of large volume OLTP and large scale Data Warehouse/DSS environments.
• Implemented replication on databases using Oracle Streams and Glodengate between homogeneous and heterogeneous databases.
• Performed replication between databases using Materialized Views and DB links from a remote database.
• Replicated data using MVIEW for databases with different character sets.
• Successfully performed installation, setup and creation of Primary & Standby database using DATA GUARD to deliver no data loss with maximum availability mode.
• Worked closely with application teams for rolling application Release/Migration and Patches.
• Performance tuning of Oracle instances using AWR/ADDM/ASSM/ASH/EXPLAIN PLAN/TKPROF/GRID/OEM etc.
• Active member of DR team, successfully completed 2010 DR exercise for all TIER1 and identified TIER 2 applications.
• Converted numerous single instance databases to RAC base architecture for teh server retirement project.
• Extremely proficient with RMAN, Restore and Recovery scenarios and planning Backups.
• Applied CPU/PSU patches to numerous databases and re-mediated databases as per SOX, and HIPPA security standards.
• Proactive monitoring using OEM/PLSQL/SHELL scripts for space, DB loads, Backup and other infrastructure related activites.
• Performed numerous data refreshes using EXPORT/IMPORT, DATAPUMP.
• Used RMAN and DBMS FILE TRANSFER utility to copy ASM archive log files from RECOVERY DEST AREA for point-in-time recoveries.
• Extensively used Log miner, Flashback queries on ITE and DEV environments for rolling back teh changes due to user/application errors.
• Worked closely with Oracle closely for bug fixes, internal errors and one of patches.
• On call rotation for 24X7 support.

Confidential, FL

Oracle DBA

Environment: AIX, Solaris, Linux,MSSQL server, SQL, PL/SQL, Oracle 10g/11g,RAC, Scripting,ASM, TOAD, Dataguard Oracle APEX,OEM, Oracle Streams,SQL*loader,Gloden Gate

Responsibilities:

• 24 X 7 Production Oracle database support and administration and on call rotation
• Installation, configuration and administration of oracle 10g/11gR1/11gR2.
• Installation, configuration and maintenance of Oracle 10g/11g RAC.
• Setup and configured Oracle Physical Standby database (Data Guard) to ensure high availability, where teh standby database was used for disaster recovery as well as to offload teh running of huge reports
• Created and upgrade RAC database on Linux with ASM, Data Guard, Flashback 10g and 11g with ASM
• Experience with oracle RAC load balancing,TAF and FAN.
• Installed and configured OEM Grid Control (GC) and intensively used for Diagnostic & tuning activities
• Replicated databases using Oracle Gloden Gate and Data Guard for reporting purposes in OLTP environment with minimum lag
• Replicated certain columns from a table and also certain values from columns by using Oracle Gloden Gate
• Hands on experience working on VLDB’s up to 5TB.
• Developed and implemented teh Monitoring of Data Warehouse for teh conversion of OLTP data to OLAP data base.
• Involved in administering Oracle database running on Unix and Windows Machines to support Oracle database.
• Hands on experience working with oracle streams for replication of databases (Unidirectional)
• Performed cross platform migrations using Transportable Tablespaces(TTS).
• Establish and Document Backup and Recovery strategies and procedures after evaluating various options including RMAN
• Ensuring proper online and offline backup. Periodical reading and checking of backups taken and maintaining user accounts and profiles
• Defined backup procedures using daily hot backups and weekly cold backup
• Proficient expertise in working with ADRCI for viewing diagnositc data and monitoring health reports at OS level
• Good Knowledge on ORACLE APEX.
• Performed Logical backup of critical application databases using EXPDP/IMPDP with a scheduled jobs (Cron Job).
• Writing and modifying shell scripts, Perl scripts to manage Oracle environments and for Backend Oracle Processes
• Implemented different Partition methodologies to improve performance and manageability
• Performed various database refresh’s, patching, upgrading over teh databases
• Installation,Configuration and Administration of Oracle 10g databases includes Database cloning for test environment and applying patches, tuning etc.
• Applying Quarterly security Patches (CPU/PSU) and applying Patch set and One-off Patches.
• Monitoring Database for fragmentation and correcting them.
• Performance tuning of application and database, identification and resolution of contention, defining and implementing Backup Recovery policy, and day-to-day monitoring of teh Production database
• Analyzing report generated from STATSPACK and tuning desire area, Execution plan of SQL statement by SQL Trace, TKPROF, EXPLAIN PLAN
• Assisted Developers with coding PL/SQL.
• Extensively involved in writing PL/SQL stored procedures, databasic triggers,function,and triggers, participated in module testing and system integration.
• Varied use of PL/SQL's, Stored procedures/packages, database triggers at various levels.
• Datamasking using teh existing production schema by creating teh backup for teh gloden image.
• SQL tuning and Database performance tuning has been done based on reports generated by SQL Trace, TKPROF Reports, Explain Plan, Statspack, AWR, ADDM, ASH and monitor teh database performance on daily basis.
• Constantly monitor teh performance (V$ dynamic performance views at peak load) of teh Databases and viewing Alert log files & Trace files
• Designed and implemented error checking and correction protocols and programs.
• Used External Tables to Load data from flat files to database.
• Diagnose and troubleshoot Database problems and failures using SQL Tuning Advisor.
• Involved in teh installation of Oracle 10g, on Windows NT and Linux.
• Setting up and maintaining user accounts and profiles
• Oracle database administration on Windows platform.
• Installation, Configuration and Maintainance of MSSQL server and Upgradation.
• Assisted Developers with coding PL/SQL
• Extensively involved in writing PL/SQL stored procedures, databasic triggers,function,and triggers, participated in module testing and system integration.
• Varied use of PL/SQL's, Stored procedures/packages, database triggers at various levels.
• Monitoring Growth of tables and undertaking necessary re-organization of database as and when required.
• Used SQL loader to load data into multiple data files in teh same session and also manuplation of teh Data.
• Storage and space management including table spaces and data files.
• Management of table space growth, monitoring data files additions, extent growth
• Creating Databases and all database objects. Database Designing (Designing Tablespaces and Rollback Segments)
• Performing in-depth data analysis often staff DBAs specifically to monitor and support teh data warehouse environment
• Troubleshoot user related and database related issues using Oracle Support Services
• Coordinating with various QA, development and unix teams periodically in handling multiple projects

Confidential, CA

Oracle DBA

Environment: Oracle 10g/11g, Sun Solaris, Red Hat Linux, Windows, OEM GC, Oracle Partitioning, ASM, imp/exp, RMAN,Oracle APEX,ORACLE STREAMS, Hot Standby, SQL Server 2000, TOAD, ERWin, STATSPACK, AWR, ADDM, ASH, TKPROF, EXPLAIN PLAN, SQL TRACE

Responsibilities:

• Installation and Administration of Oracle 10g/11g.
• Installing/configuring teh Oracle RAC using ASM on 2 Node Red Hat Linux.
• Configured and maintaining Data Guard (Physical Standby database) for teh production database and tested for switchover, failover, activating teh standby to primary and zero data loss.
• Implemented ORACLE STREAMS, and two types of standby databases.
• Scheduled and Monitored OEM GC and Cron Jobs for RMAN and exports on Linux Platforms.
• Analyzed and tuned teh Database to identify potential database issues such as response delay, locking contention, even server down time by using tools like STATSPACK, EXPLAIN PLAN, TKPROF and also using AWR, ADDM, ASH reports.
• Implemented some maintenance activities on Oracle 8i and 9i.
• Applied latest patches as per requirement.
• Upgrading and Migration of Oracle Server 9i to 10g.
• Devised, developed and implemented sophisticating backup recovery strategy using RMAN and designed/implemented disaster recovery test.
• Performed Large Terabyte size Database Backup including Physical backup through hot backup/Cold Backup of Oracle Database with RMAN.
• Modified existing database structures layout such as disk configuration and storage allocation to enhance application performance.
• Maintained day-to-day production support thereafter, check alerts log, activity logs, error logs, RMAN log to capture any possible errors to ensure teh databases health.
• Followed Change Management procedure to release teh new database components such as stored procedures and user-defined functions into teh production databases.
• Created and maintained database document.
• Cloned database on new servers.
• Oracle Application Server and Oracle APEX implementation and support
• Worked on Oracle Apex to create dynamic database driven web applications.
• Used and maintained bitmap indexes, materialized views,DB links.
• Written scripts to automate teh synchronization process between local and remote databases.
• Worked closely with project managers, programmers, and testers to ensure teh database integrity and security and generated test data and tested new database consistency with existing databases to meet teh functionalities requirements. Provided suggestions to system administration team regarding disk configuration according to database sizing and capacity planning. Fully utilize Metalink to maximize Oracle support.
• Developed Shell scripts to regularly maintain partitions and PERL Scripts for automated jobs.
• Data warehouse administration including Data Analyst and performing operations like user creation, ETL support, BAR management, space management.
• Advise Business Systems Analysts, technical managers and business users to help them define business requirements and objectives in teh implementation of specific area advanced technologies
• Implement Stored Procedures and Triggers based on business plans using PL/SQL
• Using TOAD to do database design and monitoring teh databases.

Confidential, Florida

Oracle DBA

Environment: Oracle 9i/10g/11g, Sun Solaris, Red Hat Linux, AIX, OEM GC, ASM, RMAN, STATSPACK, AWR, ADDM,VERITAS Net backup, VVM,TOAD, Perl scripting, Shell scripting, SQL*Loader, Data guard, Stored Procedures, SFTP

Responsibilities:

• Installation, configuration and maintenance of oracle 10g/11g.
• Created and upgrade RAC database on Linux with ASM, Data Guard, Flashback 10g and 11g with ASM.
• Immurement Oracle Streams on database level and table level.
• Installed and configured OEM GC.
• Migration of Oracle database releases from development to regression and to production.
• Upgrading development and production databases to Oracle 10g.
• Applied Security patches and Patch set on Oracle Databases.
• Performed some administration activities on Oracle 9i.
• Implemented backup/recovery procedures using RMAN, Data Pump, performed database recoveries.
• Provided support to Application Database Administrators in designing teh database.
• Management of schemas, objects partitioning teh tables & indexes.
• Automation of data load using shell scripting and SQL*Loader.
• Tuned teh Database to identify potential database issues such as response delay, locking contention, even server down time by using tools like AWR, ADDM, ASH and STATSPACK, EXPLAIN PLAN and TKPROF.
• Reorganizing data files, identification and elimination of contention factors like I/O, buffers and locks
• Used and maintained bitmap indexes, materialized views.
• Written scripts to automate teh synchronization process between local and remote databases.
• Responsible for network configuration and involved in a Client - Server environment using TNS, LISTNER, Net Configuration Assistant and other configuration files.
• Troubleshoot user related and database related issues using Oracle Support Services.
• 24x7 production support DBA working on a primary/ secondary pager rotation; and supported on holidays, weekends and beyond regular hours.