Aynalem Delellegn

Mobile:469-***-****

Email:ad05hm@r.postjobfree.com

ADDRESS: 11911Greenville avenue

Dallas, TX 75243

Professional Summery

Database Administration and Management

* **** ***** of experience in SQL server (2022,2019,2017,2016, 2014, 2012, 2008R2, 2008 and 2005) Database Administration in Production, Staging and Development Environments.

Very Good understanding of Normalization / De-normalization and the database design methodology.

Expert in RDBMS concepts and constructs to design relational databases model and implementation as per business needs.

Good experience in automation of administrative tasks such as Maintenance plans, Jobs, and Alerts using SQL Server Agent services

Managing Large Size of SQL Server Databases.

Experience in creating databases, tables, Indexes, Stored Procedures and Views

Proficient with SQL Server Backup/Restore and Disaster Recovery procedures.

Experience in implementing SQL Server Security and Database User Permissions.

Expert in creating, scheduling, and monitoring Jobs and Maintenance plans.

Expertise in Performance tuning, Optimization, Data integrity, Indexes and Statistics by using native tools like index tuning wizard (DTA), profiler, Perfmon, extended event, Query store activity monitor, Event viewer for performance analysis.

Experience using features like Policy Based Management, Resource Governor, Performance Data Collector and Transparent Data Encryption (TDE).

Expertise in SQL Server Storage Structures and Security Architecture for databases

Hands on experience in configuring, monitoring, and administering Always On, WSFC, Log shipping, Mirroring and Replication

Strong knowledge and experience in implementing disaster recovery solutions- database Backup, Restore, and Point-in-Time Recovery in accordance with RTO and RPO guidelines.

Proven experience in the areas of Troubleshooting, Performance Tuning, Monitoring Server & database health, disk space Utilization, query optimization.

Experience in analyzing Locks, Dead Locks using Extended Events Session and Handling the Isolation Level and Concurrency Effects.

Experienced with using performance enhancement features such as Partitioning, File Groups, and Materialized Views.

Experienced in upgrading SQL Server (2005/2008/2008 R2/2012) instances to SQL Server 2012/2014/2016/2017/2019/2022.

Expert in database object change impacts analysis at the database and application levels.

Worked closely with application developers and business users to assist in the planning and execution of the database and jobs upgrades across the Development, Test and Production environments.

Migrated SQL server database from on prem to Azure.

Expertise in Administrating SQL on Azure.

Expert in using Bulk Copy Program (BCP), Migrating DTS Packages to SSIS, Package Migration Wizard, and Storage Management.

Skilled in ETL Operations, Export & Import data from Excel File, Flat file, CSV file to/from SQL Server Database using SSDT

Developed, deployed, and implemented security for SSIS Packages

Configured and automated SQL Server Agent jobs using SSIS packages.

Establishes and builds strong working relations and partnerships with Business Units and Senior Management

Having excellent verbal, written and presentation skills, independent problem solving, team player, proactive, multi-tasking and prioritizing skills, detail oriented and excellent interpersonal skills

Education and Certification.

BSc in surveying technology/ Computer science.

MSc in Civil Engineering.

Technical Skills

● Operating Systems: Windows server 2019/2016/2012R2/2012/ 2008/2003 and UNIX

● Languages: T-SQL, PowerShell, JavaScript

● Databases: MSSQL, Databases on

Azure and AWS

● ETL: DTS, VS, Power BI

● Project Tracking Tool and Ticketing: ServiceNow, JIRA, MS project

● Monitoring tools Indera, Red gate, LightSpeed.

Work Experience

SQL Server DBA - June 2021 to Present

JP Morgan - Dallas, TX

• Installing, configuring, and maintaining SQL Server Enterprise (2022,2019,2017,2016, 2014, 2012, 2008R2) in production, test, and development environments.

• Working on database backup and restore including Point-in-Time Recovery, automating SQL agent job process and schedule the administration tasks.

• Maintaining server level, database level and object level security best practices by creating Logins and Users, Contained Databases, configuring permissions and assigning different roles to users.

• Use DBCC commands to check physical and logical consistency of the databases and reorganized/rebuilt indexes, Create and update statistics and managed the databases effectively.

• Working on resolving the Tempdb and disk space issues

• Monitoring blocking /deadlocks and maintaining all the OLTP servers with maximum database availability, reliability and investigate and resolve any database related issues.

• Performs performance tuning for Server, Database, and Query, using Profiler, Execution Plans, Profiler, DMV, Query Store, Database Tuning Advisor, and third-party tools.

• Successfully performs in-place, side-by-side upgrade and migration and handled post migration issues.

• Configuring, maintaining, and troubleshooting Always on Availability Groups, Log shipping, Failover cluster, mirroring, and Replication.

• Perform Database Refresh on development and test environment.

• Managing SQL Azure, Azure managed instance, VM

• Working on configuring linked server including from various RDBMS.

• Monitor windows event log for system, application errors, and available issues.

• Working SSIS Packages to Extract, Transform and Load data into database.

• Address security and upgrade issues by applying Service Pack / Hot Fixes on SQL Server.

• Providing 24/7 on-call support on rotation basis for production databases SQL Server DBA - March 2019 to May 2021

United HealthCare - Richardson, TX

• installed, configured, and maintained MS SQL Server 2012 and 2014,2016,2017 and 2019.

• Designed the database backup and recovery strategy; monitored to ensure backups were completed, was able to recover database to a specific point-in-time, per requests or during outages.

• Conducted troubleshooting of database issues; resolved performance problems; ensured data optimization.

• Collaborated with infrastructure and development teams to ensure database availability.

• Created server logins, database users, custom database roles, assigned users to specific roles and ensured only the required privileges are granted to the users.

• Applied SP (Service Pack)/ Hot Fixes on SQL Server Instances to address security and upgraded related issues.

• Proactive in reviewing security logs, user logins within SQL server and third-party solutions to prevent breach or violation.

• Apply various replication and HADR models including log shipping, Configured SQL Server Replication between Publisher and Subscriber server, database mirroring, Always On and Clustering.

• Database migration between various database servers.

• Configured & Managed Database and Data Security Solutions applying TDE (Transparent Data Encryption), Row Level Security, Column level encryption, Dynamic Data Encryption, Role based Security Policy, Security Auditing.

• Setup new backup procedures and jobs to automate the backup process.

• Check for the failed jobs and investigate the root-cause analysis for maintenance jobs that run against temp tables, logs, history, backup files etc...

• Developed & implemented database maintenance plans like, Index rebuild or re-organize, update statistics.

• Perform Database Refresh.

• Migrated SQL server database from on-prem to Azure cloud.

• Troubleshoot performance issues related to query optimization, tempdb, log file growing fast, identify and release Lock, block, and deadlock.

• Used SQL Server Profiler, Extended Event, Query store, Database Engine Tuning Advisor, Performance Monitor, and Activity Monitor to analyze and monitor performance of the system.

• Installed and configured and administered SQL Server Reporting Services (SSRS)

• Installed and Configured SQL Server Integration Services (SSIS)

• Exported, imported data from SQL Server to Text file, Excel file and CSV format using SSIS packages and BCP/SSDT tool and vice versa.

• Commitment to excellent customer service with 24x7 on-call support. SQL Server Jr DBA - Jan 2017 to Feb 2019

Zemen Bank. - Addis Ababa, ET

• installed, configured, and maintained MS SQL Server 2012,2014,2016,2017 and 2019.

• Upgraded and migrated SQL Servers.

• Utilized DBCC and DMV for a variety of purposes.

• Managed indexes created the backup/restore strategy for both production and development.

• Performance tuned for improvement; included SQL/TSQL code using Query Execution Plan, Database Tuning Advisor, Profiler, Monitoring Lock/Block, and Sessions.

• Troubleshoot performance issues related to query optimization, tempdb, log file growing fast, identify and release Lock, block, and deadlock.

• Maintaining server level, database level and object level security best practices by creating Logins and Users, Contained Databases, configuring permissions and assigning different roles to users.

• Perform Database Refresh on development and test environment.

• Used SQL Server Profiler, Extended Event, Query store, Database Engine Tuning Advisor, Performance Monitor, and Activity Monitor to analyze and monitor performance of the system.

• Instrumental in database mirroring, log shipping, replications, and clustering.

• Addressed security and upgrade issues by applying Service Pack / Hot Fixes on SQL Server

• Wrote T-SQL and stored procedures for reports and applications.

• Worked on SSIS Packages to Extract, Transform and Load data into database.

Contact this candidate