Sql Server Database Administrator

BEZAWIT SEYOUM

E-mail: *******.******@*******.***

Phone: 703-***-****

CAREER OBJECTIVE:

Experienced Sql Server Database Administrator with over 8 years of experience in designing, implementing, and maintaining SQL Server environments. Proven track record in managing high-availability databases, performance tuning, backup and recovery, and ensuring data integrity and security. Adept at collaborating with development teams to optimize database performance and deliver solutions that meet business needs. Possesses rich expertise in the support and management of SQL Server, with excellent communication skills. Seeking a challenging position in a progressive environment that leverages my technical and analytical skills.

PROFILE OF QUALIFICATIONS:

Experience with an emphasis on Design, development, enhancement, automation, tuning, and optimizing databases for high Availability, Performance and Security.

Experience on Applying STIG to a database and server to enhance their security posture and ensure compliance with DOD standards.

Worked on Monitoring and implanting high availability solutions such as windows failover clustering and always on.

Extensive experience with SQL Server and T-SQL in constructing database objects, tables, Store-

Procedure, triggers, user functions, views, indexes, user profiles, relational database model.

Expert in Performing and Monitoring database growth, health and consistency checks, maintenance plans, planning and scheduling Backup and Recovery.

Hands on experience in Backups and Restores.

Extensive knowledge of Relational Database Management Systems (RDBMS).

Experienced in MS SQL Server Installation, Configuration, Performance Tuning, client/server connectivity, Query Optimization, Back-Up/Recovery, running Database Consistency Checks usingDBCC.

Experience in Administering SQL Server security by Creating User Logins with appropriate roles, monitoring the user accounts, creation of groups, granting the privileges to users and groups.

Proven experience in using SQL Server Agent services to Create, Automating and Schedule jobs.

Experience in Creating Packages and Sending Alerts using SSIS and SQL Mail/Database Mail.

Experience in Data migration between SQL Server 2008 and 2012 from Excel, Flat file to MS SQL Server by using BCP and SSIS.

Expertise in Designing, Configuring, Monitoring, Troubleshooting and Quick issue resolutions and solutions to MS-SQL Server High availability methods such as Log shipping, Replication (Snapshot, Transactional, Merge), Mirroring and clustering.

Experience in implementing different types of Replication Models like Snapshot, Transactional and Merge Replication.

Extensively worked on storage and with system administrators to allocate and configure Instances.

Hands on experience in Data extractions to SQL Server from other data sources and performed Data comparison, Data validation, Data mining, Data profiling.

Conducted system and user database recovery as well as point-in-time and point-of-failure recovery testing of critical databases.

Commonly used DMV queries along with profiler trace to capture queries and their execution plan for query performance tuning and optimization.

Worked with developers to optimize poorly performing stored procedures, views and ad-hoc queries.

Performed database change requests.

Written ad-hoc T-SQL, views, and stored procedures to address various business needs.

Conducted daily system health checks and report status to immediate supervisor.

PROFESSIONAL EXPERIENCE:

SQL Server Database Administrator

AUG 2021 – Present

ManTech, Portsmouth, VA

Responsibilities:

Identified SQL statements with poor performance using Performance Tools and SQL Trace tools.

Developed stored procedures, triggers, views and added/modified tables for data load, transformation and extraction.

Configured performance tuning and optimization in SQL Server 2008/2012.

Performed data migration using Bulk Insert, Bulk Copy Process (BCP) and SSIS and from SQL Server 2008 and Flat files.

Designed, Implemented, and configured Disaster recovery processes using different methodology.

Installed, configured, upgraded and monitored SQL Server 2008 and 2012 database server.

Implemented and configured Backup and recovery process using maintenance plans for all database server included production, development, staging and test.

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

Involved in designing, configuring, monitoring and troubleshooting replication, log shipping and mirroring on critical databases issues.

Implement and configure High availability And DR such as AlwaysON, Mirroring, log shipping and Replication.

Migrated Databases server and installed and configured over 10 triplet SQL Server Always on Availability Groups using SQL 2016Enterprise Ed.

Troubleshooting, Performance Tuning, Query Optimization, and Data Integrity.

Version Control (Git, GitHub) and Compliance (GDPR, HIPAA).

Worked on Data Migration, Data Warehousing and TDE encryptions.

Adept at collaborating with development teams to optimize database performance and deliver solutions that meet business needs.

Perform database tuning and optimization using tools like SQL Profiler, Database Engine Tuning Advisor, and Performance Monitor.

Configure and maintain database High Availability (HA) solutions, such as AlwaysOn Availability Groups and Failover Clustering.

SQL Server Database Administrator

July 2019– Aug 2021

ECS Limited, Chantilly, Virginia

Responsibilities:

Contributes to the successful design, development, implementation, and change management and

production support of mission critical database applications.

Plans, installs, configure and upgrades installations related hardware and software.

24 x 7 on call support as part of a scheduled rotation with other team members.

Develop documentation for the various database standards, procedures and policies.

Implementation of log shipping and monitoring.

Creating and modified stored procedures for optimization.

Involved in creating packages using Integration Services and migrating packages from DTS.

Assists the development staff with best practices, including but not limited to, code optimization techniques and provide recommendations and resolution.

Monitored and optimized database and server performance using tuning methodology and tools, including enterprise manager, query plans, performance views, and other SQL Server tools.

Maintains and improves high availability and disaster recovery strategies for the database environments, including backup, restore and where appropriate.

Involved in the implementation of databases mirroring.

Involved in performance tuning for the optimization of slow running queries and index maintenance.

Monitored and managed use of disk space, memory, and SQL Server CPU usage using native tools.

Resolve Tempdb and log file space growth.

Disaster Recovery, Database Replication, High Availability (HA), WF Clustering, Point-in Time Recovery (PITR), Monitoring and Automation, Database Monitoring (e.g., Prometheus CloudWatch), Capacity Planning, Alerting and Logging.

Database Security and Compliance.

Backup Automation, Database Auditing and Terraform (for infrastructure automation).

Conduct database security audits and implement data encryption, user roles, and permissions to protect sensitive information.

Reduced query execution time by 30% through index optimization and code review of stored procedures.

Junior SQL Server Database Administrator

May 2018- July 2019

College Board, Reston Virginia

Responsibilities:

As SQL DBA Responsibilities and tasks include Database design, creation of user databases, Installation of MS SQL Server & Clients and Installing SQL Server service packs and migrating SQL databases from more than 100 data centers to 6 data centers.

Experience in migrating SQL Server databases.

Setup log shipping and troubleshooting log shipping errors when arises.

Running DBCC consistency checks and fixing data corruption in application databases.

Troubleshooting performance issues after migration.

Experience in Configuring Database Mail.

Administering the MS SQL Server by creating user logins with appropriate roles, dropping and locking the logins, monitoring the user accounts, creation of groups, granting the privileges to users and groups.

Setup transactional and merge replication and troubleshooting replication errors.

Solving production issues and incident tickets generated by Remedy.

Transforming the database from various sources like excel and access to SQL.

Performance Optimization, Indexing, Query Optimization, Partitioning, Database Caching (e.g., Redis, Memcached and Backup and Recovery.

Provided 24/7 on-call support for critical database systems, ensuring prompt issue resolution and minimal downtime.

Install and Configure SQL server instance, monitor database and servers.

Technical Skill:

Database: DBMS: Sql Server, Azure SQL Database, PostgreSQL, Oracle, MySQL, Data Encryption.

Language: T-SQL, C#, PowerShell, XML, Python.

Cloud: AWS (S3, Redshift, Lambda), Microsoft Azure (Data Factory, Synapse), (BigQuery, Cloud Storage), Snowflake, Databricks.

ETL Tools: SSIS, Azure Data Factory, MS Visio, SQL Server Data Modeler, GitHub, TFS, Agile Methodology, Jira, MS Excel, Data Governance, Data Security Compliance and SSRS.

Operating Systems: Windows Server 2012/2016/2019, Linux

.

EDUCATION:

BS, Information Technology, Old Dominion University.

Certified in Microsoft SQL Server Database Administrator 2014/2016

Certified in CompTIA Security+

Top Secret and Public Trust clearance

Contact this candidate