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
Database Administrator 2016-present
Work as a production and development support DBA, providing support for more than 100 servers (SQL 2019 in Azure(AWS), 2016)
Support monthly production release to ensure the changes to the database are made in controlled, reliable and efficient manner
Install and configure SQL Servers
Manage database security/integrity and backup procedure based on best practice
Use PowerShell scripts to monitor SQL server health and status
Experience in SQL Server tuning techniques to optimize the SQL queries and stored procedures.
Experience on Replication, Always On, Log shipping, DB Backup Restore etc.
Experience with version control tools (Azure Devops)
EvolutionBenefits, Avon, CT 2008 – 2016
Database Administrator
Support ETL system (SSIS) for the near real time extract of customer and transactional data from our debit card processor into SaaS application.
Develop, deploy and support SSRS and SSAS reports
Involved in multiple upgrading for SQL server (SQL 2014, SQL2008 and SQL2005)
Subway World Headquarters, Milford, CT 2004 – 2007
Database Analyst
Designed, documented, implemented, and administered company’s SQL databases
Work on Data Transformation Services (DTS) package and data conversion from various databases and files.
Create and manage the scheduling of batch jobs.
Plan and implement various Transact-SQL statements, cursors, stored procedures, triggers, views, and user-defined functions.
Administer existing databases by managing permissions, user accounts, backup/restore, replication, and database configuration management.
Troubleshoot functional and performance issues with existing database objects. Support Application Developers regarding database related questions.
EDUCATION
Bachelor of Computer Science, Southern Connecticut State University
Contact this candidate