ANKUSH CHAWLA

Technical Architect- Oracle DBA at Novartis HealthCare Pvt. Ltd

• India
• My current job since March 2016

Oracle 11g OCP DBA, Oracle GoldenGate and Exadata Certified.
Done POC on Oracle Cloud, and Hadoop Installation and Configuration

RESPONSIBILITIES
GoldenGate
Setup, Configuration of Golden gate for Oracle RAC DB by using DBFS
Migration and upgrade of the oracle databases and SQL Server DB using GoldenGate
High Availability for Goldengate by using Agctl.
Using Advanced Features of Encryption, Tuning and Troubleshooting.
OEM 12c
Installation of OEM 12c on different UNIX flavors
Upgrade of OEM10g/11g to OEM12c using 1 and 2-system approach.

Exadata
Migrating databases to Exadata environment
Monitoring and Administration of Exadata Machines
Tuning of Database on Exadata Machines
Oracle Database Security
Installation, Configuration of Oracle Audit Vault Server and Oracle Database Firewall
Implementation of Oracle Data Vault
Create & Maintain Roles and assign necessary privileges to users according to business rules
RAC
Install, Configuration of Grid Infrastructure and RAC database
Migration of Single Instance to RAC
Troubleshooting, tuning RAC database
Data Guard
Setup of physical standby database
Monitoring and switchover using DGMGRL
Space Management and Performance Tuning
Tuning Database Instance, IO and SQL Query, and CPU utilization.
Regular Maintenance of the database to remove any performance bottleneck
Planning & Checking Database Growth Periodically
Backup and Recovery
Recovering the Database without or minimal Loss of Data using RMAN
Evaluating the Backup & Recovery strategies/ procedures on a Single Instance/RAC database
Migration of databases using RMAN
Oracle Apps
Cloning and Patching of Oracle APPS11i/12i

Oracle Cloud
Basic Understanding and Done POC on Migrating DB’s to Oracle Cloud

HADOOP
Installation and Initial Configuration

Principal Consultant

• June 2013 to March 2016

Senior Consultant

• June 2013 to December 2014

Oracle Consulting - GCS
(Migration Factory)
Neiman Marcus - Offshore
Migration of DB’s to Exadata Machine
•Migration of 24X7 production Database to Exadata Machines using data pump and GoldenGate
•Installation and Configuration of GoldenGate
•Monitoring and Administration of Exadata Machines
•Migration of DEV/TEST Database using expdp
•Automation of Migration using scripts with minimum manual intervention
Los Angeles County, CA - Onsite
Migration from file System to DB
- Setup of New RAC Databases
- Tuning the Database after migration
- Setup of Data Guard

Verizon Telematics-Offshore
•New Setup of Oracle 12c RAC, Single Instance and DG.
•Setup of Oracle 12c/11g RAC Servers with pluggable database
•Implementation of OEM12c and adding plugins for applications like Siebel, AIA, CCA etc
•Adding Metrics, rules for monitoring of applications
•Oracle GoldenGate online synchronization from RAC to single instance node.
Karur Vasya DB Security Setup - Onsite
•Accessing the database for the security Requirements
•Identifying the Security threats using Audit data
•Password Policies, User Accounts, Privileges, Database Vault etc.
•Implementation of Database Audit Vault Server for monitoring and generating reports for database auditing information
•Implementation of Database Firewall on Span Port/actual Ports to monitor all SQLs on UAT and PROD to monitor and block the queries.
•Implementation of Database Vault on PROD to restrict DBAs to access the secure information.

Escalation Lead - Senior Engineer at Warner Cable Company (Navisite)

• September 2012 to June 2013

Oracle, SQL Server Database Escalation Lead for the DBA Support Team
•Playing the role of Escalation lead for 24X7 Support teams
•Build Standalone and RAC Servers
•Oracle DB, SQL Server DB Remedy tickets
•Configuring OEM’s and Monitoring
•Coordinated with Customers for the requirement and understanding of level of effort for the projects.
•Maintained defined SLA’s and monitoring of Remedy Tickets
Orange Business Service

Lead DBA

• June 2009 to September 2012

Clarify Infrastructure Upgrade Project
•Planning for the Upgrade Oracle 9.2.0.6 to 11.2.0.4
•Setup of RAC Database: Installation, configuration of Clusterware and ASM instance.
•Installation and Upgrade of Oracle 11.2.0.4
•Online Migration using Export/Import and GoldenGate Sync
•Migration of Database from Solaris 8 to HP-UX
•Creation of Data Guard for the production database

Technically Leading a project team of 6+ Oracle DBAs.
•Performance enhancement of DB by de-fragmentation, rebuild etc.
•Understanding the requirement of Clients/Users (BA and Testing Analyst).
•Cloning/Refreshing of Test/DEV Database using RMAN backups or expdp/impdp.
•Oracle Instance Tuning : Evaluating AWR and ADDM reports.
•SQL Queries Tuning : Working with development team to tune queries
•Monitoring and Maintence for Oracle 10g/11g RAC and DG
•Troubleshooting as and when required

Senior Software Engineer-DBA Technical Support at Quark Systems

• June 2008 to June 2009

Team Members for DBA Activities :
•Creating Scripts for User Managed Hot backups for the Internal Quark database.
•Oracle Instance Tuning. Generating and Evaluating Statspack Report and Trace files.
•Oracle Apps: Cloning, Creating Scripts for starting stopping services. Changing passwords as required.
•Tablespace and User Management.
•Conduct training in Oracle and SQL Server to the product support team

Consultant-DBA at Sopra Group

• India
• October 2007 to June 2008

Axway Support Team Member for DBA Support in Sentinel Product
•Supporting Away customer for day-to-day Oracle issues and product issues.
•Oracle Instance Tuning: By rebuilding and optimization of indexes.
•Working with development team to tune queries as and when require
•Space Management and Maintence Activities

Software Engineer at Simcom Solutions

• India
• August 2005 to September 2007