Sql Server Manager
Resume:
Mike Gabriel
************@*****.***
Silver Spring, MD
Page 1
DBA
OBJECTIVE
I am an enthusiastic, self - motivated and proactive Database Administrator looking for MS SQL server Database Administrator (DBA) role in the US. I have a proven track record on installation and configuration of different versions and editions of SQL Server for security and performance optimization. I have solid experience monitoring and troubleshooting SQL Server connectivity and performance issues while ensuring SQL Server Databases to be highly available by setting up different HA solutions such as Replication, Log shipping, Mirroring, Windows Failover Clustering and AlwaysOn Availability Groups. SUMMARY
Microsoft Certified Professional (MCP) in Administrating Microsoft SQL Server 2012/2014 Databases.
5+ years of experience in Ms SQL Server Database Administration, Design, and Support of MS SQL Server 2016/2014/2012/2008R2/2008/2005 in Production, Development, and Testing environments.
Highly experienced in installation, upgrade and configuration of MS SQL Servers and databases.
5+ years of experience planning and implementing SQL Server Security and database permissions.
Extensive skill in Database Backup, Recovery and Disaster Recovery procedures.
Experience creating and managing schema objects such as tables, views, clusters, indexes, stored procedures, triggers and functions.
Performance Tuning, Query Optimization, Client/ Server Connectivity, Data Transformation Services and running Database Consistency Checks Using DBCC commands
Good knowledge of Disk space management for performance optimization using RAID and SAN technologies.
Extensively used SQL Server Agent to create Jobs and Alert, creating Packages, jobs and Sending Alerts using SQL Mail and DB Mail.
Configuring Reporting service, developing and publishing reports using SQL Business Intelligence Development Studio (SSRS).
Migration of Data from Excel, Access, Flat file, Oracle to MS SQL Server by using BCP, SSIS and DTS utility
Involved in the analysis of specifications for ETL Process using DTS Import/Export Data, Bulk Insert, BCP, and DTS Packages (SSIS).
Implementing SQL server (HA) high availability solutions such as Replication, Mirroring, Log shipping and Failover Clustering (WFC) and AlwaysOn as well as carefully scheduled maintenance to minimize downtime.
Demonstrated ability in successfully handling and implementing different team projects such as migration.
Very good communication, analytical and inter personal skills and ability to learn new concepts and technology.
CERTIFICATION
Microsoft Certified Professional in Administrating Microsoft SQL Server Databases. MS ID: MS0618470188
Microsoft Certification ID: 16891756
Mike Gabriel
************@*****.***
Silver Spring, MD
Page 2
DBA
EDUCATION
Bachelor Degree, Addis Ababa University, Ethiopia, 2006 TECHNICAL SKILLS:
RDBMS: MS-SQL Server 2005/2008/2008R2/2012/2014/2016, MS Access 2007/2010
Configuration Tools: SQL Server Surface Area Configuration, Reporting Services Configuration, SQL Server Configuration Manager, Microsoft Database Upgrade Advisor
Development Environment: SQL Server Management Studio, Enterprise Manager, Query Analyzer, Export / Import (DTS), SSIS
Performance Tool: Database Engine Tuning Advisor, Profiler, Extended Events, Performance Monitor
Server Operating Systems: Windows Server 2008 R2/ 2012R2
Third party Tools: Idera, RedGate, Sentry One
PROFESSIONAL EXPERIENCE:
COMCAST, MD
MS SQL Server Database Administrator Sept 2016-Present
Install and configure SQL Server on production and non - production environments.
Apply Service Packs and Cumulative Updates of SQL Servers.
Upgrade SQL Server from lower to higher versions.
Design backup strategies to meet RPO objectives of clients and perform full, differential and transactional log backups and restore them whenever necessary.
Perform daily monitoring and routine maintenance tasks including backups (full, differential and transaction log), integrity checks, clean up jobs, index and statistics maintenance.
Identify and troubleshoot memory, I/O, disk space, CPU and other resource contentions.
Control access to SQL Server and Databases by creating logins and group users with appropriate roles and permissions.
24/7 support of mission critical production databases on call rotational basis.
Implement SQL server high availability solutions like Log shipping, Replication, Mirroring, Failover Clustering and AlwaysOn A.G. as well as carefully scheduled maintenance to minimize downtime.
Solve concurrency problems of blocks, locks, deadlocks by viewing and tracking them using Activity Monitor, SSMS, enabling Trace Flags and other tools such as DMVs, Extended Events and Profiler.
Mike Gabriel
************@*****.***
Silver Spring, MD
Page 3
DBA
Ethio Telecom– Addis Ababa, Ethiopia
Junior Database Administrator January 2014 – June 2016 Description: Ethiopian Telecommunication Corporation is the state owned Telecommunication Company providing mobile, fixed line telephone and data service services for more than 42 million customers.
Installed and configured SQL Server 2008/2008R2/2012 Database Server.
Worked with development teams to design physical database, data structures, and large databases.
Implemented server security by creating logins and users with appropriate roles and permissions.
Wrote different procedures and SQL scripts to create database and database objects
Created alerts, notifications, and emails for system errors, insufficient resources, fatal database errors, hardware errors, and security breach.
Worked with development teams in the design and modification of physical databases.
Assisted development teams with tuning queries and creating missing indexes.
Design backup strategies to meet RPO objectives of clients and perform full, differential and transactional log backups and restore them whenever necessary.
Supported developers coordinate their efforts in managing and maintaining different application databases.
Troubleshoot SQL Server performance issues for internal and external clients.
Data migration from MS-Access and Upgrading SQL Server from old to higher versions.
Contact this candidate