SUMMARY

• Over 19+ years of experience with a broad set of technical skills gained through a variety of roles (Database Administrator, Projects DBA, SME, Database Architect and Engineering Team Manager) in Oracle products, both production and development environments spanning several industries: production, health care, Trading, financial services, telecommunications and high tech.
• Expert in Oracle 10g/11g/12c/18c/19c RMAN, RAC, ASM, Exadata, AWS EC2, Oracle streams, Oracle Golden Gate, Amazon RDS, OAS, ODI, OBIEE, Oracle Internet Directory/ LDAP, Linux, Solaris, Windows, AIX +.
• Extensively worked on AWS EC2 implementations and migrations from on - premise to cloud, designed firewall rules to allow communication between on-premise and AWS cloud.
• Experienced in Oracle Golden Gate installation, configuration, troubleshooting Golden Gate EXTRACT and REPLICAT issues for both RAC and non RAC system, Golden Gate upgrades, Upgrade from oracle 10g/11g to 12c, 18c, 19c by using GG in real time, creating reporting and disaster recovery dbs by using data guard and Golden Gate and monitoring Golden Gate system by creating Unix Shell scripting.
• Plan and migrate databases from on-premise to Oracle Exadata Database Machine for different clients.
• Expertise in setup, installation, configuration, maintenance and troubleshooting of several Oracle tools and utilities like Oracle Enterprise Manager (OEM), TOAD, Oracle SQL Developer in various versions.
• Expert in Performance Tuning i.e. tuning applications, shared pool, I/O distribution, rollback segments, buffer cache, redo mechanisms.
• Experience in Auditing and Capacity Planning, Configuring & Managing Hot Standby Databases (Data Guard).
• Performed In-place and Out-of-place patch set Upgrades
• Implemented data transfer using Transportable Table Spaces (TTS), Data Pump (Export/Import) utilities.
• Experience in Real Application Cluster (RAC) environment with Automatic Storage Management (ASM).
• Installed and Monitored Oracle 12c/19c RAC software and experienced on Performance Tuning on RAC.
• Migrated NON-ASM databases to ASM using RMAN.
• Expert in tuning system performance, can read and interpret AWR/ASH/ADDM/Statspack reports, setting up SQL profiles wherever required, SQL tuning using Explain plans and TKPROF.Patch Management and Version Control.
• Expertise in setting up Oracle 12c/13c Cloud Control Enterprise manager and handling end to end management of OEM 12c suite, also installed 12c agents on database servers both on-premise and on AWS cloud.
• Experience on NOSQL of Cassandra Architecting and creating Cassandra database systems. Experience with Apache Cassandra (Development orDBA).
• Extensive knowledge and experience on Amazon Web Services(AWS) Technologies like: EC2, RDS, Route53, ELB, CloudWatch, AMI (Amazon Machine Images), IAM, VPC, Subnets.
• Ample knowledge and experience on Amazon Web Services and involved ongoing database technical support for RDS, EC2 environment.
• Responsible for launching EC2 instances w/ Linux AMI and bootstrapping with Apache using Bash scripting, using auto-scaling and load balancers (ELB).

TECHNICAL SKILLS

Operating System: HP-UX, IBM AIX 6.x, Sun Solaris/Sparc 5.x, Red Hat Linux, Oracle Linux, V-Block VMware and Windows 2003/2008 R2.

Databases: Oracle 10.x, 11.x, 12c, 18c, 19c & CDB/PDB, MS SQL, EC2, RDS, RDBMS

Clusters: Oracle Cluster ware, Oracle ACFS, OCFS, VERITAS Cluster and Windows Cluster.

High Availability: Oracle 11g/12c/18c/19c RAC, Standby Database, Clustering and Data Guard Setup, Golden-gate, Automatic Storage Management (ASM) and Configuration and Tuning.

AWS Cloud Tech: S3, IAM, EC2, Route53, VPC, SNS, ELB, Cloudwatch, Auto Scaling

Oracle & Other tools: OEM 12c/13c,OAS 10g,ODI 11g and OBIEE 11g, GoldenGate, Export/Import, Datapump, RMAN, Toad, BMC Patrol, VERITAS Netbackup, IBM TSM, Tivoli.

Ticketing System: BMC Remedy, Open Pursuit, Maximo, LANDesk and Service Now

Application Servers & Others: Oracle Application Server 11i/R12 - SYS ADMIN, AOL, GL, INV,Oracle Workflow, Oracle Discoverer, Oracle Alerts.

PROFESSIONAL EXPERIENCE

Confidential

Oracle DBA Architect / AWS Cloud Engineer

Environment: AWS (EC2, AMI, VPC, Route53), Oracle 12c/18c/19c, RAC, Dataguard (Physical & Standby), RMAN, ASM, Golden Gate, RAC, ASM, Oracle 12c CDB/PDB, TWS, Legato, Data domain, Amazon RDS, Amazon S3, OEM 12c, BI publisher, Linux, IBM AIX, SunOS, Windows, Unix Shell scripting, VERTIAS NETBACKUP.

Responsibilities:

• Migrated development/production Oracle databases to AWS RDS.
• Manage Amazon Web Services - ELB, Ec2, S3, RDS, SNS, Cloud watch.
• Create S3 buckets and also managing policies for S3 buckets.
• Created network architecture on AWS VPC, subnets, Internet Gateway, Route Table and NAT Setup.
• Create snapshots and amazon machine images (AMIs) of the instances for backup and creating clone instances.
• Achieved HA (High Availability) and FT (Fault Tolerant) for AWS EC2 Instances using the AWS Technologies like: EC2, Route53, ELB, CloudWatch, AMI (Amazon Machine Images), VPC, Subnets.
• Worked with IAM to manage the users and groups using IAM by assigning individual policies and roles to each users and group as per requirements.
• Oracle 12c/11gR2/11gR1/10g/9i Installation, Configuration of Oracle on UNIX (Sun/Linux/AIX) and Windows 2003/2008/2012.
• Golden Gate Installation, configuration and end to end management/troubleshooting and tuning of Golden Gate replication technologies.
• Implemented Golden gate replication methods between multiple databases, unidirectional and bi-directional.
• Setup flashback normal /guaranteed restore points as part of application testing, flashback database in case of back out using flashback database feature in 11g.
• Patching, upgrade, migrate and support SAP Basis 10g and 11g databases.
• Successful Migration of Non RAC single instance to 11g/12cR2 RAC database instances.
• Performance monitoring and troubleshooting during build phase as well as during PGLS support using diagnostics pack, AWS Cloud Watch and on premise server level monitoring (SCOM).
• Designed and implemented Observer setup (part of HA solution called FSFO - Fast Start Fail Over) on premise.
• Planned and implemented HA/DR (High Availability/Disaster Recovery) testing.
• Installed Cloud control agent on AWS servers configured them to be monitored by EM manager 12c cloud control running On-premise.
• OEM agents’ configuration and Installing OEM12c/13c and BI Publisher.
• ASM installation, administration and Upgradation as part of Kernel Upgradation.

Confidential

Sr. Oracle DBA

Environment: Oracle 9i/10g/11g/12c, RAC & ASM, Oracle Toad 9.1.0, iSQL*PLUS, Windows 2003, Windows XP, Linux RHE 4.0, SUN 5.10, AIX 7.1.

Responsibilities:

• Establish/Implement/Planning/Maintain Backup/Restoring/Recovering the Fully Functional Database Policies and Procedures.
• Involved in Installation of Oracle 10g on Linux, IBN-AIX, Solaris, HP-UX and windows.
• Worked on Multiple RAC clustered environments ranging from 2 nodes to 4 nodes per cluster.
• Implemented Oracle 11g new features like Real Application Testing (RAT), RMAN new compression algorithm and tested active standby data guard.
• Involved in fresh installation of 11.2.0.2 RAC databases ASM file systems.
• Installed and Configured Golden Gate for replication of production databases to Reporting Databases and troubles hooted Golden Gate issues.
• Installed, configured and supported uni-directional and bi-directional replicatedenvironments utilizing Golden Gate 10.x and 11.x software and created manager, extract, replicate trail files. Tested data is flowing fromheterogeneoussource systems to oracle database.
• Setup and configured Oracle 10g/11g Physical Standby database (Data Guard) to ensure high availability, where the standby database was used for disaster recovery as well as to offload the running of huge reports and did switchover and switchback And Troubleshooting archive log gap between primary and standby databases.
• Tested RMAN incremental and image copy backups in DEV, IST, UAT and Production databases.
• Tested RMAN image copy restore in DR database.
• Worked on 11g Grid control and 12C Cloud control and intensively used for Diagnostic & tuning activities.
• Analyzing database performance and tuning database on Oracle EXADATA.
• Using Real Application Testing (RAT)
• Performed cloning using RMAN to set up development and test databases from Production database and Automated the nightly RMAN backups for the Production in control - m and development Databases in CRONTAB.
• Expertise in recovering the database. Performed complete recovery, data file recovery, incomplete recovery.
• Taking initiatives for maintaining SLA (Service Level Agreement) & SOP (Standards Operating Procedure).

Confidential

Sr. Oracle DBA

Environment: Oracle 12c/11g/10g/9i, AWS EC2, Data Guard (Physical standby), Data Guard (Physical standby, FSFO), OEM cloud control 12c, OEM grid control 11g, Golden Gate, RAC, ASM, Exadata, Linux, AIX, Tru64, Windows, OVM, RMAN, Export/Import, Datapump, OID/LDAP, Oracle 12c CDB/PDB, PAM CyberArk, ESM, TWS, Legato, Data domain, Amazon RDS, Amazon S3, MongoDB.

Responsibilities:

• Installed, Configured Oracle 10g/11g/12c RAC Cluster for a 3 node multi instances hybrid cluster.
• Implemented various solutions running on oracle 11.2.0.2/11.2.0.4/12.1.0.2 , migrated databases from legacy versions like 8i/9i/10g to 11g/12c.
• Migrated Oracle databases from on premise servers to AWS EC2 instances.
• Performance monitoring and troubleshooting during build phase as well as during PGLS support using diagnostics pack, AWS Cloud Watch and on premise server level monitoring (SCOM).
• Planned and implemented HA/DR (High Availability/Disaster Recovery) testing.
• Installed Cloud control agent on AWS servers configured them to be monitored by EM manager 12c cloud control running On-premise.
• Installed and configured 3-node 11g R2 RAC systems with ASM storage.
• Involved in implementing Load balancing and testing failover on 3 node RAC Database.
• Worked on implementing cold/hot/logical backup procedures using shell (LINUX) scripting and also using RMAN. Developing, testing & implementing strong backup and recovery strategy. Also responsible for monitoring backups.
• Responsible for creating RMAN catalog Database and Registering the Databases in Catalog Database and Cloned production RAC instances to development and QA systems using RMAN duplication.
• Extensively worked in various areas of Dataguard i.e. Installation, Recovery, RTA (Real Time Apply), Patching, Tuning, Switchover, Switchback and Failover
• Involved in checking and writing scripts for managing table space growth, monitoring the data file growth and extents too and Monitoring of CPU usage, I/O contention, memory paging and identify the resource and performance bottleneck and reorganization for ensuring performance.
• Monitored queries with high response time and high disk read per execution (Top SQLs) and tuning the same using Explain Plan, TKPROF and SQL tuning advisor.
• Involved in De fragmenting data blocks of table spaces for optimized performance. Also partitioned large tables to increase performance.
• Applied patches whenever necessary by downloading them from Metalink.
• Automated Database refresh from the Host system to Oracle using, SQL and PL*SQL procedures.

Confidential

Sr. Oracle DBA

Environment: Oracle 11g/10g/9i, Data Guard (Physical standby), OEM grid control 11g, Linux, AIX, Tru64, Windows, OVM, RMAN, Export/Import, Datapump, PAM CyberArk, ESM, TWS, Legato, Data domain, OID/LDAP, MS SQL 2008 R2/2012/14, SSIS, SSRS, SSAS, PAM CyberArk, ESM, TWS,Foglight, Legato.

Responsibilities:

• Migrated/consolidated various systems (applications) from one data centre to another.
• Played key role in consolidating systems running in different data centres into one central location as part of optimization program.
• Co-ordinating with various teams like windows, backup, storage and UNIX.
• Migrated old version Oracle databases onto new infrastructure running on 11g.
• Based on the service criticality levels designed and implemented high availability and disaster recovery solutions.
• Closely worked with UNIX team for implementing high availability solutions for databases using AIX HACMP also data guard physical standby setup for DR.
• Performed Disaster Recovery tests for SC1/DR1 and SC2/DR2 service criticality level systems before go live.
• Performing refreshes using RMAN, Export/Import and Datapump, Restoration of backups from TSM Servers.
• Capacity planning and resizing datafiles, tablespaces etc.
• SQL tuning using Tkprof and explain plans, setting up SQL profiles, looking for long running queries, gathering adhoc statistics and identifying blocking sessions etc.
• SQL server 2008 R2/2012/2014 RDBMS builds and users setup
• SSIS Installation, users and proxy setup.
• SSIS Deployment using manifest and batch files.
• Manage Oracle, MSSQL, Unix and SharePoint teams and help to the team in critical issues.
• Setting up multiple SSRS databases
• Database capacity uplifts
• SQL deployment related activities
• Linked server setup, granting required permissions
• SSAS builds and Users setup
• Co-ordination with Primary DBA and System Admin people in London and New York.
• Used 10g features such as Data Pump, Flash Back Recovery, ASM, AWR, and ADDM.

Confidential

Sr. Oracle DBA

Environment: Oracle 9i,10g on Sun OS 5.9, TOAD.

Responsibilities:

• Responsible for creating database at central server, which is located at their head quarters.
• Implementing and maintaining database security (create and maintain users, roles and assign privileges)
• Monitored the production Oracle alert logs for database errors and system resource availability and responded to system memory and data issues.
• Generating performance reports using AWR SQL Reports, ASH Reports, ADDM, and Cloud Control
• Cloning/duplicate of database with RMAN (Recovery Manager) and user managed backups like hot or cold backups.
• Performing schemas refresh/Database refreshes using legacy exp/imp and datapump.
• Maintain and monitor the physical layout of Disk storage, table spaces, data files, and object extents.
• Implementing the incremental, cumulative incremental and full RMAN backup for each database to have space management and effective recovery.
• Troubleshooting and fixing issues with Physical standby(DR setup)
• Configuration of table space and Archive utilization scripts through Crontab.
• Applied latest releases of the RDBMS patches from Oracle to the Production and test instances to resolve few technical challenges & issues.
• Prepared standard build guides, SOPs (standard operating procedures) for teams use.
• Setting up reporting environments using data guard logical standby.
• Looking for long running sessions, identifying and cleaning up blocking sessions.

Confidential

Sr. Oracle DBA

Environment: Oracle Applications 11i, Red Hat Linux AS 3.0.

Responsibilities:

• Install Oracle Applications 11.5.9 on RH Linux AS 3.0.
• Instance Cloning for functional, technical and testing teams.
• Track all the Patch/Patch set levels for all applications.
• Clone application and database tiers after patches are applied.
• Maintain application data using System Administration module including users, responsibilities, printers, registration of concurrent programs and requests, etc.
• Monitor Application performance using stats package and implement recommended parameters to tune the application and boost performance.
• Backup and Recover required instances using RMAN.
• Tune SQL statements in custom applications when required and or requested by the development team members.

Confidential

Oracle DBA

Environment: Oracle 8i, Oracle 9i, AIX, Linux, Windows 2000

Responsibilities:

• Basic DBA activity- Creating and managing Oracle Database server, Performance Tuning, Storage management and maintenance (Tablespace, Data file, table, indexes etc.), Database security (User & Resources, User Privileges & Roles).
• Perform database backup, recovery.
• Performing the media/object recovery in the event of any database crash or user accidents.
• Monitoring database environment.
• Implement the Database Design. The DBA has ultimate responsibility for the physical database design. Take care of the Database design and implementation.

Confidential

Oracle DBA

Environment: Oracle 8i/9i, Windows 2000, Red Hat Linux AS 3.0 and Informatica 6.2.

Responsibilities:

• Administer Oracle 8i/9i/10g databases.
• Database size optimization and space analysis.
• Backup and restore databases.
• Migrating databases from one instance to another.
• Monitoring database environment.
• Install Oracle on Windows 2000 and all Unix Flavors.
• The work involves overall Installation, Maintenance, Performance Tuning, Backup, Recovery and other database related activities.
• Performed daily maintenance tasks like space management, user management, managed quotas etc.
• Worked with PL/SQL developers to write limited database code, Packages, Procedure, functions and DB triggers to query bridge data.