Sql Server Disaster Recovery

ANTENEH GETACHEW

Email: *********@*******.***,

Phone: 832-***-**** Houston, TX

PROFESSIONAL SUMMARY

Skilled MSSQL Server DBA with over 9 years Professional IT experience in SQL Database Administration & Development, System Analysis in all SQL versions on Clustered/non-clustered environments. I have experience in Microsoft SQL Server Database Installation, Configuration, Administration, Maintenance, Performance Tuning, Security, various database recovery techniques and disaster recovery mechanisms in SQL Server newer versions, 2019/2017/2016/2014/2012/2008r2 builds and accomplished projects as per user requirements (SLA). Highly effective, team-oriented and able to collaborate with cross functional personnel at all level.

Install, maintain and upgrade SQL Server from lower version to higher version.

Performing Capacity Planning

Installing, Configuring & Upgrading Microsoft SQL Server 2008R2 - 2019

Managing Data Integrity and Security

Implementing & Managing Database High Availability

Implementing Effective Backup Strategies For Disaster Recovery

Database Performance Tuning & Query Optimization

Installation, Configuration and Standardization of SQL server for optimal performance

Hands on experience implementing and maintaining SQL Server encryption models including TDE, Always Encrypt, etc

Install, maintain and upgrade SQL Server engines from lower to higher version

Configure & administer standby servers through Log shipping and Mirroring

Perform and oversee day-to-day database activities by checking SQL server error logs

Expertise in Database Administration on Prod environments with server configuration.

Setting up code review standards and best practices and collaboration with lower environment teams during migration /upgrades and to ensure availability and performance.

Experience on third party tool RedGate backup and RedGate monitor

Performance tuning and maintenance with outstanding troubleshooting skills

Management in capacity planning and monitoring database growth

Develop and implement database security, audit solutions for proper object designed procedures testing

Implement monitoring and alerts to proactively support application teams and provide advice on application data retrieval issues.

Database optimization using Database Engine Tuning Advisor & SQL Profiler.

Installed and managed SQL Server instances in virtual machines.

Experienced in configuring and supporting SQL Server Replication for various models

Knowledge in preparing and deploying T-SQL and, modifying PowerShell scripts.

Proficient working in Windows Server environment.

Experienced with infrastructure & Cloud migration environment.

Hands-on experience working in SQL Server Azure environments.

Install, configure and Administering SSRS and SSIS.

Have experience on TDE encryption and storage system .

Have experience on agile.

Refine and automate regular processes, track issues, and document changes.

Prepares and develops database documentation, procedures.

Performing capacity planning of SQL server environment and provide recommendations to management to sustain business growth. .

Gathering business requirements and designing to implement multiple projects along with production support

Designing, implementing,and maintaining Disaster Recovery (DR) methodologies and creating documentation.

Have experience on ETL tools (extract transform and load data) SSIS

Have knowledge of SQL server.

Forecast storage usage and perform capacity planning.

Hands on power shell scripts.

Plan and prepare documentation for SQL tasks.

Optimize the database and application for performance and security.

I have experience on deploying SSIS and SSRS packages.

T-SQL performance tuning to resolve day to day \critical production issues using native SQL server and third party tools.

Perform database administration tasks, such as backups, point-in-time restore maintenance plan based on mission critical application.

Have knowledge of database query, stored procedure and performance tuning.

EDUCATION& CERTIFICATES

Microsoft Certified - MSSQL Server Database Administrator

ArbaMinch Collage - Bachelor, Ethiopia

TECHNICAL EXPERTISE

SQL Server

MSSQL Server newer version, 2019,2017, 2016, 2014, 2012, 2008R2

Native Tools

SSMS, SSDT,SSCM,BCP,SQLCMD

Languages

T-SQL & PowerShell

BI & Modeling Tool

SSIS,SSRS

Operating System

Windows Server 2019/2016/2012R2/2008

Third Party Tools

RedGate, Service Now and Spotlight

PROFESSIONAL EXPERIENCE

Sr.SQL SERVER DBA

Center Point Energy –Houston, TX November 2019 –Present

Responsible for monitoring and making recommendations for performance improvement in hosted databases.

This involves index creation, index removal, index modification, file group modifications, and adding scheduled jobs to re-index and update statistics in databases.

Perform SQL Servers installation, configuration, upgrades and database migration.

Installation, Configuration and Standardization of SQL server for optimal performance

SQL Server High Availability and Disaster Recovery solutions

Hands on azure migeration

Hands-On Replication set-up and troubleshooting.

Capacity Planning, Storage Planning, Hardware Upgrade’s and Preparing cost analysis.

Microsoft SQL Server Administration and Maintenance

Installation, Configuration and Standardization of SQL server for optimal performance.

SQL Server upgrades and migration from earlier versions to SQL Server 2012/2014/2016/2017.

SQL Server Performance Tuning and Query optimization, SQL Profiler, Query Execution plan, indexing strategies.

SQL Server High Availability and Disaster Recovery solutions: AlwaysOn Availability Groups, Failover Clustering, Mirroring, Log Shipping, Replication.

Incident and Problem Management focusing on continuous improvements and quality of service.

SQL Server Security Auditing, hardening and remediation.

Design and Implement Database Backup and Restore policies.

Automate routine maintenance tasks using PowerShell.

Build project documentation and troubleshooting guides.

Leveraged excellent technical skills across multiple database technologies and platforms.

Optimized effective stored procedures to ensure optimum performance and availability.

Secured, controlled, and monitored user access by maintaining system security.

Responsible for monitoring and making recommendations for performance improvement in hosted databases. This involved index creation, index removal, index modification, file group modifications, and adding scheduled jobs to re-index and update statistics in databases.

Standardize and manage Database Administrator procedures for monitoring database performance, testing, archiving, and optimizing.

Have knowledge of database query, stored procedure and performance tuning.

SQL SERVER DBA

BBVA Compass Bank - Atlanta, GA March 2017– October 2019

Ability to quickly troubleshoot and resolve complex problems in a live environment.

Installation, administration, and maintenance of MS SQL databases.

Provided 24 x 7 production support to high critical databases and perform backup and recovery of large databases.

Administered MS SQL databases on various server platforms.

Managed users, their security privileges, and accesses in MS SQL databases, created groups, roles, users and assigned access privileges to each.

Monitored, assessed reconfigured database storage spaces, capacity and estimated sizing and growth requirements in MS SQL Databases.

Worked with developers regarding testing and accommodating new functionality of database interfaces.

Created, configured, and managed various types of database objects like tables, indexes, sequences, functions, procedures, packages, triggers, store procedures and database infrastructure objects like table spaces, data files, log files, etc.

Created and automated a new process of incorporating XML data into MS SQL server and upgraded databases usually from higher to lower versions.

Apply patches to production databases as required by the business.

Reformed De-fragmentation /Reorganization of database, Re-build indexes and move table in MS SQL Database.

Wrote complex T-SQL queries and stored procedures for retrieval of data and other applications.

Export and import data from SQL Server to MS Access, text files and excel files.

Automated data clean up and data migration efforts.

Set up backup and recovery procedure using clustering, log shipping and mirroring in MS SQL for hot backups and cold backups, incremental and full backups and performed database cloning to setup test and development database.

Used flash back technology to recover (Point-in-Time-Recovery) accidentally dropped or modified database objects and performed other regular DBA activities including space management, performance monitoring and as demanded by the business.

Recovered databases during the event of crash on several occasions and these were to point in time.

Created & maintained databases, tables, indexes, store procedures, roles, profiles, partitions and other schema objects.

Resolve blockings, locks, and deadlocks using Activity Monitor, DMV’s and SQL profiler.

Update statistics using query analyzer, enterprise manager on the existing servers.

Schedule and scripting DBCC commands to run daily and weekly basis in order to identify the health and performance of SQL server databases.

Monitored SQL server logs to ensure whether the backup operations, batch commands and scripts have completed successfully.

Implemented and tested the point in time recovery of the production databases.

Performed optimization of the queries with modifications in T-SQL queries, columns and normalization of data.

Hands on in creating SSIS packages using control and data flow elements

Played a good team member among project team and entire infrastructure team.

Have experience on agile I used it for change control.

JUNIOR SQL SERVER DBA

Scout Media Inc, Seattle, WA September2014 – February 2017

Involved in installation, upgrade, configuration and migration of SQL server in clustered and non-clustered production environments of SQL server.

Upgraded/migration Database from SQL Server from lower to higher versions.

Implemented techniques and performed special tasks within the context of database performance and tuning. Created, upgraded, maintained, while working closely and coordinating with hardware, network, and OS administrators.

Installed & configured database software, associated database tools and performance monitoring software.

Experienced on both production environment and non-production environment support

Performed database/infrastructure physical design, database upgrades & applied software patches to databases as per application/client requirements.

Performed acceptance testing to verify that database changes perform without adverse consequences.

Estimated disk storage requirements for database software, database files & database administration needs.

Participated in meetings impacting databases physical design.

Automated the SQL Server Job

Developed, tested & implemented a robust database backup and recovery strategy

Provided appropriate access to client so that they will have access to their respective needed server and database objects.

Managing Databases and SQL Server Instance Security by using Active Directory.

Reviewing/resolving backup issues.

Performed Database failovers/recoveries.

Experienced on OLTP & OLAP.

Design and handle High Availability and Disaster Recovery solutions such as Windows Failover Clustering, AlwaysOn, DB Mirroring, Log Shipping and Replication

Supporting SQL Server databases mirroring and environments.

Performance tuning with application teams to isolate and resolve performance issues.

Create reports in SQL server using SSRS as per the requirements provided by the Front-End users.

Extensively work on using System Monitor and SQL Server Profiler to identify bottlenecks, discovering slow-running queries.

Evaluate and monitor execution plans, query plans, key lookup operators for all troubled code, Evaluate transaction isolation levels.

Create maintenance plans and jobs to achieve maximum performance.

Contact this candidate