SUMMARY

• Experienced MS SQL Server Database Administrator with 6+ years of experience in a production/test/dev environment with an Onsite - Offshore delivery model.
• Experience includes install/upgrades, migrations, performance tuning, monitoring, compression, backup, restoration, automating DBA tasks and disaster recovery.
• Self-starter and committed to maintaining cutting edge technical skills and up-to-date industry knowledge.
• Highly driven and successful database Administrator with a proven track record and reputation for achieving results in Operations.
• Possess a unique combination of analytical and leaderships skills, with excellent organization and prioritization abilities.
• Hands - on experience with installation, troubleshooting, managing and configuration of MS SQL Server 2014/2012/2012/2008 on Windows Server 2012 R2.
• Maintained databases with sizes ranging from large to very large databases (terabytes).
• Created Database maintenance plans for compressed full DB backup and transaction log backup.
• Configured, monitored, supported and troubleshooting of multiple databases on Cluster environments to provide High Availability and Disaster Recovery.
• Setting up and monitored Disaster recovery environments like Database mirroring with in the primary Data center servers and Log Shipping between primary and secondary Data center servers including Mirroring conjunction with Log Shipping.
• Hands on experience in managing security through logins, users, permissions, certificates, credentials, encryption schemes per Company's Security Policies.
• Configured, monitored Transactional Replication for different clients for reporting purpose.
• Troubleshooting Mirror, Log shipping and Transactional replication synchronization issues.
• Troubleshooting Application and Backup jobs failed issues.
• Good knowledge in Reporting Services (SSRS).
• Good knowledge in using DMVs and DMFs in resolving Performance Issue.
• Experience in Query Optimization, Database Consistency Checks using DBCC Utilities, analyzing the execution plan and index management for better Query Optimization.
• Experience in server virtualization using VMware & Hyper V.
• 24/7 Database operation support for SQL server 2012/08 databases in clustered and stand-alone server environment.
• Experience in scheduling Backups and Restore and Maintenance plans using SQL Server Native tools.
• Experience in T-SQL Development skills including stored procedures, views, User Defined Functions, Triggers
• Documented Database environment, Escalation procedures, issues, Installation procedures, Disaster recovery procedures in Database Management Prod Guide.

TECHNICAL SKILLS

RDBMS: MS SQL Server 2012/ 2008BI

Tools: SSIS, SSRS 2012

Operating Systems: Windows 2012 R2

Languages: PowerShell, C++, T-SQL

Virtual Environment: VMWare, Hyper-V

DB Monitoring Tools: Performance Monitor, SQL Server DMVs, SQL Profiler, Extended Events, Database Engine Tuning Advisor.

HA/DR: SQL Server 2012/2008 R2 Clustering, Always On, Mirroring and Log Shipping

Hardware Tool: HP ProLiant DL360

PROFESSIONAL EXPERIENCE

Senior SQL Server DBA

Confidential, Seattle, Washington

Responsibilities:

• Build new SQL Servers and updated with latest service packs and cumulative patches (hot fixes) for SQL Server 2012.
• Troubleshooting the Disk failures in a Cluster Environment.
• Configured and Managing Always on High Availability on 4 node cluster environments.
• Migrated SQL Server 2008R2 databases to SQL server 2012 by using Backup - Restore, Detach-Attach, and Management Studio Wizards and custom scripts.
• Created new database objects like Tables, Procedures, Functions, Indexes and Views using T-SQL in Development and Production environment for SQL Server 2012.
• Prepared Documentation for the Disaster Recovery plan.
• Managing Databases spread across multiple servers in Production, Development, staging & testing environments.
• Daily routine DBA tasks like handling user's permissions and space issues on Production and Semi-Production Servers and Troubleshooting Failed Jobs.
• Created simple stored Procedures, Triggers, and Tables using T-SQL .
• Installed and Configured MS SQL Server 2012, responsible for configuration, tuning and provide support to all Production and development servers.
• Troubleshoot Performance issues causing Application slow.
• Created SSIS Packages using SSIS Designer for export heterogeneous data from OLE DB Source Excel Spreadsheet to SQL Server.
• Created SSIS jobs and scheduled Packages using SQL Server Management Studio for the Daily Load.
• Implemented SQL Server 2012 Always-On high availability and disaster recovery solution.
• Monitor Database consistency and heath using DBCC Commands and DMVS.
• Ensure all database environments (Development, QA, UAT and Production) are coordinated (DB Refresh when requested).
• Involved in fine Tuning and Performance and Query optimization of the Database as required by the application.
• Created, scheduled database maintenance plan using SQL Server Management Studio Maintenance plan task.
• Hands-On experience on Replication set-up and troubleshooting.
• Created and deployed reports using SQL Server Reporting Services (SSRS).
• Used SSIS to populate data from various data sources, creating packages for different data loading operations for application, and to import data from other sources to SQL databases.
• Managing Security of SQL Server Databases by creating Server Logins, Database Users, Roles and assigning permissions in compliance with standards and resolving Account Locking issues by coordinating with Active Directory Group.
• Provided 24x7 DBA Production support for more than 500 SQL Server Databases in Production Servers to achieve Optimum Performance.

Environment: MS SQL Server 2012, T-SQL, SSIS, SSRS, SSMS, SQL Agent, SQL Profiler, Database Engine Tuning Advisor, Windows 2012 R2, MS Visual Studio 2010.

SQL Server DBA

Confidential, Bellevue, WA

Responsibilities:

• Responsible for supporting over 50 SQL instances of 2012.
• Migrated Databases from SQL Server 2008 to 2012 in Production and test Environments.
• Performing the Server QA on SQL Server and configuring the SQL Server as per the standards.
• Designed and implemented backup plans as per the data - retention policy outlined in the BRD (Business Requirement Document).
• Monitored Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers.
• Creating and managing schema objects such as Tables, Views, and Indexes.
• Creating databases and logins and users with permissions in SQL server 2012.
• Used DBCC commands to check physical and logical consistency of the databases and rebuild indexes.
• Handled up to 900 GB Size databases over standalone environment.
• Created Maintenance Plans to checking database integrity, reorganizing, rebuilding indexes and updating statistics.
• Backup and Recovery of Production Databases and tuning them for better Performance.
• Worked on Profiler, Perfmon, Extended Events, DMVs, and DMFs to tune the databases, servers and query tuning.
• Used Activity Monitor/server Dashboard to check the blockings and memory issues and DISK I/O issues.
• Worked on high availability SQL Server solutions, including Log shipping, Mirroring, Replication, and Always On.
• Creating new Databases and Migrated SQL Server 2008 databases to SQL server 2012 by using Backup-Restore, Detach-Attach, and Management Studio Wizards.
• Configured database mail to inform corresponding DBA basis on each Job Status.
• Creating and Modifying Tables, T-SQL Stored Procedures, Views, Indexes, User-defined Functions, and Triggers as required.
• Monitored the Performance of the SQL Server by using Performance Monitor, SQL Profiler, SQL Profiler, DMVs, DMFs, Extended Events, and Database Engine Tuning Advisor.
• Managing Security of SQL Server Databases by creating Server Logins, Database Users, Roles and assigning permissions in compliance with standards and resolving Account Locking issues by coordinating with Active Directory Group.
• Administer, maintain, develop and recommend policies and procedures for ensuring the security and integrity of the company's databases.
• Performed Backup and recovery & Automation of Backups using maintenance plans.

Environment: MS SQL Server 2012, T-SQL, SSIS, SSRS, SSMS, SQL Agent, SQL Profiler, Database Engine Tuning Advisor, Windows 2012 R2, MS Visual Studio 2010.

Junior SQL Server DBA

Confidential, Ethiopia

Responsibilities:

• Performed Backup and recovery & Automation of Backups using maintenance plans. Monitor and optimize the performance of the databases.
• Production database support and issue resolution.
• Assist developers and QA analyst with Software Development Life Cycle.
• Assist other Product Development and IT organizations.
• Oversee performance tuning, including server profiling and index tuning.
• Maintain and administer SQL database (production, development, QA).
• Develop, test and administer database security procedures and recovery procedures.
• Performing daily maintenance including monitoring backups, managing disk space, and maintaining database objects.
• Participating in on - call rotation and working occasionally after hours or on weekends.
• Cloning and refreshing of databases, responding to client email requests.
• Maintaining client documentation including database topology, connection procedures, and special instructions.
• Providing database security administration such as User ID s, Passwords, roles, etc.
• Monitoring and responding to alerts posted from client databases.

Network Administrator

Confidential, Ethiopia

Responsibilities:

• Design and implement LAN network.
• Plan and coordinate the design, installation and connectivity of computers and network system to ensure a stable organizational operation.
• Developing, configuring, maintaining, supporting and optimizing all new and existing network hardware, software and communication link.
• Analyze and resolve wireless Local Area Network (WLAN) hardware and software problems in a timely and accurate fashion and provide end user training where required.
• Create and maintain documentation as it relates to network configuration, network mapping, and process and services records.
• Develop and deploy methodology for testing network performance and provide network performance statistics & reports.
• Design and deploy company LAN including server, routers, hub, switch and other hardware.
• Troubleshoot minor network issues that caused conflict with networking traffic.
• Manage and maintain client networks including troubleshooting of problem services and backups of file data.
• Manage and ensure effectiveness of security solution including firewalls, antivirus solutions.
• Perform sever and security audit, system backup and recovery.
• Document all pertinent end user help request and the action performed, prioritize and schedule problems, escalate problems (when needed) to appropriate experienced technicians.
• Identify and learn appropriate software and hardware used and supported by the organization.
• Configure Server, D - Link, switches, and router.
• Overseeing the daily performance of computer systems.
• Answering user inquiries regarding computer software or hardware operation to resolve problems.
• Provide IT support and training for computer users.