Pari Paramasivam

Contact: 416-***-****

Email:acx4t3@r.postjobfree.com

CAREER OBJECTIVE

To pursue a challenging career in a growing organization which will utilize my skills and enable me to further improve and contribute to the growth and success of the organization.

PROFESSIONAL EXPERIENCE

More than 5 years of experience as an Oracle Database Administrator having hands on experience in database administration, production support, installation, configuration, upgrades, patches, performance tuning, backup and recovery, cloning, space management, database security, migration and documentation.

Expertise in Oracle 11g RAC/ASM, 10g RAC/ASM installation, administration, configuration, production support, upgrades, patches, space management, database security, performance tuning, troubleshooting database design, UNIX shell scripting, Oracle Enterprise Manager (OEM) and documentation.

Thorough knowledge in high availability RAC environment (2, 3 and 4 node clusters)and upgraded standalone databases to 10g RAC environment.

Installed oracle database server on Solaris 8/9/10, HP-UX, OpenSuse11.1, IBM AIX, ML7, Linux and Windows environment and migration of oracle server from 9i to 10g and 10g to 11g applied oracle patches.

Thorough knowledge in high availability RAC environment (2, 3 and 4 node clusters)and upgraded standalone databases to 10g RAC environment.

Proficient in Database System Architecture, Data Modeling, Oracle Streams and Logical/Physical database design (Data Guard implementation for Disaster Recovery).

Implemented Oracle RAC with ASM and standalone with ASM in different environments such as development, testing, production and standby databases (both Physical and Logical databases).

Expert in implementing ORACLE STREAMS (unidirectional, bi-directional and downstream capture) and managed Operational, Historical and reporting databases.

Proficient in setting up Standby Database using shell scripts and RMAN utility tool, activating and re-building Standby Databases both Physical and Logical supported by DATAGUARD.

Managed very large database (VLDB) of maximum size 2TB with 24 servers including 7 Productions, 7 testing, 7 Development and 3 Standby databases.

Proficient in Hot/Cold Backup, Recovery and Cloning of databases using RMAN and shell scripts with VERITAS Net Backup, Export and Import database schema.

Expertise in RMAN backup (Full, incremental and cumulative) and recovery, Incomplete recovery and disaster recovery.

Monitored database servers using various tools such as OracleEnterpriseManager (OEM), OracleGridControl, DBArtisan and TOAD.

Proficient in tuning MySQL processes and queries.

Data loading and report generation using SAPBI/BO and Oracle datawarehousing tools.

Expertise in performance tuning services such as, SQL tuning services with AWR, and ADDM which is used to collect and maintain performance statistics and improves the database performance.

Expertise in planning, implementation and documentation of installation, migration, patching, backup retention policy, recovery, security, auditing, capacity planning, space management and storage allocation (SAN/NAS).

Expert in export/import and data pump import to load data in to tables.

Availability as On-Call 24x7 Production DBA and application/development DBA and Oracle Support processes for technical requests through Meta link and Help Desk Ticket applications like USD (Universal Service Desk).

UNIX shell scripts for hot backups, SQL*Loader, export and import of database.

Excellent interpersonal and strong analytical, problem-solving skills with customer service oriented attitude. A very good team player, self-motivated, dedicated in any work environment.

TECHNICAL SKILLS

Operating Systems: Linux, Open Suse 11.1 and Windows.

Database: RDBMS, Oracle 11g.

Languages: SQL, PL/SQL, and UNIX Shell Scripting.

DB Management: TOAD 9.5, DB Artisan, SQL Developer and Enterprise Manager grid.

Tool/Utilities: RMAN, Oracle Enterprise Manager, Oracle Management Service (OMS),SQL*Loader, ASM,

Export/Import, ODBC, DBUA, DBCA, putty,ImpExp32, Grid Control, Data pump,

Data guard,VERITAS Net Backup and MS Access.

Tuning Tools: TKPROF, EXPLAIN PLAN, STATSPACK, AWR and ADDM

Database: Oracle 10g/11g

Hardware: Sun Fire 15K, Sun Fire 6800, Sun V480, V240, Sun Enterprise 6500 / 450, HP XP256 / XP512, IBM

Platforms C server p5 model 590, and various PC desktop and servers.

EDUCATION

Verizontech IT

Oracle DBA Course Austin, USA

University of Toronto

Big Data Analytics Toronto, Canada

Madurai Kamaraj University

Master of Computer Application Madurai, India

WORK EXPERIENCE

Client: Sun Life Financial September 2013 to Present

Role: Oracle Database Administrator

Description:

Sun Life Financial, Inc. is a Canada-based financial services company known primarily as a life insurance company. It is one of the largest life insurance companies in the world, and also one of the oldest with the history spanning back to 1865 for more than 150 years in the business.

Sun Life Financial has a strong presence in investment management with over CAD$850 billion in assets under management operating in a number of countries. Sun Life ranks number 236 on the Forbes Global 2000 list for 2010 as well as on the Fortune 500 list.

Responsibilities:

24x7 Production database administrations, support and monitoring to ensure a proactive problem recognition and resolution of database issues.

Used cross platform transportable table space (TTS) to transport Tablespaces across platforms.

Schemas refresh using Export/Import Pump, Creating the database table spaces, tables, indexes, setting privileges. and user logins.

Managing of user’s privileges and roles.

Diagnosed and improved database performance to prevent and isolate, or recover from database degradation and failure.

Performed Setup Recovery Manager (RMAN) and Flash Recovery in RAC Environment.

Implemented backup strategies using hot/cold, exp/imp used on the business req.

Monitoring and tuning using tools like Enterprise Manager GRID, Oracle cost Based optimizer (CBO), SQL analyzer, automatic checkpoint tuning, SQL Advisors, Performance Manager.

Performed conversion single instance to Real Application Cluster (RAC) database instances.

Storage Management Managing Space, Table spaces, Segments and Extents, Rollback Segments & Data Dictionary.

Experienced on Database Security by monitoring User Management, Privileges, Roles, Auditing, Profiling, Authentication and Risk management.

Unix Shell scripting in csh, ksh for automating startup/shutdown, backup and recovery, Import and export procedure of databases, getting system alerts.

Experienced in documentation, provided documentation for database design, analysis, modifications, creating schemas etc.

Environment: Red Hat Linux5, Windows, Oracle, Enterprise Manager GRID, RUP, RMAN, SAN/NAS, ASM, RAC, Golden Gate, Streams, CDC, Data Guard, SQL*Plus, PL/SQL, ASM, ToadV9.7 & SQL, Navigator V6.1.

Client: Tata Consultancy Services Canada Inc, Toronto, Canada August 2011 to September 2013

Role: Oracle database administrator

Description:

Tata Consultancy Services Limited (TCS) is an Indian multinational information technology (IT) service, consulting and business solutions company headquartered in Mumbai, Maharashtra. TCS is one of the largest Indian companies by market capitalization ($80 billion). TCS is now placed among the ‘Big 4’ most valuable IT services brands worldwide. In 2015, TCS is ranked 64th overall in the Forbes World's Most Innovative Companies ranking, making it both the highest-ranked IT services company and the first Indian company. It is the world's 10th largest IT services provider, measured by the revenues. As of December 2015, it is ranked 10th on the Fortune India 500 list.

Responsibilities:

• Performed day to day activities such as managing user privileges, table spaces, file system, undo segments, temp

segments and indexing.

• Migrated single instance database to multiple instance database (RAC) using export/import, datapump.

• Created Partitions on large tables for easier manageability.

• Installing and configuring Recovery Manager (RMAN).

• Checking of Alert log and Trace files to monitor the database on a daily basis.

• Storage Management Managing Space, Table spaces, Segments and Extents, Rollback Segments & Data Dictionary.

• Cloning databases using scripts as well as RMAN.

• Assisting customer setup, tune and maintain Oracle database.

• Deciding the naming conventions of data file, redo log files, table spaces, and segments.

• Writing scripts for backup and recovery, Import and export procedure.

• On call support 24/7.

• Assisted in the transition from 10g to 11g, installed and configured oracle 11g.

Environment: Linux and Solaris, UNIX, Oracle 11g and 10g, TOAD 9.7.2, RMAN, SQL*Plus, PL/SQL, SQL*Loader, DBArtisian 8.7, MS Visio 2010, Oracle BI Publisher, SAP BI/BO, RAC and Data Guard, Golden Gate, WINDOWS and Siebel 8.

Client: Bharat Sanchar Nigam Limited - Hyderabad, Andhra Pradesh August 2010 to July 2011

Role: Database Administrator

Description:

Dot soft is a commercial application developed by BSNL Core Group, Andhra Pradesh for the purpose of automation of various activities performed by the BSNL like generation of bills, generating of advice note for new connection and for working connection, raising of refund order for the close connection, etc. The present Dotsoft applications have been implemented on Linux and Oracle 9i, supporting 245 GB of database and more than 450 users. Dotsoft application includes Commercial, TRA, and Billing Package and Fault Recognition system.

Responsibilities:

Oracle Configuration. Oracle Tuning. Oracle Patch Administration.

Coordinating Backup and Recovery operations over all databases, ensuring 100% recoverability.

Performing Daily, Weekly and Monthly Oracle monitoring and maintenance tasks.

Wrote Stored Procedures according to specs and control files for input to SQL*Loader utilities for loading data from external files into the Oracle database.

Planning, Installation and Configuration of Oracle Database on the Server.

Creation of Table space, Data files, Indexes, Rollback Segment and monitoring them.

Creation of Users and Granting them privileges and roles.

Performed Database Tuning. Performed Database Security and Integrity.

Wrote extensive Sub Queries, PL/SQL procedures, functions, database triggers and packages.

Responsible for writing database programming to Store/Retrieve the information from the database using SQL.

Designing and creating schema objects like Database tables, indexes, views, synonyms, and all schema objects in Oracle.

Writing Pl/SQL procedures and functions. Writing shell scripts to automate the data loading.

Monitoring the data loading jobs and tuning the SQL queries.

Environment:Oracle 8i, SQL Server 2000, UNIX (Sun Solaris), Windows (NT/2000/Advanced Server), TOAD, OEM, SQL*PLUS, Explain Plan, UNIX Shell Scripting, Quest software tools, PL/SQL navigator.

Contact this candidate