Sr. SQL Database Administrator

Gloria M Vila

Sr. Database Administrator, MCSE, MCSA

**** ********** ******

Sarasota, FL 34231

Mobile : 410-***-****

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

www.linkedin.com/in/gloria-vila-766a3ba

PROFILE – Senior SQL Database Administrator (MCSE, MCSA) with over 15 years of experience managing enterprise-level SQL Server environments, overseeing 500+ instances across versions 2005 to 2022. Demonstrated success in delivering robust IT solutions within healthcare, finance, and government industries.

Proficient in all stages of the software development life cycle, including requirements analysis, prototyping, solution design, technical architecture, testing, deployment, and ongoing support. Recognized for exceptional troubleshooting abilities, effectively resolving complex issues where others have struggled. Known for reliability, integrity, and a collaborative approach to achieving team goals. Fluent in both Spanish and English, with a commitment to excellence in every project. Outside of work, I enjoy the precision and focus of target shooting.

TECHNICAL SKILL SET

Database Management Activities:

SQL Server (versions: 2005, 2008, 2012, 2014, 2016, 2019, 2022)

SQL Server Mirroring, Log Shipping, Always On & Snapshot Replication

MYSQL

Database Management

Database Software Install, Build, Deployment, Migration

Database configuration & Administration, Internal parameter configurations

Best Practices Implementation

Database moves (Host to Host), Refreshes

Installation of patches & Database server upgrades

Authentication of users/clients/servers

Respond to availability (e.g., DB up/down) events

Set up Performance thresholds, maintenance jobs, alerts and emailing of alerts

Monitoring & Performance Tuning

DB Performance Monitor/Tuning reports & Administer 3rd Party DBA Tools

Backup monitoring & Log monitoring (Alert log/ Transaction log/Trace file)

Database Maintenance / Housekeeping

Backup/recovery configurations

Consistency Checking (DBCC),

Index Fragmentation management

Security Login Cleanup and Standardization

AD logins create and maintenance

Replication

(SQL SERVER) Mirroring, Log Shipping, Always ON, Snapshot Replication

Set up Log Shipping and Always On between instances of SQL server

Detail Setup Documentation

Data Analysis

Data Manipulation, Analysis & Presentation

Expert skills for presenting data in charts, graphs, tables, designing and developing relational databases for collecting data and presenting conclusions

Expert writing DDL, DML SQL commands

Project Management & Lead

Project Lead:

Project to Lead and implemented MS SQL Server with log shipping & Always On techniques

Successfully responsible for managing a project converting a 10 yr. Old income & reconciliation system in the WANG to a newly designed & developed system in the IBM mainframe. Backward re-engineered the implementation of this system upgrade, re-developing existing system specifications, standards, data dictionary, & re-designing the DB2 Database, its tables & relationships.

Business Systems:

Healthcare: Nextgen, Siemens’ Radiology Syngo Workflow (VB10, V32, V31 & V30B, Novius 27.1 & 26.2), Billing, Interfaces & HL7.

Insurance: Small Commercial Policy Writing Systems, Large Policies Reporting System, Claims Data Warehouse, Surety/Bond, Agency Upload for Personal Lines

Financial: Puerto Rico’s Dept. of Treasury Income Reconciliation System, Financial Contribution Margin Reporting, Investment Allocations, Personalized Benefit Reporting, M&D General Ledger & Accounts Payable, Financial Data Warehouse, T Rowe Price’s Participant Accounting System (Retirement Plan Administration)

Other: Disaster Recovery, Data Processing Chargeback / Time Reporting & Labor Reporting, WANG to IBM Conversions, Document Management

OS:

Windows Server, Linux, Unix, VMWare, Sun Solaris, IBM Mainframe OS 390, MVS/XA, DOS

Software:

SQL Server T-SQL, SQL for DB2, SharePoint 2013, Shell Scripting, Database access methods (ODBC & DB-Lib), Communication protocols (TCP/IP & SOCKETS), HL7, Crystal Reports, familiar with Shell scripting, CRON job creation, Perl & Perl/TK, ColdFusion, PHP, HTML, XHTML, JavaScript, Cascading Style Sheets, COBOL II, VS COBOL, COBOL/DB2, JCL.

Hardware:

VM, N-Tier architecture, SUN Solaris Servers, Linux Red Hat, IBM Mainframes OS/390

Tools:

Vcenter, Connectwise Manage & Automate, Kaseya, Salesforce, Solarwinds Database Performance Analyzer, SQL Server Management Studio, SQL Profiler, SSRS, PowerShell, Visual Studio,, DB Artisan, SQLDBX, SYBASE Central, SQL Advantage, BCP, FTP, ACCESS, EXCEL, AMS Utilities, BMC & Platinum Utilities For DB2, Catalog Management For DB2, CLIST, Data-Expert, DFSORT & PFSORT, Exceed, File-Aid, Dreamweaver MX, MKS Toolkit, MS Project, OS JCL, PFSORT, RAPID SQL, Securecrt, Securefx, TSO / ISPF, VSAM

PROFESSIONAL EXPERIENCE

SQL Database Administrator – NextGen Engineer

Norwin Technologies – Client: Panorama Eye Care & Red8, Remote (3 months contract) 11-2024 – Present

Oversee and manage NextGen EMR databases along with other SQL-based systems on a virtual cloud environment.

Optimized database performance through recommendations, tuning, troubleshooting, and robust backup and recovery strategies

Partnered with cross-functional teams to facilitate NextGen customizations, integrations, and enhancements. Updated the 2025 CPT4 codes, and Surescripts formulary.

Conducted regular maintenance tasks, including system upgrades, migrations, and patching, to ensure seamless database operations

Implemented Log Shipping to maintained high data availability, integrity, and security by implementing best practices and proactive monitoring

Addressed organizational reporting needs by designing and managing queries, reports, and data extracts

Created the SQL scripts, PowerShell job, and schedule tasks to SFTP a daily, and biweekly update files to Press Ganey.

Collaborated with stakeholders to understand and implement data and reporting requirements effectively

Sr. Database Administrator

DAS Health, Remote 7-2018 – 7-2024

Sr. SQL Database Administrator with over 15 years of experience in the administration of SQL Database environments, migration, upgrading, MSSQL Server (version 2008 - 2022) and sizing of SQL databases and servers in a private cloud environment, and using VMWARE.

6 years of experience with managing enterprise-level database environments supporting complex/critical applications in the cloud

Successfully supported 100+ clients by managing 500+ SQL Servers and optimizing database performance for databases up to 7TB. Most of them Nextgen clients

4 years' experience building Virtual Microsoft Servers. I not only stood up databases I even created the actual VM (windows server) and installed and configured the SQL server

Experience with upgrading SQL Servers in-place and side-by-side to other versions. Performed SQL server software upgrades from older versions of SQL to 2016, 2019, 2022. Implemented service packs including testing and evaluation of patching strategies

Performed technical troubleshooting to diagnose, isolate and correct data and database issues. I have expertly troubleshooted many issues regarding performance, High CPU, deadlocks, blocks, and long running transactions. When the CPU was very high, I was able to identify the query causing it and fixed the issue by running update statistics on the table(s) that required it where the stats were stale.

Identified high-load SQL statements, gather performance-related data

Resolved performance issues using SQL Profiler by analyzing the SQL Trace

I have set up log shipping for multiple clients and HA (Always On) for our largest clients. We also had 'reporting' databases for the clients which were copies of the production database. I set up the maintenance plans to back up to remote share, restore and then perform maintenance on the database or add logins and permissions

Refreshed databases in lower environments with a copy of Production to facilitate testing and development

Extensive experience migrating clients’ database servers to the cloud

Optimized database performance, security, and user access in SQL Server. Established security roles and database access rights and controls and created and maintained logins in AD

Resolved connectivity issues

1 years MySQL Server experience

Created SQL jobs or stored procs necessary for application

Provided technical and functional support 24x7 and on-call rotation

Experienced with Connectwise Manage and Automate, Kaseya, VCenter, Salesforce, Solarwinds DPA, some Visual Studio, SSRS & SSIS

Sr. Database Administrator III

Owensboro Health Systems, Owensboro, KY & Remote 1/2016 – 7/2018

I was responsible for administering, implementing, and supporting over 145 enterprise-wide MS SQL Server instances for Owensboro Health. My duties included performing installations, upgrades, patch management, and configuring databases for all clinical and business applications. I leveraged teamwork, analytical skills, and a deep understanding of clinical and operational processes to ensure a highly efficient and available information systems environment.

Created inventory & Supported and Maintained over 145 SQL Servers/Instances (versions: 2005, 2008, 2012, 2014, 2016)

Evaluated the selection of a SQL Server performance and monitoring tools, presented my recommendations and the tool was selected based on our needs, my analysis and recommendations

Monitored, administered and tuned all SQL Server databases ensuring application performance is optimal at all times.

Troubleshooted memory, log space, CPU issues with SQL Server instances

Installed new versions of DBMS and applied patches to assigned database systems and software tools as required by product roadmap/lifecycle and support requirements.

Implemented Maintenance Plans on over 140 SQL Server Instances & troubleshooted all database infrastructure issues including database backups, disaster recovery and business continuity solutions

Defined and forecasted database license, server hardware, and database storage infrastructure needs for new projects.

Developing database security policies and standards in compliance with organizational data access policies and standards

Developing and maintaining database best practices and a roadmap in relation to database and application lifecycle, business growth, technology improvements

Mentored and educated other team members on database fundamentals, techniques, and best practices

Branch Chief - U.S. Coast Guard Auxiliary (National C Directorate)

Flotilla 84, 7 Division 2016 – 2018

As Branch Chief Database Administrator at the national level, I was responsible for supporting and troubleshooting MySQL databases. Shortly after joining as a volunteer for the U.S. Coast Guard Auxiliary, I identified a significant intrusion on the MySQL server. In recognition of my contributions, I received the U.S. Coast Guard Meritorious Team Commendation. Additionally, I completed training and earned certification in the Operations Auxiliarist Program (AUXOP), enhancing my knowledge and skills to better support Coast Guard missions.

Sr. Database Administrator – Consultant

Median Health – Consulting Assignment: Owensboro Health Systems 7/2015 – 12/2015

•Support and Maintenance of SQL Servers (2005, 2008, 2012)

•Troubleshoot memory, log space, CPU issues with SQL Server instances

•Working on providing Best Practices recommendations related to SQL Server implementation, maintenance, support, security & alerts

•Ensuring inventory of all database servers is up to date

•Ensuring AD Group is being used for Windows Authentication and making sure DBA AD group is added as a login to all SQL Server instances

•Evaluating SQL Server performance and monitoring tools

•Assisting application support staff with database/SQL changes and production implementation

SSRS Report Developer - Consultant

Robert Half Technology – Short Term Consulting Assignment: Suncoast Credit Union, Tampa, FL 5/2015 – 7/2015

•Creating multiple reports using SSRS (Report Builder, SQL Server Management Studio) remotely and under minimal supervision.

CONSULTING ASSIGNMENTS

CONSULTING FIRM

CLIENT/HOSPITAL

YEAR

Avid (Sub-contracting for Siemens)

El Camino Hospital, Mountain View, CA

2014 – 2/2015

Leidos Health

Lifespan, Information Services, Providence, RI

Partners Health, Boston, MA

University Mississippi Medical Center, Jackson, MS

2013 – 2014

Health IT Services (HIT)

North Shore-Long Island Jewish Health System, Lake Success, NY

2013 – 2013

TEKsystems Group

Mountain State Health Alliance, Johnson City, TN

2012 – 2013

The Stowe Group

North Shore-Long Island Jewish Health System, Lake Success, NY

2011 – 2012

Sr. RIS Implementation Consultant – SIEMENS RIS (NOVIUS & SYNGO) / Sr. Database Administrator (Sybase & SQL Server)

SQL SERVER 2008 & 2012:

•Created data models (physical & logical) for the Radiology department metrics & performance indicators

•Performed the Data Migration & Data Conversion setting up requirements and performing conversion/migration.

•Performed multiple data imports, cleaning, transforming, data conversions, validating, modeling data for decision making

•Created multiple reports using SSRS

•Created data extraction, cleansing via automated processes & created thresholds for alerts, and maintenance tasks

SYBASE SERVER 15.0:

•Created complex Sybase T-SQL & Stored Procedure Scripting used in data for modality department analysis

•Performed complex extract of data using TSQL from the radiology & voice recognition systems for data needed to support migration to EPIC

•Expert skills for presenting data in charts, graphs, tables, designing and developing relational databases for collecting data and presenting conclusions

•Expert writing DDL, DML SQL commands

•Expert improving data quality & detail testing with other systems to avoid further troubleshooting

SIEMENS RADIOLOGY INFORMATION SYSTEMS (RIS):

Identified over 1800 missing radiology charges & re-created the charge file for IDX to process.

Assisted client with SQL for their billing analysis & troubleshooting

Created a consolidation of the ‘reconciliation’ files that are used to compare against what is sent to IDX, combining 15 different documents into 1 document. Compared their logic and parameters side by side and compared them against the logic and parameters of the IDX file. Prepared a chart to indicate which depts. to exclude or include for the corresponding hospitals/services for parameter set up.

Provided solutions to issues with in-house built daily processes such as billing transaction & study consolidation (DTARs), reviewing, fixing & documented this multi system process between Syngo, Sybase, FTP process, Access, Visual Basic, & ORACLE based database warehouse

Provided knowledge of technical & professional billing in a hospital setting, CPT codes, modifiers & ICD9 diagnosis codes

Made corrections to various Mammo letters

Updated the charge master adding numerous new codes, and updated various other tables

Troubleshooted & documented Mountain States' Billing process & resend of log file & results to Mountain State Empire

Sr. Sybase Database Administrator \ Sr. RIS Clinical Analyst

Johns Hopkins Hospital, Dept. of Radiology, Baltimore, MD 2005 – 2011

SQL SERVER

Lead and implemented MS SQL Server 2005 & 2008 instances

Developed requirements, design, standards, & documentation

Designed logical and physical designs for SQL Server databases. Experienced with data modeling (physical & logical)

Created database, tables, relations, automated processes, thresholds for alerts, and maintenance tasks

Implemented mirroring & log shipping techniques for research database

Performed the Data Migration & Data Conversion setting up requirements and performing conversion/migration.

SYBASE SERVER

Successfully perform & implement Sybase ASE 12.5.4, configuration, security, monitoring, backups, large scale performance tuning, & best practices.

Lead the support of Sybase ASE 12.5.4.

Experienced with shell script coding

Execute & monitor Database & Application Disaster Recovery.

Develop TSQL, code, stored procedures, triggers, & views. Created complex Sybase T-SQL & Stored Procedure Scripting used in data mining for department metrics & dashboards. Performed complex extract of data using TSQL from the radiology & voice recognition systems for individuals doing medical research or for the managers of all modalities. Performed multiple data imports, cleaning, transforming, data conversions, validating, modeling data for decision making. Expert skills for presenting data in charts, graphs, tables, designing and developing relational databases for collecting data and presenting conclusions

Expert writing DDL, DML SQL commands. Expert improving data quality

Reduced backup times and implemented Sybase compressed dumps & stripping. Performed detail testing with other systems to avoid further troubleshooting

SYBASE REPLICATION

Lead & oversaw Sybase Replication Server (12.6) including installation, configuration, troubleshooting, & failover.

Implemented and maintained Sybase replication in various environments, and Troubleshooted/resolved all issues

SIEMENS RADIOLOGY INFORMATION SYSTEMS (RIS)

Provided expert support of Siemens Syngo V27.1 & Syngo Workflow V30B implementation creating user-defined reports (UDR), Alerts, Interactive Documents, Mammo letters, performing patient merges and testing

Sr. Sybase Database Administrator

Snell Enterprises, Inc., Columbia, MD 2005 – 2005

SYBASE SERVER & HIGH AVAILABILITY

Lead the successful implementation, & configuration of Sybase ASE12.5.4. For the Department of Defense

Implemented security, monitoring, backups, performance tuning, & best practices.

Monitored & maintained Sybase Replication Server (12.6, 12.1) including installation, configuration, troubleshooting, & failover. Coded & documented all housekeeping scripts & CRONJOBS as modular, portable, & easy to maintain.

Installed & configured Sybase’s High Availability environment providing near continuous database access during transient database failures for local recovery.

Developed UNIX servers, Sybase ASE, & Replication servers & device requirements.

Created a concise & valuable Database Administration Services “Cookbook”.

Devised a Sybase Infrastructure design, standards, & documentation.

Set up bi-directional replication for Disaster Recovery on a remote site and performed Database & Application Disaster Recovery tasks.

ADDITION PROFESSIONAL EXPERIENCE:

Sr. Sybase Database Administrator

The St. Paul Travelers Insurance, Hunt Valley, MD

Sr. Technical Consultant, Professional Services

Compuware Corporation, Baltimore, MD

Project Lead, Sr. Database Administrator & Sr. Analyst

GM Group, San Juan, PR - Client: The Departmento de Hacienda, San Juan, PR

Manager Consultant

Ernst & Young, LLP, San Juan, PR

Sr. Programmer Analyst III

USF&G Insurance, Baltimore, MD

Team Leader, Sr. Technical Consultant, Sr. Programmer Analyst

Compuware Corporation, Baltimore, MD

Programmer Analyst III

Alexander & Alexander Insurance, Baltimore, MD

Programmer Analyst II

T. Rowe Price Investments, Baltimore, MD

EDUCATION

Boston University, (Began Master Level Classes on Database Administration & BI)

College of Notre Dame of Maryland, Baltimore, MD - B.A. Management/CIS

Universitá Per Stranieri, Perugia, Italy - Intermediate Italian Summer class

Georgetown University, Washington, DC - Business Mgmt. & English Summer classes

HONORS, AWARDS

US Coast Guard Meritorious Team Commendation

2016

USF&G Insurance - Key Contributor Award

1996

USF&G Insurance - R.A.V.E. Award (Recognize A Valued Employee)

1996

Mayor William D. Schaeffer, City of Baltimore - Citizen Citation

1986

TECHNICAL & PROFESSIONAL COURSES

MCSE: SQL Server 2012-214 Certification for Business Intelligence

2016

Implementing Data Models and Reports with Microsoft® SQL Server®

Designing Business Intelligence Solutions with Microsoft® SQL Server® 2012

MCSA: SQL Server 2012-2014 (certified)

2016

Querying Microsoft SQL Server

Administering Microsoft SQL Server Databases

Implementing a Data Warehouse with Microsoft SQL Server

Digital Forensics (Grade: A)

2010

PHP, HTML, JavaScript, Cascading Style Sheets, MySQL (Grade: A)

2010

Database Administration for Business (Grade: A)

2010

Project Management (Grade: A)

2010

Crystal Reports

2008

MS SQL Server Administration

2007

ColdFusion & Dreamweaver (Basic & Intermediate)

2006

Sybase Fast Track to ASE: 12.0 & powering up with ASE 12.5

2001

Sybase System & Database Administration 12.5

2001

Consulting for the Advanced Practitioner, Ernst & Young, LLP

1997

SPEAKING ENGAGEMENTS

Guest Speaker: “Year 2000 Compliance”, PRAICO Insurance & Chapter of Property & Casualty Underwriters of Puerto Rico

1998

Guest Speaker: “Year 2000: Compliance in the Corporate/Government Agency Computing Environment.”, Information Security/Emergency Management Association of Puerto Rico

1997

Contact this candidate