Sql Server Management

ANDREW LOPEZ MONTEMAYOR

#* ************, ********** ********

Email Address: **********@*****.***

Contact Number: +597-*******

Objective

To utilize my skills and contribute to the company's productivity and

obtain IT position that suits my skills and qualifications in a fast-paced

technology company with varied responsibilities and potential for

advancement.

PROFESSIONAL sUMMARY

. 4+ years of experience in Database Administration and Developer for very

large and complex databases in SQL Server 2012, SQL Server 2008 R2, 2008

and 2005.

. Expertise in Database Administration on Production Servers with server

configuration, performance tuning and maintenance with outstanding

troubleshooting capabilities.

. Strong technical background along with the ability to perform business

analysis and write effective documentation and specifications.

. Expertise in T-SQL writing stored procedures, triggers and functions.

. Administering SQL Server High Availability and Disaster Recovery

strategies.

. Worked extensively on Clustering and server consolidation.

Troubleshooting production issues and raising high availability.

. Experience in Disaster Recovery Planning and Security Management

operations.

. Proficiency and expertise in SQL Server Replication, Backup/Recovery,

Disaster recovery and planning.

. Having hands on experience in DR processes including Log Shipping and

Database Mirroring.

. Worked on configuring SQL Server with minimum privileged access.

. Troubleshoot performance problems, fine-tuning of databases and index

Analysis.

. Maintained individual service accounts for SQL Server services on cluster

with different Security groups to raise security mark.

. Having Experience on Data center servers and handling 1.4 TB databases.

. Handling Memory configurations for SQL Server 2012 and SQL Server 2008 on

Windows 2008.

. Experience in Batch processes, Import, Export, Backup, Database

Monitoring tools and Application support.

. Working knowledge in Analysis Services (SSAS), Reporting Services (SSRS)

and Clustering.

. Experience in supporting Very Large databases (VLDB) and troubleshooting

the problems.

. Strong experience in mentoring team members and writing documentation.

. 24 X 7 Production Database on Call Support

TECHNICAL SKILLS

Databases: MS SQL Server 2012, 2008, MS SQL Server 2005

Programming: Visual Basic 6, Visual Basic 5, C, C++ & SQL

DBA: Database administration of MS SQL Server

2012,2008, 2005

Operating Windows 2008/2003 Advanced Server, NT & Windows 9x

System:

Other Software: Windows 2008/2003 Advanced Server, NT & Windows

9x, MS Office

Tools: Backup Utility, SQL LiteSpeed, Visio

Network TCP/IP, DNS, WINS, DHCP, FTP, SNMP, SMTP

Topologies:

EMPLOYMENT HISTORY / INTERNSHIP

Company : Greenheart Group Limited

Address : 31 Duisburglaan, Paramaribo Suriname

Department : Information Technology Group

Position : SQL Server Database Administrator

Date : July 22, 2013 - Present

Duties and Responsibilities:

. Responsible for extensive application/SQL monitoring, troubleshooting,

tuning, high-availability strategies in a Windows 2008/ SQL Server 2008

24X7 production environment.

. Develops and implements replication, archiving, and backup and recovery

strategies.

. Plans hardware requirements and storage capacity for production servers

for scalable database growth.

. Proactively monitors the Production Database and optimizes stored

procedures for better performance; resolves locking conflicts and

resource utilization issues.

. Administers, maintains, develops and recommends policies and procedures

for ensuring the security and integrity of the company's databases.

. Manages and creates database schemas for Relational Database Systems

(optimize index creation, table creation, storage allocations, etc.).

. Ensures all database environments (Development, Staging, QA and

Production) are in sync.

. Defines TSQL scripts versioning system to keep track of database versions

for all environments.

. Designs, reviews and implements production SQL Server database objects,

models and database designs (schema).

. Identifies and resolves database performance issues, database capacity

issues and other distributed data issues.

Company : MediCard Philippines INC.

Address : 7th Floor the World Centre, Gen. Gil Puyat Ave., Makati

City

Department : Information Technology Management Group

Position : Senior Database Engineer

Date : December 8, 2010 - July 12, 2013

Duties and Responsibilities:

. Design and maintain the database that provides informative and relevant

data to other employees within the company.

. Keep the database available, secure and stable. Constantly test the

data that is coming from the database to ensure it is not corrupted.

. Creates new database for programmer's testing. Updates record from the

database. Participates in Indexing and Rebuilding of database.

. Data Extraction as per employee request. Daily Database Back-up.

Participates in System Integration and Database update. Manages

database replication monitor.

. Ensure accuracy & integrity of data & applications through analysis,

coding, writing clear documentation & problem resolution.

. Manages company's website. Posts new articles, escalate online inquiry

and approves online registration.

Company : LBP Service Corporation

Address : 21st Floor Petron Mega Plaza, Gen. Gil Puyat Ave., Makati

City

Assigned at : Bangko Sentral ng Pilipinas, Manila Philippines

Department : International Operations Department

Position : IT Analyst

Date : July 13, 2009 - December 2010

Duties and Responsibilities:

. Works on the completion of Participants Files to be used in BSP's Debt

Management and Financial Analysis System (DMFAS) Project.

. Documents Short Term Loan Data Transfer Program including mapping of

tables and fields from the previous system Integrated External Debt

Management System (IEDMS-AS400) to the newly implemented Debt

Management and Financial Analysis System (DMFAS).

. Participates in Auditing and Editing of data migrated to Debt

Management and Financial Analysis System from Integrated External Debt

Management System.

. Generates Loan Information Sheet, Loan Account Statement and

Amortization Table from DMFAS to be used for production and for filing

purposes.

. Supports the Project Management Organization (PMO) with data gathering,

consolidation and reporting of activities;

. Periodically coordinates and requests for data update from other

organization;

. Generates regular reports using Microsoft Office Tools such as Excel

and provides initial analysis of the data;

. Ensures that pertinent data for report generation is properly gathered

and corresponding reports generated on time.

. Developed a Memorandum Receipt Assigning System. Mostly involved in all

phases of development including system requirement, design,

programming, testing/debugging and implementation.

educational background

Bachelor of Science in Information and Communications Technology

Pangasinan State University

Urdaneta City Campus, Urdaneta City, Philippines

Year: 2005-2009

SEMINARS AND TRAININGS

On the Job Training,

Land Transportation Office- Urdaneta City Branch

April 2008- June 2008

"Philnits/ Jetro Seminar",

Pangasinan State University, Lingayen, Philippines

September 2008

"ICT Congress, Web Development",

Pangasinan State University, Urdaneta City, Philippines

February 2007

"MS Visual Studio 2010 Training",

MediCard Philippines INC., Makati City, Philippines

June 2011

STRENGTHS

. Able to work independently

. A team player

. Excellent written and oral communication skills.

. Thorough, systematic, and organized worker, with an eye for quality and

detail.

. Fast learner, highly adaptable to a variety of situations and trainable

PERSONAL INFORMATION

Date of Birth : May 22, 1987 Place of Birth : Villasis,

Pangasinan

Citizenship : Filipino Civil Status : Single

Religion : Christian Sex : Male

Height : 5'8" Weight : 160 lbs.

CHARACTER REFERENCES

Available upon request.

I hereby certify that the above information are true.

Andrew L. Montemayor

Contact this candidate