SUMMARY:

• Competent, diligent and result oriented Masters in Computer Applications offering 10 years of experience.
• Currently spearheading functions as an Oracle DBA (Database Administrator) - Technology Lead
• Proven expertise in database architecture, managing of Oracle Databases 10g/11gR2/12c/13c(OEM) and Oracle RAC (Real Application Clusters) systems.
• Installation of Oracle 11gR2/12C GI (Grid Infrastructure) software, ASM instance creation, RAC RDBMS software installation and RAC database creation on 4-node clustered environment.
• Experienced in database refreshes, upgrades, migration, cloning, patching, designing logical/physical architecture, Data Guard, ASM, OEM, performance tuning (Instance/Database/SQL query), MAA technologies, RMAN backup and recovery, multi-tenant (CDB, PDB) environment, Golden gate, Exadata, Capacity Planning.
• Responsible for creating databases as per the requirements, maintaining control file, redo log file, data files and creating table spaces and resizing them as per requirement, ASM storage management.
• Extensive usage of OEM tool to provide performance test analysis report and for monitoring CPU utilization, data throughput, blocking sessions, ASM disk space usage, tablespaces usage, datafile addition for extra space, configuring alert notifications etc.,
• Troubleshooting of performance and tuning problems in Oracle database using internal utilities such as AWR, ASH, ADDM, OEM grid control and manual scripts.
• Performing database refreshes using export and import utilities (exp/imp) at all level. Performed the same using data pump export and Import utilities (expdp/impdp).
• Actively involve daily meetings with business to discuss in terms of growth, organizing more systems to improve quality on databases.
• Ability to handle multiple projects simultaneously and capable to work independently.
• Working knowledge Project Life cycle (PMLC) and Agile development teams. Strong in SQL tuning and performance tuning.
• Migrated databases from lower version 11gR2 to Oracle 12c multi-tenancy environment.
• Distribution Centre build project deliverables for different environments (Dev, QA, UAT, STRESS & Production).
• Expertise in co-ordination and communication with system administrators, business data analysts, security directors and development teams for different level of project deliverables.
• Excellent work experience with different clients such as Confidential, Harley-Davidson, Confidential & Company, Confidential, Manhattan, Rackspace, JDA, Confidential Beauty etc., helped to get a successful delivery of multiple projects in my career.
• Setting up stand-by databases, implemented/ administered data guard for higher availability and disaster recovery. Used the stand-by database for reports generating purpose.
• Responsible to respond effectively to database monitoring alerts and escalations.

TECHNICAL SKILLS:

Operating Systems &Versions: Enterprise Linux RHEL 6.3/7.1, Windows 7/8/10, Solaris 9.0/10.0, HP-UX.

Database versions: Oracle 9i, Oracle 10g, Oracle 11gr2, Oracle 12C

Hardware: Sun SPARC, Intel, EMC2, VMWare.

Case Tools: SQL-Developer, Toad, Xmanager, FileZilla, psftp and Putty, Xming

Tools: RMAN, EXPDP/IMPDP, EXP/IMP, ASM.

Oracle Monitoring Tools: Oracle Enterprise Manager, Foglight, AWR, ASH, ADDM. Cherwell, Lotus Notes 6.5, JIRA.

PROFESSIONAL EXPERIENCE:

Confidential, Bolingbrook, IL

Lead Oracle DBA

Responsibilities:

• Installation, configuration and administration of Oracle 11gR2 RAC ONE NODE, Oracle 12C FULL RAC on Enterprise Linux (RHEL) 6.1 / 7 OS versions.
• Installation of Oracle 11gR2/12C GI (Grid Infrastructure) software, ASM instance creation, RAC RDBMS software installation and RAC database creation on 4-node clustered environment.
• Providing database and system management for multiple Linux and windows servers running Oracle 11g/12C ranging in size from 500Gb to 8Tb+.
• Installed and configured OEM 12C Grid Control, OMS (Oracle Managed Server) and OEM Agent, extensively used OEM tool to provide performance test analysis report and for monitoring CPU utilization, data throughput, blocking sessions, ASM disk space usage, tablespaces usage, datafile addition for extra space, configuring alert notifications etc.,
• Troubleshooting of performance and tuning problems in Oracle database using internal tools like AWR, ASH, ADDM, OEM Grid Control and manual scripts.
• Providing primary DBA support for e-commerce sites, customer facing OLTP and data warehouse systems of multiple applications related to JDA and Manhattan vendors.
• Performing database refreshes using export and import utilities (exp/imp) at all level. Performed the same using data pump export and import utilities (expdp/impdp).
• Proficient in raising Service Request (SR) with Oracle Support and using Metalink to resolve the bottlenecks in the database environments.
• Helped developers to install Oracle Client, troubleshoot and establish the connection to Oracle database through ODBC, JDBC.
• Responsible to do SQL query tuning and provide best practices to development team in building SQL statements.
• Applying quarterly patches, CPU/PSU and version change patch bundles.
• Responsible to do co-ordination and communication with system administrators, business data analysts, security directors and development teams for different project deliverables.
• Responsible to prepare and maintain standard documents/templates for all major activities like database software installations, creation, refreshes, cloning, patching, issue resolutions etc., which helps to maintain consistency across all environments (Dev/QA/STRESS/PRODUCTION) during implementation and for the client in the future.
• Automation of RMAN backups, schema refreshes, database refreshes and to monitor activates like availability of database & listeners, space utilization, gathering statistic for the cost base optimizer, index rebuilding etc., using shell scripting.
• 24 X 7 Production database administration, support providing during on-call schedules.

Environment: Used: Oracle 11gR2/12C, OEM 12C, Enterprise Linux (RHEL) 6.3 / 7.1 OS versions, VMware, EMC2, Cherwell Ticketing tool, JIRA, Windows 2007/8, Lync communicator, Tidal, Mputty.

Confidential

Oracle DBA

Responsibilities

• Performed Oracle database & schema refresh activities.
• Oracle RDBMS software installations and database creation.
• Space management over database layer and monitoring physical space utilization.
• Monitored and managed the databases during the generation of large reports.
• Generated and analysed the AWR, ADDM reports to provide best tuning solutions for performance issues.
• Monitored daily scheduled RMAN backup’s status.
• Performed database backups using datapump, RMAN and logical export/import utility.
• Provided database server maintenance support and outage plans.
• Oracle database upgrades from 9i to 11gr2, 10g to 11gr2.
• Applied CPU/PSU database patches using OPatch utility.
• Migration of databases in cross platform systems. Goldengate usage to migrate data.
• Involved in database design to build new database servers for applications.
• Provided solutions to database connectivity issues and application problems encountered by end users.

Environment: Used: Windows 2007, IBM AIX 5/7.1, Oracle 10gR2, 11gR2, Maximo Tool, Putty, Xmanager.

Confidential

Oracle Database Administrator

Responsibilities:

• 24 X 7 Production database administration, support.
• Maintained data guard to ensure high availability, data protection and disaster recovery for enterprise data.
• Extensive experience in data guard configuration, implementing and maintaining stand-by databases.
• Followed the ITIL discipline, proper problem management, inventory management, risk management and risk mitigation plans.
• Installed and configured physical and logical stand-by databases.
• Performance tuning, monitoring session waits and SQL reports.
• Maintained sync between HA and primary by clearing back logs.
• Database cloning over stand-by.
• Re-establishment of log-shipping.
• Monitored the growth of tablespaces by creating and altering required tablespaces, users and roles for the application.

Environment: Used: Confidential Mac Laptop, Linux Servers, Oracle 10g, 11gR2, Jabber, Espresso, Houston tool, Mac OS

Confidential

Oracle DBA

Responsibilities

• Oracle database server build preparation.
• Installation of Oracle 10g, 11g software in silent mode.
• Created Oracle 10g, 11g databases on different versions of HP-UX servers.
• Manual Creation of Oracle 10g, 11g databases on need basis in HP-UX server.
• Implemented Oracle database 10g/11g migration from windows to HP-UX servers.
• Responsible to do database refreshes, user management, space management.

Environment: Used: HP-UX servers, Oracle 10g,11gR2, Windows Servers, Lotus Notes 6.5, Sametime 8.1.0, Putty, Filezilla.

Confidential

Oracle DBA Co-ordinator

Responsibilities:

• Act as a contact for all development communities in ODC for database issues and coordinates everyday database administration.
• Closely coordinate and work with ID (infrastructure development) and DM (data management) teams on database architecture, upgrade and maintenance related projects.
• Everyday monitoring of development databases.
• Prepare necessary templates like database/schema creation, database refresh, database upgrade, database server commission templates etc., to standardize the process to follow across the environments (Dev/QA and production) by the project teams.
• Worked on a “Database Decommission Project” to claim space on the servers by removing unused databases.
• Created Oracle 9i, Oracle 10g Databases on different versions of Linux and AIX servers.
• Dealing with Export / Import, datapump, backup & recovery and various Database issues.
• Involved in databases design for various client custom applications.
• Involved deeply in Database Decommission Project.
• Implemented backup and recovery procedures (cold/hot backups, RMAN incremental backups & import/export)
• Created database links and materialized views.
• Performed patching on Oracle Database Server 10g and 11g using OPatch utility. Troubleshoot and resolve database and/or application problems encountered by end users.

Environment: Used: IBM AIX servers, Linux, Oracle 9i, Oracle 10gR2, Lotus Notes 6.5, Sametime 8.1.0, putty.

Confidential

Jr. Oracle DBA

Responsibilities:

• Created Oracle 9i, Oracle 10g databases on different versions of Linux and Windows servers.
• Create and maintain users, roles and privileges and auditing triggers.
• Monitor tablespace and database growth by verifying shell script generated reports.
• Performed daily maintenance tasks like space management, rectified locking problems, managed quotas etc., configured network components like TNSNAMES, names server, connection manager, etc. for easy and effective management of Oracle networking. Configured listener for external procedure calls.
• Prepared standard database creation, schema/database refresh templates for the purposes of the development team.

Environment: Used: Linux, Sun Solaris, Windows, Oracle 9i, Oracle 10G, Lotus Notes 6.5, Putty.