Sql Server Technical Support

BETHLEHEM DESTA

202-***-**** ************@*****.***

SQL DATABASE ADMINISTRATOR

Qualifications Profile

A seasoned Database Administrator with background in SQL development environment. Detail-oriented, analytical and methodical with critical thinking to resolve complex work issues even under stressful conditions. Flexible and adaptable with quick learning abilities to reach high productivity levels in fast-paced work environments and new or demanding assignments. Well-organized and resourceful with multitasking skills that optimize limited resources to achieve outstanding results from concurrent tasks with or without supervision.

Professional Experience

SQL SERVER ADMINISTRATIOR (DBA)

INFOZEN-(BETHESDA, MD) 2016– 2017

Provided ongoing support for United States Citizenship and Immigration Services (USCIS) in achieving its goal for the transformation of its information technology systems’ delivery.

Designed, automated, Scheduled and monitored all maintenance jobs for SQL Server 2005/2008/2008R2/2012/2014 including database consistency check, and index defragmentation.

Expertise in Database Administration on Production Servers with server configuration, performance tuning and maintenance with outstanding troubleshooting capabilities.

Used Agile and DevOps methodologies to produce secure, efficient operations with added automation and with measurable cost-savings.

Configured and Managed the High Availability and Disaster recovery Solutions Always On, Mirroring, Replication, Active-Active and Active-Passive Clustering on Critical Production Servers.

Installed, configured and maintained SQL Server 2008, 2008R2, 2012, 2014 and 2016 versions.

Defined constraints, rules and indexes (clustered and non-clustered) based on business requirements.

Scheduled database backup, recovery and restore plan using stored procedures and SQL Server Agent. Created and Scheduled jobs, alerts jobs to capture any possible errors.

Planed and coordinated database upgrades and maintenance patches.

Implemented database replication and mirroring as of High availability options to cloud database.

Did performance turning, optimization and analyzing slow running queries with the use of SQL Profiler and Database Turning Engine Advisor. Also using the execution plan to analyze my queries.

Provided a 24 hour on call services monthly and provide able to write, communicate and troubleshooting very well in case of an incident.

Responsible for creating SSIS packages according to requirement as well as deploying and monitoring SSIS jobs

Monitored all databases status including CPU, memory, I/O, space Management, block, and dead lock.

SQL SERVER ADMINSTRATOR (DBA)

BRIDGE IT SUPPORTS SERVICES, LLC. (ALEXANDRIA, VA) 2013 – 2016

Involved in conceptual, logical and physical database modelling for a WPF desktop application.

Experienced in performance Monitoring and Tuning, Query Optimization via T-SQL, DMVs, System Monitor, DBCC Utilities, Database Tuning Advisor/Index Tuning Wizard, and SQL Profiler.

Granted, revoked and denied user’s permission and access to SQL server through the desktop application.

Created alerts and notifications for system errors, insufficient resources, and fatal database errors.

Designed, automated and scheduled database backup, recovery and restore plan using stored procedures and SQL Server Agent.

Implemented database replication and mirroring as of High availability options to cloud database.

Scheduled SSIS jobs (SQL Agent), Migrating DTS packages to SSIS packages.

Experienced in developing and debugging complex SQL Queries, Dynamic Stored Procedures, User Defined Functions, Triggers, Views, Cursors, Joins, Constraints, DDL and DML to implement the business logics.

Experienced in using SQL Server Profiler and Database tuning advisor to identify long running TSQL queries and stored procedures for better performance tuning.

Analyzed and performed data mapping which involves identify source data field and target entities.

Experienced in using different data source and destinations like Access, Excel, CSV, flat files, SQL Server etc.

Implemented Event Handlers, Error Handling, Logging and package configuration for deployment to test and production environment.

Involved in complete SSRS life cycle in creating SSRS packages, building and deploying to report server.

Enforced security measures and polices by minimizing scope of exposure to logins, applying security patches and performing necessary security audits.

Experienced in using data source and data sets to build embedded and parameterized reports.

Experienced in using DMVs and DMFs to finding and solving Performance Issue, Data modeling concepts.

TECHNICAL SUPPORT

Notable Solutions, Inc. (Rockville, md) 2008– 2011

•Troubleshoot database and hardware-related problems.

•Managed data fulfillment via excel and other similar applications.

•Involved with project management group to ensure accurate and comprehensive understanding of data and reporting requirements.

•Developed alerts, reports and automated processes for failed jobs.

•Provided successful guidance to clients on new methods of Employer Engagement.

•Provided issue escalation and resolution as well as timely execution of deadlines.

•Provided technical support to internal developers and external clients.

TECHNICAL SUPPORT ANALYST

Choicepoint services, inc. (Alpharetta, GA) 2001 – 2004

•Designed, implemented and maintained databases with respect to access methods, access time, device allocation, validation checks, organization, security, documentation and statistical methods systems through database design.

•Supported Software development and systems integration teams for ChoicePoint data warehouse environment.

•Supported the daily operations of the data warehouse, including maintaining and administering database systems and related environments (hardware, system and application software, and all configurations).

•Identified data issues and provided recommendations for resolution to ensure optimal performance.

Education & Credentials

US Citizen with Department of Homeland Security Public trust Clearance.

MCSA (Microsoft SQL Server Database Administration); Duna TekSolutions (Silver Spring, MD)

Bachelor of Science and Business Administration; University of Central Oklahoma (Edmond, Ok)

Contact this candidate