Oracle Database Administration

Anju Rema

****-**** ****** ******, 778-***-****

Burnaby, BC V5H1P2 ********@*****.***

PROFESSIONAL SUMMARY

• An Oracle Certified Professional (OCP 11g) with over seven years of experience in Oracle database

administration.

• Experience in supporting multiple production databases running 24X7 mission-critical / OLTP applications

demanding high availability and increased performance.

• Experience in administration, upgrading, maintaining, performance tuning and troubleshooting Oracle

9i/10g /11g databases on various platforms like Linux, Unix, SOLARIS, HP-UX and Windows.

• Experience with working in Global Delivery Model.

• Performed cross platform migration from Linux to Solaris in production environment.

• Performed database upgradations from 9i to 10g and 10g to 11i.

• Experience in database creation using DBCA and manual method.

• Configured RMAN backups, performed database refreshes using RMAN and cold backup, full and partial

database restoration using RMAN.

• Experience in database cloning /refresh activities.

• Administration and troubleshooting of RAC databases of RAC-10gR2, RAC-11gR1 and RAC-11gR2.

• Experience in Automatic Storage Management (ASM), Data Guard and Goldengate.

• Expertise in maintaining database security by database auditing set-up and reporting.

• Experience in Unix shell scripting and automation of jobs for database monitoring.

• Experience in capacity planning, storage allocation and space monitoring & configuration management.

• Ability to work independently under pressure to resolve operational issues and contribute new thoughts and

ideas to solve complex issues

• Strong knowledge and experience of creating users, public synonyms, database links, roles, profiles,

privileges and assigning roles to users.

• Excellent experience in performing logical backups using data pump and exp/imp utility.

• Analyzed Automatic Workload Repository (AWR), Active Session History (ASH) reports and ADDM.

• Experience in the performance tuning of SQL queries using ADDM, AWR, EXPLAIN PLAN, TKPROF and

SQL * TRACE.

• Used Oracle scheduler and Unix Cron utility for automating jobs.

• Performed user account maintenance and schema maintenance.

• Experience in database monitoring using Oracle Enterprise Manager.

• Excellent know of Oracle DBA best practices.

• Coordinated the databases activities for various application teams and handled various critical database

changes.

• Excellent trouble shooting skills & a good listener who understands problem well to provide to optimal

solutions.

• Excellent written and verbal communication skills, able to develop, write, and enforce procedures and

policies

• Highly motivated, enthusiastic team player and a quick learner of new technologies with strong interpersonal

and communication skills.

1/5

EDUCATION DETAILS & CERTIFICATIONS

• Bachelor of Technology in Civil Engineering from TKM College of Engineering, 2005

University of Kerala, India

• Oracle Certified Professional (OCP) 11g 2015

• Oracle Certified Associate (OCA) 11g 2014

• Oracle Certified Associate (OCA) 9i 2006

TECHNICAL HIGHLIGHTS

Operating systems :HP –UX, Sun Solaris, Redhat Linux, Windows,

Languages :SQL, PLSQL, Unix shell Programming

Databases :Oracle 11g, 10g, 9i

Tools & Utilities :EXP/IMP, EXPDP, OEM, RMAN,TKPROF, STATSPACK, AWR,ADDM, SQL

LOADER, SQL NET, TOAD, SRVCTL

PROFESSIONAL EXPERIENCE

Company: Tata Consultancy Services (June 2010 – October 2013)

A global leader in IT services with over 300,000 employees, head quartered in Mumbai, India.

Client : American Express

American Express, also known as Amex, is an American multinational financial services corporation

headquartered in Three World Financial Center, Manhattan, New York City, New York, United States.

Project : Enterprise Data Management Services ( July 2011–October 2013)

Role : Sr. Oracle DBA

Responsibilities:

• Administration and support of Oracle 10g / 11g databases in development and testing environments.

• Creation of new instance and database using DBCA/manual method.

• Database upgradation from Oracle 9i to 10g and 10g to 11g and troubleshooting post upgrade issues.

• Migration of databases from Solaris to Linux using exp/transportable tablespace method.

• Setting and maintaining database high availability solutions like Real Application Clusters.

• Database refreshes from production to lower environments using RMAN utility.

• Conversion of single instance to Real Application Cluster (RAC) database instances.

• Perform backup and recovery through RMAN.

• Generate logical backups using exp/imp and datapump utility.

• Proactively monitor database performance and take necessary actions.

• Generate and analyse AWR/ADDM/ASH/TKPROF report for performance related issues .

Anju Rema

1601-4288 Grange Street, 778-***-****

Burnaby, BC V5H1P2 ********@*****.***

• Enhancing Database Security by Database Auditing set-up and reporting.

• Shell scripting for automating and monitoring database jobs.

• Diagnose Oracle bugs and coordinate with Oracle support through metalink to resolve them in timely manne r.

• Pro-active database monitoring using OEM.

• Data loading using SQL Loader (from Text files to Database)

• Decommission of databases as per application requests.

• Database Performance Tuning, SQL Tuning and Optimization.

• Day to day general administration, tablespace management, undo management, managing users, resources,

privileges and roles.

• Provide troubleshooting and problem solving support to application developers .

• Analysis and monitoring Goldengate functionalities.

• Proactively monitor alert logs, trace files, listener log and other database job logs .

• Co-ordinating critical implementations among various teams.

• Ensure appropriate use of freespace within tablespaces, reclaimed space whenever possible.

• Reorganize tables and indexes within databases when needed.

• Manage expectations and commitments with stakeholders, including application, operating systems, and IT

support teams

• Ensuring the incident, service and change management processes are followed for the various database level tasks

requested by the application team.

• Provide night and weekend support during outages and implementations.

• Conduct training and Knowledge transfer sessions for the new team members.

Project : Central Database Management (June 2010 – June 2011)

Role : Sr. Production DBA

Responsibilities:

• Administration and support of 200 Oracle 10g / 11g databases in Production environments.

• 24X7 Production database administration, support and monitoring to ensure proactive problem recognition and

resolution of database issues.

• Database point of contact for various application teams.

• Setting up and maintaining user accounts and profiles

• Ensure database security by enabling database auditing.

• Storage and space management including tablespaces and datafiles.

• Troubleshoot production issues and communicate the resolution to the stakeholders.

• Manage expectations and commitments with stakeholders, including application, operating systems, and IT

support teams

• Performe the pre & post outage checks on the database with regards to the outages on th e database servers.

• Day to day general administration, tablespace management, undo management, managing users, resources,

privileges and roles.

• Review and analysis of daily database health check report and taking necessary actions.

• Review and analysis of server utilization report to ensure timely addition of storage.

• Monitoring the excessive fragmentation of table spaces and taking remedial steps.

3/5

• Proactively monitor database performance and take necessary actions.

• Shell scripting for automating, monitoring and performing routine database jobs.

• Implement the scheduled jobs and ensure the databases adhere to the AMEX standards.

• Generate and analyse AWR/ADDM/ASH/TKPROF report for performance related issues.

• Basic SQL query performance tuning.

• Pro-active database monitoring using OEM.

• Create Service Requests with the Oracle Support for the various issues and fixing Oracle bugs.

• Ensure the successful completion of RMAN database backups.

• Configuring, monitoring and troubleshooting of the database alerts.

• Creating and managing teams shift schedule.

• Preparing work reports and presenting in monthly meetings.

• Ensuring the incident, service and change management processes are followed for the various database level tasks

requested by the application team.

• Mentoring the new DBAs in the team.

Company: Infosys Technologies Limited (October 2006 – May 2010)

A large-size IT consulting firm with over 160,000 employees, headquartered in Bangalore, India.

Client : Pfizer Pharmaceutical Ltd

Pfizer is one of the world's largest research-based biomedical and pharmaceutical company. The project

involved the support and administration of various production, development and testing databases hosted on HP

UX, Sun Solaris and Windows Servers.

Role : Oracle DBA

Responsibilities:

• Support and Administration of Oracle 10g/9i Databases in production and lower environments.

• Ensure the security, performance and availability of databases.

• Installation of oracle 9i/10g database software.

• Creation of databases using DBCA and Manual method.

• Upgradation of databases from 9i to 10g.

• Installation of Oracle Client on Application Servers.

• Providing out of office on call support for high priority issues.

• Perform schema backups using datapump and exp/imp utility.

• Proactively monitoring alert log, trace files, listener log and other database job logs.

• Creating schemas and its maintenance.

• Performing schema refreshes using exp-imp utility and expdp-impdp utility.

• Set up database security by enabling auditing .

• Monitoring tablespace and adding space to ensure the space utilization is below the threshold level.

• Creating users, roles, privileges,profiles and grating quotas.

• Creating tablespaces, datafiles, database links, creating and rebuilding indexes.

• Manage expectations and commitments with stakeholders, including application, operating systems, and

IT support teams

• Importing data using SQL*Loader, Monitoring the database performance and providing assistance to

development teams.

• Using OEM to manage multiple instances and Toad for development and reporting.

• Database Performance tuning using AWR, STATSPACK, TKPROF, SQL Trace and Explain Plan.

Anju Rema

1601-4288 Grange Street, 778-***-****

Burnaby, BC V5H1P2 ********@*****.***

• Gathering tables statistics for optimum query performance.

• Proactively monitor database performance and take necessary actions.

• Diagnosing low performing sql queries and taking necessary actions.

• Troubleshoot production issues and communicate the resolution to the stakeholders.

• Monitor the CPU utilization and performance using UNIX utilities.

• Implementing and coordinating major deployments with the application teams.

• Assisting application teams in resolving connectivity issues.

• Handle weekly meetings with the application teams.

• Automate daily jobs using shell scripts.

• Monitor database alert log for errors.

• Review the scripts, IQ document from the DBA team perspective and provide approvals for the actual

deployment of the script in the database.

• Provide night and weekend support during outages and implementations.

• Create Service Requests with the Oracle Support for the various issues and fixing Oracle bugs.

• Conduct training and Knowledge transfer sessions for the new team members.

5/5

Contact this candidate