Certification

Azure Database Administrator Associate

Education

BS, Addis Ababa University, 06/2006

Addis Ababa, Ethiopia

BS, San Jose State University, 12/2012

San Jose, California

ABSTRACT

I am a certified Microsoft SQL Server Database

Administrator (DBA) with a diverse industry

background and extensive experience in managing

SQL server databases. My expertise encompasses

various tasks such as installation, configuration, updates, and migration of SQL servers. I possess

strong skills in storage capacity planning, disaster recovery, and high availability solutions like log shipping, mirroring, replication, and AlwaysOn.

Additionally, I am well-versed in SSIS, SSAS, SSRS, PowerShell, Ansible, and T-SQL, enabling me to

handle complex database operations and automate

routine tasks. With a commitment to staying updated with industry advancements, I am equipped to ensure the integrity, performance, and security of database systems. As a dedicated DBA, I am prepared to

contribute my skills and knowledge to drive

organizational success.

Getachew Alex

San Jose, CA 95126

• Follow enterprise standards, procedures, physical data storage, maintenance, access, backup and recovery, documentation, security, and best practices in a team environment.

• Responsible for the installation, update, configuration and production support for all SQL Server Database Services and servers

• Provides SQL DBA support based on SQL monitoring and maintenance solutions, respond to SQL alerts, and provide on-call support.

• Works closely with application and IT teams to design and optimize all DB environments.

• Performs advanced database administration activities including installation, configuration, monitoring, space management, database backup and recovery, and disaster recovery procedures.

• Performs installation, configurations, and maintenance for SQL Server AlwaysOn Availability Group

• Performs database environment reviews and provides DB improvement solutions to application owners.

• Provide HA and DR solutions for Dev, Test, and production environments.

• Provide technical writings and detailed documentation on technology standards and procedures and make recommendations for optimization.

• Independently be able to provide performance measures of transactional databases, identifying bottlenecks, disk analysis and other metrics to provide tuning recommendations. adx3jt@r.postjobfree.com

408-***-****

Professional Summary

Over 8 years of on-premises Microsoft SQL Server Database Installation, Configuration, Administration, Maintenance, Performance Tuning, Backup/Restore and Disaster Recovery procedure in SQL Server 2019/2017/2016/2014/2012/2008R2 for Development, Test & Production servers with High availability, and large OLTP transaction server environments.

SSIS & SSRS

o Installing and Configuring SQL Server Reporting Services (SSRS) based on the application needs and requirements.

o Creating different reports for internal DBA task purposes using native Microsoft Report Builder.

o Installing, Configuring SSIS and maintaining SSISDB database for successful package deployments.

o Worked with Developers closely to deploy SSIS/SSRS/SSAS packages and troubleshooting permissions, connection strings and variable errors during deployments. o Troubleshooting SSRS performance

AZURE

o Consulted, Designed, and built AZURE cloud service models including Infrastructure-as- a-Service and Platform-as-a-Service.

o Experienced on AZURE SQL managed Instance and AZURE SQL Databases on deployments and ongoing support by using AZURE Database Migration Assistant and AZURE monitoring tools.

o Worked with AZURE Synapse Analytics for Data Ingestion, Pipelines, Data Mapping and Data Transformations.

o Encrypting Azure SQL databases using Key Vault

o Worked in Azure data factory to integrate data migration from Cloud to cloud and on- prem to cloud.

o Worked in Azure database (PaaS) Gro-replication. o Worked in SQL server in Azure VM (IaaS) (Provisioning, Installation, Configuration and Monitoring)

Amazon AWS and Amazon RDS

o Worked on migrating on premise SQL Databases to Amazon Cloud Web Services (EC2, ELB, VPC, S3, CloudFront, IAM, RDS, Route 53, CloudWatch, SNS). o Proactively monitor resources and applications after migration using AWS Cloud Watch including creating alarms to monitor metrics such as EBS, EC2, RDS, S3, SNS and configured notifications for the alarms generated based on events defined. Technical Skills

Database

- MS-SQL Server 2019/2017/2016/2014/2012/2008R2

- Testing SQL 2022

- MySQL

Operating System - Windows Server 2019/ 2016/ 2012/ 2012R2/ 2008R2/ 2008 Qualification and Experiences

Collaborating with developers and other infrastructure team members to accommodate new application interfaces functionality.

Participating in database planning, including data modeling and design, availability, disaster recovery, and capacity planning.

Coordinating with developer team to create, configure and manage various database objects including tables, indexes, functions, procedures, packages, triggers and facilitating work of developers by resolving issues that might impede their ability to get their work done in time.

Providing application support and integration, including creating database environments, integrating with applications, query development and optimization, and incident response.

Providing database administration support to third party vendors, developers, and others

Creating and managing users, security, and object permission: Granting permissions, assigning database roles, and server roles.

Establishing and maintaining sound Backup & Recovery policies for various mission-critical business applications and disaster recovery procedures to meet the business Recovery Point Objectives (RPO) and Recovery Time Objectives (RTO).

Failure diagnosis & root cause analysis for database recovery scenarios.

Data scrubbing and normalization

Setting up database Replication models (Snapshot, Transactional and Merge), Log Shipping, Clustering and Migrating SQL servers on Physical and Virtual machines.

Extracting and transforming data using data transformation services like import/export wizard, BCP, Bulk insert, attach/detach and data movement between databases.

Turning SQL Server Integration Services (SSIS) packages and Reporting Services (SSRS) creating deployment utility to Deploy SSIS Packages over Production and QA Systems.

Experienced with programming languages such as PowerShell and Ansible Tower.

Participate in deep architectural discussions to build confidence and ensure customer success when building new and migrating existing applications, software, and services on the AZURE platform.

Extensive experience with partitioning, indexing, and data sharding techniques to optimize database performance and scalability.

Proficient in implementing and managing structural operational and data sharing methodologies to ensure efficient data access and distribution.

Strong knowledge of policies and best practices related to database management, ensuring data integrity and security.

SQL Server Tools

- SQL Server Management Studio, SQL Server Data Tools, Business Intelligence Development Studio

- Visual Studio, SQL Profiler, Performance Monitor, DTS, Database Engine Tuning Advisor, Microsoft Clustering Services

Case Tools - MS Office, MS Excel, MS Outlook, MS Visio, Pinnacle, Astra ETL Tools - SSIS, SSRS, Import/Export wizard.

Languages - T-SQL, PowerShell, Ansible Tower, DBA tools Third-party tools - Redgate, LiteSpeed, FogLight, & ServiceNow, Ansible Tower, Idera SQLSafe backup solution

Professional Experience

Sr. SQL Server Database Administrator

Feb 2022 - Current

Kaiser Permanente, Oakland, California

Installing, configuring, and managing Microsoft SQL Server in standalone and clustered environments.

Designing and developing automated database refresh for all the system test and UAT environments from production backups for Scrum team’s development and testing.

Developing various aspects of databases creation and modification procedures to satisfy business needs.

Implementing partitioning, indexing, and data sharding techniques to optimize database performance and scalability.

Implementing and managing structural operational and data sharing methodologies to ensure efficient data access and distribution.

Managing HIPPA related databases and generating quarterly and annual audit reports.

Automating and configuring server level and database level management tasks using T-SQL and Power Shell scripts.

Monitored and tested the health of Availability Groups using dbatools.

Enforcing and implementing group level security using windows group accounts to manage group permissions effectively.

Writing complex T-SQL queries and stored procedures for retrieval of data and other applications.

Designing backup and recovery procedures to reduce downtime and maximize recoverability.

Implementing different types of high availability and disaster recovery mechanisms such as log shipping, database mirroring, clustering and AlwaysOn Availability group setup and configuration.

Capacity planning, space allocation, and proactive database growth and storage requirements.

Setting up Transactional Replication to synchronize a subset of tables to multiple subscribers in real-time for reporting purposes.

Planning and executing database consolidation to reduce licensing costs, hardware, and software expense.

Designed and developed data pipelines using SQL Server Integration Services (SSIS), TSQL, PowerShell and Stored Procedures

Using dbatools configured database migration.

Collaborating in designing and implementing backend database storage layout for databases created through the application as per the requirement of application installation document.

Troubleshooting databases from SQL Server 2012 to SQL server 2019 AlwaysOn Environment.

Collaborating with IT operations and testing organizations to ensure timely releases of projects and make sure database environments are sustainable.

Conducting system tests, troubleshooting customer issues, and correcting database defects.

Migrating databases across multiple versions and environments by coordinating with different teams and application contacts.

Creating and modifying stored procedures, indexed views, triggers, cursors, and functions to meet business requirements.

Using SQL profiler and extended event templates to capture different types of SQL activities including long running queries and deadlocks. Developing the process to invoke the SQL profiler trace to run in the background based on the schedule and import the trace files into SQL tables for sorting and further analysis.

Provisioning, Installation, Configuration and Monitoring of Azure Database, Azure Managed Instance and Azure VM.

Encrypting Azure SQL databases using Key Vault and Azure database Geo-replication

Managing Azure data factory to integrate data migration from Cloud to cloud and on-prem to cloud.

Providing 24x7 production database support on a rotational basis for weekends and during production code deployments.

Environment: SQL Server 2019/2017/2014 and Windows Server 2012/2008/2003 Skills: Storage and capacity planning · Migration · T-SQL Stored Procedures · SQL Server Integration Services (SSIS) · SQL Server Reporting Services (SSRS) · SQL Server Analysis Services (SSAS) · Replication · Extract, Transform, Load (ETL) · Database Maintenance · Backup & Recovery Systems · Visual Studio · Performance Tuning · Disaster Recovery · Active Directory · SQL Server Management Studio · Transact-SQL (T-SQL) · Microsoft SQL Server . PaaS . IaaS

Sr. SQL Server Database Administrator

Nov 2020 – Jan 2022

Energy Transfer, Houston, Texas

Installed, configured, and monitored SQL Server 2017/2016/2012/2008R2 with large sized databases.

Tested installation and configuration on SQL Server 2019

Created SQL Server Maintenance plans to automate routine jobs, workflows, and data loading processes.

Automated and configured management tasks using Power Shell scripting language and windows scheduler as an add on a third-party tool Ansible Tower.

Provided technical guidance during all phases of development and deployment process.

Applied SQL server updates, patches, and hotfixes with newly Released Service Packs from Microsoft.

Created availability groups and set up AlwaysOn High Availability on SQL 2016 and 2017 Servers.

Implementing partitioning, indexing, and data sharding techniques to optimize database performance and scalability.

Implementing and managing structural operational and data sharing methodologies to ensure efficient data access and distribution.

Build real-time reporting and dashboards to maintain the performance of database servers.

Involved in migrating SQL Server 2008 to 2016 and SQL Server 2012 to 2017 using dbatools.

Participated in SQL Server in-place upgrade for windows 2012R2 to 2016 enterprise edition.

Managed SQL user logins, permissions, database user accounts, server roles, database roles.

Configured and supported Transactional Replication between Publisher and Subscriber SQL Server instances.

Managing SOX related databases and generating quarterly and annual audit reports.

Updated database statistics and indexes using DBCC commands.

Monitored Disk space, memory and User connections using Windows Performance Monitor and third-party tools.

Designed and implemented comprehensive Backup plan and disaster recovery strategies.

Maintained the database consistency with DBCC and Dynamic Management Views (DMVs) at regular intervals.

Monitored and tuned databases to meet the performance and availability requirements of on-line systems.

Performance tuning of long running SQL queries and Stored Procedures using SQL Profiler and Query Execution Plans.

Troubleshoot and resolved blockings, locks, deadlocks using SQL Server Profiler, Activity Monitor, DMV's, and Database Engine Tuning Advisor/DTE.

Modified database structures including tables, stored procedures, views, triggers, user-defined functions to support application enhancements.

Installed, configured, and monitored Doubletake Replication between production and DR Servers.

Performed DR exercise before Go live for SQL Server database.

Created alerts, notifications, and emails for system errors, insufficient resources, and fatal database errors.

Fashioned complex stored procedures, functions, and cursors.

Provided 24x7 support on a rotational basis for weekends and during production code deployments.

Environment: SQL Server 2017/2016/2012/2008R2, Windows Server 2012/2008 SQL Server Database Administrator

June 2018 - Nov 2020

Bank Of America, Houston, Texas

Installed, Configured, Administered, maintained, and utilized policies and procedures for ensuring the integrity, validity, and consistency of the database.

Developed strategies for data acquisitions, archive recovery, implementation of data access and table maintenance of SQL databases.

Participated in capacity planning and reviewed database changes for system impact.

Developed and created database objects including tables, views, index, stored procedures, and functions.

Maintained referential, domain and column integrity using constraints.

Managing PCI related databases and generating quarterly and annual audit reports.

Participated in migrating SQL Server 2008 databases to SQL Server 2014/2016

Developed physical data models and created DDL scripts to create database schema and database objects.

Interacted with Business Analysts and Developers in identifying the requirements and designing and implementing the database schema.

Generated periodic reports based on the statistical analysis of the data from various time frames and division using SQL Server Reporting Services (SSRS).

Developed various operational, drill-through, drill-down reports using SSRS and added report parameters.

Migrated DTS packages to SQL Server Integration Services (SSIS) and modified the package according to the advanced feature of SQL Server Integration Services.

Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases and data mart databases built on star schema with facts and dimensions.

Used DBCC Statements to perform maintenance tasks on the database. Executed DBCC commands like CHECKDB before backing up the databases.

Performed Database and Log Backups & Restoration, Scheduling Backups. Backing up master & system databases and restoring them when necessary between various environments

Troubleshot system issues, monitored scheduled jobs, and set up maintenance plans for proactively monitoring the performance of SQL Server databases.

Developed system maintenance tasks such as Database Backup & Recovery, database mirroring and replication and apply in Dev and Testing Environment.

Monitored and troubleshot blocking, deadlock issues and performance tuning.

Supported all SQL instances on production, staging, testing and development databases.

Created logins, groups, users, roles, database devices, databases, mirroring devices, checking for database consistency, fixing DBCC errors, monitoring error logs, database space allocations, transaction log space allocations, fine tuning SQL performance.

Resolved Locking and Blocking issues by using various SQL server internal commands.

Provided 24x7 support on a rotational basis for weekends and during production code deployments.

Environment: SQL Server 2014/2012/2008R2/2008, Reporting Services (SSRS), Integration Services (SSIS), Analysis Services (SSAS), Oracle 9i/8i, T-SQL, Windows 95/NT/2000/2003, XML, MS Excel, and MS Access.

SQL Server Database Administrator

Jan 2016 – May 2018

Transcore, Houston, Texas

Administered SQL server 2008R2, 2012 and 2014. Performed SQL Server upgrade.

Maintained the integrity and performance of SQL server databases and to ensure the data is stored in a consistent manner, securely and optimally.

Created Clustered and Non-Clustered indexes on tables to speed up OLTP query performance.

Worked on multiple SQL instances in clustered environment for server consolidation projects built on SAN using required RAID levels.

Created database maintenance plans for the performance of SQL Server including database integrity checks, update database statistics, re-indexing, and data backups.

Administered multiple SQL server database objects, logins, users, and permissions in each registered server.

Managed Database files, transaction log and estimated space requirements for Capacity planning purposes

Participated in database server tuning, application tuning, maintaining documentation, capacity planning, and database security.

Involved in writing reports, documentation, and operating manuals.

Tasked with Performance Tuning and Maintenance plan for consistency checks, backup/restore and Rebuild Indexes

Ran various DBCC commands like checkdb/checkable, showcontig, showstatistics for checking database consistency.

Involved in installing SQL Clustering for production environments, implementing Log Shipping

Configured and audited SQL server security in line with business requirements.

Configured database mail setup and received alerts for the threshold values.

Participated in database migration and upgrade from SQL server 2008R2 to 2014.

Worked with various business groups while developing their applications, assisting in database design, phasing from development to QA and to Production environment. Environment: MS SQL Server 2008R2, 2012 and 2014, SSIS, SSRS, DTS, SQL Management Studio, SQL Server Business Intelligence Tools, Windows 2003, SQL Server Query Analyzer, SQL Profiler

SQL Server Database Administrator

Dec 2014 – Jan 2016

Banfield Pet Hospital, Portland, Oregon

Administered SQL server 2008R2, 2012 and 2014. Performed SQL Server upgrade.

Maintained the integrity and performance of SQL server databases and to ensure the data is stored in a consistent manner, securely and optimally.

Created Clustered and Non-Clustered indexes on tables to speed up OLTP query performance.

Worked on multiple SQL instances in clustered environment for server consolidation projects built on SAN using required RAID levels.

Created database maintenance plans for the performance of SQL Server including database integrity checks, update database statistics, re-indexing, and data backups.

Administered multiple SQL server database objects, logins, users, and permissions in each registered server.

Managed Database files, transaction log and estimated space requirements for Capacity planning purposes

Participated in database server tuning, application tuning, maintaining documentation, capacity planning, and database security.

Involved in writing reports, documentation, and operating manuals.

Tasked with Performance Tuning and Maintenance plan for consistency checks, backup/restore and Rebuild Indexes

Ran various DBCC commands like checkdb/checkable, showcontig, showstatistics for checking database consistency.

Involved in installing SQL Clustering for production environments, implementing Log Shipping

Configured and audited SQL server security in line with business requirements.

Configured database mail setup and received alerts for the threshold values.

Participated in database migration and upgrade from SQL server 2005 to 2008r2.

Worked with various business groups while developing their applications, assisting in database design, phasing from development to QA and to Production environment. Environment: MS SQL Server 2008R2, 2012 and 2014, DTS, SQL Management Studio, SQL Server Business Intelligence Tools, Windows 2003, SQL Server Query Analyzer, SQL Profiler

Contact this candidate