Synopsis:

• Quantified 8 years of Proficient Oracle Database Administrator having hands on experience on Database Installation Management, Real Application Cluster Management RAC Automatic Storage Management ASM , Setting up and Configuring Data guard, Replication Using Golden gate, RMAN Backup Cloning, Datapump, Upgradation, Migration, Patch execution PSU CPU and Performance tuning.
• Flexible with database administration of Oracle 12c, 11g, 10g 9i in very large scale database environment and to run vital day-to-day on in Online Transaction Processing OLTP and Online Analytical Processing OLAP systems.
• Worked on distinguished platforms alike HP-UX, AIX, Sun Solaris, RED HAT Linux and Oracle Enterprise Linux OEL and Windows.
• Installed and maintained Oracle 12c/11gR1/2/10g/9i , RAC with ASM Oracle Cluster File system2 OCFS2 .
• Excellent experience in configuring and tuning of Oracle 10g/11g RAC, CRS and ASM for high availability database.
• Created a Clone Database using RMAN on remote Server using SRVCTL commands for Real Application Cluster RAC Databases.
• Monitoring Health checks of OCR, VOTING DISKS and Interconnect for better performance and troubleshooting issues in RAC environment.
• Skillful in employing ORACLE STREAMS for replication and two types of standby databases logical standby and physical standby databases supported by DATAGUARD for Disaster Recovery DR and High availability HA .
• Troubleshooting and performed switchover/failover using Data Guard manager command line and Graphical User Interface GUI .
• Hands on experience in Oracle Golden Gate installation, configuration, troubleshooting Golden Gate EXTRACTS,PUMPS and REPLICAT issues.
• Comprehensive experience in Database backup and recovery User-managed , RMAN Backup, Recovery Cloning with/without catalog database.
• Executed Logical Backup using Data Pump Utilities Export/Import and Physical Backup Cold/Hot/Full/Incremental/ Cumulative backup strategies in 11g/10g/9i.
• Configuring Backup Retention Policy, planned strategies for Incremental Backups of Data files and Rolling Forward Image Copies of Data files and Performing and Scheduling Backups with Enterprise Manager
• Upgraded database from 11.1.0.6 to 11.1.0.7 and applied a PSU patch set from 11.2.0.3.1 to 11.2.0.3.9.
• Performed Oracle Cross-platform Migration from Oracle 10g R2 on Solaris to the same version on Linux followed by Upgrading to 11g Both platforms were x86-64 .
• Writing scripts in UNIX Shell Scripting cron, awk, scp, kill, top for managing the user roles and privileges, scheduled backups using Data pump /cold backups , manage statistics Disk space management.
• Creating PL/SQL packages, Stored Procedures, Functions, Triggers and Views to retrieve, manipulate and migrate complex data sets in Oracle Databases about 4 years.
• Prompt and attentive in Oracle Installations, Upgrades, Patch set updates-Critical Patch Updates CPU in an assorted environments.
• Proficient in setting up the Network configuration Listener TCP/IP Connections .
• Data transferring and Refreshing with export/import utilities, Data Pump and Data loading using SQL Loader and External tables.
• 6 Years of experience in Performance tuning of the database - SQL Tuning, Used Tuning utilities like STATSPACK, UTLESTAT interpret Automatic Workload Repository AWR , Automatic Database Diagnostic Monitor ADDM reports , Tuning of SGA, distribution of disk I/O, Resizing of tables and indexes.
• Expertise in Using EXPLAIN PLAN for query optimization and Performance diagnostic tools like SQL Trace and TKPROF.
• Experience in advanced Oracle features such as table partitioning, Oracle Streams Replication Transportable Tablespace TTS feature allows users to quickly move a user Tablespace across Oracle databases.
• Mastered the ability to Setup, Install, Configure, Maintain and Troubleshoot several Oracle tools and utilities similar to Oracle Grid Control, Oracle Enterprise Manager OEM , Tool for Oracle Application Developers TOAD , Oracle SQL Developer in diverse versions.
• Expert in planning, creation, administration and troubleshooting of Oracle 11g/10g/9i OLTP multiple instances /OLAP databases in production.
• Involved in designing of Disaster Recovery drill plan using Data Guard, and High Availability using RAC.
• Gathered high-quality exposure towards Exadata.
• Extensively used BMC Remedy, HP Quality Center ticketing systems HP Java ITO OVO Console for monitoring.
• Enthusiastic Resilient Team Member in establishing effective task priorities, customer-focused, in fast-paced and multitasking environment.
• Portrayed conviction in handling Severity issues within the team and won lots of Laurels to the organization and to the Team.

Technical expertise: Operating Systems HP-UX 10.x,11.x, Sun Solaris5.8,8,9,10, AIX 5.1,5.2, Red Hat Linux 4.x,5.x,6.x and windows 2003/2005 RDBMS Oracle 12c/11g/10g/9i, 12c/11g/10g Real Application Cluster RAC , ASM Tools Utilities RMAN, TOAD, PL/SQL developer, SQL Loader , Export/Import, Data pump, Query builder, Net Backup, SQL Tuning/Access Advisor, SQL Performance Analyzer, Data Guard, Golden Gate, Cloning, Migrations Languages C, SQL, PL/SQL, UNIX/NT Shell Scripting, Perl. Tuning Tools SQL Tuning ADVISOR/ TKPROF/ EXPLAIN PLAN /STATSPACK, ADDM, AWR. Web Monitoring Tools Web Portals, BMC Remedy, HP Quality Center, HP Java ITO OVO console, Oracle Enterprise Manager OEM 12c/11g/10g Work Experience: Confidential Role : Oracle DBA Responsibilities:

• Installed, configured and maintained Oracle 11G R2 Real Application Cluster RAC 3 node RAC.
• Supporting more than 15 production, 35 development and 40 Test databases
• Installed and configured Oracle 12c on Golden gate with Oracle Enterprise Linux.
• Migrating single Instance Databases to 3 Node RAC environments.
• Created a Clone Database using RMAN on remote Server and used SRVCTL commands for Real Application Cluster RAC Databases.
• Involved with installation and maintenance of ORACLE RAC 3 node and adding a node to this cluster database for high availability.
• Created custom services for RAC database for distribution of load across the nodes.
• Supported development teams by providing SQL statement tuning and removing load and query performance bottlenecks by using tools EXPLAIN PLAN, STATSPACK, and TKPROF.
• Manage users, privileges, profiles, schemas using Grid Control of Oracle Enterprise Manager.
• Installation and maintenance of Oracle 10g, 11g Data Guard.
• Standby database setup via Data guard for Database Disaster Recovery.
• Worked extensively on Performance tuning of Queries by maintaining Aggregates, Compression, partition, indexing and use of Statistics.
• Installed STANDALONE servers on Automatic Storage Management ASM , Red hat LINUX.
• Data Guard using physical standby database, Data guard / Standby both physical and logical standby perform switchover/failover and monitor using Data Guard manager command line and GUI
• Upgraded database from 11.1.0.6 to 11.1.0.7 and applied a PSU patch set from 11.2.0.3.1 to 11.2.0.3.9.
• Performed Backup and recovery strategies using RMAN.
• Performed Explain Plan analysis for Query Optimization and SQL tuning.
• Furnished technical support to Application Support team for performance and database related issues.
• UNIX shell scripting as and when required based on the requirement.
• Performed Migration / Up-gradations of Databases.
• Oracle Golden Gate installation, configuration, troubleshooting Golden Gate EXTRACT and REPLICAT issues.
• Responsible in Migrating the databases from SOLARIS to RHEL.
• On-Call 24x7 DBA support for production databases.
• Verify and notify for the success of whole migration process and make live production databases.
• Installation, Configuration and Maintenance of Oracle RDBMS Software.
• Creating and maintaining the Oracle databases.
• Created and managing the database objects such as tables, indexes and views.
• Table Partitioning, creating Index Organized tables, Creating Locally managed Table spaces.
• Applying patch set and interim patches whenever required to make the database software up to date.
• Creation of new scripts to automate the procedures to generate statistics on database space supervision, performance and for proactive monitoring.
• Database Sizing, Table space Management and Rollback Table space Management, Transaction Management and Security Administration.
• Created Users, Groups, Roles, Profiles and assigned users to groups and granted privileges and permissions to appropriate groups.
• Involved in I/O tuning by moving data files and redo log files to faster disks..
• Effective Production Support and off hour support, support handover, off-shore co-ordination.

Environment: O/S: Sun Solaris, Red Hat Linux RDBMS: Oracle 9i/10g/11g/12c Tools: RMAN, OEM,TOAD,SQL Loader, Export/Import, Data Pump, Data Guard, Golden gate, Cloning, Migrations, Upgradtion Languages: PL/SQL,SQL, Unix Shell Scripting Tuning Tools: TKPROF, STATSPACK,AWR,EXPLAIN PLAN,OEM Confidential Role : Oracle DBA

• The Taxation and Revenue Department, charged with the task of collecting tax dollars and distributing them according to state law, answers to the Governor as part of the executive branch of state government. It administers taxation, revenue and motor vehicle laws passed by the Legislature and signed by the Governor.
• Responsibilities:
• Daily Health Checkup of the database using STATSPACK, Automatic Workload Repository AWR , Automatic Database Diagnostic Monitor ADDM .
• Accountable for administration and supporting Oracle 11g, 10g and 9i databases in Development DEV , Quality Assurance QA , User Acceptance Testing UAT and Production environments.
• Configuration of release 10g RAC R2 with Automatic Storage Management ASM and Raw Devices, 10g CRS also with 11gR2.
• Created a Clone database using RMAN on remote server and used SRVCTL for RAC High Availability HA .
• Installation and Setup of 4 node 11g RAC and adding a node in Linux environment in 11g R2 ASM on RAC databases.
• Planning and implementing DR High Availability solutions using Oracle 10g Standby Database using Oracle Data guard, 9i and 10g RAC
• 24 X 7 Production database administration, support and monitoring to ensure a proactive problem recognition and resolution of database issues.
• Supported Data Warehousing and OLTP projects and Database design tasks utilizing Oracle EXPRESS OLAP technology and Oracle 7.1.4, 8i RDBMS.
• 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 Oracle Golden Gate to ensure disaster recovery, high availability and data protection
• Utilized Oracle Enterprise Manager OEM to manage users, privileges, profiles, schemas
• Database monitoring and performance tuning using OEM Oracle Enterprise Manager , AWR and ADDM
• Performed Upgrade of development, production and QA databases from oracle 10.2.0.3 to Oracle 11gR1.
• Migration of database from oracle 10g to oracle 11g on Sun Solaris server.
• Worked on Automatic Storage Management ASM for managing data in SAN
• 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
• Extensive Performance Tuning, Memory SGA Tuning, Net backup, RAID, RAW Devices
• Created Users, Groups, Roles, Profiles and assigned users to groups and granted privileges and permissions to appropriate groups
• 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 Tablespace usage, checking alert log, trace files, monitoring disk usage, Table/Index analyze jobs and Monitoring database backup logs.
• Adhering and Pioneering the Service level Agreement SLA Reporting, Handling tickets / requests Troubleshooting the bottlenecks with the aid of Team members.

Environment: O/S: Red Hat Linux RDBMS: Oracle 10g with RAC, Oracle 9i/10g/11g Tools Utilities: High Availability Data guard, RAC TOAD, RMAN, RAID, Data Pump, Data Broker Language: UNIX,PL/SQL, Shell Scripting Tuning Tools: TKPROF, STATSPACK, OEM

Confidential Role : Oracle DBA Responsible

• for administration and supporting Oracle 9i/10g and 11g R1 databases.
• 24x7 Production database administration, support and monitoring to ensure a proactive problem.
• Successfully migrated databases from windows 2000/2003 running oracle 9i over to Linux 5 with Oracle10g.
• Installation, Upgrade and Configuration of Oracle 10g and 11g Databases on Red Hat Enterprise Linux Solaris Platforms.
• Involved in designing of Disaster Recovery drill plan using Data Guard, and High Availability using RAC.
• Schemas refresh using Export/Import Pump, Materialized View Creating the database using DBCA Database Creation Assistant manually Create table spaces, tables, indexes, setting privileges and user logins.
• Configuration, Administration and tuning of Oracle 10g and 9i RAC.
• Used cross platform transportable table space TTS to transport table spaces across platforms.
• Data Refresh in Test and Integration Databases using Transportable Table spaces.
• Performed Setup Recovery Manager RMAN and Flash back Recovery in RAC Environment.
• Implemented backup strategies using Hot/Cold, Exp/Imp according to business requirement.
• Cloning of database performed Tablespace-point in time recovery TSPITR using RMAN.
• Installed Oracle 10g Enterprise Manager Grid Control for diagnosing and monitoring performance related problems and configured with Application servers on test databases.
• Assisted a team of DBA's in migration of databases from Oracle 9i Release 2 to Oracle 10g Release 2.
• Worked on Automatic Storage Management ASM with SAN Storage for managing data in EMC Symmetric.
• Monitoring and tuning using tools like Enterprise Manager GRID, Oracle cost Based optimizer CBO , SQL analyzer, automatic checkpoint tuning, SQL Advisors, Performance Manager, and STATSPACK.
• Performed conversion from single instance to Real Application Cluster RAC database instances.
• Provided database/application tuning including as reducing lock contention, analyzing objects.
• Downsizing and defragmenting the Very Large Databases VLDS by Export / Import, Cloning those using RMAN duplicate features and then upgrading them to Oracle 10g and Production to development refresh.
• Storage Management Managing Table spaces, Segments, Extents, Rollback Data Dictionary.
• Experienced on Database Security by monitoring User Management, Privileges, Roles, Auditing, Profiling, Authentication and Risk management.

Confidential Role : Oracle DBA

• Niteo IT Solutions is a leading talent development company, building skilled man power pool for various industry requirements. Niteo IT's expertise in learning content development, training delivery and education process management make it the most preferred partner for various clients.
• Installed, Configured and Maintained Oracle 9i 10g versions on Sun Solaris and Red Hat Enterprise Linux platforms.
• Translated business requirements into creation and alteration of database objects: tables, indexes, constraints, triggers and stored procedures.
• Created and Managed users, roles, schemas and rebuilding Indexes and granting privileges
• Revoked user privileges and roles as per requirement and killed blocking session.
• Assisted the Development team in developing new logic and modify PL/SQL code to make new enhancements or resolve bottlenecks.
• Responsible for Preparing Data Flow Diagrams for existing PL/SQL code.
• Configured Recovery Manager RMAN and Performed Hot and Cold backups for production databases using RMAN.
• Involved in taking logical backup using Data pump Expdp and Impdp Utility.
• Performed auditing on user activities on request and according to organization guiding principle.
• Conducted daily routine checks on alert logs and trace files for database errors and taken necessary actions to resolve the issue.
• Involved in coding of data extraction scripts as per technical specifications.
• Involvement in all phases of the project life cycle.
• Implemented automated backup strategy using the UNIX shell script CRON UTILITY.
• Involved in configuring the status of listener and restarting listener.
• Analyzed the table structures using Analyze command and to collect Stats on a Table.

Environment: O/S: Red Hat Enterprise Linux, Sun Solaris RDBMS: Oracle 9i/10g Tools Utilities: TOAD, RMAN, Data Pump Languages: UNIX, PL/SQL