Sr. Oracle Database Admin
Oracle
(Internet and Information Technology, >10.000 employees)
Keywords
Skills
Goldengate, Exadata, Oracle RAC, Oracle ASM, Dataguard, Oracle Database 9i/10g/11g/12c/18c/19c, Oracle performance tuning, Data pump,
Oracle Database Upgrade, Oracle Database Patching, Oracle Database Migration, Unix, Shell Scripting.
Oracle Database Upgrade, Oracle Database Patching, Oracle Database Migration, Unix, Shell Scripting.
Project history
02/2018
-
Present
- SR support 24/7 on all oracle products.
- Respond to customer requests quickly and document corrective action
- Perform analysis and troubleshooting of queries; provide performance improvement recommendations
- Participated in all phases of the system development life cycle from requirements analysis through system implementation.
- Collaborated with development team to tackle database/application issues
- Trouble shooting, admin and end-to-end support to Customers Install and patch database Exadata software and related components
- Providing the 24*7 database operation.
- Oracle Goldengate Configuration: Responsible for the configuring and designing
- Oracle Goldengate EXTRACT, REPLICAT, PUMPS and their parameters for the high availability solutions which are adding values to the client’s investment.
- Oracle Goldengate Process is configured in such way that it will not create any load on production and read data from Archive logs of the production. And provide the data for the real-time reporting.
- Database Migration specialist using various tools Rman,Gldengate,Datapump,O2O tool
05/2017
-
02/2018
Senior Database Admin
Indecomm Golbal Services
(Internet and Information Technology, 5000-10.000 employees)
- 24/7 Support production, dev and test instances
- Oracle Goldengate Configuration: Responsible for the configuring and designing Oracle Goldengate EXTRACT, REPLICAT, PUMPS and their parameters for the Online Solution.
- Supported bi-directional replication, broadcasting data from Enterprise Data warehouse to downstream database at client location
- Test impact of multiple Extract and Replicat processes on a Single Node
- Prepare Confidential parameter files for Extraction and Replication
- Investigate, trace fix and report replication failures using Logdump
- Oracle Goldengate Process is configured in such way that it will not create any load on production and read data from Archive logs of the production.
- Troubleshooting of the Goldengate components and queries related to customer account data.
- Analyze database current growth rate and allocate suffice storage for future growth.
- Granting Roles and privileges to users.
- Handling the performance related tasks by rebuilding, Analyzing and SQL Query level tuning.
- Importing and exporting Data with IMP/EXP or Data Pump utility according to the users request and maintenance of Oracle Production, Development and QA databases.
- Handling issues related to Space Management, Locks, Backup failures and Database related On-Call alerts.
09/2015
-
05/2017
Senior oracle database admin
Sabre Travel Technologies
(Telecommunications, 5000-10.000 employees)
Installed and configured 3 node cluster with ASM
* Configured and monitored databases using grid control
* Proactively tuned SGA as required
* Installed Confidential software in Test and dev instances
* Configured Confidential on production servers
* Setup classic capture replication mechanism using Confidential
* Configured Confidential to achieve unidirectional and bidirectional replication
* Implemented database auditing and regularly monitored active user sessions
* Troubleshooting and fixing Confidential errors in a 2 node RAC production environment
* Applied patches, quarterly patch security updates to existing instances
* Upgraded Oracle Server Software from 11gR1 to 11GR2.
* Upgraded oracle 11gR2 to 12c
* Tune Performance of SQL queries used in reporting real-time statistics
* Involved recovery of database information and maintaining automated schema refresh whose data
changes regularly using export/import
* Experience of monitoring and rebuilding indexes and analyzing very large tables
* Monitoring standby database in a data guard configuration
* Setup DataGaurd broker successfully
* Implemented and configured Confidential on a 2-node RAC cluster
* Experience in analyzing views and DBA views
* Scheduled database performance tuning reports using Stats pack and AWR reports
* Troubleshoot complex SQL using explain plan and TKPROF utility
* Maintaining and monitoring logical and physical structure of database
* Documented corn jobs, replication setup, post migration and post upgrade procedures
* Setup ACFS mount for GG replication for multi node RAC clusters
* Setting up Cluster ware registration to handle Confidential automatically
* Configured and monitored databases using grid control
* Proactively tuned SGA as required
* Installed Confidential software in Test and dev instances
* Configured Confidential on production servers
* Setup classic capture replication mechanism using Confidential
* Configured Confidential to achieve unidirectional and bidirectional replication
* Implemented database auditing and regularly monitored active user sessions
* Troubleshooting and fixing Confidential errors in a 2 node RAC production environment
* Applied patches, quarterly patch security updates to existing instances
* Upgraded Oracle Server Software from 11gR1 to 11GR2.
* Upgraded oracle 11gR2 to 12c
* Tune Performance of SQL queries used in reporting real-time statistics
* Involved recovery of database information and maintaining automated schema refresh whose data
changes regularly using export/import
* Experience of monitoring and rebuilding indexes and analyzing very large tables
* Monitoring standby database in a data guard configuration
* Setup DataGaurd broker successfully
* Implemented and configured Confidential on a 2-node RAC cluster
* Experience in analyzing views and DBA views
* Scheduled database performance tuning reports using Stats pack and AWR reports
* Troubleshoot complex SQL using explain plan and TKPROF utility
* Maintaining and monitoring logical and physical structure of database
* Documented corn jobs, replication setup, post migration and post upgrade procedures
* Setup ACFS mount for GG replication for multi node RAC clusters
* Setting up Cluster ware registration to handle Confidential automatically
11/2014
-
09/2015
Oracle Database admin
IBM India Pvt Ltd
- Managing around 3500 databases.
- Oracle Goldengate on Standalone, RAC and end-to-end support.
- Upgradation, patching, Maintenance activity.
- Daily Database health checks report preparation and monitoring the database growth.
- Oracle upgrade from 10g to 11g.
- Goldengate support Maintaining, admiration and trouble shooting
- Monitoring the temporary table space usage.
- Troubleshooting database related issues.
- Performance monitoring through Nagios tool. Closely monitoring the database mount point.
- Managing space related issues, adding & resizing the space in data files.
- Identifying the user locks and intimating the same to clients.
- Identifying the Long running queries and clearing the same.
- Issue analysis through log files. Ensure the smooth run of RMAN backup of all production databases.
- Schema level refreshing by using exp/imp, expdp/impdp.
- Database level refreshing by using RMAN.
11/2011
-
11/2014
Associate Database Administrator
Ceva Logistics; HCL Technologies
* Installing and Maintaining Database on Unix/Linux and Windows Platform using OUI
* Installing different version of Oracle in the same server (10g & 11g).
* Oracle Installation in silent mode.
* Installed and implemented 2 nodes cluster RAC11g setup on RHEL 5.6.
* Used the SRVCTL utility to manage, start, and stop Oracle Database and services.
* Data guard configuration and maintenance
* Creating new user accounts, profiles, and roles and assigned them to different users.
* Troubleshooting database related issues.
* Provide technical support to customers.
* Daily report extraction for Database performance.
* Performance Monitoring through Viking tool as well as manually.
* Closely monitoring the server CPU utilization and load average for production databases.
* Applying latest security (CPU Patches) on all the environments from development, test to
production after testing.
* Managing space related issues, adding & resizing data files.
* Check and ensure the smooth run of RMAN backup of all production databases.
* Provided 24x7 on-call supports. Worked beyond regular hours based on business demands.
* Installing different version of Oracle in the same server (10g & 11g).
* Oracle Installation in silent mode.
* Installed and implemented 2 nodes cluster RAC11g setup on RHEL 5.6.
* Used the SRVCTL utility to manage, start, and stop Oracle Database and services.
* Data guard configuration and maintenance
* Creating new user accounts, profiles, and roles and assigned them to different users.
* Troubleshooting database related issues.
* Provide technical support to customers.
* Daily report extraction for Database performance.
* Performance Monitoring through Viking tool as well as manually.
* Closely monitoring the server CPU utilization and load average for production databases.
* Applying latest security (CPU Patches) on all the environments from development, test to
production after testing.
* Managing space related issues, adding & resizing data files.
* Check and ensure the smooth run of RMAN backup of all production databases.
* Provided 24x7 on-call supports. Worked beyond regular hours based on business demands.
Local Availability
Only available in these countries:
India
I will travel any time upto 75%
