PROFESSIONAL SUMMARY

• Around 8 years of experience in Information Technology in various roles, my experience TEMPhas scaled in providing client support, analysis, designing, testing, development, installation, migration, maintenance, Replication, Database Security, RMAN, User management, Performance tuning and monitoring teh database using OEM Grid Control, and administration for oracle databases, which included understanding teh requirements, upgrades, performance tuning, backup & recovery, cloning, and space management, shell scripting using ORACLE 12c/11g/10g/9i, performing teh role of Oracle Database Administrator according to teh set standards and timelines, Install and configure Container and Non - Container 12c databases, Pluggable databases - Architecture, Installation and teh concepts associated wif 12C database. Convert Non-CDB to Pluggable database.
• Experience in Installation of Oracle Real Application Cluster (RAC) wif ASM and manage RAC instances using CRSCTL and SRVCTL Utility.
• Hands on experience in Oracle 10g/11g/12c RAC implementation & administration (Oracle Cluster-ware setup and configuration, RAC Installation using ASM, Grid Installation.), Patching, RAC Backup
• Expertise in troubleshooting Oracle GI (Grid Infrastructure (RAC+ASM)) issues.
• Configured multiple database instances using ASM instance.
• Extensive experience in configuring and implementing ASM and proficiency in using ASMCMD and ASMLIB, Flash-Back Technology, Log Miner
• Backup and Recovery issues related (loss of OCR, Voting Disk and Oracle cluster ware) & also issues wif corruption of individual disk data blocks, loss of OS configuration files, loss of net configuration files
• Providing DBA support to multiple Cluster, Non-Cluster and ASM Database in production, development and Testing Servers in UNIX, AIX &Windows Environments.
• Resolved/Diagnose Node Eviction and Add or Remove Node from RAC.
• Configured ACFS and performed RAC health checks
• Working Experience in Exadata x3-2, x4-2 migrated databases to ExadataRAC environment
• Configured and maintained physical standby databases using Oracle DATA GUARD to perform quick disaster recovery.
• Implemented Dataguard wif maximum availability, protection and performance configurations and worked wif Dataguard Fail over and Switch over cases.
• Experience in Uni-directional, Bi-directional and Integrated Capture data replication using Gloden Gate.
• Configured Replication between different structured Target and source wif DEFGEN and COLMAP.
• Experience in using GlodenGate to support data replication monitoring, tuning and capacity planning.
• Data Guard setup wif Primary and Standby Databases.
• Configure and build Gloden Gate Extracts/replicate for multiple databases, Configure and build heartbeat monitoring in Gloden Gate
• Error handling for restart, logging, production support and status reporting in Gloden Gate
• Trouble shooting and performance tuning gloden gate replications, monitoring scripts for Gloden gate in Unix scripting
• Proficiency wif Installation and maintenance of replication tool Gloden Gate by creating extract process, extract pump, and replicate.
• Implemented Gloden Gate for replication and data migration for Oracle 11gR1 RAC multi nodes on IBM, AIX and debugging Gloden Gate issues such as extract, replicate rebuild and abend.
• Experience in using Gloden Gate in moving large volumes of transactional data, wif minimal impact to online systems.
• Experience in configuring Gloden Gate director for alerts monitoring.
• Performed data replication, transformation and delivery of database transactions using Gloden gate replication tool. Supported many Development Databases.
• Gloden gate monitoring was done using teh cronjobs, where it does report a mail in case of a process a bend or Lag more TEMPthan threshold and any Checkpoint.
• Worked on Shell Scripts for teh GlodenGate monitoring and Trail file system size.
• Cross platform Migrated from AIX to Linux and Upgraded database from 11g to 12c Using GlodenGate.
• Upgrade of Grid and Oracle Infrastructure on multi node RAC cluster from 11.2.0.3 to 11.2.0.4.
• Performed Migration between different data centers, Non ASM to ASM, Single instance to RAC.
• Extensively worked on identifying bugs and installing necessary/latest CPU/PSU patches in a rolling fashion for both teh Clusterware home and Database home.
• Experience in Implementing Streams, ODI, Data Pump, Export and Import utilities.
• Strong noledge and experience of managing Oracle 9i and 10g RAC environments using teh OEM Grid Control tools.

TECHNICALSKILLS:

Database: Oracle 12cR1, 11gR2, Oracle 11gR1, Oracle 10gR2, Oracle 9i, SQL server 2008 R2, 2012, 2014 and 2016.

Oracle Products: OEM 13c, 12C, 11g (Grid Control), Oracle cluster ware, Data guard broker, RMAN, Data pumps, ASM, AWR, ASH, ADDM, and CRSCTL.

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

Languages: Core JAVA, JDBC, SQL, PL/SQL, UNIX shell scripting.

Tools: OEM, TOAD, Fog light, SVN, STONE BRANCH, GIT, Redgate Git, Jenkins, AWS, VPC, Apache Tomcat, VM and python.

Ticketing Tools: Service Now, JIRA.

PROFESSIONAL EXPERIENCE

Confidential, Boston, MA

Sr. Oracle Database Administrator

Responsibilities:

• Oracle Operation database administrator support and Responsible to provide 24x7 database administrative activities over different database servers
• Installed OEM 13C, registering databases, creating OEM users, deploying agents, monitoring databases, registered Databases in OEM Administering Oracle Database 10g, 11g and 12c using Enterprise Manager
• Implemented Monitoring Templates and Incident Rule notifications using OEM cloud control 12C/13c for database alerting.
• Used Oracle Enterprise Manager to protect sensitive data in production databases
• Installation of new versions of application on Mainframes and AIX environments
• Configure Auditing on Oracle database to suite needs of security and managements.
• Worked in Build stage, Responsible for Installation of 12c RAC and Managing RAC Environment efficiently and involved in migration of standalone databases to RAC
• Involved in capacity planning, Tuning teh RAC interconnect, Finding RAC wait events. And Tuning teh RAC using teh Enterprise Manager Grid Control.
• Maintaining ASM in RAC environment and Monitoring Health checks OCR, voting files and Interconnect for better performance and troubleshooting issues in RAC environment (11GR2 and 12c)
• Exadata and Involved in moving databases in Exadata x4-2, x3-2 Environments
• Worked wif oracle platinum support, applied Security patches to Exadata Quarter Rack.
• Involved in all teh non-production databases on Exadata server according teh Data Warehouse development project's requirement
• Worked on wif Oracle on Exadata related Issues/Investigations & Troubleshooting Exadata using cellcli and IORM
• Converting back-end Fare Manager mainframe applications using ORACLE and DB2
• l Performance Tuning OGG in extremely high data volume environments. Installing and configuring OGG heterogeneous environments from MS SQL Server to Oracle Exadata.
• Installed and configured GlodenGate JAgent to work wif OEM GlodenGate Plugin.
• Faced and fixed database upgrade issues while working on ASM upgrade in Oracle restart environments
• Configured Mutimaster Active- Active configuration using Gloden Gate and configured extract and replicate pumps for gloden gate replication 11g/12c and troubleshooting issues using report files, Monitor status, lag and Checkpoint wif gloden gate
• Troubleshooting Gloden Gate issues in both development and production environments.
• Performed Uni-directional and Bi-directional replication through Gloden Gate for zero downtime Database migrations.
• Migrating and upgrading Oracle Database from 10gR1 on Solaris/Windows to 11gR2 on Linux environment using Datapump and Gloden Gate replication.
• Developed and configured GlodenGate macros for data conflict resolution, filtering and transformation,
• Configured GlodenGate High Availability on VERITAS Clustering Service and developed scripts for GlodenGate Failover.
• Upgrading Grid Infrastructure and databases from 11.2.0.1/11.2.0.2/11.2.0.3 to 11.2.0.4.
• Implemented and supported Gloden Gate replication in production, and development environments.
• Performed Cross platform migration and used Oracle Gloden Gate to transfer database from Hp-unix to RHEL
• configured integrated extract, integrated replicate and coordinated replicate on oracle multitenant databases 12.1.0.2
• Created blackouts in OEM to disable alerts from OEM while performing database maintenance activities such as PSU patching.
• Migrated teh current Linux environment to AWS/RHEL Linux environment and used auto scaling feature.
• Hands on experience on AWS Oracle RDS, Aurora Postgres SQL, MySQL as well as experience managing a large Oracle database on EMC Storage in a data center environment
• Hands on experience wif Chef in AWS Cloud environment
• Experience in real-time monitoring and alerting of applications deployed in AWS using Cloud Watch, Cloud Trail and Simple Notification Service
• Installed Disaster recovery databases using Data Guard and configured standby databases in maximum availability and maximum performance modes.
• Configured Physical Standby databases using data guard and converted Physical standby to Snapshot Standby and active data-guard depend on Business Requirement.
• Used Dataguard broker to monitor Dataguard status periodically and Maintained DR server and troubleshooting issues in Data Guard environment
• Proactively Monitored and identified areas dat need to be improved in teh application and database using Stats pack, AWR, ASH, ADDM and OEM Grid Monitoring.
• Experience in creating and managing user accounts, security, rights, disk space, quotas and process monitoring in Red hat Linux.
• Manage deployment, maintenance, support and upgrade of servers, hardware, software, operating systems in server environment.
• Implement Oracle TDE column encryption for advanced security.
• Performed DB migration from Windows to Solaris, implemented Oracle TDE to satisfy PCI requirements for credit card data Redaction.
• Enforced Security administration, system monitoring by adding and removing users, configuring quotas, auditing at different levels, and analyzing security problems
• Applied patching on 11g/12c and Up-gradation of Hp-unix critical databases from 11.2.3.x to 11.2.4.x.(11gr2)
• Scheduled Oracle Jobs using DBMS SCHEDULER and Backups using CRONTAB.
• Configured Glodengate 12c RAC -RAC Active configuration wif 12c database and WebLogic Administrator for Fusion Applications wif SOA
• Restoration and Recovery of databases at teh times of occurrence of critical failures and Performed Block Recovery and Data file recovery using RMAN
• On-Call 24x7 production DBA support and Worked wif off-shore and coordinating work wif prod support for managing databases

Environment: Oracle 11gR2/12C, RHEL 6.X, OEM cloud control 12C/13c/11g/10g, RAC, NFS, Data guard, GlodenGate, VMWARE, AWR, ASH, ADDM, EXPLAIN PLAN, Opatch auto, VMSTAT, DSTAT, UPGRADATION 11g TO 12C, Oracle Transparent Data Encryption, EXADATA, Data pump, SQL, TOAD, UNIX, AWS, Git, Jenkins, VPC, Shell scripting, Apache Tomcat and python.EC2, Auto-Scaling, S3, putty and Winscp.

Confidential, Chicago, IL

Sr. Oracle DBA

Responsibilities:

• Capacity planning: Allocate system storage and plan future storage requirements.
• Oracle HA Stack: Install, Configure, Setup, Maintain and Support Oracle 11gR1, 11gR2, 12c RAC, Physical and Logical Standby database for Test, Development and Production for various home-developed applications
• Involve in 24x7 on-call support for 12 databases of 5.0 TB on a 3 Node production 10g and 11g RAC databases using Oracle 12c Cloud Control for Alert Monitoring and Notification.
• Experience wif SaaS (Software as a Service), PaaS (Platform as a Service), and IaaS (Infrastructure as a Service) solutions.
• Implemented AWS high-availability using AWS Elastic Load Balancing (ELB), which performed balance across instances in multiple availability zones.
• Configured an AWS Virtual Private Cloud (VPC) and Data Base subnet group for isolation of resources wifin AWS RDS.
• Support for all other AWS products such as RDS, Route53 (DNS), Cloud Trail and Amazon Kinesis
• Maintained teh user accounts RDS, RDB, Dynamo DB, SES, SQS and SNS services in AWS cloud wif Amazon Cloud Services.
• Primary technical resources in SQL tuning in Exadata Production and Performance Testing environments by using statistics, hints, SQL tuning set etc.
• Develop and record certified processes/procedures for all potential IT downstream support groups to maintain and upgrade teh Exadata database machine.
• Very comfortable in using ASM for creating diskgroups, adding additional storage (DISKS) and troubleshooting ASM issues.
• Setup notifications (various levels for Cluster activities, tablespaces utilizations, Listener alerts) using OEM. Used OEM grid control to Monitor and troubleshoot database issues.
• Doing teh regular activities like monitoring teh alert logs, redo log status, listener. Log and checking teh space for normal segments, rollback segments and tablespaces.
• Successfully upgraded teh databases from 11g to non CDB 12c and successfully migrated 12c Non CDB databases to pluggable databases.
• Applying upgrade patch, maintenance and interim (opatch) patches on all teh databases.
• Refreshing Dev and Test instances wif data from Production on a regular basis.
• Creating users; creating and assigning appropriate roles and privileges to users depending on teh user activity.
• Created Oracle Wallets and implemented Tablespaces level TDE security.
• Defragmentation of tables and indexes for improved performance and effective space management.
• Successfully implemented physical standby database using Oracle Data guard and Active Data guard feature for High availability configuration in RAC environment.
• Setup teh unidirectional replication on oracle 11g databases using Glodengate.
• Monitoring and troubleshooting teh gaps between source and target databases configured wif glodengate.
• Helped developers to run and troubleshoot PL/SQL (procedures and functions).
• Preparation of High Level & Low-Level Design documents.

Environment: Oracle 11gR2/12C, RHEL 6.X OEM 12C, RAC, NFS, Data guard, GlodenGate, VMWARE, AWR, ASH, ADDM, EXPLAIN PLAN, Opatch auto, VMSTAT, DSTAT, UPGRADATION 11g TO 12C, Oracle X2/X3/X4 full rack Exadata machine, Data pump, SQL, PLSQL, TOAD, BANNER, UNIX, AWS, Apache Tomcat, Git, Jenkins, VPC, Shell scripting, VM and python.EC2, Auto-Scaling,S3,putty and Winscp.

Confidential, IA

Sr. Oracle DBA

Responsibilities:

• Implemented Oracle Database 11gR2 2 node Real Application Cluster (RAC) using Oracle Cluster-ware on UNIX and Installed RAC on Linux.
• Installed and Configured Oracle 11g databases on AIX 6.1 and RHEL 6.X
• Worked on large databases size greater TEMPthan 12TB.
• Installation, Maintenance, Administration and troubleshooting of Red hat Enterprise Linux 5.x/6.x servers on various hardware platforms.
• Installed and supported teh Clean Address add-on product for Banner.
• Configured, and maintained Apache web server from open source wif Java and Tomcat.
• Maintained systems configuration and managed teh installation and integration of systems patches, updates and enhancement.
• We successfully switched and failed over databases to secondary databases during DR testing using Dataguard broker.
• Configured Dataguard broker and involved in annual Disaster recovery testing
• Involved in designing of Disaster Recovery using Data Guard and High Availability using 11g RAC.
• Achieved High Availability, Data protection and Maximum performance by maintaining both Physical and Logical Standby databases.
• Used Dataguard broker to monitor Dataguard status periodically.
• Hands on experience in Oracle 10g/11g/12c RAC implementation & administration (Oracle Cluster-ware setup and configuration, RAC Installation using ASM, Grid Installation.), Patching, RAC Backup
• Installed 7 standalone servers on ASM and maintained DR databases on it.
• Performed various tasks on ASM, creating a disk group, adding a disk to disk group, making disk Online and Offline and troubleshooting issues in ASM environment.
• Installed Gloden gate on source and target side for Replication and implemented load balancing topology using Glodengate.
• Configured Gloden Gate Parameter files for Extract and Replica process for replication
• Converted Classic extract into Integrated Extract and used “batchsql” to improve performance of GlodenGate Installation
• Used Shareplex to provide Data Accuracy and Integrityto ensure dat target instances are accurate representations of teh source database.
• Performed automated backups and scheduling using scripting.
• Configured RMAN and registered databases in Catalog server.
• Responsible in configuring and backing up database using RMAN, Hot backups, Cold backups and Logical backups.
• Implemented Oracle database backup & recovery solutions using RMAN.
• Extensive use of Oracle Data Pumps Exports/Imports utility for moving data among teh servers.
• Generated AWR reports, ADDM reports for fine performance tuning and worked closed wif PL/SQL developers to tune TOP SQL running queries in databases.
• Used Invisible Indexes, and turn off indexes temporarily to check how queries perform wifout them.
• Performed large batch jobs, and tuning of SQL queries and database systems.
• Performed Quick System Review by using Education Performance Index (EPI), System Performance Index (SPI) and Memory Performance Index (MPI). Disk Performance Index (DPI). And calculated teh Total Performance Index (TPI).
• Created User accounts, Roles and granting required access permissions and privileges.
• Written Stored Procedures and Triggers for database maintenance and management using PL/SQL, UNIX Shell Scripts for backups.
• Maintained application and security polices and resolve hardware/software interface problems.
• Installed, Configured & Upgrade of Linux operating system and Performed LAMP installation and configuration on Ubuntu, Red hat and Amazon Linux Instances.
• Performed installations of SQL 2008\R2\2012 on clustered and standalone servers
• Upgradation of SQL server versions and applying patches and hot fixes.
• Adding nodes to already existing clustered servers as a part of data load\High availability
• Configured Transactional Replication and Log Shipping wif SQL Server Management
• Tuned teh Database wif Initialization Parameters. Viewing teh Initialization Parameters wif Enterprise Manager. Increasing Performance by Tuning teh DB CACHE SIZE parameter.
• Implementation of SQL server logins, Roles and Autantication modes as a part of security policies.

Environment: Oracle, 10g, 11g, Unix, Sun Solaris, Linux, RAC, DBCA, GOLDENGATE v11, v10, Dataguard, EXPLAIN PLAN, DATAPUMP, ASM, AVAMAR, RMAN Cloning, OEM 11g,12c, STATSPACK, TKPROF and putty, SQL Server 2008,2008R2,2012, log shipping, Mirroring.

Confidential, NY

Sr. ORACLE DBA

Responsibilities:

• Installed and configured 2 Node RAC on 10gR2 and performing Monitoring Health checks in RAC environment.
• Installed 13 standalone servers on ASM and migrated databases to ASM environment.
• Configured Oracle Data guard on 10G for Oracle Disaster recovery. Worked on both Physical standby and Logical standby databases and resolved issues in DR environment.
• Converting Physical standby to Snapshot standby for testing purposes.
• Achieved High Availability, Data Protection and Maximum performance by maintaining both physical and logical standby databases.
• Responsible for Installing, Upgrading and configuring teh Oracle environment by creating databases, storage structures and objects, database backup and recovery, monitoring and optimizing database Performance.
• Installed Gloden gate on source and target side for Replication and implemented load-balancing topology using Glodengate.
• Implemented Oracle database backup & recovery solutions using RMAN
• Restored and Recovery of databases at teh times of occurrence of critical failures.
• Performed cloning and refresh of Database from production environment to test environment using RMAN Duplicate database and Data pump import export.
• Identified and fixed teh logical block corruption using RMAN.
• Handling service requests wifin Service line agreement.
• Upgraded databases using Database Upgrade Assistance (DBUA).
• Involved in teh optimization of various SQL and PL/SQL using EXPLAIN PLAN and TKPROF and Creation and administration of Virtual Machines using VMware.
• Designed bash scripts to automate application and system management activities.
• These scripts provided teh following functionality: application startup and shutdown, monitored systems and applications health, and web site management.
• Involved in optimizing SQL statements using Indexes and Hints.
• Made use of teh REF CURSORS in stored procedures for report generation.
• Involved in teh creation and modification of different PL/SQL object like Packages, Stored Procedures and Triggers.
• Involved in configuration files like Listener.ora, Tnsname.ora for Client - Server environment using network configuration assistant.

Environment: Oracle 9i, 10g, Sun Solaris, windows, Unix, RMAN, DBCA, Informatica, GOLDENGATE, Data guard, EXPLAIN PLAN, Cloning, OEM, STATSPACK, RHEL 5.x/6.x, VMware, Web Servers, TKPROF and putty.

Confidential

Oracle DBA

Responsibilities:

• Implemented Oracle Database 10g R2 Node Real Application Cluster (RAC).
• Maintained and troubleshooting cluster-ware components in 10G RAC environment.
• Installed 10g standalone servers on Sun Solaris and installed databases on it.
• Used oracle configuration assistants like Database Configuration Assistant (DBCA) for creating databases, Database Upgrade Assistant (DBUA) for upgrading databases.
• Configured listener and TNS names manually.
• Involved in Up-gradation of databases from 9i to 10g.
• Configured Oracle Data-guard for Oracle Disaster recovery on 10g Solaris.
• Achieved High availability, Data protection and maximum performance by maintaining both physical and logical standby databases.
• Converted physical standby databases to Snapshot standby database.
• Implemented Oracle database backup & recovery solutions using RMAN.
• Configured and Tuned RMAN for better performance and backup strategies.
• Involved in writing for shell scripts for taking RMAN backups.
• Restored and Recovered database at teh times of occurrence of critical failures.
• Created user accounts, roles and granting required access permissions and privileges to teh database based on teh application they are accessing.
• Experience in Installing, upgrading and configuring Red Hat Linux.
• Experience in administering, installation, configuration, support and maintenance of Linux.
• Performed large batch jobs and tuning of SQL queries and database systems.
• Performed automated backups and scheduling using scripting.
• Written Stored Procedure and Triggers for database maintenance and management using PL/SQL and Involved in gathering requirements from end users.
• Estimate growth of database size by detail analysis of teh company's future policies and generating reports for teh management to act in advance.
• Clear documentation was prepared on all teh processes like program specification, bugs fixing logs & change requests for future reference

Environment: Oracle /10g/9i, Sun Solaris 5.x, Unix, OEM 10g, Shell Scripting, Oracle 10g RAC, TOAD, putty, STATSPACK, EXPLAIN PLAN.