OBJECTIVE:

I am a highly motivated, tech - savvy and experienced Database Administrator/Developer with six plus years of experience in modeling, designing, deploying, maintaining, tuning and securing enterprise level Databases in MSSQL 2005, 2008, 2008R2 and 2012 on development, testing and production environments.

SUMMARY:

• Extensive knowledge and experience in installation, configuration and maintenance of Microsoft SQL Server 2005,2008, 2008R2 and 2012 and databases on Clustered and Non-Clustered environments.
• Experienced at relational and dimensional database modeling vis-à-vis normalization and de-normalization.
• Experience in Migrating from SQL server and by using in-place upgrade process as well as side-by-side upgrade process and documented complete upgrade Process.
• Performed acceptance testing to verify that database changes are applied without adverse consequences.
• Hands on experience in administering multiple MSSQL Server instances in a multi-site environment by implementing and supporting different High Availability & Disaster Recovery scenarios like Always-On Availability Groups(AAG), Clustering (Active/Passive), Replication models (Transactional, Snapshot), Log Shipping (Native and Custom) and Database Mirroring.
• Expertise in implementation of security models, database authentication modes, creation of logins, granting permissions and assigning roles to users on databases.
• Extensive experience working with Windows Server 2012, 2008R2 Enterprise Edition, Windows Server 2008 Enterprise Edition, Windows Server 2008 Standard Edition and Windows Server 2003 Enterprise Edition.
• Created effective Backup and Recovery plans by Transactional Log and Full Database Backups and utilized to recover data in 'Point in time' in case of disaster of server based on ERT (Estimated Recovery Time), RTO (Recovery Time Objective), and RPO (Recovery Point Objective) Policies.
• Experience in batch processes, Import, Export, Backup, Database Monitoring tools and Application support.
• Experience in troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues, replication issues, log shipping issues, security issues etc.
• Experience in Performance Tuning, Query Optimization, Client/Server Connectivity, and Database Consistency Checks using DBCC Utilities, Re-Indexing, Updating Statistics and performing Maintenance Tasks.
• Ability to detect and troubleshoot SQL Server related CPU, memory, I/O, disk space and other resource contention.
• SQL Development - ability to write and troubleshoot SQL Code and design stored procedures, functions, tables, views, triggers, indexes, constraints.
• Skilled at assessing client needs, working in a group, suggesting ideas that enhance efficiency and maximize performance, implementing cutting-edge technology solutions, and training/supporting end users.
• Excellent interpersonal, analytical and communication skills and capable of growing positive relationship with clients and colleagues at different levels of the organization.

TECHNICAL SKILLS:

DBMS: MS SQL Server 2005, 2008, 2008R2 and 2012

Database Tools: SQL Server Management Studio, SQL Profiler, Import/Export, SQL Agents, SQL Alerts, SQL Jobs, SQL Mail

Database designing tools and data modeling: ER Assistant, CA ERWin data Modeler

Third Party Monitoring Tools: Red Gate, SQL Sentry, Idera

PROFESSIONAL EXPERIENCE:

Confidential

Database Administrator/Developer, Silver Spring, MD

Responsibilities:

• Installation, Configuration, Upgrade and Patching of SQL Server 2012/2008R2.
• Installed SQL Server 2012 Cluster and configured Always On availability group set up on Windows Server 2008R2 in Development and Production environments.
• Migrating databases from SQL Server 2008R2 to 2012.
• Modeled data and design databases and access plans with ER/Studio and Erwin for trading applications.
• Configured, monitored, supported troubleshooting of database mirroring and log shipping for multiple databases on geographically separated cluster environments to provide High Availability and Disaster Recovery.
• Primarily responsible to design, implement and manage database maintenance and disaster recovery plans including replication, full /differential /transactional log backups with recovery procedures.
• Implemented Windows and SQL Server based security for all SQL services and SQL servers.
• Regular monitoring of servers, which includes but not limited to backup jobs monitoring, disk space monitoring, services monitoring, and blocking monitoring and troubleshooting using SSMS.
• Monitored Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers using DMV's. Extensively worked on Profiler, Perfmon Counters, DMVs, DMFs and DTA to tune the databases, servers and query tuning.
• Maintained database integrity by checking the allocation of structural integrity of user and system tables and indexes in the database using DBCC commands.
• Automate maintenance plan jobs in SQL Server agent and task scheduler: such as backup database, index rebuilding, creating filtered indexes, index reorganizing, cleaning up, and updating statistics.
• Creating and modifying Tables, Stored Procedures, Views, Indexes, User-defined Functions and Triggers as requirement on SQL Server environments.
• Supports day-to-day operational duties for the database platform such as service requests and tickets, as assigned or expected from DBAs.

Environment: Windows SQL Server 2012/2008R2, Windows Server 2003 Enterprise and Windows Server 2008R2/2012 Enterprise, SAN disk, Active Directory, Red Gate, SQL Sentry, Idera.

Confidential, Addis Ababa

Jr. Database Administrator Addis Ababa, Ethiopia

Responsibilities:

• Experienced in installing, configuring, applying service Packs/security updates and maintaining multiple instances on SQL Server 2005 and 2008R2.
• Migrated Databases from SQL Server 2005 to SQL Server 2008R2 in production and test environments.
• Develop and implement policies and procedures for ensuring the security and integrity of the databases.
• Responsible for tuning data, indexes, and queries as well as providing assistance on these areas to development teams.
• Identified performance bottlenecks and troubleshoot to improve database performance.
• Development of automated daily, weekly and monthly system maintenance tasks such as database backup, database integrity verification, indexing and statistics updates. Rebuild and reorganized. Indexes, checked DB consistency.
• Performed Backup and Restore and applied High Availability solutions (log shipping, mirroring and replication).
• Monitored Locks and Blocks, CPU usage, Storage usage, network failures.
• Monitoring the servers by using SQL Server 2008R2 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Tuning Advisor.
• Automate and enhance daily administrative tasks, including but not limited to space management, object alteration, backup & recovery.
• Created Alerts and Notifications for system errors, insufficient resources, fatal database errors, hardware errors, security breach, etc.
• Created logins, groups, users, roles, database devices, databases and mirroring devices.
• Analyzed various aspects of Stored Procedures and performed tuning as needed to increase productivity and reusability of code.
• Actively involved in hardware and network specification, installation and configuration, and participated in database design, architecture and SQL scripting.

Environment: MS SQL Server 2005, 2000, Windows 2000; Windows Server 2003 Standard Edition, Enterprise Edition.