Database Administrator

Senior Engineer - Database ** May **** - Now

Database Administrator 16 Sep 2020 - 28 Apr 2022

*************@*****.***

+65-98-999-560

Singapore

www.linkedin.com/in/paulvfranklin/

Paul V Franklin

Oracle Certified Professional (OCP) - MySQL Database Administrator (1Z0-883). 7 years of experience in Database Administration.

Experience in MySQL, MS-SQL and Oracle Administration on On-Prem/Cloud (AWS/Azure) environment. Experience in Database Installation, Upgrade, Maintenance and Troubleshooting. Experience in MySQL/MariaDB Install/Upgrade, Replication, InnoDB Cluster, Backup & Recovery, MEM, MEB. Experience in MS-SQL Server & Azure SQL DB Logins, Privileges, Backup & Restore, Always-On, Log Shipping. Experience in Oracle Database Installation, User Access Control, AWR Reports, DB Backup & Restore. Experience in Performance Tuning, Query Optimisation, Log Files Monitoring, High-Availability. Experience in Automation, ETL Design, SSIS Jobs, 24*7 On-Call Support & Monitoring. Experience in Percona Toolkit, MariaDB Audit, Zmanda Recovery Manager (ZRM) and XtraBackup. Experience in Azure VM & AWS EC2, Security/Resource Group, AWS RDS, AWS DMS. Knowledge of MongoDB Replica Set, Sharding, MongoDB Atlas/Compass. Experience in Pentaho ETL, Zabbix, Datadog, JIRA, Sysbench, Putty, MS-RDP, Slack. Experience in DBA team activities work-flow documentation (SOP, Confluence). Experience in SQL Server Management Studio (SSMS) and Azure Data Studio. Experience in Automation of Data Archival, Data Hashing using MySQL Events, Stored Procedures and Triggers. PCCW Solutions, Singapore

Managing the Database Environment of Monetary Authority of Singapore (MAS) Installation & Upgrade of MySQL & MS-SQL Databases Setting up of InnoDB Clusters & InnoDB ClusterSet

Master-Slave & Multi Channel Replication implementation Hardening of MySQL DB environment according to CIS guidelines Auditing of Database Events as per GovTech guidelines User Access Management

Database Backup Configuration

Designing of ETL jobs

Troubleshooting InnoDB Clusters

Tuning of MySQL config variables

Fine Tuning the Queries.

Walmart, Chennai

Installation & Upgrade of MySQL, MS-SQL, Oracle Database DB Replication, Backup & Restore

Configuring DB Security, Always-On & Availability Groups Involving in Production Pages and Supporting P1 & P2 Incidents Change Request Management for Production activities Creating IVB Plan (MySQL, Oracle CLI Queries for Implementation, Validation & Backout) for Production Releases

Oracle User Creation, Access Privileges, Lock/Unlock users, Generating AWR Reports Documentation (Confluence)

System Performance & Health Monitoring (Datadog, Grafana & Slack) 24x7 On-Call support

SUMMARY

WORK EXPERIENCE

Database Administrator 03 Oct 2017 - 11 Sep 2020

Database Administrator 04 Jan 2017 - 30 Sep 2017

Database Administrator 04 May 2015 - 30 Nov 2016

Bachelor of Engineering (BE) Aug 2010 - Jul 2014

GAIN Credit (formerly Global Analytics), Chennai

Capacity Planning

Installation & Upgrade of MySQL, MongoDB Database

Database Replication, Sharding, Cluster setup

Database Backup & Recovery

Data Extract, Transform and Load (ETL)

Database Security and Access Control Policy

Database Processes and Tools

Database Tuning & Troubleshooting

Performance Monitoring, Query Optimization, Documentation (SOP) Master-Slave, Master-Master, Multi-Channel and Group Replication 24*7 On-Call Remote Monitoring Support

QR Solutions, Trichy

MySQL DB Administration for AUDI-Australia, ASG Australia. Bharat Electronics (BEL), Bangalore

Installing & Configuring MySQL in CentOS Linux 6 Platform. Creation and Maintenance of Production Databases.

Implement and Maintain Database Security (User Roles and Access Privileges). Providing Technical Support for Clients, Data Centers for Troubleshooting. Meeting Government Officials like Census & Rural Development Ministries Directors, Joint Directors, District Collectors for planning the Project activities.

Oracle Certified Professional (OCP-1Z0-883) - MySQL 5.6 Database Administrator. MySQL 5.7 Administration Test by Brainbench (scored Higher than 96% of all previous test takers). Microsoft SQL Server 2019 - Essential Learning - LinkedIn Learning SQL Server 2016 - Administer a Database Infrastructure - LinkedIn Learning Become an Azure Administrator - LinkedIn Learning Path AWS Database Migration - eLearning.

Anna University, Chennai

Computer Science and Engineering (CSE)

QUALIFICATIONS

EDUCATION

Contact this candidate