SUMMARY:

• 9 years of experience as 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 ofOracle 12c,11g,10g &9iin very large scale database environment and to run vital day - to-dayOnline Transaction Processing (OLTP)andOnline 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 maintainedOracle 12c/11gR2/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.
• Extensive knowledge on EXADATA and implemented specific features like Smart scan, HCC, Smart flash log.
• Involved in configuring Exadata X2-2, X2-8 and have a good knowledge on smart flash cache, storage index, storage management and migration.
• Involved in moving databases in Exadata RAC environment and also Implemented DBFS on Exadata.
• Installed Oracle 12c database and OEM 12c Cloud control on Linux server.
• Monitoring Health checks of OCR, VOTING DISKS and Interconnect for better performanceand troubleshooting issues in RAC environment.
• Skillful in employingORACLE STREAMS for replication and two types of standby databases logical standby and physical standby databases supported by DATAGUARD for Disaster Recovery (DR).
• Troubleshooting and performed switchover/failover using Data Guardthrough command line and Graphical User Interface (GUI).
• Experience in Software Development Life Cycle (SDLC), Analyzing and Designing systems using Structured Methodologies (ERD, DFD) along with extensive knowledge of Relational Database Management Systems with in-depth of T-SQL. Actively involved in management of Change Control Requests.
• Hands on experience in OracleGolden Gateinstallation, configuration, troubleshooting Golden Gate EXTRACTS,PUMPS and REPLICAT issues.
• Comprehensiveexperience in Database backup and recovery (User-managed), RMAN Backup, Recovery & Restore with/without catalog database.
• Executed Logical Backupusing, Network Link, Data Pump Utilities(Export/Import) and Physical Backup (Cold/Hot/Full/Incremental/ Cumulative) backup strategies in 12c/11g/10g.
• Configuring Backup Retention Policy, planned strategies for Incremental Backupof Data files and Rolling Forward Image Copies of Data files and Performing and Scheduling Backups with Enterprise Manager
• 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).
• Experience in maintaining Extraction Transformation and Loading (ETL) tools for Reporting Solutions.
• Developing Unix shell scripts (cron and Perl) to extract data from ETL database environment as reports and importable delimited data sets.
• Supported development effort by providing SQL statement tuning and optimizing ETL procedures and removing load and query performance bottlenecks by using Explain Plan.
• Conducted Junior Oracle administrators on Backup strategies,Patching andupgradation.
• Writing scriptsinUNIXShell 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/SQLpackages, Stored Procedures, Functions, Triggers and Views to retrieve, manipulate and migrate complex data sets in Oracle Databasesabout 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 using SCP,FTP,SFTP and Refreshing with Network Link, export/import, Data Pumputilitiesand Data loading using SQL*Loader andTOAD.
• Expertise in Performance tuning of the database - SQL Tuning, implemented utilities like STATSPACK andinterpret Automatic Workload Repository (AWR), Automatic Database Diagnostic Monitor (ADDM) reports, AWR SQL Report, ASH Report, Tuning of SGA, distribution of disk I/O, Resizing of tables and indexes.
• Expertise in Installation of SQL Trace and analyzing XTRACT and XECUTE SQL Traces for Performance Tuning.
• Experience in handling Oracle features such as table partitioning-sub partitioning,OracleStreams (Replication)TransportableTablespace (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), OracleSQLDeveloper in diverse versions.
• Expert in planning, creation, administration and troubleshooting of Oracle 12c/11g/10g/9i OLTP (multiple instances)/OLAP databases in production.
• Involved in designing of Disaster Recovery drill plan using Data Guardin RAC environment.
• 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 wonLaurels to the organization and to the Team.

TECHNICAL SKILLS:

Database: Oracle 12C,11gR2, Oracle 11gR1, Oracle 10gR2, Oracle 9i,8i, MYSQL, SQL Server 2008

OracleProducts: Oracle Real Application Cluster 10g/11g/12C, OEM 12C, Golden Gate, Data guard, Import & Export, Data pumps, Data Masking, Oracle Wallet Management, Automatic Storage Management, Oracle 10g/11g/12c (Grid Control), Oracle Exadata, RMAN, Transparent Data Encryption and ETL(Extraction Transformation and Loading)

OperatingSystem: Oracle Linux, HP UNIX 11i, Red Hat Enterprise Linux (RHEL) 4.x, 5.x, 6.x, Sun Solaris 5.8, 5.9, 5.10, Windows XP/2003/2008, AIX 5.x

Languages: SQL, PL/SQL, Unix shells scripting, VBScript

Tools: & Utilities: SQL Trace and SQL tuning Advisory, SQL* plus, ADDM, DBCA, Log Miner, TKPROF, AWR, ASH, Toad, Putty, ERWIN, ETL tool, DBUA, Opatch, Statspack, DB Verify, SRVCTL, CRSCTL, ASMCMD, ADRCI, SQL Loader.

Web Monitoring Tools: Web Portals, BMC Remedy, HP Quality Center, HP Java ITO (OVO) console, Oracle Enterprise Manager(OEM) 12c/11g/10g

Web Technologies: HTML, XHTML, CSS, XML

WORK EXPERIENCE:

Confidential, Plano, Texas

Oracle DBA

Responsibilities:

• Skilled in supporting 24 x7 On- call Production DBA support, Application/development DBA.
• Functioned on databases ranging from 500GB to 10 TB.
• Experienced in Refreshing Database using Data pump, Network Link Export and Import and Export and Import.
• Upgrading RAC databases from 10.2.0.5 to 11.2.0.1 and 11.2.0.4 to 12c.
• Changing the Plan Hash value associated with a SQL using SQLT utility, Loading plans from cursor cache and through SPM baselines as a part of Performance Tuning.
• Restore and Recover of a RAC, Windows, Data guard, Exadata databases using RMAN duplicate restore.
• Working experience with Oracle Exadata X2-2 Servers nodes ranging from 2 to 8.
• Proficient in using SQLT, Oracheck, raccheck, Sql360, OEM Advisory utilities for Performance tuning.
• Extensively usedAWR, ADDM, AWR Sql Report, SQLT, and EXPLAIN PLAN for performance tuning of the database and perform Root-cause-analysis for any issues.
• Responsible for creating Heterogeneous Network links to DB2, Sybase and Teradata databases.
• Experienced in using SQL Loader, Import & Export Wizard, compare database objects, Session browser for Active monitoring of SQL’s,Advanced Sql Optimization, Rebuild Multiple Objects.
• UsedSCP, FTP and SFTPfor file transferring between dissimilar servers.
• Knowledgeable in creating Range, Hash Partitions and Sub-partitions for Monthly, Quarterly and Yearly based on the requirement.
• Involved in Extensive Performance Tuning and engaged Oracle Support through Webex sessions for severe Production issues for solutions on the go.
• Designed and ImplementedAccess Control List (ACL) and Security Classes to connect/update/access databases.
• Involved in Writing Shell Scripts and designing Cron jobs for automatic scheduling of jobs on databases.
• Proficient in working with Stored Procedures, Functions, Views, Cursors, Triggers in Oracle 10g, 11g, 12c and MYSQL databases using T-SQL and PL/SQL.
• Conversant Knowledge of VB Script, JavaScript’s, XML\XPATH and SQL Server.
• Experience in designing Master Pages layoutsusing CSS3 and HTML.
• Expertise in Migrating from AIX server to Linux servers, Decommissioning of databases, Shrink datafiles, and Move data files from one tablespace to other Online/offline mode.
• Involved in resolving Sync issues,
• Strong analytical and problem-solving skills coupled with excellent written, verbal and interpersonal communication skills.
• Enthusiastic and Quick to learn new applications, tools and willing to take individual responsibilities.

Confidential, East Hanover, NJ

Oracle DBA

Responsibilities:

• Installed, configured and maintained Oracle 11GR2 Real Application Cluster (RAC) 3 node RAC.
• Supporting more than 45 production,35development and 40 Test databases
• Installed and configured OracleGolden gate.
• Migrating single Instance Databases to 3 Node RAC environments.
• 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,SQL PLUS.
• Supported development effort by providing SQL statement tuning and optimizing ETL procedures and removing load and query performance bottlenecks by using Explain Plan.
• Manage users, privileges, profiles, schemas using Grid Control of Oracle Enterprise Manager.
• Extensive working knowledge with development teams in design and development on Front End technologies: JSP,HTML, JavaScript, XHTML.
• Have Extensive knowledge in scheduling loads and transformations and process depending on the success or failure of the operation workflow through ETL typically addressed by Oracle Warehouse Builder.
• Developed Graphical User interfaces using HTML5 and JSP's for user interaction.
• 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
• Performed Backup and recovery strategies using RMAN.
• Performed Explain Plan analysis for Query Optimization and SQL plus.
• 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.
• OracleGolden Gate installation, configuration, troubleshooting Golden Gate EXTRACT and REPLICAT issues.
• Responsible in Migrating the databases from SOLARIS to RHEL.
• Installation, Configuration and Maintenance of Oracle RDBMS Software.
• Creating and maintaining the Oracle databases.
• Createdand managing the database objects such as tables, indexesand 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.

Confidential

Oracle DBA

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 nodein 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
• 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 Oracle11gR1.
• Migration of database from oracle 10g to oracle 11g on Sun Solaris server.
• Worked on Automatic Storage Management (ASM) for managing data in SAN
• 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 utility.
• Developed and modified scripts to work efficiently for alerts for ORA error backup and recovery, automatic startup and shutdown databases.
• Consumed Web services for transferring data between different applications.
• Interfaced with the Oracle 10g back-end database using Hibernate HTML5 and XMLconfig files.
• Used JSP,HTML on front end.
• 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.

Confidential, Houston, TX

Oracle DBA

Responsibilities:

• 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 databasesfrom windows2000/2003running oracle 9i overto Linux5 with Oracle10g.
• Installation, Upgrade and Configuration ofOracle 10g and 11gDatabases on Red Hat Enterprise Linux & Solaris Platforms.
• Involved in designing ofDisaster Recovery drill plan using Data Guard, and High Availability using RAC.
• Schemas refreshusing 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 Refreshin Test and Integration Databases using Transportable Table spaces.
• Performed Setup Recovery Manager (RMAN) and Flash back Recovery in RAC Environment.
• Installed Oracle 10g Enterprise Manager (Grid Control) for diagnosing and monitoring performance related problems and configured with Application servers on test databases.
• Worked on Automatic Storage Management (ASM)with SAN Storage for managing data in EMC Symmetric.
• Monitoring and tuning using tools likeEnterprise Manager GRID, Oracle cost Based optimizer (CBO), SQL tuning, 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 theVery Large Databases(VLDS)byExport / Import, Cloning those usingRMANduplicate features and then upgrading them to Oracle 10g and Production to development refresh.

Confidential

Oracle DBA

Responsibilities:

• 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.
• AssistedtheDevelopment 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 CRONUTILITY.
• Involved in configuring the status of listener and restarting listener.
• Analyzed the table structures using Analyze command and to collect Stats on a Table.