Banner Image

All Services

Administrative & Secretarial

SQL Server Database Administrator

$30/hr Starting at $120K

• Enhanced database performance implemented recovery procedures and achieved 99.9% uptime on all SQL Servers. • Increased efficiency 25% by providing optimum database performance with efficient backup and restore processes. • Saved $250K annually in licensing, hardware, and lower tech support calls, by migrating from standalone NT servers to VMware. • Interacts with clients, application team and project managers to design, implement and support solutions to meet client needs. • Strong Experience with SQL Server 2000 through 2017 Administration standalone and cluster environment • Windows and SQL patching of servers with the latest Service packs available. • Provide DBA support and technical expertise for multiple applications in development, test and production - SQL Server 2005, 2008, and 2012, 2014, 2016 and 2017 environments. • Performed Database Migration from an On-Premises SQL environment to Azure Database in the cloud. • Experience in supporting Very Large databases (VLDB) 500GB – 2TB and troubleshooting the problems. • Expertise in Always-On Availability Groups (AAG) and HA/DR Troubleshooting • An excellent team player with a very positive can; do attitude. • Configured and supported replication (Snapshot/Transactional/Merge) and log shipping in both SQL 2008 and 2012, 2014 and 2016 Servers. • Performance Tuning, Performance Baselining and Query Optimization • SQL Server Performance Dashboard Reports for Monitoring • High Availability Solution- Clustering, AlwaysOn, Database Mirroring and Log Shipping • Building of Window Server Clusters • Query Store, Import/Export Wizard, SSMS, SQL Profiler, Extended Events

About

$30/hr Ongoing

Download Resume

• Enhanced database performance implemented recovery procedures and achieved 99.9% uptime on all SQL Servers. • Increased efficiency 25% by providing optimum database performance with efficient backup and restore processes. • Saved $250K annually in licensing, hardware, and lower tech support calls, by migrating from standalone NT servers to VMware. • Interacts with clients, application team and project managers to design, implement and support solutions to meet client needs. • Strong Experience with SQL Server 2000 through 2017 Administration standalone and cluster environment • Windows and SQL patching of servers with the latest Service packs available. • Provide DBA support and technical expertise for multiple applications in development, test and production - SQL Server 2005, 2008, and 2012, 2014, 2016 and 2017 environments. • Performed Database Migration from an On-Premises SQL environment to Azure Database in the cloud. • Experience in supporting Very Large databases (VLDB) 500GB – 2TB and troubleshooting the problems. • Expertise in Always-On Availability Groups (AAG) and HA/DR Troubleshooting • An excellent team player with a very positive can; do attitude. • Configured and supported replication (Snapshot/Transactional/Merge) and log shipping in both SQL 2008 and 2012, 2014 and 2016 Servers. • Performance Tuning, Performance Baselining and Query Optimization • SQL Server Performance Dashboard Reports for Monitoring • High Availability Solution- Clustering, AlwaysOn, Database Mirroring and Log Shipping • Building of Window Server Clusters • Query Store, Import/Export Wizard, SSMS, SQL Profiler, Extended Events

Skills & Expertise

Administrative AssistantApp DevelopmentDatabase AdministrationDatabase DevelopmentReportsServer AdministrationSoftware TestingSQLTroubleshooting

0 Reviews

This Freelancer has not received any feedback.