JON

CHADWICK

PABALAN

Database Administrator AWS - SAA

PROFILE

Experienced Database Administrator

with a demonstrated history of working

with high availability configurations.

AWS Certified Solutions Architect

Associate, skilled in Amazon Web

Services (AWS) VPC, EC2, RDS,

Performance Tuning, Backup Plans,

and Replication Technologies. Strong

information technology professional

with a Bachelor of Science focused in

Information Technology from De La

Salle University-Dasmarinas.

CONTACT

PHONE:

091********

LinkedIn:

linkedin.com/in/jon-chadwick-

pabalan-459a7a93

EMAIL:

adjpqz@r.postjobfree.com

EDUCATION

De La Salle University - Dasmarinas

Bachelor of Science in Information Technology

June 2010 – April 2014

CERTIFICATION

Certified Amazon Web Services – Solutions Architect Associate Passed: October 10, 2020 Valid Until: October 10, 2023 WORK EXPERIENCE

Eastvantage Business Solutions Inc – Database Specialist April 2019 - Present

- Created database servers for testing and production

- Setup Replication Technologies on Servers

- Setup Fail Over Clustering

- Setup AlwaysOn High Availability

- Does pre-sales work and communicate with client’s business to business

Essilor Shared Services Philippines Inc - Database Administrator May 2018 – April 2019

- Develop SSIS Jobs

- Develop SSRS Reports

- Managed SQLServer 2008R2 instances

Capital Power Global Ltd – Team Lead Database Administrator April 2017 – May 2018

- Handled DBM Team

- In charge with Infrastructure planning

- Configure Failover Cluster

- Setup High Availability of Servers

- Create Amazon RDS for SQL Server

- Setup AWS EC2 Instances

- Setup Domain Controllers/DNS/Active Directory Windows server 2016

- Setup Application Request Routing with network load balancing windows server

Teradata – Database Administrator

January 2017 – March 2017

- Backup and maintenance tasks

- Database Optimization

- Develop performance reports

Wealth Access International Holdings (Previous Denizen Technologies Inc) Database Administrator

May 2014 – December 2016

- Create database servers for UAT - Production

- Configure transactional/p2p replication on sqlserver instances

- Configure Windows Failover Clustered Instances

- Query optimization using SQL Profiler/PerfMon/Execution plans

- Configure Domain Controllers/DNS/ActiveDirectory

- Setup Disaster Recovery Solution

- Setup VM for UAT database servers

- Configure Database Mirroring/ Log shipping

Cambridge University Press – Oracle Database Management Trainee

(Internship)

November 2013 – February 2014

- Configured Red Hat Enterprise Linux 6 server based on Oracle 11g

- Installed Oracle Grid Infrastructure and Real Application Clusters

- Tested Liquibase, a database refactoring tool, on the current database that were being used by the company

- Integrated maven, eclipse, subversion for the purpose of implementing Liquibase on the Database system

- Created dump files from the UK server and copied it into the local server using Linux command rsync, and Oracle data pump to export and import the dump files

- Contributed to the documentation on how to properly use Maven, Liquibase, Subversion on Eclipse

PROJECTS

Database Server Migration

March 2017 – May 2017

Migrated database from SQL 2014 with

Window failover cluster instance setup on

VM Servers to SQL 2016 Physical servers with

Always On High Availability Group Config

Encode System

October 2017 – February 2018

- Lead the planning and design of the AWS Infrastructure

- In charge with the technology stack to use and integrate on AWS

- Configured AWS EC2 instances, Setup RDS databases

- Configure VPC, Security Groups, NACLs

SKILLS

- Configuration of Windows Failover Cluster Instances

- High Availability and Disaster Recovery Planning and Configuration

- Solutions Architecture

- Configured Application Request Routing with Network Load Balancing on windows server (Web server)

- Configured Test Hadoop 2.6 node clusters on Ubuntu

- Oracle 11g

- SQLServer 2008R2, 2012, 2014, 2016, 2019

- Amazon Web Services Certified Solutions Architect Associate

- Azure

- AWS EC2, RDS, S3, VPC

- Windows Server 2008, 2012, 2016

- Setting up Domain Controllers/DNS/Active Directory

Contact this candidate