Resume

Sign in

Sql Server Active Directory

Location:
Silver Spring, Maryland, United States
Posted:
April 23, 2018

Contact this candidate

Resume:

Abel Alemayehu

*** ***** ***, ****** ******, MD *0910

ac4780@r.postjobfree.com

202-***-****

SQL Server Database Administrator and System administrator with above seven (6+) years of experience with detail oriented, analytical and troubleshooting experience in different Microsoft products like SQL Server (2016,2014,2012, 2008R2, 2008, 2005), Operating Systems, AD (Active Directory), Microsoft Exchange Server 2010, Solid working experience in managing large databases in 24/7 environment including backup/recovery, Developing and managing reports using SQL Reporting Services (SSRS), Perform a broad range of data migration tasks Extraction, transformation, and loading (ETL) SSIS, Monitoring Performance Tuning, stored procedures, triggers, functions, constraints, DBCC using third party tools.

Professional experience also entails developing/managing database objects such as tables, views, stored procedures, triggers, functions, constraints, database migrating, managing/moving securities, managing jobs, highly professional, Excellent team player and multi-tasking in timely manner.

Career summary:

Hands on experience in Installing, Configuring, Managing, Upgrading, Monitoring and Troubleshooting of SQL Server 2016,2014,2012/2008R2/2008/2005 instances on Virtual and Physical machines

Experience in implementing appropriate SQL Server Security and Database Permissions

Good understanding of Normalization/De-normalization and the database design methodology

Proficient with High Availability (HA) and Disaster Recovery (DR) options for MSSQL Server and well experienced in scheduling SQL Server Jobs, Maintenance plans and executing them as well as implementing operational automation using scripts

Proven experience with Performance Tuning and Optimization using native monitoring and troubleshooting tools like SSMS, System Procs, DMVs, DMFs, MS SQL Profiler, DTA, Activity Monitor, PerfMon, DBCC Commands

Experience in troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues, replication issues, log shipping issues, connectivity issues, security issues etc.

Ability to detect and troubleshoot SQL Server related CPU, memory, I/O, disk space and other resource contention.

Skilled in the set up and maintenance of high availability solutions like Mirroring, log Shipping, Replication, Failover Clustering and AlwaysOn and Expert experience in implementing operational automation.

Strong knowledge and skill of testing queries for prompt data retrieval, how indexes, index management, integrity checks, configuration, patching, how statistics work, how indexes are stored, how they can be created and managed effectively.

Experience in using third party tools like Spotlight, idera and RedGate for monitoring performance and great Technical documentation skills

Ability to handle multiple tasks and responsibilities independently as well experienced working in a team-oriented and collaborative environment

Self-motivated and directed with keen attention to detail, able to research new topics and quick and continuous learner

PROFESSIONAL EXPERIENCE

Exelon - Baltimore, MD August 2017 to Present

SQL DBA

Installing, Configuring, Upgraded & migrating SQL Server/Applied Service Packs to Supporting both production environment and non-production environment of

Set up security and access profiles and procedures for database system administrators.

Designing and handling of Disaster recovery and high availability solutions (Failover Clustering, Alwayson, DB Mirroring, Log-shipping and Replication)

Installs and configure Windows Server 2012 R2 Hyper-V,vSphere 6.0

Provide deep technical expertise to support delivery and maintenance of IT solutions.

Provide IT teams and business personnel with technology solutions by weighing advantages of technology standards, market availability of products, and risks and benefits of technology to meet business/IT needs.

Work environment: Windows server 2012R2 Enterprise edition, MS SQL Server 2016,2014,2012, 2008/R2, 2005, SQL BI, Visual studio, Idera SQL safe, Idera Diagnostic Manager, SAN, RAID, NAS, Amazon Web Services (EC2, EBS, S3, RDS)

HSBC Bank, Charlotte, NC Aug 2015- Aug 2017

SQL Database Administrator

Worked extensively on installation new SQL Servers, upgrading and migrating configuration of MS SQL Server 2016, 2014,2012, 2008R2

Applied patches and service packs to keep the database at current patch level

Schedule full and transactional log backups for the user created and system database in the production environment

Daily check for successful back up completion, including system drives and SQL Server data, log, temp DB, and backup disks

Point - in-Time recovery and Restored Database from backup

Implement Disaster Recovery and High Availability plan such as Log-Shipping, Database Mirroring, Replication, SQL server clustering and AlwaysOn.

Provide 24X7 Production support for the database and application issue

Used DBCC to check database conditions, fix database corruption, rebuild indexes and other database Maintenance purposes as well

Developed Reports for different purposes like DBA Reports, using SSRS

Automating administrative tasks using SQL Server Agent Service

Creating and administer Database objects – Tables, Views, Indexes, and Procedures.

Administering 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.

Database Upgrade SQL Server 2005 to 2008/2008R2 and 2012

Apply SP (Service Pack) on SQL Server 2005, 2008, 2008R2

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

Developed DTS and SSIS packages to extract, transform, and load data into the, from OLTP database.

Develop different maintenance plan such as backups, index management, Fragmentation management, cleaning history deleting old files.

Assisted Database Developers to optimize SQL queries and Stored procedures

Monitor server activity, Error Logs, Space usage, and solving problems as needed

Work Environment:

Windows server 2008R2 Enterprise edition, MS SQL Server 2012, 2008/R2, 2005 Enterprise edition, SSRS, SSIS, T-SQL, ETL, Visual studio, Idera SQL safe Manager, Agile model, Idera Diagnostic Manager, MS Access, Excel, SQL Profiler, Windows XP, SAN, RAID, NAS.

MBI Health Services LLC, Bethesda, MD Sep 2013 -July 2015

OPS SQL Database Administrator/Developer

Installed, Configured, and Managed SQL Server 2012, 2008 R2, & 2005 in development, test and production environment

Schedule full and transactional log backups for the user created and system database in the production environment

Daily check for successful back up completion, including system drives and SQL Server data, log, temp DB, and backup disks

Implement Disaster Recovery and High Availability plan such as Log-Shipping, Database Mirroring, Replication, SQL server clustering and AlwaysOn.

Provide 24X7 Production support for the database and application issue

Configured Log Shipping as Standby Database from Production Database for Reporting Purposes

Used DBCC to check database conditions, fix database corruption, rebuild indexes and other database Maintenance purposes as well

Creating and administer Database objects – tables, views, indexes, and procedures.

Administering 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.

Database Upgrade SQL Server 2005/2008/2008R2 and 2012

Apply SP (Service Pack) on SQL Server 2005, 2008, 2008R2

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

Developed DTS and SSIS packages to extract, transform, and load data into the. Campaign database from OLTP database.

Develop different maintenance plan such as backups, index management, Fragmentation management, cleaning history deleting old files.

Assisted Database Developers to optimize SQL queries and Stored procedures

Export & Import data from Flat file, CSV file to/ From SQL Server Database using DTS, and SSIS

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

Involved in data modeling for the application and created ER diagram using Erwin, Msviso

Export & Import data from /to database like Oracle, My-SQL, and Access to / from SQL server

Monitor server activity, Error Logs, Space usage, and solving problems as needed

Installed, Configured, and administered SQL Server Reporting Services (SSRS)

Developed Reports for different purposes like DBA Reports, user reports using SSRS and Report Builder 3.0 & 2.0

Deployed Reports and managed security of report server including folder level.

Work Environment:

Windows Server 2008R2, 2003 R2, IIS 7.5, 6.5, Apache Tomcat 5.5, SQL Server 2008R2, 2005, ASP, ASP.NET, PHP, AD (Active Directory)

Addis Ababa ICT Agency, Addis Ababa, Ethiopia April 2009 – Sep 2012

System Administrator

Supported and performed configuration, operations, updates, and maintenance of customer associated LANs and WANs for various unclassified and classified networks

Managed network operations including troubleshooting connectivity problems; installing and maintaining routers, firewalls and switches; added/terminated users; assigned rights and access; reset passwords; established email addresses; performed backups and restores

Maintained network security and ensured compliance with security policies and procedures

Maintained and monitored network operations, including firewall, switches, and wireless access points

Mange installation & configuration Exchange Server 2010 Roles Mailbox Server role Client Access Server, Hub Transport Server role, Edge Transport Server role & Unified Messaging Server role on windows server 2008R2

Create a new user account with Domain Admins credentials in Active Directory environment

Upgrade Install & configurations SQL Server 2005 to 2008/2008R2 in different machines

Performed computer repair and maintenance including application installs, virus/spyware maintenance and updates, hardware upgrades, memory and hard drive

Supported desktop hardware and peripherals; conducted software troubleshooting, installs, licensing, OS installs; built and maintained corporate ghost images; compiled corporate hardware inventory

Provided technical support for up to 300 on-site and remote users including desktop, application, mobile device, video, teleconferencing, and IP phone systems

Monitored and maintained data backup and disaster recovery systems

Managed the usage and performance of voice, video, and data communications networks

Evaluated hardware and software, including peripheral, output, and related equipment

Work Environment:

Windows Server 2008R2, Exchange 2010, 2003 R2, Huwawi & Cisco routers switches and firewalls, SQL Server 2008R2, 2005 PHP, AD (Active Directory)

TECHNICAL SKILLS

Operating Systems: Microsoft Windows Server 2008/R2 & 2012/R2, Windows XP, Vista,7, 8, Ubuntu Linux

Servers: MS Exchange 2010, Active Directory, DNS, DHCP, SQL 2008, Sql 2012

Visualization: VMware, ESX and Hyper-V

Networking: TCP/IP, VPN, LAN/WAN, Firewalls, Switches, Routers, Wireshark

Programming Languages: TSQL & Basic knowledge of C, C++, VB and Java HTML

Office Suites: Microsoft Office 2007, 2010,2013 & 365

Backup and Disaster Recovery Utilities: Idera, Symantec Backup Exec, Windows Server Backup

Security: Security Policies, Anti-malware/Anti-Virus (Trend Micro Security, Malware bytes), Barracuda Spam filters

Hardware: Dell, HP, IBM Servers; Hiwawi Firewall Switches and Routers; Cisco Switches, Router

CERTIFICATIONS / TRAINING

•Microsoft Exchange Server 2010

•Microsoft Active Directory

•CISCO CCNA

•Trend Micro OfficeScan Antivirus

•HUAWIU Router, Switch, Firewall Maintenance

•Systematic NetBackup

Education

BSC Computer engineering

Languages

Fluent in English and Amharic; Beginner in Italian



Contact this candidate