| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateProfessional SummaryMore than 11 years of progressive work experience in database Administration and Development in all versions of MS SQL Server 2022/2019/2017/2016/2014/2012/2008R2/2008/2005 and editions including Standards, Developer, Express, and Enterprise on standalone and cluster servers.Experienced in Microsoft SQL Server installation, configuration, optimization, server builds, patches, service packs, purging, upgrade/Migrate, and troubleshooting of SQL Servers in Clustered and Non-Clustered environments.Database Maintenance and Optimization includes applying routine maintenance tasks Like index reorganization/rebuilds, update statistics, and database consistency checks.Monitor and manage database growth, file size, and space utilization table partitioning, consolidation, performance tuning, disaster recovery procedure, and maintenance.Having hands-on experience skill writing PowerShell scripts, T-SQL scripts, migrating scripts in a production environment, data warehouse configuration and experience in creating and modifying tables, views, trigger, indexes, stored procedures and functions, advanced queries, cursors, and functions to meet business requirements.Experienced in ensuring SQL Server security and object permission like maintaining the creation of users, configuring permissions database authentication modes, and assigning roles of users.Expertise in implementing diverse types of high availability (HA) and disaster recovery (DR) mechanisms like replication, log shipping, database mirroring, clustering, and Always-On High Availability solution on physical and virtual machines.Implement and maintain backup and recovery strategies to ensure data integrity and minimize downtime. Develop and execute disaster recovery plans and perform regular backups, including testing and verification of backups.Worked extensively on ETL process and SSIS package development, deployment, and scheduling using SQL Server Data Tool (SSDT) and Business Intelligence Development Studio (BIDs).Experienced in SQL Server Reporting Services installation, configuration, and maintenance using Visual Studio and Reporting Services.Expert in handling data quality issues and generating several types of reports like parameterized, drill, and interactive reports, and dashboards using SSRS on OLAP databases.Experienced in developing BI applications utilizing SQL server, BI stack, and Power BI.Used PowerShell for automation and task scheduler to automatically perform routine tasks.Solid hands-on experience in database patching, upgrades, and migration from SQL Server 2012/ 2008 to SQL Server 2014/2016.Having hands-on experience on Azure cloud services, Azure storage, Active Directory (AD), VM, Created Azure SQL database, Azure Synapse, Azure develops, performed monitoring and restoring of Azure SQL database, Performed migration of Microsoft SQL server to Azure SQL database.Experienced working on Agile Projects with Multiple Sprint cycles and Scrum meetings.Intensively worked on troubleshooting database-related issues including blocking, deadlock, connectivity problems performance degradation, and data corruption.Experienced in allocating system storage and planning future storage requirements for the database system.Monitoring and analyzing database performance using built-in tools (SQL Server Profiler, Extended Events, Database Engine Tuning Advisor) and third-party solutions (Redgate monitor, spotlight monitor, Uptime, SolarWinds), identifying, and resolving performance bottlenecks, optimizing queries, and suggesting improvements to enhance overall system performance.Create and maintain comprehensive documentation, including database schemas, configurations, backup and recovery procedures, and system changes. Generate reports on database performance, availability, and capacity.Data migration using SSMA from Oracle to SQL server.Worked on 24/7 production database on-call support.Performs duties in line with any existing and established Standard Operating Procedures (SOP)Collaborates with application developers and system administrators and provides support with database-related issues.Strong interpersonal & communication skills, Competitive analytical, logical, proactive, and critical thinking skills, Strong management, administrative and leadership skills to work in a team.Detail-oriented team player with strong organizational skills, willing to take on added responsibilities to meet team goals.TECHNICAL EXPERTISELanguages: Visual Basic, C, C++, T-SQL, PL/SQL, MySQL, Power shell.RDBMS: Microsoft SQL Server 2005/2008/2012/2014/2016/2017/2019/2022.SQL Server Tools: Management Studio, BIDS, Visual Studio, SQL Profiler, DTS/SSIS (ETL),Database Tuning Advisor (DTA), SQL* Plus, IDERA, Red Gate, spotlight, Uptime, SolarWinds, Remedy Force, Sales Force, Tenable One, Pager Duty, HPDM, Squirrel, DB Visualizer, DIAL (HP internal Tool), MS Azure.Case Tools: MS Office 2000/XP/2003/2007/2010/2011, Visio, MS Project, Pinnacle.BI and Modelling Tool: SSIS, SSRS, SSAS, Erwin, PDMPROFESSIONAL EXPERIENCETitle Sr. SQL DBA DeveloperClient Quick parts, Atlanta, GA Oct. 2023 PresentResponsibilitiesInstallation, upgrade, configuration, and migration of SQL Server in clustered and non-clustered UAT, production environments.Planning for backup and recovery of database information.Responsible for the performance and optimization of databases using tools like SQL Profiler, execution plan, Query Analyzer, and Database Engine Tuning Advisor.Worked on Integration Services for the purpose of transforming data from the cubes and storing it in the data in the SQL Server tables.Creating database Maintenance plans, jobs, and Optimization includes applying routine maintenance tasks like index reorganization/rebuilds, statistics updates, database refresh, and database consistency checks to achieve maximum performance.Ensuring SQL Server security and object permission like maintaining the creation of users, configuring permissions database authentication modes, and assigning roles of users.Involved in SQL Server Reporting Services (2017 and 2019 SSRS) Installation, configuration, and maintenance.Installed, configured, and maintain the SQL Server Reporting Services (2017 and 2019 SSRS).Create and schedule the SSRS reports to run on a required schedule in SQL Server Report server.Developed and created the new database objects including tables, views, trigger, indexes, stored procedures and functions, advanced queries, and updated statistics using Query Analyzer and Enterprise Manager on the existing servers.Worked with application developers to design databases and tables to support development activities and achieve optimal efficiency.Experience in support production, Data warehouse, Development, and QA Environment.Expertise in performance monitoring & tuning, query optimization, Client/Server connectivity, and Database Consistency Checks using DBCC utilities.Responsible for data migration from Excel, Flat file, Sybase, my SQL, DB2, and Oracle to Microsoft SQL Server by using BCP and DTS utilities as well as Extracting, Transforming, and Loading data using Microsoft SQL Server SSIS and DTS.Worked with Change Data Capture (CDC) feature in SQL server to capture all the changes during migration of data between databases.Perform restoration operations in high availability including Always on Availability Solutions.Set up database Replication models (Snapshot, Merge, Peer to Peer, and Transaction), Log Shipping, Clustering, and Mirroring on Physical and Virtual machines.Administrated and the new SQL Server 2016 and 2019 mechanisms like data compressions, and online indexing.Developed and documented backups, recovery strategies, and disaster recovery mechanisms and participated in disaster recovery drills for various environments.Proactively managed Microsoft SQL Server instances at the corporate office by developing Microsoft SQL scripts for the creation and upgrade of databases, maintenance plans, user logins, automation of network and server monitoring with exception reporting via Database Mail notifications, and a SQL Server failover system.Extensively 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.Having hands-on experience on Azure cloud services, Azure storage, Active Directory (AD), VM, Created Azure SQL database, Azure Synapse, Azure develops, performed monitoring and restoring of Azure SQL database, Performed migration of Microsoft SQL server to Azure SQL database.Involved in the development of databases including creating new databases, converting old databases to new databases, modification of existing databases, and creating reports to meet business needs.Worked on Git ticketing system.Worked on 24/7 production database on-call support.Hands-on experience in troubleshooting all database-related issues.Environment: SQL Server 2022, 2019, 2017, 2016,2014,2012, 2008, 2008R2, and 2005 Enterprise, SSRS, Windows Enterprise Server 2012/1008/2003, Microsoft Reporting Services. PL/SQL SQL Tuning Git High Availability (HA) Troubleshooting SQL Databases Database AdministrationExtract, Transform, Load (ETL) Data Warehousing
Title Sr. SQL Server DBAClient Gwinnett County, Lawrenceville, GA Apr. 2022 Sep. 2023ResponsibilitiesInstallation, upgrade, configuration, and migration of SQL Server in clustered and non-clustered UAT, production environments.Modifying the database structure, as necessary, from information given by application developers.Responsible for the performance and optimization of databases using tools like SQL Profiler, execution plan, Query Analyzer, and Database Engine Tuning Advisor.Worked on Integration Services.Creating database Maintenance plans, jobs, like index reorganization/rebuilds, statistics updates.Ensuring SQL Server security and creation of users and assigning roles of users.Involved in SQL Server Reporting Services (2016 and 2019 SSRS) Installation and maintenance.Experience in support production, Data warehouse, Development, and QA Environment.Experience for data migration from Excel, Flat file, Sybase, my SQL, DB2, and Oracle to Microsoft SQL Server by using BCP and DTS utilities as well as Extracting, Transforming, and Loading data using Microsoft SQL Server SSIS and DTS.Worked on SQL Server 2019 migration from SQL Server 2016.Worked with Change Data Capture (CDC) feature in SQL server to capture all the changes during migration of data between databases.Perform restoration operations in high availability including Always on Availability Solutions.Set up database Replication models (Snapshot, Merge, Peer to Peer, and Transaction), Log Shipping, Clustering, and Mirroring on Physical and Virtual machines.Administrated and implemented the new SQL Server 2016 and 2019 mechanisms like data compressions, and online indexing.Developed and documented backups, recovery strategies, and disaster recovery mechanisms and participated in disaster recovery drills for various environments.Extensively 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.Having hands-on experience on Azure cloud services, Azure storage, Active Directory (AD), VM, Created Azure SQL database, Azure Synapse, Azure develops, performed monitoring and restoring of Azure SQL database, Performed migration of Microsoft SQL server to Azure SQL database.Expertise in performance monitoring & tuning, query optimization, Client/Server connectivity, and Database Consistency Checks using DBCC utilities.Involved in the development of databases including creating new databases, converting old databases to new databases, modification of existing databases, and creating reports to meet business needs.Data migration using SSMA from Oracle to SQL server.Upgrading and monitoring the server using third-party tool Quest Spotlight, SolarWinds, and Uptime.Worked on Remedy Force and Jira ticketing system.Worked on 24/7 production database on-call support.Hands-on experience in troubleshooting all database-related issues.Environment: SQL Server 2022, 2019, 2017, 2016,2014,2012, 2008, 2008R2, and 2005 Enterprise, SSRS, Windows Enterprise Server 2012/1008/2003, Microsoft Reporting Services. PL/SQL SQL Tuning Quest Spotlight High Availability (HA) Troubleshooting SQL Databases Database Administration Extract, Transform, Load (ETL) Data Warehousing
Title Sr. SQL Server DBAClient Coca-Cola company, Atlanta, GA Mar. 2020 Mar. 2022ResponsibilitiesInstallation, upgrade, configuration, and migration of SQL Server in clustered and non-clustered UAT and production environments.Implement and maintain backup and recovery strategies to ensure data integrity and minimize downtime. Develop and execute disaster recovery plans and perform regular backups, including testing and verification of backups.Created reports in SQL server using SSRS as per the requirements provided by the Front-End users.Design report layouts, including tables, charts, graphs, and visualizations, to effectively present data. Develop reports using reporting tools such as Microsoft Power BIConfiguring and managing SQL Server maintenance plans jobs and alerts and ensuring the success of all scheduled jobs and maintenance plans to achieve maximum performance.Collaborate with cross-functional teams, including developers and system administrators.Troubleshoot database issues and provide timely resolution to minimize downtime.Implementation of Transparent Data Encryption (TDE)Worked on SQL Server 2016 migration from SQL Server 2012.Develop, implement, and monitor management information systems policies and control to support data accuracy, security, and legal and regulatory compliance.Strong DBA/Developer skills in Writing complex dynamic T-SQL scripts, stored procedures, views, triggers, functions, cursor, query.Extensively worked on Profiler, DMVs, DMFs, and DTA to tune the databases, servers, and query tuning.Used native tools like SQL Server Profiler, Extended Events, Database Engine Tuning Advisor as well as third-party tools like Redgate SQL Backup and Redgate SQL Monitor.Ensuring SQL Server security by creating user logins, assigning roles and least-privilege permissions, and certificate-based security authentication.Worked on installation, configuration, support, maintenance, and backup of SQL Server databases and IIS Web Server.Set up and manage and maintain data synchronization/replication between legacy and modernized environments.Involved in Day-to-day activities such as Agent Jobs, Backups and Recovery, Services, Index, Database growth, health and consistency check, Data maintenance (partitioning, archiving, and purging), issue problem maintenance, and management, Incident management, and Security maintenance.Environment: SQL Server 2019, 2017, 2016,2014,2012, 2008, 2008R2, and 2005 Enterprise, SSRS, Windows Enterprise Server 2012/1008/2003, Microsoft Reporting Services. Transact-SQL (T-SQL) Microsoft Azure Developer Studio Backup & Recovery SystemsTitle SQL DBA / BI DeveloperClient Targeted Technology Institute, Silver Spring, MD Apr. 2018 Feb. 2020ResponsibilitiesPerformed backup using backup compression and Data compression in MS SQL Server 2008R2 on a clustered environment.Involved in scheduling the reports to run on a daily and weekly basis in Report Manager.Maintaining referential integrity, domain integrity and column integrity by using the available options such as constraints.Administrated and managed the SQL Server in production and non-production servers.Experienced in creating SSIS packages using proper control and data flow elements.Export and import data from sources like flat files, and row files using DTS, SQL Server Integration Services.Installed and configured The SQL Server Reporting Services (SSRS) and maintenance of the Reporting Servers.Migrated SQL Server 2012 databases to SQL Server 2016 databases including DTS to SSIS packages.Implement high availability using Replication, Log-Shipping, and Mirroring.Apply and evaluated the point-in-time recovery of the production databases.Developed and created the new database objects including tables, views, indexes, stored procedures and functions, advanced queries, and updated statistics using Query Analyzer and Enterprise Manager on the existing servers.Optimized the performance of queries with modifications in T-SQL queries, removed unnecessary columns, eliminated redundant and inconsistent data, normalized tables, established joins, and created indexes whenever necessary.Loaded the data into other data sources like SQL Server using SSIS.Configured data partitioning and table partitioning on huge tables containing numerous numbers of rows for better performance.Scripting the Database Consistency Checks (DBCC), scheduling the scripts to run daily and weekly basis.Monitoring SQL Server logs to ensure that the backup operations, batch commands, and scripts have been completed successfully.Contacted various users in gathering the requirements and documented the necessary changes.Created necessary templates for various requirements gathering and documentation.Application support for front-end feeds and Resolved Application connectivity issues like connection timeouts, connection pooling issues, and memory leaks.Monitored Log shipping and Transactional Replication and troubleshooting of errors.Environment: Windows 2000/2003, SQL Server 2017, 2016,2014,2012, 2008, 2008R2 and 2005 DTS, Windows Enterprise Server 2012/1008/2003, SSRS Microsoft Reporting Services.Title - SQL DBAClient - T. Rowe Price - Baltimore, MD Feb. 2016 Mar. 2018ResponsibilitiesPrepared, maintained, and modified SQL server installation and configuration documents.Performed daily tasks including backup and restore by using SQL Server 2014 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.Created database maintenance plans for the performance of SQL Server which covers database integrity checks, updated database statistics, reorganizing, and rebuilding the indexes.Collaborated with different upstream teams for downloading ETL MART data.Worked on extracting data from multiple data sources such as Oracle, PeopleSoft, Siebel CRM, flat files, and loading into OLAP systems.Developed and optimized database structures, stored procedures, Dynamic Management Views, DDL triggers, and user-defined functions.Involved in troubleshooting and fine-tuning databases for their performance and concurrency.Converting DTS packages into SQL Server 2014 Integration Services.Migrating SQL Server 2008 databases into SQL Server 2014.Used SQL Profiler to capture the activities of the databases and used the trace file as a workload file to the Database Tuning Advisor for index recommendations.Installed SQL Server 2014 and created Development Database for testing, upgrades, and development.Recovering the databases from backup in disasters.Worked with application developers to design databases and tables to support development activities and achieve optimal efficiency.Handled numerous change management requests on production servers.Configured SQL Server settings using configuration manager.Worked on log shipping for synchronization of the database.Involved in creating functions to provide custom functionality as per the requirements.To analyze long-running slow queries and tune the same to optimize application and system performance.Environment: SQL Server 2016,2014,2012, 2008, 2008R2, and 2005, Windows 2012/2010/2008 Server, T-SQL, SQL Query Analyzer, SQL Profiler.Title Technical Database AdministratorClient SEBRENA Trucking Company LLC - Dallas, Texas Jul. 2012 Jan 2016ResponsibilitiesRelocation of databases from one server to another server using attach and detach databases.Involved in the upgradation of the touch works database.Touch works application was implemented in Active-Passive clustered environment.Installing SQL Server with minimum access privileges service account to improve security and to attain high ratings in SOC audits.Designed and created databases, tables, views, store procedures, and triggers.Involved in troubleshooting and fine-tuning databases for their performance and concurrency.Apply log shipping between two instances of servers using a database maintenance plan by creating a monitor server and a shared folder.Designed and implement the comprehensive backup plan and disaster recovery strategies implemented and scheduled the Replication process for updating our parallel servers.Monitored and modified performance using execution plans and Index tuning.Maintaining the database consistency with DBCC at regular intervals.Good experience in data modeling and metadata services.To Set up SQL Server configuration settings to resolve various resource allocation & memory issues for SQL Server databases and to set up ideal memory, min/max server options.Environment: SQL 2014,2012,008, 2008R2 and 2005, Windows 2008/2003 Server, Query Analyzer, SQL Profiler, Index Tuning Wizard, and Password Updater.EDUCATIONBachelors degree in computer science, Hilcoe School of Technology, Addis Ababa, Aug 2007.Advanced Diploma in Data Management, SQL Server Databases Administrator, November 2010.Advanced Diploma, Electrical Engineering Addis Ababa University, July 1991.CERTIFICATIONMicrosoft Certified Azure Data Fundamentals.Microsoft Certified Querying Data with Transact SQL. |
