Messiah A. Email & Phone Number

Houston, Tx, Us

Boise, Id, Us

SQL Server DBA, my duty is to manage and maintain SQL Databases through multiple tiers, including Development, Staging, QA, and Production.I also deliver proactive assisting in migrating/upgrading from lower versions to higher and documenting security models/standards.I am responsible for managing daily support requests, including but not limited to performance issues and database refreshes.Moreover, I supported and maintained high availability mechanisms, such as AlwaysOn Availability group and set up SQL Agent jobs. Key Contributions:• Designed, configured, and maintained High Availability and Disaster Recovery solutions, including Windows Failover Clustering, Always-On, Log Shipping, and Replication. • Performed Database Refresh as requested, and backup databases using backup compression in SQL server databases • Performed Database Migration and upgrade from a lower version to a higher version. • Assisted Engineering team in applying data modeling techniques to ensure development and implementation. • Automated maintenance jobs on Databases using different maintenance solutions and scripts.• Enabled, administered, and maintained change data capture (CDC) for audit solution in production SQL Servers. • Performed decommissioning of old unused serves and databases by moving data to Archived instances. • Participated in building a new server for AlwaysOn Availability Group database and in manual failover. • Handled server and database level securities and permissions with different teams across the environment based on business requirements. • Participated in multiple backlog projects on Azure DevOps with different team members.

Houston, Texas, Us

In this role, I was responsible for delivering applicable database solutions to meet stability, reliability, and performance metrics.It was my duty to build, maintain, and support SQL Server High Availability and Disaster Recovery Solutions, including AlwaysOn Availability Groups, Failover Clustering, Mirroring, Log Shipping, and Replication.I also managed and maintained complex T-SQL queries, views, and stored procedures in a multi-database environment with little supervision.I utilized DTS and SSIS to successfully export and import data from flat/row files.I enhanced referential, domain, and column integrity by collaborating closely with developers.Moreover, I played a key role in developing and executing Database Backup and Restore policies and request procedures.Key Contributions:• Implemented SQL Server Security Auditing, hardening, and remediation.• Wrote/coded logical and physical database descriptions, specifying database identifiers to management systems.• Automated routine maintenance tasks, including routine database refresh requests using SQL Server Agent, Maintenance Plans, and PowerShell scripts.• Performed backup using backup compression and data compression in SQL server databases.• Maintained and troubleshot SQL performance issues by cycling the SQL Server error logs, Activity monitor, DTA, BCC, DMV's, and SQL profiler.• Completed SQL Server upgrade and migration from earlier versions to SQL Server 2012/2014/2016/2017.• Applied SQL Server Performance Tuning and Query optimization and used SQL Profiler, DTA, and Query Execution plan and Indexing maintenance.• Conducted Database Migration from On-Premises SQL environment to Azure Database in the cloud.• Configured data partitioning and table partitioning on huge tables containing numerous numbers of rows to improve performance and manage storage.

Us

In this company, my duty was to lead daily data management activities, including end-to-end database support, such as installing/configuring/upgrading SQL Servers, database migration, and troubleshooting connectivity/memory issues, query performance, and server-related: auto jobs failures.I successfully installed, configured, and Administered SSRS, SSIS, and SSAS.I was responsible for conducting capacity planning, performance tuning, monitoring, troubleshooting, and optimizing databases.Furthermore, I deployed and debugged SSIS packages for import, export, and bulk inserting data with transformations from various data sources.Key Contributions:• Contributed to installing, upgrading, configuring, and migrating SQL server in clustered and non-clustered production environments of SQL server.• Setup and configured SQL Server Clustering on Window Failover Clustering Service.• Configured always on for providing AlwaysOn high availability (HADR) in both synchronous and Asynchronous modes as per application requirements.• Designed and handled High Availability and Disaster Recovery solutions such as Windows Failover Clustering, Always-On, DB Mirroring, Log Shipping, and Replication).• Uncovered and resolved the mission-critical issue of high usage of system CPU, Disk, blocking issues and transaction per/sec, and memory involved in performance monitoring of Memory, Processor, and Disk I/O.• Automated DBCC maintenance activities on Databases, Tuning Servers by setting configuration parameters, as well as Backup and Recovery of Databases using UNIX scripts.• Worked on upgrading Microsoft SQL server, failover clustering, log shipping, and replication, using System Monitor and SQL Server Profiler to identify bottlenecks, discovering slow-running queries, performing backup and recovery databases, and implementing database modifications on production servers.

During this role, I was managing SQL Server databases through multiple product lifecycle environments, from development to critical production.I provided training to non-technical users and answered technical support questions.My duty was to Identify, protect, and leverage existing data.Moreover, I designed and oversaw data analytics environments throughout the company.Key Contributions:• Scaled solutions and optimized processes using DBA knowledge to perform database architecture tasks.• Gathered, outlined and refined requirements, led design processes, and oversaw project progress.• Created and implemented complex business intelligence solutions.• Applying data modelling techniques to ensure development and implementation.• Headed the upgrading of the Microsoft SQL server, failover clustering, log shipping, and replication.• Utilized System Monitor and SQL Server Profiler to identify bottlenecks, discover slow-running queries, perform backup and recovery databases, and implement database modifications on production servers.• Participated in the development of databases, such as creating new databases, converting old databases to new ones, modifying existing databases, and creating reports to meet business needs.