Sql Server Active Directory
Resume:
Abel Alemayehu
*** ***** ***, ****** ******, MD *0910
***********@*****.***
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