PAVITHRA SRINIVASAN

Mississauga, ON ac7xfv@r.postjobfree.com +1-905-***-**** linkedin.com/in/pavithra-srinivsn

Oracle Database Administrator

Over 6 years of experience as an Oracle Database Administrator with strong expertise in database administration, production support, installation, configuration, upgrade, patch, backup and recovery, database security, audit, space management, script development, performance tuning and documentation.

Ensured high availability and performance (24 hrs production support)

Hands on experience in migration, up-gradation and optimization of over 1TB databases

Database Capacity planning and management of logical volume and ASM, load balancing, backup, disaster recovery and security

Skilled in creating database scripts and shell scripts resulting in database optimization

Certified in OCP 12c Database Administration and ITIL v3

Strong communication skills, analytical logical abilities, problem solving and ability to work to tight deadlines under pressure

Master in Computer Applications and Bachelor in Science

TECHNICAL SKILLS

Databases: Oracle 10g, 11g, 12c, SQL Server, MS-ACCESS

Languages: UNIX Shell programming, SQL

Operating Systems: Windows, HP-UNIX, Linux

Tools: OEM, SQL Plus, RMAN, Data Pump, Export/Import, Putty, SQL Developer, DBCA, TOAD, TKPROF, EXPLAIN PLAN, AWR, STATSPACK, ADDM, ASH, AUTOTRACE, ADRCI, ASM, DBSAT

Oracle Skills: Data Guard, Backup and Disaster recovery, Troubleshooting, Performance Tuning

PROFESSIONAL EXPERIENCE

Role: Oracle DBA

The Clearing Corporation of India Ltd. – Mumbai, India Jul 2010 – Feb 2017

Finance/Banking Industry (www.ccilindia.com)

A corporation subsidiary to Reserve Bank of India (RBI) and is promoted by leading Banks / Financial Institutions

ACHIEVEMENT

Successfully recovered a production truncated (permanent delete) table, containing 15 lacs rows of highly sensitive data. This process which ideally would have taken 6 hrs was completed by me in 30 mins

Project 1: Migration of 10g database (non-ASM) to 11g (ASM)

Led and managed the migration of 1TB databases from Oracle 10g (non-ASM) to 11g (ASM) and the data conversion ensuring data integrity and quality

Installed and configured Oracle 11g ASM and database on over 500 servers for high availability

Configured and managed physical standby database using Data Guard for disaster recovery on a different node for different production servers.

Created a backup configuration using Oracle Recovery Manager(RMAN) and Data pump, thus ensuring the data remained secured at any point of time and cutting down the data loss by 95%

Configured and enabled Flashback thus reducing the logical damage by 90% which helped in the reduction of accidental errors

Implemented and enforced a security policy for database users. Used the Oracle Database Security Assessment Tool (DBSAT) to analyze database configurations and security policies

Project 2: Standardization and Automation of scripts

Developed an automation alert system resulting in an accurate and timely information of errors within the database, reducing turnaround time from 3 hours to 30 minutes

Developed a fraud alert system for a sensitive database that send the credentials of users who logged on to senior management thereby improving the security aspect of the Database

Developed and standardized scripts for BCP activities and Data Centre Operations resulting in the reduction of the complexity of operations and the DC Team using the same actions across all the databases

Automated a script that ran weekly for defragmentation thus reclaiming the wasted space and improving the overall performance of the database

Key Functions

Installed, configured Oracle 12c ASM and database on over 30 servers. Created Container databases (CDB) and Pluggable databases (PDB) and managed them

Tuned the performance for long running queries using AWR reports, trace, explain plan. Analyzed the existing table structures and fine-tuned if required

Forecasted the growth of database by capacity planning over monthly / yearly basis

Created a business continuity process (BCP) plan in the event of a disaster for an intermediary firm that integrated with 19 public banks, 180 private banks, handles guaranteed settlement(GS), real time gross system(RTGS) and funds settlement system(FSS)

Installed more than 20 critical patches to rectify database bugs, thus protecting the end users, organization and upholding the security aspect of the system

Generated and distributed Adherence, Audit, Security and Forecasting reports to the senior management

Implemented an auditing system which monitored the actions of users on the database

Technical Environment: Oracle v10.2, 11.2, 12c; Platforms - HP-UNIX, Linux, Windows 7

Role: Dot Net Developer

Sparsh BPO Services Ltd Jan 2010 – June 2010

Created and implemented CHAT Application as a part of my internship.

This project includes features like over LAN, easy implementation on internet, private chat, conference chat. People can transfer files and have a customized experience to chat with.

Microsoft C#, SQL Server 2005

VOLUNTEER EXPERIENCE

Worked at Holiday Inn Express for 6 months to get a feel of Canadian work culture Feb 2018 – Aug 2018

QUALIFICATIONS

Workplace Communications for IT Professionals from Ryerson University, Canada 2018

Master of Computer Applications (MCA) from SIES College of Management Studies, Mumbai University

[Canadian Equivalency: Master’s degree (WES Certified)] 2007-10

Bachelor of Science (B.Sc. Computer Science) from RUIA College, Mumbai University

[Canadian Equivalency: Bachelor’s degree (WES Certified)] 2003-06

CERTIFICATIONS

Oracle Certified Professional (OCP) 12c Database Administration

ITIL V3 – Foundation in IT Service Management

Contact this candidate