Post Job Free

Resume

Sign in

SQL Server Database Specialist

Location:
Philippines
Posted:
July 10, 2016

Contact this candidate

Resume:

Jasper Ian A. Guela

**-* **** **** *****, Phil-Am Homes, Quezon City

Mobile No: (63998) - 8487810

Home No: (632) - 4152632

Email: acvmto@r.postjobfree.com or acvmto@r.postjobfree.com

BACKGROUND

Jasper Guela has more than seventeen years of Information Technology experience in areas of Infrastructure and Application Development

SKILLS INVENTORY

Operating System:

Unix, Windows

Databases:

Oracle 9i, 10g, 11g, MS SQL Server 2000,2005,2008,2012

Application Server/Webserver:

WebSphere, WebLogic, Microsoft IIS

Job Management Tool:

Autosys

DETAILED WORK EXPERIENCE

Sun Life of Canada (Philippines), Inc.

Sun Life Financial is a leading financial services organization headquartered in Toronto, Canada, with operations in key markets around the world. The Philippine company serves as the regional headquarters for the Central Systems Department. This department supports the business in all territories in the Asia Pacific Region.

Positions Held:

Technical Manager – Database and Middleware Services – October 2015 – Present

Manages a team of 12 middleware and database administrators.

Directs the design, implementation and maintenance of IT systems and services

Establishes and enforce IT policies, standards and procedures

Oversees and coordinate establishment of project plans, schedules and budget

Works with users and technology teams to identify and address management information needs; educates users in IT policies, standards and procedures

Provides high-level consulting to users on IT systems and services

Ensures adherence to corporate policies, standards and procedures

Manages the professional career of IT professionals

Staff performance planning, monitoring and evaluation

Establishes IT service level agreements with the business community

Project Manager – February 2015 – October 2015

Single point of contact for all Infrastructure related requirements of Application projects.

Project Management of Infrastructure Projects.

Coordination of Infrastructure activities with Application Team.

Database Administrator/Specialist - June 2008 – February 2015

Primary responsibilities entail administering Oracle and SQL Server databases to support the business operations in the Asia Pacific Division and ensure optimal performance to meet desired SLA.

Define procedures, standards and guidelines with regards to Oracle and SQL Server databases.

Define procedures/standards for database security and user access base on the logical access set by Information Security Group.

Create and administer database in multiple environments (Development, System Test, User Acceptance Test, Model office and Production).

Creation and maintenance of database structure/design, as necessary, from information given by application developer.

Migrate databases to the Mainstream Database Version.

Setup/Install Oracle and SQL Server database software.

Provide 24x7 production support and development support on new applications.

Test and apply database patches as necessary.

Conduct database capacity planning in coordination with System Administrators.

Conduct researches on current database technologies and implement if necessary.

Monitor the performance of database and its server. Conduct database tuning if necessary.

Operations Analyst - June 2006 - June 2008

Coordinate with the development teams on batch operational requirements to ensure all applications are developed, tested and moved to UAT/Production according to set standards and procedures, and ensure SLA is achieved.

Plan, prepare, test, analyze, document and implement batch operational requirement, batch processing and operations flow according to set standards and procedures, and ensure SLA is achieved.

Act as change management facilitator. Review and facilitate change management for all systems in UAT/Production according to set standards and procedures, and ensure SLA is achieved.

Perform first level data center support on problem diagnosis and resolution to ensure SLA is achieved; responsible for escalation to next level support until final resolution and closure of the problem.

Train computer operations staff on all new systems supported by data center to ensure proper support is provided to end-user according to the SLA.

Train and assist computer operators to handle and support computer equipment and batch processing to ensure proper support is provided to end-user according to the SLA.

Application Development Experience

Systems Analyst: July 2005 - May 2006

Analyst/ Programmer: September 2002 - June 2005

Junior Analyst/ Programmer: August 2000 - August 2002

Programmer: May 1999 - July 2000

SPECIALIZED TRAINING

Foundation of Supervision – December 2015

Sun Life Financial Educational Center, Sun Life Centre BGC, Taguig

Project Management Professional Training – August 2015

QAI Learning - Sun Life Centre BGC, Taguig

SQL Server 2012 Performance Query Tuning – November 2013

DB Wizards, Makati Philippines

Oracle 10g Database Performance Tuning - September 2009

Oracle University, Makati Philippines

Project Management Workshop - August 2009

Sun Life Financial Educational Center, Enterprise Center, Makati

Oracle 10g Database Administration Workshop 1 - June 2008

Oracle University, Makati Philippines

INDUSTRY-RELATED TRAININGS (Insurance)

LOMA (Life Office Management Association)

FLMI 290 - Operations

November 2000

FLMI 280 - Principles of Insurance

November 2000

ACS100 - Customer Service

May 2003

FLMI 320 - Marketing Life and Health Insurance

May 2004

FLMI 310 - Legal Aspects of Life and Health Insurance

November 2005

EDUCATIONAL BACKGROUND

Bachelor of Science in Mathematics Major in Computer Science

University of Santo Tomas

Manila, Philippines

June 1995 - March 1999

PERSONAL DATA

Date of Birth: October 1, 1978

Place of Birth: Caloocan City, Philippines

Sex: Male

Nationality: Filipino

Civil Status: Married

Languages: English, Filipino



Contact this candidate