| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateCandidate's Name
MICROSOFT SQL SERVER DATABASE ADMINISTRATORSUMMARYMulti-talented Microsoft SQL Server Database Administrator with 5 years of expertise and hands on experience in managing, performance monitoring, and securing of database solutions in various environments. Hands-on experience with managing SQL Servers relational databases hosted on SQL versions of 2008/2008R2/2012/2014/2016/2017/2019 running on physical and virtual hardware platforms in a 24x7 support delivery environment. Provided dedicated support for users in production, development, and testing servers and troubleshooted a wide range of incidents and problems based on their priorities in multiple ticketing system. Motivated initiative-taker consistently meets deadlines and succeeds in high-pressure environments.SKILLSDatabase ManagementQuery Scripting/MonitoringData SecurityAlways ONDatabase AdministrationReplicationMicrosoft SQL ServerData Storage/CapacityData Restore TroubleshootingManage/Design TablesPerformance MonitoringCollaborationExtended EventTeam LeadData Log ShippingMeeting FacilitationBackups/Recovery, Management StudioScheduling Emails, Alerts, & Maintenance PlansEXPERIENCEMicrosoft SQL Server Database Administrator Premier Inc Raleigh, NC 01/2021 10/2023IT experience in Database Administration and Support of MS SQL Server 2019, 2017, 2016, 2014, and 2012 in Production, Test, Development, and Cluster Server Environments.Experience in Database Design, Performance Tuning, Optimization, Backup and Recovery in SQL Server 2017, 2016, 2014, and 2012.Experience in Disaster Recovery Planning, Execution, and Testing.Experience in using SQL Server tools like Import/Export Wizard, SQL Management Studio, SQL Server Data Tools, SQL Profiler, and SQL Query Analyzer.Experience in migration from MS SQL Server 2012 to MS SQL Server 2014, 2016, and 2017.Experience in Database Administration activities for DB Security (Creating Logins, Users, Roles, and Assigning Permissions).Experience in performing administrative tasks such as Database files management, Backup/Restore, Security management, Database Monitoring, Database Integration, and Synchronization.Extensive use of SQL Server, Performance Tuning, Index Tuning, and managing Server and Clients.Implementing High Availability using Log Shipping and Database Mirroring in SQL Server 2017.High Availability SQL Server Solution including Replication Models (Snapshots, Transactional, Merge, and Peer to Peer) and SQL Server Clustering.Junior SQL Server Database Administrator Aramark Raleigh, NC 12/2018 11/2020Installed, configured, and upgraded production SQL server instances from 2008, 2012, 2014, 2016, 2017 and 2019 in a virtual environment.Monitors database performance. Performs routine checks and updates, as necessary.Responsible for reliable back-up/recovery methodology.Performs troubleshooting of problems within databases using Execution Plan, Profiler or Activity Monitor.Perform in the successful completion of planning and advising on SQL server configuration for a new application and keeps management aware of progress and issues.Day-to-day data administration of SQL Server in a clustered environment.Ensure database is backed up with Full, Differential, and Transactional Log and can be recovered.Configure SQL Server monitoring utilities to reduce the number of false alarms.Monitoring, performance tuning, and query tuning to include index optimizations.Setup high availability as part of the disaster recovery strategy for the database.Manage maintenance plans for index reorg, index rebuild, and updating statistics.Communicate deployment status, risks, and mitigation plans.Proactively maintain database servers by monitoring and tuning.Review query plan and causes of index scans/seek using execution plans.Creating logins and granting permissions in Security.Maintenance plan using the Olahallengren.Database Administrator Cellular World Belize City, Belize 09/2015 11/2016Responds to requests for technical assistance in person, via phone, and electronically.Identifies and escalates situations requiring immediate attention.Tracks, routes problems, requests, and documents resolutions.Remains current with system information, changes, and updates.Research questions using available informational resources.Advises users on appropriate action and follows standard Service Desk procedures.Supports remote access applications and hardware.Diagnoses technical hardware and software issues.Performs root cause analysis and resolves issues.Performs workstation administration, management, setup, and configuration.Support both the workstation hardware and software. This includes Operating system installation, configuration, and upgrade.Install hardware and peripheral components like disk drives, printers, keyboards, and monitors.Troubleshoot software.Performed daily backups of client/customer information.EDUCATION & TRAININGAssociate of Arts in Computer Science 05/2015Wesley Junior College Belize City, BelizeHigh School Diploma 06/2013Sadie Vernon Technical High School Belize City, BelizeCERTIFICATIONSMicrosoft SQL Server Database AdministratorScrum MasterScrum FundamentalsREFERENCESReferences available upon request. |
