SUMMARY

• Around 9 Years of experience in IT and I have been developing my skills in Oracle 9i, 10g and 11g 12c and 19c Database Administration (DBA) .
• Experience with Oracle 9i, 10g and 11g on UNIX, Linux, Solaris & Windows operating systems.
• Experience with RMAN, Oracle Enterprise Manager (OEM), Oracle Data Guard, Oracle Data pump.
• Extensive DBA experience in supporting multiple ORACLE databases including Development, User acceptance testing & Production.
• Experience in cloning/replicating production database using RMAN and manually.
• Job scheduling through crontab, O/S updates and upgrades, applying patches.
• Experience in backup/restore, disaster recovery using RMAN and manually.
• Experience in using data pump import/export utility of ORACLE.
• Experience in database migration by designing and implementing database logical and physical storage structures.
• Extensive experience in daily batch and report monitoring, space management, index rebuilds, statistics collection and other Oracle housekeeping tasks.
• Extensive experience in creating PL/SQL queries, procedures, packages and functions.
• Developed database support processes and automated tasks through UNIX Shell Scripting.
• Strong analytical and problem solving skills.
• Experience in database security strategies by creating database users, user roles, profiles and audits.
• Upgrading and Migrating Databases from lower versions to higher versions.
• Experienced in Planning, Installation, Backup and Recovery, Cloning, Refreshing test and development databases, Monitoring, Trouble shooting& Tuning.
• Experience in analyzing database & rebuilding indexes to improve database performance.
• Implemented & monitored daily, weekly and monthly batch jobs in database.
• Working knowledge on AWS and Unix Shell Scripting.
• Worked on Oracle Golden Gate implementation and Management.

TECHNICAL SKILLS

Hardware: Sun - Solaris, IBM-AIX, SUSE LINUX, REDHAT LINUX

Operating Systems: MS DOS, Windows- 95/98/2000, Windows-NT 4.0, Unix (Solaris-5.10),Exadata

Database: Oracle 9i, 10g, 11g, 12c and 19c, SQL Server.

Languages: C,C++,SQL, Unix Shell Programming

DB Tools: Toad, Export, Import, Data pump, RMAN, SQL Loader, AWR, ADDM, STATSTPACK, tkprof, SQL developer, SQL Server Management Studio, Trivadis 18,OEM12C

PROFESSIONAL EXPERIENCE

Confidential, East Hanover

Oracle DBA

Responsibilities:

• Support Oracle version-Oracle 10g, 11g, 12c on all platforms e.g. Solaris, HP-UX, IBM AIX, and Linux.
• Installed, configured, maintained Oracle Database Software 10g/11g/12c on Solaris, Solaris x86, Linux x86, Windows machines.
• Performed POC for Oracle 19c on Redhat Linux 7 and prepare document for the same.
• Installing Oracle 19c Dataguard on Windows.
• Applied PSU July 2019 patches on standalone and RAC databases on Windows, Linux, AIX platforms.
• Upgrading Oracle RAC from 12c to 18c on AIX.
• Patching and upgrading the databases.
• Work on the P1/P2 critical incidents and provide the RCA for the same.
• Performance tuning using OEM, awr and addm reports.
• Performance Tuning using OEM 12c.
• Upgrading OEM 12c to 13c.
• Installing and troubleshooting Oracle clients.
• Performed POC for Trivadis tool for maintaining the database status and backups.
• Perform Day to Day Support to User issues (Account related, connectivity, performance, database related installation issues etc.).
• Prepare documents for various Operational activities like Binary Installation, Database installations, SOPs, tools installations, backup and recovery, upgrades, migrations etc.
• Helping the automation team in automating tasks like Oracle 18c Database installation
• Generating SOX Audit reports for SOX audits.
• Implement latest security compliance baselines to the installation scripts to ensure database security.

Environment: Red Hat Linux 6/7, Sun Solaris 9/10, Exadata, Oracle 12c/11g/10g, RMAN, Putty, Service-Now Ticketing Tool, Trivadis 18, OEM 12c/13c,XTerm.

Confidential

Oracle DBA

Responsibilities:

• A member of Project team and was responsible for maintaining the health of all the Oracle Databases in the environment.
• Managing the request of the users through Service-now service request queue.
• Monitoring the incident alert about the space or alert log issues through automated email alerts.
• Troubleshooting and root cause analysis P1 issues related to the databases.
• Defining user roles and permission, based on the level of access required.
• Perform disk space management on the Australia servers as weekly maintenance tasks on the Servers.
• Refreshing the schema/test databases with the latest data as per the request from the Application team.
• Monitor the performance and capacity of the administered systems and respond proactively to any potential problems identified.
• Manage & Administration of Australian databases and servers by sending the health check report weekly.
• Work with the Application team for issues corresponding to the application connectivity or enhancements by doing structural or data changes in the database.
• Perform Day to Day Support to User issues (Account related, connectivity, performance etc.).
• Support Australian Client issues, troubleshoot database related issues
• Monitor database performance and Availability.
• Strong day-to-day administration experience within a medium environment.
• Patching, maintenance, Upgrades, and migration of the databases.
• Experience with Microsoft Outlook 2007 / 2010.
• Experience with SQL Server Management tool
• Troubleshooting SQL Server databases by checking the databases status, checking system event log entries for warnings and errors, restore and recover databases.
• SQL server Database space management of transaction log files.
• Document processes and procedures, creating SOPs, working on RFC's.
• Golden gate implementation and monitoring.
• Managing the Golden gate implementation for Oracle 11g RAC on Exadata Machines.
• Checking the GG processes in sync, tracking the high logs generation by the GG processes.
• Resolving the high memory usage by GG on the server.
• Assisting team in helping in their queries and issues.
• Managing weekly report for the database health check and failed login/multiple password resets attempts in the production database.
• Managing RAC databases on Exadata using Goldengate replication.

Environment: Red Hat Linux 5.4/5.5, Sun Solaris 9/10, Oracle 12c/11g/10g/9i/8i, RMAN, Putty, Service-Now Ticketing Tool.

Confidential

Oracle DBA

Responsibilities:

• Strong 24x7 Production database administration, support and monitoring to ensure a proactive problem recognition and resolution of database issues.
• Intensively involved in the area of installations of Oracle Software, Configuration for database and day-to-day routine works for database administration.
• Supporting over 200+ critical production databases along with 90+ QA/DEV databases of sizes from 80 GB to 9TB.
• Upgraded databases from 10g to 11g.
• Handling issues related to Database Upgrade/Migrate and Patching.
• Excellent experience in performance tuning using STATSPACK, EXPLAINS PLAN, SQL TRACE, TKPROF, AWR and ADDM reports.
• Performed backups and tested crash recoveries using conventional hot & cold backups and RMAN, cloning databases using RMAN NetBackup.
• Skilled in developing RMAN scripts for database back up including hot and cold backup options
• Diagnosing and performing root cause analysis on ORACLE INTERNAL errors like ORA-600, ORA-7445 and ORA-3113 issues.
• Recovery of Database (Recovering from Media Failure, Recovering tables dropped accidentally, Recovering data files, Recovering from Block Corruption).
• Writing UNIX shell scripts for backup and recovery, Import and export procedures.
• Maintaining the availability of the databases by checking the daily alert log reports.
• Troubleshooting the backup related issues.

Environment: Red Hat Linux 5.4/5.5, Sun Solaris 9/10, HP-UX, Oracle 11g/10g/9i, RMAN, Putty, X-Ming, AR Ticketing Tool.

Confidential

Software Engineer

Responsibilities:

• Supported Oracle version-Oracle 9i, 10g on windows server 2003.
• Installed, configured, maintained Oracle Database Software 10g on Windows machines.
• Managing the Oracle 10g database of 40GB, was involved in the maintenance of the development/Test environments.
• Implementation and configuration of OEM, Oracle Management Server for maintenance and monitoring.
• Performing Hot / Cold backups of the database through RMAN or User Managed method.
• Generated and analyzed STATSPACK reports and monitored statistics for performance tuning of the database.
• Review alert logs and dump files to check for any problems related to the database.
• Perform database cloning/exp/imp to setup identical databases in the development/Test environments.
• Create and maintain users, roles and privileges.
• Upgrade/Migrated the production and development databases from 10.2.0.1 to 10.2.0.3.
• Good working knowledge of RMAN Backup, Restore and Recovery.
• Excellent knowledge of Import and Export.
• Used Oracle 10g AWR & ADDM to monitor database activities and performance tuning.
• Created lots of SQL’s for task automation like generating reports (e.g. Timesheets, task based efforts etc.) for monthly project analysis and which helped in the smooth working of the projects.
• Created PL/SQL procedures, packages for the generating the Monthly collective data for the Management for data analysis.
• Identify top SQL that are consuming heavy resources and provide support to the development team in identifying SQL queries that are consuming high resources and interact with the development team to see if these queries can be fine tuned further.
• Applying patches and updates.
• Created batch jobs for the automating the RMAN backups and removing the old trace files for the regular maintenance and Space management.
• Tuned SQL queries using TKPROF and EXPLAIN Plan.

Environment: Oracle 10g, SQL Developer, RMAN, Windows 2003 Server, Tortoise SVN.

Confidential

Associate Consultant (Oracle DBA)

Responsibilities:

• Supported Oracle version-Oracle 9i, 10g all releases on all platforms e.g. Solaris, HP-UX, IBM AIX, and Linux.
• Installed, configured, maintained Oracle Database Software 9i/10g on Solaris, Solaris x86, Linux x86, Windows machines.
• Performing Hot / Cold backups of the database through RMAN or User Managed method.
• Generated and analyzed STATSPACK reports and monitored statistics for performance tuning of the database.
• Review alert logs and dump files to check for any problems related to the database.
• Perform database cloning/exp/imp to setup identical databases in the production and development environments.
• Create and maintain users, roles and privileges.
• Upgrade/Migrated the production and development databases from 9i to 10g.
• Good working knowledge of RMAN Backup, Restore and Recovery.
• Excellent knowledge of Import and Export and datapump.
• Used Oracle 10g AWR & ADDM to monitor database activities and performance tuning.
• Creating shell scripts, SQL scripts for task automation.
• Good knowledge with writing PL/SQL stored procedures, functions, packages and triggers.
• Identify top SQL that are consuming heavy resources and provide support to the development team in identifying SQL queries that are consuming high resources and interact with the development team to see if these queries can be fine tuned further.
• Actively involved in monitoring the lock processes, releasing locks in case of resource blockage and gathering statistics.
• Applying patches and updates.
• Create small shell scripts and cron jobs for the regular maintenance and automating small backups.
• Tuned SQL queries using TKPROF and EXPLAIN Plan.

Environment: IBM AIX 5.3, Solaris 5.9,5.10,RHEL 4,5, Oracle 9i/10g/11g,SQL Developer, TOAD,RMAN, Windows XP, Putty, FileZila, X-Ming, X-Manager, WinScp, Tortoise SVN, AR Ticketing Tool.