SUMMARY

• Having Over all 6+ plus years of experience in Software industry as “Oracle Database Administrator” and over 3 years of experience as ‘SQL DBA’
• Experienced in environments requiring direct customer interaction during the Database activities like patching, upgradation, installation, Database cloning activity etc.
• Having experience as Exadata Database Administrator.
• Proficient Experience in handling mission critical Databases 10g,11g in a 24x7 operational mode on various Operating Systems with good analytic and problem solving skills
• Logical Backups include full Database/Schema/Table level backups/refreshes using Data pump.
• Backup and Recovery using RMAN.
• Experience on working with ASM 10g/11g r2
• Experience on working with 12C databases.
• Good Experience on RAC 10g/11g r2 Administration.
• Managing and monitoring all components of Exadata RACK - Database 11g R2, Database Nodes, Storage Cells and IB Switches.
• Installations on test environments
• Experience on Patching and Upgradation both on Standalone & RAC Databases.
• Experience on working with SQL SERVER 2008,2012 activities including Installations, backup scheduling, monitoring job failures, Log shipping, Mirroring, Replication, upgradations, Latest Service pack Installations.
• Experienced in ITIL framework like Incident Management and Change management.
• Expertise in Acquisition of data from multiple source systems.
• Strong Ability to handle multiple tasks and work independently as well as in a team.
• Have Strong analytical skills with ability to follow project standards and decision-making capability and Exceptional ability to quickly master new concepts and applications.

TECHNICAL SKILLS

Programming: C++, JAVA, SQL

Database: Oracle10g, 11g R2, RAC 11g R2, 12c, Oracle Exadata, SQL SERVER 2008,2012

Platforms: Windows, Oracle Enterprise Linux 5/6, Exadata

Ticketing Tools: MOS (My Oracle Support), BMC REMEDY

PROFESSIONAL EXPERIENCE

Confidential

Oracle DBA

Responsibilities:

• Installation and configuration ofOracle cluster ware/RAC version 10g/11g.
• Installation & administration of Red Hat Linux RHEL 5/6 operating system.
• Performance tuning of databases/SQL using Oracle 10g/11g tools like AWR/ADDM/Explain plan/trace.
• Setting up and managing RMAN backups,
• Performing cloning operations using RMAN.
• Upgrade of databases from 9i/10g to 11g. Patching of software/databases
• Upgrading oracle database from 11g to 12c.
• Upgrading oracle Grid Infrastructure from 11gR2 to 12C
• OS supported: Red hat Linux (RHEL 6), Windows.
• Performing refresh activity using Oracle tools: RMAN, data pump/export.
• Have good experience on working with RAC.
• Extensive working experience on working with ASM.
• Configuring and maintain Dataguard and Physical standby. (Worked on resolving the gap issues)
• Index rebuild activities.
• Involved in Performance Tuning for the SQL scripts using EXPLAIN PLAN, HINTS to tune queries for better performance and also extensive Usage of Indexes
• Having knowledge on working of Oracle 12c databases.

Confidential

Exadata Patch Engineer

Responsibilities:

• Patching of all components of exadata like the YUM, CELL, Database.
• Providing 24*7 Production support, on-call support for customers across the globe.
• Providing L2, L3 level support for all customers.
• Clearing SR queue based on priority.
• Backup & Recovery using RMAN.
• Logical backups using Data pump utility.
• Experience on Managing Storage using ASM 11g r2
• Monitoring and managing RAC 11g r2 Cluster ware components and database resources.
• Trouble shooting issues on cluster startups.
• Creating and Maintaining Data guard set up.
• Blacking out the alerts as a process of activity .
• Switching Production to Standby Databases for planned/unplanned activities.
• Working closely with Customers to schedule outages for maintenance activities.
• Applying Quarterly Bundle Patches on RAC Databases.
• Upgrading RAC Databases from 11.2.0.3 to 11.2.0.4
• Upgrading OEL Kernel (YUM updates) and firmware of InfiniBand Switches.

Environment: Oracle 11g, RAC 11g, ASM, Data Guard, Exadata X2-2 to X4-8

Confidential

Oracle DBA/SQL SERVER DBA

Responsibilities:

• Supporting more than 2000+ Production, test, development databases for different applications running on Oracle 8i/9i/10g/11g with IBM AIX, Linux & Windows NT servers.
• Complete range of Oracle DBA activities including day-to-day production database maintenance and monitoring, Backup & Recovery using RMAN, troubleshooting production issues, performance tuning, export-import, Data guard gap issues, recovery and management of physical storage of database in AIX, Linux.
• Good knowledge of hot backup/cold backup for 24*7*365 environment.
• Managing and monitoring the space on tablespaces.
• Created RMAN Catalogs and set up various levels of backups.
• Creating, managing and modifying database storage structures like control files, redo log files, archive log files, table spaces and data files as necessary, from information given by the management.
• Experience in using Export / Import utilities / Data pump.
• Creation of new database as per the client requirement.
• Installation & administration of Red Hat Linux RHEL 5/6 operating system.
• Creation of users, Security Management through privileges, roles, profiles and auditing of user actions.
• Managing of Oracle Data guard in physical standby database.
• Troubleshooting complex issues related to generic RDBMS issues.
• Experienced in ASM Administration in 10g and 11g databases.
• Creating indexes and gathering statistics.
• Re-organization is done from time to time for the primary storage objects like tables, indexes.
• Finding the root cause and fixing issues experienced in backup job failure.
• Recovered databases from block level corruptions using RMAN.
• Primary knowledge of PL/SQL.
• Responsible for solving the workday issues faced by the development users.
• Performing health check for databases by generating AWR reports.
• Implementing CRQ as per business requirements.(Change requests are followed through a documented process)
• Worked on Materialized views refreshes.
• Working with Client in attending bridge calls and fixing the issues.
• Proactively contribute to increasing the team efficiency by sharing knowledge, providing feedback about best practices.

Confidential

SQL SERVER DBA

Responsibilities:

• Performing the restoration of data.
• Administration including planning, installation, deployment/implementation,
• Configuration of SQL Server 2012
• Managing security by creating logins, users and assigning privileges.
• Creation and implementation of maintenance plans.
• Performing Database maintenance activities like Backups, Restoring.
• Monitoring backup schedules, disk space, and log files growth.
• Refreshing, migrating and upgrading databases.
• Hands on experience in DR processes including Log Shipping and Database Mirroring
• Experience in Batch processes, Import, Export, Backup.
• Scheduling jobs in Sql server
• Created Linked Server.
• Handled multiple SQL Instances on Cluster environments.
• Creating Index & managing other objects of Database

Environment: Oracle 10g/11g, RAC 10g/11g, SQL SERVER 2008,2012, Linux

Confidential

Oracle DBA/SQL SERVER 2008 ADMIN

Responsibilities:

• The daily activity involves end to end database activities like creating small test databases, creating tables, user creation.
• Daily job responsibilities include Creating test databases.
• Database security and Auditing (creating users and granting the privileges for the global users to do the transaction on the database)
• Creating tables that are required to store the information regarding the hospital and patients.
• User & Table space Management.
• Database Health Checks and monitoring alert log files.
• Setting up scheduled jobs using OEM.
• Traditional Export & Data pump.
• Installing Oracle RDBMS Software through OUI, & creating new databases using DBCA.
• Handling Security, scheduling backup jobs, creating databases, Checking on space issues in Diskspace Management -SQL SERVER 2008.

Environment: Oracle 9i/10g/11g, RAC 10g/11g, SQLSERVER 2008, Linux