Mail Agent Database Administrator

Rahwa Adhanom

Senior SQL Database Administrator

*************@*******.*** • 713-***-****

www.linkedin.com/in/rahwa-adhanom-7a6015226

Houston, TX

Summary

PROFESSIONAL SUMMARY

A Microsoft SQL Server Database Administrator (DBA) with over seven years of progressive professional working experience in all aspects of SQL Server edition and versions (2008, 2008 R2, 2012, 2014, 2016, 2016, 2017 and 2019), including installation, configurations and databases high availability solutions (mirroring environment, log shipping, replication, Always On, and failover cluster).Proven ability in managing large databases in a 24/7 processing. Strong knowledge of database backup, disaster recovery, and point-in indexes -time recovery through database restoration. Proficient in using DBCC to check database conditions-integrity checks-, rebuilding (Cluster/Non-Cluster). Developing maintenance plans for monitoring and server activities and resolving troubleshooting questions as needed. Technical Proficiencies

SQL Servers & Operating Systems

MSSQL Server 2019,2017, 2016, 2014, 2012, 2008r2, 2008, Windows Server 2016/2012R2/2008

Tools & Languages

SSMS, SSDT, BIDS, SSCM, BCP, SQLCMD, SSIS, SSRS & SSAS, RedGate, Service now, SQL Lite Speed, SCOM, Remedy, T-SQL, SQL

Professional Experience

Reliant Energy, Houston, TX, July 2019 - Present

SQL Database Administrator (DBA)

Play key role in capacity planning, reviewing database changes to identify system impact. Manage installation, upgrade, configuration, and migration of SQL server in clustered and non-clustered production environments, developing strategies for data acquisitions, archive recovery, and tables’ maintenance. Developed database objects, including tables, views, index, stored functions, and advanced queries. Troubleshoot and diagnose database issues, proficiently setting up backup recovery strategies supporting high availability. Translated requirements using T-SQL to create databases, tables, and other objects.

Optimized database performance, developing and implementing performance monitoring processes to analyze data.

Plan and Lead database development, documentation and maintenance of databases including

Troubleshoot problems for customers

Implemented and Scheduled Replication process for updating our parallel servers

Analyze information and data

Excellent in using TDE to encrypt data at rest as well as in transit & to perform real time I/O encryption / decryption IG the data and log filers to protect at rest

Used TDE to perform real time I/O encryption and decryption IG the data and log filers to protect at rest

coming up with appropriate solutions relevant to the problem at hand

Communicate problem/cause and resolution inn effective manner

Support SQL Server 2019/2017/2016/2014/2012/2010 R2/2008 on premise

Provide DBA 7x24 Support to production teams and perform routine DBA activities for SQL database instances.

PaaS Azure database creation, configuration, monitoring

Strong experience in mentoring team members and writing documentation.

Azure SQL Managed Instance Configuration

Migrating SQL server databases to cloud

Migrated from Oracle Database to SQL Server

Great working knowledge installing, patching, maintaining, and upgrading all MS SQL Server software.

Experience in Clustering (Active/Active, Active/Passive). Experience in Mirroring, Log Shipping and Replication.

Control user privileges and closing production support tickets with client satisfaction in timely manner

Led process improvements, migrating databases from SQL Server 2005 to SQL Server 2012 and also 2014-2019

Implemented high availability and disaster recovery protocols on multiple servers using Windows clustering, replication, log-shipping, and database monitoring.

Participated in integration projects using ETL process to extract the data, transform the data and load the data.

Created SQL Server Integration Services (SSIS) packages using control and dataflow elements; exported and imported data from flat files and row files.

Set up transactional and merge replication between SQL Server databases

Configured data and table partitioning on huge tables with numerous rows.

Managed SQL database security, granting permission and access to database users and login.

Resolved application connectivity issues, including connection timeouts, pooling issues, and memory leaks.

Uncovered and resolved the issue of mission-critical of high usage of system CPU, Disk, blocking issues and transaction per/sec, memory involved in performance monitoring of Memory, Processor, Disk I/O.

BBVA Compass, Houston, TX,02/ 2017 – 06/2019

SQL DBA

Installed, configured, upgraded, maintained, and migrated SQL Server, quickly troubleshooting and resolving complex issues in live environment. Conducted regular database backup monitoring and prepared reports, using SQL Profiler to identify deadlocks and blocking. Supported production and non-production environment, applying service packs and cumulative updates. Established and maintained sound backup and recovery policies, setting up security and access profiles.

Designed and managed Disaster Recovery and high availability solutions, including failover clustering, always on, log shipping, and replication.

Monitor database activity and file usage, and ensures necessary resources are present.

Determine data to collect and analyzes information as appropriate.

Investigate and resolve technical database issues of significance.

Used TDE to encrypt data at rest as well as in transit

Utilize third party performance tuning tools to analyze and determine database performances.

Characteristic, informational needs and elements, data flow, storage requirements, data output and reporting capabilities for complex databases.

Backup/Restore, Troubleshooting databases for performance tuning.

Read and understand T-SQL.

Designed, building, installing, configuring and supporting Database servers

Installed, maintained and patched the MS-SQL software; created, moved, upgraded, and deleted databases.

Implemented backup and recovery processes; performed routine maintenance on databases; monitored and tuned databases using Performance Monitor, SQL Server Profiler and Dynamic Management Views (DMV) and Dynamic Management Functions (DMF).

Creation and management of database maintenance plan for various database consistency checks

Implemented and maintained security rules and security audits; maintained state of audit readiness; problem resolution.

Experience working with ETL development functions, or similar experience involved with the Extraction, Transformation and Loading of data and files

Adhered to Change Control Procedures and worked with Change and Incidents management tools

Experienced in using MS SQL Reporting Service (SSRS) and MS SQL Server Integration Services (SSIS).

Deployed and maintained SQL clustering environment

Experience using Master Data Management (MDM) for data management, data control, data linage.

Experience with SQL Server 2017/2016/2014/2012/2010 R2/2008 installation, Migration, configuration.

Performance tuning experience, specializing in database and instance tuning and SQL optimization.

Monitored database system details within the database, including stored procedures and execution time.

Planned and implemented high availability solutions

Proficiently employed native tools (Profiler, Perfmon, dynamic management views) to diagnose and repair SQL server performance issues.

Rebuilt and re-organized database indexes and automated application-related jobs and data replication activities.

Wrote documentation to database, including data standards, procedures, and metadata.

CGX Energy, Plano, TX, 11/2014 – 12/2016

Junior SQL DBA

Performed installations, configurations, upgrades, and migrations of SQL servers, tools, and software, working closely with senior administrators to ensure accuracy and performance of database. Developed project documentation and troubleshooting guides. Applied patches to databases to meet client requirements and conducted acceptance testing to verify performance of database changes. Automated server jobs and estimated disk storage requirements.

Strong skills in configuring and administering SQL Server Replication and DR solutions like Setting up transactional and merge replication between SQL Server databases.

Worked extensively in automating process like creating jobs, and error reporting using Alerts, SQL Mail Agent

Developed and implemented comprehensive Backup plan and disaster recovery strategies

Resolving requests related to database and system issues raised by user support

Planned and executed many upgrades such as Service Pack, Hot fixes etc.

Participated in meetings impacting databases physical design.

Customized support for Client’s Applications (e.g. Third party supported/In-House Applications etc.) provided client will own the responsibility of creating and maintaining database objects and structures (e.g. tables, indexes, views, triggers, Functions, Procedures etc.)

Database recoveries as per requirements.

Conducted root cause and analysis for database incidents and problems.

Participated in designing, testing and implementing an enterprise Disaster Recovery Plan.

Monitored data activities (i.e. database status, logs, space utilization, extents, Checkpoints, locks and long transactions).

Managed security by defining roles and rights.

Executed scripted changes requests in accordance with change control procedures.

Upgrade of Database from SQL Server SQL 2008R2 to 2012, 2014, 2016, 2017.

Provided overall configuration and change control management for database components.

Escalated database issues to appropriate approvers (if applicable).

Researched, reviewed and recommended for preventive maintenance.

Set up security and access profiles and procedures for database system administrators.

Complied with standard security-related procedures that are based on established best practices and conformity to company policy and adjusted to accommodate Client Security Policy based on agreement.

Proven ability to handle database of more than 1 TB in Size.

Expertise in MSSQL SERVER Database Administration.

Configured and managed multi transactional replication chain on a production database.

Set up Log Shipping, MSSQL Mail

Created, administered & maintained SQL Server Databases (Production, Development, Test and Staging Environment’s.) for various groups such as Developer, QA, BA, and User are ensured the Availability of the Database Server in a 24X7 Environment.

Scanned the data pages, Indexes and checked the storage space used by each table.

Migrated up to 50 servers and over 400 databases from a legacy Datacenter with upgrade to new Datacenter.

Planned and executed many upgrades such as Service Pack, Hot fixes etc.

Interfaced with database vendors & client technical support teams to isolate & resolve database related problems.

Implemented MS SQL Cluster (Active/Passive & Active/Active), Single Node, Multi Node Cluster up to 4 Node.

Developed, tested, and implemented robust database backup and recovery strategy, managing Server Instance Security with Active Directory.

Education

Bachelor of Science, Computer Science

Mekelle University, Ethiopia

Contact this candidate