Technical Architect- Oracle DBA
Novartis HealthCare Pvt. Ltd
مجموع سنوات الخبرة :18 years, 10 أشهر
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
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.
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
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
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
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
in
from
BSC
Post Graduate Diploma in Computers