Microsoft Certified SQL server

Database Administrator

Name: Desbele, kibreab

Mobile: 281-***-****

Email: - adxlpn@r.postjobfree.com

PROFESSIONAL SUMMARY

Managed SQL Server Databases through multiple product lifecycle environments from Development to Mission-critical production systems.

Installed, configured and managed SQL Server Instances in a clustered and non-clustered production, development, and test environments.

Configured and maintained instances and databases including system health check and Performance monitoring to ensure high levels of database performance and availability.

Managed logins, users and permissions and fix security issues of the server and databases according to the security policies defined by the company.

Refined and Automated routine tasks and processes and track and resolve server level and database level issues and document the changes that have been applied.

Assisted developers and business analysis a regular database refresh, script testing and query tuning requirements.

Installed Hot fix, Cumulative Update and Service Packs to different SQL Servers versions.

Perform scheduled database maintenance activities and support application downtimes during application migration or upgrade.

Designed a point in time restore strategies for mission critical databases to be compliance with the SLA requirements of business units and application owners.

Extensive backup and restore and automation experience using different backup and restore options including Compression, Copy only, backup stripping and backup mirroring in a production environment to satisfy business needs

Implemented database Partitioning and table compression for optimal performance.

Resolved Locking and Blocking (Deadlock)issues by using various SQL server internal commands.

Maintained database consistency with DBCC commands.

Configured Database Mail for automatic notification of reports and jobs status

Implemented HA and DR solutions like Database Mirroring, Log shipping, fail over Clustering and Always On as per Organizational requirement.

Managed Azure Cloud/SQL Server on VM/Managed DBs/Managed Instances.

Migrated SQL server databases from on-premises SQL Server to Azure IAAS/PAAS.

Independently Analyzed, solved, and rectified server level and database level issues in real time, providing problem resolution and root cause analysis/RCA

Experienced on Performing BCP, Bulk Insert operations and openrowset functions for data uploading and data movement.

Deployed SSIS packages in production and redesigned SSIS packages for data transfer & data transformation across between multiple data sources.

Participated an on-call rotation to provide 24x7 Support for critical production systems

SQL Server Administrator August,2021 to Present

Ercot, Austin, TX

SQL Server Software Installs, Upgrades in version 2012\ 2014\2016\2017\2019

Performance tuning of the Database both at the application level (SQL) as well as instance

Creating databases, SQL Objects, monitoring databases, implementing security, setting up alerts, maintenance plan and high availability solutions

Experience in building and modifying stored procedures, functions, creating tables and views with Strong T-SQL skills

Designing, developing, and optimizing our SQL server databases and environment

Experience in troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues, replication issues, log shipping issues, connectivity issues, security issues, etc.…

Experience with Rebuilding indexes and Reorganizing Databases

High availability SQL Server solutions, including Log Shipping, Replication, Mirroring and SQL Server clustering In all SQL Versions.

Experience with third party monitoring tools such as Idera, ServiceNow and Fog

light required.

Database operational maintenance, capacity planning and implementation of enhancements, including associated documentation of data models and configurations

Work with other technical support groups to determine appropriate disk platforms, disk configuration, operating system kernel settings and database engine configurations

Apply MS SQL Server maintenance patches and upgrade instances to supported release levels

Troubleshooting and resolving technical problems and providing on-call support

Experience with automation and PowerShell scripting for Server hardening

Experience working in an 24/7/365 environment

SQL Server Administrator May,2020 – July,2021

Chase Bank, Houston, TX

Working on Installation, configuration, and Upgrade/Migration of SQL server to higher version.

Configuring and maintaining database servers and processes, including monitoring of system health and performance, to ensure high levels of performance, availability, and security.

Working on Backup and Restore with Compression options along with point in time recovery of production databases per business needs and automating backup jobs.

Use DBCC commands to check physical and logical consistency of the databases and reorganized/rebuilt indexes, Create and update statistics and managed the databases effectively.

Monitor blocking /deadlocks, Tempdb and maintain all the OLTP servers with maximum database availability, reliability and investigate and resolve any database related issues.

Working on SQL server Disaster recovery and high availability solutions, including replication, SQL Server Clustering, Mirroring, Log shipping and Always On.

Managing SQL Server logins and user accounts, granting of permissions based on the business requirements,

Assisting developers with complex query tuning and schema refinement.

Performing scheduled maintenance and support release deployment activities.

Providing technical mentorship and cross-training to other peers and team members.

Managing databases on Azure Cloud /SQL Server on VM/Managed DBs/Azure SQL.

MSSQL Server DBA March,2018 – April,2020

Hewlett Packard (HP) - Houston, TX

Installed, upgrade, configured, managed, and migrate SQL Server in clustered and non-clustered production, dev, and test environments.

Implement DR and HA availability solutions like Database Mirroring, Log shipping, failover Clusters and Always On depending upon the criticality of the applications and as per Organizational requirement.

Managed Logins, Users, and permissions and fix any Security issues of the Server and Databases according to Security Policies defined by the company.

Create and alter stored procedures, Indexed views, User Defined Functions (UDF), Triggers Distributed Queries and Common Table Expressions.

Installed Hot fix and Service Packs in MS SQL servers.

Perform Backup and Restore with Compression options along with point in time recovery of production databases per business needs, automated this process via Agent Jobs as well.

Implement database Partitioning and table compression for optimal performance.

Resolve Locking and blocking issues by using various SQL server internal commands.

Experienced in Performance tuning and monitoring using different built-in and 3rd party tools.

Configured Database mail for automatic notification of reports and jobs.

Configured and support Transactional Replication between Publisher & Subscriber servers.

Performance tuning of long running SQL queries and Stored Procedures using SQL Profiler, DMV, Query Execution Plan.

Perform BCP and Bulk Insert operations for data uploading module and Create DTS and SSIS packages for data transfer & transform across locations and multiple data source.

Maintain database consistency with DBCC.

MSSQL Server DBA Jan, 2016 – Feb,2018

Linn Energy - Denver, CO

Perform Server installation and configuration.

Experienced in implementing different types of HADR solution like replications, log shipping, database mirroring, clustering and Always ON.

Rebuild/reorganized indexes on regular intervals and placing the huge table/non-clustered index on the separate file group to improve the performance.

Developed and created new database objects including tables, views, index, stored procedures and functions, advanced queries and also updated statistics using Query Analyzer and Enterprise Manager on the existing servers.

Analyzed execution plans and generate suggestions for improvement.

Involved in configuring SQL jobs and windows tasks for performing scheduled activities like backups and purging/archiving data.

Worked on configuring data files; log files and Tempdb as per RAID features.

Implement Logins, Roles and Authentication modes as a part of security policies.

Created mail profile and setting up Alerts using Database Mail.

Experienced in trouble shooting database issues like Disk issues, TempDB

, deadlocks, performance CPU usage, IO statistics, Memory Usage and blocking issues.

Applied SQL server patches and migrated to different versions of SQL.

Experienced in using command line tools like BCP utility for Data movement.

MSSQL Server DBA Feb,2012 – Dec 2015

CGX Energy Inc., Plano, TX

Installed, configured, migrated, managed, and upgraded database servers along with performance Tuning, Backup and recovery on SQL Server 2005~2014 database systems.

Involved in Day-to-day activities such as Agent Jobs, Backups and Recovery, Services, Index, Database growth, health and consistency check, Data maintenance, issue problem maintenance and management, Incident management, Security maintenance etc.

Managed SQL user logins, object permissions, server roles and database roles.

Extensively worked on upgrading Microsoft SQL server, failover clustering, log shipping, and replication, using System Monitor and SQL Server Profiler to identify bottlenecks, discovering slow-running queries, performing backup and recovery databases, and implementing database modifications on production servers.

Install all software upgrades and service packs for SQL Server.

Involved in development of database including creating new databases, converting old databases to new databases, modification of existing databases, creating reports to meet business needs.

Planning for backup and recovery of database information Responsible for performance tuning and optimization of databases using tools like SQL Profiler, Query Analyzer Database Engine Tuning Advisor

Worked on import and export data using BCP from different source sources.

Used DBCC Utilities to maintain the consistency and integrity of each database in the production server.

TECHNICAL SKILLS

Operating Systems: Windows 2003/2008/2008R/2012/2012R/2016/2019, UNIX

Languages: T-SQL, Python, R, HTML

Databases: SQL Server 2008/2008R2/2012/2014/2016/2019, MySQL

Reporting Services: Crystal Reports, SSRS, Argos

ETL: DTS, Talend, Informatica, VS

Tracking Tool : JIRA, MS project management software.

Monitoring tools: Foglight, Idera, ServiceNow Ticket, Lite Speed, PAL tools

EDUCATION

Bachelor of Mathematics and Minor in Computer science

Microsoft Certified SQL Server Database Administrator

Contact this candidate