Sql Server Ms

Location:

Posted:

August 12, 2024

Resume:

PROFESSIONALUALIFICATIONS

Competent, experienced, and highly dependable professional, proficient at producing and completing quality outputs, recognized for performing all duties and responsibilities in compliance with standard operating procedures. Known for demonstrating exceptional work ethic. Equipped with communication and interpersonal skills. Versatile and easily adapt to changing environments. 7+ years of database management experience that includes Database Administration, System Analysis and Design, Development & Support of MS SQL Server 2012, 2014, 2016,2017 and 2019 environments.

Experience in installation and configuration of MS SQL Server, applying service packs, hot fix and cumulative updates in Production and non-production environments.

Experience in performance tuning/analysis, troubleshooting and query optimization.

Experience in using dynamic management views (DMV) and dynamic management functions (DMF), TSQL scripts, Triggers, and Store Procedure for troubleshooting and performance tuning.

Security Management group and security management, creating Logins with appropriate roles, creating users and group, and granting privileges according to company policy.

Experience in coordinating and supporting server level hardware and software maintenance, windows patching and application migration/upgrade.

Monitoring error logs, database space allocations, transaction log space allocations for performance and documentation of errors and resolutions for future references.

Maintain Data Views for Reporting.

CORE TECHNOLOGIES:

Database:

SQL Server 2019/2017/2016/2014/2012

ETL Tools:

SQL SSIS/ DTS, Import/Export Wizard

Server Tools:

SSMS, SSCM, SSRS

Troubleshooting:

SQL server error log, Activity Monitor, Query Analyzer, Profiler, DTA

Operating Systems:

Windows Server 2012/2012(R2)/2016/2019

Third Party Tools:

Redgate SQL Backup, Data Compare, SQL compare, SQL Monitor

EDUCATIONAL BACKGROUND

B.Sc. in Health Care Administration Texas Southern University Houston, Texas

EXPERIENCE HIGHLIGHTS

DFW Airport Senior SQL Server DBA April 2023 - Present

Dallas, TX

Experience in Upgrading SQL Server (In place and Side by side Upgrade) based on application compatibility and fixing the orphan users.

Experience in implementing SQL Server security and Object permissions like creation of users, granting permissions, and assigning roles to users.

Experience implementing and troubleshooting High Availability of database servers using Replication, Log Shipping, Database Mirroring, failover clustering and Always ON AG.

Experience in Configuring and Scheduling SQL Server agent Jobs, Alerts, operators, Maintenance plans, Database Mail Configuration, facets, and Transparent Data Encryption.

Experience with Monitoring, Performance Tuning, and analyzing DB performance issues.

Strong experience in designing and implementing backup and disaster recovery strategies as per RPO and RTO values.

Experience in configuring and maintaining Full backup, Transactional log backup, Differential backup and creating the maintenance plans for index rebuild, index reorganize based on fragmentation.

Experience in identifying and troubleshooting database health, integrity checks and fixing them.

Experience in Microsoft Reporting Service (SSRS) with Report authoring, Report management, Report delivery and Report security.

Created jobs, alerts to run SSAS, SSRS packages periodically. Created the automated processes for the activities such as database backup processes and SSAS, SSRS Packages run sequentially using SQL Server Agent job.

Experience in Database refresh from prod to lower environments as per business requirements.

Managed and involved in SQL performance tuning, identifying locking, and blocking issues using Native and third-party tools to enhance and boost performance and SQL Dbs.

Worked with Performance Tuning/Query tuning, execution plans, trace flags and SQL Profiler

Installation of Service packs to all environments.

Used log shipping for synchronization of databases.

Experience on migration from on-premises database to Azure cloud.

Good knowledge and hands on experience on Azure cloud database and servers

TransCore LP SQL Server DBA December 2020 - March 2023

Houston, TX

Experience in installation and configuration of Microsoft SQL Server, applying service packs, hot fix and cumulative updates in development, QA and production environments.

Designs and implements secure, efficient, and accurate Databases.

Setup database using backup and restore, insert metadata, and configure setup compatibility with application functionality.

Created Linked Servers, Test Connectivity in a multi-server setting.

Managed users and groups (roles) from Active directory or SQL, provide appropriate server roles, map them to specific databases and grant specific privileges over selected database securable objects to ensure security and integrity.

Analyzed and deployed scripts and packages in prod/test environments from different developers based on CR/change request process.

Created Database Mail, configured Alerts and operators and tested schedule reports both from DB and Application.

Created and monitored database maintenance plans and schedule jobs using SQL Agent/Maintenance plan; Schedule database integrity check, reorganize/rebuild indexes, update statistics, backup/restore and cleanup job history.

Used SQL native and Redgate tools for performance monitoring /analysis and troubleshooting. Performance tuning by analyzing execution plans, creating, and maintaining indexes (rebuild/ reorganize), Statistics updates and other mechanisms that are application specific.

Added Server IP’s and other machines in DB, created endpoints and configured machines for overall functionality of the Application.

Configured replication in a parent child setup of DB, scheduled replication job to send transaction to back office.

Used native and third-party tools to diagnose server reliability and performance issues.

Monitored SQL Server Error Log, Windows Event Logs, Profiler, Query Execution Plan, Index Tuning Advisor, Database Tuning Advisor, System Monitor, troubleshooting issues.

Tested application functionality in different build and version requirements.

Compared Data and deployed using Redgate SQL Data Compare and Data Compare features.

CGX INC SQL Server DBA May 2017 – December 2020

Houston, TX

Installed and configured different MS SQL Server versions on standalone and clustered environments.

Experienced in migrating contents from lower versions to higher versions.

Experienced in applying periodic service packs and hot fixes (cumulative updates).

Auditing databases for user’s transaction, login and database action and fixing orphan users.

Involved in capacity planning and allocation of resources for the databases by assisting application teams in creating databases depending upon the criticality of the databases following current and best practices in accordance with SLA of the company.

Involved in database Consolidation project.

Responsible for creating and monitoring database maintenance plans and schedule jobs using SQL Agent/Maintenance plan; Schedule database integrity check, reorganize/rebuild indexes, update statistics, backup/restore and cleanup job history.

Experience in SQL native tools for performance monitoring /analysis and troubleshooting. Performance tuning by analyzing execution plans, creating, & maintaining indexes.

Analyzed Locks, Blocks, Dead Locks, Resource Utilization, handling Isolation Level and Concurrency issues.

Reviewed and optimized SQL queries, stored procedures, views, and triggers from other developers to achieve maximum efficiency and scalability. Provided consultation for development teams regarding performance review and the correct usage of database objects and list the most resource-intensive queries on the server and suggest ways to improve performance on each.

Supported implementation of AlwaysOn, Availability groups by creating availability databases using the high availability and DR strategies in clustered environment.

Experienced with configuring database high availability techniques like Replication, clustering as well as implementing disaster recovery techniques like database mirroring and log shipping.

Used free tools to diagnose server reliability and performance issues.

Experienced in implementing, configuring, and maintaining different types of Replication Models like Snapshot and Transactional.

Xerox Corporation SQL Server DBA April 2016 – April 2017

Houston, TX

Installed, Configured, and Managed SQL Server instances and databases in production, development, and test environment.

Applied periodic service packs and hot fixes (cumulative updates).

Experience in migrating contents from lower versions to higher versions.

Managed database security, creating logins, groups, users, and server level and database level roles following company policies and procedures.

Created Alerts and Notifications for system errors, insufficient resources, fatal database errors, hardware errors, security breach, etc.

Strong knowledge and working experience in Database Backup and Disaster Recovery. Experienced with Point-in-Time Recovery that meets company’s RTO and RPO. Plan backup strategies based on the recovery models, size of data and I\O activity.

Design, implement and manage database maintenance and disaster recovery plans including full/differential/transactional backups and recovery procedures.

Implemented pre/post strategies for upgrading and migration of user databases by scripting all SQL server replications, login/users, linked servers, scheduled job, database mail profiles and server level configurations.

Analyzed Locks, Blocks, Dead Locks, Resource Utilization, handling Isolation Level and Concurrency issues.

Managed efficient backup system to minimize backup/restore time by applying Database Backup Compression, enabling Instant File Initialization, and applying frequent full, differential and transaction log backups.

Configured Log Shipping as Standby database from Production database for Reporting purposes as well as installed, configured, and maintained database mirroring.

Contact this candidate