SUMMARY

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 toolsSQL 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

TECHNICAL SKILLS

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: Confidential, USA

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: Confidential

Role: SQL DBA

Project Location: Addis Ababa, Ethiopia

Responsibilities:

• versee 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 dat require an efficient and TEMPeffective 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: Confidential

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.