PROFESSIONAL SUMMARY:

• Around 8 years of experience as Oracle Database Administrator in various domains and on a variety of UNIX and Windows platforms with Oracle (12c/11g/10g/9i/8i) . Highly competent in Administration, Monitoring and specialized inAdvanced DBA skills such as Performance Tuning, Database Backup and Recovery, Data guard, Data Pump, RAC, Golden gate.
• Extensive experience in installation and configuration of Oracle 12c,11g, 10g, 9i, & 8i on production, test and development environments on SUNSOLARIS, HP - UX, IBM-AIX, WINDOWS, REDHAT-LINUX.
• Expertise in Migration and Upgradation databases to 12c, 11g and 10g.
• Strong skills in SQL* PLUS, SQL* Loader, UNIX Shell scripts (KSH and CSH), Import/Export Server Manager.
• Worked on Oracle E-Business suite EBS-12.2.3 release to help deploy and implement application projects and enhancements
• Proficient in maintenance of Production, Testing, Development, RAC, Standby databases/ DataGuard for OLTP and DATAWAREHOUSEusing customized shell scriptsand experienced in Data Modeling
• Good Experience in patching and upgradations.
• Applied Patch Set Updates to 10g and 11g oracle databases.
• Delivered SQL and Database performance tuning services via V$/GV$ views, Explain Plan, TKPROF, AWR (Stats pack) reports, ADDM, SQL Tuning Advisor, SQL Access, Oracle Enterprise Manager (OEM), Grid control, analyzed SQL trace dumps for 9i/10g/11g.
• Installed, configured and updated EXADATAmachines.
• Responsible for code efficiency and Data integrity for all deliverables
• Managing rollback segments redo log files, control files and data files.
• Managed Databases in the range from 50GB to 3TB.
• Experience in UNIX shell programming
• Expertise in Tuning the databases for optimal performance.
• Laid hands on new tools and experienced features like Data Replay, Log Miner and Flashback data Archive, Schema Management, Data guard and RMAN in Oracle 11g.
• Configured Data guard to provide high availability by implementing Physical stand by database.
• Excellent knowledge in Hot/Cold Backup and Recovery and Cloning of databases using RMAN.
• Design and Document backup and disaster recovery plans for critical databases using conventional HOT, COLD and RMAN backups
• Testing and implementing different physical and logical backup and recovery methods including point in time, media recovery, full/partial, export/import, expdp/impdp.
• Implementation of Flashback Technology and Created and monitored database objects like Tables, Indexes, Views, Users and DB links
• Experience in LOGICAL BACKUPS and Database migration tools with DATA PUMP.
• Extensive experience in migration of databases with export/import, expd/impdp, RMAN
• Managed resources for ongoing development of integration.
• Expert in Real Application Cluster (RAC) environment with Automatic Storage Management (ASM) on Oracle 10g and 11g.
• Utilized 11g new features like Real Application Testing (RAT) and Database Replay (DR) to validate database performance on new Hardware.
• Experience in Real Application Clusters (RAC) setup, configuration and cluster interconnection with Automatic Storage Management (ASM), configured user log on load balancing and failover on RAC database for high availability.
• Used Oracle Data Integrator for High performance batch loads.
• Handled magic tables in sql server.
• Good experience in Creation and Maintenance of Database Objects like Packages, Stored Procedures, Functions, Triggers, Database Link, Snapshot, Roles, Privileges, Tables, Constraints, Views and Indexes. Monitoring and managing local table partitioning
• Installation, Configuration and Maintenance of Oracle 9i/10g/11g RAC on two node and four node configurations.
• Used Automatic Workload Repository (AWR) & Automatic Database Diagnostic Monitor (ADDM) in RAC for Performance Tuning.
• Experience in Supporting Exadata, Oracle RAC and Golden Gate.
• Experience in conversion of Single Node Instance to Multi node RAC with ASM.
• Experience in Migration of Oracle Databases from non-RAC to RAC and non-ASM to ASM Instances
• Intensively used OEM Grid Control Diagnostic and tuning packs to tune the application and SQL queries.
• Expertise in Oracle Golden Gate installation, configuration, troubleshooting Golden Gate issues.
• Implemented data load by replication methods like Materialized views, Golden Gate from OLTP systems into data warehouse databases
• Experience in bi-directional and broadcast replication from source to target databases using Golden Gate 9.5 and Golden Gate 10.0.
• Experience in using Golden Gate in moving large volumes of transactional data, with minimal impact to online system.
• Possess good leadership, excellent communication and time management and presentation skills with excellent technical, analytical, interpersonal, problem solving and organizational skills
• Work 24 x7, weekends, late hours. Less guidance, documentation of methods, plans & daily work. Work in Team or as stand-alone person.

TECHNICAL SKILLS:

Operating Systems: Sun Solaris 9/10, HP-UX 11i v1.5, AIX 5.3/6.1/7.1, RHEL 3/4/5, Windows 2003Windows 2000/NT, Windows XP.

Databases: Oracle 12c,11g, 10g, 9i, 8i, Mysql, Microsoft Sql Server 2005, Oracle 12c/11g/10g Real Application Cluster (RAC), ASM

DB Utilities: SQL*LOADER, exp, imp, EXPDP, IMPDP, RMAN, Opatch,TKProf, UtlbstatUtlestat,Statspack, AWR, ADDM, QOPATCH, NID, DBVERIFY, SRVCTL, CRSCTL, ASMCMD, DBCA, ADRCI and DBUA

Scripting: Shell Scripting Korn & Bourne, C Shell

Tools: Oracle Enterprise Manager 10g/11g/12c, TOAD 8.5, SQL Developer, PuttySQL*PLUS, iSQL*Plus, ERWIN 4.14, SQL- Navigator, ERWIN, LogMiner and Flashback data Archive, Macromedia Flash, Quest Fog light, VERITAS Net Backup, Legato backup,Cisco Tidal, Performance and Web Portals, BMC Remedy, HP Quality Center Dream-weaver, MS Office, Joomla.

Languages: SQL,PL/SQL for Oracle, MYSQL, C, C++, XML.

PROFESSIONAL BACKGROUND:

Confidential, Arlington, VA

Sr. Oracle DBA

Responsibilities:

• Design, Implement and support multiple scalable, highly available, zero downtime, multi-site load balancing Oracle based 50+ TB Oracle Database systems using Oracle 10g/11g/12c including RAC and ASM, Golden gate.
• Installed 12c Databases and Responsible for upgrading Oracle 10g RAC to 11g RAC.
• Playing vital role in streamlining all the databases on AIX, HP-UX, Linux, and Solaris.
• Implemented backup and recovery procedures (Cold/Hot backups, RMAN Incremental backups & Import/Export).
• Worked closely with the system operations team on database deployment processes and database capacity planning.
• Maintained DATA GUARD to provide high availability by implementing physical stand-by database and snapshot-standby and worked with Oracle 11g features 11g Grid Control and Automatic Storage Management (ASM).
• Upgraded oracle 10g databases to oracle 11g R1 (11.1.0.6, 11.1.0.7) and 11g R2 (11.2.0.2).
• Upgraded oracle RAC databases from 10g to 11g
• Implemented Oracle 11g OPS Center and fully integrated hardware and storage Arrays to the Grid Control.
• Implemented backup and recovery procedures (Cold/Hot backups, RMAN Incremental backups & Import/Export).
• Scheduled database maintenance tasks such as tables/indexes analysis, index rebuild, materialized views refresh and db exports.
• Working with Database Monitoring tools like TOAD, BMC PATROL.
• Set up Active Dataguard Configurations for oracle database 11.2.0.3 for thirty databases whose size varies from 10TB to 30TB on a 6 node RAC.
• Installed and configured oracle 10g and 11g Management Agent (silent and Agent push) and cloned it to the multiple nodes.
• Installed oracle 10g Data Guard Physical Standby at DR site for production nodes.
• Maintained and monitored various production servers with Oracle 11g R1, 11g R2, 10g, and exadata servers.
• Performance tuning of oracle databases using Sql Access Advisor, Sql Performance Analyzer, sql Tuning Advisor.
• Identify Top SQL that are consuming heavy resources and provide support to the development team in identifying SQL queries that are consuming high resources and interact with the development team to see if these queries can be fine-tuned further
• Migrated the entire rdbms database to EXADATA machine.
• Creating and Managing Tablespaces with different block-sizes to prevent row chaining and row migration.
• Used ITIL problem management process to minimize the adverse impact of errors and to prevent recurring incidents related to that error.
• Worked on SQL, PL/SQL Programming and performance tuning
• Installing agent 12c on the server. Adding high Available database with CRS, scheduling Backups through OEM12c.
• Implemented RMAN Image Copy Backup Strategy for very large Databases in minimizing the downtime for recovery.
• Managed VLDB (Very Large Database) for large number of users.
• Implemented and administered Oracle Golden Gate (v10) for Database Replication between production and reporting node, by using Oracle Streams in parallel to secure data and having the availability of the database during regular the upgrade or maintenance operation.
• Worked on oracle 11g New Features for Administration and Tuning.
• Responsible for Capacity Planning and Upgrade of Hardware and storage Arrays.
• Applied Critical Patch Updates and Patch Set Update (CPU/PSU) on various platforms using Universal Installer and OPatch Utility.
• Handled Physical and Logical Corruptions and recovery using RMAN (Recovery Advisor).
• Responsible for managing databases on VCS Cluster and VCFS file systems.
• Written Shell scripts to Monitor activates like availability of database & listeners, space utilization, gathering statistic for the cost base optimizer, index rebuilding etc.
• Configured SNMP Agent on UNIX nodes for monitoring the server health and outages.
• Responsible for monitoring and administering EMC Storage Arrays using Navisphere.
• 24*7 Production Technical Support and Hardware Support.

Environment: Oracle 12c,11g R1,11g R2, SUN SPARC,, Sun STOREDGE 6140, 6130, 3500, EMC Storage, VERITAS NetBackup, Solaris 10, 9, 8 AIX 5.2, 5.3 BMC Patrol, 11g OPS center.

Confidential, Bedminster, NJ

Sr. Oracle DBA

Responsibilities:

• Supported 50+databases including RAC Production database, a data warehouse database and lot of Development and Test databases.
• Planning, Implementing and Validating various versions of Oracle Databases to 10gR2(10.2.0.4,)& 11g R1(11.1.0.7) & 11gR2 upgrades on all the environments (in a procedural approach Dev, Test, Stage and Production) also Planning of back out procedures like downgrades/building parallel environments and also working on proof of concept for Oracle 11g upgrades.
• Responsible for administration and supporting Oracle 11g, 10g RAC databases in DEV, QA, UAT and Prod environments.
• Scheduling and maintaining RMAN (Recovery Manager) backups to the FRA.
• Downsizing and defragmenting the Large Databases by export/import, cloning those using RMAN duplicate features and then upgrading them to Oracle 11g.
• Setup, configuration and maintenance of standby databases (Oracle Data Guard) to ensure disaster recovery, high availability and data protection.
• Proactive database monitoring using 11g grid monitoring tool.
• Utilized Oracle Enterprise Manager (OEM) to manage users, privileges, profiles, schemas
• Applied PSU patches to Oracle Databases and Oracle Applications.
• Database monitoring and performance tuning using OEM (Oracle Enterprise Manager), AWR and ADDM.
• Upgraded from 10g to 11g.
• With ITIL Configuration management process verify the configuration records, and provide accurate information support for all key process.
• Worked on Automatic Storage Management (ASM) for managing data in SAN.
• Used Tivoli Workload Scheduler for different os to perfume execution of track jobs on several environments.
• Monitoring and resolving tickets in different environments.
• Export and Import of database objects to copy from one database to another database between different environments.
• Planning Backup/Restoration Strategy, Scheduling Backups, Schema backups, taking Logical Backups (with Export/Import Data Pump utilities).
• Created Users, Groups, Roles, Profiles and assigned users to groups and granted privileges and permissions to appropriate groups.
• Used Change Management in oracle enterprise manager and oracle sql developer to reduce downtime caused by application changes.
• Validates the change against the target database to identify any discrepancies or conflicts by using Change Management.
• Used shell scripting to run plsql queries.
• Designed GOLDEN GATE data bases to meet business uses.
• Experience in recovering GOLDEN GATE corruptions and managing cluster maintenance mode blackouts.
• Created UNIX shell scripts to automate batch jobs through Cron.
• Developed and modified scripts to work efficiently for alerts for ORA error backup and recovery, automatic startup and shutdown databases.
• PL/SQLprogrammingto resolve various problems.
• Performing day-to-day database administration tasks like Table space usage, checking alert log, trace files, monitoring disk usage, Table/index analyze jobs, database backup logs etc.

Environment: Oracle 11g, 10g, Oracle RAC (11g), Oracle Enterprise Manager (OEM), IBM-AIX, Sun Solaris RMAN, Import/Export, ASM, AWR, STATSPACK, TOAD, Unix Scripting, SQL*Plus, PL/SQL.

Confidential, Albertville, AL

SR.Oracle DBA

Responsibilities:

• Planning, installation, configuration, management, troubleshooting and administering of 10g & 11g Oracle databases on Window OS
• 24x7 production testing and development support for several mission critical systems which utilize multiple Oracle databases.
• Performed CDC (Change Data Capture) along with data replication and MDM (Master Data Management) capabilities ofGolden Gate.
• Restored and recovered successfully production databases in Dataguard, RAC and ASM environment using RMAN. Converted successfully oracle databases from ASM to Non-ASM and Non-ASM to ASM database using RMAN.
• Usedadvanced features in Oracle 11g like RMAN,RAC etc.
• Installation and configuration of GOLDENGATECross Platforms.
• Tablespaces encrypted using Advance Security features.
• Set up & manage database security by creating new users, roles, profiles, and provide required user privileges using OEM and SQLPLUS
• Managed schema objects like tables, views, indexes using OEM and SQLPLUS
• Load and transfer data into the database by using data pump &SQL Loader utilities
• Applying ORACLE PSUpatches on both RAC and single machines.
• Upgrading the database from 10.2.0.4 to 11.2.0.2.
• Storage and space management including tablespaces and data files.
• Developed scripts for daily maintenance activity like analyzing the tables/indexes, and monitoring their growth rate.
• Experience in monitoring blocking sessions and killing them on the requirement basis.
• Experience with new features like Flash-Back Recovery like Flashback Transaction and Query.
• DBA activities including creation, management, startup and shutdown of Oracle databases, management of data files, redo log files, control files, table spaces, segments, extents and data blocks & physical storage, creation, monitoring.
• Golden Gate trouble shooting in production databases.
• Creation of DB console (OEM) for databases.
• Configuring databases and listeners in GRIDCONTROL.
• UNIX Shell scripts for monitoring the processes, sessions, transactions on Production RAC database after migration.
• Defined backup procedures using daily hot backups and weekly cold backups.
• Monitor and report on daily, weekly Backup and Recovery procedures for production, non-production databases using RMAN backups taking periodic complete, cumulative and differential incremental backups
• Use data pump utility to export and import data from the database
• Implemented database monitoring and tuning, application, and queries using ADDM, ASH, AWR, Explain Plan and OEM.
• Scheduling jobs in crontab by configuration in TSM, Networker.
• Performed database tuning using Explain Plan, Toad, and Enterprise Manager.
• Performed Database tuning using StatspackAWR and ADDM.
• Performed SQL Tuning using explain plan, TKPROF with SQL trace and SQL TuningAdvisor.

Environment: Oracle 9i/10g/11g, OEM,SunSolaris, and TOAD, Data Guard, RAC,ASM,Networker TSM, HPOV,grid control.

Confidential

Oracle DBA

Responsibilities:

• Install, Setup and configured 10g/11g RAC on Redhat and AIX using Automatic Storage Management (ASM).
• Provide support for all assigned projects, which also includes database backup and recovery, performance tuning, capacity planning and monitoring.
• Security compliance on all supported databases following internal and corporate security guidelines.
• Updating Database, Schema refresh and objects comparison using Erwin.
• Configured Oracle Grid and RMAN with TSM based on end-client environments.
• Tuned SGA by Library Cache, Dictionary Cache. Tuned OS by reducing paging/swapping. Tuned I/O which includes separation of data files and redo log files.
• Demonstrated experience in working on Root Cause Analysis for oracle database issues.
• Implementing database security and audit, removing default passwords, configuring permissions for binaries and secure other executables.
• Handled different magic tables to store data with help of triggers.
• Perform TSM Installation and configuration of server and clients including AIXv5.1 server and Windows NT, Solaris and HP UNIX clients. Administering TSM Server on a daily basis for reclamation, availability of tapes, tapes to be sent to safe site, to check whether backup schedule run properly, managing Tape Library.
• Using Query commands and Activity logs to check for problems and activities done.
• Provide solutions and service for configurations with TSM server involving more than 300 clients.
• Defining and modifying Barcode rules or labels for the Tape libraries to provide auto adding of new volumes.
• Deciding time for Backup process to take and implementing schedules accordingly.
• Writing Scripts with TSM server with queries to generate statistics and reports.
• Write scheduling scripts to supervise and schedule TSM tasks for backup and archive clients.
• Monitoring of Network performance of all clients for better backup performance.
• Creating Device classes and storage pools and registering nodes under TSM server.
• Restoration of Data for Users in the event of requirement or Systems crash.
• Documented AIX Servers, TSM Server and done Hardware labeling.

Environment: Oracle 10g/11g, HP-UX 11i, AIX 5.2, SQL Server 2005, J2EE, Erwin, TSM

Confidential

Database Administrator

Responsibilities:

• Responsible for, both manage and support 6 production databases and 15 development/test databases with sizes of databases varying from 50 GB to 550 GB.
• Installed and UpgradedShareplex (3.2 to 4.1) a replication tool for reporting environment.
• Perform daily administration support for database backups, performance tuning and monitoring
• Monitored and diagnosed database performance through monitoring of alertfiles, trace files.
• Created User accounts, Roles and granting required access permissions and privileges to the database based on the applications they are accessing.
• Worked with Data pump to take the logical backups of databases.
• Worked in performing Point in time recovery using RMAN.
• Used oracle configurationassistants like DBCA (Database Configuration Assistant) for Creating databases, DBUA (Database Upgrade Assistant) for Upgrading databases and NETCA (Network Configuration Assistant) for creating a Client-Server environment using Listener, TNSnames etc.
• Standby database setup via 10g data guard for database DisasterRecovery.
• Implemented shell scripts to reduce the time for large code movements during cut over tasks.
• Storage Management Managing Space, Tablespaces, Segments and Extents, Rollback Segments & Data Dictionary. Online/Offline Database Backups and managing database recovery with RMAN.
• Performance tuning via OEM, STATSPACK/AWR for 9i/10g/11g.
• Maintenance tasks like bouncing the production database, services through veritas.
• Effective in gathering the statistics for pinning the objects. Resolving listener and tnsnames.ora issues.
• SQL Server production database support & Troubleshooting SQL Server 7.0, 2000, 2005, 2008(R2), versions. Supporting high volume OLTP databases over 2TB; & OLAP 5TB
• SQL Server services Installation, applying Service pack and Patches/updates to fix bugs
• Created custom DBA script using DMVs, system tables for database management

Environment: Oracle 9i, 10g IBM-AIX, HP-UX, Windows 2000, RMAN, PL/SQL, Shell Scripting, exp/imp, SQL, SQL/PLUS, MS SQL