Sql Server Database Administration

MESFIN WOLDE

Tel: -832-***-****

Email: - ad7eqy@r.postjobfree.com

Work Authorization: - US Citizen

PROFESSIONAL SUMMARY

Over 9 plus years of experience in SQL Server Database Administration of large and complex databases with SQL Servers 2000/2005/2008/2008R2/2012/2014/2016 /2017/2019 and SQL Server 2022. Expertise in database administration on production servers with server Installation, configuration, server hardening, BI tool, performance tuning and maintenance with outstanding troubleshooting capabilities.

Expert in SQL Server version upgrades, patching, and service packs.

Skilled T-SQL programmer proficient in optimizing queries, scripts, jobs, and stored procedures.

Specialized in SQL views, stored procedures, functions, and triggers for efficient data analysis.

Implemented HADR solutions (Always On, Replication, Log Shipping, Clustering, and Mirroring) on physical and virtual environments.

Effective communicator fostering collaborative environments and delivering innovative solutions.

Configured and managed replication models including snapshot, transactional, and merge replications.

Proficient in ad hoc report creation using T-SQL and adept in query optimization techniques such as indexing and performance tuning.

Managed Microsoft cloud environments (IaaS, PaaS, and SaaS).

Extensive experience in various backup strategies (full, differential, transactional log, copy-only).

Worked extensively with Active-Active and Active-Passive SQL Server Clustering.

Familiar with Policy Based Management, Resource Governor, data masking, and Transparent Data Encryption (TDE).

Strong understanding of RDBMS concepts and proficient in logical and physical database modeling using ERWIN.

Utilized tools like Index Tuning Wizard, DBCC Utilities, and SQL Server Activity Monitor for performance tuning and management.

Configured Database Mail, SMTP, and operators for efficient alerting on job failure.

Identified and resolved performance bottlenecks, managed locks, blocking, and deadlocks using DMVs and Query Execution plans.

Experience with BI tools (SSIS, SSRS, and SSAS) and third-party tools (LiteSpeed, Foglight, Redgate) for data integration, reporting, and performance monitoring.

Developed SSIS packages for ETL processes, extracting data from various sources and loading into SQL Server using OLE DB and SQLNCLI.

SKILLS

Platforms: - Windows server 2003/2008/2012/2012R2/2016/2019/2022

Languages: - C, C++, T-SQL, JAVA, HTML, CSS, XML, MYSQL, PHP, PL-SQL

RDBMS: - Microsoft SQL server 2005/2008/2008R2/2012/2014/2016/2017

SQL server tools: - SSMS, Azure, SQL profiler, DMA, DTA, red gate, lite speed, fog light

Case tools: - MS office, MS excel, and MS outlook of 2000/2003/2010, MS Visio, MS project.

BI tools: - SSIS, SSRS, SSAS, Erwin, SSDT

Use of Microsoft Teams and M365 tools such as Planner

EXPERIENCE

Professional Experiences

Center Point Energy/Houston, TX October 2018- Present

Senior SQL server DBA

Responsibilities

Led and executed cloud migration projects from On-premise SQL Server to Azure SQL, ensuring seamless transitions with minimal downtime.

Implemented and enforced best practices for database security and compliance with data privacy regulations, incorporating advanced access controls, encryption, and auditing mechanisms.

Proactively identified and resolved performance bottlenecks, collaborating closely with development teams to optimize query performance, indexing strategies, and resource utilization.

Implemented and maintained robust monitoring solutions to provide real-time insights into database health, ensuring proactive issue resolution.

Conducted regular health checks, capacity planning, and managed upgrade/migration activities to uphold system reliability and stability.

Managed essential database administration tasks including installation, configuration, proactive monitoring, tuning, backup, recovery, and troubleshooting.

Innovated and implemented automation solutions for routine tasks, significantly reducing manual efforts and improving operational efficiency.

Implemented and managed database replication, Change Data Capture (CDC), Always On, Windows Failover Clustering (WFC), and high-availability solutions to ensure continuous operation and disaster recovery.

Designed, implemented, and maintained SQL and Azure database solutions aligned with organizational requirements and industry best practices.

Developed, enhanced, and optimized ETL processes using Azure Data Factory and other tools to seamlessly integrate data from diverse sources into the database.

Collaborated with teams to optimize and streamline data transformation pipelines, ensuring efficient data flow and optimal database performance.

Troubleshot and resolved complex database issues efficiently using Azure Insights, Monitoring, DMVs, Query Store, etc., demonstrating expert knowledge of SQL, Transact-SQL, DMVs, Stored Procedures, user-defined functions, and Custom Types.

Provided expert counsel on database design principles, optimizing database structures for scalability and high performance while adhering to industry best practices.

Leveraged T-SQL and PowerShell scripting to automate routine tasks, enabling proactive monitoring, maintenance, and timely issue resolution.

Identified opportunities for process improvements and automation, driving initiatives to enhance the efficiency and effectiveness of database administration tasks.

Collaborated effectively with cross-functional teams, actively participating in solution design sessions and contributing insights to ensure robust database solutions.

Contributed to the development and implementation of best practices for database management, aligning strategies with evolving industry trends.

Developed and maintained comprehensive documentation, standards, and procedures to foster knowledge-sharing and ensure consistent operational excellence and continuity.

Environment: - Window server 2012/2012R2/2016/2019, MS SQL Server 2008R2/2012/2016/2017/2019/2022, Microsoft Azure, PowerShell, SSMS, SSRS, SSIS, MS Visio Studio 2012/2013/2015, Red Gate, Service Now, Spotlight, FogLite, Cipher Trust.

United Health Group / Houston, TX October 2015 –September 2018 MS SQL Server DBA

Upgraded and /migrated Database from SQL Server from lower to higher versions

Installed & configured database software, associated database tools and performance monitoring software

Performed acceptance testing to verify that database changes perform without adverse consequences

Estimated disk storage requirements for database software, database files & database administration needs

Demonstrated proficiency in utilizing Lite speed tools for SQL Server administration back up, recovery, and performance optimization

Utilized Lite speed tools for troubleshooting and resolving SQL Server issues, ensuring optimal system performance and data integrity

Implemented lite speed solutions to streamline back up processes, reduce storage requirements, and enhance database availability

Provided appropriate access to client so that they will have access to their respective needed server and database objects

Performed day to day troubleshooting and support activities.

Developed new databases and implements enhancements to existing databases.

Implemented application databases, sets up database backup and recovery, data integrity procedures, space management strategies, and security.

Created database application designs that adhere to the database standards and procedures.

Documented all implementation work. Participates with application developers and operations staff in the database installation, development and testing phases of assigned projects.

Utilized FogLite tools for SQL Server monitoring, performance analysis, and optimization, ensuring optimal database performance and uptime.

Configured FogLite alerts and notifications to proactively identify and address potential issues, minimizing downtime and improving system reliability.

Conducted regular performance tuning and optimization activities using FogLite tools, resulting in improved query performance and overall system efficiency.

Implemented Cipher Trust tools for SQL Server encryption to protect sensitive data at rest and in transit, enhancing overall database security.

Configured and managed encryption keys using Cipher Trust solutions, ensuring secure storage and access control to encrypted data.

Collaborated with cross-functional teams to assess security risks and develop encryption strategies using Cipher Trust tools, contributing to a robust security posture.

Implemented Disaster Recovery Backup processes and conducts Disaster Recovery testing.

Effectively used database utility, monitoring and tuning tools.

Provided consulting support to application teams that use enterprise class databases.

Experienced in leading DBA for small to medium projects. Monitors database performance and responds to service calls for database related problems.

Provided resolutions for basic to complex service-related problems and accurately documents outages, anomalies and fixes.

Worked with Infrastructure personnel to install and test new versions of or patches to the Database Management System.

Experienced on Knowledge of SQL, TSQL, SSIS, and SSRS, stored procedures, triggers, and other RDBMS objects.

Amegy Bank: Houston, TX January 2012 – September 2015

SQL Server Database Administrator

Experienced in installation and maintenance of application databases on a computerized database management system.

Extensively worked in creating Database, database objects such as view, table, stored procedure, trigger and function using T-SQL, while creating complex T-SQL join querie

Developed different kinds of interactive reports such as Sub Reports, Charts, Matrix reports, and Linked reports.

Used Index tuning wizard to get a better idea of implementing indexes on the existing databases

Performed SQL maintenance duties such as backup, restoration, creating and scheduling jobs

Created Triggers to monitor activities on server as well as database and generate alerts and notifications

Created and maintained of databases, creating Roles and managing user permissions.

Developed data recovery, maintenance, data integrity, and space requirements for physical databases.

Reviewed and optimized database changes, including patches, prior to production deployment.

Experienced in Troubleshoot and resolve database integrity issues, performance issues, blocking and deadlocking issues, replication issues, log shipping issues, connectivity issues, security issues etc.

Expert in performing the administrative functions including Backup and Recovery, Database security, Replication, Running Database Consistency Checks, Designing, Performance tuning and Query Optimization

Experienced in detecting and troubleshooting SQL Server related CPU, memory, I/O, disk space and other resource contention

Experienced in Monitoring SQL server I/O and develop SAN storage requirements, working with the Infrastructure Team to ensure optimal performance, high availability, and scalability

Created packages, Jobs, Sending Alerts using SQL Mail, Database Mail and custom extended procedures

Conducted performance tuning and optimizations using native monitoring and troubleshooting tools

Documented all application database designs

Owned problems and see to resolution, including when outside support is needed from other teams or outside vendors

Analyzed potential problems areas and recommend and/or implement improvements

Implemented Vormetric tools for SQL Server databases to enforce data encryption and access controls, safeguarding sensitive information from unauthorized access.

Managed encryption keys and access policies within the Vormetric platform, ensuring secure storage and controlled access to encrypted data.

Collaborated with security teams to assess and address data security risks, leveraging Vormetric solutions as part of comprehensive security strategies for SQL Server environments.

Tools & Environments

MSSQL Server 2008/2008R2/2012/2014/2016/2017, T- SQL, SQL Profiler, Log shipping, Replication, Mirroring, Clustering, MS Access, SQL, Transact-SQL (T-SQL), PL/SQL, XML, MS SQL Server Integration Service (SSIS), MS SQL Server Reporting Service (SSRS), SQL Profiler, SQL Query Analyzer, MS SQL Server Index Tuning Wizard, Visual Studio 2005/2008/2010, DTS SQL Developer, ETL, Data Ware house, SSDT, Report Builder, XML, MS-Excel, MS-Access, and third party tools (Red Gate, Service Now, Spotlight, FogLite,Cipher Trust,SQL Compare, SSW SQL DEPLOY,SSW SQL Server Auditor, Power-BI instant SQL formatter. Red-Gate SQL Doc, Lumigent Log Explorer

EDUCATION & CERTIFICATION

Microsoft Certified Technology Specialist in Database Administration

Bachelor’s Degree in Information Systems, Addis Ababa, Ethiopia

Contact this candidate