Over 6+ years of professional experience as a SQL Server Database Administrator with proficiency in managing very large and highly transactional database systems. Expertise in Database Administration on Production Servers with Server Configuration, Performance Tuning and maintenance with outstanding troubleshooting capabilities. Experience on High Availability/Disaster Recovery (HADR) solutions; Failover Clusters and AlwaysOn Availability Groups, Replication, Log Shipping and Mirroring. Experienced in Upgrade/Migration of MS SQL Server 2008 to MS SQL Server 2008R2, from SQL Server 2012 and SQL Server 2014. Experienced in installation, configuration, maintenance and optimization of SQL Server HADR solutions. Experienced in Backup and Recovery, Query Optimization and Security. Experienced in monitoring the health and performance of SQL servers as well as home grown applications using SQL Server native tools and several other third party solutions. Adept at T-SQL, stored procedures, tables, indexes, views, functions, and triggers. Created various SSIS, SSRS and SSAS Packages to serve company needs. Expert in using DTA/Extended Events/PerfMon/SQL Profiler/Scripts and other third party tools to resolve bottlenecks, Deadlocks and slow running queries. Able to benchmark and load test new instance builds for performance with DB load simulators. Responsible for securing SQL Server, user management, assigning permissions and roles. Strong System Administration background in Windows and Linux environments. Experienced with Development/Test/Production QA which included documentation of processes, creation of test scenarios and execution of tests, via T-SQL scripts, to ensure UI standards met the required specifications. Experienced in creating technical documentations and process archiving and change management. Experienced in working independently as well as in team-oriented environments. Experienced in supporting and maintaining large databases and troubleshooting their problems. * Knowledge on cloud computing technologies such as AWS EC2 and Azure. Team player, willing to share and develop my knowledge and experience
Capacity management *
Data Modeling * Installation and Configuration *
Backup/Restore * Updates and Patches *
Security * Performance Tuning *
SSRS/SSIS * Automation *
Virtualization- Vmware/Hyper-V * AlwaysON *
Azure * SQL Failover Cluster *
AWS EC2/RD/S3 * Log Shipping *
IIS Languages: *T-SQL, PL/SQL, HTML, VB, .NET, Java, PERL, ASP, PHP and XML
Reporting & Audit Tools:* SSRS, Report Builder and SSDT, Idera SQL Compliance Manager and SQL Secure
RDBMS and Tools:*SQL Server 2005/2008/2008R2 /2012 /2014, MS Access 2007/2010/2013, Oracle 11gR2,
Backup Software:* SQLBackup, Lite Speed, Red Gate, Idera SQLSafe, and Backup Exec.
ETL Tools:* SSIS, BI (BIDS/SSDT).
DB Query Tools:* MS SQL Server Query Analyzer, SQL Profiler, ETL, SSMS, Enterprise Manager, PL/SQL Developer, Toad for SQL/MySQL/Oracle.
Data Modeler:* SSAS, SQL Developer Data Modeler, TOAD Data Modeler.
Operating System:* Windows 7,8, 10, Windows 2003, 2008R2 and 2012R2 servers
SQL DBA GEICO – Chevy Chase,
Involved in developing logical design and physical design.
Created Documentation for steps need to be taken while upgrading.
Installed and configured MS SQL Server 2016, 2014.
Migrated SQL server 2008R2 to SQL server 2016.
Administered and maintained production/Development servers with more than 2 TB of database size with complex structures.
Designed a report on the monitoring of SQL Server Performance.
This report gives a detail report to the management on the Performance of the server.
Worked with SQL server Profiler to generate traces.
Integrated SQL server profiler traces with Performance monitor to have better graphical analysis to find system bottlenecks.
Identified long running stored procedures and SQLs using profiler and fine-tuned for maximum performance.
Expertise in setting up and troubleshooting Database mirroring.
Daily routine Developer/DBA tasks like handling user's permissions and space issues on Production and Semi- Production Servers and handling maintenance Jobs.
Use SQL Server RML Utilities to do performance baseline analysis report between the SQL Server 2005 and SQL Server 2008R2.
Extensively worked on IMS performance issues like update statistics, reorganizing and rebuilding the indexes at regular intervals for better performance.
Created Database Maintenance Planner for the Performance of SQL Server which covers Database Integrity Checks.
24/7 on call support, created various jobs to check health of the server and to troubleshoot.
Export or Import data from other data sources like flat files using Import/Export through, SSIS.
Huge data of Insurance policies and customer information in XML, Flat file data transformation using SSIS Packages.
Developed SSIS packages, stored procedures, functions, triggers.
Tuned servers to the peak for maximum performance by configuring memory and various server level parameters.
Hands of experience in writing batch files.
Worked closely with application development and support team to understand their requirements and provide timely solutions, for both current and future projects.
Configured and monitored Replication, Mirroring, Always ON clusters.
Data Modeling Experience including Physical and Logical data modeling using Erwin tool.
Extensively used repositories like Team Foundation Server (TFS), and Visual Source Safe.
Environment: Windows Server 2008 R2, Windows 2012 R2 Server Database: MS SQL Server* 2008R2/2014/2016 Monitoring and solving incident tickets, change requests and service calls in 24/7 environment, adhering to SLAs.
SQL DBA Wells Fargo – Washington, DC
As a production L2 support, I was responsible for resolving incident tickets escalated from L1 support and handling critical incidents (Sev1, Sev2 high).
Provided SQL Server implementation changes requested from application teams Responsible for installing, configuring, and maintaining as per supported LOB applications.
Writing and improving SQL Server T-SQL queries.
Created necessary T-SQL scripts, stored procedures, tables, views, functions, triggers and indexes.
Responsible for providing SQL Server problem resolution and 24x7 production support and server outages.
Responsible for disaster recovery and high availability solutions and large scale database migrations from SQL server 2005 to SQL server 2008R2 and 2012.
Created and migrated partially contained databases within AlwaysOn Availability Groups.
Created automation of day to day operations, critical SQL server alerts and repetitive tasks.
Monitored the health and performance of SQL, server instances and home grown applications using Extended Events, SQL server Profiler, PerfMon and other third party tools.
Tested newly built servers for performance impact with DB load simulators.
Setup and maintained Log Shipping between various environments.
Worked on Dev/Test/Prod environments which included documentation of processes, creation of test scenarios and execution of tests, via T-SQL scripts, to ensure UI standards met the required specifications.
Created necessary T-SQL scripts, stored procedures, tables, views, functions, triggers and indexes.
Operated and oversaw database and log backups and Optimized the Indexes, adding/deleting them when necessary for better performance.
Verified backups and error logs on the servers and troubleshoot any failures or alert problems, and open trouble tickets if necessary to work with technicians from other departments.
Responsible for Installing, configuring and maintaining SQL failover clustering for production environments.
Worked with installation, configuration and creation of SSRS.
Decided whether clustering, log shipping, mirroring, replication, etc are the right fit to solve a business problem.
On-call troubleshooting for SQL Server service outages.
Responsible for securing SQL Server, user management, and taking care of permissions and roles.
Environment: Microsoft SQL Server 2014/2012/2008R2 Enterprise and Standard Editions, Windows* 2012/2008R2, Clustering, Always On, Mirroring, replication, SQL Server Management Studio, SQL Profiler, Performance Monitor, SSIS, SSRS, Microsoft Visual Studio 2012, TOAD for MYSQL, Microsoft Office 2013.
SQL DBA Intern & SQL DBA02/2010
to 08/2012 Ethio-telecom Addis
Installed and Configured SQL Server 2005/2008 R2 Responsible for MS SQL Server 2005 /2008/2008R2 database administration.
Diagnosed server problems and employed preventive measures to maintain high availability of MS SQL Server and Oracle databases.
Created database maintenance plans for SQL backups, optimization, and integrity check and t-log backups.
Worked on change requests, permission requests and refreshes requests.
Created checklists for proper/unattended install of SQL Server, applied service packs and security fix.
Configured and maintained Transactional, Snapshot and Merge replication.
Worked with SQL Disaster Recovery processes like Log shipping methodologies, clustering and mirroring.
Worked with capacity planning, database sizing and monitoring.
Performed critical Patch management.
Established and recommend policies on system use and services.
Provided emergency after hours support for mission critical applications and any upgrades/maintenance as required.
Provided records and data on specific performance/availability concerns as basis for problem identification/ resolution and management reporting.
Maintained user security and overall application and database data integrity, knowledge of SSL deployment and support in a SQL Server environment.
Used helpdesk software to manage support cases assigned.
Created databases, tables, indexes, stored procedures and triggers, alerts and maintained user permissions.
Worked with application team to test the successful upgrades, migrations and installations.
Maintained Operators, Categories, Alerts, Notifications, Jobs, Job Steps and Schedules.
Environment: SQL Server 2005, SQL server 2008, T-SQL, Oracle PL/SQL, Windows 2003/2008 Server,* Import & Export Data.
BS: Computer Science2009St. marry university college Addis Ababa-
Microsoft Certified Solutions Associate (MCSA): 2018-
.NET, application development, ASP, Automation, Backup Exec, Backup, BI, capacity planning, Clustering, Compliance Manager, Data Modeling, database administration, DBA, databases, Database, Disaster Recovery, Documentation, Erwin, ETL, XML, for MS, HTML, PHP, IIS, IMS, Insurance, Java, management reporting, memory, MS Access, Microsoft Certified, Microsoft Office, SharePoint, Windows 7, Windows, MYSQL, Enterprise, Olas, Operating System, optimization, Oracle, DB, Developer, Oracle PL/SQL, PL/SQL, peak, PERL, policies, problem resolution, processes, Project management, RDBMS, Reporting, Servers, Scripts, Shipping, Visual Source Safe, MS SQL Server, Microsoft SQL Server, SQL, SQL Server, SQL Loader, SSL, statistics, tables, TOAD, T-SQL, troubleshoot, troubleshooting, upgrades, upgrading, Utilities, VB, Microsoft Visual Studio, Windows Server