Database administration, RAC, ASM, OEM12C, Backup and recovery, data

Gifteena Nikhil ********@*****.***

**** ****** **** ***** ***: +1-321-***-****

Maitland, Florida - 32751

Career Profile

More than two years of Oracle database administrator experience mainly in pharmaceutical industry. Worked as an Oracle DBA for Shire Pharmaceuticals and AstraZeneca India private limited which has client base in more than 20 countries. A self-motivated, responsible, and reliable team player with zest and zeal to learn new technologies.

Experience Summary

Company : AstraZeneca India Private Limited Aug 2015 to Dec 2015 Environment : RH Linux, Windows and AIX with Oracle 9i,10g and 11gR2. Tools : R-login, CYBERARK Login, NetBackup, HPDP, IBM Tivoli Backup and Legato Backup. Part of a twenty-member DBA team managing more than 800 databases that included 120 production databases. Users were located in more than 20 countries across the globe. Sizes of databases varied from 5 GB to 1TB. ü Experience in supporting 24X7 production databases in different environments like Red Hat Linux, AIX and windows.

ü Performing installation of Oracle Databases on Linux. Re-organizing database by using export/import and traditional exp/imp for oracle 8i/9i databases.

ü Expertise in patching databases.

ü Provided technical assistance to Application Support team for database related issues like Blocking session, fixing slow running queries, releasing object level locks and killing active/inactive sessions. ü Have worked on Performance Tuning scenarios by using tools/utilities like Automated Workload Repository (AWR), Automatic Database Diagnostics Monitor (ADDM), Explain Plan, Auto trace, TKPROF, Stats pack and ASH reports.

ü Have experience on RAC (Real Application Cluster) environment and Dataguard. ü Managing and administering ASM file system interface for Oracle database to reduce the administrative overhead on database storage.

ü Performing critical activities like Restore and Recovery, Cloning and DR test. ü Implementing backup & recovery strategy for Oracle databases. ü Generation of backup report on a daily basis by ensuring successful completion of RMAN and export backups.

ü Setting up monitoring through OEM for new databases. ü Proficiency in using Oracle Enterprise Manager (OEM) to monitor and administer the performance of Oracle Databases.

ü Tuning of Oracle memory structure (Buffer cache, library cache, Shared spool, sort area). Company : HCL Technologies May 2013 to Jul 2015

Client : Shire Pharmaceuticals Inc.

Environment : RH Linux, Windows with Oracle 8i, 9i, 10g, 11gR2. Tools : OEM 12c, R-login, NetBackup, SQL *Loader, RMAN, EXP/IMP, EXPDP/IMPDP. Part of a five-member DBA team managing 320 databases that included 34 production databases. Users were located in America, UK and Asia Pacific. Sizes of databases varied from 5 GB to 300 GB. ü Provided 24x7 support for all the production databases with Oracle 9i, 10g and 11g versions and on-call database support (rotatory weekly backup DBA) using VPN during weekends. ü Set up and manage database security by creating new users, roles, assigning profiles, and providing required user privileges in development, test, training and production environments. ü Creation and Decommission of Oracle 10g and 11g Databases. ü 12c agent installation and configuration.

ü Configuration and maintenance of standby databases. ü Having hands on experience on OEM 12c.

ü Defining backup strategies for 11g Oracle databases through OEM 12C. ü Performed daily housekeeping activities like purging of alert logs, audit logs and trace files. ü Got hands on experience on tools like SQL LOADER, RMAN, EXP/IMP, EXPDP/IMPDP. ü Apart from the above-mentioned tasks, daily monitoring was carried out before start of business hours to ensure database availability and smooth functioning of databases. Daily monitoring includes checking whether all databases are running, listener is running, Agent status check, UNIX error messages, disk space availability, tablespace usage, checking for errors in alert logs and trace files, checking for invalid objects, etc. Corrective action is taken for any of the problems before start of business hours.

ü Performed extensive optimization on existing inventory system. ü Knowledge and understanding of Data guard. Ensured that standby database is always in sync with the production database by checking ARCHIVELOG sequences. ü Worked on Oracle10g/11g Real Application Clusters (RAC) environment on different nodes with Automatic Storage Management (ASM) to support large volume. ü Database server capacity planning for production, test/dev environments. Estimated growth of database size by detail analysis of the company's future policies and generating reports for the management to act in advance.

ü Proficient in raising Service Request (SR) with Oracle Support and using Metalink to resolve the bottlenecks in the database environment.

ü Supported team in Facilitating RMAN incremental backups by using Block Change Tracking algorithm.

ü Proactively diagnosing and resolving problems affecting the database. Technical Skills

• Database Management Expertise: Database Administration, Backup & Recovery, Cloning, Migration, Patching and management of standby databases.

• Operating Systems: RH Linux, Windows, AIX.

• Database Versions: Oracle 9i, 10g and 11g.

• Support Tools & Utilities: Datapump, Export/Import, OEM, RMAN. Awards & Recognitions

• Got encouraging appreciations from client and service lines and application team for the dedication and the work that I have done during critical incidents.

• Got appreciation from client and project managers for successful completion of projects within strict deadlines while working for Shire Pharmaceuticals Inc. Education

• Bachelor of Electronics and Communication Engineering [B.E] from Anna University, Chennai

(2008 – 2012).

Personal Profile

Nationality : Indian

Visa : Work Visa (L2) with EAD

Contact this candidate