Sql Server Data

Qualifications Summary

A certified SQL Server DBA with over 6 years of professional experience in Database Administration, Design, Development, and Support of MS SQL Server 2016,2014, 2012, 2008R2, and 2005 in Production, UAT and Development Environments.

Experience in Performance Tuning, Index Tuning, Execution Plan, Query Optimization, Reports, Backup and Disaster Recovery.

Solid experience in SQL Server high availability solutions, including AlwaysOn Availability Groups, and SQL Server Clustering (Active-Active, Active-Passive).

Proficient in SQL/T-SQL Scripts, indexes, stored procedures, views, triggers, and functions.

Proven ability to identify the root cause of database issues with the expertise to troubleshoot and resolve issues promptly.

Hold exclusive knowledge of database security including data encryption and decryption.

Working knowledge of SQL server upgrades and migrate using various versions and editions.

Experienced in ETL operations across heterogeneous sources for small and large scale data warehouse.

Developed and deployed several report using SSRS.

Expertise in using SQL Server tools as well as third-party tools efficiently like ERWin, Toad Data Modeler, SQL Sentry/SentryOne, Idera, Redgate, OpNet,SolarWinds and Tableau.

Technical Proficiencies

Operating Systems

Windows Server 2012, 2008R2, 2003R2

Virtualization

VMWare, and VSphere. Managed Database Servers and Databases in Virtual Environment, Azure Cloud, AWS (EC2, Redshift,RDS)

Database

MS SQL Server 2016,2014/2012/2008/2008R2/2005,

SQL Server Tools

SSMS, Query Analyzer, Performance Monitor, SQL Server Profiler, BIDS/Data Tools, Database Tuning Advisor, SSIS, SQL Server Configuration Manager, Activity Monitor, Job Activity Monitor, Execution Plan, DMVs, DMFs, DBCC, Index Tuning Advisor

Data Modeling Tools

ERWin, Toad Data Modeler

Reporting Tools

SSRS, Report Builder

Data Migration/ETL Tools

SSIS, Backup/Recovery, Detach/Attach, Import/Export Tool, DTS

Hardware/Storage

SAN, RAID

Professional Experiences

DATAGROUP USA 07/2013 – Present

SQL Server Database Administrator

Responsibilities:

SQL/TSQL/Database Programming:

oCreated stored procedures, functions, Queries, views and other database objects.

oExecuted performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.

ETL/SSIS: (SQL Server Integration Service)

oDeveloped SSIS packages using Lookup Transformations, Merge Joins, and Derived Columns with Multiple Data Flow tasks.

oUsed SSIS to create ETL packages to Validate, Extract, Transform and Load data to Data Warehouse and Data Mart Databases. Involved in Extracting, Transforming and Loading (ETL) data from Excel, Flat File to MS SQL Server by using SSIS services.

oDeployed and Debugged SSIS packages for import, export and bulk insert data with transformations from various data sources.

SSRS (SQL Server Reporting Service):

oInstalled, Configured, and administered SQL Server Reporting Services.

oDeveloped and Deployed Reports using SSRS.

oDeveloped periodic SSRS reports in BIDS used to generate daily, weekly, monthly and quarterly reports.

oCreated Ad-Hoc Reports, Summary Reports, Sub Reports, and Drill-down Reports using SSRS.

Installed, Configured, Managed and applied Service Pack to SQL Server 2014 and 2012, 2008R2 in development, test and production environment.

Backup/Recovery:

oPerformed different daily routine backup jobs by using maintenance plan.

oCarried Out manual and automation schedule backup job.

oPerformed tail log backup for a point in time recovery based on the disaster recovery.

oRestore Database from backup file Server to production.

Database Upgraded/Migrated (development, testing, and production environment)

Created documentations for an upgrade and migrate databases.

Solid hands-on skills in migrating/upgrading SQL Server 2005 to 2008/2008R2&SQL Server 2005, 2008/2008R2 to 2012 and 2014 and applying service packs.

Database Monitoring/Performance Tuning:

oMonitoring Server and databases Performance tuning (Disks space, lock, and block, query running slow).

oSchedule jobs to automate different database related activities including backup, monitoring database health, disk space and backup verification.

oMonitor SQL Temp DB, Server Error Log, and Usage space.

High Availability:

oConfigured and Maintained AlwaysOn in 2012 on Virtual machine.

oConfigured Manage and maintain Transactional Replication.

oManaged and maintained two NODE active-passive clusters.

INDEX:

oCreated, modify tables, Index (Clustered/Non-Clustered), Constraints (Unique/Check), Views, Developed different Maintenance Plans for database monitoring.

oDMV command to check database conditions, Rebuilding indexes and other database Maintenance purposes.

oPerformed database consistency checks with DBCC, Defrag, Index tuning and monitoring error logs.

OTHERS:

oExpert in analyzing the execution plan and index management for better Query Optimization.

oApplied SP (Service Pack) on SQL Server 2008 (SP4), 2012(SP3).

oCreated Trace file using SQL Profiler then review it for further steps.

oTune queries which are running slow using Perfmon, Profiler, and Statistics I/O by using different Methods in terms of evaluating joins, indexes, updating Statistics and code modifications.

Worked with Windows team to failover the cluster when needed after Windows patching.

Created jobs, Scheduling Jobs, Alerts using SQL Server agent and handle error logs for troubleshoots.

Created DB master key, symmetric keys, asymmetric keys and certificates for encryption.

Performed partition for efficient management of database tables.

Troubleshoot performance issues such as locking, blocking and deadlocks on production database using tools like SQL Server Profiler.

Environment: SQL Server2014, 2012,2008R2, Windows Server 2012, 2008 R2 64 bit, SQL Profiler, PerfMon, Execution Plan, Activity Monitor, SSIS, T-SQL, SQL Agent

MANTAD TECHNOLOGY SOLUTIONS INC, SILVER SPRING, MD 01/2011 – 06/2013

SQL Server Database Administrator/DBA

Main Responsibilities:

Supported day to day operational activities for the database platform like service requests and tickets, monitoring, performance tuning, troubleshooting long-running queries, locks, deadlocks and performance issue like CPU, I/O, Memory bottlenecks.

Installed, Configured, and Maintained SQL Server 2008 R2, 2012, in development, test, and production environments.

Installed SQL Server 2012 in a test environment to be the future production environment

Configured Backups, involved in restoring the database to point- in- time in case of issues, and optimization jobs for various purposes and DBA notifications like job failures, disk issues, critical events.

Implemented high availability with AlwaysOn Availability Groups, Mirroring, Replication and Failover Clustering.

Upgraded SQL Server 2000 to SQL Server 2008 R2 and SQL Server 2005 to SQL Server 2012

Applied SP (Service Pack) and Hot Fixes on SQL Server 2008 R2, and 2012.

Installed, Configured, and Administered SQL Server Reporting Services (SSRS), and Developed, Deployed and Managed Reports for associates and upper management using SSRS, Crystal Reports and Report Builder.

Involved in completing database design including conceptual, logical and physical data models

Created and managed schema objects such as tables, views, indexes, stored procedures, and triggers and maintained referential integrity.

Exported data from SQL Server to multiple destination/format such as Flat file, CSV file, Oracle, MySQL, Access and ODBC/OLEDB data sources.

Import data from multiple sources such as Flat file, CSV file, Oracle, MySQL, Access and ODBC/OLEDB data sources to SQL Server.

Migrated Oracle 10g/11g, MySQL 5.1/5.5 databases to SQL Server 2008R2 and 2012.

Performed Performance Monitoring, and Troubleshooting using SQL Profiler, Execution Plan, Database Tuning Advisor and tracing and optimizing long running queries.

Wrote T-SQL scripts including Stored Procedures, triggers, and functions.

Scheduled to Rebuild and reorganize the index.

Worked on managing Lock, Block, and deadlocks.

Performed Database administration including monitoring and tuning, job automation, maintenance task, backup recovery, analyze database performance.

Created and Managed Jobs, Setup Alerts, SQL Mail Agent and Scheduling SSIS Packages.

Implemented SQL Server security and Object permissions.

Implemented TDE, and closely worked with System Admin to setup IPSec and SSL.

Installed, Configured, Developed and administered SQL Server Reporting Services (SSRS).

Environment: SQL Server 2012, 2008 R2, 2005, Windows server 2012, 2008 R2, 2003

Education:

Bachelor of Information Technology, CPU COLLEGE, Ethiopia

Certifications and Training:

MCITP (Microsoft Certified IT Professional): 70-462 – SQL Server Database Administrator 2012/2014.

MCITP (Microsoft Certified IT Professional): 70-463 – Implementing a Data Warehouse with SQL Server 2012/2014.

MCITP (Microsoft Certified IT Professional): 70-461 – Querying Microsoft SQL Server 2012/2014.

MCSA ( MICROSOFT CERTIFIED SOLUTIONS ASSOCIATE)

Security clearance: clearable

Citizenship: U.S citizen

Contact this candidate