Sql Server Database Administrator

PROFESSIONAL PROFILE

Accomplished, performance-driven, detail-oriented, and diligent Database

administrator with over 8 years of extensive experience in SQL Server Database development and administration. Specialized in SQL Server High Availability and Disaster Recovery solutions, Relational Database Management Systems (RDBMS), performance tuning, query optimization, T-SQL & PowerShell Scripting, and SQL Server Security. A proven track record of success in managing performance and diagnostic tests along with troubleshooting database issues, configuring devices, and planning with a strong sense of Database Administration. Proficient in prioritizing and completing projects and assigned tasks in accordance with budget and SLAs, yet flexible to multitask when necessary. Strong analytical, problem-solving, and organizational skills with the ability to face problems effectively under pressure. seeking a challenging role in a team-oriented and reputable organization to utilize my technical database and management skills for the growth of the organization as well as learn new and emerging technologies in database administration. A B U D U O N A I W U

• Proficient in managing thousands

of mission-critical SQL servers with

high availability using TSQL and

PowerShell scripting for

automation.

• Experience in Relational Database

Management Systems (RDBMS),

performance tuning, query

optimization, T-SQL & PowerShell

Scripting involving SQL Server

versions from 2008 to 2019 across

Test, Development, and Production

Server Environments.

• Extensive expertise configuration

and maintenance of SQL Server

High Availability and Disaster

Recovery solutions such as Backup

and Restores, Always-On High

Availability Group, Replication

Models (Snapshot/Transactional),

Log Shipping, and Mirroring.

• Proficient in SQL Server Security

including Server Roles, Logins, and

Permissions; Upgrades, Patches,

Migration of databases from 2012

to 2019 both on-prem and in the

cloud.

• Demonstrated skills in supporting

SQL Servers in the cloud - Azure

Virtual Machines, Azure SQL

Databases, SQL Managed

Instances, and AWS RDS and EC2

Instances.

• Proficient in using Microsoft Office

(Word, Excel, PowerPoint, Outlook,

Project, Publisher).

• Excellent analytical,

communication, detailed oriented

and interpersonal skills.

• Solid experience with ETL Tools

such as SSIS, Import/Export Wizard,

and Bulk Copy Program (BCP).

HIGHLIGHTS

PROFESSIONAL EXPERIENCE

DATABASE ADMINISTRATOR

Sr. SQL Server Database Administrator Feb 2021 – Present Tesla, Inc. Fremont, CA

• Establish and maintain regular backups and restores to and from disks, using high availability and disaster recovery solutions such as AlwaysOn, Database Mirroring, Log Shipping, and Replication.

• Implement security policies by setting up SQL Logins, Roles, and Authentication Modes for various categories of users.

• Set up Always-On Availability Group as the Highest form of Availability solution in SQL Server.

• Analyze performance issues using native tools such as SQL Profiler, Database Tuning Advisor, and performance monitor, while gathering information about the SQL server environment using Dynamic Management Views (DMV).

• Create and deploy database objects such as Tables, Indexes, Constraints, Views, Stored Procedures, Functions, and Triggers.

• Monitor server and database status including CPU, memory, I/O, space, and deadlock issues using SQL Server Utilities.

• Engage in and successfully implement capacity planning for different servers by setting up the SQL Server Configuration to resolve various resource allocation and memory issues for SQL Server databases and to set up ideal memory, and min/max server options.

• Manage and troubleshoot SQL Servers 2016, 2017, and 2019 on Dev/UAT/QA/Prod environments.

• Provide 24/7 Production Database On-Call Support. 510-***-****

***********@*****.***

Oakland, CA 94621

PROFESSIONAL EXPERIENCE

SQL Server Database Administrator Mar 2016 – Jan 2021 Uber Technologies Inc. San Francisco, CA

• Provisioned Databases and configured appropriate HA/DR strategy based on the RTO/RPO requirements.

• Installed stand-alone and clustered SQL Server 2008 and SQL Server 2012 on 64- bit systems with minimum access privileges service account to improve security.

• Successfully migrated and upgraded existing SQL Server from Legacy to 2014 and 2016 while ensuring optimal performance.

• Involved in Administering the servers by creating Users and assigning appropriate roles, and logins, monitoring the user accounts, creating groups, and granting privileges to users and groups using the principle of least privilege.

• Configured, maintained, and troubleshoot Log shipping, Mirroring, Always-On Availability Groups, replication SQL server Failover cluster on the same and multiple subnets.

• Used Import/Export Tool to Export and Import data from different sources like SQL Server Database, Flat file, CSV, Excel, and many other data sources supported by ODBC, OLE DB Data Sources.

• Performed Database Refresh tasks by taking backups from production servers and restoring them to lower environments (Development, Test, and QA servers).

• Supported SQL Server Reporting Services (SSRS), and SQL Server Integration Services (SSIS) services.

• Continuous process improvement

• Time management

• Strategic Planning & Implementation

• Technical Troubleshooting

• Analytical thinking

• Customer Service

• Problem-solving

• Attention to details

• Multiple Program Coordination

• Task Scheduling & Prioritization

• Cross-Functional Collaboration

• English (Oral and written)

SOFT SKILLS

• Proven track record in managing

large databases, backup/recovery,

and managing reports using SQL

Reporting Services (SSRS).

• Experience implementing

Transparent Data Encryption (TDE),

Always Encrypted, and Data

Masking for Database Security.

HIGHLIGHTS

EDUCATION

Bachelor of Science, Business Administration

University of Benin

CERTIFICATIONS

Microsoft Certified: Azure Data Fundamentals

Contact this candidate