RESUME OF

REYAM MELANDREW CRUZ

GA Tower Edsa Mandaluyong City

+639*********

PROFESSIONAL PROFILE

TECHNICAL SKILLS

Skill

Proficiency

Experience Age

(Indicate unit if less than a year)

Year Last Used

Microsoft Office

Advance

10

2019

C#.NET

Novice

1

2019

Microsoft Visio

Proficient

3

2019

Jira System

Proficient

3

2019

Subversion

Proficient

3

2015

MySQL

Proficient

3

2019

Oracle PL/SQL

Proficient

2

2019

Teradata DBA

Proficient

1

2013

SQL Database Administration

Proficient

2

2019

Teradata Scripting

Proficient

1.5

2013

MS SQL Server 2005/2008

Proficient

5

2019

MS SSIS

Proficient

5

2019

ITSM

Expert

1

2016

AWS RDS

Proficient

3

2019

AWS EC2

Novice

1

2019

CERTIFICATIONS

Microsoft Certified Professional – passed exams 70-433,70-451 (SQL database developer certifications)

TRAINING & SEMINARS

●SQL Server 2008 Bootcamp

●Introduction to VB.Net

●ASP.Net Fundamentals

WORK EXPERIENCE

FULL POTENTIAL SOLUTIONS (FPS) 03/2019 - PRESENT

Cloud Database Administrator

●Lead migration and support of existing on prem servers to aws rds

●Lead migration and support of existing on rds servers to aws redshift

●Creates report using aws spectrum

●Tune long running queries

●Performance feedback for junior members

●Facilitate daily scrum and project calls

●Address adhoc request from different vendor concerning database issues

●Develop ETL process to inject data in our database

Technologies Used

MS Visio, MS Excel, Word, RDS AWS, EC2 AWS, AWS Redshift, AWS Glu, AWS Spectrum, MySQL, Postgres, Jira, Confluence, SSIS

ASURION 06/2017 - 03/2019

Infrastructure Engineer

●Lead migration of existing MS SQL premise database to AWS Aurora

●Testing and performance tuning for all database related objects

●Develop spotfire report for stakeholders

●Participate in daily scrum to ensure all work deliverables are met

●Perform maintenance all etl on premise job

●Spin up RDS and Ec2 instances used for development and testing

●Configure Route 53 address for specific applications

Technologies Used

MS SQL Server 2005/2008/2012, BIDS 2008/2012, Service Now, SSIS, MS Visio, MS Excel, Word, RDS AWS, EC2 AWS

ACCENTURE, INC. 04/2016 - 05/2017

Architecture Lead

●Developed automated process on preparing LCBO data via SSIS 2010 and SQL Server 2010

●Perform maintenance task for the project such as but not limited to

oDatabase restore/backup

oUpdate statistics

oIdentify fragmented index candidate for reindexing

oStrategize on adding database files to support testing of development team to avoid space issue

oAdd and modify database users

oCreates basic powershell script to automate deployments involving database upgrades and hotfixes deployments

●Gives performance feedback on teammates

●Assign deliverables for each senior and junior member outside there ticketing task

●Mentor/Coach newly roll in teammates

●Attends client facing calls/discussion

●Coordinate AO and IO teams for process improvement for the whole project

●Creates overall team process

Technologies Used

MS SQL Server 2005/2008/2012, BIDS 2008/2012, Service Now, SSIS, MS Visio, MS Excel, Word

ACCENTURE 09/2015 - 04/2016

Oracle/SQL Server DBA Lead

Client/Project: Project Michaels - one of the leading retail distributors of framing products throughout the US and Canada

●Developed automated reports via SSIS 2008/2012 that will help cut manual checking of the sql servers

●Maintain shift plan for DBA team

●RIM (Risk and Issue Management) Coordinator/POC for Michaels’ Infrastructure teams

●Resolve P1,P2,P3 and P4 tickets as part of our daily BAU

●Restore databases from 1 server to another

●Perform weekly fragmentation check on each servers

●Deployment of scripts(DML),jobs provided by application teams on prod boxes (ensure that proper approval, testing has been done before the deployment and always have a screen share)

●Identify highly fragmented index and create maintenance plan to reduce the fragmentation percentage and in return have a better performance

●Create maintenance task for backup and cleanup for all sql servers

●Create/add/delete users on each boxes as per request of the business users

●Gives performance feedback on teammates

●Assign deliverables for each senior and junior member outside there ticketing task

●Mentor/Coach newly roll in teammates

●Point of escalation for every HBI(High Business Impact) issues

●Attends client facing calls/discussion

●Coordinate AO and IO teams for process improvement for the whole project

●Maintain and coordinate with infra teams for the tracking of each Problem tickets assigned to there queue

●Configure Failover setup for platinum servers

●Use Solarwind/Spotlight as monitoring tools for SQL servers health

●Use Service Now to monitor daily ticket inflow

●Performed Incident management and resolution

●Creates weekly/monthly trending ticket report and share the report with onsite L3 DBA for analysis

Technologies Used

MS SQL Server 2005/2008/2012, BIDS 2008/2012, Service Now, SSIS, MS Visio, MS Excel, Word, Spotlight, Solarwinds, ServiceNow, Oracle 10G, PL/SQL

OUTSOURCED 12/2014 - 07/2015

Project Manager / ETL Lead / BI Developer

Client/Project: Project CCBP(GotoDRS) - a finance/insurance company based in the US. The purpose of our services for this project is to eliminate all manual processes being done by their agents and also re-architect the existing database to support data growth in the future.

●Gather requirements, plan and estimate timeline of the project

●Provide members daily task and perform weekly/daily meeting to discuss challenges and accomplishments

●Daily meeting with business users/clients

●Develop application that will satisfy the BAU using MS SQL 2005/2008/SSIS

●Automate all manual process done by business

●Provide project documentation and timeline

●Manage and admin subversion for code repository

●Perform QA/Code review of members task

Technologies Used

MS SQL Server 2005/2008, DBeaver, Oracle PL/SQL, Subversion, SSIS, C#, Jira, ITSM

JP MORGAN 12/2013 - 11/2014

Project Manager / Developer

Client/Project: Project Filestaging - an application that enables a user to send funds details to specific clients via a secure route (3rd party gateway) by using a xml file to act as its tracker. Prior to sending the files a series of verification steps are to be passed.

Client/Project: UPART - a MS Access project that helps the business users compute funds discrepancy by applying complicated business rules and logics on sql queries.

●Gather requirements, plan and estimate timeline of the project

●Provide members daily task and perform weekly/daily meeting to discuss challenges and accomplishments

●Daily meeting with business users/clients

●Develop application that will satisfy the BAU using MS SQL 2005/2008/SSIS

●Automate all manual process done by business

●Provide project documentation and timeline

●Use subversion for code repository

●Perform QA/Code review of members task

Technologies Used

MS SQL Server 2005/2008, Oracle PL/SQL, Subversion, SSIS, C#, ITSM

JP MORGAN 12/2013 - 11/2014

Project Manager / Developer

●Gather requirements, plan and estimate timeline of the project

●Daily meeting with business users/clients

●Develop application that will satisfy the BAU using MS SQL 2005/2008/SSIS

●Provide project documentation and timeline

●Use subversion for code repository

●Perform QA/Code review of members task

Technologies Used

MS SQL Server 2005/2008, Oracle PL/SQL, Subversion, SSIS, C#, ITSM

TERADATA 06/2013 - 11/2013

Database Administrator

●Retrofit DDL's from Dev, QA and Prod boxes

●Assign/Create roles, users,profiles as per clients request

●Investigate issue occurring in QA,Prod and Dev boxes

●Collect statistics and give index recommendation for core tables

●Perform data profiling on Dev, QA and Prod boxes

●Automate script /query for easy DBA use

●Perform PDM on Teradata database vs Oracle database

●Allocate space on boxes as per user's use

Technologies Used

MS SQL Server 2005/2008, Teradata SQL, TD Admin, Viewpoint, Excel, TD Data Miner tool

TERADATA 11/2012 - 04/2013

Developer

●Responsible for creating deliverables during build phase(code,component test planning)

●Unit testing and peer review of codes

●Communication with client and onshore counterpart for daily status update

●Distribute, monitor and manage task for team

Technologies Used

MS SQL Server 2005/2008, Teradata SQL, SQL Express, Excel

TERADATA 08/2012 - 10/2012

Developer

●Converted Oracle codes to Teradata

●Performed UTP for codes in QA and Dev environment

●Documented and provided hot fixes on issues encountered during development,test and deployment phase

Technologies Used

MS SQL Server 2005/2008, Teradata SQL, SQL Express, Excel

EDUCATION

Baliuag University - Baliuag, Bulacan

Bachelor of Science in Electronics and Communications Engineering, Graduated 2009

Contact this candidate