Database Administrator Customer Support
Resume:
Adeshile Oluremi
adw5sq@r.postjobfree.com
PROFESSIONL SUMMARY
Seasoned Database Administrator with 7 years of experience, proficient in areas like database development, maintenance, security, and high availability solutions, with proficiency in T-SQL and PowerShell.
Migrated over 375 Databases from OnPrem to Azure.
Proven experience in setup and troubleshooting of database components including Always On, Clustering, Database Mirroring, and Log Shipping, and in implementing backup, recovery processes, and disaster recovery solutions.
Skilled in query optimization, SQL Server installation, configuration, and securing SQL Servers through techniques like transparent database encryption (TDE) and dynamic data masking.
Proficient in Migration/Upgrade operations, applying service packs, conducting database health checks, optimizing indices, updating statistics, and managing client/server connectivity and capacity planning.
Experienced in creating and supporting ETL processes, using SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), POWER BI, and Tableau.
Familiar with tools such as Query Store, Extended Events, Database Engine Tuning Advisor (DTA), SQL Profiler, ServiceNow, SolarWinds, SQL Sentry, Redgate, and IBM Tivoli Storage Manager (TSM) to manage and resolve issues.
Competent in working with Cloud (Azure) and managing Active Directory (AD) objects and user permissions.
WORK HISTORY
SQL SERVER SUPPORT ENGINEER 09/2021 to CURRENT
Microsoft Corporation, Irving, Texas.
Provide SQL Server database support to Microsoft Premier and professional customers on a wide range of issues across the product.
Specialize in SQL Server performance cases on both an individual query and instance level.
Participate in Microsoft SQL Server internal training sessions with product developers and engineers.
Assist other engineers with solving SQL Server-related technical issues.
Attend group Microsoft Teams meetings with customers for live troubleshooting sessions.
Responsible for providing technical customer support
Own, troubleshoot, and solve customer technical issues, using troubleshooting and diagnostic processes
Escalate issues requiring higher-level support
Track and document all requests and work-notes
Support initiatives to optimize and identify opportunities for automation and customer self-service
Maintained service-levels
Perform event and time-based scheduling of SSIS packages.
Perform Optimization and Technical Design and Documentation.
Debug and resolve technical issues.
Handle batch production job failures to meet the SLA on time.
SQL SERVER DATABASE ADMINISTRATOR 1/2018 to 09/2021
NEC America Corporation, Irving Texas.
Managed over 500 databases including VLDBs across multiple data centers and provided 24x7 DBA & Production support for over 180 SQL Server databases.
Participated in technical decisions, interacting with Business Analysts, Client team, and Development team, and conducting capacity planning and SQL Server upgrades.
Led migration of SQL Data from on-premises to Azure SQL Database and large-scale database migrations from SQL Server 2005 to SQL Server 2012R2 and 2014/2016.
Set up and maintained High Availability and Disaster Recovery Solutions, configured DR solutions with Transaction Replication from Distribution Server.
Employed SSIS to build high-performance data integration solutions, and involved in the creation, development, and deployment of SSIS packages and SSRS reports.
Performed Physical and Logical Data Modeling for various sized databases, including VLDBs, and carried out database refresh tasks from production to Development and Staging Servers.
Scheduled backups and restore operations with LiteSpeed 4.5, performed database consistency checks with DBCC, Defrag, and Index tuning, and monitored error logs.
Created Logins, Users, Groups, Roles, Jobs, Alerts, and Mail confirmations according to standards, and performed security tasks like granting, and Revoking permissions.
Provided On-Call support to Mission critical Environments with a focus on Disaster Recovery mechanisms and resolution of SQL Server problems per SLAs.
Involved in auditing and resolving database transaction issues with PerfMon, SQL Profiler, and NetMon, and maintained both a Read-only reporting database and Disaster recovery database.
SQL SERVER DATABASE ADMINISTRATOR 02/2016 to 11/2017
Globacom Nigeria Limited, Lagos Nigeria.
MS SQL Server design, Development, and administration using SQL Server 2005 – 2014 database environments.
Expert in MS SQL Server design, development, and administration across SQL Server 2005 – 2014 environments, encompassing user management, database maintenance, and server security.
Proficient in monitoring SQL health checks, identifying and fixing issues, improving query performance through SQL indexes, and utilizing optimization tools like SQL Profiler, Dynamic Management Views, and Windows Performance Monitor.
Experienced in automating administrative tasks such as job creation and scheduling, alert management using SQL Server Agent, and maintaining server security through an assignment of logins, roles, and permissions.
Skilled in implementing disaster prevention and recovery strategies, supporting High Availability features like Clustering, Always On, Log Shipping, Database Mirroring, Replication, and maintaining database response times in 24x7 production environments.
Responsible for planning and implementing database backup/restore and disaster recovery, maintaining SQL objects, using tools like SQL Profiler, Fog Light, Red Gate for monitoring, and installing and maintaining SSIS, SSRS, and Power BI.
MS JR. SQL SERVER DATABASE ADMINISTRATOR 09/2014 to 01/2016
Globacom Nigeria Limited, Lagos Nigeria.
Proactively monitor and address SQL server and database performance issues, and develop data models in conjunction with application development teams.
Offer solutions to database concerns such as capacity, redundancy, replication, and performance, and maintain disaster recovery methods like SQL server mirroring, log shipping, and clustering.
Provide comprehensive technical support for databases, including system management, backup/recovery, account management, and configuration management, while estimating effort for software development activities.
Work with application development staff to establish database architectures, coding standards, and quality assurance policies, and assist with Windows Server configuration and management related to MS SQL Server.
Collaborate with the development team to resolve bug fixes, assist in testing, and contribute to performance feedback for staff while staying current with software upgrades and patches.
EDUCATION
Bachelor of Science Business Administration 06/2014
Universite Polytechnique Internationale Du Benin(UPIB)
CERTIFICATION
Microsoft Certified: Azure Fundamentals
.
Contact this candidate