TECHNICAL SKILLS:
Operating Systems: Windows Server 2008/2012 /2014, 2016 Windows XP/8/10, VMware 10
Database: MS SQL Server 2017/2016/2014/2012
Languages: T-SQL, PL/SQL
Reporting/Migration Tool: SSRS (SQL Server Reporting Services), SSIS, Crystal Report,
Data Modeling: SSDD (SQL Server Database Diagram), Erwin, MS Visio
Other Tools: SharePoint 2010,LiteSpeed (backup), Idera (Performance), Redgate, Remedy Ticketing System, JIRA.
MS Office: Word, Excel, Access, Outlook and PowerPoint
PROFESSIONAL EXPERIENCE
Falcon Info Tech, New York, NY Jan 2019 – Dec 2019
SQL Server Database Administrator
• Installed, and configured SQL Servers 2014, 2016 and 2017 and migrated databases from SQL 2014 to 2017.
• Configured AlwaysOn for SQL Server 2017.
• Setup database maintenance plans to backup/restore, reorganize indexes, fragmentation, update index and statistics on databases.
• Implemented log-shipping as disaster recovery solution.
• Design and deploy SSIS Packages to export/import data from various databases and files.
• Used system monitor, extended event, SQL profiler to troubleshoot CPU/memory bottlenecks that negatively impact performance.
• Experienced using SSIS to automation of the importing, exporting and manipulation of data.
• Executed plans to fine tune stored procedure performance.
• Allocated table partitioning for a large table to optimize query execution.
• Created insert and update Trigger to monitor changes for audit purposes.
• Configured Peer-to-Peer and Transactional Replication.
• Maintained plan\view history and checked drives space.
• Assigned alert for SQL server jobs schedule, operators and troubleshoot the Job failures.
• Extensively practiced on Dynamic Management Views (DMV) in SQL Server 2017 and
Checked Database Health by using DBCC Commands and DMVS
• Investigated SQL error logs for any unexpected issues.
LEADERSHIP & VOLUNTEER
Volunteer, LaGuardia Community College, Queens, NY 03/2014/-08/2014
• Configured operating systems and software for network connectivity
• Provided end user support in various levels of technical and non-technical staff
• Supported PC hardware components, desktop operating system software, application software
EDUCATION
LaGuardia Community College, CUNY, NY Computer Networking and Administrator
Falcon Info Tech, NY SQL Server Database Administrator
Udemy Course SQL Server Database Administrator