Sql Server Quality Control

Phillip Galicia

***** ******* ** #****, *** Antonio, TX 78253

210-***-**** **********@*******.***

MCTS: Microsoft SQL Server 2008, Implementation and Maintenance

CompTIA Security+ Certification

PROFESSIONAL EXPERIENCE

BEAT, San Antonio, TX

September 2012 - Present

Senior SQL Server Database Administrator

- Responsible for installing and configuring SQL Server 2012 and SQL Server 2008 clustered and non- clustered

instances.

- Manage security and apply hardening scripts to meet client/ government requirements.

- Perform database migrations and assist application support teams.

- Create, monitor and provide reporting for backup and recovery plans.

- Create and monitor database maintenance plans including Integrity Checks, Index Rebuild/ Reorganization and

Updating Statistics

- Configure and monitor Transactional Replication

- Install patches and Service Pack upgrades

Accenture, San Antonio, TX

May 2011 - September 2012

Senior SQL Server Database Administrator

- Responsible for installing and configuring SQL Server 2005 and SQL Server 2008 clustered and non- clustered

instances.

- Manage security and apply hardening scripts to meet client/ government requirements.

- Perform database migrations and assist application support teams.

- Create, monitor and provide reporting for backup and recovery plans.

- Configure and monitor native SQL Audit logs.

- Create and monitor database maintenance plans including Integrity Checks, Index Rebuild/ Reorganization and

Updating Statistics

- Supported backend databases for Blade Logic, Citrix, Remedy and SharePoint.

- Implemented and managed log shipping.

- Queried tables and performed administrative tasks via SQL scripts.

SWBC, January 2007 - May 2011

SQL Server Database Administrator

- Production DBA administering over 60 instances of SQL Server 2008 R2, SQL Server 2008, SQL Server 2005 and

SQL Server 2000.

- Installed SQL Server instances and service packs as necessary. Monitored performance using Confio Ignite and

worked with development team and/ or networking to resolve them.

- Deployed SSIS packages and code changes and documented change management results.

- Configured the SQL Servers optimally.

- Configured and implemented high availability plans including SQL Server Clustering and SQL Server Mirroring.

- Configured and implemented disaster recovery and scalability plans.

- Configured and monitored SQL Server Transactional Replication.

- Ensured database backups completed successfully using SQL native tools and RedGate SQL Backup Pro.

- Managed security and performed periodic access reviews.

- Created and scheduled database maintenance plans including integrity checks and index rebuilds/ reorganizing.

- Performed database migrations and data refreshes.

- Performed ETL via SSIS packages and SQL scripting.

- Configured alerts and Database Mail.

SWBC, September 2003 - December 2006

Business Systems Analyst

- Gathered technical requirements for Mortgage Insurance Tracking clients and system.

- Worked closely with developers to design and enhance AS400, PC, and web-based applications.

- Acted as liaison between clients, users and staff to coordinate user requests and solve system process problems.

- Wrote ad hoc queries for quick glance reporting.

- Performed quality control of new client onboard process.

- Ensured accurate ETL mapping from client supplied data file to SWBC DB2.

- Generated reports and queries as requested by users and/ or clients.

- Established initial setup and/ or maintenance of EDI transmissions.

United States Marine Corps, September 1992 - September 1996

High Priority Expeditor

- Expedited the acquisition of outstanding aircraft parts for mission critical fighters and helicopters while stationed at

Marine Corps Air Station El Toro.

EDUCATION AND PROFESSIONAL DEVELOPMENT

Associates Degree, Hallmark College, San Antonio, TX, 2005 - 2006

Computer Network Systems Technology

PROFESSIONAL AFFILIATIONS

San Antonio League of SQL Server Administrators

HONORS AND AWARDS

SWBC Employee of The Month, August 2006

Navy/ Marine Corps Achievement Medal 1996

Contact this candidate