ERMIAS WOLDE

ad3kc6@r.postjobfree.com 408-***-****

McKinney, Tx

PROFESSIONAL SUMMARY

An experienced SQL server Database Administrator with 6+ years of expertise in 24/7/365 production environment and possess extensive knowledge in SQL installation, configuration, optimization, server builds, patches, service packs, upgrading and troubleshooting of SQL Servers in Clustered and Non-Clustered environments. Implemented and supported different High Availability and Disaster Recovery scenarios like Always-On Availability Groups, Clustering, Replication, Log Shipping and Database Mirroring. Worked extensively on ETL procs using DTS, SSIS, SSRS packages, handling data quality issues and generated diverse types of reports using SSRS on OLAP databases. Analytical and skilled in understanding business problems to develop systems that improve functionality. Talented at working effectively in collaborative and initiative-taking environments. Driven Database Architect with 6+ years of experience in full lifecycle development. Purposeful collaborator succeeds collaborating with various colleagues and clients by maintaining communication. Motivated with keen analytical, problem-solving and task management abilities. Efficient administrator eager to leverage knowledge in SQL based database management systems. Skilled in database security, backup, and recovery with good understanding of automation and containerization tools. Collaborative with strong work ethic. Top-notch DBA-Administrator with solid background in designing and implementing data management solutions. Strong knowledge of database security, backup, and recovery. Collaborative and dedicated to improving and optimizing database performance. High-performing professional with experience managing large-scale, complex databases. Skilled in SQL and database management systems. Strong understanding of database design and data modeling with excellent troubleshooting skills. Smart and committed to staying up to date with recent technologies and advancements. Organized and dependable candidate successful at managing multiple priorities with a cheerful outlook. Willingness to take on added responsibilities to meet team goals. Hardworking and enthusiastic job seeker with strong organizational skills eager to secure senior-level DBA position. Ability to manage multiple projects simultaneously with a high degree of accuracy.

SKILLS

Operating system and Virtualization; Window server 2008/2008R2/2012/2012R2/2016

Relational DBMS; MS SQL server 2012/2014/2016/2017/2019,

Programming; SQL, T-SQL, Oracle, and shell scripting (Power Shell)

Performance Tool; Database Engine Tuning Advisor, Profiler, Performance Monitor

Migration tools: DMS, DMA for environment

Development and Modelling tool; Data tools Visual Studio, BIDS, SSMS, Query Analyzer and Red gate

Team working

Adaptive person

Problem-solving

Disaster Recovery

WORK HISTORY

Senior SQL Server Database Administrator Walmart- Dallas, TX Apr 2023-Feb 2024

Responsibility

Install and configure new Microsoft SQL Server instances, including Always On availability groups and failover clustering.

Create database, table, index, stored procedure, triggers.

Create Users and assign permissions based on level of database access users would need.

Create, schedule, modify and optimize SQL Server Agent jobs and maintenance plans, verify that all scheduled jobs have run successfully.

Design database Backup and Restoration Strategy, monitor backups for being performed regularly.

Configured and maintained transactional, snapshot replication and merge replication.

Worked and coordinated with developers in writing and tuning new stored procedures.

Perform ETL process of importing large volumes of data, cleaned up and transformed to desired format.

Check all statistics related to memory, locks, I/O, database response time, wait events, top sessions, and background processes.

Monitoring performance of physical configuration, way database is indexed, regularly monitor, and identify blocking and lock issues.

Design procedure that continuously runs on all production servers and notifies DBA team if any blockings, long running quires/transaction.

Scripted and automated day to day maintenance tasks using PowerShell scripts.

Converted existing T-SQL batch scripts to PowerShell scripts and improving SQL Server maintenance jobs performance.

Configured Temp DB with considerable Memory and RAID Levels for better performance.

Created internal secured website linking to database that includes updated information about all target SQL server information.

Create, configure, and manage virtual machines.

Wrote and maintained technical and functional specifications to document database intentions and requirements.

Implemented system enhancements to design and develop solutions to address problem reports.

Followed standard practices for migrating changes to test and production environments.

Maintained complex T-SQL queries, views, and stored procedures in multi-database environment with little supervision.

Set up and controlled user profiles and access levels for each database segment to protect important data.

Evaluated programs and databases to identify issues and make necessary modifications.

Created and updated database designs and data models.

Administered, supported, and monitored databases by proactively resolving database issues and maintaining servers.

Collaborated with staff to develop and implement procedures to prevent data loss and maximize system availability.

Produced high-standard database solutions to meet stability, reliability, and performance metrics.

Client-Amegy Mortgage Capital- Woodland, TX Feb 2021—Apr 2023

Responsibility

Worked on migrating SQL Server from SQL Server 2012 to SQL Server 2016/2019

Design and implement appropriate database maintenance for database systems (Index maintenance, update statistics, Backup strategies)

Work with application teams on tuning queries which causes extended blocking, deadlock and locking.

Developed automated tasks for daily, weekly, and monthly database maintenance such as database backup, database integrity verification and indexing using control-M agent and SQL server agent.

Developed complex T-SQL script and stored procedure to improve performance, preserve referential integrity and provide application functionality.

Worked on linked server to run distributed queries between SQL server and Oracle databases.

Periodically apply required service packs and cumulative updates on database servers

Configured Transparent Data Encryption (TDE) and backup/restore strategies on encrypted database.

Worked with REDGATE tool by setting up alerts for monitors of various SQL servers for all types of issues.

Incorporated extensive familiarity with Red Gate system for data management and backup and recovery accountability

Followed standard practices for migrating changes to test and production environments.

Developed custom database objects, stored procedures, and delivered application support.

Managed workload independently but collaborated with colleagues to complete larger scale tasks in distributed team environment.

Kinder Morgan- Dallas, TX Jan 2018 – Feb 2021

Junior DBA

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.

Refreshing and cloning of database.

Monitoring and responding to alert posted.

Worked on planning and implementing MS SQL server security and database permissions.

Responding client documentation including connection procedures, and special instructions.

EDUCATION

Bachelor of computer science - university of Addis Ababa, Ethiopia

Contact this candidate