SUMMARY

• Over 8 years of technical/consulting experience as Oracle Database Administrator, Data Analyst, Data Modeling and Data Migration in Oracle 9i/10g/11g on Linux, UNIX, Windows.
• Fulfilled DBA daily activities including user management creating users, synonyms, privileges, roles, quotas, table, index, sequence etc., space management, and monitoring
• Performing capacity Planning, Backup/Recovery strategies using RMAN and conventional Oracle Hot and Cold backup and Export/Import.
• Performance tuning of Oracle 10g/11g databases, reviewing Statspack/AWR report for resolving performance bottlenecks and involved in SQL tuning
• Experience in different Database backups such as User managed backups, RMAN backups, Operating System backups, Hot and Cold backups, full backup, incremental and cumulative backup and also FLASHBACK recovery features
• Implemented Data Guard Physical Standby for RAC databases.
• Experience in Performance Tuning of database, instances, SGA, I/O, and Rollback segment using different methods and detecting locks
• Implemented High Availability/Disaster recovery using RAC, Physical Logical standby databases Oracle Data Guard
• Installation, Configuration and administration of Oracle Golden Gate.
• Experience with High Availability features RAC/DG/ASM /Flashback /RMAN.
• Rebuilding of Indexes for better performance, User Management, Table space management, maintenance of Oracle Database.
• Expert skills onOracle Data Guardimplementation by the log shipping process between primary andstandbyand for disaster recovery DR .
• Involved in capacity and resource planning. Estimated the size of data files and redo log files considering transactions rate, transaction records size, transaction type, and volatility of the data, recovery time allowed etc.
• Experience in performing crash recoveries without data loss
• Performance tuning using, SQL Trace, Explain Plan, STATS PACK, AWR, ADDM
• Experience in different phases of Software Development Life Cycle which include Analysis, Design, Development and Testing and working closely in implementing DB Auditing and Compliance as well as Oracle and system Security enhancement
• Implementation of Oracle Backup and Recovery strategies using RMAN with Data Guard in RAC environment
• Monitoring Reorganizing Tablespaces/Tables/Indexes and Granted Users the resources by Creating Profiles, Managing Sessions, Privileges and Roles.
• Strong experience in using tools such as SQL Plus, TOAD, TKPROF, RMAN and Export/Import
• Exprience in implementing and using of Oracle 10g new features like Data Pump, ASM, Flash Back Technology, Transportable Tablespaces and Automatic Workload Repository
• Strong ability to understand new concepts and applications. Good communication skills to work independently and in a team environment
• Experience with Real Application Testing RAT
• Implemented a standby database operation using Oracle9i, 10g Data Guard for data loss and also provides graceful switchover and switchback between sites for a planned OS and hardware maintenance
• Upgraded 10g databases to 11g
• Proficient in Capacity planning and bench marking
• Refresh and Cloning using Datapump and RMAN with Commvault, VERITAS Net Backup TSM
• Provided 24/7 on call support for very large databases VLDB and Data Warehouse environments.

TECHNICAL SKILLS

LANGUAGES: SQL, PL/SQL, PERL SCRIPTING

DATABASE: ORACLE 11G RAC/10G RAC/9I/8.X, MS ACCESS

OPERATING SYSTEM: UNIX, SOLARIS, AIX, HP - UNIX, LINUX, WINDOWS 2005/2003/XP/2000

TOOLS: TOAD, SQL PLUS, SQL NAVIGATOR, OEM, OEM12C

TUNING TOOLS: EXPLAIN PLAN, STATSPACK, ASH, AWR, ADDM

TOOLS: /UTILITIES: RMAN, ASM, GRID CONTROL, GOLDEN GATE, EXP, IMP, EXPDP, IMPDP

PROFESSIONAL EXPERIENCE

Confidential, Richardson, TX

Sr. Oracle Database Administrator

Responsibilities:

• Extensive Responsible in configuring and backing up database using RMAN for hot backups, cold backups and logical backups
• Using the backend programming like SQL, PL/SQL, writing stored packages, procedures, functions, and triggers in a multi-tier environments
• Created users, granted roles and privilege management. Maintained user accounts and privileges to maintain application security.
• Responsible for Monitoring 24/7 Production Support and Performed upgrades from Oracle 10g to 11g and applied patches
• Oracle utilities i.e. export/import Data Pump, Flash Back Recovery, SQL, Data Guard, ASM and OEM
• Estimate growth of database size by detail analysis of the company's future policies and generating reports for the management to act in advance
• Install, upgrade and maintain Oracle 11g R2 on Windows 2008R2, Redhat5.
• Implementing Database Security, Management of role-based security
• Setup and configured replication using GoldenGate and Data Guard in physical and logical mode.
• Cloned schemas, objects and data on new server using exports from 9i database and imported in 10g using Oracle data pumps
• Usage of Partitions to improve the query performance and manageability.
• SME on partitioning Advanced Compression and other core DBA functions.
• Cloning databases using scripts as well as RMAN. Installation, setup and configuration of Data guard.
• Implementing automated backups with RMAN using crontabs
• Management of schemas, objects partitioning the Tables & Indexes.
• Worked on Advanced Replication including synchronous and asynchronous scenarios.
• Security User Management, Privileges, Roles, Auditing, Profiling, Authentication.
• Deployed and configuring database entries and monitoring of the databases using Oracle Enterprise Manager (12cOEM).
• On-Call 24x7 DBA support for very large databases.
• Creating database objects in operational data store and maintaining them in Golden Gate.
• Performed Data Migration as a part of enterprise data warehouse project.
• Developed tools to migrate the data from legacy systems to oracle database.
• Writing SQL*Loader scripts to load the external files into the Oracle Database
• Using SQL Loader for populating static tables and fact tables
• Implemented Initial DataLoad, Batch/Online replication, Security in Golden Gate

Environment: Oracle12c, OEM 12c, Oracle 11g/10g/9i, HP UX 11.31/ RHEL 5.4, Windows 2008, RAC, Data guard Grid control RMAN, Export/Import, ASM Packages. Tivoli backup, SQL*Loader, ASM, Data guard, Data pump, Golden Gate and Exadata.

Confidential, Bloomington, IL

Oracle Database Administrator

Responsibilities:

• Hands on experience using Oracle Enterprise Manager 12C OEM, SQL PLUS, TOAD and Grid Controlling using OEM
• Responsible for Load and Performance testing of the database servers and application servers, analysis and documentation of results
• Regular DBA activities like Undo segments, Rollback segments, database auditing, space management, database issues, locking, managing user groups and tuning
• Create & Managing Database Structure, Storage Allocation, Table/Index segments, Rollback segments, Constraints, Database Access, Roles and Privileges.
• Administer Active Directory and DNS for TIERS servers and supports LDAP / Windows Directory as it relates to TIERS Operations.
• Applying Patches to 10g/11g on Oracle database.
• Creating and maintaining Materialized Views for replication.
• Run the Oracle STATSPACK on the Oracle Instances to find out the System Performance Statistics during the peak load times.
• Use of Data Guard Manager, 9i and 10g Data Encryption.
• RMAN Duplicate database and RMAN duplicate Standby database.
• Partitioning Strategies for very large tables.
• Documented policies and procedures for each project including recovery in case of disaster using procedures,such as daily script creation of control files and copying, binary control files to backup directories, database copying, and renaming a database on different servers
• Responsible to review security policy for database users using Profiles, Roles, Privileges.
• Trace the frequently called procedures/packages and pinning them to improve the performance
• Manage updates and configure alert responses for all database systems, ensuring optimal security and backup.
• Migrating data using RMAN transportable tablespace.
• Created multiple Raid levels using volume manager
• Implemented different Partition methodologies to improve performance and manageability.
• Supported development effort by providing SQL statement tuning and optimizing ETL procedures and removing load and query performance bottlenecks by using tools Explain Plan, SQL Trace, TKPROF, TOAD and Oracle Enterprise Manager
• Refreshing schema’s in non-production environment with production backup.

Environment: Oracle 11g/10g, Cisco Blade server Oracle Enterprise Linux, RMAN/10g Enterprise manager, Cisco Load balancer

Confidential, New York, NY

Oracle Database Administrator

Responsibilities:

• Perform Backup and Recovery of Primary and Standby Databases using RMAN and external backup using NETBACKUP.
• Involved in Design, implementation and generating documentation of Oracle 10g, 11g Data Guard on both physical/logical standby databases in high availability mode
• Worked with IT managers and application developers to ensure the database integrity, high availability and security
• Manage and maintain database and user security using OEM Grid Control.
• Data Loading using SQL*Loader and DBVERIFY for corruption checking
• Responsible for network configuration and involved in a Client Server environment using TNS, LISTNER, Net Configuration Assistant and other configuration files
• Applying upgrade patches, maintenance and interim on all the databases
• Implemented database auditing, data security and Remediate high-risk violation in production environment and Gathering schema stats and monitoring the index usage
• Cloningduplicatingdatabases using scripts as well as RMAN
• Designed physical and logical database structures and created, managed Tablespaces.
• Documented backup and recovery plans and tuning procedures.
• Helped create and manage systems and guidelines to ensure host network was protected and to prevent unauthorized access to LAN/WAN systems
• Gathering schema stats and monitoring the index usage.
• Involved in reorganizing the tables and rebuilding the indexes that are highly fragmented to improve the performance
• 24 x 7 production support group member supported by our team.
• Converting datafiles across different platform using RMAN convert, Transportable Tablespaces (TTS), Export/Import and Datapump (expdp/impdp)
• Installed Oracle 11g database in the test environment and tested the upgrade from Oracle 10g to 11g.
• Monitored production database using AWR and ADDM for Daily or weekly tuning needs.
• Configured database targets in the ORACLE Enterprise Manager OEM .
• Writing backend procedures, functions, packages and triggers using PL/SQL and kshell scripts for automatic recovery.
• Migration of Database from 9.2.0.6 to 10.2.0.2 (RAC)
• Worked extensively on monitoring 10G grid control database, configuration of error notifications, installing listeners, and adding them to the grid control.
• Applied High priority patches downloaded from Metalink.
• Planned and implemented Disaster Recovery solutions using Oracle Standby Database/Dataguard.

Environment: Oracle 10g/9i, Oracle 10g RAC, ASM, Red Hat Linux 4.x, HP-UX 11, Windows 2003, AIX, Data Warehouse, ERWin, Netbackup, OEM, SQL*Loader, Grid Control, RMAN, ASM, Dataguard, TOAD, Datapump.

Confidential

Oracle Database Administrator

Responsibilities:

• Monitored and performed database sizing, tablespace management and undo tablespace management, transaction management and security administration.
• Experienced working on non-prod databases which are resided on Virtual Machines and understanding the working process
• Duplication of Databases from Production RAC to test RAC using RMAN active cloning.
• Supporting and Monitoring data loading, Creating /Analyzing /Scheduling reports, User management, performance tuning using Data warehouse Administrative Control DAC
• Also, provided support to customers to manage their operational data ranging from GB to TB in Oracle database, solving of space problem, data loading problem Experience with building, installation, upgrade, and patching of Oracle
• Analyzed SQL queries causing performance problems
• Involved in design and enforcing of standards in place to ensure that all application design and code is produced with proper integrity, security and performance
• Applied patches both Server side and Client side.
• Cloned databases using scripts as well as RMAN. Installation, setup and configuration of Data guard.
• Converting dictionary-based tablespaces to locally managed tablespaces to eliminate fragmentation, betterperformance and reduced maintenance.
• Supported the Upgradation from Oracle Server 8i and then to 9i/10g
• Used Oracle Advanced replication feature to set up multi-master replication, dealt with conflict resolution and performance issues.
• Applying Quarterly security Patches CPU/PSU and applying Patch set and One-off Patches
• Supported Security User Management, Privileges, Roles, Auditing, Profiling, Authentication.
• Worked on in house installation of Oracle on different platforms, loaded user data to reproduce the problem, applied new Oracle patch, managed database backup using RMAN, upgraded Oracle database, prepared Oracle database environment for the application analyst.
• Refreshed schema using Export/Import. Created the database, tablespace, tables, indexes, set privileges and user logins.
• Involved in Performance tuning which includes creating indexes, analyze, explain plan, optimizer hints
• Loaded data from flat file to Oracle database using SQL Loader. Created indexes on tables for performance tuning. Performance monitoring, tuning and space management in database with Grid control. Performed Troubleshooting and system maintenance.
• Designing Data conversion Interface with the use of SQL Loader, and Open Interface, and convert data.
• Provided technical support for Oracle Server to customers for Production Database.
• Modified SQL*Loader control scripts to eliminate while spaces generally used for data loading

Environment: Red Hat, Oracle 9i/10gR2, Oracle Enterprise Manager, RMAN, SQL*Plus, PL/SQL, SQL*Loader, Toad 9.

Confidential

Oracle Database Administrator

Responsibilities:

• Responding immediately to any critical conditions, and proactively to any developing conditions, including: Database locking, Database corruption, Low diskspaces and Performance issues.
• Intensively used latest 10g Automatic Workload Repository (AWR) & Automatic Database Diagnostic Monitoring (ADDM) reports for the health check of the databases, and used the notification tool to send the alerts in OEM Grid Control
• Checking of Alert log and Trace files to monitor the database on a daily basis. Also wrote monitoring scripts to Check reports for Space, Max. Extents, coalescing which are kept in CRONJOB
• Database migration from Windows to Linux using exp/imp and Datapump
• Provide Primary CARE DBA support for Oracle Administration, Configuration and Maintenance of RAC Real Application Cluster and Non-RAC Databases. Work within the production support team and maintain operational consistency and efficiency.
• Performed Tuning, coding and Monitoring for Oracle Real Application Clusters (RAC) nodes, Production Standalone Servers via Toad
• Oracle database upgrade from 9i to oracle10g.
• Creating databases, objects, roles and privileges.
• Monitoring Scheduled jobs of the daily activities for the performance of all the databases.
• Managed all database activities required to support release of new applications to production servers.
• Creation of Users and Granting them privileges and roles.
• Cloned/Refreshed Database environments to create patch, test, development and QA environments.
• Responsible for writing database programming to Store/Retrieve the information from the database using SQL.
• Writing shell scripts to automate the data loading.
• Expertise in implementing data refreshes (atdatabase, schema & table level) using RMAN utility and Datapump, conventional Export/Import ofOracle11g, 10g.
• Monitoring the data loading jobs and tuning the Sql queries.
• Responsible for managing production, development & test databases and applications.
• Creation of Table space, Data files, Indexes and monitoring them.
• Configured scripts to monitor activity with database.
• Installed and ImplementedBACKUP RECOVERYprocedures. ImplementHOT, COLDand Logical backup plans.
• Used Oracle UTL file features to create flat files and Procedures for Data Extraction.
• Implement Hot, Cold and RMAN Logical backup plans
• Designing and creating schema objects like Database tables, indexes, views, synonyms, and all schema objects in Oracle.

Environment: Oracle 9i/10g, SQL Server 2005, IBM AIX UNIX, TOAD, OEM, SQL*PLUS, Explain Plan, UNIX Shell Scripting, Quest software tools, PL/SQL navigator.