SUMMARY:

I have more than * years of experience working with Microsoft SQL Server, spanning versions from SQL Server 2012 to SQL Server 2019. Over the course of my tenure, I've been involved in a myriad of tasks and responsibilities pertaining to database management and optimization:

1.Database Design and Implementation:

Led the design and creation of multiple new databases to support various applications.

Normalized database structures to optimize storage and enhance data retrieval.

Created numerous tables, stored procedures, views, and triggers.

2.Performance Tuning:

Regularly reviewed query performance and optimized SQL code for efficiency. Utilized the built-in execution plans to identify bottlenecks.

Managed database indexing, ensuring that frequently accessed data was retrieved efficiently.

3.Backup and Recovery:

Instituted daily, weekly, and monthly backup schedules.

Successfully recovered data during two critical instances, ensuring no loss of crucial data.

4.Replication and High Availability:

Set up and maintained transactional replication for a set of databases to offload reporting.

Implemented Always On Availability Groups to provide high availability for critical applications.

5.Security:

Regularly audited server and database security settings.

Set up and maintained role-based access controls and managed user permissions.

6.Upgrades and Patching:

Led the upgrade process from SQL Server 2016 to 2019, ensuring smooth migration with no downtime.

7.Monitoring and Maintenance:

Used SQL Server Management Studio (SSMS) extensively for routine tasks and monitoring.

Leveraged SQL Server Profiler to trace and monitor SQL Server events.

Deployed SQL Server Performance Monitor to gather metrics on the system's health and performance.

Utilized third-party tools like Redgate SQL Monitor and SolarWinds Database Performance Analyzer for more granular monitoring and insights.

Throughout my experience with SQL Server, I've always prioritized ensuring that the databases run efficiently, securely, and remain available to support the needs of the business.

SKILLS:

Database Management: MS SQL Server 2019/2017/2016/2014/2012/2008, MS-Access

Programming Languages: Transact SQL, Java, Python, C#

SQL Server Tools: SQL Server Management Studio, SQL Server Profiler, SQL Server Integration Services (SSIS), SQL Server Replication, SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS), SQL server Integration Service (SSIS)

Operating Systems: Windows Server 2016/2012/2008/2003 Advanced Server, Windows NT

Third-Party Tools: Redgate, SQL Litespeed, Spotlight

WORK EXPERIENCE:

Client - Janus International Group

Role – SQL Server Database Administrator

Location - Remote

Duration – June 2021 to Present

Responsibilities

Managed end-to-end installation, configuration, and administration of SQL Servers in standalone and clustered environments.

Implemented high availability and disaster recovery solutions, including clustering, mirroring, log shipping, and AlwaysOn.

Implemented performance monitoring, analysis, and tuning strategies for relational databases, optimizing query performance.

Apply both cumulative and service pack patches.

Oversaw the creation and review of database objects, including tables, triggers, views, stored procedures, indexes, and statistics.

Successfully migrated databases from various versions of SQL Server to improve system efficiency and data integrity.

Implementation of AlwaysOn Availability Groups and cluster environments for enhanced data redundancy and availability.

Supported 24/7 on call resolving critical issues promptly to minimize downtime.

Ensured database security with access controls, encryption, and policy-based management.

Orchestrated database backup and recovery operations, minimizing data loss and ensuring business continuity.

Collaborated closely with development teams to deploy seamless database changes and integrate with applications.

Proficiently utilized source control management concepts, including branching, merging, labeling/tagging, and integration with Git, Jetbrains Intellij, and TFS.

Built and maintained documentation related to the company’s database environment.

Performed reviewing, optimizing, and deploying of database scripts.

Provided 24/7 DBA support in development and production environments. Duplicate

Created and automated SQL server jobs & configured database mail, operators, alerts, & notifications

Carried out performance monitoring, analysis and tuning of relational databases using SQL native tools & features such as profiler, tuning advisor, performance monitor, DBCC Consistency Checks, activity monitor, extended event, DMVs, DMFs & query plan analysis.

Troubleshoot issues related to database integrity, performance, concurrency, blocking, deadlocking, connectivity, security, index management and statistics.

Client - PJM Interconnections

Role – SQL Server Database Administrator

Location - Audubon, PA

Duration – Feb 2018 – May2021

Responsibilities

Ensured high availability and optimal performance of critical SQL Server RDBMS systems, supporting corporate applications throughout the product lifecycle.

Automated installation, upgrade, and patching of SQL Servers 2008-2019, significantly reducing manual workload.

Configured and maintained databases in clustered environments and Azure cloud services to enhance data access efficiency.

Implemented performance tuning measures, optimizing queries, and resolving blocking issues.

Designed and executed database maintenance plans for regular upkeep and data consistency.

Scheduled and managed Replication processes to keep parallel servers up to date and ensure data synchronization.

Enforced robust database security, managing user privileges and resource allocation effectively.

Troubleshot SQL Server issues promptly and effectively, maintaining system stability.

Developed and deployed SSIS packages for seamless data integration, enhancing data management.

Supported 24x7 OLTP and data warehouse/BI environments, ensuring continuous data availability and meeting business demands.

Led end-to-end administration of SQL Server installations, ensuring high availability, performance, and security.

Implemented disaster recovery solutions, including clustering, mirroring, log shipping, and AlwaysOn.

Optimized relational databases through performance monitoring, T-SQL tuning, and query plan analysis.

Streamlined database objects creation and maintenance, including tables, triggers, views, stored procedures, indexes, and defaults.

Successfully migrated databases from SQL Server 2005 and 2008 to SQL Server 2012, minimizing downtime and ensuring data integrity.

Spearheaded the implementation of AlwaysOn Availability Groups and cluster environments for enhanced data protection and availability.

Efficiently managed database backups, Point-In-Time Recovery, and maintenance plans to support 24/7 operations.

Maintained robust database security by granting permissions to users, roles, and objects, and administering server logins for both Windows and SQL Accounts

EDUCATION:

Bachelor of Science Bahir Dar University

CERTIFICATION:

Microsoft Certified Professional – 70-462 Administering Microsoft SQL Server 2012 Databases.

Contact this candidate