Senior database administrator

RESUME

Arvind Kamath B S

Mobile: +91-886*******

Email: ****************@*****.***

Professional Summary

Over 11 years’ experience as Database Administrator in managing database systems across Retail, Banking & Telecom industry. In-depth knowledge of Oracle, Sql Server, PostgreSql &

MySQL. Proven effectiveness in Handling Database Systems in Production and Development

Environments. Intermediate in Vertica,Mongodb & AWS RDS Aurora.

Areas of Expertise

Installation & Configuration Of Oracle, Sql Server, PostgreSql & Mysql

RMAN Backup & Recovery

Oracle RAC setup and administration

Sql Server Backup and Recovery

Sql Server Replication, Mirroring & AlwaysOn setup

Annual DR Test

Oracle Data guard Setup

Oracle Golden Gate Replication

Oracle Enterprise Manager installation and setup

Performance Tuning

Shell Scripting

Quarterly Patching Of Oracle, Sql Server & EDB PostgreSQL

Oracle To Postgres Migration

Oracle To AWS RDS Aurora Migration

Database Design

PL/pgSQL Development

MySQL 8 Installation, Replication Setup.

Major Accomplishments ( M1 LTD)

Successfully Migrated Oracle 5 Production and 10 Development databases

From 11gR2 to 12cR2.

Successfully Configured 6 Oracle 12cR2 databases with Dataguard.

Created Shell Script to automatically patch Oracle PSU of version 11 & 12

for all Unix Flavors ( AIX,Solaris & Linux).

Created 6 Sql Server 2014 Instances with Always On Replication.

Oracle TDE setup for 8 production databases.

Implementation of Imperva DAM ( Database Active Monitoring ) for protection

Against data breach for Oracle,Sql Server & Postgres databases.

Successfully migrated 3 oracle databases to AWS RDS Aurora PostgreSql.

Oracle Enterprise Manager 13c installation and alerts setup for production databases.

2 Production MySQL 8 installation and Replication Setup.

Delphix and Datamasker setup for Oracle & Sql Server databases.

PEM installation for EDB Postgres databases for Monitoring.

Configured DRITA function for EDB Postgres for hourly stat snapshots.

Develop PL/pgSQL stored procedures for PostgreSQL.

Successfully Migrated 5 Production & 10 Development Oracle Databases

To EDB PostgreSql V9 & v10.

Career Experience

M1 LTD (Jan 2014 – Apr 2020)

Senior Database Administrator,

Singapore

Installation of Oracle software, SQL Server, PostgreSql & Mysql.

Planning and designing DB including logical/physical structures.

Configuring Backup & Monitoring for Oracle, Sql Server, PostgreSql & Mysql.

Review and Apply Oracle quarterly patches, Sql Server security and CU patches & EDB Postgres patches.

Yearly DR activity, Visit DR Site and carry out annual test for switchover of Oracle databases.

Sql Server 2014 AlwaysOn installation and setup.

Sql Server Replication, Mirroring Setup and administration.

Beginner Level support for Vertica & Mongodb databases.

Performance Tuning for Oracle databases.

Oracle database monitoring with OEM,AWR & ASH.

Uprade Oracle 11g databases to 12c.

Migration of Oracle databases to EDB Postgres.

Migration of Oracle databases to AWS RDS Aurora.

Develop PL/pgSQL stored procedures for PostgreSQL.

Convert Oracle Stored Procedures to PostgreSQL.

Refresh of Oracle & Sql Server development databases with Delphix.

Datamasking of Develpoment databases with Datamasker.

Mysql 8 installation and replication setup.

Imperva DAM (Database Activity Monitoring) Setup & administer through

SecureSphere for protection against data breach.

WIPRO TECHNOLOGIES (Jun 2008 – Jan 2014)

Database Administrator,

India & Singapore

Worked with 2 clients during my tenure in Wipro (India Location).

a) Levis Strauss and Co DBA Support, US.

b) NGN DBA and Infrastructure Support, Northern Gas Networks, UK.

Worked with 1 client during my tenure in Wipro (Singapore Location).

a)CACIB DBA Support, Credit Agricole Investment Bank, Paris

Installation of Oracle Software & Sql Server software.

Oracle & Sql Server Job and alerts monitoring.

Oracle & Sql Server Backup and Restorations.

Maintaining & administer Oracle 11gR2 RAC databases.

Service Request and Change Request handling using Remedy Ticketing Tool.

Automation of DB jobs as required by the applications.

RMAN Clone of production databases into Development databases.

Upgrade & Migration of Oracle Databases

Conversion of 11gR2 Production databases into Dataguard.

Sql Server Replication, Mirroring Setup and administration.

Oracle Goldengate Replication Setup.

Patch Oracle & Sql Server databases.

Trainings Attended

HPE Vertica Database Administration 7.2

16,17 & 20 Feb 2017

Ashnik 5 day comprehensive PostgreSQL Training

18 to 22 Sep 2017

Imperva IU_Database Security and Compliance 13.0

Database Active Monitoring ( DAM ).

07 to 10 Oct 2019

Academic/Professional Qualifications

2008 : Master Of Science ( MSc in Computer Science),

Kuvempu University, India.

2003 : Bachelor of Science ( BSc in Computer Science ),

Mysore University, India.

Personal Particulars

Age : 39

Citizenship : Indian

Languages : English, Hindi, Kannada

Marital Status : Married

Interests : Reading, music

Contact this candidate