Sql Server Database Administrator

AKUETE “A.K.” KPODAR

Email: ************@*****.*********:******@*****.***

Mobile: 213-***-****

Professional Summary:

* + years of IT experience in Microsoft SQL Server database administration, managing Azure (IAAS & PAAS) databases. Proficient in supporting Sybase and SQL databases. Well-versed in scripting languages including T-SQL and PowerShell for automation.

Experience in Installation, Configuration, Maintenance and Administration of SQL Server 2019,2017, 2016, 2014, 2012, 2008R2,2008, 2005 and 2000.

Good experience in implementing High Availability & Disaster Recovery solutions using Always ON, Clustering, Replication, Mirroring and Log Shipping.

Good Experience in Backup & Recovery scenarios and worked on Azure backups.

Implementation of SQL Logins, Roles, and Authentication Modes as a part of Security Policies and implementation of Kerberos authentication on multiple SQL servers

Worked with SQL server upgrades and SQL databases migration from on-prem to Azure.

Performed upgrades of multiple servers from SQL server 2016 to 2022 and very good experience in doing rolling upgrades.

Configured Geo-replication in Azure SQL databases and failovers groups on Azure VM’s.

Expertise in Index tuning, Rebuild and Reorganizing according to Index fragmentation and troubleshooting maintenance job failures.

Well experienced in analyzing Performance and Query tuning. Identifying the I/O, memory bottle necks and handling blocking and deadlocks scenarios.

Maintaining the Database consistency using DBCC commands at regular intervals.

Experience in creating Tables, Views, Stored Procedures, User Defined Functions, and good knowledge on other T- SQL statements.

Designed and implemented Change Data Capture (CDC) to track and audit data changes in critical OLTP databases, ensuring compliance with business requirements.

Automated daily backup reports and database health checks using PowerShell scripts.

Good experience in daily administrative tasks like Space issues, transaction log file size growth, connectivity issues and regular monitoring of SQL Server error logs and Windows event viewer.

Experience in extracting and transforming information using DTS Import/Export wizard, BCP (Bulk Copy Program) DTS (Data Transformation Services) and SSIS Packages from SQL Server.

Experience in SSRS to manage reports, Creating and troubleshooting SSIS Packages.

ETL Development

Worked on Point in time restores in Azure and Configured Long Term Retention (LTR) backups for Mission critical databases.

Provisioning and configuring Azure VM’s, Azure SQL databases and Managed instances.

Monitoring the alerts using the Operations Management Suite (OMS) in Azure portal.

Implemented Always-ON on Azure VM’s by setting load balancer, health probe etc.

Experience working with Performance Metrics and Plan Management in SQL Azure.

Experience in installation, migration, monitoring and troubleshooting of SQL databases, applying service packs and hot fixes as per the requirement.

Good knowledge on Database design & architecture, Networking concepts and Protocols.

Good experience with Agile and Scrum methodologies, leveraging JIRA for project tracking, sprint planning, and database development collaboration.

Known for SLA based deliverables. Excellent communication and interpersonal skills, self-motivated, quick learner, and determination to learn new technologies.

Technical Skills :

Databases

SQL Server 2005, 2008 & 2008 R2, 2012, 2014, 2016,2017,2019 and 2022

SQL DBA

users, roles, privileges, schema and objects management, data loading, export/import, backup/restore, Migration activities, Disaster recovery, High availability, Database Performance management and query tuning

Cloud/Azure

PaaS, IaaS, Deployments, Maintenance of Microsoft Azure cloud, High Availability, TDE, DDM, Azure Data Studio, performance tuning, security management, Migrated on premises databases and Legacy products on Azure, deployed products on Azure, Azure Storage Explorer, Setup development and test environment on Azure

Database Tools

SQL Server Management Studio, SQL Server Business Intelligence Development Studio (BIDS), Database Engine Tuning Advisor, Visual Studio Enterprise Manager, Query Analyzer, SQL Profiler, Data Transformation Services, Upgrade Wizard, Replication, SSIS and SSRS

Third Party Tools

SCOM, RedGate, Service Now, Solarwinds SQL Sentry

Operating systems

Windows 2000/2003/2008/2012/2016/2019 servers

Programming

SQL, TSQL, Windows PowerShell

Education :

Master of Science in Data Science August 2026

Utica College, Utica, NY

Relevant coursework: Machine learning, Multivariate Statistical Analysis, Experimental Design, Linear and Non-linear regression modeling, Statistical Inference, Time Series Methods, Data Mining

SMU Data Science bootcamp February 2020

Southern Methodist University, Dallas, TX

Relevant coursework: Advanced Excel, Databases, Front End Web Visualization,Data Mining, Machine Learning and Data Visualization,Implementing a Data Warehouse SQL Server 2019,SQL Server 2016: Administer a database Infrastructure,Advanced SQL for Query Tuning and Performance Optimization,SSIS, SSAS, SSRS

Bachelor of Science in Mathematics December 2016

California State University, Dominguez Hills, Carson, CA

Relevant coursework: Math Club,International Association of Black Actuaries,Linear Regression, Complex Analysis,Statistical Analysis using R, Python, Power BI, Tableau

Associate of Arts in Liberal Arts June 2015

West LA College, Culver City, CA

Relevant coursework: Emphasis in Mathematics, Lead UMOJA, Teacher’s Assistant, Mathematics

Certifications:

•Microsoft Certified: Azure Database Administrator Associate (DP-300) In progress

•Microsoft Certified: Azure Data Fundamentals (DP-900)

•Microsoft Certified: Azure Fundamentals (AZ-900)

Professional Experience:

Title: Senior Database Administrator/Developer

Client: Department of Homeland Security (DHS)

Employer: EY Dignari

Duration: November 2023 to Present

Responsibilities:

Managing SQL Server software installations and version upgrades, ensuring seamless transitions and compatibility across different SQL Server versions.

performing database server backups, developing effective backup strategies and schedules, and utilizing third party tools such as Cohesity for reliable data protection.

Migration of SQL Databases from On-promise to Azure Cloud.

Managing IaaS and PaaS SQL Servers end-to-end, providing comprehensive support and maintenance for seamless operations.

performance tuning by reviewing monitoring tools and query execution plans to optimize query efficiency. Conducting root cause analysis to address and resolve query performance issues.

Designing, managing, and troubleshooting high availability solutions, including Always on Availability Groups, replication, and log shipping.

Managing user security, capacity planning, and SQL patching, while ensuring robust Azure database security using Azure Role-Based Access Control (RBAC).

Automating routine administrative tasks using PowerShell, Azure CLI, and Azure Automation.

Performing regular health checks, database maintenance, and proactive monitoring using tools like Microsoft Profiler, Extended Events, and third-party monitoring systems.

Handling the Mission Critical databases and resolving all the database issues reported by application team.

Configured and optimized SAN storage for SQL Server, ensuring high availability, low latency, and performance per Microsoft best practices

Collaborating with developers and production teams across departments to identify business requirements and evaluate strategic solution options.

Proficient in T-SQL development with hands-on experience in creating and managing SSIS packages and designing reports using SSRS.

Index Maintenance, Rebuild and Reorganizing according to Index fragmentation, running DBCC checks

and Update Statistics.

Proficient in utilizing RedGate SQL tools to optimize database deployments, enhance performance monitoring, ensure compliance, streamline test data generation, and automate various database management tasks.

Worked on fragmentation issues, monitoring and troubleshooting maintenance job failures.

Monitor Server Activity, Error Log, space usage, and solving problem as needed.

Taking care of database maintenance issues.

Participating in weekly CAB meetings and managing scheduled changes. Proficient in using ticketing systems such as ServiceNow (SNOW) and JIRA for tracking and resolving issues.

Title: DBA/ETL Developer

Employer: TEKSystems/Grange Insurance

Duration: August 2021 to November 2023

Responsibilities:

Managing all the On-prem SQL servers in the environment, IAAS and PAAS servers.

performing SQL server installations, upgrades, and installing patches.

Performing database server backups, planning backup strategy and schedule.

Designing and building MS SQL databases within Azure.

Performance monitoring, troubleshooting, and identifying the cause of performance degradation.

Setup and manage Always-on, troubleshooting Always-on issues.

Migrated SQL databases from on-prem to Azure IAAS and managed instances.

Configuring the monitoring of SQL Server databases utilizing Spotlight, Foglight and SQL sentry.

Configured on-premises SQL DB backups using third party tools like Commvault, TDPSQL and SPP.

Performed Query Optimization to improve the performance and SQL query tuning.

Configured CDC for a high-volume transaction system to capture changes for real-time synchronization.

Automated the retention policies for CDC data to prevent system overload and ensure optimal storage utilization.

Managing clustering and replication and troubleshooting in case of any issues.

Good knowledge on storage accounts and storage replications in Azure.

Configured Long Term Retention (LTR) backups for Mission critical databases.

Managing SQL logins, roles as per the security policy.

Solving Disk space, Log files full and database file full-related issues on SQL servers.

Consistently monitor all parameters on SQL servers via Spotlight (Sessions, processes, evaluating blockings), memory, and storage.

Worked with HA techniques like Log Shipping, Mirroring, Replication and Clustering.

Designed and implemented PRO/2 replication for a high-availability system, ensuring near real-time Performed Query Optimization to increase the performance by tuning SQL queries using Profiler and Execution Plans.

Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.

Performance monitoring, troubleshooting and identifying the cause of the performance degradation.

Performing administrative tasks like Space issues, transaction log file size growth, connectivity issues and regular monitoring of SQL Server error logs and Windows event viewer.

Experience implementing TDE (Transparent Data Encryption) and DDM (Dynamic Data Masking) features on Azure SQL databases.

Configuration of Always-ON on Azure VM’s by setting load balancer, health probe etc.

Adhered to Change Control Procedures and developed & executed scripted changes requests in accordance with change control procedures.

Setup Azure Machines to meet security requirements such as Firewall, intrusion detections, etc.

Automated DBA tasks using stored procedures, PowerShell scripts and T-SQL which helped to reduce the workflow.

Working with developers and end users in leveraging data systems to solve business problems.

Provide support for database standardization programs to improve the system performance and stability.

Experience in installation, migration, monitoring and troubleshooting of SQL databases, applying service packs and hot fixes as per the requirement.

Performed SQL Replication setup and manage SQL replication, lag monitoring, failover, slave promotion, backup, and recovery.

Title: Sr. Data Operation Analyst/ SQL Database administrator

Employer: Quest Analytics

Duration: February 2019 to August 2021

Responsibilities:

Performed upgrades from lower versions of SQL server 2005, 2008 and 2008R2 to the higher

versions 2012, 2016 and 2019 depending on application compatibility.

Performed standard database maintenance activities such as backup/restore, re-indexing, log file management, security patching, etc.

Responsible for maintenance of all the SQL Servers, SQL Azure Pass servers and managed instances in the Environment.

Automated the database backup daily reporting across all the SQL servers using PowerShell

Migrated databases from On-premises to Azure using bacpac files, DMA, lift and shift methods.

Applying Patches and Hot fixes.

Implemented Always-ON (AAG) on SQL Server 2012,2016 and 2019 servers and configuration of Always-ON on Azure VM’s by setting load balancer, health probe etc.

monitoring the database consistency at regular intervals.

Enforce Database Security by Managing user privileges and efficient resource management by assigning profiles to users.

Analyzing I/O, CPU, memory issues and providing required fixes.

Utilized query optimization techniques for efficient data processing in HDFS and developed PySpark scripts to automatically send daily Microsoft SSRS reports on performance to respective managers

Experience working with Performance Metrics and Plan Management in SQL Azure.

Setup Azure Virtual Appliances (VMs) to meet security requirements.

Handled multiple SQL Instances on Cluster environment.

Implemented and maintained Database mirroring and Log shipping.

Conduct root-cause analysis of defects, identify key and recurring problems, and provide solutions to prevent a recurrence.

Query store feature for monitoring performance of database systems.

Perform Administrative tasks in SQL Server using PowerShell script, including installation of SQL.

Good knowledge on Networking concepts and Protocols.

Experience in Change Management and Problem Management which ensures/tracks code changes.

Worked on Server cleanup activity at Enterprise level using PowerShell scripts to have clean and efficient database Inventory which helped to generate various reports.

SQL tuning and optimizations.

Table partitioning and other PostgreSQL advanced features.

Maintain and develop complex programming/scripts. Fix and report bugs on PostgreSQL.

Title: Database Administration Specialist (Azure SQL) and Developer

Client: American Airlines/ Envoy Air

Employer: American Airlines/ Envoy Air

Duration: March 2014 to January 2019

Responsibilities:

•Serving as the technical expert in SQL Server and Azure technologies

•Participating in Azure and SQL Server database systems design and operations using Normalization Forms, Entity Relationship design model and application-oriented design

•Experience in using monitoring tools like Quest Spotlight and Foglight, fetching data from the tools and troubleshooting performance related issues and user raised concerns.

•Troubleshooting always on issues, performing failovers whenever required.

•Performing Enterprise-wide Database Upgrade and Migrations projects, Migration of SQL server databases to Microsoft Azure hosted DB's and Managed Instances.

•Manage back-up and recovery plans and procedures, taking care of daily backup report across the production and test environments.

•Handling backup and restore of Azure SQL databases using portal and PowerShell commands.

•Worked on database mirroring, log shipping, replication.

•Proactively monitor the production database(s) and optimize stored procedures for better performance and resolve deadlock, block, and locking conflicts and resource utilization

•Expertise in Database Maintenance Plan Wizard, creating, scheduling Maintenance Jobs.

•Involved in capacity planning, sizing and database growth projections.

•Performed SQL Replication setup and manage SQL replication, lag monitoring, failover, slave promotion, backup, and recovery.

•Performance Tuning daily for preventing issues and providing capacity planning using SQL Enterprise Monitor.

•Implementing SQL Server security in Object permissions like maintaining Database authentication modes, creation of users, configuring permissions and assigning privileges to users.

Contact this candidate