Sal- Tafesse

Email: adxp6a@r.postjobfree.com

Phone number: 443-***-****

Career Objective

A Microsoft Certified IT professional seeking the opportunity to work as a SQL Server Database Administrator (DBA) that will offer an opportunity for utilization of technical knowledge and further growth.

TECHNICAL SKILL SUMMARY

●A Microsoft certified SQL server (DBA) with almost 6 years IT experience: designing, coding, testing, and supporting next-generation database solutions in SQL Server environment.

●Possess strong communication and problem-solving skills developed through a variety of projects. Offer proven ability in teamwork and proactive system support.

●Experience in installing, configuring, administration and Maintenance of mission critical client databases in SQL server 2008, 2008R2, 2012, 2014, 2016, 2017 and 2019 versions.

●Good experience in configuring the SQL Server in AWS Relational Database Management system and in EC2.

●Extensive Experience in Upgrading SQL Server (In place Up 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.

●Deployment, administration and operational support of production, development and test environments utilizing proper change management and other ITIL best practices using ticketing tools.

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

●Strong experience on understanding and creating the server level and database level roles as per business requirement.

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

●Extensive experience with Monitoring, Performance Tuning, and analyzing DB performance issues.

●Strong experience on designing and implementing the backup and disaster recovery strategies as per RPO and RTO values.

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

●Strong experience on 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.

●Created reports, sub reports, charts, Tablix, Matrix, Hyperlink reports.

●Created jobs, alerts to run SSAS, 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

Professional Experiences

Hartford Financial Services, Connecticut, United States Jan 2020 – To Present

Title: SQL Database Administrator

Key Roles:

●Installing, managing, and administering MS SQL server 2012, 2016 and 2019 versions in development, test, and production environments

●Applied Service packs (SPs) on SQL Server 2012,2014 and 2016

●Migrated/upgraded database/instances from SQL Server 2008, 2008R2, 2012 to 2016

●Developed, maintained and implemented database backup and recovery plans on productions, Test and Development environments including mission critical databases.

●Refreshed databases in test and development environments from production server

●Worked on Window clustering and Always on Availability Group

●Monitor, detect and troubleshoot the health of the database environment (such as CPU, Memory and I/O, Disk space, blocking, deadlock, fragmentation, indexing, database integrity, etc.) without interruption the daily operation of the system using tools such as PerfMon, Profiler, Database Tuning Advisor, DMVs and DMFs, System Stored procedures, red gate etc.

●Setup maintenance plans and scheduled jobs to automate different database administration related tasks

●Setup and configured Database Mail and configured notifications and alerts

●Installed, configured, secured and maintained SQL Server Reporting Services (SSRS) and deployed reports

●Move data from flat file, CAV file, Excel, Access, and OLE DB data sources to/from SQL Server database using SSIS, BCP and /or Import/Export Wizard

●Monitored if scheduled SQL agent jobs have run successfully on a daily basin and troubleshoot, and fix if any job failed

●Regularly inspected SQL Server Logs, SQL Server Agent Error Logs, and Windows Event Viewer for information, errors and warnings

●Used SQL/T-SQL to create, alter, drop, delete, insert, update, etc. of databases, tables, Views, clustered and non-clustered indexes, schemas, triggers, functions, stored procedures, and so on

●Secured, managed, and created logins, users, roles and granted permissions of database objects

●Assisted SQL Server Database Developers in code review and optimizing SQL queries

●Provide technical support to resolve problems, test solutions, and implement fixes

Kaiser Permanente, California, United States May 2017 – December 2019

SQL Server DBA

Title: SQL Database Administrator

Key Roles:

●Installed, Configured, and Managed SQL Server 2016, 2014, 2012, 2008 R2 in development, test, and production environment

●Installed & Configured SQL Server Reporting Services (SSRS)

●Developed Ad-hoc Reports using SSRS

●Installed, Configured and Maintained Fail-Over Clustering using SQL Server 2012

●Installed, Configured and Maintained Database Mirroring using automatic fail-over option in SQL Server 2008 R2 & 2012

●Configured and Maintained Replications (Transactional)

●Configured and Maintained Always On in SQL Server 2016

●Database Upgraded (development, testing, and production environment):

●SQL Server 2008R2 to SQL Server 2014 and 2012

●Database Migrated (development, testing, and production environment)

●Oracle 10g databases to SQL Server 2012

●My-SQL 5.0.1 databases to SQL Server 2012

●Backward & Forward Engineering with data modeling

●Applied SP (Service Pack) on SQL Server 2012

●Strong on database Monitoring and Performance tuning

●Scheduled jobs to automate different database related activities including backup, monitoring database health, disk space, backup verification

●Monitor SQL Server Error Log, space usage

●Assisted Database Developers to optimize SQL queries and Stored Procedures

●Export & Import data from Flat file, CSV file to/from SQL Server Database using SSIS,

●Export & Import data from/to databases like Oracle, My-SQL, and Access to/from SQL Server

●Experienced with Point-in-Time Recovery, restored Database from backup.

Education: Bachelor’s degree

Contact this candidate