Sql Server Microsoft

Summary:

•Over * years of experience in Microsoft SQL Server Database installation, configuration, administration, and performance tuning automation and scripting, data migrations, and ETL.

•Proficient in managing Azure SQL Database, Microsoft’s fully managed cloud database service.

•Proven track record in implementing high availability, disaster recovery solutions, database security, data migration, troubleshooting, database upgrades, and patches.

•Demonstrated expertise in utilizing SQL Server native tools and third-party applications, such as PowerShell, Red Gate, and SolarWinds, for monitoring, optimizing, maintaining, and troubleshooting database performance.

•Developed a disaster recovery plan for a Microsoft SQL Server database that ensured that the data was always available in the event of a disaster.

•Migrated a Microsoft SQL Server database to the cloud using Azure SQL Database.

•Optimized the performance of a Microsoft SQL Server database by using indexes, stored procedures, and triggers.

•Created custom reports using SQL Server Reporting Services.

•Troubleshooted and resolved performance issues in Microsoft SQL Server databases.

•SQL Server Reporting Services Installation, Configuration and Maintenance using Visual Studio and Reporting Services.

•First-hand experience migrating scripts in a production environment, creating, and modifying stored procedures, triggers, and functions based on business requirements.

•Use DBCC Utilities to maintain the consistency and integrity of each database in the production server.

•Firsthand in implementing SQL Server Security through administering user permissions, user roles and setting database authentication modes.

•Experience in Data Migration between several versions

•Experience Creating Packages, Jobs and Sending Alerts using SQL Mail/Database.

•Experienced in working with Azure for database migration and management.

•Excellent analytical, communication, and interpersonal skills.

Work Experience:

SQL DBA Harris Health

Houston, TX July 2021 to Present

Responsibilities

•Install, administer, and maintain MS SQL databases.

•Provide 24x7 production support, including backup and recovery of large databases.

•Manage user security privileges and access levels.

•Monitor and assess database storage spaces, capacity, and growth requirements.

•Collaborate with developers to test and accommodate new functionality.

•Create and manage database objects, such as tables, indexes, procedures, and

triggers.

•Migrate scripts in a production environment and modify stored procedures based on business requirements.

•Implement SQL Server security through user permissions and roles.

•Perform data migration between different versions.

•Create and schedule database maintenance tasks, backup jobs, and alerts.

•Optimize database performance by tuning indexes, using tools like Database Engine Tuning Advisor.

•Resolve database issues, such as space management, deadlocks, and blocking.

•Monitor and optimize database performance using native and third-party tools.

•Ensure timely completion of database refreshes to maintain reporting environment sync.

•Upgrade SQL Server versions and apply patches and service packs.

•Provide 24x7 on-call support on production databases.

•Utilize virtualization technologies like VMware and Hyper-V.

•Work with ticketing services like Service Now and Solution Center.

MS SQL DBA Bank of Texas –

Houston, TX May 2020 to June 2021

Responsibilities

•Install, upgrade, configure, and migrate Microsoft SQL Server in clustered and nanocluster production environments.

•Plan and implement high availability and disaster recovery solutions such as Replication, Log shipping, Always On, and Clustering.

•Perform performance tuning and optimization using SQL Profiler, Query Analyzer, and Database Engine Tuning Advisor.

•Monitor server performance using System Monitor and SQL Server Profiler.

•Evaluate execution plans, query plans, and transaction isolation levels.

•Create maintenance plans and jobs to improve performance.

•Support ETL processes and deploy SSIS projects.

•Work with Azure VM for migration and on-demand resources.

•Demonstrated expertise in utilizing SQL Server native tools and third-party applications, such as PowerShell, Red Gate, and SolarWinds, for monitoring, optimizing, maintaining, and troubleshooting database performance and SolarWinds.

•Utilize ticketing services like Service Now and Solution Center.

MS SQL DBA Direct Energy

Houston, TX February 2017 to April 2020

Responsibilities

•Migrate SQL Server 2005 databases to SQL Server 2014.

•Design and implement database objects like stored procedures, views, tables, and

constraints.

•Monitor server availability and optimize performance.

•Design and implement security policies for SQL Servers.

•Troubleshoot client connections and application issues.

•Perform daily tasks, backup and restore databases using SQL Server Management

Studio.

•Design and optimize database structures, stored procedures, and functions.

•Implement log shipping for database synchronization.

•Conduct daily, weekly, and monthly database maintenance tasks.

•Manage SQL Server security by creating roles and groups.

•Maintain data integrity and perform data migration.

•Troubleshoot and resolve database-related issues.

•Utilize SQL Server native tools and DMVs for performance analysis.

•Work with SQL Server 2012 Reporting Services.

•Collaborate with teams for new releases and implementation.

Education

Bachelor’s degree in science

Skills:

•Microsoft SQL Server 2019/2017/2016/2014/2012

•SQL

•Data Warehouse

•Disaster Recovery

•Server Management

•T-SQL

•SSIS

•SQL Server Reporting Services (SSRS)

•Database Security

•Data Modeling

•Query Optimization

•Performance Tuning

•Backup and Restore

•PowerShell

•Red Gate

•SolarWinds

•High Availability (Always-On, Clustering)

•Replication

•Log Shipping

•Azure (Virtual Machines, SQL Database)

Contact this candidate