Sql Server Developer

S U MMARY/ P ROF ES S I ONA L P ROF I L E

• Experienced SQL Server Database Administration for over 7 years in SQL Server 2005/2008/2012

• Extensive knowledge of Relational Database Management Systems with in depth knowledge of T-SQL

• Experience in migrating SQL Server 2005 databases into SQL Server 2012

• Expert in Data Extraction, Transforming and Loading (ETL) using SSIS

• Experience in Creating, Publishing reports and administering SSRS

• Experience in configuration of native and SharePoint integrated mode SSRS

• Experience in using third party tools like Idera and Redgate as well as native tools such as Windows Performance Monitor and

SQL Profiler for Monitoring and Tuning MS SQL Server Performance.

• Experience in Performance Tuning, Query Optimization, Client/Server Connectivity, Database consistency checks

• Motivated, diligent, strong team player with Solid analytical and problem-solving skills.

TECHNICAL SKILLS

• Database Management Systems: MS SQL Server 2000/2005/2008/2012, MySQL, MS Access 2003/2007/2010

• Query Languages : SQL/T-SQL

• Programming Languages: C++, C#, VB, VB.Net, VBScript

• Web Technologies :HTML, XML, PHP

• Development Environment: SSIS, SSAS, SSRS

• Databases Technologies : ADO, ADO.NET, ODBC, OLEDB

• Software Design Methodologies: OOAD, UML, DFD, Data Dictionary, ERD, Work Flow Diagrams, Process Specification,

SDLC

• Data Modeling Tools: MS Visio, ER-Assistant

• Development Tools: MS Visual Studio 2005/2008, Microsoft Team Foundation Server 2010

• Application and Third Party Tools: MS Office Suite, Red Gate,Quest, Idera software,

• Report Writers : Report Designer, Report Builder, Seagate Crystal Report 7.0/8.0

• Server Operating Systems :Windows Server 2000/2003/2008R2

R E L E VA N T E X P E R I E N C E

CFF, Bethesda, MD April 2013 Present

SQL Server DBA/Developer

• Installed & configured SQL Server 2005/2008/2008R2/2012 and associated native and third party database tools

• Migrated SQL Server 2005 SSIS packages into SQL Server 2012 SSIS packages and deploying SSIS packages to production

servers.

• Conducted root cause analysis for database incidents and problems.

• Performed database/infrastructure physical design and implement

• Perform database encryption using TDE

• Develop and Deployed SSIS packages.

• Write complex Queries, design and deploy reports using SSRS

• Installed, Configured, Designed, Created, managed security and maintained customized database-driven reports using SSRS

2005/2008/2008R2/2012

• Identified, tested, and resolved database performance issues (monitoring and tuning) to ensure database optimization.

• Created SQL Server Agent jobs to automate different activities such monitoring database health, disk space, job alert, index

monitoring, stats monitoring

• Created Users and Roles, and managed security and permission of database.

• Documentation of all the processes involved in maintaining the database for future reference and disaster recovery.

• Developed, tested & implemented a robust database backup and recovery strategy with client assistance.

• Set up high availability technologies such as Mirroring, Log shipping, failover clustering and Replication

AMCAD, Herndon, VA June 2012 – March 2013

1

SQL Server DBA/SSRS Developer

• Installed, Configured, and Managed SQL Server 2008R2, 2008 & 2005 in development, test, and production environment

• Enhanced database performance, implemented recovery procedures, handled performance tuning and conduct regular system

backups and recoveries.

• Ensured technical and functional designs met business requirements

• Installed, Configured and Maintained, Log Shipping, Database Mirroring, failover clustering in SQL Server 2008

• Applied appropriate service pack on SQL Server 2005, 2008, 2008 R2 when required

• Managed logins, roles, and groups to the MS SQL Server and maintaining proper security procedures.

• Assisted Database Developers to optimize SQL queries and Stored Procedures

• Scheduled jobs to automate different activities such monitoring database health, disk space, job alert, index monitoring, stats

monitoring

• Created and managed Object, Schema, Indexes, Constraints

• Configured, Designed, created, and maintained standardized and/or customized database-driven reports using SSRS 2005/2008

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

• Developed Reports for different purposes like DBA Reports, user reports using SSRS and Report Builder 3.0 & 2.0

• Deployed Reports and managed security of report servers

• Developed detail and summary reports, line and pie charts, trend analysis reports and sub-reports according to business

requirements using SSRS

Ghion Money Transfer Inc. Falls Church November 2011 June 2012

SQL Server DBA /Developer (SSRS/SSIS)

• Installed and configured new SQL Server 2005 Database Server instances, SQL Server Integration Services (SSIS), SQL Server

Reporting Services (SSRS) for Development, Testing and Production Environment.

• Worked on Log shipping, mirroring and transactional replication.

• Prepared and implemented back up strategy, maintenance plan, and disaster recovery strategy

• Designed logical and physical data model using MS Visio.

• Developed complex SQL stored procedures, functions, and triggers according to the specs joining different tables and views.

• Created, deployed and managed SSIS Package

• Monitored execution of SQL agent jobs on daily basis.

• Checked the database consistency using DBCC commands and resolved various performance issues using SQL tools like SQL

Tracer and SQL Profiler.

Blue Cross Blue shield (BCBS), Durham, NC Sept 2010 – November 2011

SQL Server DBA/ Database Performance Tester

• Created Database Objects like Tables, Stored Procedures, Views, Triggers, Rules, Defaults, user defined data types and

functions.

• Implemented database standards and naming convention for the database objects.

• Developed SQL scripts for maintaining administration tasks.

• Maintained all the SQL documents include installation and data conversion Procedures documents.

• Performed maintenance tasks and devise point in time recovery plans and Troubleshooting critical production problems;

• Performed Load and Performance test of software

• Wrote Test Plans and developed test Strategy, Procedures and developed test Script and Executed for database

performance/load test

Addis Ababa University, Addis Ababa, Ethiopia Dec 2006 – May 2010

SQL Server DBA

• Installed, Configured, and Managed SQL Server 2005 in development, test, and production environment

• Managed Backup/Restore, Point-in-Time Recovery including backup verification

• Managed Server, Database Roles and Security for different users and user groups

• Setup automated jobs for different purposes including backup, monitoring database health, disk space, backup verification,

moving databases from environment to environment including creating test environment

2

• Developed Different Maintenance Plans such as backups, index management, fragmentation management, cleaning history,

deleting old files

• Monitored Server Activity, Error Log, space usage, and solving problem as needed

E D U CAT I O N

• Masters of Science in Information Science, Addis Ababa University, Addis Ababa, Ethiopia

C E R T I F I C AT E S O F E XC E L L E N C E

• PRO: Designing, Optimizing and maintaining a Database Administrative Solution using Microsoft SQL Server 2008

• Microsoft Certified Technology Specialist on Microsoft® SQL Server™ 2008 - Implementation and Maintenance

3

Contact this candidate