Manager Sql

Tsegaeab Belay

Alexandria, Virginia

240-***-**** • ********@*******.*** • linkedin.com/in/tsegaeab-belay-96b4b618a/

SQL Server Database Administrator

Results-oriented expert with extensive hands-on experience in database management

7 years of experience in Microsoft SQL including 2016/2014/2012/2008/2008 R2, SSIS, SSAS, and SSRS enterprise, standard editions and exposure to 2019.

Involvement through the phases of software development life cycle (SDLC) including Requirement Gathering, Analysis, Design, Development, testing, and Post-Production Support.

Experience in planning, installing, configuring, and managing of SQL 2014/2012 and 2008 R2 server.

Working with system and user defined databases, database files, and file groups.

Skill in designing, creating, configuring, monitoring, upgrading, and supporting databases.

Experience in planning, Implementing, and administering HA/DR solutions like log shipping, Mirroring, Replication, Clustering, and Always on Availability group.

Proficiency on performance monitoring using SQL server profiler, performance monitor, activity monitor, extended events, Database engine tuning advisor (DTA), and Server side traces.

Experience in migrating, copying, detaching and attaching, Backing up, and restoring databases.

Knowledge on capacity planning and storage management, expanding, and shrinking databases.

Skill on creating database objects like views, indexes, stored procedures, functions, and triggers.

Extensive experience creating user and groups’ logins, granting necessary permissions, and monitor activities enforcing security policy.

Setting up, Scheduling and maintenance plans, jobs, notifications, and alerts.

Creating and configuring and managing partially contained databases, and database snapshots.

Monitoring, Rebuilding and reorganizing indexes at regular intervals for better performance.

Strong understanding in performance tuning, query optimization, and resolving database performance issues including blocking, deadlocking, and index fragmentation.

Proficient in Creating, implementing, and deploying SSIS packages.

Implementing, managing and troubleshooting SQL server security, and audit.

Troubleshooting SQL server by Reading and analyzing event viewer and SQL server error logs.

Database Migration / Database Backups / Database Troubleshooting/Writing Programing Language T-SQL

IDERA Diagnostic Manager / COMMVALUT Backup Software /SQL Server Security /Pre Production Databases / DBCC Commands / Database Analysis/ETL/SSIS/SSAS/SSRS/MySQL/AWS/EC2

TECHNICAL PROFICIENCIES

Platforms:

Windows Server 2008 R2 2012, SQL Server 2008 R2, 2012, 2014, 2016 and security server.

Tools:

COMMVAULT Backup Software, ZENA Job Scheduler, IDERA Diagnostic Manager, and Visual studio.

PROFESSIONAL EXPERIENCE

SQL Server Database Administrator (5/2019 – 12/2020) Baltimore Country Public Schools, Towson MD

Ensured effective training and development by installing and configuring SQL Server 2016 Enterprise Edition on Windows Server 2016.

Installed several service packs and patches on SQL Server, including SQL server 2016, 2014, 2012, 2008R2, and Windows Server operating system by utilizing Windows Server update services.

Created follow up checklist for restoring databases, including all production, test development, and training environments.

Developed pre-production databases on SQL Server 2016 for test and training environments.

Analyzed physical and logical consistency of databases by leveraging DBCC commands.

Prevented unauthorized access within SQL server platform by setting up various user logins with appropriate roles, as well as deactivating user accounts of older employees.

Carried out in-depth database backups by using Commvault backup software on user request for protection against power failures and data losses.

Ensured the security of the database by implementing Data Masking and encryption.

Drove table migration from one server to another through creation of SQL server integration services package.

Improved reliability, security, and compatibility by implementing DB mail to receive alerts for job failure.

Implemented and planned multiple tasks, including integrity checks, rebuild, index reorganization, and stats updates by utilizing OLA HALGREEN scripts.

Employed Sentry One Plan Explorer to optimize slow queries to ensure efficient performance and results.

Key Achievements:

Successfully migrated database from SQL server 2014 to 2016 and version to enhance reliability.

Fostered databases restoration to production, including testing, training, and development on SQL Server 2016, 2014, and 2012.

Monitored and troubleshot databases by using IDERA Diagnostic Manager to evaluate health, performance, and potential issues within SQL server environment.

Utilized ZENA job scheduler to run the nightly ETL job to the data warehouse and minimize table sizes in SQL server to optimize unused space from database files.

SQL Database Administrator/Developer (09/2016– 04/2019) Kinsale Insurance, Richmond, VA

Designed and normalized relational database models.

Performed side by side migration from 2008 R2 to 2014 enterprise edition.

Created tables, views, triggers, functions, and Stored Procedures SQL Server 2014 and 2008/R2.

Implemented Always ON for High availability on SQL Server 2014/2012.

Applied transparent data encryption (TDE) to secure databases and backup file.

Provide analysis and recommendations for setting up a Backup and Recovery Strategy for SQL Servers.

Performed full, differential, and transaction log backups.

Used DBCC commands to check physical and logical consistency of databases.

Used SQL Agent to setup and automate internal processing tasks and backup tasks as well as setting up alerts to monitor the server and database health.

Created clustered and non-clustered indexes to improve query performance.

Recommended performance improvement involving index creation, index removal, and index modification.

Tuned slow running queries using server side traces and SQL server profiler.

Performed troubleshooting using activity monitor, dmv, dmf, profiler, and performance monitor.

Created and deployed SQL Server Integration Service (SSIS) for ETL processes.

Developed MSBI, SSAS, and SSRS for business decision making process.

Created auditing logs user actions at the instance and database level, to monitor elevated privilege users developers, DBA, and connection attempts.

Meet the established SLA (system Level Agreement) with the management

Key Achievements:

Achieved maximum productivity and recovered lost data by managing and implementing high availability / disaster recovery plans.

Mitigated data redundancy and increased integrity by designing as well as normalizing relational database model.

Implemented migration from SQL Server 2008 R2 to 2012 and 2014 Enterprise Edition.

SQL Database Administrator/Developer (01/2014– 08/2016) Evergreen Health, Baltimore, MD

Installed SQL Server 2014/2012 enterprise edition instance Database engine, SSIS, SSAS, and SSRS.

Created synchronized mirroring and configured to automatic failover.

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

Performed database and log backups and restoration, backup strategies, and scheduling backups.

Backing up system databases and restoring them when necessary.

Performed in routine database maintenance activities i.e. monitoring of jobs, and performance tuning.

Created roles and managed user permissions thru adding users, logins, and groups to the databases, and granting/revoking permissions on database objects.

Implemented Replication models such as Snapshot, Transactional, and Merge.

Configuring and Managing transactional replication in OLTP environments.

Managed tables which have frequent inserted, deleted and updated transactions to improve performance.

Troubleshooting deadlocks and blocking issues.

Audited database for users’ transaction, login and database action.

Configured memory, monitored disk usage, and memory usage of servers.

Key Achievements:

Improved database performance by managing frequent table functions, including insertion, deletion, and upgrade of transactions.

EDUCATION & TRAINING

Bachelor of Science in Information Technology

Adama Science & Technology University, Adama, Oromia

Technical Certifications

AWS Certified Cloud Practitioner

Contact this candidate