PROFILE

8 Years’ experience of full SQL Database Administration, Performance Analysis, SQL Disaster Recovery planning and configuration, Database Design, Onsite and Offsite Support in Production, Development, Test, Stage and Cluster Server Environments. Goal-oriented, Open for Change and Learnings, and able to communicate with both technical and non-technical persons involved in projects.

EXPERIENCES

DXC Technology

Consultant Level 3 / DBA

October 2018 to Present

Accenture, Inc.

www.accenture.com

Designation

Database Admin Senior Analyst

June 2015 to September 2018

Development
Automated customized daily monitoring and administration using SSIS, across project application servers. And to name a few: Disk size monitoring, SQL job monitoring, Database health monitoring, DR configuration status monitoring (Log shipping, Replication)
Develops business inventory and listing reports using SSRS
Implemented log shipping configurations to new SQL Databases
Designs and Implemented data replication via merge and transactional setup
Develops T-SQL scripts for data extracts, data manipulation, bulk updates, cleanup routines and team scripts for monitoring
Created maintenance plans for complete backup and refresh strategies
Leads some application database architecture

Maintenance
Optimizes Database Performance: Collecting necessary statistics (ex: execution run time) and profiler output analysis as base on improving performance
Controlled and monitored user accesses across database servers
In depth knowledge of High Availability health monitoring, latency and configuration: Log shipping, SQL AlwaysOn and Mirroring
Updates SQL jobs – run schedules, script date coverage, script conditions
Transactional and merge replication performance and impact monitoring
Monitor databases for errors, and perform problem determination and root cause analysis
Migrated multiple SQL instances from lower version to higher performance configurations

Other tasks and responsibilities
Leads project members involving application upgrades, database upgrades, re-indexing efforts and of DB standards
Work coordinator. Responsible on disseminating and overseeing tickets statuses/progress within team. Using ServiceNow ticketing system.
Attends team meetings with application owners or IT managers to provide database related insights and suggestion for upcoming projects
Documentation: DB infrastructure, DBA routines, and processes for DB object installation and patching

Kaiser dela-Cruz Consulting Inc.

2nd floor Lorma Medical Center Compound, Carlatan San Fernando City

La Union, 2500 Philippines

https://www.gomedsys.com

Designation

Systems Analyst (Radiology and Financial Module)

June 2011 up to May 2015

Development
Develops new programs, business reports, data transformation processing based on the given functionalities
New program development includes data entry forms and database tables creation and architecture.
Integrates software with other RDBMS systems (SQL to SQL, HL7 Interfacing, File auto-uploading)
Designs and Implements SQL database migration plans and scripts
Prepares the necessary program documentation, users manuals or operations manuals
Designs set of SQL scripts to perform data cleanup routines and data uploading-to-manipulation of hospital related data listing

Maintenance
Modifies existing business reports stored procedures or scripts, programs and data extracting scripts (used by IT support) based on the validated request modifications/changes
Modifies table fields, stored procedure, functions and views based on the system process change request
Updates documentation, user manual or operation manual based on changes made
Coordinates with the key business users to clarify and verify requirements

Testing and Implementation
Conducts unit testing and integration testing for functionality and performance limit
Assists users in the conduct of user acceptance testing
Provides product execution demonstration/data entry for end users regarding change requests

Troubleshooting / Product Support
Assists in troubleshooting reported problems encountered either during user acceptance testing or in the production system
Documents solutions or recommendations on problems serves as Team KB articles
Provides onsite support especially on modified programs and of business reports
Provides on call 24/7 support to clients

Other tasks and responsibilities
Mentors and assists entry-level developers
Generates daily, monthly and special reports using crystal reports and back end scripting
Advices inhouse IT Support for DB backup strategies and refresh to lower environment routines
Aids and suggests processes on data archiving operation
Provides support on capacity planning (used for disk expansion requests); computation-based on the existing database weight