Oracle Database Administration
Resume:
Anju Rema
****-**** ****** ******, 778-***-****
Burnaby, BC V5H1P2 acob6a@r.postjobfree.com
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 acob6a@r.postjobfree.com
• 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 acob6a@r.postjobfree.com
• 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