Sisay Abraham

Phone: 571-***-****

Email:adhw3t@r.postjobfree.com

TARGET JOB TITLE:

SQL Server Database administrator

PROFESSIONAL SUMMARY

• 6+ years of professional experience in Administering MS SQL Servers 2019, 2017, 2016, 2014, 2012, 2008 & 2005 Production/ Development environments and Database Reporting.

• Skilled in conceptual, logical and physical design using ERD and Erwin data modeler.

• Expert in MS SQL Server Installation, Configuration, Upgrading of Microsoft® SQL Server™ 2008, 2012, 2014, 2016 and 2017.

• Proficient in T-SQL Programming in writing Stored Procedures, Ad-hock queries, Functions, Views and Triggers.

• Secured SQL servers, databases and objects by Creating User Logins with appropriate roles, monitoring the user accounts, creation of groups, passwords and TDE encryptions.

• Executed backup and recovery, and automating maintenance tasks using SQL job agent and task scheduler.

• Have implemented several disaster recovery and High Availability technologies like Replication, Log shipping, Mirroring, Failover Clustering and AlwaysOn High Availability Groups.

• Expert in MS SQL Server Performance Tuning, Activity Monitor, SQL profiler, Query Optimization, monitoring error logs, Client/Server Connectivity and running Database Consistency Checks Using DBCC.

• Experience working on ETL projects using SQL Server Integration Services (SSIS) and migration of user databases, user logins, maintenance plan, jobs, packages, and database objects between multiple SQL Servers, and other OLEDB and ODBC sources like MS Access.

• Deployed database to Azure SQL using both DMA and Export Data-tier Application wizards.

• Experience in Data Migration between SQL Server from 2008R2/2012 to 2016/2017 and Migration of Data from Excel, Flat file, Oracle to MS SQL Server by using BCP and SSIS.

• Skilled with third party tools including Idera SQL DM, Spotlight.

• Expert in creating Packages, Jobs and Sending Alerts using SQL Mail/Database Mail.

• Excellent interpersonal, analytical and quick in learning new technologies.

• Ensuring SQL server security by creating user logins, assigning roles and least-privilege permissions, certificate based security authentication, as well as strict monitoring of server and database level object changes through regular audits.

• Creating reports using visual studio and deploying it to SSRS.

• Excellent interpersonal communication; analytical and leadership skills; highly proactive.

• Working some administration tasks as SharePoint 2010/2013/2016 Administrator.

• Created Azure resources and deployed VMs to Azure Cloud environments.

• Environment: Windows Server 2016, 2012/R2, 2008/R2, 2003; SAN; SQL Safe, LiteSpeed, SQLDM, TFS, SCOM, Visual Studio 2013, CMD, SQLCMD, PowerShell-ISE. Sisay Abraham

Phone: 571-***-****

Email:adhw3t@r.postjobfree.com

TECHNICAL SKILLS

Relational DBMSs:

SQL Server 2017/2016/2014/2012, MS Access

BI Tools: SSIS, SSRS, SSAS, and SSMS, Power BI, SharePoint, MS Excel ETL Tools: SQL Server Integration Service (SSIS)

Languages: T-SQL, Java, and HTML

Reporting Tools: SQL Server Reporting Service (SSRS), Power BI, and MS Excel Office Tools: MS WORD, MS EXCEL, and MS Power Point. Other Tools: Outlook and Adobe Photoshop

Operating Systems: Windows Server 2016, 2012 R2/2012,VMware EDUCATION& PROFESSIONAL CERTIFICATION

• Bachelor’s Degree: In Management Information Systems (MIS).

• Microsoft Certifications:

MCSA Administering Microsoft SQL Server 2012/2014 Databases, and

Certification on Azure Fundamentals.

PROFESSIONAL EXPERIENCE

1. Landmark Health - (October 2018 – September 2020) Sr. SQL Server DBA

Responsibilities

• Installed and configured MS SQL Server 2019, 2017, 2016, 2014, 2012, 2008R2 and 2008 instances consistently following agreed-upon organizational standards.

• Developed, modified, and optimized complex stored procedures, triggers to handle complex business rules, history data and audit analysis.

• Created Azure resources and deployed VMs to Azure Cloud environments.

• Extensively analyzed and tested database objects and T-SQL statements before deployment to the production server.

• Maintained a log of any changes made to servers, including documentation of any issues identified and corrected.

• Administered the MS SQL Server security by enforcing security policy, creating User Logins with appropriate roles, monitoring the user accounts, creation of groups, granting the privileges to users and groups.

• Scheduled full and transactional log backups for the user and system databases in the production environment.

• Worked on all Recovery Models and performed Database Recovery based on Recovery Point Objective

(RPO) and Recovery Time Objective (RTO).

• Ensured Disaster Recovery and High Availability using Log-Shipping, Replication, SQL Server Clustering and AlwaysOn.

• Installed and configured SSRS and created reports locally and deployed to a server.

• Moved data from flat file, Excel, Oracle, My SQL, MS Access, OLE DB Sources to SQL Server.

• Upgraded databases from SQL Server 2012/2014 to 2016/2017. Sisay Abraham

Phone: 571-***-****

Email:adhw3t@r.postjobfree.com

• Patched SQL Server 2012, 2014, 2016 and 2017.

• Scheduled jobs to automate different activities such monitoring database health, disk space, job alert, index monitoring, stats monitoring and backup verification.

• Monitored Server activity, error logs, space usage, and solved problems as requested.

• Executed different maintenance plans such as backups, index management, cleaning backup history and purging old files.

• Created Alerts and Notifications for system errors, insufficient resources, fatal database and hardware errors and task assignment.

• Installed and configured Failover Clustering and AlwaysOn Availability Group on mission critical servers.

• Ran each separate SQL Services under a different Windows Domain Account by assigning the bare minimum rights and permissions as needed.

• Automated SQL Server database restoration using bacpac with PowerShell.

• Provided a 24X7 Production support for the database and application issue. Environment

SQL Server Management Studio, SSIS, SSRS, SSAS, SQL Server Configuration Tools, Microsoft Excel, Database Engine Tuning Advisor, Performance Monitor, SQL Profile, Microsoft Visual Studio, Outlook 2003/2007, DBCC, DMV, and Data Collector. 2. IndraSoft – (January 2016 – October 2018)

Sr. SQL Server DBA

Responsibilities

• Created T-SQL scripts, stored procedures, tables, views, functions, triggers and indexes.

• Ensured disaster recovery and high availability for production and non-production environments

• Executed large scale database migrations from SQL server 2012 to SQL server 2016.

• Created automation of day-to-day operations, critical SQL server alerts and repetitive tasks.

• Monitored the health and performance of SQL OS, server instances and applications using SQL Server Profiler, Extended Events and other third-party tools.

• Setup Database Mirroring, Log Shipping and SQL Clustering between various environments.

• Used PowerShell to execute batch files and other scripted tasks.

• Installed and configured MS SQL Server 2016, 2014 on Windows Server 2012 and 2016 in both Standalone and Failover Clustered SQL Servers and applied service packs and security fixes.

• Executed database and log backups and restoration; planned backup strategies and scheduled related tasks.

• Optimized Indexes by reorganizing/rebuilding them when necessary for better performance.

• Verified backups and error logs on the servers and troubleshot failures or alert problems, and open tickets if necessary to work with technicians from other departments.

• Secured SQL Server through provisioning the bare minimum permissions and roles to execute jobs.

• Implemented SQL Logins, Roles and Authentication Modes as part of Security Policies for various categories of User Support.

• Monitored competing resources on Azure cloud databases. Sisay Abraham

Phone: 571-***-****

Email:adhw3t@r.postjobfree.com

• Planned new job process, new database maintenance plans, DTS programs and Performance Tuning.

• Proactively monitored SQL Server Maintenance Jobs, troubleshot failed jobs, resolved client connectivity issues and error logs in a timely manner.

• Provided a 24X7 technical support.

Environment

Microsoft SQL Server 2012/2014/2016, Management Studio, Database Engine Tuning Advisor(DTA), Perfmon, SQL Profiler, Microsoft Outlook 2003/2007, DBCC, DMV, Windows Server 2016, 2012 R2, 2012, 2008R2 Enterprise edition, MS SQL Server 2012, 2008R2, SQL Server Data Tools, Visual studio.

3. Allscripts Healthcare Solutions (August 2014 - January 2016) Jr. SQL Server DBA

Responsibilities

• Installed, configured, and monitored MS SQL Server 2014/ 2012/2008R2 versions.

• Collaborated with BI teams in the full development of life cycle of SQL Server 2012/14 and 2008R2 enterprise data warehouse and report servers.

• Monitored and troubleshot performance issues and optimized T-SQL queries, stored procedures and functions.

• Performed various data migration tasks for mission critical databases.

• Refined and automated regular processes, track issues and document changes.

• Monitored and tuned aspects of SQL Server infrastructure like Disk, CPU, Memory and SQL Code by using Perfmon, Profiler, Dynamic Management Views and Dynamic Management Function.

• Deployed backup and recovery strategies for SQL Server databases to meet SLA requirements.

• Monitored the complete server environment for resource utilization in order to avoid any bottlenecks in a proactive manner.

• Enhanced security control by creating user defined server roles in SQL Server 2008R2/12/14.

• Created jobs for database maintenance index fragmentation, index rebuild and database statistics.

• Checked the physical and logical consistency of the files, filegroups and databases using DBCC commands.

• Created new alerts, notifications and database mail on SQL Server Instances.

• Created and managed schema objects such as tables, views, indexes, procedures, and triggers whilst maintaining their referential integrity.

• Worked as team player in resolving issues and in preparing documentation.

• Provided a 24/7 technical support in troubleshooting and diagnosing database performance related issues. Environment

Microsoft SQL Server 2014/2012/2008R2/2008, Management Studio, BIDS, Perfmon, Performance Monitor, SQL Profiles, DBCC and DMV.

Contact this candidate