SUMMARY

• 5+ years in - depth experience in managing and Administering multiple MS SQL Server 2005/2008/R 2/2012/2014/2016 servers with very large OLTP Databases in development, testing/QA and production environments while ensuring their performance, high availability and internal/external security.
• Logical and physical planning of relational databases; manage internal databases from planning and testing stages through implementation and support.
• Develop Integration Services Packages and performance efficient ETL Process.
• Expertise in creating database objects and structures including databases, tables, indexes, views, snapshots, stored procedures, triggers, functions and cursors.
• Experience in developing TSQL scripts and stored procedures to perform administrative tasks and multiple DDL, DML, and DCL activities to carry out business requirements.
• Experience in performance tuning / analysis, troubleshooting and query optimization using native tools like MSSQL Server Profiler, Activity Monitor, Performance Monitor, Event Viewer, Index Tuning Advisor, Database Tuning Advisor (DTA), Dynamic Management Views (DMV), Dynamic Management Functions (DMF), TSQL scripts, Triggers, and Store Procedures, Services and Protocols, and Configuration Manager.
• In-depth understanding of user management and database security at different levels to ensure database integrity and secure databases from unauthorized intrusions and data corruption.
• Experience in designing, implementing and maintaining high availability and disaster recovery plans including: back-up and restore, log shipping, replication (transactional/merge), database mirroring, failover clustering and Always-on.
• Experience in automating maintenance jobs in SQL Server job agent and task scheduler: such as Shrinking database, index rebuilding, creating filtered indexes, index reorganizing, cleaning up, updating statistics and full, differential and transactional log backups and other SSIS package tasks.
• Experience in creating, managing and delivering server based reports with interactive views that provide valuable insight for business heading using MS SQL Reporting Services (SSRS).
• Excellent communication, coordination, presentation and analytical skills; worked on 24X7 Production support, involved in an on call rotation.

TECHNICAL SKILLS

Operating Systems: Windows Server 2003/2008/2008 R2/2012/2012 R2, Windows/ XP/Vista/7/8/8.1/10.

DBMS: MSSQL Server 2000/ 2005/2008/2008 R 2/2012/2014/2016.

ETL Tools: DTS (Data transformation services), MS SQL Server Integration Services (SSIS).

Reporting tools: SAP Crystal Report, MSSQL Server Reporting Services /SSRS/, Power Pivot.

Data modeling tools: ERWin and SQL Server Database Diagrams(ER diagram).

Programming Languages: T-SQL, HTML, XML, Power Shell, C, VB.NET, ASAP.NET Microsoft.NET, JDBC, C++, Java. Objective C, Swift, and C #.

Network Topologies: TCP/IP, FTP, SMTP

Third party tools: Symantec, Redgate, Idera Diagnostic Manager, Idera Frag Manager Spotlight.

Applications: IIS, Visual Studio, FTP, Adobe Photoshop suite, Dreamweaver,SharePoint.

Networking: SAN, NAS, LAN, WAN.

PROFESSIONAL EXPERIENCE

Confidential, Alexandria, VA

SQL Server DBA

Responsibilities:

• Experience in SQL Server Database management, administration and maintenance.
• Work with a team of ETL developers, application developers, network engineers, server administrators, system analysts and testers.
• Implemented SSIS and configured, deployed and managed SSIS package and projects.
• Extensively used various SSIS objects such as Control Flow Components, Dataflow Components, Connection managers, Logging, Configuration Files carrying out ETL processes.
• Developed, Deployed, and Managed - Foreach loop Container, Bulk Insert Task, Data Flow Task, Execute SQL Task, Transferring Files, File System Task, and FTP Task.
• Designed and deployed ETL solutions in SSIS and created SQL Server Agent jobs.
• Exported & Imported data from Flat file, CSV file, My-SQL, and Access to/from SQL Server Database using DTS, SSIS, and BCP.
• Data Migration to and from various sources using SQL Server Integration Services (SSIS).
• Implement database refresh using SSIS packages and automated backup/restore jobs.
• Architects, monitors, and maintains the Microsoft SQL Server Database environments which support applications.
• Developed datasets to perform reporting and created interactive Drill down, Drill through, Tabular, Cross tab, Parameterized, Cascaded and Sub- reports, Report models and Ad-hoc reports using SSRS.
• Developed new mappings using SSIS Look Up/Aggregation transformations to match the needs of the business case and schedule SSIS packages usingSQLServer Agent.

Confidential, Addis Ababa, Ethiopia

SQL Server DBA Consultant

Responsibilities:

• Installing, configuring, administering and securing test, development and production servers.
• Responsible for SQL server Conceptual, logical and physical database design, implementation, and maintenance.
• SQL Server 2005/2008/2008 R 2/2012/2014/2016 installations, patches and upgrades, including both standalone and clustered environments of production, test and development.
• Scheduling and automating full/differential/ transactional backups and implementing recovery strategies.
• Create Databases, Tables, Indexes, Stored Procedures, Views, database management policies and Constraints, Defaults, Rules, Functions, Triggers, Cursors and Dynamic SQL queries.
• Design, implement and manage database maintenance and disaster recovery plans including replication, full /differential /transactional log backups with recovery procedures.
• Using dynamic management views (DMV) and Dynamic Management Functions (DMF) troubleshoot and tune performance that include finding out long running queries and query costs.
• Configured SMTP Server for Database Mail setup and received Alerts.
• Auditing of database for logins, users transactions, and database activities and resolving orphan users.
• Implement database refresh using full export for table level and full database.
• Automate maintenance jobs in SQL Server job agent and task scheduler: such as shrinking database, index rebuilding, creating filtered indexes, index reorganizing, cleaning up, and updating statistics.
• Set up and manage transactional log shipping, SQL Server Mirroring (Synchronous/ Asynchronous), Fail over clustering and Transactional replication in multiple environments as part of disaster recovery plan and load balancing strategy.
• Manage users and groups (roles) from Active Directory or SQL, provide appropriate server roles, map them to specific databases and grant specific privileges over selected database securable objects to ensure security and integrity.
• Performing on backups, DBCC utilities, updated index statistics, monitored database and disk space.
• Monitoring SQL server performance using profiler to find performance, deadlocks, blockings and Capturing long running SQL queries for fine-tuning SQL statements that better result in efficient SQL statements processing.
• Extensively used SQL native tools like Index tuning wizard, Database tuning advisor (DTA), SQL profiler, Performance monitor, Activity monitor, Event viewer, dynamic management views and dynamic management functions for monitoring, performance tuning/analysis and troubleshooting.
• Develop TSQL scripts to create database objects and perform DML and DDL tasks.
• Create Databases, Tables, Indexes, Stored Procedures, Views, database management policies and Constraints, Defaults, Rules, Functions, Triggers, Cursors and Dynamic SQL queries.

Confidential, Addis Ababa, Ethiopia

Project Assistant

Responsibilities:

• Responsible for Planning, scheduling, supervising, implementing, monitoring and evaluation of administration and project works of the program in Head office and in different regions.
• Conducting tasks according to company procedure and policies.
• Tracking project expenditures; Payment preparation for these project expenses and pass on finance division to be refunded.
• Gathering, analyzing and interpreting data in a systematic and scientific manner and budget preparation.
• Preparing and generating monthly inventory and variation report in time manner.
• Cross functional tasks within the company and with other company’s clients.
• Assisting staff and other stakeholder’s ongoing capacity building and developments through effective and collaborative work with designated experts to achieve the same high standards locally.