SUMMARY

• 8+ years of experience as Oracle Database administrator, having hands on experience in database administration, production support, installation, configuration, upgrades, performance tuning, backup and recovery, cloning, space management, and database security with Oracle (7,8,9i, 10g, 11g, 12c) on Sun Solaris, Red Hat Linux, HP - UX, AIX, and Windows 2000/2003/2008 Platform.
• Experience with RMAN, Oracle Enterprise Manager (OEM), RAC, OEMGrid control, Data warehousing, Oracle Data Guard.
• Proficient in space management, capacity planning, monitoring and management.
• Good experience in Data Migration using export/import.
• Management of Objects, Schemas, Partitioning the tables and Indexes.
• Oracle RAC Database Administration including Installation, configuration, Analysis, Design, Backup and Recovery (RMAN).
• Experience in database migration by designing and implementing database logical and physical storage structures.
• Experience in optimizing database access and allocates/re-allocates database resources for optimum configuration, database performance and cost.
• Expertise in data modeling and database designing.
• Strong Oracle PL/SQL development background besides DBA skills.
• Performance Monitoring and Tuning of Database, Application, System Global Area, I/O, Rollback segments using self-developed scripts, Oracle Enterprise Manager.
• Experience on Data Replication using Golden Gate and Oracle Streams. Hands on experience on setting up the environment for unidirectional, bidirectional propagation in Oracle Streams.
• Data loading using SQL*LOADER, Logical backups using full export and DATAPUMP.
• Experienced in using Oracle's Transportable Tablespace (TTS) feature allows users to quickly move a user Tablespace across Oracle databases.
• Implemented Golden Gate on Exadata.
• Migrated Exadata from V2 to X2.
• Experience in applying security patches to the databases.
• Effective troubleshooting of database and Performance problems.
• Expertise in performing Hot and cold backups with and without RMAN. Automated RMAN scripts using cronjob and implemented Veritas Net Backup to perform daily backups.
• Performed full, incremental and cumulative backups using RMAN.
• Expert in performing manual recovery using RMAN with and without catalogue.
• Experience with Oracle Advanced Security including Data Encryption, Data Authentication, and Data Integrity.
• Proficient in working with Data Guard for production system in case of disaster recovery, maintained primary and standby databases, Data Guard Broker.
• Experience in analyzing database & rebuilding indexes to improve database performance.
• Extensive knowledge of Oracle Architecture, SGA, PGA, LISTENER, TNSNames, V$ and DBA views.
• Applying oracle patches (CPU, PSU and ONE-OFF), upgrade and migration of databases using the OPatch utility and fixing bugs.
• Familiar with Data Warehousing (ETL), Data mining and OLTP concepts and ASM, SAN.
• Experience with Oracle /11gRAC/10gRAC/10g/9i/8i in Telecom, Financial and banking industries in both Business Intelligence/Data ware house Systems and OLTP Systems.
• Skilled in cloning of production databases for test and QA environments.
• Experience in different database refreshing mechanisms from PROD to various databases.
• Extensive experience using SQL* Loader, External Tables for data loading.
• Experience in user management which includes creating users, assigning roles and privileges.
• Experience in security management which includes auditing, role-based security and advanced security options like Data encryption to ensure data privacy.
• Skilled in MySQL, SQL Server Database Administration and tools like PL/SQL, TOAD.
• Worked with various UNIX operating systems (like Solaris, Linux RHEL 4.0, AIX, HP-UX, Tru64) also with Microsoft Windows 2000/2003/XP.
• Developed UNIX Shell scripts for day-to-day database administration tasks that include various Cron jobs for alert logs and performance, Backups, Restores and Recoverability.
• Experienced in system Monitoring and Database Performance Tuning using Explain plan, SQL Trace, Statspack, TKPROF, AWR, ADDM and ASH.
• Skilled in performing Logical backup using Traditional export/import and Datapump export/import.
• Experienced in applying patches including Patchsets and CPU/PSU, One-Off patches on Standalone, RAC and Standby Databases using Universal Installer and OPatch Utility.
• Configured and administered replication using Oracle Streams and Oracle GoldenGate technology.
• Experienced in Space Management, Resource management and Capacity Planning.
• Extensively worked with NETSTAT, NET Manager and Ping Utility to resolve network problems.
• Setup and Management of Auditing, Oracle Security and SQL Navigator. Job scheduling using corn utility and Shell Scripting for automating DBA tasks. Experienced in SQL/PL SQL programming.
• Worked on new advanced features including Load Balancing, Transparent Application Failover (TAF), Transparent Data Encryption (TDE) and Hardware Security Model (HSM).
• Excellent communication, analytical and interpersonal skills. Good team player and a highly motivated individual strong commitment to quality and customer service.
• Supported and provided Oracle DBA on-call after hours support for a 24x7 production environment.

TECHNICAL SKILLS

Operating Systems: HP-UX 10.x/11.x, Sun Solaris 8/9/10, AIX 5.2/5.3/6.1, Red Hat Linux RHEL 7.3/8/9, SUSE 10.0 and Windows NT/2000/2003.

RDBMS: Oracle 9i/10g/11g/12c Oracle 10g/11g Real Application Clusters (RAC)

Languages: SQL, MYSQL,PL/SQL, C, C++, XML, Unix Shell Scripting, Python, Perl, HTML

Software Applications/ Tools: OEM, DATAGUARD, Recovery Manager (RMAN), Data-pump, STATSPACK, ASH, AWR, TKPROF, ADDM, ERWIN, ETL, Clusters, EMC Storage, DTS, Developer 2000, SQL Loader, TOAD,SQL*LOADER, Erwin, putty, WinSCP3, SQL*PLUS, Net Backup, EXPLAIN PLAIN, OLTP, Oracle Golden Gate.

Protocols: FTP, SFTP, Ssh, Telnet, TCP/IP

PROFESSIONAL EXPERIENCE

Confidential, EDEN PRAIRIE, MN

Sr. Oracle Database Administrator

Responsibilities:

• Supported 100+ production instances (RAC) of very large databases.
• Involved in 24x7 support for production database with on-call pager.
• Successfully implemented oracle 11g grid control in different environments.
• Experienced in handling database issues using OEM as well as command prompt.
• Upgraded the databases to version 12c from 11g and 10g
• Installed, Setup, Configured Oracle version 12c Release2 64 Bit on Solaris 10 and RHEL 6
• Up-gradation and Migration of Database from 10g to 11gand then to 12c and also applying patches whenever required.
• Applying upgrade patches, maintenance and interim patches on all the databases.
• Worked on Automatic storage management (ASM) with EMC storage for managing data in SAN.
• Successfully implemented 11g RAC on nodes for high availability.
• Troubleshooting RAC environment, using srvctl, crs stat and crs profile.
• Responsible for setup and implementation of 2Node RAC on IBM-AIX in log and 11gR2 using Veritas cluster server.
• Monitoring and resolving TICKETS(CA Service Desk).
• Implemented RAC 3 node, 4 node and 7nodes cluster as well.
• Written a Shell Script to Monitor and auto start the OSWatcher.
• Performed cross platform migration from SOLARIS, AIX to LINUX in VIRTUAL MACHINES and migrated 300+ databases.
• Implemeted Golden Gate.
• Performed AUDITING on licenses for OEM (Tuning and Diagnostics pack)
• Installed and configured Oracle Golden Gate 11g. Configured Extract, Data pump and Replicate processes in a production environment.
• Installed and configured Oracle 12c Databases and Cloud control 12c to monitor all databases.
• Worked on Automatic Storage Management (ASM) for managing data in SAN, also used ASMCMD utility for monitoring the ASM, Installation of ASMLIB rpm packages.
• Migrating OCR, Voting disks and data ASM disk groups to a new SAN.
• Installed the data guard (11g) for disaster recovery and enabled dataguard broker. Tested the read only feature (11g) on standby databases, switch over, switch back and failover scenarios using dataguard broker utility DGMGRL .
• Implemented 10g,11g and 12c patching as per ORACLE Vendor suggestions.
• Worked on performance - tuning of Golden Gate.
• Participated in analysis and designing of Oracle Exadata Server for infrastructure and related projects.
• Integration of Exadata monitoring and escalation into existing IT monitoring and actionable events solutions.
• Performance tuning for optimized results using tools like EXPLAIN PLAN, SQL*Trace and TKPROF, STATSPACK.
• Lead DBA Team for Database upgrade project.
• Frequent audits on Functional users.
• Continuous Performance monitoring and tuning of the databases and application using OEM Tuning Pack, Diagnostics Pack, and STATSPACK.
• Installed and configured Oracle 12c database and cloud control 12c to monitor all databases.
• Applying RDBMS patches, security patches, sox reporting proactive monitoring of databases and applications.
• Implementing Oracle Identity Management applications.
• Experience in maintaining with high available databases.
• Loads databases, reorganizes as necessary, and assists in monitoring database performance
• Developing and Implementing Disaster Recovery (DR) Plan using DataGuard. and implemented physical standy database using DataGuard.
• Devised and Implemented backup strategies using hot, cold, and export based on the business requirements.
• Migrated data from old 10g environments to new 11gR2 environments using database cloning and DATAPUMP (EXPDP).
• Weekly refreshes of database and schemas using DATAPUMP (EXPDP).
• Taking logical backups using EXPDP
• Daily Health Check Up of the Database using staspack, AWR, ADDM & ASH.
• Rebuilding of Indexes for better performance, maintenance of Oracle Database.
• Implemented partitions on a table in production database in order to improve performance.
• Maintaining security of databases and users.
• Reading Alert Log and User trace Files and Diagnosing the Problem.
• Automation of Startup Shutdown on all Production and Development Database.
• Installation and configuration of Oracle Client software and Tools.
• Restoration of Data for users in the event of requirement or system crash.
• Written SQL scripts to monitor tablespace and extent growth.
• Worked with T-SQL statements like DELETE and UPDATE statements and also like BULK insert of data into the datable.
• Performance tuning which includes creating indexes, analyze, explain plan, optimizer hints.
• Lead DBA team to successfully patch Dev/stress/production databases.

Environment: Red Hat Linux, IBM-AIX,HP -UX 11.31, Solaris, MYSQL, Windows 2003/2008 server, Oracle 11g/12c, RAC, OEM, Grid Control, RMAN, DBCA, Data Guard, GoldenGate, Exadata, Putty, TOAD 8.1, UNIX, Linux 4.0, SQL Developer.

Confidential, Herndon, VA

Sr. Oracle Database Administrator

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 ofOracle Databases to 10gR2(10.2.0.4,)& 11g R1(11.1.0.7)&11gR2 upgradeson 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 forOracle 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.
• Helped customers in EBS migration
• Utilized Oracle Enterprise Manager (OEM) to manage users, privileges, profiles, schemas.
• Monitoring and managing of Oracle instances using Enterprise Manager Grid Control (OEM grid) 10g /11g/12c.
• Starting and stopping the agents to clear metric alerts and collecting ADDM reports in OEM.
• Installed Golden Gate for replication of database on 11gR2 RAC environment.
• Involved in Tuning the RAC interconnect Finding RAC wait events. And Tuning the RAC using the Enterprise Manager Grid Control.
• Configured parameters for the Bi-directional replication using Golden-Gate.
• Implemented Golden Gate for Active-Active Replication between the Datacenter for High Availability.
• Worked on Oracle Exadata Backup Configuration utility.
• Implemented physical standby database for maximum availability using Oracle Data Guard 11g with Oracle Enterprise Manager (OEM) 12C cloud Control.
• Used Explain Plan, Oracle hints and creation of new indexes, identifying the join methods (Nested/Hash/Merge join/Sort merge join) between the row sources for tables, to improve the performance of SQL statements.
• Proactive database monitoring using automated scripts based on v$views.
• Developer Environments setup using database cloning.
• Applied PSU patches to Oracle Databases and Oracle Applications.
• Database monitoring and performance tuning using OEM (Oracle Enterprise Manager), AWR and ADDM..
• 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.
• Captured and restored data backups using mongo db.
• Export and Import of database objects to copy from one database to another database between different environments.
• Responsible for Capacity Planning and Upgrade of Hardware and storage Arrays.
• Scheduling and maintaining RMAN (Recovery Manager) backups to the FRA.
• Setup, configuration and maintenance of standby databases (Oracle Data Guard) to ensure disaster recovery, high availability and data protection.
• Installed Oracle Discoverer and Integrated with EBS.
• Installed, Configured and Managed11g Oracle Enterprise Manager (OEM) grid control for Performance, Administration and Maintenance of Databases. Successfully maintained multiple databases. Experienced in working with tools like TOAD.
• Conducted analysis and feasibility studies for development of Oracle Exadata solutions.
• Implement “Stored Procedures and Triggers” based on business plans using PL/SQL.
• 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.
• 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, NY

Sr. Oracle DBA

Responsibilities:

• Upgraded databases from 10.2.0.4 to 11g R2
• Installed, configured and maintained 11g R2 databases on standalone servers and Real Application Cluster (RAC) 2 Node RAC
• Managed Oracle Real Application Cluster (2 Node RAC) running on ASM storage
• Hands on experience in migrating Non-RAC environments to RAC environments both manually and by using R-CONFIG
• Created custom services on RAC database for distribution of load across the nodes
• Installed Oracle and grid software on standalone servers on ASM and file system.
• Performed activities on ASM, creating disk group with different Redundancy Levels/using Fail group, adding a disk to a disk group, making disks online/offline and mount/dismount disk groups as SYSASM
• Having good experience in build stage, installed Oracle databases on ASM using DBCA.
• Maintained Production and Development Oracle databases.
• Used OWB repository from 10g to 11.2.0.3
• Supporting more than 125 production and development databases on 10g and 11g.
• 24*7 on-call production database support and maintenance including remote database support.
• Worked as lead DBA for off-shore team.
• Setup and managed replication among several databases
• Converted physical Standby to Snapshot standby for testing process.
• Used new features in Oracle Data-Pump for export and import.
• Involved in creating Golden Gate EXTRACT and REPLICAT files.
• Resolving the conflicts between the target and source database in Oracle Golden Gate
• Created new GoldenGate processes for new tables, implemented DDL Replication between Source and Target Instances
• Upgraded Oracle10.2.0.2 database to 10.2.0.4 and applied Patches using OPatch Utility.
• Using Automatic Shared Memory Management (ASMM) for optimal use of available SGA memory.
• Maintained catalog server and registered database in catalog.
• Used SQL Tuning Advisor and SQL Access Advisor to fix bad SQL
• Used Oracle Enterprise Manager 10g/11g Grid Control to monitor databases.
• Worked on Performance Tuning Oracle DBA (11g &10g) on Solaris 10, AIX 5.2.
• Worked on Performance analysis using AWR/ASH/ADDM reports and wait event analysis.
• Used EXPORT/IMPORT to do table level and full database defragmentation.
• Used Datapump new features, Remap Tablespace, Remap Table, Remap Schema, Parallel while refreshing data between different environments
• Used Transportable Tablespaces to migrate tablespaces from one database to another.
• Working Experience with latest TOAD having new features, Database Health Checkup, ASM Manager, Diagnose Extents, Segment Advisor, SGA Trace.
• Used TKPROF to analyze tracefiles and tuned long running Queries on Database.
• Familiar with SNAPSHOT TOO OLD error, involved in tuning this error
• Developed a bunch of Index monitoring scripts in order to sort out the unused space occupied in tablespaces
• Tested database performance issues (monitoring and tuning) to ensure database optimization.
• Performed exports/imports, hot/cold backups and recovery of Corrupted Blocks using RMAN.
• Created Materialized Views and fine-tuned them for better performance
• Functionality testing has been performed against the identified modules.
• Tuning SQL statements using Explain Plan and STATSPACK
• Modified SQL*Loader control scripts to eliminate while spaces generally used for data loading.
• Created DBLinks to access remote data and bit-map Indexes for data warehouse databases
• Implemented database refresh with the hot backup using full export.
• Developed database monitoring/health check alert scripts for database uptime/downtime status, and sizing issues using grid control (OEM)
• Performed administrative maintenance, monitoring on Oracle database systems in a global 24x7 operational environment.

Environment: Oracle 10g/11gR1, R2 RAC on AIX/Linux, Windows server 2003,RMAN, ASM, Data Guard, Golden Gate, UNIX Shell Scripting, TKPROF, ORA-01555, SQLPROFILE, Quest Toad, PL/SQL Developer, OEM, Windows NT/XP.

Confidential, Cincinnati, OH

Oracle Database Administrator

Responsibilities:

• Installed Oracle cluster services and implemented 2node RAC 11g on ASM on RHEL 5.2 and AIX.
• Responsible for maintaining Oracle 11.2.0.2 using SRVCTL, Oracle Enterprise Manager (OEM) Grid Control, maintaining Oracle Cluster ware using CRSCTL.
• Implemented Data Guard/Standby solution for Disaster Recovery.
• Applied appropriate patchsets whenever required and installed interim patches for particular bugs using OPatch by referring to MOS.
• Setup streams environment for unidirectional and bidirectional propagation and resolved conflict issues.
• Evaluated Golden Gate for future purposes that is for reducing the complexity involved in Oracle Streams.
• Configured RMAN which includes planning, testing and implementing different backup and recovery strategies such as compressible backups, fast and efficient incremental backups, and point in time recoveries (Table space point in time recovery).
• Identified the long running transaction through V$session longops and also for Rollback monitoring which is an enhanced feature of Oracle 10g.
• Installed, configured and managed OEM (Oracle Enterprise Manager) for routine administration, database monitoring, replication process and performance tuning.
• Configured initial and incremental load using GoldenGate.
• Involved in NoSQL and relational data modeling.
• Support modules for implementation using PL/SQL Scripts, Unix Shell Scripts and Pro*C.
• Creating database packages, procedures, functions, triggers, views, materialized views using Oracle PL/SQL.
• Installed, configured, supported and troubleshoot databases on Veritas Cluster on top of Solaris 9.
• Monitored and troubleshot top CPU/memory consuming processes.
• Extracted data from OLTP Database and loaded data into OLAP DB’s using PL/SQL scripts (ETL Methodology).
• Scheduling Automatic scripts for GoldenGate reboot.
• Tuning of data load jobs using SQL* Loader and correcting errors on replicated environment.
• Migrated databases from 10g to 11g using transportable table space and datapump.
• Implemented Oracle Advanced Security Options such as Data Encryption etc.
• Performed database and application tuning using EXPLAIN PLAN, TKPROF and analyzing the reports generated by AWR, ASH, RDA, ADDM and STATSPACK.
• Performed data migration, refresh using datapump and oracle export/import.
• Configured network Service names and created Database links for application users.
• Supported SQL Server administration.
• Maintenance of Oracle databases which includes rebuilding of indexes, partitioning of large tables, implementing materialized views and space management.
• Performed cloning of production databases for test and QA environments.
• Automating the routine DBA tasks through cron utility, autosys.
• Prepared documentation for ongoing maintenance and support.
• On-Call 24x7 DBA support for production databases in data warehouse environments.
• Worked with the users and guided them in preparing optimal queries for better performance.
• Coordinated with end user and Confidential to resolve application and performance issues.
• Excellent communication, ability to work in a team and interpersonal skills.

Environment: Oracle 11g/10g RAC, RHEL 5.x, AIX 5.2, ASM, VERITAS NetBackup, Golden Gate, OEM Grid Control, Data Guard, Autosys, AWR, STATSPACK, SQL*Loader, SQL, PL/SQL and Shell Scripting

Confidential

Oracle Database Administrator

Responsibilities:

• Assisted in installation and configuring ORACLE 9i/10g on Linux and Windows NT.
• Performed data modeling, system design using entity relationship diagrams, data flow diagrams, Normalization for reducing data redundancy in database objects.
• Assisted in migrating databases from Oracle 7.3, 8i to 9i and 10g.
• Maintenance and Administration of Oracle Databases for Developers and Testers.
• Upgraded databases from Oracle 8i to 9i. Other activities like applying RDBMS patches, security patches, proactive monitoring of databases and applications.
• Involved in creation of Data Warehouse database (Physical Model, Logical Model) using Erwin data modeling tool.
• Supported and troubleshoot databases on VERITAS Cluster on top of Solaris 8.
• Cloned/Refreshed Database environments to create patch, test, development and QA environments.
• Planned and implemented backup and recovery strategies using RMAN.
• Implemented logical backups using Oracle export/import utilities.
• Installed, configured and managed OEM (Oracle Enterprise Manager) for routine administration, database monitoring, replication process and performance tuning.
• Tuned SQL statements using explain plan and Tkprof. Monitoring and Performance tuning.
• Designed, developed and maintained UNIX shell scripts to collect and monitor database metrics and Statspack snapshots and reports.
• Installed and controlled Grid Control to monitor RAC and Non RAC instances patched and upgraded the grid control.
• Configured and troubleshoot ASM Cluster File System (ACFS) for Grid/RAC cluster.
• Writing Oracle scripts for the SQL and PL/SQL requirements for various applications.
• Modify Oracle PL/SQL Procedures and Functions as per the client requirements.
• Refreshed tables using materialized views.
• Hands on experience on performing database and application tuning by analyzing the reports generated by STATSPACK.
• Performed partitioning of large tables for increased performance.
• Assisted in writing scripts for database jobs and scheduling them through cron utility.
• Unloaded data using UTL FILE.
• Assisted in creating users, granting roles and the necessary user management.

Environment: Oracle 10g/9i/8i, Linux, Windows NT/2000, RMAN, STATSPACK, Export/import utilities.