Server Dba Production

Baharan Getachew

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

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

PROFESSIONAL SUMMARY

More than 6 years of IT experience in Microsoft SQL Server Database installation, configuration, administration, and database performance tuning. Having hands-on experience migrating scripts in a production environment and extensive experience in creating and modifying stored procedures, triggers, cursors and functions to meet business requirements. Experience in implementing HADR solutions like Replication, Log shipping, Clustering, and mirroring on physical and virtual machines. Good knowledge of High Availability (HA), Always On and Disaster Recovery (DR) options for MSSQL Server. Proficient with SQL Server 2012, 2014, 2016 and 2019 optimization, fine-tuning, and scalability techniques with knowledge of SSIS. Working 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. Strong ability to work independently and manage my own time. Strong people skills, written and verbal communication Strong decision making, critical thinking skills, and critical thinking.

EXPERIENCE

SENIOR SQL SERVER DBA – Home Depot 04/2020 – Present Remote

•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.

•Designing servers and providing insight on how these servers should best work together to achieve a client's goals.

•Supporting and managing SQL Server databases and production failover cluster, ensured elevated levels of performance, availability, sustainability, security, and several other responsibilities.

•Installation, Upgrade, Configuration and Migration of SQL Server in clustered and non-clustered production environments.

•Setting up the Transactional Replication in between SQL Server databases and also from SQL Server to Oracle databases.

•Installing and upgrading the Database server and application tools.

•Modifying the database structure, as necessary, from information given by application developers.

•Planning for backup and recovery of database information.

•Involving in development of database including creating new databases, converting old databases to new databases, modification of existing databases.

SQL SERVER DBA – Houston Federal Credit Union 09/2017 – 3/2020 HOUSTON, TX

•Implemented HADR using log shipping, mirroring, AlwaysOn and replication between SQL Server instances.

•Implemented and scheduled Replication process for updating parallel servers.

•Maintained all existing databases and new installations at current and stable production levels.

•Configured, installing and administrating SQL database systems.

•Tuned SQL queries to troubleshoot and resolve database or application problems encountered by end users.

•Planed and installed change control, verification of system resources, backup and recovery, disaster planning, performance tuning and troubleshooting.

•Managed use of schedule jobs and automation to populate data in production and non-production databases.

•Set up access privileges to databases, monitored database servers for resource utilization, and recommended and implements database tuning changes to maintain optimum database performance.

•Performed backup and recovery and configures database parameters.

•Managed testing, reporting, and backup/restore, worked with development team to deploy database objects.

•Import data across multiple instances using BULK INSERT and BCP Utility.

•Performed Data migration using DTS across different databases like Oracle, MS access & flat files.

•Used Event Viewer, SQL Error Logs and Log File Viewer for monitoring purposes

•Collaborated with developers to troubleshoot and problem solve SQL queries as well as optimizing and performance tuning.

SQL SERVER DBA – Houston Methodist Hospital 06/2016 – 08/2017 Houston, TX

•Used best practices to create and maintain backup and disaster recovery plans as needed for prod and per-prod environments.

•Maintained of the databases including rollouts and upgrades, implementation and released of database changes.

•Provided trend analysis to the management team enabling them to make informed decisions regarding resources.

•Acquired knowledge of emerging technologies to analyze and offer solutions to current business application challenges.

•Managed and maintained data definitions for complex production, non-production databases.

•Write T-SQL Scripts for database backup jobs and daily/weekly jobs.

•Creating and maintaining various databases in Production and development environments

•Maintained security for databases and generates reports, queries, and documentation.

•Managed database elements, including creation, alteration, deletion, and copying of schemas, databases, tables, views, indexes, stored procedures, and triggers.

EDUCATION

Bachelor’s Degree

Contact this candidate