HAYLEYASUS NEGA

Phone: 346-***-****

Email: ad1aq6@r.postjobfree.com

Houston, TX

PROFESSIONAL SUMMARY

* + years of experience as Microsoft SQL Database Administrator. Responsibilities include SQL server installation-configuration-administration, SQL optimization, Performance tuning, production support, maintenance review, Disaster recovery planning and ensuring 24x7 supports. US Citizen.

Excellent experience working on different versions of SQL server like 2008R2, 2012, 2014, 2016 & 2019.

Excellent hands-on experience in Elastic Jobs and Run Books on Azure. Deploy, Configure, Maintain Compute on Azure IAAS and PAAS servers. Troubleshoot Azure related issues and engage internal teams and vendor issue resolutions.

Monitor performance and setting up alerts to avoid performance issues occurring on Azure databases.

Having good knowledge on External tables and Elastic pool Model(s). Import and Export data within Azure Cloud environment.

Expert in the areas of Microsoft SQL Server installation, Configuration, Server upgrade, Performance tuning, Backup and recovery, Disaster recovery techniques such as mirroring, log shipping and clusters.

Having hands on experience migrating scripts in a production environment and extensive experience in creating and modifying stored procedures, triggers, cursors and functions to meet business requirements.

Installing and configuring SQL Server instances on Standalone and Clustered environment.

Monitor database server resources and provide recommendations on hardware/software upgrade to increase server performance, monitor databases and resolve any blocking issues, and identify slow running queries and perform performance tuning by examining the execution plans and creating missing indexes to boost the query performance.

Sound knowledge in stored procedures, Indexed views, User Defined Functions (UDL), Triggers Distributed Queries and Common Table Expressions.

Working with Active directory.

Ensuring high availability of databases for smooth running of the business by implementing high availability solutions like Always On, Database Mirroring, Log shipping and failover Clusters depending upon the criticality of the applications and as per Organizational requirement.

Experience in Data Modeling (Logical and Physical Design of Databases), Normalization and building Referential Integrity Constraints. Designed schemas. Built tables, FKs, PKs, etc. by providing a structure that meets the business needs.

Sound knowledge stored procedures, Indexed views, User Defined Functions (UDF), Triggers Distributed Queries and Common Table Expressions, Tables, Views and other T-SQL code and SQL Server joins for applications.

Understand and implement organizational standards across all servers in all environments and follow processes in performing day to day administrative tasks. Have monitoring jobs in place that helps audit the activities on the servers and databases.

Experience in providing Logging, Error handling by using Event Handler, and Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations.

Verifying the status of Disk spaces of the servers and Log spaces of Databases and taking appropriate action if required.

Improving query optimization performance using profiler, execution plan, Database Tuning Advisor.

TECHNICAL EXPERTISE

Platforms

Windows Server 2000/2003/2008/2010, Task Manager, Perfmon, Services.msc, Task Scheduler, Control Panel, Command Prompt

Languages

T-SQL, PL/SQL, HTML, SQL

RDBMS

Microsoft SQL Server 2008-2022, Azure

SQL Server Tools

Management Studio, SQL Server Profiler, DTS/SSIS (ETL), Database Tuning Advisor (DTA)

Case Tools

MS Office 2000/XP/2003/2007/2010, MS Excel 2000/XP/2003/2007/2010, MS Outlook /2000/2003/2010,

BI and Modeling Tool

SSIS, SSRS, SSAS, Erwin

Scripting and 3rd Party Tools

PowerShell, Redgate Tools, Golden Gate, SharePoint, Service now, SolarWinds DPA, Commvault,Dynatrace

PROFESSIONAL EXPERIENCE

Title: SQL DBA

Client: Community Health Choice November 2022 – Present

Responsibilities:

Installed, configured, and managed databases in UNIX/Linux environments.

Having very good knowledge on saving the cost on Azure models.

Proficient in managing backups, maintenance tasks, and patching for Azure SQL Managed instances to maintain data integrity and system stability.

Strong knowledge of Azure SQL Managed instance security, implementing role-based access control (RBAC) and data encryption to safeguard sensitive data.

Deploy, Configure, Maintain Compute on Azure IAAS and PAAS servers.

Implement and enforce security measures to protect sensitive data within the data warehouse.

Ensure compliance with industry regulations and data privacy laws (e.g., GDPR, HIPAA) in data warehousing operations.

Proficient in configuring azure ExpressRoute and VPN gateways to establish secure and reliable connections between on premises infrastructure and Azure resources.

integrate data from various sources, including on-premises databases, cloud services, and external data providers, into the data warehouse.

Manage data consistency and quality during the integration process.

Troubleshoot Azure related issues and engage internal teams and vendor issue resolutions.

Automate deployment and troubleshoot mechanisms for quick service.

Create and configure Logical SQL servers, databases, elastic pools in Azure Cloud.

Monitor performance and setup alerts to avoid performance issues occurring on Azure databases.

Having hands on experience in Elastic Jobs and Run Books.

Having good knowledge on External tables and Elastic pool Model(s).

Having hands on experience into the Reservations and Azure hybrid benefits.

Import and Export data within Azure Cloud environment.

Creating and Managing logins/Access levels in Azure IAAS and PAAS environments.

Provide Production, Staging and Integration SQL Server database Administration support with databases as large as 14TB.

Installed and configured two node clustering i.e., active/active and active/passive.

Implemented and configured Always on High Availability in MSSQL Server 2012.

Experience in implementing HADR solutions like Clustering, Replication, mirroring and Log shipping

Configured Active Geo Replication, Failover Groups using Azure portal.

Installation, Configuration and Standardization of SQL server for optimal performance.

Configured on-premises Sql database backups to Azure using Microsoft Azure Backup tool.

experienced in Migrating on Premises SQL Databases to SQL Azure using DMA & DMS.

Worked on Creating logins, users and assigning the permissions to the users in Azure.

Installed and configured MS SQL Server VM in Azure Database.

SQL Server High Availability and Disaster Recovery solutions- Always-On Availability Groups, Failover Clustering, Mirroring, Log Shipping, Replication.

Build dashboards, reports using SQL, DAX, Power BI or other visualization tools.

Data modeling, Azure Data factory, Building Pipeline, SSIS, SSRS, Power BI

Capacity Planning, Storage Planning, Hardware Upgrade’s and Preparing Estimates for database.

Incident and Problem Management focusing on continuous improvements and quality of service.

SQL Server Security Auditing, hardening and remediation.

Design and Implement Database Backup and Restore policies.

Written PowerShell scripts automation and to name a few, a script that will count files with email notifications when it exceeds certain thresholds, that deletes old files that older than.

Build project documentation and troubleshooting guides.

Creates incident (ICM) related performance analysis and reporting for review by IT management.

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

Performed backup using backup compression and data compression in SQL server databases on clustered environment.

Maintained referential, domain and column integrity using constraints.

Analyzed traces, debug stored procedures, triggers, and packages.

Title: SQL DBA

Client: CVS /Aetna September 2021 – October 2022

Responsibilities:

Lead multiple infrastructure planning and implementation including SQL Server instance strategy, backup and recovery strategy, tuning, configuration, troubleshooting, and building.

Lead the database instance and schema implementation activities for all projects.

Extract data from external systems, transform data and load them into the existing databases using SSIS packages.

Experience in Data Modeling (Logical and Physical Design of Databases), Normalization and building Referential Integrity Constraints. Designed schemas. Built database objects E.g tables, constraints (Foreign key, Primary Key, etc.) by providing a structure that meets the business needs.

Applied Patches and Service packs, hot fixes to update different versions of MS SQL server.

Implement backup plans, monitor and maintain Backup and Recovery on servers.

Perform daily, weekly and monthly Database Maintenance tasks.

Database design and optimization of databases for better performance.

Managing SQL Server security by creating roles and security groups.

Monitor and resolve blocking issues in coordination with application team.

Proactively check the SQL Server Error log and take appropriate action to avoid downtime.

Analyze slow running queries across environments and find the root cause for the same and resolve by introducing missing indexes, partitioning tables and placing them in different file groups on different drives to improve performance.

Monitoring SQL Server performance by finding deadlocks and blocking.

Import/Export data as per user request using import export wizard.

Deploying/Migrating DTS and SSIS packages; help troubleshoot issues with packages.

Perform database refresh and fix orphaned users on the refreshed database.

Support Disaster Recovery project planning, testing and implementation.

Worked on Migrating data from SQL server 2012 to 2019 versions.

Create views, indexes, functions, stored procedures and scripts.

Database and Code Implementation on production environment. Once production implementation is completed provide maintenance and support for the databases.

Backup client databases and perform database restore and run consistency checks from SQL Server and application.

Reviewing SQL Server and SQL Server Agent Error Logs.

Data modeling, Azure Data factory, Building Pipeline, SSIS, SSRS, Power BI

Capacity Planning, Storage Planning, Hardware Upgrade’s and Preparing Estimates for database.

Incident and Problem Management focusing on continuous improvements and quality of service.

SQL Server Security Auditing, hardening and remediation.

Design and Implement Database Backup and Restore policies.

Automate routine maintenance tasks using PowerShell.

Build project documentation and troubleshooting guides.

Creates incident (ICM) related performance analysis and reporting for review by IT management

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

Performed backup using backup compression and data compression in SQL server databases on clustered environment.

Title: SQL DBA

Client: Chevron, Houston, TX January 2019 – August 2021

Responsibilities:

Experienced in supporting and managing large size environment.

Performed standard database maintenance activities such as backup/restore, re-indexing, log file management, security patching, etc.

Upgrading and maintaining of database versioning, patching and upgrading database and grid infrastructure.

Experienced in troubleshooting SQL Server including performance issue.

Monitor incident queue and work request queue, supporting day to day operations.

Install Microsoft SQL Server DBMS, deploy security patches and migrate SQL Server databases to newer versions.

Experienced on database storage and capacity monitoring and forecasting and provided recommendations to management on long-term capacity plans.

Experienced in advising application development team on process bottlenecks and provide databases tuning to ensure optimal performance.

Experienced on day-to-day production support including checking daily logs, backup/recovery procedures, disaster recovery, and periodic maintenance.

Experience installing, configuring and maintaining SQL Server in a Clustered environment, as well as Transactional Replication.

Performed daily system monitoring and environmental health checks.

Performed database deployment changes across development, test, and production environments though established release management procedures.

Able to implement complex projects and time-sensitive tasks under minimal supervision.

Experienced Design, implement, maintain security administration reports as required.

Experienced with backups, restores and database recovery models.

Monitor, evaluate and perform administration of local area network servers.

Reviewing/resolving backup issues and experience in database failovers/recoveries.

Experienced with PowerShell.

Ability to quickly troubleshoot and resolve complex problems in a live environment.

Provide 24/7 on call support as part of an on-call rotation.

Title: SQL DBA

Client: DXC Tech Austin, TX August2016 – December 2018

Responsibilities:

Installation and Configuration of Microsoft SQL Server instances.

Database creation and implementation of code on database servers.

Plan and implement robust Backup and Restore strategies.

Configuring SQL Server mail, scheduling tasks and managing alerts.

Co-ordinate with onsite DBAs and ensure smooth running of the system.

Worked on security management and linked Server creation.

Provided support for DTS/SSIS package migration and implementation.

Monitoring SQL Server performance using System Monitor and SQL Server profiler.

Preparation of Knowledge sharing documents on SQL Server.

Automated DB maintenance tasks by developing scripts for providing consolidated reports over mail for daily full and transactional log backups across all production servers.

Handle ad-hoc user requests like granting permissions, database refresh from production to development environments and identify slow running queries.

Developed SSIS packages for maintenance plan tasks.

Manage data, transactional log file growth and implement file management policies.

Ensure weekly index rebuild and update statistics jobs run fine on production systems.

Capacity planning for new and existing SQL servers to manage database files.

Prepare knowledge sharing technical documents on SQL server DBA activities.

Maintain SQL Server Production databases and ensure high availability.

Interact with the client, understand and gather requirement, identify the DB objects to be modified and new objects to be created.

Manage space on database servers by proactively forecasting the DB growth.

Backup databases before change implementation and ensure rollback capability.

Perform ETL operations with the help of SSIS packages for the initial setup of DBs.

Restore development and staging databases to help development team work on the current version of the database to avoid errors during production move up.

Create roles and grant permissions to users upon proper approval from business.

Ensure the change process is followed religiously and suggest changes required.

Managing SQL Server security by creating roles and security groups.

Title: SQL DBA

Client: BBVA Compass Bank Atlanta, GA August 2015– July 2016

Responsibilities:

Installed, upgraded, and configured SQL Server for several applications with the latest

service packs.

Support production systems and migrate data from older servers to newer systems and

responsible for administrating the releases as they come available.

Backup and recovery strategy planning and implementation along with environment

transition planning (development, test, stage, production).

Responsible for DB Migration, code deployments, backups and recovery, DB upgrade,

performance tuning and optimization, troubleshooting and error resolution, DB and

Logins creation and granting privileges, OLTP, OLAP.

Rebuilding the indexes at regular intervals and placing the huge table/non-clustered index

on a separate file group to improve the performance.

Responsible for applying the service packs to MSSQL Server standalone and multi-node

clustered instances.

Applied patches to various MSSQL Server standalone instances, two-node, three-node,

and four-node clustered instances.

Configured Database Mirroring to create a Disaster Recovery Stand by servers in the

environment.

Troubleshooting on SQL Server Database Data File Full/ Log File Full issues.

Worked on Always On the environment and configured Always-On (AAG) in SQL with 5

replicas which included 1 primary replica and 4 secondary replicas.

Review database design and provide backup recovery making recommendations regarding.

enhancements and/or improvements.

Monitoring database size and disk space in the Production Environment.

Configured Snapshot, Transactional and Merge Replications along with Distribution,

Publication, and subscription replication.

Implemented many automated tasks using PowerShell, TSQL, or Command line utilities.

Supporting SQL Server databases mirroring and environments.

Performance tuning with application teams to isolate and resolve performance issues.

Working with a wide variety of customers that have varying skills and a diverse set of needs.

Working with change control and ticketing systems to coordinate changes with other infrastructure teams.

Created, upgraded, maintained, while working closely and coordinating with hardware, network, and OS administrators.

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

EDUCATION

●BSC In Computer Science, July2013, Mekelle University, Ethiopia

●BA in Accounting and finance, June 2014, Mekelle university.

●Microsoft Certified MSSQL Server 2012 Database Administrator.

Contact this candidate