Sql Server Windows

SUMMARY:

I am a Microsoft Certified Professional with 7 years of IT experience and a total of 6 Years of experience in SQL Server. I have managed Microsoft SQL Server, administration of SQL databases, upgrading, migration and development in production and nonproduction environments. I am dedicated, hardworking and have the motivation needed to jump in and take control of my duties to ensure the job is done right and in a timely fashion.

TECHNICAL SKILLS:

Installing, configuring, managing, migrating, upgrading, monitoring and troubleshooting

SQL Server 2000/2005/2008/2008/R2/2012/2014 on Physical boxes and virtualized environment using Hyper-V /VMware

Installation, configuration and upgrading SSIS, SSRS, and related products

Applying Service Packs/Hotfixes/Cumulative Updates

Security: Implementation and maintenance

Database security (creating logins, users and roles, assigning least/appropriate privileges)

Auditing, Encryption (TDE)

Implementing and maintaining HA and DR solutions

Mirroring, log Shipping, Replication, Failover Clustering and Always-On

Backup and recovery strategies based on companies’ RPO/RTO

Monitoring and performance tuning

Database integrity, locking, blocking and deadlocking, replication, connectivity, security issues

Memory, I/O, CPU, disk space and other resource contention

Extensive use of DMVs, DBCC commands and built-in and custom Stored Procedures to monitor the health of SQL instances, diagnose problems and tune performance

Implementing Automation

Using SQL Agent and third-party task scheduling tools

SQL Server Agent Security, Jobs, monitor and respond to alerts

BI Tools, Database design and TSQL Coding

Deploying SSIS packages and SSRS Reports

Creating and managing schema objects such as tables, views, indexes, functions, stored procedures, and triggers & maintaining referential integrity

Ability to write and tune/troubleshoot complex T- SQL Codes

Understands principles of database physical and logical design

Data transformation services

SSIS, DTS, BCP and Bulk Insert from heterogeneous DBs like, MS Access, Excel, and DB2

Third Party Tools: Spotlight Idera SQL Diagnostic Manager Idera Inventory Manager Red Gate

TECHNICAL EXPERTISE:

Databases

MS SQL Server 2014, 2012, 2008/R2, 2005, MS-Access

Programming

Transact SQL

SQL Server Tools

Profiler, Query Analyzer, Import and Export, DTA, SSIS, SSRS, SSAS.

Operating System

Windows server 2012/2008/2003, Advanced Server, NT & Windows, UNIX

Third party Tools

Red gate, Litespeed, spotlight and Idera.

PROFESSIONAL EXPERIENCE

Genco FEDEX (Pittsburgh, Pennsylvania) April, 2014 – Oct,2017

SQL server Database Administrator

Responsible for the technical and administration aspects of the company’s SQL Server Databases as well as providing a primary database support for on-premises applications, consult and monitor Database environments. Ensuring proper database security is in place as per company’s policy and Microsoft best practices. Performing Daily DBA Monitoring tasks to ensure Databases are up and running smoothly.

Roles and Responsibilities:

Building and maintaining new SQL Server 2012/2014 instances and Databases

Building Sandboxes, Template Servers and Performed unattended/silent installations of SQL instances

Monitoring alerts from the SQL Server error log and third-party tools like Idera and RedGate

Troubleshooting and resolving complex production performance issues

Performance tuning of long running queries and code reviewing

Creating and managing stored procedures, indexed views, user defined functions, triggers, database constraints to meet business requirements and policies

Restoring and recovering corrupted databases

Implementing and monitoring high availability solutions including snapshot and transactional Replication for reporting purpose

Configuring Always-On and implementing SQL Server clustering (Active-Active, Active-Passive).

Applied patches and service packs on SQL 2005, 2008/R2, 2012 and 2014 instances to keep the databases at current patch level

Involved in Data Acquisition / Data Conversion project

Performing standard DB Security administrations (creating logins, users, roles, and assigning Permanent and also temporary permission to them)

Consulting the Security team to add users into the appropriate Active Directory groups for SQL Database access

Upgrading/migrating databases to 2014, 2012 and 2008 instances of SQL 2000 and 2005

Deploying SSRS reports and scheduling SQL Server packages

Reviewing SQL codes in SSIS packages and providing recommendations for better query performance

Importing data from various sources to SQL Server using SSIS

After-hours support for Emergency and Standard releases/change management activities

Participating in 24X7 on-call rotation and respond to critical database incidents

Work Environment:

Windows server 2012/R2, 2008/R2, 2003R2, SQL server 2014/2012/2008R2/2008/2005/2000, SSRS, SSIS, T-SQL, ETL, Visual studio, Powershell, Redgate, SAN, RAID

New York Presbyterian Hospital February 2013 – March 2014

Role: SQL Server DBA

Description: New York Presbyterian Hospital is committed to excellence in patient care, research, education and community service. I have worked as a SQL DBA and my duties included creating and implementing database applications, writing scripts, and creating views to simplify queries. I am also familiar with some data modeling and creating SSRS reports.

Responsibilities:

Managed evaluation of installation requirements and designed the installation.

Installed and configured an operating system and SQL server 2012/2008-R2/2008/2005.

Installed and administered clustered and stand-alone SQL server 2012 and 2008.

Migrated SQL server 2005/2008/2008-R2 to SQL Server 2012.

Involved in troubleshooting and fine-tuning of databases for its performance and concurrency.

Implemented AlwaysOn on the clustered environment.

Configured and deployed Microsoft Business Intelligence solutions such as, SSIS, SSRS, and SSAS,

Managed and configuring databases.

Upgrading SQL Server to new versions and applying service packs and patch.

Implemented the new SQL Server 2012 new features and mechanisms.

Rebuilding/monitoring the indexes at regular intervals for better performance.

Recovering the databases from disasters.

Implementing Point-In-Time Recovery solutions.

Managed logins and server roles as well as users and database roles.

Experienced in using SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.

Monitoring and making recommendations for performance improvement in hosted databases.

Responsible for reviewing, optimizing and deploying database scripts.

24 X 7 Production Database on Call Support

Environment: SQL Server 2012/2008-R2/2008, Windows Server 2012/2008, Clustered, SSIS, T-SQL

DICT, Addis Ababa, Ethiopia Jan 2011 – Aug 2012

Role: SQL Server DBA

Description: DICT is a consulting company that provides consulting and training services for international institutions with its operations driven by modern information technology platform, spread across length and breadth of Ethiopia.

Responsibilities:

Installed SQL Server 2008-R2/2008/2005 in multi instance environment and service packs.

Performed and managed database backup and recovery.

Created database objects including tables, triggers, views, stored procedures, and indexes.

Performed maintenance of clustered and non-clustered indexes.

Monitored job history for maximum availability of data and to ensure consistency of databases.

Implemented and scheduled Replication process for updating parallel servers.

Designed and implemented database maintenance plan.

Automated messaging services/alert on server failures for task completion and success.

Enforced database security by managing user privileges and efficient resource management.

Performed and configured mirroring with windows authentication and certificate authentication.

Using database level triggers code for database consistency, integrity and security.

Migrated data from MS Access and MS Excel to SQL Server.

Environment: SQL Server 2008-R2/2008/2005, Windows Server 2003, Performance Monitor, and Backup Utility.

Union college, Hawassa, Ethiopia Jan 2005 – December 2010

Role: Dean and Lecturer

Description: Union College is one of famous colleges is Ethiopia engaged in providing different Long and short-term trainings in the country.

Responsibilities:

Preparing strategic plan and different administrative tasks,

Conducting lecture in different courses,

Advising thesis to senior or graduating class students, and

Conducting different problem-solving researches.

EDUCATION & CERTIFICATION

Microsoft Certified Professional – 70-462 Administering Microsoft SQL Server 2012 Databases.

Bachelor’s Degree in Information Technology and Computer Science from Hawassa University, Ethiopia.

Master of science from Addis Ababa University, Ethiopia.

Contact this candidate