Betty Debas

Title/Role: MS-SQL DBA

Phone # 571-***-****

Email: adz5xu@r.postjobfree.com

PROFESSIONAL SUMMARY

I have 8+ years of experience in MS SQL Server Database Administration and Development working in complex enterprise domains including:

• Developing server architectures for High Availability (HA) and Disaster Recovery (DR).

• Installation, configuration, upgrade, patching, and management of SQL Server 2019, 2016, 2014, 2012, 2008/R2, hosted by Windows 2016, 2012/R2, 2008/R2 in physical and virtual environments.

• Installed and managed Azure SQL Databases, Azure SQL Managed Instances, and SQL Server on Azure Virtual Machines.

• Database administration in production, test, and development systems.

• Designing scalable enterprise level database architecture using agile methodologies.

• Configuration and management of HA/DR solutions such as AlwaysOn-AG, Failover Clustering, Database Mirroring, Log-Shipping, and Transactional Replication.

• Performance tuning and optimization using Perfmon, DMV/DMFs, SQL Server profiler trace, and database engine tuning advisor.

• Performance monitoring using native tools and third-party products like SQLdm and PRTG.

• Ensuring SQL Server Security by creating user logins, assigning roles and least-privilege permissions, certificate based security authentication, as well as strict monitoring of server and database level object changes through regular audits.

• Conducting annual security compliance using CIS security metrics for SQL Server. And, up-to- date knowledge of current cyber-security threats/challenges and best practices.

• Writing complex ad-hoc T-SQL, stored proc, views, triggers, functions, cursor, dynamic-SQL.

• Documentation of server and database level configuration settings as well as critical jobs.

• Development of database design and code review guidelines.

• Patching service packs and latest security updates.

• Configuring automated jobs and alerts using SQL Server Agent and DatabaseMail.

• Implementing Transparent Data Encryption, Column Level Encryption, and Always Encrypted.

• Running DBCC commands for database consistency checks.

• Implementing and documenting robust disaster recovery strategy.

• Developing, deploying and managing SSIS packages.

• Creating reports using Visual Studio and deploying it to SSRS.

• Installed and Configured SSRS, SSAS and SSIS application to specific guidelines.

• Designed and engineered SQL Server databases with other infrastructure technologies.

• Created ETL packages for moving data from and to various database systems and data formats including SQL Server, Flat Files, XML, and Excel files using SSIS.

• Provided a 24x7 dedicated support for users in Production, Development and Testing servers, and Responded on Tickets based on Requirements.

Professional Experience

SQL Database Administrator

U.S Bank Oct 2019 - Present

City Here, MN

• Installed and configured MS SQL Server 2019/2016/2014/2012/2008 on Window Clustered and Standalone Environment with the latest service pack.

• Configured Windows Server Failover Clustering (WSFC) and SQL Server Always On Availability Groups.

• Created and Monitored automated daily, weekly and monthly SQL Server agent jobs/Maintenance plans such as but not limited to Database Backups/Restore, Database Integrity Checks, Index Rebuild/Reorganize, Update Statistics, Job History and Maintenance Clean up Tasks and Update Statistics.

• Installed and Configured SQL Server High Availability including Clustering and AlwaysOn Availability Groups.

• Performed administrating, monitoring, and implementing performance on database systems as well as Database Performance Optimization, Developing/changing Database indexes, Redesigning database structure and reloading data into a database.

• Performed Database Migration from SQL Server 2014 to SQL Server 2016/2019 and to Azure Environment

• Created databases, tables and views, stored procedures, triggers and other necessary database objects

• Run DBCC commands to check the database consistency and shrink the databases.

• Monitored and modified performance using execution plans and index tuning.

• Resolve Locks Deadlock Isolation level and performance issues like CPO, IO and Memory.

• Configured Table Partitioning on huge tables containing millions of rows for better performance.

• Developed automated jobs using maintenance plan daily, weekly and monthly such as Database backup, Integrity checks,and index Rebuild,index Reorganized and Update statistics.

• Implemented security to restrict the access to users and to allow them to use only certain reports.

• Performed patching and applied cumulative updates on SQL Server 2019/2016/2014/2012.

• Performed disaster recovery, performance analysis, index maintenance, and monitoring of data.

• Installed, Configured, and deployed SSIS, SSRS, on windows and Linux Servers.

• Monitored, Troubleshoot and Resolved issues including but not limited to SQL Server performance, database integrity, blocking and deadlocking, connectivity, security and database activities of particular users by using Performance Monitor, Activity Monitors, Store Procedures, DBCC, and DMVs.

• Deployed periodic reports based on the analysis of the data using SQL Server Reporting Services.

• Supported data modeling activities by way of prototype database implementations.

• Created ETL packages for moving data from and to various database systems and data formats including SQL Server, Flat Files, XML, and Excel files using SQL Server Integration Services

(SSIS).

• Deployed SSIS packages in staging and production servers.

• Fine-tuned slow running queries using Execution Plan and Database engine tuning advisor.

• Provided 24X7 on rotation based call supports for all the environments. SQL Database Administrator

MetLife Dec 2018 – Sept 2019

New York

Responsibility:

• Installed and configured SQL Server 2017/2016/ 2014 /2012/2008R2 and applied patches and Service Packs.

• Involved in Planning, defining and designing data based on business requirements and provided documentation.

• Excellent experience in designing, maintaining & tuning various RDMS like T-SQL, MS access databases and strong knowledge of SDLC principles.

• Provided a 24/7 dedicated supports for development, testing and production MS SQL Servers.

• Highly proficient in the use of T-SQL for developing complex stored procedures, triggers, views tables, user defined functions, relational database models and data integrity, and SQL joins.

• Managed SQL server backup and recovery strategies

• Experience in table partitioning strategies and how to work with very large tables.

• Experienced in planning, implementing and administering High Availability and Disaster recovery solutions like Log shipping, Mirroring, Replication, Clustering and Always On Availability group.

• Managed SQL Server security including implementation of SQL logins, users, roles, and authentication modes.

• Streamlined Server/database level Security and utilized SQL Server auditing, policy -based management and transparent data encryption.

• Established remote MS SQL servers as Linked servers for fetching data.

• Performed SQL server upgrade/patching and performed migration from MS SQL Server 2005 - 2008R2 and /or 2005/2008R2 to MS SQL server 2012/2014.

• Developed and performed SQL server post installation maintenance plans: Database backups, Integrity checks, Update database statistics and Index maintenance using GUI and T-SQL.

• Set up and executed database maintenance plans, scheduled and automated SQL Server Jobs, configured database mail, created alerts, operators and notifications.

• Installed and Configured SSIS, SSRS and SSAS.

• Deployed generated reports of each quarter onto the report server to access it through browser.

• Performed rebuild and reorganize indexes on tables to reduce fragmentation and enhance SQL Server Performance.

• Monitored and Troubleshoot SQL server performance and database activities of particular users using SQL Profiler, Performance Monitor, Extended event, Trace flags, Activity monitors, Store procedures, DBCC, and DMV/Fs.

• Tuned slow running T-SQL queries using execution plan and database engine tuning advisor

• Evaluated CPU, Disk I/O and Memory related bottlenecks using Performance monitor and improved the SQL server performance.

• Evaluated concurrency issues in SQL server by using DMVs, Trace Flags, SQL alert, Store procedures, DBCC, and activity monitor; and resolved by adding Index, Tuning queries, Identifying missing index and using appropriate isolation level. SQL Database Administrator

Kellogg’s Sep 2015– Nov 2018

Michigan

• Installing and Configuring new SQL Server 2008,2012,2014 Database Server instances, and upgrading SQL Server 2008,

• Setting up and Monitored transactional replication, Database mirroring on Production, QA and Development servers.

• Providing 24x7 dedicated production support for SQL Server problem resolution and server outages.

• Responsible for large scale of database migration from SQL server 2005 to 2008r2, 2012, 2014 and to 2016.

• Responsible for creating stored procedures, tables, views, functions, triggers and indexes.

• Involved in database backups/restoration and planning backup strategies.

• Backing up master & system databases and restoring them when necessary.

• Rebuilding the Indexes at regular intervals for better performance.

• Verify backups and error logs on the servers and troubleshoot any failures or alert problems, and open trouble tickets if necessary to work with technicians from other departments.

• Responsible for Installing, configuring and maintaining SQL Failover clustering for two production environments.

• Responsible for configuring and maintaining Transactional, Snapshot and Merge replication in production environments.

• Involved in improving database performance using SQL Profiler, Trace Flags, Execution plan and Index Tuning Wizards.

• Responsible for securing SQL Server, user management, and taking care of permissions and roles.

• Working with SSIS package to import and export operations in and out of the SQL Servers.

EDUCATION

Bachelor’s Degree – Computer Science

CERTIFICATION DP-300: Administering Microsoft Azure SQL Solutions AZ-900: Microsoft Azure Fundamentals

AWS Solution Architect professional

Contact this candidate