Sql Server Ms

Soza Teshale

Atlanta, GA

Cell: 404-***-****

Email: ****.*******@*****.***

Status: GC holder

Professional Summary

7+ years of professional experience in SQL Server Database Administration, Support and Upgrade in Production & Development Environments

Extensive experience with MS SQL Server 2014, 2012, 2008 R2 and 2008 Versions on clustered and standalone environment

Extensive Knowledge of Relational Database Management Systems.

Experienced in Database Backup, Restore and Disaster Recovery procedures.

Experienced in MS SQL Server installation, configuration, performance tuning, client/server connectivity, query optimization and back-up/recovery.

Strong experience working on environments which includes Windows 2012 R2, 2012, 2008 and 2003 Server on clustered and standalone.

Highly experienced in Database Maintenance plans, scheduling jobs, alerts, Notifications and configuring Database Mail.

Managed databases, schemas, tables, views, indexes stored procedures, triggers, and integrity constraints

Experienced scheduling jobs to check Database Consistency Checks using DBCC command or maintenance plans.

Expert in providing high availability support for SQL Server: Database mirroring, log shipping, replication and AlwaysOn High Availability.

Hands on experience in system security, managing user logins, granting access roles and object level permissions.

Strong in monitoring Event viewer and SQL Error logs for Software, hardware and database related errors.

Knowledge of SQL Server Integration Services and Reporting Services.

Knowledge of applying the latest SQL server service packs and cumulative updates on clustered and standalone servers.

Experience in providing 24 x 7 Production Support including code deployments

Provide weekly On-Call rotation for production operation and other environments as needed

Experience in providing support on monthly maintenance windows.

Excellent communication skills, self-managing and teamwork spirits in multicultural environment.

WORK EXPERIENCE

SQL Server DBA

Elavon Corporation–Atlanta GA

Jan 2016 –Present

Elavon Inc., formerly NOVA, is a processor of credit card transactions and a subsidiary of U.S.

Bancorp. Elavon offers merchant processing in more than 30 countries and supports the payment needs.

Responsibilities:

Installation and administration different versions of SQL server from 2008 R2, 2012 to 2014.

Maintaining SQL Server instances which includes primary database maintenance, performance tuning, patching and support.

Optimize database queries for best performance.

Scheduled and monitored database backups on a regular basis to allow for database recovery

Worked on capacity planning for critical production servers

Regular monitoring of SQL server agent jobs and error logs /event logs.

Monitored server activities, space usage, blocking, performance issues and solved problems as needed

Monitoring Memory, CPU, replication latency and resolve problems

Very proficient in troubleshooting mirroring and log shipping

Configured and maintained AlwaysOn High Availability Groups

Created new database objects like Tables, Procedures, Functions, Indexes and Views using T-SQL in Development and Production environment

Worked in Active /Active, Active / Passive Cluster environment as a High availability solution.

Regular monitoring of Database Health by using Consistency Check Commands.

Monitored and modified Performance using execution plans and Tuning the Index's as per requirement.

Document, and promote security "best practices", policies, standards and protocols.

Responsible for applying latest Service packs and security updates on SQL server.

Responsible for providing daily and weekly reports to the immediate supervisor and actively involved in weekly meetings to discuss project status.

Environment: MS SQL Server 2008 R2, 2012, 2014, Windows 2012 / R2 Server, Red Gate Tools, SQL Profiler, SQL Query Analyzer, Spotlight, SSRS, SSIS., ServiceNow

SQL Server DBA

Brightstar Corporation – Atlanta GA

November 2012 -January 2016

A U.S.-based privately held corporation founded in 1997. Brightstar corporation, provides specialized global wireless distribution and services, serving mobile device manufacturers, wireless operators and retailers.

Responsibilities:

Responsible for installing, Configuring and maintaining SQL Servers

Resolving system/database issues, monitoring automated jobs, monitor system availability

Coordinating with the Systems Administration/Network team pertaining to any system, network related issues.

Support and maintenance of Transactional Replication and experience in troubleshooting replication problems.

Administer security for server logins (Windows, SQL Logins) and Role based permissions

Periodic creation of objects like Tables, Procedures, Functions, Indexes and Views using T-SQL in Development and Production environment

Worked in Cluster environment which included replication as a High availability solution.

Periodic monitoring of Database Health by using Consistency Check Commands

Good experience in pulling out performance and database growth Reports using Spotlight tool

Worked on Performance Tuning of long running Queries and Stored Procedures using Database Engine Tuning Advisor and Profiler.

Worked on deploying Codes, SSIS packages and jobs in production environment

Daily routine DBA tasks like handling Security and space issues

Handled periodical Database Refresh in QA-Test environment for testing new Deployments

Environment: Windows 2003 / 2008 Server, SQL Server 2008/ 2008 R2, Management Studio, SQL Profiler, SQL Query Analyzer, DTS, SSIS, SSRS and SolarWinds

SQL Server DBA

Medhin Ethiopian Insurance Corporation

Feb 2011 – May 2012

Ethiopian Insurance Corporation EIC was established in 1976 by proclamation No.68/1975. The Corporation came into existence by taking over all the assets and liabilities of the thirteen nationalized private insurance companies, with USD 1.29 million paid up capital aiming the following objectives.

Responsibilities:

Installed, configured and administered SQL server 2005 and 2008, 2008 R2 in Clustered and stand-alone environment

Verified, maintained and created automated procedure for daily, weekly and monthly system maintenance tasks such as database backup, database integrity verification, indexing defragmentation, update Stats

Experience in deploying Database objects to production environment from Staging servers

Successfully upgraded SQL Server 2005 to SQL Server 2008 R2.

Extensively involved in setting up Database Mirroring, Log Shipping and Replication

Support and maintenance of Transactional Replication and experience in troubleshooting replication problems.

Configured Database mail, created jobs, alerts and set up notifications

Assigned permissions to users, roles, and objects, and column level permission.

Granted permission on SQL security for server logins (individual windows and SQL logins and for Windows Group accounts).

Prepared Documentation for the Disaster Recovery plan

Created Linked servers to access data between SQL Instances

Document, and promote security "best practices", policies, standards and protocols.

24/7 support with on-call rotation

Environment: MS SQL Server 2008 R2/2008/2005, Windows server 2003/2008 Enterprise Edition, SQL Server Management Studio, SQL Profiler, SSIS

ADDITIONAL INFORMATION

Technical Summary:

SQL Server Tools: SQL Server Management Studio, Business Intelligence Development Studio, Query Analyzer, SQL Profiler, SSIS,Replication, Database Tuning Advisor and Index Tuning Wizard, BCP, SQLCMD,Reporting Services, Report Manager, Reporting Services Configuration and Report Builder, Upgrade Advisor, SQL Configuration manager and Service manager.

Languages: T-SQL, Visual Basic 6, Visual Basic 5, C++

Operating Systems: Windows Server 2012 R2, 2012, 2008, Windows Server 2003, Windows Professional, Windows 7, NT/95/98/ME/XP and MS-DOS.

Data bases: SQL Server 2014/2012/2008/2008 R2/2005, MS Access

Education: BSc in Computer Science

Haromaya University, Ethiopia

Certification: - Administering Microsoft SQL Server 2012/2014 Databases (70-462)

Relocation: Willing to relocate.

References: Available on request.

Contact this candidate