Database Administrator Sql Server
Resume:
DANNI LIAO
*********@*****.***
Riverside, CT 06878
SUMMARY
A capable SQL Server DBA with diverse technical background and professional experience for both on-premise and Azure Cloud, processing good communication and collaborative skills to work with both IT and Business Communities at all levels of an organization.
PROFESSIONAL EXPERIENCE
WEX INC. --- Simsbury, Connecticut 2016 – 2024
Database Administrator
Provided production and development DBA support for over 100 SQL servers (SQL 2019 in Azure).
Developed, deployed, and supported SSRS and SSAS reports.
Supported monthly production release to ensure the changes to the database are made in controlled, reliable and efficient manner.
Installed, configured and maintained SQL Servers.
Used PowerShell scripts to monitor SQL server health and performance.
Worked on Replication, High availability, Discovery Recovery, Log shipping, DB Backup Restore etc.
Assisted developers in troubleshooting SQL statements.
Utilized version control tools including Azure Devops, Sourcesafe.
EvolutionBenefits --- Avon, Connecticut 2008 – 2016
Database Administrator
Created and maintained database schema, views and stored procedures.
Supported ETL system (SSIS) for near real time extraction of customer and transactional data from our debit card processor into SaaS application.
Managed database security/integrity and backup procedure following industry best practice.
Successfully upgraded multiple SQL servers (SQL 2005, 2008, 2014).
Subway World Headquarters --- Milford, Connecticut 2004 – 2007
Database Analyst
Designed, documented, implemented, and administered enterprise SQL databases.
Built Data Transformation Services (DTS) packages and performed data conversions across multiple sources.
Created and scheduled batch jobs to manage workflows.
Wrote and optimized SQL statements, cursors, stored procedures, triggers, views, and user-defined functions.
Administered database security, access control, and configuration and performed backup/restore, replication, and routine maintenance tasks.
Troubleshot functional and performance issues across existing database objects.
EDUCATION
Bachelor of Computer Science, Southern Connecticut State University
Contact this candidate