Sr Database Administrator

ALPESH KABRA ***-**** Martin Grove Road, Etobicoke, ON

TEL: 647-***-**** **********@*****.***

SUMMARY OF SKILLS:

• Around 12 plus years of solid knowledge of business and management principles involved in

strategic planning, resource allocation, leadership technique, production methods

coordination of people and resources, designing, development and implementation of all the

business applications

• Keen with confidentiality, able to meet deadlines, reliable with strong communication(verbal,

written) and interpersonal skills

• Proven ability to be flexible and work hard, both independently and in a team environment, in

high pressure with changing priorities

• Excellent technical, trouble shooting and maintenance skills

• Keen insights and ability to identify key problems and generate creative solutions

• Innovative mind, confident, responsible and a quick learner with a positive attitude

• Work closely with Business Intelligence and Business Analyst team for Data Analytics, Ad

Hoc Reporting and Performance improvement of various ETL Process.

TECHNICAL EXPERTISE:

• Databases: Oracle 7x, 8x, 9i, 10g, 11g, 12c, Sql Server 2005, 2008, Oracle 12c

• Programming Languages: C, SQL, PL/SQL, SQL*Loader, Shell Scripting, Perl scripting, Visual

Basic 6, Lotus Notes

• Tools: Toad, DB Artisan, Sql Developer, Informatica, Crystal Reports, Confio, Actifio

• Operating Systems: IBM AIX Unix, Sun Solaris, Linux, Windows NT, Windows 2000, Windows XP,

Windows 2003, Windows 95, Windows 98

• ERP : JD EDWARDS, Oracle EBS (11i and r12)

PROFESSIONAL EXPERIENCE:

Canada Pension Plan Investment Board July 2013 – Current

Sr Database Administrator (Contract)

• Installation of Database servers including Oracle and Sql Server.

• Extensive experience in setting, implementing and maintaining Dataguard in 9i,10g and

11g on standalone and RAC database

• Implementing and supporting Oracle Automated Storage Management (ASM)

• Creating and Adding Lun’s to ASM

• Participating in DR scenario to do failover and switchover using Dataguard.

• Administration of Oracle databases including backups & restore and migrations,

application releases, software installations

• Tablespace space utilization, ASM space Utilization reports

• Granting access to SQL Server 2008R2/2012

• Restoring database in Sql server 2008

• Installed and Configured Enterprise Manager 12c.

• Monitoring Database performance issues using CONFIO for sql server and Oracle

• Testing backup and recovery of SQL Server 2008R2/2012.

• Management and Administration of Oracle RAC (real application cluster) system from

design architecture to Replication implementation.

• Experience of working in an ITIL-aligned service environment

Genworth Financials, Ontario Feb 2012 – July 2013

Sr Database Administrator (Contract)

• Administration, Monitoring of Database servers and installations of new database

including Oracle and Sql Server.

• Extensive experience in setting, implementing and maintaining Dataguard in 9i,10g and

11g on standalone and RAC database

• Extensive experience with Backup and recovery using RMAN,

• Active Database duplication using RMAN

• Creating Physical Standby database from Active database using RMAN

• Implemented backup and recovery solutions using RMAN

• Experience implementing 10g, 11g RAC (using raw devices, ASM).

• Involved in various projects of capacity planning

• Strong Oracle RAC performance tuning and troubleshooting skills.

• Constantly analyzing poorly performing sql query and providing recommendation

• Expertise using Oracle ASM administration

• Applied PSU, CPU patches and some bug fixes

• DR planning and testing

• Regular refresh of database using RMAN.

• Duplicate database over the network and with backup using RMAN.

• Regular schema refresh using Datapump, exp/imp.

• Performing tablespace point in time recovery, database recovery using RMAN.

• Monitoring, Creating and Administering Golden Gate replication

• Tablespaces Encryption to match SOX requirements.

• Experience with Performance Tuning in High Availability Environment

• Very strong debugging skills with clusterware, pl/sql and sql coding

• Work closely with developers and tune the queries and debug the codes

• Expertise using Oracle Enterprise Manager, Management Pack

• Strong Knowledge of OEM /Oracle Grid for 10g, 11g, 12c OMS and agents.

• Expertise in Oracle Spatial.

• Implemented 11g Active Dataguard for reporting.

• Installed and Configured Enterprise Manager 12c.

• Support, administer and maintain the database environments running on all SQL Server

servers and databases.

• Supporting various Data Warehouse application for Extracting and Reporting purpose

and Analytics

• Monitoring performance of Data Warehouse and ETL process and recommending

various sql cause performance issues.

• Working with ITIL standards and Agile methodologies.

• Monitoring Sql Server database.

• Granting user permission to Sql Server and AD group

• Restoring database in Sql Server and Oracle

Bank of Nova Scotia (Capital Markets) June 2008 – Feb 2012

Sr Database Administrator (Contract)

• Administration of Database servers and installations of new database

• Monitoring managing RAC servers.

• Installed High Availability Oracle solutions using Oracle RAC, ASM, Dataguard, Streams

• Perform capacity planning, database tuning and optimization to ensure maximum database

uptime based on established SLAs.

• Debugging Oracle Clusterware issues, RMAN issue, pl/sql codes

• Upgraded database from 9i to 10g, 9i to 11g, 10g to 11g

• Strong Database Migration and Upgrade experience across versions and platforms.

• Configured database using Veritas Cluster.

• Upgraded and migrated Oracle databases using Export/Import, database upgrade

Assistant, scripts, Transportable Tablespaces etc

• Planning and migration of 24/7 database to new servers

• Controlling Security and access to Database systems

• Install Oracle patches CPU patches and PSU patches

• Increased the audit ability of the database to ensure compliance with SOX reporting

requirements.

• DR planning and testing

• Database refresh as requested

• Extensive experience in complex issues, including problem-solving and coordination of issue

resolution in a timely fashion

• Set up and manage database security by creating new users, roles, profiles, and provide

required user privileges in development, test, training and production environments.

• Planning, testing and Implementing of Dataguard

• Clone databases using RMAN, export/import, Datapump and physical online/offline

backup for development, testing, education and production purpose.

• Maintaining, supporting, monitoring, performance tuning and benchmarking Oracle

databases to ensure the continual availability/reliability and optimal performance of these

databases

• Implemented advance security using Auditing, Tablespace encryption and transparent

data encryption.

• Experience with integration of SQL Server with SQL Reporting Server.

• Administrating, Maintaining and building Sql Server 2008

• Working with Business Intelligence team to ensure overall data integration architecture for

ETL processes, Data Marts and Data Warehouse projects

• Work with BI team to create smart/efficient reporting solutions using Crystal Reports

Rx Canada Mississauga, Ontario Jan 2008 – June 2008

Database Administrator ( Contract )

• Managing and monitoring RAC and ASM instances, problem resolution, user

administration, providing management reports and ensuring backup and recovery processes

are in place

• Perform server/application audits and health checks

• Upgraded from 9i to 11g, 10.2.0.1 to 10.2.0.3

• Plan and implement tuning on servers, databases and SQL levels

• Perform database tunning using Statspack reports, AWR, ADDM

• Experience designing, developing, testing, and deploying production database systems

• Testing of Hot/Cold Backup and Recovery and Cloning of databases using RMAN

• Monitors database growth and resources utilization

• Site Disaster Recovery Engineering (Experience developing solution for DR site)

• Performance engineering - Support performance testing; identify tuning and design

changes to gain performance

• Perform database recover; types of recovery,datafile recovery, partial database (table

space level recovery), database cloning, recovery from online and offline backup.

• Doing patch and cloning for 11i

• Cloning the application using Rapid Clone

• Work with Business Intelligence Analyst and Business clients to gather and document

needs for ad-hoc reporting

• Monitored and improved the performance of ETL processes, automation of Sql

queries, data feeds and security

Spectrum Supply Chain Mississauga, Ontario 2005 – 2008

Database Administrator

• Installed Oracle 10.2.0.1 on AIX 5.3, Solaris Sparc, Solaris x86,Linux x86

• Upgraded from 10.2.0.1 to 10.2.0.3, 10.2.0.1 to 10.2.0.4

• Delivering Oracle Database performance-tuning services for customers with EXPLAIN

PLAN, TKPROF, STATSPACK, SQLTRACE, ORADEBUG, 10gOEM Grid Monitoring

custom scripts troubleshooting oracle databases using sqltrace utilities

• Tuned SGA, Buffer Cache, Rollback Segments, Redo Mechanisms; Monitored and

detected locks; Tuned, sorted and pinned frequently used tables

• Trouble shoots and provides database performance & optimization for production

databases

• Documenting server access for all systems, and establishing backup and restore

procedures

• Perform server/application audits and health checks

• Manage 45 Oracle production databases and 15 development databases spread across

Canada on AIX & NT running the corporate Order Management System, Warehouse

Management System & Billing System

• Testing of Hot/Cold Backup and Recovery and Cloning of databases using RMAN

• Monitors database growth and resources utilization and provides database and server

capacity planning for applications expansion; prepares and presents to management

proposals for hardware upgrades

• Managing and administrating Sql Servers

• Worked with different financial modules for ad-hoc reporting

• Worked closely with Business Analyst for ETL extracts and reporting purpose.

• Recommended various sql queries for performance issues causing impact on ETL

loads.

Interface Sarl, Douala, Cameroon (Africa) 2003 – 2004

Database Administrator

• Administered and secured the database using roles and privileges

• On-going monitoring of database performance, fine tuning analysis and

implementation

• Performance tuning and monitoring the database using diagnostic tools like OEM,

performance pack including Oracle Expert, Lock Manager, Performance Manager, Oracle

Tracer, Tablespace Manager and V$views

• Configure and Installed ORACLE RAC

• Installing, upgrading the Oracle database

• Performing Oracle patches

• Plan, coordinate and implement security measures to safeguard information in computer files

against accidental or unauthorized damage, modification or disclosure

• Configured, created and upgraded the database

Alpha Systems 1999 – 2003

Database Administrator

• Led several tuning efforts using Statspack, SQL tuning, and the wait events interface that

resulted in significant improvements in response times for both application and data migration

modules

• Provided mentoring and knowledge transfer to DBA’s and developers on Oracle architecture;

Tuned methodologies, database replication, RMAN backups

• Database Storage management

• Corn shell scripting

• Comprehensive experience and skills as an Oracle DBA 7.x, Oracle 8, PL/SQL, SQL

• Generate user schemas, including table structure and referential integrity constraints

• Managed health of SQL Servers including backups, restores, monitoring

• Reviewed and tuned SQL queries, stored procedures, views, triggers

• SQL Server performance tuning and optimization, query optimization, index tuning, caching

and buffer tuning

EDUCATION & PROFESSIONAL DEVELOPMENT:

Oracle 10gCertified Database Administrator (OCPDBA) 2007

Oracle Institute

Oracle 10g DBA 2006

Humber College, Toronto Ontario

Red Hat Linux Basic Administration 2004

Tuya Classes

Oracle Certified Database Administrator (OCPDBA) 2001

Oracle Institute

Visual Basic 6 2001

Tuya Classes

C LANGUAGE 1998

Tuya Classes

Bachelor’s of Science 1998

M. S University, Baroda India

REFERENCES AVAILABLE ON REQUEST

Contact this candidate