TECHNICAL SKILLS:

• Windows server 2003, 2008, 2012R2 Active directory, Group Policy and Local security policy
• Windows SQl server 2005, 2008, 2008r2, 2012, 2014 and SQl server 2016 3 rd party Software -
• Performance Tuning: Solarwinds, Idera, redgate, Sql sentry, Brent ozar first responder kit, SP whoisactive
• Backups and recovery: IBM Tivoli, Redgate, Netbackup, Avamar, Litespeed
• Ticketing/change management tools: BMC Remedy, Jira, HEAT, Service Now, Nexus
• Performance Monitoring Tools: SCOM, EM7, Foglight, DPA, HostMonitor, Dynatrace

WORK EXPERIENCE:

System support administrator

Confidential, Raleigh, NC

Responsibilities:

• Worked as a hybrid providing Tier 3 system support and database Administration across Microsoft platforms
• Acted as point of escalation for level 2 tech support to resolve issues with windows OS
• Set up Active passive cluster node to sustain High availability
• Setup SFTP for file transfer of confidential patient data form Database to EDI system
• Setup automated batch files to delete old unwanted files which consumed space across servers
• Frequently monitored and added disk space to server as required to ensure non interruption of business process in active directory
• Configured and responsible for troubleshooting network printers across each domain
• Created, unlocked, reset user account, deleted terminated users in active directory
• Remotely assisted users troubleshoot variety of issues ranging from office 365 questions to VPN connectivity for
• Responsible for prepping installation images to meet different application use and standard
• Monitor server disk space and memory utilization across the domain for over 500 servers
• Coordinated quarterly patch management via WSUS application to mitigate server vulnerability
• Leveraged warranty with IBM by escalating issues as needed to vendor support management

Desktop Support Technician

Confidential, Daytona Beach, Florida

Responsibilities:

• Migrated over 20 physical servers to virtually hosted environment on VMware
• Migrated all user profiles across domains due to acquisition of new lines of business
• Setup, Administration and Maintenance of SQL Server Instances for new applications
• Reset users password in Active directory and for Sql server
• Diagnosed root cause of customer issues and created a knowledge base for frequently received calls - this document helped reduced time spent troubleshooting for other team members
• Performed internal audits for databases and Elevated Access for SOC Type 2 audit
• Collaborated with off shore team in India and remote team in Dallas to provide round the clock 247 support
• Reviewed server configurations including TempDB settings to ensure they met with baseline best practice in order to minimize DISK, CPU and memory issues
• Implemented Database and Active directory security to aid business meet HIPPAA compliance
• Collaborated deployments and testing with Developers in lower environment to ensure that an effective change control process is followed and codes are efficiently tested and peer reviewed
• Utilized Symantec Netbackup to backup all VM and ensure proper tape archival storage was put in place for each newly built server to meet business RPO and RTO
• Responsible for ensuring that data between primary and secondary snapshot replicated databases were in sync for business reporting purposes.
• Deployed SSIS packages, fixed connection manager strings to ensure ETL load jobs for monthly reports did not fail

Junior SQL Server Database Administrator

Confidential, Jacksonville, Florida

Responsibilities:

• First point of callDBA for all security applications running on Microsoft SQL Server
• Responsible for P1 Incident Management and Change Management
• Granted approved users required access needed to perform their job functions
• Implemented Ola hallengren’s maintenance plans for taking routing backups and index maintenance
• Worked with business to purge and archive unused data residing in tables - this resulted in reduced calls for space issues and faster queries as result set got smaller
• Utilized a combination of DBCCs and DMVs to diagnose performance issues
• Responsible for resolving locking, blocking and troubleshooting long waits on resources
• Involved in Capacity Planning and Environment Setup including Storage, Memory, I/O as per Business SLA
• Migration, Upgrade, Consolidation from SQL Server 2000 to SQL Server 2008 (Including
• Transactional Replication) in Active / Active / Passive Microsoft SQL Server Cluster

SQL Server Database Administrator

Confidential, New Jersey

Responsibilities:

• Setup, Administration and Maintenance of SQL Server Instances in Production / Non - Production Environments.
• Design and Implement Backup and Recovery for SQL Server 2005 and SQL Server 2008R2
• Maintain database for Vendors such as Allscripts
• Utilized 3 rd party tools like SQL Lite Speed to compress backup files to save Disk space
• , includes Full Backup and Point in Time Recovery
• Upgraded Windows servers from 2003 to server 2008
• Setup and configured SSIS / DTS in SQL Server 2005, SQL Server 2008r2
• Performed Disaster Recovery Tests for SQL Server Database Servers
• Performance and Tuning of SQL Server Databases using Performance