SUMMARY

• 7 +years of experience with Microsoft SQL SERVER database Administration, Development in SQL server 2008/2005/2000.
• Experience installing MS SQL SERVER 2000,2005,2008,2008 R2; updating with hot fix and service packs
• Extensive experience in implementing High availability solutions like different Replication models (Snapshot, Transactional and Merge), Log shipping, clustering and mirroring on physical and virtual machines.1
• Extensive Experience in Installation, Configuration and Maintenance of SQL Server in both 32bit and 64bit boxes.
• Experience in Database design, modeling (logical and physical), Normalization and Database Applications Development using varied development tools.
• Proficient in SQL Server 2008 new features like Policy Based Management, Data Compression, Resource Governor, Performance Data Collector and Transparent Data Encryption (TDE), Backup compression, and Performance Data Collection.
• Implemented the new SQL Server 2005 concepts like database mirroring, database snapshot, DDL triggers, DMV’s, DMF’s, Mail Setup, Jobs, and Alerts
• Handling Memory configurations for SQL Server 2000 and 2005 on Windows.
• Extensively worked on Performance Tuning analysis, Query optimization, avoiding deadlocks and blocking, Backups, Disaster Recovery Planning, Security Management, Managing server and clients, T - SQL, Stored Procedures, Functions and Triggers etc.
• Expertise in reading and understanding execution plan and fixing query to execute with low cost using joins like merge, nested loops depends on scenarios.
• Created Linked Servers between SQL Server 2005 & Oracle.
• Expert in extracting from different sources, transforming and loading data using transformation services like data transformation services like Import/Export, SSIS, DTS, BCP and Bulk Insert.
• Expert in using Native tools like SQL server profiler, database tuning advisor, perfmon.
• Experience in Migrating DTS 2000 packages to SSIS packages in 2005 using Migration Wizard.
• Dexterous developer in creating Constraints, Defaults, Rules, Tables, Indexes, Views, Stored Procedures, Functions, and Triggers.
• Performed BCP, BULK INSERT, Imported and Exported data from different Data Sources.
• Experience in Normalization, Database design, Performance Analysis and Production Support for large Databases.
• Experience in SQL Upgrades SQL and .
• Experience in Backing up, restoring the data base manually and also by scheduling the jobs and Maintenance Plans.
• Expertise in Identifying the bottlenecks caused by complex queries using Activity Monitor/SQL Profiler and handling them by implementing better Query Execution plans
• Extremely motivated, diligent, conceptually strong team player with an ability to take new roles and Ability to adapt quickly to changing environments.

TECHNICAL SKILLS

Operating System: Windows 2000, Windows NT, Windows Server 2003/2008/2008 R2, Windows 95/98/XP/Vista/7, LINUX, UNIX

Databases: MSSQL Server 2008R2/2008/2005, MS Office Access 97/2000/2003/2007.

Languages: T-SQL, Visual studio2005/2003

Technologies: Microsoft Office Suite

Tools: SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), Data transformation services (DTS), SPSS, and Visual Studio 2003/2005

PROFESSIONAL EXPERIENCE

Confidential, Seattle, WA

SQL Server Database Administrator

Responsibilities:

• Managed and Administrated SQL Server 2008/2005 production and Non-production servers.
• Installed and configured SQL server 2008 in non-clustered environments. Documented the installation and configuration.
• Analyzed SQL Servers and Databases and came up with a plan for consolidation based on usage, performance, and compatibility.
• Implemented and Maintained routine DBA tasks like scheduling jobs, creating maintenance plans. Checked servers for optimizations and implemented them.
• Performed daily tasks including backup and restore by using SQL Server 2005 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.
• Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.
• Used native tools like DATA BASE TUNING ADVISOR, PROFILER, PERFORMANCE MONITOR and ACTIVITY MONITOR for performance tuning.
• Designed and implemented comprehensive Backup plan and disaster recovery strategies.
• 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.
• Scheduled the backups for Databases and Transaction log. Performed restoration operations
• Configured and deployed SSIS Packages from Test to Production Environments.
• Analyzed Access database usage and migrated databases to SQL.

Environment: SQL Server 2005, 2008 Access, Windows 2000, 2003, 2005 and 2008 Servers.

Confidential, Seattle, WA

SQL Server Production DBA/ Developer

Responsibilities:

• Managed and Administrated the SQL Server 2008/05 production and Non-production servers.
• Installation of SQL Server 2008/05 on Windows Server Clustered environment.
• Worked on Conceptual, Logical, Physical data modeling and Performance Analysis.
• Performed backup using backup compression and Data compression in SQL Server 2008 on clustered environment and SQL Server 2005 security Audit.
• Application support for front end feeds and Resolved Application connectivity issues like connection timeouts, connection pooling issues and memory leaks.
• Monitored Log shipping/ Transactional Replication and trouble shooting of errors.
• Migrated SQL Server 2000 databases to SQL Server 2005 databases including DTS to SSIS packages.
• Upgraded/Migrated SQL Server 2005/00 databases to SQL Server 2008 databases.
• Worked on SSIS packages using different control flow tasks, Transformations and dataflow tasks.
• Created, scheduled database maintenance plan task.
• Configured and deployed SSIS Packages from Test to Production Environments.
• Deployed database objects from development/testing environment to production environment.
• Extensively worked on Profiler, DMVs, DMFs and DTA to tune the databases, servers and query tuning.
• Created/altered/modified and tuned T-SQL Stored Procedures, Complex Queries, views, tables, and functions on OLAP environments like Data warehouse and reporting.
• Reviewed stored procedures developed by the developers and given recommendations for the code modifications for production.
• Managed Security using SQL Logins, Roles and Security Modes for various users.

Environment: SQL Server 2008/05, Advanced Windows 2008/03 server, XML, SQL Profiler, T-SQL, SSIS, MS- Excel.

Confidential, Addis Ababa, Ethiopia

SQL Server Production DBA/ Developer

Responsibilities:

• Installed and configured SQL Server 2000 and SQL Server 2005.
• 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.
• Provided necessary data validation checks against the data entry.
• Frequently ran DBCC checks to maintain consistency.
• 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.
• Used Performance monitor and SQL Profiler to optimize queries and enhance the performance of database servers.
• Managed the migration of SQL Server 2000 databases to SQL Server 2005