ZEWDE

SQL DATABASE ADMINISTRATOR

E-MAIL: abob7p@r.postjobfree.com

CELL: 214-***-****

Objective

Seeking a SQL server DBA position with new challenges and opportunities to

build upon my extensive knowledge and experience in MSSQL Server

2012/2008R2/2008/2005/2000 in the areas of Installation, Configuration,

Development, Maintenance, Performance Tuning, Backup and Restore, Disaster

Recovery, Security, Data Transformation, Reporting Services and Business

Intelligence Configuration.

EDUCATION

. M.Sc. (Communication Engineering), Addis Ababa University, Addis Ababa,

Ethiopia, 2007.

. B. Sc. (Electrical Engineering), Bahir-Dar University, Bahir-Dar,

Ethiopia, July 2002.

TECHNICAL SKILLS

> Databases - MS SQL Server 2008R2/2008/2005/2000, MS Access.

> SQL Server Tools - Enterprise Manager, Profiler, Query Analyzer,

Export & Import, DTS, SQL Server Management Studio, Reporting

Services, SQL Server Integration Services, Analysis Services.

> Operating Systems - Windows Server 2003, Windows 2000 Advanced Server,

Windows NT 4.0, Windows XP/2000/ME/98/95, MS-DOS, Linux.

> Languages - T-SQL, MDX, XML, VB, C/C++, Java, Pascal.

PROFESSIONAL SUMMARY

> Seven plus years of experience as a SQL Server Database

Administrator.

> Extensive experience with SQL Server Upgrade/Migration, Business

Intelligence/Data warehouse, Database Architecture and Datacenter

Experience.

> Sound knowledge of Sarbanes-Oxley Compliance requirements and HIPPA

compliance

> Experience with Microsoft Clustering Services and SQL Server

Clustering.

> Experience in SQL Server Partitioning, Partition Functions, Partition

Schemes and Managing Partitions.

> Experience in the Installation, Configuration of MS SQL Server

2000/2005/2008 and Migration of SQL Server 2000/2005 to SQL Server

2008.

> Experience in routine Database Backup/Recovery procedures & 3rd party

tools.

> Experience in supporting the development of IT and Database

Architecture and Physical Data Models and Creating Data Models with

ERWIN and ER/Studio.

> Experience using Data Transformation Services (DTS), Upgrading DTS to

SSIS Experienced in and working with Bulk Copy Process (BCP).

> Performance Tuning, Query Optimization, Client/Server Connectivity and

Database Consistency Checks using DBCC Utilities.

> Knowledge and experience in dealing with Relational Database

Management Systems, including Normalization, Constraints, Querying,

Joins, Keys, Indexes, Data Import/Export and Capacity Planning.

> Experienced in using Performance Monitor/Profiler to resolve System

bottlenecks and Dead Locks/Long-Running Queries.

> Experience working with SQL Server Integration Services (SSIS), SQL

Server Reporting Services (SSRS) and knowledge in Analysis Services

(SSAS)/OLAP Cubes.

> Experienced in executing Stored Procedures, T-SQL Queries, MDX and

Triggers.

> Experience in implementing Log Shipping along with different types of

Replication Models, namely Snapshot, Merge, and Transactional.

> Knowledge of Redundant Array of Independent Disks (RAID) system and

levels.

> Unifying business Process using Service Oriented Architecture (SOA).

> Extensive knowledge of Windows server 2003, Windows 2000 Advance

Server and Windows NT and dealing with such issues as domain access,

user profiles, hardware/software installation & configuration.

> Knowledge of Unified Modeling Language (UML), including Use Cases,

Sequence, Work Flow Diagrams and Activity diagrams.

Work Experience

UniFocus, Irving, TX

Oct' 10 - Present

SQL Server Development Database Administrator

UniFocus, a performance-management firm in the hospitality industry,

acquired Telman Software to enhance UniFocus real-time, dynamic information

systems. UniFocus integrated Telman's financial expertise and Focused

Scorecard database into its own systems.

Responsibilities:

> Worked in Sql Server 2000/2005 with 2 TB of Data and SAN infrastructure

of 60 Server 2 NODE cluster Active / Active and Active/ passive on

Microsoft Windows Server 2003 R2 Enterprise Edition SP2 on SAN

environment

> Migrated DTS packages from Sql Server 2000 to SSIS SQL server 2005.

> Created Documentation for steps need to be taken while upgrading the SQL

server 2000 to SQL server 2005.

> Performed BCP extracting the zip file and used the xp_cmdshell for the

bulk operation.

> Utilized foglight, profiler, Perfmon for monitoring the deadlocks,

blockings and windows level performance also.

> Conducted Consistency Checks on the database and analyzed the

fragmentation on the indexes.

> Worked with Transactional Replication to achieve Load balancing.

> Created several stored procedures, triggers, views.

> Created ADHOC reports using SSRS in BIDS.

> Reviewed Store Procedures and Queries fine tuned the Slow Running

Queries.

> Implemented Maintenance Plan tasks like History Clean Up and Rebuilding

the Indexes in SSIS.

> Detected and Resolved locks and Deadlocks using the Trace Flags and

Native tools like Profiler and the Activity Monitor.

> Creating Logins and Mapping the User to Roles by Assigning Permissions.

> Development and Atomized Administration and Maintenance Plan for SQL

Server 2005.

> Troubleshooted SSIS packages which failed to execute in the Scheduled

Jobs.

> Developed CLR Functions to replace earlier application modules and

integrate assembly using Service Broker Feature Available in SQL Server

2005.

> Creating Stored Procedures to convert database tables into XML format and

display via web.

> Collected business requirements, designed data maps and data models.

Created Internal and External Design Documents and Transaction Definition

Documents.

> Used DTS Xchange tool for Migrating DTS packages to SSIS.

> Development of DTS Packages using DTS Designer for Extraction,

Transformation and Loading (ETL) for extraction, transfer and load (ETL)

of existing data into SQL Server

> High Level Design of ETL DTS Package in SQL server 2005 for integrating

data from heterogeneous sources (Excel, CSV, Oracle, flat file, Text

Format Data).

> Used Notification Services Available in SQL Server 2005 to create alerts

and email notification.

> Worked on Veritas Netbackup 6.0 for Database backup and recovery

solution.

> Involved in change management process like releasing the report into the

production Report server by deploying the code using the TFS.

> Configured the Protection levels for the SSIS packages while moving from

Staging to Production

> Involved in 24/7 production support.

Environment: TSQL, MS SQL SERVER 2000/2005,SSRS, VISUAL STUDIO 2005,

VB.NET,C#, ADO.Net, XML,MS WINOWS SERVER Enterprise Server

2008/2003/2000,IIS 6.0,SSIS

Consolidated Graphics (CGX), Houston, TX

Aug' 2009 - Sep' 2010

Role in project: SQL Server DBA

Consolidated Graphics has the largest and most technologically advanced

sheet fed printing capabilities in North America, a sizeable and

strategically important web printing capability, industry-leading digital

printing services, a rapidly growing number of fulfillment centers and

proprietary Internet-based technology solutions. At Consolidated Graphics

managed and took care of Day to day operations for Consolidated Graphics

Enterprise Database and Data warehouse applications.

Responsibilities

> Installations, configuration and up gradation of SQL Server software,

Service Packs and Hot fixes.

> Administer SQL servers located within Consolidated Graphic's data

center and specific servers within the regional offices and other

entities.

> Installation, Upgrade, Migration and applying Service Packs for SQL

Server Database, SSIS, SSRS Software.

> SQL Server 2008/2005/2000 Clustered Resources and Single Server

Instances.

> Setting up of Database Maintenance Plans or creation of SQL Jobs for

DBCC, Database reorganization etc.

> Implementing and Database availability with Cluster Management,

Database Mirroring, Log shipping, Replication.

> Performed database refreshes including BCP operations.

> Setting up of Database Replication, DR database setup and monitoring.

> Monitoring SQL Server Error log, Database, SQL jobs Monitoring and

troubleshooting to fix the errors.

> Coordinated with developers for Optimization and improvements of

Database Design.

> Database User, Security Administration and audit setup.

> Worked with support groups for smooth functioning of the SQL Server

Environment.

> Monitored LiteSpeed Backup activities on all installed servers.

> Involved in Applying of LiteSpeed Upgrades.

> Performed Object Level Recoveries using LiteSpeed.

> Involved in Trouble shooting and resolved Backup solution issues.

> Monitored Backup's are successful in DEV, TEST, and PROD environments.

> Performed root cause analysis for problems

> Worked collaboratively with development staff toward resolution,

provided advanced tuning expertise.

> Provided support for system management and monitoring tools.

> Installation and configuration support for Compliance Manager,

Diagnostic Manager, DB Artisan, MS Operations Manager

> Responded to all non-critical system alerts in a timely manner

> Managed of User and Role Creation and system privileges.

> Worked with the business to forecast and address database capacity

planning challenges.

> Supported applications including People-Soft, SharePoint, Business

Objects and Raisers Edge.

> Prepared and maintained updates on system documentation.

> Used performance Monitor/Profiler to solve Dead Locks/Long running

queries.

Environment: SQL Server 2008(R2)/2005/2000, T-SQL, Management Studio,

Integration Services/DTS, BCP, Bulk Insert, Bulk Load, Analysis Services,

SQLXML, Erwin, Visio.

Boardwalk Pipeline Partners, LP Houston, TX,

Jan' 2008 - Aug' 2009

Role in project: SQL Server DBA

Boardwalk Pipeline Partners, LP (NYSE: BWP) is a master limited partnership

engaged through its subsidiaries in the interstate transportation and

storage of natural gas. My day to day responsibilities touches primarily

every aspect of SQL server database administration. Tasks include but not

limited to SQL Server database systems planning, installation and

configuration, capacity planning, database and server level security,

backup and recovery, performance and tuning evaluation and implementation,

implementing high availability solutions for uninterrupted access of

database resources enterprise wide.

Responsibilities

> Administer SQL servers located within John Hancock data center and

specific servers within the regional offices and other entities.

> Scheduling Backup and Restoring of Databases.

> Managed Database Users and security

> Production support as per on call basis

> SQL Server 2008/2005/2000 Clustered Resources and Single Server

Instances

> Administered MS Reporting and Analysis Services

> SQL Server jobs monitoring, Job failures and root cause analysis

> Involved in Developing DTS, Integration Services packages for Data

Imports and Exports.

> Assisted application owners with DB design.

> Provided Backup/Restore Solution Support for all SQL Instances

> Performed DB Backups and Restores.

> Monitored SQL Error log, Event Log for error and issues

> Implemented Database Standards and policy among all the databases

> Involved in Trouble shooting and resolved Backup solution issues

> Monitored Backup's are successful in DEV, TEST, and PROD environments

> Installed and configured new SQL server instances

> Determine/Design drive layout and naming conventions

> Install and configure SQL server and related monitoring tools

> Developed scripts for specific monitoring solutions and process

automation

> Provided administration and support for Ad Hoc query users

> Granted user access to data

> Participated in Audit and provide information for Audit purpose and

implement Audit recommendation

> Provided high level connectivity support of query tools

> Provided the Service Desk with information required to support on-

going requests

> Implemented 3rd party client connectivity software (Oracle Client)

> Provided problem determination and resolution support for SQL server

related application problems

> Performed root cause analysis for problems

> Worked collaboratively with development staff toward resolution,

provided advanced tuning expertise.

> Provided support for system management and monitoring tools

> Installation and configuration support for Compliance Manager,

Diagnostic Manager, MS Operations Manager

> Responded to all non-critical system alerts in a timely manner

Environment:

SQL Server 2008(R2)/2005/2000, T-SQL, Management Studio, Integration

Services/DTS, BCP, Bulk Insert, Bulk Load, Analysis Services, Windows 2003,

Enterprise manager, DTS/SSIS, SQL profiler. MS Analysis Services,

Diagnostic Manager, MS Reporting Services, HTML, SQL Light speed Backup

Software

Jimma University Specialized Hospital

Jun' 2005 - Nov' 2007

SQL

Server Database Administrator

Jimma University Specialized Hospital (JUSH) is one of the oldest public

hospitals in the country. Currently it became the only teaching and

referral hospital in the southwestern part of the country. It runs an

annual governmental budget of 25.06 million Birr with bed capacity of 450

and a total of more than 750 staffs of both supportive and professional. It

provides services for approximately 9000 inpatient and 80000 outpatient

attendances a year coming to the hospital from the catchment population of

about 15,000 million people.

Responsibilities

> Maintaining the production database servers.

> Monitoring the growth of the database to ensure the smooth running

of daily activities.

> Taking full / differential database backups of all system and

production databases.

> Taking back up of system databases whenever changes are made to the

system databases or updates and service packs are applied to the

SQL Server

> Check the Windows 2000 Event Viewer for error messages.

> Check for adequate disk space for growing database files and log

files.

> Check SQL Server jobs (look for failures) and the SQL Server logs

for error messages.

> Controlling and monitoring user access to the database

> Import and Export data from one database to another database or to

another server using DTS

> Remove extra-unused space from the data and log files

> Evaluate possible approaches to increasing application and server

performance, based on the knowledge obtained from daily operational

activities

> Requirement gathering and analyzing data sources

> Assisted in design and implementation of Database

> Installation and configuration of SQL Server 2000 and 2005

> Design and implementation of Backup policies and Recovery

procedures

> Created stored procedures and triggers

Environment: SQL Server 2000 and 2005, Windows 2003

Ethiopian Telecommunication Corporation

Sep' 2002 - May' 2005

Role:- Jr SQL DBA

Ethiopian telecommunication corporation (ETC), now called Ethio-Telecom is

the sole telecommunication service provider in Ethiopia. Based in Addis

Ababa, it was the second-largest state-owned company in Ethiopia. It

provides fixed line, mobile, Internet and other special services to its

customers.

> Installed and configured SQL Server 2000

> Performed backups, DBCC utilities, updated index statistics, monitored

database and disk space.

> Created & maintained databases, users, Logins, tables, indexes, stored

procedures, roles, permissions and other schema objects.

> Monitoring SQL server performance using profiler to find performance,

dead locks, blockings and Capturing long running SQL queries for fine-

tuning SQL statements that better result in efficient SQL statements

processing.

> Interacted with development team and assisted them in optimizing SQL

Queries and Stored Procedures.

> Scheduled the backups for Databases and Transaction log. Performed

restoration operations.

> To set up SQL Server configuration settings.

> Designed and implemented comprehensive Backup plan and disaster

recovery strategies

> Rebuilding the indexes at regular intervals for better performance.

> Responsible for Stored Procedures optimization, Performance tuning &

index tuning.

> Frequently ran DBCC checks to maintain consistency.

> Used Performance monitor and SQL Profiler to optimize queries and

enhance the performance of database servers.

Environment: SQL Server 2000(Enterprise Manager, DTS, Performance monitor

and System monitor, Profiler, QA, Analysis Services), Windows 2000 Advanced

Server.

Contact this candidate