Post Job Free

Resume

Sign in

Sql Server Manager

Location:
Silver Spring, MD
Posted:
February 07, 2019

Contact this candidate

Resume:

Fekadu Tarekegne Teshale

Takoma park, MD–*****404-***-****– ac8e9w@r.postjobfree.com –https://www.linkedin.com/in/fekadu-t-2477a2154/

SQL SERVER DATABASE ADMINISTRATOR

IT MANAGEMENT ~ PROJECT MANAGEMENT

PROFESSIONAL GOAL

To obtain employment in a diverse and innovative company that utilizes my technical expertise and interpersonal skills and enables me to constantly contribute to the success of the company and at the same time, provides a platform to hone my skills as a SQL Database Administrator.

PROFESSIONAL SUMMARY

7+ years of experience in SQL server database administration and developer for very large and complex databases in SQL server 2016, SQL server 2014, SQL server 2012, and SQL server 2008 r2, 2008. In addition to that I have experience on production and non-production environment.

Expertise in installation, configuration, performance tuning and maintenance with outstanding skill troubleshooting capabilities production servers and virtual machine continually focused on identifying, isolating and resolving technical issues.

Worked extensively and expertise on failover clustering and server consolidation.

Extensive experience on PostgreSQL

Extensive experience in software installation and upgrades, resolving errors and failures, auditing activities, and resource utilization.

Extensive experience coding, testing and supporting database solutions in SQL server environments.

Expertise in T-SQL writing stored procedures, triggers and functions.

Experience in SQL server always on availability groups, the high availability and disaster recovery strategies.in addition to that experience in SECURITY management operations by enforcing Security policies.

Proficiency and expertise in SQL server migration from SQL server 2008 / 2005, excel, and Flat file. In addition to that expertise in replication, log shipping and database mirroring.

Analytical, highly adaptable professional with extensive experience developing, deploying and evaluating systems aimed at improving quality and efficiency.

Maintained individual service accounts for SQL server services on cluster with different security groups to raise security mark.

Having experience on Experience on 64 bit SQL server 2012 / SQL server 2008 r2 systems configurations, data center servers and handling 2-3 TB databases.

Handling memory configurations for SQL server 2014 and SQL server 2012 on windows 2012.

Experience in batch processes, import, export, backup, database third party monitoring tools like Spotlight and Idera tools and application support.

Working knowledge in analysis services (SSAS), reporting services (SSRS) and clustering.

Implemented the new SQL Server 2012 mechanisms like data compression, online indexing, Contained Databases, security principals and AAG

Expertise in automating the SQL regular tasks to reduce the team member efforts

Experience with Data Warehousing and IO subsystems in context of the database engines.

Expertise in Schedule, plan, and document installation and testing.

Develop standards and guideline.

Successfully ensure security and integrity of databases by administering, maintaining, developing and recommending appropriate policies and procedures.

Accomplished communicator skilled in building and strengthening relationships across functions to drive cohesive, strategic operations.

Strong technical background along with the ability to perform business analysis and write effective documentation and specifications.

Strong interpersonal, written and verbal communicator who can deliver effective presentations, and maintains collaborative relationships.

Positive attitude and willing to take new responsibilities

Professional Expertise

-

-Installation, configuration and post-configuration on both physical server and virtual machine

-maintenance plan

-disaster recovery planning and security management

-log-shipping

-mirroring

-replications

-migration

-window And SQL Failover clustering

-High Availability

-postgreSQL

-Third party monitoring tools- Quest spotlight and idera’s diagnostic manager

-Data Modeling (Visio And Erwin design Tool)

-Performance tuning

-Power shell

-Troubleshooting

-Documentation

-SSAS, SSRS, R, Minitab and ANOVA

Professional Experience

METROPOLITAN HEALTHCARE SERVICES. Herndon, VA. JUNE 2018–PRESENT

SQL Server DBA.

metropolitan healthcare services (mhs) is the industry leader in providing comprehensive support services for hospitals and healthcare facilities throughout the united states.

Reviewed and offered recommendations for Database system configurations, responsible for tuning data, indexes, and queries as well as providing assistance on these areas to development teams.

Troubleshoot SQL Server performance issues for internal and external customers.

Provided consultation for all application development teams regarding performance review and the correct usage of database objects. Monitor and record database activities.

Monitored and tune databases, indexes, stored procedures and Server Performance using Performance Monitoring tools for Microsoft SQL Server 2012.

Automate and enhance daily administrative tasks, including space management, object alteration, backup & recovery and performance monitoring.

Scheduled Full, Differential and Transactional log backups for the user created and system databases in the production environment

Created Alerts and Notifications for system errors, insufficient resources, fatal database errors, hardware errors, security breach, etc.

Project management : Created logins, groups, users, roles, database devices, databases, mirroring devices, checking for database consistency, fixing DBCC errors, monitoring error logs, database space allocations, transaction log space allocations, fine tuning SQL performance.

Analyzed various aspects of Stored Procedures and performed tuning as needed to increase productivity and reusability of code.

Environment : Microsoft SQL Server 2008/2012, Windows Server 2005/2008, SSIS, SSRS, Windows Live Meeting, Replication Monitor, Mirroring Monitor, spotlight tool, Microsoft Visual Studio, Management Studio Monitoring tools (SQL Profiler, DMV, and Performance Monitor).

WALGREENS · Columbia, MD Feb. 2016-June 2018

SQL Server DBA

Directed concurrent technology projects, including identifying and resolving database performance issues, capacity planning, replications and other distributed data issues in line with aggressive timeline, quality and best practices requirements.

Team Collaboration: Liaised with software development teams to effectively assess the impact of database changes on system performance

Project Management: Installed, configured and managed SQL server 2012 and 2014 in development, test and production environments, patching SQL server packs and hotfixes with recent update, migrating databases and creating relational databases and database objects

Database Administration: Install, monitor, backup and tuning of PostgreSQL,

Familiar with Oracle, Maria DB and MySQL databases.

Maintenance: Create server agent jobs and maintenance plans while successfully problem solving failed jobs and monitoring server database alerts.

Disaster Recovery & High Availability: Manage and test SQL server backups and create and manage different SQL server high availability solutions, such as Replication, Log Shipping, Mirroring, Always On and Clustering.

Performance Tuning: Monitor and improve SQL server performance by suing different tools, such as DMV’s DMF’s, SQL server Profiler, Query Plan, and Database Tuning Advisor.

Environment: MSSQL Server 2008R2/2012/2014/2016, MS-Access, PostgreSQL, Windows2003/2008/2012, DTS/SSIS, SSAS, Visio, spotlight, VSS 6.0, Erwin, SQL Diagrams, Index tuning wizard, SQL Profiler, Query Analyzer, Enterprise Manager.

LIFE LINE SCREENING · Independence, OH Mar. 2014-Jan.2016

SQL Server DBA

Independently configured, installed and implemented clustered and standalone SQL server 2014/2008R2 production environments, SSIS and SSRS. Expertly applied service packs and hotfixes.

Data Migration: Captained migration of SQL Server databases from SQL server 2005/2008 to SQL server 2012.

Responsible for all backup, recovery, and upgrading of all the PostgreSQL databases.

Integrity: Diagnosed and problem-solved issues across all systems to ensure database health and integrity.

Data Capacity: Monitored and managed database capacity growth and refreshed data from production to lower environment.

Implemented migration tasks from MS SQL apps to PostgreSQL databases.

Environment : Microsoft SQL Server 2008/2012, PostgreSQL, Windows Server 2005/2008, SSIS, SSRS, Windows Live Meeting, Replication Monitor, Mirroring Monitor, spotlight tool, Microsoft Visual Studio, Management Studio Monitoring tools (SQL Profiler, DMV, and Performance Monitor).

BANK OF AMERICA · Baltimore, MD May. 2011-Feb. 2014

SQL Server DBA

Successfully installed and configured SQL server 2012/2008/2005/2000 and service pack and scrupulously monitored service agent jobs.

Efficiency & Quality Improvements: Reviewed and revised execution plans, tuned long and ad hoc queries and created missing indexes for optimal performance

Disaster Recovery/High Availability: Project-managed solutions, such as mirroring, log shipping, replication and clustering.

Systems Management: Brainstormed, implemented and tested full disaster recovery at all levels of SQL server while performing database backups and restoring databases in point in time recovery.

ADDIS ABABA ICT AGENCY · Addis Ababa, Ethiopia Sep. 2010-Jan. 2011

Junior SQL Server DBA

Addis Ababa Information and Communication Technology Development Agency is a government organization. It has got a responsibility of managing; regulating, developing, investigating, securing and performing any ICT related ACTIVITIES in the region under the scope and collaboration with Federal ICT Development Agency. The Addis Ababa City Administration recognizes ICT as the umbrella of all aspects of development and realizes that this technology should be applied to accelerate the rate of economic growth and alleviate poverty.

My general responsibilities included Administering, maintaining all existing SQL Servers across organization. In addition to that I have also responsible to recognized for superior work in the installation and configuration of SQL server 2005 and 2008R2 on Windows server 2000 and 2003 multi instances and service packs. Managed database backups to verify integrity.

Troubleshooting: Problem-solved SQL job failures and implemented database maintenance plan.

Server Support: Ensured all instances of server were up and running perfectly while monitoring development and deployment of software applications.

Performance: Helped the performance tuning, query tuning and index tuning using DBCC Command, Wizards and SQL Profiler.

Environment: Windows Server 2008R2, Exchange 2010, 2003 R2, SQL Server 2008R2, 2005 PHP, AD (Active Directory)

Technology Proficiencies

Operating System:

Databases/Languages:

SQL Applications:

ETL Tools:

Monitoring performance third party tools:

Programming:

Data Modeling Tools:

Backup and Disaster Recovery Utilities:

GIS software :

Security :

Web tools :

Other statistical software’s:

Windows Server 2012R2, 2008, 2003$2, 2003 Windows XP Professional, Windows 7 Professional, VMware ESX 3.x

SQL Server RDMS

SQL Server Management Studio, Database Upgrade Advisor, Query Analyzer, SQL, VBA, VB/C# .NET, C programming

Profiler and Database Tuning Advisor, SQLCMD, Reporting Services Configuration

Manager, BIDS, SQL Server Configuration Manager

SSIS,SSRS, BCP, DTS

Quest spotlight, Idera’s Diagnostic manager

SQL, T-SQL, Store Procedures, Trigger

ER-Win, MS Visio, Red gate

Idea SQL safe, Symantec net Backup, Windows Server Backup

ArcGIS 10.3

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

XML, HTML5, CSS

SPSS, SAS 9.3, R, Minitab 17.3.1.0, ANOVA

EDUCATION AND CERTIFICATIONS

ADAMA SCIENCE AND TECHNOLOGY UNIVERSITY

BACHELOR OF SCIENCE IN INFORMATION TECHNOLOGY (2008-2010)

MICROSOFT CERTIFICATION SQL SERVER 2012 ADMINISTRATOR



Contact this candidate