SUMMARY

• Over 12 years of experience as an Oracle Database Administrator, Responsible for database administration, production support, installation, configuration, upgrades, patches, backup and recovery, database security, auditing, and space management.
• Experience as On - Call 24x7 production DBA support, application/development DBA.
• Extensive knowledge ondatabase administration for Oracle 8i, 9i, 10g and 11g,12c,18c and 19c with experience in very large-scale database environment and mission critical largeOLTP and OLAPsystems.
• Hands on experience in Oracle 10g/11g/12c/18c/19c RAC implementation & administration(Oracle Clusterware setup and configuration, RAC installation usingASM, Grid Installation).
• Good experience RAC Clusterware administration,Configuration and Patching.
• Extensive experience in Data guard configuration, implementing and maintainingstandby databases.
• Hands on experience in Grid control, Streams, GoldenGate Replication.
• Experience in Performance Tuning usingEXPLAIN PLAN, SQLTRACE, TKPROF,STATSPACK, AWRand ADDM.
• SetupOracle Enterprise Manager(OEM) 10g &Grid Control(13c) for database monitoring/performance/diagnostics.
• Extensive experience in DatabaseBackups RMAN(Full/Incrementalbackups) and in traditionalhot/coldbackups.
• Experience inLOGICAL BACKUPSand Database migration tools withDATA PUMP,Export/ImportandTransportable Tablespaces.
• Good experience in writing/editing UNIXShell Scripts.
• Good experience in PATCHING AND UPGRADATION. Expertise inupgradingOracleDevelopmentandProductiondatabases from 8i to 9i,9ito10g&11g, 10g to 11g.
• Extensive knowledge and experience on managing very large Data Warehouse databases.
• Proficient in SQL, PL/SQL, Stored Procedures,Functions, CursorsandTriggers.
• Extensive experience in configuring and implementing ASM and proficiency in usingASMCMDandASMLIB.
• Experience inFlash-Back Technology.
• Experience inDatabase Refreshand patch management and in Database cloning with RMAN and manual methods.
• Good hands-on experience in EXADATA DATABASE MACHINE Storage cell administration maintenance tasks by using cellcli dcli utilities
• Good Experience in Applying Latest Bundle Patches to EXADATA
• Created scripts in Python which Integrated with DASHBOARD API’s to control instance operations.
• Experience with deploying configuration management and CI/CD services such as (Ansible, Jenkins, Docker, JIRA)
• Installation and configuration of Oracle Enterprise Manager Cloud Control 13c
• Performed database administration, production support, installation, configuration, upgrades, patches, migration, backup and recovery, performance tuning, and cloning on the above said versions.
• Grid control, Streams, and Golden Gate.
• Used Cron jobs to automate many DBA tasks.
• Proficient in raising Service Request (SR) with Oracle Support and using Metalink to resolve the bottlenecks in the database environments.
• Extensively used Oracle Enterprise Manager (OEM) to do the daily tasks regarding performance and maintenance.
• Good experience in Patching and Upgradation.
• Expertise in upgrading Oracle development and production databases from 9i to 10g to 11g to 12c to 18c to 19c.
• Performance monitoring and tuning using SQL TRACE, TKPROF, EXPLAIN PLAN, STATSPACK, AWR, ADDM to improve the performance.
• Monitor CPU usage, I/O contention, memory paging and identify the resource and performance bottleneck. Storage Management Managing Space, Table spaces, Segments and Extents, Rollback Segments.
• Create database maintenance plans, including updating statistics, re indexing, structure modifications, Capacity plans, and index analysis.
• Hands-on experience in implementing enterprise databases on enterprise storage solutions using Storage Area Networks (SAN) / Network Attached Storage (NAS).
• Experience in database cloning with RMAN and patch management.
• Hands-on experience in capacity planning.
• Performed point-in-time recovery whenever needed.
• Excellent communication and analytical skills.

TECHNICAL SKILLS

Operating Systems: Sun Solaris, HP UX, AIX, Linux (RedHat & OEL (Oracle Enterprise)), Windows 2000, XP.

Automation: Ansible, Python, Unix Shell scripting, SQL, PL/SQL, SVN, Git, Docker.

Database: Oracle 9i, 10g, 11g,12c,18c and 19cTuning Tools: SQL TRACE, TKPROF, EXPLAIN PLAN, STATSPAK, AWR, ADDM

Protocols: FTP, SFTP, Ssh, Telnet, TCP/IP, Putty

Languages: SQL, PL/SQL, C, C++, JAVA, VB, UNIX Shell Scripting

Tools: and Utilities RMAN, Import / Export, DataPump, SQL*Loader, ASM, TOAD

PROFESSIONAL EXPERIENCE

Confidential, SC

Senior Oracle Database Administrator

Environment: Oracle 12c/11g/10g, Oracle 11g RAC, Oracle 10g RAC, PostgreSQL 9.5/9.6, MySql 5.6/5.7, MS Server 2008, 2012 & 2014, Aurora, AWS, EC2 & RDS, Nagios, Dataguard, RedHat Linux, HP-UX, Sun Solaris, IBM AIX, Windows, TOAD, Grid Control, ERWIN, SQL, PL/SQL

Responsibilities:

• 24x7 production database and applications support
• Built L1 and L2 Teams from offshore to operate under 24/7 model.
• Installed and configured Nagios monitoring tools for host and database monitoring.
• I Participated in analysis and designing of Oracle Exadata Server for infrastructure and related projects. Assisted in integration of Exadata applications into current IT actionable events and solutions.
• Maintaining and Administering EXADATA X2-2
• EXADATA monitoring by ILOM, KVM and using Oracle Enterprise Manager Cloud Control 13c
• Resolving critical query performance issues.
• Consolidating Mission critical databases on database machine Analyzing EXADATA Performance metrics.
• Exadata Monitoring setup IB switch, Cell server and compute nodes
• Create AWS instances via Jenkins with EC2 plugin and integrated nodes in Chef via knife command line utility.
• Automated various infrastructure activities like Continuous Deployment, Application Server setup, Stack monitoring using Ansible playbooks and has Integrated Ansible with Jenkins.
• Implementing new projects builds framework using Jenkins and Maven as build framework tools
• Automating backups using python scripts.
• RAC configuration Oracle 18c,12c,11g,10g,9i.
• Installation and configuration of Oracle Enterprise Manager Cloud Control 13c
• Installation, configuration and maintenance of Oracle 19c,18c,12c,11g and10g databases.
• Involved in construction of DR sites for all the Production databases.
• Performed Database Refresh from Production to QA, UAT and Development databases.
• Upgraded the Oracle 12c database to 18c version and also applied patch set and interim patches whenever required to make the database software up to date.
• Also added nodes to RAC for minimizing the downtime and maximizing the availability and also achieving load balancing.
• Monitoring Day-Day Backups, Log’s.
• Successfully implemented Backup & Recovery using RMAN, Conventional Hot and Cold backups.
• Managing backup strategy for all production databases.
• Taking the RMAN incremental (Differential & Cumulative) backups.
• Extensive experience in recovery.
• Cloning of Databases from Production to Development and Test.
• Implemented Data Guard with maximum availability, protection and performance configurations and worked with Data Guard Fail over and Switch over cases.
• Installed GoldenGate, upgraded from 10 to 10.4
• Utilized Oracle Streams to capture, propagate, and apply the transfer of data, transactions, and events within managed databases.
• Implemented DRP (Disaster recovery plan) for critical databases.
• Provided instance level performance monitoring and tuning for Wait Events, Sessions, Physical and Logical IO and Memory Usage.
• Worked extensively on Performance tuning of Queries
• Supported development teams by providing SQL statement tuning and optimizing ETL procedures and removing load and query performance bottlenecks by using tools EXPLAIN PLAN, STATSPACK, TKPROF, AWR, ADDM.
• Assessed database capacity by monitoring online storage, requirement, growth and file system space, in adherence to the OFA.
• Creation of Users and granting them the required Roles and Privileges accordingly.
• Involvement in space management, rectification of lock problems, managed quotas.
• Created database objects like Tables, Indexes, Views, and DB Links etc.
• Responsible for capacity planning, database security, recovery planning and installing patches
• Conducted time to time analysis and monitoring of the software and hardware requirements and act accordingly.

Confidential, SC

Senior Oracle Database Administrator

Environment: Oracle 11g,10g/9i Oracle 10gR2 Real Application Clusters (RAC), FOGLIGHT, BMC Tool, OEM, OAM, Optimizer Hints, Oracle Universal Installer, PL/SQL, Unix Shell scripting, RMAN, SQL*Plus, SQL*Loader, Quest tools, utility, Sun Solaris 9,, Windows NT, Windows 2000 server and AIX 5.0l/5.3.

Responsibilities:

• Installed and configured Oracle Enterprise Manager 12c/11g/10g Grid Control for Enterprise.
• Configured and managed physical standby database using Data Guard for disaster recovery on a different node for different production servers.
• Performed Data Guard switchover/failover as per the requirements.
• Created monitoring scripts to send alerts in case standby is out of sync.
• Configuring and managing two nodes UNIX RAC environment for high availability, highly busy databases.
• Worked in Oracle 10g/11g RAC environment and troubleshooting for RAC issues.
• Worked on RAC/ASM interconnect issue.
• Worked with Developers and change management team to ensure smooth life cycle progress from development through testing and production implementation.
• Provided 24/7 production support for infrastructure and performance areas.
• Performed the migration and up-gradation of Oracle databases by using import/export, Oracle Data Pump, and Transportable tablespaces.
• Day to day troubleshooting like adding space in data files, rebuilding indexes, check alert log file and monitoring of system.
• Cloned databases on same node and also on different server nodes using custom shell script with hot and cold backups of source database.
• Upgraded and patched Oracle binaries in the development environment and production environment.
• Upgraded Oracle from 11.2.0.1 to 11.2.0.3.
• Performed load testing on pre-production multisite database servers.
• Coding and optimizing objects for data access.
• Responsible for setting up production, development, performance, and staging database environments.
• Reorganized existing database to standardize the placement of various databases related files.
• Managed logical/physical backups for these databases depending on the nature of database set up either full export, partial export or export of just the structure of schema objects.
• Monitored and audited database access for unauthorized access.
• Work as part of team and provide 24x7 supports when required.
• Do general technical trouble shooting and give consultation to development teams.
• Have Applied Patches to existing versions.
• Created tablespaces and managed tablespaces adding/deleting/ resizing data files.
• Utilized SQL Loader ETL to perform bulk data loads into database tables from external data files.
• Use of Crontab, DBMS JOBS to automate the monitoring jobs.
• Performance tuning of application by identifying the SQL, which are not written well providing inputs to the application programmer correcting and implementing the right components.
• Administered all database installation, creation, modification, and tuning issues of Oracle.
• Performed SQL tuning by using Explain Plan and AWR/ADDM.
• Tuned SQL by buffer gets and I/O.
• Generated working documentation for the DBA team use.
• Analysis of alert log for error tracing.
• Resolved different locking issues.
• Worked on daily DBA activities.

Confidential

Senior Oracle Database Administrator

Environment: Red Hat Linux, Oracle 10g RAC and 11g RAC, Oracle Enterprise Manager/Grid Control, RMAN, DataGuard, ASM, SCP/SFTP, Net App, TKPROF, Explain plan, AWR, ADDM, SQL* Plus, Crontab, PL/SQL, SQL* Loader.

Responsibilities:

• 24x7 Production on call Database support
• Installed configured, maintained and tuned Oracle 10g and 11g databases.
• Upgraded database from Oracle 10g to Oracle 11g R2.
• Installed and configured Oracle 10g RAC, Oracle 11g RAC.
• Involved in Migration of Non RAC single instance to Real Application Cluster (RAC) database instances.
• Converted Single Instance Database to Multi Node RAC
• Involved in Design, implementation and generating documentation of Oracle 10g, 11g Data Guard on both physical/logical standby databases in high availability mode.
• Performed capacity planning and bench marking.
• Implemented Dataguard, creating both Logical and Physical Standby databases in 10g RAC, 11g RAC environment for the Production databases.
• Implemented Cumulative, Differential, Incremental backups using RMAN
• Written and modified UNIX shell scripts, to manage Oracle environments
• SQL tuning and Database performance tuning has been done based on reports generated by SQL Trace, Explain Plan, AWR, ADDM and monitor the database performance on daily basis.
• Planning Backup/Restoration Strategy, Planning and scheduling Backups, taking Logical Backups (with Export/Import Data pump utilities).
• Creating & Managing Database Structures, Storage Allocations, Table/Index segments, Constraints, Database Access, Roles and Privileges.
• Performance tuning of Queries by maintaining Aggregates, Compression, partition, indexing and use of Hints, Stored outlines, Statistics for the same.
• Organized various migration review meetings with the application team to discuss the migration strategy based on business requirements.
• Performed SQL and PL/SQL tuning, oracle contention and monitored production database using automatic workload repository (AWR), automatic database diagnostic monitor (ADDM) and active session history.
• Automated the backups
• Cloning & duplicating databases using scripts as well as RMAN.
• Expertise in recovering the database. Performed complete recovery, data file recovery, incomplete recovery.
• Data loads using SQL*Loader and external tables.
• Created and scheduled jobs using DBMS Scheduler
• Configured database targets in the ORACLE Enterprise Manager (OEM).
• Experienced in Database Security User Management, Privileges, Roles, Auditing
• Applied security patches, Patch Set Unit PSU and Performed testing.
• Written monitoring scripts and scheduled them using the Crontab
• Worked closely with the Oracle developers for the better performance in Applications in writing the efficient SQL and PL/SQL Packages, Procedures, Functions and Triggers.
• Used Secure SCP & FTP extensively for the File transfers from machines to remote server.
• Working with Oracle support to resolve critical issues like ORA-600 errors.

Confidential

Senior Oracle Database Administrator

Environment: Sun Solaris, HP UX, AIX, Linux RHEL, Oracle 10gRAC/11g RAC, Data Guard, Datapump, RMAN, ASM, GoldenGate, PL/SQL, SQL Scripts, Shell Programming, TOAD, Putty.

Responsibilities:

• 24x7 Production database and applications support.
• Installed 11gR2 RAC with 3+ nodes on SAN (Storage Area Network) of 2TB size using ASM.
• Administering ORACLE Databases 9i, 10g, 11g and Oracle10g RAC/11g RAC.
• Applied patching for upgrading database from 9i to 10g,10g to 11g and for other updates.
• Configured Oracle grid control to manage the entire database in single centralized location.
• Applied database patches using Opatch utility, building Clone instances for Development and Test teams.
• Managing multiple production, testing, QA and development databases.
• Cloned/Refreshed databases from production database to test and development.
• Implemented backup and recovery strategies using export/import, RMAN Incremental backups), Traditional hot, cold backups.
• Created shell scripts and Perl scripts scheduled them for monitoring Oracle Databases.
• Working with Development, QA and other teams to support the related issues.
• Creating primary database storage structures (tablespaces), altering, and modifying the database structure according to the company’s requirement as necessary, from information given based on business requirements.
• Setup Standby databases including Active Data Guard for disaster recovery and reporting.
• Implemented Oracle RAC with Data Guard implementation for disaster recovery.
• Planning and implementing Backup and Recovery procedures (RMAN), scheduling daily backups and performed periodic recovery tests.
• SQL tuning using SQL Trace and TKPROF, Explain Plan, STATSPACK, AWR, ADDM.
• Tuning init.ora parameters for optimal performance and scalability.
• Running AWR reports to figure out the bottleneck and analyze using ADDM.
• Database Maintenance and clearing of locks, cleaning of database logs, rebuilding indexes, Tablespace monitoring, database objects monitoring.
• UNIX scripting for automation backups, monitoring, statistics collection as well as for other routine tasks.
• GoldenGate installation, configuration for replication.
• Designing the security and database access strategies & cloning databases and partitioning tables.
• Creating and refreshing materialized views & performing SQL*loader jobs for data loading.
• Performance tuning and Monitoring using OEM Grid Control.
• Problem resolution repository is built in custom DBA ticketing tool.
• Working with Development, QA, and other teams to resolve the issues.

Confidential

Oracle Developer/ DBA

Environment: Oracle 9i/10gRAC, RHEL, HP UX, Sun Solaris, SQL, PLSQL, UNIX Shell Scripting, RMAN, Oracle 10g Grid control, Data Guard, SQL*Loader, EXP, IMP, TOAD, Datapump, TKPROF, EXPLAIN PLAN, AWR, STATSPACK, ADDM

Responsibilities:

• Proficient in installation and creation of Oracle 9i, 10g databases in development, Production and QA environments including configuration, backup & performance tuning.
• Designing, documenting and deploying through the various development and production environments.
• Refresh/Cloning of the databases from Production to the Test and Development environments.
• Upgraded database from Oracle 9i to Oracle 10g.
• Installation and Configuration of Oracle 10gRAC and Standby Databases for high availability and disaster recovery.
• Automation of deployment/migration from existing systems (Oracle), monitoring and reporting.
• Database Migration.
• Applied CPU, One-off patches using Opatch utility, RDBMS patch set Upgrade (PSU).
• Worked with Oracle Data Pump which provides high speed, parallel, bulk data and metadata movement of Oracle database contents.
• Used Oracle 10g grid control utility.
• Planned and implemented Backup & Recovery using RMAN.
• Implemented Cold Backup and Hot Backup depending on the requirement.
• Refreshed development and test databases from production using Logical Backups (Export and Import).
• Extensive Performance tuning for optimized results using tools like EXPLAIN PLAN, SQL*Trace and TKPROF, AWR, STATSPACK.
• Daily Health Check Up of the Database using ADDM with the help of AWR report.
• Written SQL, PL/SQL scripts and Shell scripting to monitor table space and extent growth. Space Management, which includes table space creation, adding new data files.
• Maintaining Database Security by Creating Roles, Privileges, Quotas, and Passwords.
• Troubleshooting and Technical Support on Oracle Database & Oracle Applications and Network Administration using SR, SAR, IOSTAT and RDA.
• Recovery of Database (Recovering from Media Failure, recovering tables dropped accidentally, recovering data files, Recovering from Block Corruption).
• Object maintenance e.g., Storage Parameters, Rebuild Indexes.
• Responsible for installing, upgrading, and configuring the Oracle server.
• Supported different Oracle 10g, 9i Databases of Production, Testing, Staging and Training.
• Involved in logical and physical data modeling and schema design using Erwin tool.
• Created database manually using Oracle Database Configuration Assistant.
• Developed PL/SQL packages, stored procedures, functions, Cursors, triggers.
• Creating databases, tablespaces, objects, roles and privileges.
• Partitioned large tables to increase the performance and to improve I/O access.
• Responsible for Data load on different databases using SQL*Loader.
• Export and import of database objects using EXP and IMP Utilities.
• Enforce Database Security by Managing user privileges and efficient resource management by assigning profiles to users.
• Using database level triggers code for database consistency, integrity and security.
• Involved in the database design, installation, creation of various instances, and creation of tables, granting roles to users and maintain the security according to application.
• Performed daily maintenance tasks like space management, rectified locking problems, managed quotas etc. Created users and roles and maintained system security.