Sign in

Oracle Database Administration, RAC, OEM, ASM, RMAN, Disaster Recovery

Charlotte, North Carolina, United States
October 17, 2016

Contact this candidate


Anand Niranjan


E-Mail: Mobile: 704-***-****


Seeking a full-time position to utilize my database administration work experience along with my analytical efficacy in problem solving, precise decision making and contribute my oriented skills towards the tasks embarked. Currently pursuing Master’s in Computer Science from University of North Carolina at Charlotte. SUMMARY OF EXPERTISE

Installation & configuration of Oracle & SQL Server database system

Upgrade Oracle Database from 9i to 10g & 10g to 11g in UNIX / Linux platform

Backup and Recovery of database & offline/online backup in a production environment via shell scripting

Database migration from non-production to production environment

Implementation of Disaster Recovery Systems & physical data guard

SQL Performance tuning & managing database & server storage space

Strong technical background along with business analysis and writing effective documentation and specifications EDUCATION

Masters in Computer Science University of North Carolina at Charlotte, US Dec 2016 (Expected) GPA: 3.8/4

Bachelor of Engineering in Electronics and Communication Maharshi Dayanand University, India Grade: First Class with Distinction (74.2%) June 2010 TECHNOLOGY EXPERTISE

Skills Product/Platform/Software

RDBMS Oracle 12c/11g/10g/9i, SQL Server 2012


SQL Server Profiler, SQL Server Agent, Database Engine Tuning Advisor, Data Pump, BRTOOLS, Exp/Imp, Tkprof, Stats pack, AWR, RMAN, DBCA, SQL Loader OPERATING SYSTEM HP-UX 11.23, Red Hat Linux 6, RHEL AS, Unix, Windows Server R12 LANGUAGES SQL, PL/SQL, Unix Shell Scripting R, Python, Java WORK EXPERIENCE

Tata Consultancy Services, India: Oracle Database Administrator Mar 2011 – Jul-2015 Client Name Designation

Database 12c, 11g, 10g (Single node & RAC on ASM)

Express Scripts, St. Louis, US IT Analyst

OEM OEM 12c, Grid Control, Database Control

Bayer, Leverkusen, Germany System Engineer

Backup/Recovery RMAN Incremental & Full, Hot & Cold Backup, Datapump BSNL, Pune, India System Engineer

High Availability Disaster Recovery System, Physical & Logical Dataguard Client: Express Scripts (Dec 2014 – July 2015)

Provided Level 3 production, QA & testing database support from offshore data center in India

Supported end to end application deployments on production database

Worked on user security issues, password management & manage access to SYSDAB roles

Analyzed SQL queries & procedures to tune them and improve performance of the applications

Visualized data growth to predict space requirements at tablespace level

Worked on database refreshes, schema migration and capacity monitoring

Carried out installation, upgradation, and data migration across DBMS platforms Client: Bayer (Sep 2014 – Nov 2014)

L3 support for the client from offshore data center at New Delhi, India

Database commission & decommission

Database and schema cloning and migration

Database installation (Silent, DBCA & using template), upgradation and patch apply

Capacity planning of NFS mount point & db storage utilization & allocation to manage space crunch Client: BSNL (July 2011 – Aug 2014)

Administered Production, T&D & DR database for 20 critical applications at onshore data center client location

Involved in implementation of Disaster Recovery Infrastructure and demonstrated the setup for more than 20 databases to the client

Managed and provided 24x7 on-call support for large production database of size more than 20 TB

Regular database health checks, refreshes & routine performance monitoring

Analyzed SQL queries & procedures to tune them and improve performance of the applications

Database migration from non-production to production environment

Implemented business requirements into technical process like disaster recovery & high availability

Designed & implemented best practices, service level agreement & table purging schedule

Analyzed transaction statistics, raw trace files & logs to give recommendations to improvise the system, find bugs and data corruption and avoid bottlenecks

Instance Management, table space management and reorganization of fragmented tables using BRTOOLS

Carried out critical activities like patch application & database upgrade, listener creation, asm disk configuration for windows

& unix/linux platforms in production environment on Oracle 10g

Backup Consistency check of critical databases and monthly checks of all production databases

Table space & disk space management & reorganize fragmented tables

ASM Installation and database migration to ASM

Debugging & troubleshooting ora errors & coordinating with oracle support

Performance tuning using oracle tools like Stats pack, Explain Plans, AWR, ADDM analysis

Backup and Recovery of database using RMAN & offline/online backup in a production environment via shell scripting

Wrote shell scripts to automate manual work, take backup, generate reports & track parameter changes

Monitoring & troubleshooting log shipping & working on flashback database

Scheduled database jobs using dbms_scheduler, dbms_jobs and cron

Set up duplicate (cloning) & standby database (Data guard)

Switchover with physical standby database using data guard

Using SQL Loader to load data into tables trough text files & csv files

Enhanced the understanding of DMBS interaction with application and server to developers and system admins

Strong technical background along with business analysis and writing effective presentation and documentation

Mentored team members and documented audit reports of financial year and present it to auditor

Contact this candidate