SUMMARY

• Over 16+ years of IT experience working on various part Oracle Database administration activities.
• Oracle Certified Professional 11g
• Exposure to Goldengate, Configuring extract, manager & replicat process.
• Expert in Oracle 11g, 10g, Oracle 9i and SQL server .
• Experience working on Oracle 19c,12c, 12C OEM, 11gR2, 10g RAC, ASM & Data Guard, RMAN.
• Build, configure and maintained Oracle Databases.
• Extensively worked on Oracle 10g and 11g production support activities in HA environment.
• Experience in Oracle Server Installation, Database Configuration, Troubleshooting on HP UX, Solaris, Aix, Linux.
• Experience in implementing and maintaining Database Security Guidelines.
• Provide solutions for physical/logical database structure and functional capabilities, database security, data back - up, and recovery specifications.
• Performing administrative tasks: database files management, backup/restore, security management, Database Mirroring, data integration, and synchronization.
• Monitor and analyze database activity to proactively identify and prevent potential Incidents and also recommend performance improvements.
• Performing database monitoring using OEM, shell scripts, and resolving reporting issues on replicate databases as reported by Reporting Managment system.
• Provides database support by coding utilities, responding to user questions, and resolving problems.
• Provides Oracle Database administration specialistsupport running on Unix/Linux servers.
• Indexes and query optimization for bad queries based on the database analyzer and query plan.
• Database architectureand DB modeling by designing the logical and physical database structure.
• Maintains database performance by identifying and resolving production and application development problems; calculating optimum values for configuration parameters.
• Tune database Design and plan for load balancing based on the utilization.
• Capacity planning for the critical Applications and Oracle Databases.
• Performed to fix the Oracle index/Object fragmentation for the highly usedobjects and scheduledaily update stats on the critical objects as part of maintenance.
• Experience in designing and implementing Backup and recovery Strategies. Experience in administering tasks like monitoring, error checking and running health checkup.
• Expert in performing Database Backup and Recovery, Database cloning using RMAN, Database Creation/Migration/Upgrade, Export/Import data, Storage allocation, Database Reorg, Database and SQL Tuning, Capacity Planning, Managing Users, and Creation of physical database objects from logical model.
• Experience in Planning Database, Sizing table space, Create database, scripts, Monitor databases, Interact with developers, Oracle Install, Upgrade, 24x7 DBA support, Disaster recovery Automate daily jobs, Schema management, SQL loader, Export/import Database, Tune database.
• Experience in Configuration of RMAN.
• Oracle performance tuning considering Oracle wait event, optimizer and Histogram and clustering factor.
• Exposure to Oracle Utilities and Tools like OEM, Import-Export, DBCA, RMAN, Netapp.
• Experience and exposure to Oracle features like Partitions, Materialized views, Indexes.
• Experience in handling large databases (size in TB) and also large number of databases in multi OS environments & OLTP, DSS.
• Experience in migrating databases on cross platform.
• Experience in Leading US and global project for Database Administration in banking and telecom domain. Coordinating with Support Managers in US and UK being a global team member.
• Documenting the processes.
• Worked extensively on Remedy, GSD as ticketing system to accept user/client ticketing requests as well as on “Tivoli” monitoring system according to the ITIL standards.
• Experience in Performance Tuning databases using various techniques. Collected performance statistics memory usage, data storage, data manipulation, physical / logical storage, network traffic and implement / manage parallelism for optimum performance using Explain Plan, SQL Trace, AWR & ADDM.
• Experience in monitoring and supporting RAC databases, ASM, CRS patching.
• Knowledge of MS sql and Mysql databases.
• Knowledge on AWS ( Oracle), completed POC for one the highly fluctuating application database.

TECHNICAL SKILLS

RDBMS: Oracle 19c, 12C, 11gr2, 10g, Oracle 9i, Oracle Goldengate

Operating Systems: Sun Solaris 8/9, Aix, HP UNIX, Linux.

Languages: SQL and Shell Scripting.

Tools: Toad, SQL*plus, OEM, Addm, Awr, ASH, ADDM, Stats pack, RMAN, SQL*Loader, sql developer, Golden gate, Remedy, ERWIN, Control M, Patrol, NDM - connect direct.

PROFESSIONAL EXPERIENCE

Confidential

Sr. Oracle DBA

Responsibilities:

• Provide solutions for physical/logical database structure and functional capabilities, database security, data back-up, and recovery specifications.
• Performing administrative tasks: database files management, backup/restore, security management, Database Mirroring, data integration, and synchronization.
• Support migration from lower version to 12c and 19C.
• Provide solutions to post migration performance issues.
• Monitor and analyze database activity to proactively identify and prevent potential Incidents and also recommend performance improvements.
• Goldengate replication (oracle to oracle and Oracle to Kafka)
• Performing database monitoring using OEM, shell scripts, and resolving reporting issues on replicate databases as reported by Reporting Management system.
• Provides database support by coding utilities, responding to user questions, and resolving problems.
• Resolve database performance issue using Active workload repository (AWR) report and Active Session History (ASH) report.
• Provides Oracle Database administration specialistsupport running on Unix/Linux servers.
• Indexes and query optimization for bad queries based on the database analyzer and query plan .
• Database architectureand DB modeling by designing the logical and physical database structure.
• Maintains database performance by identifying and resolving production and application development problems; calculating optimum values for configuration parameters.
• Tune database Design and plan for load balancing based on the utilization.
• Capacity planning for the critical Applications and Oracle Databases.
• Performed to fix the Oracle index/Object fragmentation for the highly usedobjects and scheduledaily update stats on the critical objects as part of maintenance.

Confidential

Sr. Oracle DBA

Responsibilities:

• Support OSM, ASAP and UIM database operations.
• Monitoring database health and provide recommendations.
• Performance tuning of database, plan baselining based on different situation.
• Understand existing systems and client processes and help operations team in critical changes during after hours.
• Database backup configurations, 10g,11g and 12c (CDB and PDB) DBA support.
• Trouble shooting the runtime issues and helping development teams for better performance of their changes.
• Monitor and analyze database activity to proactively identify and prevent potential Incidents and also recommend performance improvements.
• Performing database monitoring using OEM, shell scripts, and resolving reporting issues on replicate databases as reported by Reporting Management system.
• Resolve database performance issue using Active workload repository (AWR) report and Active Session History (ASH) report.
• Raising /follow up on platinum SR with oracle support for issues during oracle exadata database support.
• DBA level performance tuning, monitoring plan changes and using SPM to fix plan change.
• Used AWR, explain plan for performance related issues.
• Indexes and query optimization for bad queries based on the database analyzer and query plan.
• Support oracle real application cluster ( RAC) and data guard.
• Refresh of production data to preprod environments using export/Import & RMAN.
• Participate in on-call support of production databases on a rotating basis.
• Pro-actively monitor production database for high availability and performance.
• Provide DBA support to assigned projects.
• Perform database upgrade, migrate and patching as per requirement
• Enforce best practices in all areas of database administration and architecture
• Database optimization and performance tuning.
• Provides Oracle Database administration specialistsupport running on Unix/Linux servers.
• Batch jobs monitoring, execution status verification and remedial actions.
• Validating and monitoring database during batch jobs execution and taking care for smooth execution
• Support and Rebuild physical and logical standby databases as per requirement.
• Prepare Method of Process (MOP) and get approvals on same from CAB (Change management).
• Oracle performance tuning considering Oracle wait event, optimizer and Histogram and clustering factor.
• Goldengate implementation, monitoring and troubleshooting issues.

Environment: Oracle 11g, 12c, ORAAS, Rman, Sql developer, SSH Tectia,Service now, OEM, shell script, AWR, ASH, ADDM, hang analyzer, Sql tuning advisor, data modeling tool, Real application cluste, dataguard, Physical and logical standby, Goldengate, exadata, ASM, import-export

Confidential

Oracle DBA

Responsibilities:

• Worked for TCS oracle practice for 4+ years.
• Work in Staff augmentation mode.
• Understand existing systems and client processes.
• Database build and environment readiness activities and process documentation.
• Oracle database - Performing administrative tasks: database files management, backup/restore, security management, Database Mirroring, data integration and synchronization, installation, upgrade and patching, testing performance and scalability.
• Monitor and analyze database activity to proactively identify and prevent potential Incidents and also recommend performance improvements.
• Performing database monitoring using OEM, shell scripts, and resolving reporting issues on replicate databases as reported by Reporting Managment system.
• Provides database support by coding utilities, responding to user questions, and resolving problems.
• Provides Oracle Database administration specialist support running on Unix/Linux servers.
• Indexes and query optimization for bad queries based on the database analyzer and query plan.
• Database architecture and DB modeling by designing the logical and physical database structure.
• Tune database Design and plan for load balancing based on the utilization.
• Database backup configurations, 10g, 11g and 12c (CDB and PDB) DBA support.
• Using data guard provides possibilities to minimize the time of migration and down time of the system.
• POC and scoping for offshore-onsite support model in IS area.
• Trouble shooting the runtime issues.
• Raising /follow up on SR with oracle support for issues during database support.
• Provide solutions for physical/logical database structure and functional capabilities, database security, data back-up, and recovery specifications.
• Performing administrative tasks: database files management, backup/restore, security management, Database Mirroring, data integration, and synchronization.
• Monitor and analyze database activity to proactively identify and prevent potential Incidents and also recommend performance improvements.
• Performing database monitoring using OEM, shell scripts, and resolving reporting issues on replicate databases as reported by Reporting Management system.
• Provides database support by coding utilities, responding to user questions, and resolving problems.
• Resolve database performance issue using Active workload repository (AWR) report and Active Session History (ASH) report.
• Provides Oracle Database administration specialistsupport running on Unix/Linux servers.
• Indexes and query optimization for bad queries based on the database analyzer and query plan .
• Database architectureand DB modeling by designing the logical and physical database structure.
• Maintains database performance by identifying and resolving production and application development problems; calculating optimum values for configuration parameters.
• Tune database Design and plan for load balancing based on the utilization.
• Capacity planning for the critical Applications and Oracle Databases.
• Performed to fix the Oracle index/Object fragmentation for the highly usedobjects and scheduledaily update stats on the critical objects as part of maintenance.
• Configured Goldengate unidirectional topology for Dangerous Goods database.
• Configure Oracle Goldengate processes like Manager, Extarct & Replicat.
• Monitoring Goldengate, verifying lag & taking remedial actions
• DBA level performance tuning, expert in sql tuning for various application teams.
• Sql tuning using SQL Tuning Advisor
• Used AWR, explain plan for performance related issues.
• Patching and upgrade in different environment as per requirement.
• Support oracle real application cluster.
• Implementing backup policies using RMAN.
• Oracle performance tuning considering Oracle wait event, optimizer and Histogram and clustering factor.
• Refresh of production data to Dev/QA environments using export/Import & RMAN.
• Ensuring regular hot backups & archive backups.
• Understand, modify automations in shell script.
• Support and Rebuild physical and logical standby databases as per requirement.
• Batch jobs monitoring, execution status verification and remedial actions.
• Prepare Change Requirement Form (CRF) and get approvals on same from CAB (Change management).
• Prepare SPP (Service Protection Plan) planning and fulfill support requirements for smooth SPP.
• Supporting Oracle database on exadata servers.
• Knowledge on AWS ( Oracle), completed POC for one the highly fluctuating application database.

Environment: Oracle 10g, 11g, 12c, 12C OEM, Dataguard, Rman, RAC, Exadata, Solaris, linux, Unix, netapp, Shell scripting, Sql developer, SSH Tectia, AWR, ASH, ADDM, hang analyzer, Sql tuning advisor, data modeling tool, Physical and logical standby, ASM, import-export, AWS

Confidential

Oracle DBA

Responsibilities:

• Providing 24*7 technical supports to maintain around 12 production database environments.
• Providing on-call support for critical issues on a rotational basis.
• Data warehouse DBA support.
• Leading offshore DBA team.
• ASM instance installation & configuration.
• Support in Disaster recovery activities.
• Refresh of production data to QA environments.
• Used AWR for performance related issues.
• Ensuring regular hot backups & archive backups.
• Used RMAN for database backups.
• Space management and capacity planning for future requirements.
• Sizing tablespace and undo segments.
• Used Oracle Export & Import utilities to upgrade and copy database.
• Monitor all development / testing / Production databases.
• Monitoring & automation of rebuilding the indexes at regular intervals for better performance.
• Alert logs monitoring using grid control.
• Tuning of SQL statements and performance tuning.
• Automation of day to day tasks using shell and pearl scripts.
• Oracle database - Performing administrative tasks: database files management, backup/restore, security management, data integration and synchronization, installation, upgrade and patching.
• Performing database monitoring using shell scripts, and resolving reporting issues on replicate databases as reported by Reporting Managment system.

Environment: IBM - AIX, ORACLE, SAS, data warehouse, Control M, Patrol, NDM - Connect Direct, Shell & perl script, Oracle 11g, 12c, Rman, Sql developer, SSH Tectia,Service now, OEM, shell script, AWR, ASH, ADDM, Sql tuning advisor, data modeling tool, Real application cluster, dataguard, Physical and logical standby, ASM, import-export

Confidential

Jr. Oracle DBA

Responsibilities:

• Providing 24*7 technical supports to maintain around 12 production database environments.
• Providing on-call support for critical issues on a rotational basis.
• Data warehouse DBA support.
• Support in Disaster recovery activities.
• Refresh of production data to QA environments.
• Used RMAN for database backups.
• Space management and capacity planning for future requirements.
• Sizing tablespace and undo segments.
• Used Oracle Export & Import utilities to upgrade and copy database.
• Monitor all development / testing / Production databases.
• Monitoring & automation of rebuilding the indexes at regular intervals for better performance.
• Alert logs monitoring using unix shell commands and scripts
• Tuning of SQL statements and performance tuning.
• Automation of day to day tasks using shell and pearl scripts.

Environment: Oracle 10g, Rman, Sql developer, Putty,Service now, OEM, shell script, AWR, ASH, Sql tuning advisor, data modeling tool, Real application cluste, dataguard, Physical and logical standby, ASM, import-export,IBM - AIX, ORACLE, SAS, data warehouse, Control M, Patrol, NDM - Connect Direct, Shell & perl script