Sql Server Data
Resume:
WELDAY TEKA
**** ********* ***. *** * Henrico VA 23228
*******@*******.***
5+ years of experience as a SQL Server DBA with detail orientation, analytical and troubleshooting and data modeling experience in different SQL Server technologies (2005, 2008/R2, 2012, 2014 and 2016). Solid working experience in managing and maintaining medium to large databases in 24/7 environment including backup/recovery, Performance Tuning, implementing and maintaining HA\DR solutions (always-on AG, Fail over Clustering, Mirroring, Log shipping and replication), developing T-SQL queries, stored procedures, triggers, functions, constraints, SSIS packages and utilizing various third-party tools
SQL Server DBA Experience
•Hands-on experience in installing, configuring, managing, maintaining, monitoring and troubleshooting SQL server 2005/2008/2008R2/2012 and 2014 technologies;
•Worked in 24X7 production on-call and day-to-day support;
•Migrated databases from one server into another and from earlier to the latest versions;
•Implemented and maintained various HA\DR solutions including Always-on AG, Failover Clustering, Mirroring, Log-shipping and Replication;
•Worked on logical and physical data modeling using Erwin data modeler;
•Experience in supporting Very Large Databases more than 1.8TB and troubleshooting issues;
•Expertise in database backup and recovery procedure and point-in-time recovery using native and third-party tool-LiteSpeed
•Expertise in performance tuning and query optimization using native tools including DMVs, Perfmon, profiler, execution plan and third-party tools- SQL DM;
•Experience in capacity planning, space and transaction log management;
•Expertise in writing stored procedures, UDFs, views and triggers;
•Experience with Transparent Data Encryption (TDE);
•Experience in creating and managing alerts, operators and database maintenance tasks (integrity check, index maintenance, backup and clean up jobs) through sql server agent;
•Worked on SAN/RAID storage technologies;
•Experience in designing and deploying SSIS & SSRS packages;
•Skilled in tuning databases to improve performance on high transaction systems and designing data models - conceptual, logical and physical data models
Environment
MS SQL Server 2014, 2012, 2008/R2 and 2005, SQL Server Tools SSMS, SSCM, SSIS, SSRS, PerfMon, DMV's, DMF's, Profiler, Windows server 2012/2008/R2, SQL LiteSpeed, Idera SQL DM.
Professional Experience
Company Name: Data Group USA March 2016- Feb,2019
Role: SQL DBA
Project location: Fairfax, VA,
Responsibilities:
•Installing, configuring and managing and tuning SQL server 2014/2012/2008/2008R2 in production and lower environments;
•Configured and maintained various HA\DR solutions including Always-on, Database mirroring and Log-Shipping;
•Migrated Databases from SQL Server 2008 to SQL Server 2012 and 2014;
•Apply patch (hot fixes, CUs and SPs) to various version of SQL servers;
•Design, document, and promote security "best practices", policies, standards and protocols.
•Managing security including creation of logins and assigning roles and minimum privileges to users;
•Deploying application code and packages to lower and production environments ;
•Working with development and systems teams to perform application and database tuning and Setup and maintenance of appropriate database and application monitoring.
•Working experience and strong knowledge in disaster recovery;
•Performed performance tuning: using SQL Server profiler, PerfMon and Database engine tuning advisor to analyze and fine tuning of long running queries and stored procedures and slow running servers.
•Tracing and troubleshooting blocking and deadlocking using profiler, trace flags, DMVs, system views and system stored procedures;
•Created documentation for installation, monitoring procedures, security policies, configuration changes, migration procedures, and best practices.
•Migrated databases from other databases like Oracle 10g, MySQL, to SQL Server 2008/2008R2
•Data Modeling using ERWin;
•Generated Report using SSRS (SQL Server Reporting Services).
•Scheduled jobs to automate different database related activities including backup, consistency check, disk space, index maintenance and backup verification.
•Monitor Server Activity, Error Log, space usage, and addressing issues.
•Expertise in writing stored procedures, triggers and functions using T-SQL and optimized stored procedure
•Used Transparent Data Encryption (TDE) and Column level encryption to maintain sensitive data.
•Used SSIS (SQL Server Integration Services) for data extraction, transformation and loading across different databases
•Environment: MS SQL Server 2014, 2012, 2008/R2 SQL Server Tools SSMS, SSCM, SSIS, SSRS, PerfMon, DMV's, DMF's, Profiler, Windows server 2012/2008/R2, Idera SQL DM.
Company Name: InfoTech computer solution - May 2012 to March 2015
Role: SQL DBA
Project Location: Addis Ababa, Ethiopia
Responsibilities:
oversee daily activities for 50 SQL Servers including security management, storage space, backups and restores.
Used Transparent Data Encryption (TDE) and Column level encryption to maintain sensitive data.
Maintain and run SSIS based ETL jobs, for daily, monthly and quarterly tasks.
Writing T-SQL scripts to convert complex client data for load into staging database
Troubleshoot performance problems, fine tuning of databases and index analysis
Installation & Configuration of SQL Server 2008 on windows 2008 servers and applied service packs and security fixes for all individual servers & Clusters.
Upgrade and migration from SQL Server 2005 to SQL Server 2008.
Writing scripts and creating scheduler jobs to automate the tasks.
Monitor SQL server performance using profiler to find performance issues or deadlocks.
Designing and implementing comprehensive backup plan and disaster recovery strategies.
Troubleshooting databases issues for clients during implementation, maintenance, upgrade, and migration processes.
Using Index tuning wizard to redesign and created the indexes for better performance.
Setup Database Maintenance Plans to reorganize indexes, re-indexing and update the index statistics on the production databases.
Proactively monitoring drive space, database size, and backup status to avoid any production disasters.
Environment: SQL Server 2005/2008R2, Windows Server 2008R2/2008
Install and configure SQL SERVER 2005 and 2008, managing SQL version lifecycle throughout the enterprise
Infrastructure support for SQL Server databases in development, test, and production environments.
SQL Server performance tuning
Used Transparent Data Encryption (TDE) to maintain sensitive data.
SQL server security and data integrity
Enforcement of database standards
Collaborate with development teams on designs that require an efficient and effective integration of database services into custom software solutions
Documentation of procedures and best practices
Capacity planning & trending analysis
Backup/recovery of database instances
Other duties as assigned by Director
Environment: SQL server 2008/2005, Microsoft Visual Studio 2008, Win 2003, Microsoft Visual Source Safe, Office communicator, Change Control Manager.
Company Name: United Nation peace keeping operation
Role: Data entry Clark
Project Location: Darfur, Sudan
Responsibilities:
Responsible for the installation and maintenance of IT equipment including printers, scanners, and workstations.
Supporting customers using remote access technologies and also by visiting client sites.
Responsible for supporting: Windows XP/Vista/Windows 7/ Office 2003 and 2007, Windows
Server, Small Business Server 2003/2008, and Active Directory management
Diagnose, troubleshoot and resolve a range of software, hardware and connectivity issues. Excel in asking probing questions and researching, analyzing and rectifying problems. Duties:
Diagnosis of desktop, application, networking and infrastructure issues.
Troubleshooting PC's, laptops and mobile devices. Providing 1st/2nd line support to users.
Maintaining a log of all problems detected and system backups.
Entering organization and account data from source documents within time limits.
Compiling, verifying accuracy and sorting information to prepare source data for computer entry.
Reviewing data for deficiencies or errors, correcting any incompatibilities and checking output.
Demonstrated strengths in rapidly diagnosing, troubleshooting and resolving client issues.
Education
Bachelor of computer science from C.P.U business and computer technology University
References
Strong reference will be provided upon request
Work Authorization for USA
U.S GC EOD and authorized to work for any employer in US
Contact this candidate