Sql Server Ms

PROFESSIONAL QUALIFICATIONS

Competent, experienced, and highly dependable professional, proficient at producing and completing quality outputs, recognized for performing all duties and responsibilities in compliance with standard operating procedures. Known for demonstrating exceptional work ethic. Equipped with communication and interpersonal skills. Versatile and easily adapted to changing environments. 7+ years of database management experience that includes Database Administration, System Analysis and Design, Development & Support of MS SQL Server 2012, 2014, 2016, 2017 and 2019,2022environments.

Experienced in installation, configuration, and administration of MS SQL Server, applying service packs, hot fix and cumulative updates in Production and non-production environments.

Experienced in performance tuning/analysis, troubleshooting and query optimization.

Experienced in using dynamic management views (DMV) and dynamic management functions (DMF), TSQL scripts, Triggers, and Store Procedure for troubleshooting and performance tuning.

Managed security group, created logins with appropriate roles, created users and groups, and granted privileges according to company policy.

Experienced in coordinating and supporting server level hardware and software maintenance, windows patching, and application migration/upgrade.

Monitored error logs, database space allocations, transaction log space allocations for performance and documentation of errors and resolutions for future references.

Maintain Data Views for Reporting.

24 X 7 Production Database on Call Support.

CORE TECHNOLOGIES:

Database:

SQL Server 2022/2019/2017/2016/2014/2012

ETL Tools:

SQL SSIS/ DTS, Import/Export Wizard

Server Tools:

SSMS, SSCM, SSRS

Troubleshooting:

SQL server error log, Activity Monitor, Query Analyzer, Profiler, Extended Events, DTA, Query Store, DMV’s.

Operating Systems:

Windows Server 2012/2012(R2)/2016/2019

Third Party Tools:

Redgate, ServiceNow

EXPERIENCE HIGHLIGHTS

DFW Airport Senior SQL Server DBA January 2020 - Present

Dallas, TX

Experience in Upgrading SQL Server (In place and Side by side Upgrade) based on application compatibility and fixing the orphan users.

Experience in implementing SQL Server security and Object permissions like creation of users, granting permissions, and assigning roles to users.

Experience implementing and troubleshooting High Availability of database servers using Replication, Log Shipping, Database Mirroring, failover clustering and Always ON AG.

Experience in Configuring and Scheduling SQL Server agent Jobs, Alerts, operators, Maintenance plans, Database Mail Configuration, facets, and Transparent Data Encryption.

Experience with Monitoring, Performance Tuning, and analyzing DB performance issues.

Strong experience in designing and implementing backup and disaster recovery strategies as per RPO and RTO values.

Experience in configuring and maintaining Full backup, Transactional log backup, Differential backup and creating the maintenance plans for index rebuild, index reorganize based on fragmentation.

Experience in identifying and troubleshooting database health, integrity checks and fixing them.

Experience in Microsoft Reporting Service (SSRS) with Report authoring, Report management, Report delivery and Report security.

Creating jobs, alerts to run SSIS, SSRS packages periodically. Created the automated processes for the activities such as database backup processes and SSAS, SSRS Packages run sequentially using SQL Server Agent job.

Experience in Database refresh from prod to lower environments as per business requirements.

Manage and involve in SQL performance tuning, identifying locking, and blocking issues using Native and third-party tools to enhance and boost performance and SQL Dbs.

Work with Performance Tuning/Query tuning, execution plans, trace flags and SQL Profiler

Installation of Service packs to all environments.

●Used log shipping for synchronization of databases.

so is pieces that are so so versatile that I really do know so these was this this was a surprise but something that ended up like once I got them I was like I love this story and I'm just reaching for it so so much

WELLS FARGO SQL Server DBA May 2017 – December 2020

Austin, TX

Installed and configured different MS SQL Server versions on standalone and clustered environments.

Experienced in migrating contents from lower versions to higher versions.

Experienced in applying periodic service packs and hot fixes (cumulative updates).

Auditing databases for user’s transaction, login and database action and fixing orphan users.

Managed users and groups (roles) from Active directory or SQL, provide appropriate server roles, map them to specific databases and grant specific privileges over selected database securable objects to ensure security and integrity.

Involved in capacity planning and allocation of resources for the databases by assisting application teams in creating databases depending upon the criticality of the databases following current and best practices in accordance with SLA of the company.

Involved in database Consolidation project.

Responsible for creating and monitoring database maintenance plans and schedule jobs using SQL Agent/Maintenance plan; Schedule database integrity check, reorganize/rebuild indexes, update statistics, backup/restore and cleanup job history.

Experience in SQL native tools for performance monitoring /analysis and troubleshooting. Performance tuning by analyzing execution plans, creating, & maintaining indexes.

Analyzed Locks, Blocks, Dead Locks, Resource Utilization, handling Isolation Level and Concurrency issues.

Reviewed and optimized SQL queries, stored procedures, views, and triggers from other developers to achieve maximum efficiency and scalability. Provided consultation for development teams regarding performance review and the correct usage of database objects and list the most resource-intensive queries on the server and suggest ways to improve performance on each.

Supported implementation of AlwaysOn, Availability groups by creating availability databases using the high availability and DR strategies in clustered environment.

Experienced with configuring database high availability techniques like Replication, clustering as well as implementing disaster recovery techniques like database mirroring and log shipping.

Used free tools to diagnose server reliability and performance issues.

Experienced in implementing, configuring, and maintaining different types of Replication Models.

Texas Children Hospital SQL Server DBA April 2016 – April 2017

Houston, TX

Installed, Configured, and Managed SQL Server instances and databases in production, development, and test environment.

Applied periodic service packs and hot fixes (cumulative updates).

Experienced in migrating contents from lower versions to higher versions.

Managed database security, creating logins, groups, users, and server level and database level roles following company policies and procedures.

Created Alerts and Notifications for system errors, insufficient resources, fatal database errors, hardware errors, security breach, etc.

Strong knowledge and working experience in Database Backup and Disaster Recovery. Experienced with Point-in-Time Recovery that meets company’s RTO and RPO. Plan backup strategies based on the recovery models, size of data and I\O activity.

Designed, implemented and managed database maintenance and disaster recovery plans including full/differential/transactional backups and recovery procedures.

Implemented pre/post strategies for upgrading and migration of user databases by scripting all SQL server replications, login/users, linked servers, scheduled job, database mail profiles and server level configurations.

Analyzed Locks, Blocks, Dead Locks, Resource Utilization, handling Isolation Level and Concurrency issues.

Managed efficient backup system to minimize backup/restore time by applying Database Backup Compression, enabling Instant File Initialization, and applying frequent full, differential and transaction log backups.

Configured Log Shipping as Standby database from Production database for Reporting purposes as well as installed, configured, and maintained database mirroring.

EDUCATIONAL BACKGROUND

Bachelor’s in Information Management Addis Abeba University Ethiopia

Contact this candidate