Manager Sql Server

ERICH JOSEPH C. AMAGNA

** ***, ****** ******, ***********, Ontario, Canada, M1L4W4

Mobile: 416-***-**** Home: 416-***-**** **********@*****.***

LinkedIn: ph.linkedin.com/pub/erich joseph amagna/12/6a2/479/

P R O F I L E

A skilled IT professional with more than twelve years of experience in database and system administration, eight years as

technical lead and more than three years in a senior level position. An experienced and proactive team leader, fast learner, and

continually looking to upgrade knowledge and skills.

P R O F E S S I O N A L E X P E R I E N C E S

AMDOCS, Infra Group Leader (Teradata DBA), July 02, 2012 up to October 15, 2013

Award/s: September 2012 Employee of the Month, April 2013 Awardee for an Outstanding Performance

Project: Globe Telecom, July 02, 2012 up to October 15, 2013

Managed Teradata Database 13.10 running in 2650 and 2580 appliances with 24/160TB and 4/20TB nodes/disk

capacity respectively.

Managed all deployment/object migrations from Development to System and User Acceptance Testing to Production.

Administered capacity planning through housekeeping, purging, applying table compressions and making sure

retention policies are being implemented.

Conducted performance tuning to problematic queries by analyzing explain plans, collecting stats, using partition

columns on huge tables, analyzing join conditions and recommending the best possible columns to be defined as part

of the primary index.

Managed all DBA activities affecting huge tables like dropping and recreating of partitions, reinserting of data due to

table restructure of indexes, managing of spool and temp space, and copying of data from one server to another using

ARC scripts.

Provided root cause analysis to all Priority 1 and 2 issues.

Supervised security access by making sure each accounts have the correct roles and profiles.

Checked all system alerts and make sure to close all tickets within the agreed SLA.

Supervised daily monitoring of the server using Teradata Viewpoint to make sure that the system was well maintained

during business hours.

Performed DDL and DML script executions for development and testing phases as well as production change requests.

Managed backup application tools (TARA) to make sure all archive jobs were successfully completed. In the event of

failures, provide root cause analysis and decide whether to rerun on the basis that no other applications will be

affected. Stakeholders must be always informed.

Created a collect stats scheduler that can be executed in a daily, weekly or monthly basis using BTEQ, Macro,

Windows Task Manager and batch commands.

Managed and assessed all hardware and software issues/upgrades in coordination with the Global Support Group.

Provided daily automated daily and weekly reports essential to workload analysis like CPU/IO and Memory usages

using BTEQ and Macro scheduled in Windows Task Manager via batch command.

Maintained daily and weekly database backup using TARA.

Provided lead roles to coordinate and resolve issues relating to Teradata product lines in a timely manner.

Provided on site DBA support to all Amdocs clients using Teradata Platform by making sure that 24/7 support is in

place.

Performed an in depth problem/product/root cause analysis and provided solutions/work around.

Page 1

ERICH JOSEPH C. AMAGNA

Identified and documented new product defects and solutions.

Administered Teradata related tickets.

Mentored, developed and transferred all technical knowledge to junior DBAs.

UST GLOBAL, Associate Consultant (Teradata DBA), January 16, 2012 up June 29, 2012

Project: Wellpoint, January 19 to June 29, 2012

Provided production and development support for all projects related to Teradata.

Assisted Business Intelligence group on report performance issues.

Managed DBA activities as required by the development team.

Interfaced with clients regarding Teradata issues.

Member of a group panel that review scripts essential to SDLC process.

Trained junior resources about Teradata architecture, performance tuning and coding standards that is critical to client

needs.

TERADATA, Technical Consultant (Teradata DBA), November 15, 2010 up to December 31, 2011

Project: Intercontinental Hotels Group, June 16 to December 31, 2011

Provided an off shore Teradata Database Administration Support for Intercontinental Hotels Group which is based in

Atlanta.

Administered Teradata Database 13.10 running under 2550 Appliance with 12 Nodes/60TB for Production, and 1

Node/1TB for Development.

Performed performance tuning to all problematic queries being executed by BI and ETL teams.

Administered and Supported Development, Testing and Production Environments.

Worked closely with Global Support in expanding the Production System from 8 to 12 Nodes.

Escalated high level issues to Teradata Global Consulting Center and work with them for immediate resolution.

Used Teradata Client Tools to monitor and managed multiple users and sessions, analyze workloads, system health

check, manage space, and monitor hardware issues.

Used ATANA Suite for column compressions and replicating tables to preserve data and statistics.

Used TARA to manage backup and restore activities.

Worked closely with the Business Intelligence and Development teams for all development and performance related

tasks.

Conducted weekly CPU/IO/Space reports to the client’s DBA Manager.

GLOBE TELECOM, Sr. Specialist (ETL/System Administrator), July 21, 2008 – November 6, 2010

Implemented procedures to maintain, monitor, backup and recovery operations for ETL jobs running under UNIX and

MS SQL Server environments.

Conducted ETL optimization, troubleshooting and debugging.

Performed import and export ETL jobs by consolidating data in UNIX then transmitted to Windows 2003 Server via

FTP to be loaded in MS SQL Server via DTS/SSIS. This is across various ETL projects and servers.

Provided development support to ETL application development teams via DTS/SSIS.

Managed roles, users and access privileges in Windows 2003 Server essential to the users’ accessibility to the

database.

Performed database administration of SQL Server Database and DTS/SSIS.

Performed basic system administration in UNIX and Windows 2003 server by regular system health check, managing

of all jobs running in cron and scheduled tasks, performing manual housekeeping if necessary, space management and

application restart.

Collaborated with the company’s data warehouse and ETL developers to implement ETL solutions.

Page 2

ERICH JOSEPH C. AMAGNA

Conducted troubleshooting production and ETL job issues.

Performed Level 2 support on different Web Applications by redirecting web portals, upkeep Internet Information

Service, restart APACHE application, manage website performance issues and escalate high level ticket to responsible

groups to work with them for immediate resolution.

Acted as the single point of contact between Outsourcing Developers, DBAs, System Administrators, Level 1 support,

and the Business and Project Teams.

PLDT EMPLOYEES’ CREDIT COOPERATIVE INC., Lead Database/System Admin, February 5, 2002 June 15, 2008

Award/s: 2002, 2003 and 2004 Employee of the Year

Responsible for the company’s IT infrastructures.

Managed the company’s integrated system developed by a third party vendor using Visual Basic and MS SQL Server.

Planned, designed and executed system enhancements thru query optimizations and development that are very critical

to the varying business requirements.

Responsible for migrating manual booking transactions of accounts to automated transactions via MS SQL Server

database.

Developed the company’s Members’ Information System to address critical information needed by the customer

service and functional officers in approving or disapproving transactions.

Developed an adhoc queries crucial to implementing yearly dividend transactions, computation of monthly savings and

fixed deposit interest, and calculate monthly penalties for all deferred accounts.

Developed an adhoc queries to generate daily bank advice via flat files following the format required by each banks to

credit the net proceeds of all members with loan and withdrawal transactions.

Administered Windows 2003 Server and MS SQL Server database application.

Provided technical support to all other sections.

Provided monthly report to the General Manager using Crystal Report, MS Access and MS Excel.

Managed the company website.

Performed backup and restore.

Managed Sophos Antivirus and company emails.

Participated in all regular management meetings and reported directly to the General Manager.

Provided technical trainings to the members of the team.

Provided the team with all necessary business information.

Provided the team with standard operating procedures to address all relevant issues within the specifications and

various standards.

Worked with functional committee officers and different vendors to obtain necessary resources to support the team's

technical requirements.

Coordinated meetings with the computerization committee, general manager and all stakeholders to discuss project

impediments, needed resources or issues/delays in completing a task.

PHILIPPINE LONG DISTANCE TELEPHONE COMPANY, Project Assistant, August 3, 2001 February 4, 2002

Provided technical support to the shipment section under Warehouse Division.

Encoded shipment information and coordinate with respective carriers for scheduled deliveries.

Managed database information critical to shipment distributions.

MERCURY SHIPPING CORPORATION (November 16, 1999 March 16, 2001 as Records Assistant)

Provided technical assistance to different organizations.

Encoded daily transaction critical to seaman’s scheduled embarking and disembarking.

Page 3

ERICH JOSEPH C. AMAGNA

Provided system analysis and design for continuous system enhancements using Visual Foxpro.

Managed seaman’s 201 files, hardcopy and softcopy.

Assisted managers on technical difficulties with regards to report generations using Microsoft Office products.

MAPUA INSTITUTE OF TECHNOLOGY (June 1997 December 1998 as Student Assistant)

Worked as a Student Assistant in the school library.

E D U C A T I O N

Bachelor of Science in Computer Engineering – Mapua Institute of Technology (1999)

C E R T I F I C A T I O N S

Teradata Certified Professional (C3H2J6XC2F415P86)

Microsoft Certified Professional (6241550)

E X A M I N A T I O N S P A S S E D

IELTS (International English Language Testing System) – April 12, 2012

Teradata Exam Code TE0 122 (Teradata 12 SQL) – May 10, 2011

Teradata Exam Code TE0 121(Teradata 12 Basics ) – February 28, 2011

Microsoft Exam Code 290 (Managing and Maintaining a Microsoft Windows Server 2003) – May 26, 2008

T R A I N I N G S

Teradata Advanced SQL, Teradata Philippines (February 16, 2011)

Teradata Warehouse Administration and Management, Teradata Philippines (January 28, 2011)

Teradata Factory, Teradata Philippines (December 15, 2010)

Statistical Analysis System (SAS) Programming 2, SAS Institute of the Philippines (April 30, 2009)

Statistical Analysis System (SAS) Programming 1, SAS Institute of the Philippines (March 18, 2009)

Information Security Design and Consulting, Globe Telecom (October 10, 2008)

Managing and Maintaining a Microsoft Windows Server 2003 – Course 2273B, Edupro Inc, (February 2, 2008)

Advance SQL, Informatics, Makati City (November 13, 2004)

Introduction to Client/Server Database, Informatics, Makati City (October 15, 2004)

MSQL1 – SQL Server Programming, Informatics, Makati City (September 24, 2004)

Introduction to desktop database development using Microsoft access 2000, Informatics (September 2, 2004)

REFERENCES

Available upon request

Page 4

Contact this candidate