SUMMARY

• Over 8 years of experience as an Oracle Database Administrator on Oracle 9i, 10g, 11gR2 and 12c database servers in Production, Development and Test environment on multiple platforms and environments spanning Finance, IT, Health, Communication and Tech sectors.
• Experience as On - Call 24x7 production DBA support, application/development DBA
• Proficient in database administration, installation, configuration, upgrades, patches, performance tuning, backup and recovery, cloning, space management, troubleshooting, physical and logical database design wif RAC, ASM, Data Guard, Exadata, Golden Gate and Grid Control experience.
• Experience in Oracle 10g/11g RAC implementation, administration and troubleshooting RAC databases including Oracle Clusterware setup and configuration, RAC installation using ASM.
• Strong Oracle RAC Installation, Configuration and Tuning Skills on Red-Hat Linux and Sun Solaris.
• Experience in configuring database backups on RAC and physical standby database for RAC.
• Upgrading RAC databases from 10g to 11g and 11g to 12c.Configured and maintained physical standby databases using Oracle Data Guard to perform disaster recovery.
• Data Guard setup wif Primary and Standby Databases.
• Configured/instantiated Physical Standby database for RAC. Performed switch-over and switch-back from primary to its corresponding standby databases during maintenance window and also when required.
• Experience in configuring, managing and troubleshooting Golden Gate on multi-node RAC.
• Experience in using Golden Gate to support data replication monitoring, tuning and capacity planning in Oracle database.
• Upgrading Golden Gate software from 9.5 to 10.4, 10.4 to 11.1.
• Configured DDL, bi-directional and uni-directional replication from source to target database.
• Experience in using Golden Gate during Disaster Recovery scenario and performing History pull to sync-up data between Oracle to Non-Oracle databases.
• Experience in configuring Integrated Extract and Co-ordinated Replicate after upgrading Golden gate software to 12.1
• Experience in using RMAN (Recovery Manager) to perform Full and partial backups, Incremental and Cumulative backups and restoring teh database from backups.
• Experience in performing point in time recovery at times of necessity.
• Performed cross-platform migration and instantiation of standby database using RMAN.
• Created Clone databases in Dev and Test environments using RMAN cloning procedure as well as User manual cloning.
• 4 years of experience in dealing wif Performance Tuning.
• Worked on Performance optimization of large objects (LOB, BLOB, CLOB) by monitoring redo's generation, increasing log buffer size, blocksize and changing archiving procedures and Query tuning using Statspack, TKprof and OEM.
• Used oracle 11g tools like AWR, ADDM, Advisories, TKPROF, EXPLAIN PLAN for performance tuning of teh database and perform Root-cause-analysis for any issues.
• Experience in Migration of Database from 9i to 10g, 10g to 11g, NON-ASM to ASM and also across multiple platforms and resolving teh issues related to installation, upgrades and patches.
• Experience in Implementing Streams, ODI, Data Pump, Export and Import utilities.
• Experience in Flash-Back Recovery Area (FRA), creating & scheduling jobs through OEM.
• Experience of managing Oracle 10g/11g RAC environments using teh OEM Grid Control tools.
• Implemented cross platform data migrations using Transportable Table spaces.
• Proficient in SQL,PL/SQL, Perl Scripting, Shell Scripting, ERwin Data modeling, OLAP, Oracle Data Dictionary - meta data, Logical and Physical Database Design.
• Written shell scripts to monitor Oracle services, Golden Gate processes, to upgrade databases from 10g to 11g, to automate startup/shutdown of Oracle database, to migrate database from one server to another.
• Expertise in developing various Database objects like Triggers, Stored procedures, Functions, Sequences, Views etc.
• Experience in SQL Server Clustering and MS SQL Server 2000/2005 Log Shipping, Database Mirroring.

TECHNICAL SKILLS

Operating Systems: RHEL 3.x,4.x,5.x, Sun Solaris 8,9,10, HP-UX 10.x/11.x, AIX 4.3x/5.1/5.2, WINDOWS NT/2000/2003/2008/XP

RDBMS: Oracle 12c/11g/10g/9i/8i, Oracle 12c/11g/10g RAC, Microsoft SQL Server, Sybase, MySQL, DB2

Languages: SQL, PL/SQL, UNIX Shell Scripting

Network Protocols: HTTP, TCP/IP, FTP, SFTP, TELNET

Tools/Utilities: Oracle Golden Gate, Oracle Enterprise Manager (OEM), OEM Grid Control, Data Guard, Oracle Management Service (OMS), Real Application Clusters (RAC), Data Pump (expdp, impdp), Recovery Manager (RMAN), DBCA, DBUA, ASMCA, TOAD, SQL*Plus, Rapid SQL, SQL*Loader, Erwin, Autosys, Query Analyzer, VERITAS, NetBackup, ExaData, Developer 2000, Explain Plan, SQL Trace,TKProf, Statspack, AWR and ADDM, ASSM, Log miner, Win SCP, Putty, Informatica

PROFESSIONAL EXPERIENCE

Confidential, MN

Oracle DBA

Responsibilities:

• Configuration teh database onExadata and upgradingthe database from 10g to 11g.
• Configurations ofOracle restartfor all databases.
• Gathering Statistics usingBRTOOLS for SAP Databases.
• Setting up theSAP databases to Oracle Home.
• Configuration of Database wifFAST START FAIL OVERfor maximum availability.
• Manually configuration ofASMthrough commands.
• Installed and configuredSQL SERVER 2008R2, 2012 on windows 2008, 2003.
• Setup and maintainedDatabase Mirroringwif automatic failure andTransactional Replication.
• Adding teh Witnessserver to existing Mirroring.
• Extensively worked on Installation and Maintenance ofSQL Server 2012/2008R2 on Test, Development and Production Environments
• Database Backup and restores, and periodical database refreshes
• Refreshing teh Database fromproduction to Non ProductionusingAuto refresh Process.
• Configuration ofPhysical Standby databasefor maximum performance mode, Maximum Availability - Oracle Data Guard by using OEM 12c.
• Installation, ConfigurationandMaintenanceof OracleRDBMSandClientsoftware in various environments.
• Migrationofdatabasesfrom10g to 11gusingexport/importanddata pump export/importutilities
• Oracle Agent installationOEM 12c, ORACLE HOME, GRID HOME, SAPORACLEHOME.
• ConfigurationofActive and passive clustersfor Oracle Databases at Plant Locations.
• Worked on Operational side forDisk Space, Log Space, Blocking and Deadlock issues.
• Installed Various Service packs for SQL Server 2008 and 2005.
• Migrated SQL Server2005/2008/2008 R2 databases to 2012.
• Uselog shipping for synchronization of database.
• Managed Security usingSQL Logins, Roles and Security Modesfor various users.
• CreatedDatabase Maintenance Plansfor teh performance of SQL Server which coversDatabase Integrity checks, update database Statistics and Re-indexing.
• Patching SAP databases in AIX and LINUX server.
• Setup of Jobs using theOracle Enterprise Manager (OEM) 12c and 11g.Auto refresh processand RMAN backups inOEM 12c
• Weekly Data RefreshfromProduction to Development and Testenvironments usingdata pump export/import, Auto Refresh.
• Daily incremental backupandweekly full backupof databases usingRMAN
• Involved inmigration of applicationsof teh clients.
• Loading data into database tables usingSQL *Loader
• ImplementedMaterialized views, database links.
• Regular database management on10g and 11g OEM, 12c OEM.
• Performedday-to-day activitiessuch as creating users, roles, schemas, tables, views, indexes and rebuilding Indexes and running scripts given by teh clients.
• Table space monitoring,Performance monitoring and tuningfor performance improvement
• Creatingbatch filesandautomating teh tasks
• Granting roles and privilegesto end users
• Managing, troubleshooting and resolving oracle database and application issues.
• Daily health checkup of teh database usingTKPROF, AWR, ADDM.
• Monitoringalert log/system log.
• ManagingDatabase Locksandblocking sessions.

Confidential, IL

Oracle DBA

Responsibilities:

• Involved in 24x7 on-call support for production 10g and 11g RAC database using Oracle Enterprise Manager Grid Control Alert Monitoring and Notification System.
• Install, configure and support Oracle Databases for SAP Applications like MDM, BW, EP.
• Upgrade Oracle Databases and Client software for SAP Applications from 10gR2, 11gR2, applying SBPs and using BR*Tools for administration.
• Addressing and supporting both Test and Development tickets in co-ordination wif Application Development Team.
• Upgrading of Database from 10.2.0.5 to 11.2.0.1 Apply Patch set update to 11.2.0.2.
• Upgraded Golden Gate from v10.4 to v11.1.
• Installed, Setup, Configured Oracle version 11g Release2 64 Bit on SLES 10.
• Migrating from Oracle 10g Sun Solaris 10 to Oracle 11g SUSE Linux (SLES) 10.
• Supported 15 Terabyte Oracle Data Warehouse (Oracle 10g). Used Sybase Power Designer for development and support of Data Warehouse.
• Built Oracle MAA Physical Standby and Logical Standby and configure Data Guard Broker for High Availability/Disaster Recovery purpose.
• Perform planned switchover and failover to physical standby database wif and wifout Data Guard Broker to verify availability status.
• Extensively used Oracle 11gR2 features automatic SGA tuning, enhanced RMAN wif Flash Recovery Area, Block Change Tracking
• Merge backup, Oracle Data Pump, big file tablespaces, new EM Grid Control, Database Control, Studio Control, AWR, ADDM, SQL Tuning/Access Advisors, Flashback Database and several others.
• Monitoring and Troubleshooting of Database Replication issues.
• Performance Tuning of Oracle Database Objects using tools like EXPLAIN PLAN, SQL*TRACE, TKPROF, STATSPACK for optimized results.
• Working wif Application Development team to address any issues they encounter and provide support and resolution action plan.
• Resolve lock/latch and resource contention issues during production hours.
• Performed database cloning to setup test and development database.
• Rebuilding of Indexes for better performance, maintenance of Oracle Database.
• Creating and Managing Tablespaces wif different block-sizes to prevent row chaining.
• Wrote UNIX shell scripting to automate tasks and crontab and dbms scheduler for scheduling job.
• Write SQL scripts to monitor table space and extent growth.
• Applying Critical Patch Update (CPUs) every quarter in rolling mode wif no downtime.
• Data refresh from production to test and development.
• Installing and configuring Recovery Manager (RMAN) efficient backup strategy to disks and tapes using best business practice.
• Setting and Installing Oracle Enterprise Manager (OEM) -and Enterprise Backup Utility.
• Setting up new Development & Production environments.
• Generated scripts for daily maintenance activity like analyzing teh tables/indexes, and monitoring their growth rate.
• Automation of Startup Shutdown on all Production and Development Database.
• SQL Tuning for Performance of Objects.

Confidential

Junior Oracle DBA

Responsibilities:

• Installation of oracle 9i, 10g, 11g databases in production, development and test environments depending on project requirements.
• Refreshing development/test database from production using Export/Import & RMAN backups.
• Making structural changes to teh databases. Sizing database objects for effective space management and optimal performance.
• Managing database security.
• Creating and assigning appropriate roles and privileges to users depending on teh user activity.
• Defragmentation of tables and indexes for improved performance and effective space management.
• All Database Maintenance Activities to achieve optimum database uptime.
• Configuration of Listener and Tnsnames.
• Doing teh regular activities like monitoring teh alert logs, redo log status, listener. Log and checking teh space for normal segments, rollback segments and tablespaces.
• Created database link between two databases to access teh table data from one local database to remote database using distributed database feature.
• Planned database backups (operating system, full/partial backups, and export/import) using various types of backups and designed teh backup methodology for teh organization.
• Performed other Oracle DBA responsibilities performance tuning, monitoring tablespaces, monitoring users, etc. as well as much problem solving.
• Designed Logical and physical database for business transaction functionality.
• Provide production support for teh deployed project till it is stabilized.
• Written SQL scripts to create database objects like tables, views and sequences.
• Created procedures and functions using PL/SQL.
• Preparation of High Level & Low Level Design documents

Confidential

Database Analyst

Responsibilities:

• Administering client’s servers, databases and performing upgrades and tasks to resolve teh client issues wifin business hours.
• Restore servers, reconfigure databases, purge and Load data from one database to another.
• Adding space to file systems, logical volumes and segments. Monitoring files and space for all clients.
• Granting and Revoking different roles for user.
• Processing files through interface using crontab.
• Perform software troubleshooting on documented and undocumented issues affecting single or multiple machines.
• Perform hardware analysis to diagnose issue or identify sources of performance degradation.
• Replaces, upgrades or modifies hardware at own discretion.
• Provide network analysis for issues related to connectivity.
• Routinely investigates availability issues pertaining to domain/network resources, identify and resolve respective issues.
• Advanced desktop support to external customers visiting onsite, ensuring proper network connectivity regardless of system/OS.
• Evaluate and test new operating systems and other software’s, provide recommendation and if necessary implementation planning and assistance upon testing completion.
• Mitigate issues by updating, modifying, re-installing or removing software.
• Provide input and recommendations for departmental processes and procedures, considering impact on teh organization. Evaluates and implements best practices wif technology.
• Research, recommend and apply technical solutions to enhance productivity in meeting business needs