SUMMARY

• Oracle Certified Professional with over 11 years of extensive experience on Oracle 12c/11g/10g/9i Database Administration, UNIX, HP - UX, Solaris, Linux, AIX, WINDOWS Operating systems. Also expert in Golden Gate.
• Installing/Configuring and Maintaining Oracle Real Applications Cluster (RAC) database on 3 node & 8 node clusters
• Installing/Configuring/Maintaining Oracle Enterprise Manager Grid Control for enterprise monitoring several patches such as CPU/PSU patches, One-Off Patches, Interim patches, DST, Patch sets on Exadata databases as per the oracle recommendations
• Loading and unloading of data using utilities like Export, Import, Data Pump Export & Data Pump Import
• Cloning/Replicating production database using RMAN & OEM Grid control
• Creating Primary database storage structures (Table spaces), Primary objects (Tables, Views and Indexes) and creating users, roles, profiles and resource manager
• Daily batch & Report monitoring, Space management, Index rebuilds and statistics collection
• Performance tuning production databases and performing routine DBA functions like space management
• Analyzing Automatic Workload Repository (AWR), Automatic Database Diagnostic Monitor (ADDM) in Oracle 10g
• Database Migration & Up gradation from 9i/10g/11g to 12c (Exadata X2 and X3)
• Recovery Manager (RMAN), setting new back up schedules/ plans on new databases as well as maintain and modifying the existing backups as per the new requirement
• Installing ASM environment and migrating database from NON-ASM to ASM
• Production Scripting and Scheduling of Oracle Database backup and recovery using RMAN
• Data Warehousing& Data Mining,Extraction, Transportation, Transformation, and Loading (ETL) Solution
• Implementing FLASHBACK technology and its various features in Oracle 10g/11g/12c
• Configuring physical and logical Standby Database (Data Guard) and testing for business continuity plan and Disaster recovery plan
• Working on planned switch over and rebuilding DR (Disaster Recovery) on Exadata as a part of back out plan
• Online Transaction Processing (OLTP), Online Analytical Processing (OLAP), Decision Support System (DSS) database systems & implementing and managing Very large databases (VLDB) and Oracle Warehouse Builder
• GeneratingOracleMaterialized viewsto replicate data and to cache expensive queries in a data warehouse environment
• Supportingmultiple instances of Oracle database including Development, Reporting, Data Warehousing, User Acceptance Testing & Production
• Enhancing performance, availability and manageability of a wide variety of applications by Partitioning, reducing cost for storage of large amounts of data
• Extensive Performance tuningusingSQL Baseline Tuning, SQL Tuning Advisor, SQL T etc.
• Oracle Maximum Availability Architecture (MAA), in achieving high HA with low cost and complexity
• Working with the Tools likeOEM, TOAD, ADDM, Export/ Import, Stats pack, SQL * Loader, SQL Analyze, TKPROF, AWR, Explain Plan
• Writing backend Procedures, Functions Packages & Triggers using PL/SQL and automation using Python/shell scripting.
• Worked on different types of compression, analyzing big tables and creating/rebuilding right indexes to improve database performance
• 3+ years of Strong Experience on AWS platform and its dimensions of scalability including VPC, EC2, ELB, S3,and EBS, ROUTE 53
• Worked on Amazon Web Services (AWS) infrastructure with automation and configuration management tools such as Chef and Puppet
• Installation/Configuring/Maintenance/Upgrading of Oracle Golden Gate for replication, integration and transmission of data between Exadata databases and applications
• Performing Golden Gate setup to achieve unidirectional and Bidirectional replication
• All of my work is based on industry best practice, including the Information Technology Infrastructure Library (ITIL), international standards such as ISO: 20000, CMMI, CoBIT, the BSI suite of standards. I am trained and certified ITIL process implementer

TECHNICAL SKILLS

Operating Systems: HP-UX 10.x, 11.x Sun Solaris 2.5, 2.6, 8, 9, 10 AIX 5.1, 5.2, 5.3, 6.1, 6.3 RHEL 2.1, 3.x, 4.x, 5.x Linux Enterprise Server 9, 10 Windows 95/98/NT/2000

RDBMS: Oracle 8i/9i/10g/11g&12c, RAC Exadata X2, X3 SQL Server 2000/2005/2008 , Sybase

Applications: Oracle Applications 11i and R12

Tools: & Utilities: RMAN, OEM, SQL*Loader, EXP, IMP, Data pump, EMC NetWorker, Erwin, Powershell, TOAD, Oracle SQL Developer, Golden Gate, Banner, Forms, Reports

Tuning Tools: TKPROF, EXPLAIN PLAN, STATSPACK, AWR and ADDM

Languages: SQL, PL/SQL, C, C++, UNIX Python/Shell Scripting, PERL

Others: Pac2000, TOA, VNB, VVM, BMC Patrol

PROFESSIONAL EXPERIENCE

Confidential, Dallas, TX

Sr. Oracle DBA

Responsibilities:

• 24x7 Production Database administration
• Installed Oracle 10g, 11g, 12c different versions of oracle databases for implementation work of re-hosting applications as well as new applications
• Upgrade databases from 10g/11g to 12c (ATT payment applications) as a part of UNIX to Linux migration
• Installed, configured and managed Exadata 11g Grid Infrastructure RAC databases
• Established Disaster Recovery for Exadata 11g,12c RAC database
• Excellent knowledge of RAC srvctl, crsctl, ocrdump, ocrcheck and ocrconfig utilities
• Performed converting single node instance to RAC and Adding instance to the existing RAC
• Installed and configured OEM Agents on multiple new servers and implemented standard monitoring and alerting procedures
• Installing ASM environment and migrating database from NON-ASM to ASM
• Configured database backups using Control-M/Autosys and Net Backup, tested and scheduled daily database RMAN backups and other databases jobs
• Worked on several Shell scripts to maintain the database activities, Written shell scripts for backup monitoring,Password management and montoring standby database
• Configured and managed physical standby database using data guard for disaster recovery on a different node for production databases
• Provided database support from small databases to very large databases
• Extensively worked in tuning ad-hoc SQL queries with both OLTP and data warehouse databases
• Worked with the development team for deploying application code patches and builds during implementation
• Partitioned Large tables to execute queries in finite window and fine tune the response time of database
• Applied patches, keeping applications software bug free, and improving data integrity
• Tested and Implemented Sound backup and Recovery Strategy
• Worked on Production Scripting and scheduling of oracle database backup using RMAN
• Implemented change requests on a daily, ongoing basis based on user requirements and changes in project specifications. Erwin was used to synchronize the data model against the database to generate scripts for the changes. The script was verified for discrepancies and changes on the database were implemented
• Created tables with referential integrity for implementing business rules and queries were developed using SQL, SQL*PLUS, PL/SQL and Python/Shell scripting. Assisting developers in object design and use of new features and implement modifications to existing objects to for better performance
• Involved in performance tuning the database. Analyzed Stats Pack results to tune SQL for improved performance of the stored procedures and created indexes on tables on a case-by-case basis. Rectified fragmentation and row chaining problems in the database
• Supported OS patching for both Prod & Non-Prod servers
• Worked on Amazon Web Services (AWS) infrastructure with automation and configuration management tools such as Chef and Puppet
• Good knowledge on Amazon Web Services (AWS), Amazon Cloud Services like Elastic Compute Cloud (EC2) AWS EC2 and Cloud watch services.
• Configured AWS IAM and Security Group in Public and Private Subnets in VPC
• Worked on Installation/Configuring/Maintenance/Upgrading of Oracle Golden gate for replication, integration and transmission of data between different databases and applications
• Performed Golden Gate setup to achieve unidirectional replication
• Implemented Table auditing using Golden gate, which replaced many triggers saving database resources
• Prepared Golden Gate parameter files for Extraction and Replication and estimated SAN Storage needed for Replication across multiple sites
• Documented various implementation procedures for future needs and shared within the team
• I am ITIL certified and worked to implement ITIL standards across the organization

Environment: Oracle 12c, 11g,10g, Linux 5,Grid management, OID, OEM,TOAD, Python/Shell Scripting, PL/SQL developer, SQL*Loader, Statspack, ERWin, RMAN, AWR, ADDM, EXPLAIN PLAN, TK Prof, Dataguard, DataPump, SQL*Loader, EMC NetWorker

Confidential, St Louis, MO

Sr. Oracle DBA

Responsibilities:

• 24X7 interaction with Business Development groups for maintenance and enhancement of the database as per the Service Level Agreement Installation, configurations of multiple Oracle 10gR2 RAC environments with Oracle Cluster ware (CRS)on two node clusters starting from scratch
• Migrated/Upgraded from Single Instance to RAC and 10g to 11g RAC Worked on re-hosting existing legacy databases to new and Exadata (Linux) databases. Configured Automatic Storage Management (ASM)
• Migrated Non-ASM systems to ASM systems
• Design and development of SQL, PL/SQL as well as the use of Oracle Warehouse Builder to perform ETL functions for a 100 GB data warehouse
• Responsible for using AWS Console and CLI for deploying and operating AWS services
• Utilized Oracle Streams to capture, propagate, and apply the transfer of data, transactions, and events within managed databases from legacy server to production server
• Setup Databases using manual and configuration of users, schemas, objects
• Monitored on a regular basis, as part of database preventive maintenance, the database growth, alert logs and archive log destination space by setting up alerts through OEM
• Configuring Oracle 10g/11g Data Guard for RAC Exadata production systems
• Performed and Recoveries using RMAN/Conventional hot backups
• Applied several patches such as CPU/PSU patches, One-Off Patches, Interim patches, DST, Patch set as per the oracle recommendations
• Created and maintained Materialized views for improved query performance
• Database and SQL tuning using SQL TRACE, EXPLAN PLAN, Automatic Workload Repository (AWR), Automatic Database Diagnostic Monitor (ADDM)
• Implemented oracle high availability solution using Oracle Physical & Logical Standby
• Fine-tuned queries to optimize the application performance
• Performed system testing and integration testing of large Data Warehouse application
• Dealing with Oracle Support/Support Requests (SR), one-off patches
• Daily Production support /Database Maintenance with/without Grid Control
• Scripts/Automation of daily support/maintenance/monitoring activities using Shell, SQL and PL/SQL scripting
• Performed capacity planning, provided backup strategy for remote production database
• Creating and dropping of users, granting and revoking permissions to users/roles as and when required
• Experienced with Space Management and Security
• Worked on Database Design / Application meeting as DBA representative, Created physical & Logical models using ERWIN, created schema generation scripts, installed & maintained database objects
• Worked on Installation/Configuring/Maintenance/Upgrading of Oracle Golden gate for replication, integration and transmission of data between different databases and applications
• Performed Golden Gate setup to achieve unidirectional replication
• Implemented Table auditing using Golden gate, which replaced many triggers saving database resources
• Worked with multiple teams setting up processes to align with ITIL process

Environment: Oracle 11g/10g/9i, Linux, Solaris, AIX, Windows NT, SQL Developer, PL/SQL, Shell scripting (Bourne/ Korn/ C), OEM GC, Statspack, ERWin, RMAN, AWR, ADDM, EXPLAIN PLAN, TK Prof, Dataguard, DataPump, SQL*Loader, EMC NetWorker

Confidential, Columbia, MO

Database Administrator

Responsibilities:

• 24X7 interaction with Business Development groups for maintenance and enhancement of the database as per the Service Level Agreement
• Installation, configurations of multiple Oracle 10gR2 RAC environments with Oracle Cluster ware (CRS)on two node clusters starting from scratch
• Applied several patches such as CPU/PSU patches, One-Off Patches, Interim patches, DST, Patch set as per the oracle recommendations
• Supporting ETL / Configuration and administration of Informatica ETL
• Created and maintained Materialized views for improved query performance
• Database and SQL tuning using SQL TRACE, EXPLAN PLAN, Automatic Workload Repository (AWR), Automatic Database Diagnostic Monitor (ADDM)
• Implemented oracle high availability solution using Oracle Physical & Logical Standby.
• Fine-tuned queries to optimize the application performance
• Database and SQL tuning using SQL TRACE, EXPLAN PLAN, Automatic Workload Repository (AWR), Automatic Database Diagnostic Monitor (ADDM)
• Implemented oracle high availability solution using Oracle Physical & Logical Standby
• Fine-tuned queries to optimize the application performance
• Created tables with referential integrity for implementing business rules and queries were developed using SQL, SQL*PLUS and PL/SQL. Assisting developers in object design and use of new features and implement modifications to existing objects to for better performance
• Involved in performance tuning the database. Analyzed Stats Pack results to tune SQL for improved performance of the stored procedures and created indexes on tables on a case-by-case basis. Rectified fragmentation and row chaining problems in the database
• Supported OS patching for both Prod & Non-Prod servers
• Scripts/Automation of daily support/maintenance/monitoring activities using Shell, SQL and PL/SQL scripting
• Performed capacity planning, provided backup strategy for remote production database
• Worked on Installation/Configuring/Maintenance/Upgrading of Oracle Golden gate for replication, integration and transmission of data between different databases and applications

Environment: Oracle 11g/10g/9i, Linux, Solaris, AIX, Windows NT, SQL Developer, PL/SQL, Shell scripting (Bourne/ Korn/ C), OEM GC, Statspack, ERWin, RMAN, AWR, ADDM, EXPLAIN PLAN, TK Prof, Dataguard, DataPump, SQL*Loader, EMC NetWorker

Confidential, Columbus, OH

Sr. Oracle DBA

Responsibilities:

• 24x7 Production Database administration
• 24X7 interaction with Business Development groups for maintenance and enhancement of the database as per the Service Level Agreement
• Installation, configurations of multiple Oracle 10gR2 RAC environments with Oracle Clusterware(CRS)on two node clusters starting from scratch
• Migrated/Upgraded from Single Instance to RAC and 9i to 10g RAC
• Configured/Integrated multiple Application Environments to use RAC
• Configured Automatic Storage Management (ASM)
• Migrated Non-ASM systems to ASM systems
• Utilized Oracle Streams to capture, propagate, and apply the transfer of data, transactions, and events within managed databases from legacy server to production server
• Setup Databases using DBCA and configuration of users, schemas, objects
• Monitored on a regular basis, as part of database preventive maintenance, the database growth, alert logs and archive log destination space by setting up alerts through OEM
• Configuring Oracle 10g Data Guard for RAC production systems
• Performed and Recoveries using RMAN/Conventional hot backups
• Applied several patches such as CPU/PSU patches, One-Off Patches, Interim patches, DST, Patch set as per the oracle recommendations
• Supporting ETL / Configuration and administration of Informatica ETL
• Created and maintained Materialized views for improved query performance
• Database and SQL tuning using SQL TRACE, EXPLAN PLAN, Automatic Workload Repository (AWR), Automatic Database Diagnostic Monitor (ADDM)
• Implemented oracle high availability solution using Oracle Physical & Logical Standby.
• Fine-tuned queries to optimize the application performance
• Performed system testing and integration testing of large Data Warehouse application.
• Dealing with Oracle Support/Support Requests (SR), one-off patches
• Daily Production support /Database Maintenance with/without Grid Control
• Scripts/Automation of daily support/maintenance/monitoring activities using Shell, SQL and PL/SQL scripting
• Performed capacity planning, provided backup strategy for remote production database
• Worked with Transparent Data Encryption (TDE) in Oracle 10g R2 to encrypt sensitive data within the data files without access from the OS
• Creating and dropping of users, granting and revoking permissions to users/roles as and when required
• Experienced with Space Management and Security
• Extensively used the advanced features of PL/SQL like Records, Tables, Object types and Dynamic SQL
• Developed Database Triggers for audit and validation purpose
• Created physicaland logical models using ERWIN, created schema generation scripts, installed and maintained database objects
• Implemented ITIL based Configuration Management Process design and development for a service provider

Environment: Oracle 11g/10g/9i, Linux, Solaris, HP-UX 10.2, AIX, Windows NT, SQL Developer, PL/SQL, Shell scripting (Bourne/ Korn/ C), OEM GC, Statspack, ERWin, RMAN, AWR, ADDM, EXPLAIN PLAN, TK Prof, Dataguard, DataPump, SQL*Loader, EMC NetWorker

Confidential, Los Angeles, CA

Oracle DBA

Responsibilities:

• 24X7 Interaction with Business Development groups for maintenance and enhancement of the database as per the Service Level Agreement
• Involved in RAC administration including Installation of Oracle 10/11g, Database cloning, tuning, patching, monitoring concurrent manager processing
• Installing/Maintaining/Configuring ASM Environment and Migrating Several Non ASM systems to ASM
• Cloned Very Large Databases from Production to Development/Test clusters
• Configured/Set up Monitoring through OEM GC as part of database preventive maintenance, the database growth, alert logs and archive log destination space
• Upgraded/Migrated Databases from 9i/10g to 11g in the SAP Environment
• Installed/Configured Oracle streams to propagate information within and in between several databases
• Performing Backups and Recoveries using RMAN/Conventional hot backups and EMC Networker
• Configured Oracle 10g Data Guard for RAC production systems
• Applied several patches such as CPU/PSU patches, One-Off Patches, Interim patches, DST, Patch set as per the oracle recommendations
• Performed Oracle Database and SQL tuning using SQL TRACE, EXPLAN PLAN, Automatic Workload Repository (AWR), Automatic Database Diagnostic Monitor (ADDM)
• Scripts/Automation of daily support/maintenance/monitoring activities using Shell, SQL and PL/SQL scripting
• Strong knowledge in developing, designing and implementing data mining models using neutral networks and logistic regression
• Excellent technical and analytical skills with clear understanding of design goals of ER modeling for OLTP and dimension modeling for OLAP
• Performed Oracle Database and SQL tuning using SQL TRACE, EXPLAN PLAN, Automatic Workload Repository (AWR), Automatic Database Diagnostic Monitor (ADDM)
• Created and maintained Materialized views for improved query performance
• Implemented oracle high availability solution using Oracle Physical & Logical Standby.
• Refreshed using Export, Import, Hot, Cold and RMAN backups from Production to non-prod Environments
• Used data pump import/export utility of ORACLE to create other development and test databases
• Maintaining schemas and partitioning tables
• Creating and dropping of users, granting and revoking permissions to users/roles as and when required
• Experienced with Space Management and Security
• Supported application team to solve any issues in Production Environment
• Importing data from flat files into database using SQL* loader and External Tables

Environment: Oracle 10g/9i, Linux, Solaris, HP-UX 11.0/10.2, AIX, Windows NT, SQL Developer, PL/SQL, Shell scripting (Bourne/ Korn/ C), OEM GC, Statspack, ERWin, RMAN, AWR, ADDM, EXPLAIN PLAN, TK Prof, Dataguard, DataPump, SQL*Loader, EMC NetWorker

Confidential

Database Administrator

Responsibilities:

• Provide Oracle DBA support for multiple large databases in production, development and test environments
• Refreshing development/test database from production using Export/Import & RMAN backups
• Making structural changes to the 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 the user activity
• Defragmentation of tables and indexes for improved performance and effective space management
• All Database MaintenanceActivities to achieve optimum database uptime
• Configuration of Listener and Tnsnames
• Doing the regular activities like monitoring the alert logs, redo log status, listener. Log, v$session and checking the space for normal segments, rollback segments
• Created database link between two databases to access the table data from one local database to remote database using distributed database feature
• Created snapshots for some most queried tables to get the most refreshed data. Planned and installed replication of database also
• Planned database backups (operating system, full/partial backups, and export/import) using various types of backups and designed the backup methodology for the 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

Environment: Oracle 8, 8i on Sun Solaris 8/9, HP UNIX.