Sql Server Database Administrator

Titilayo Adejoke Adejumo

P: 508-***-**** E: *********@*****.***

Data Analysis Data Mining Data Warehousing Regression Analysis Data integration Data Mapping Business Analysis Business Processes Requirements Management Project Management Business Process Modeling

Database Administrator

Summary:

Highly analytical and results-driven IT professional with over 6 years of working experience in SQL Server Database Administration and Microsoft, Security Backup and Restore, Hyper-V, VM Ware, T-SQL, IaaS, SaaS

Proven success in deployment of effective IT roadmaps, processes & procedures including setting up high availability & disaster recovery solutions in SQL such as Always on Availability Groups, Log Shipping, Mirroring, Replication & Traditional Fail over Clustering.

Excel at production support of mission-critical databases on both On-Premises and remotely with the highest efficiency.

Significant expertise in SQL Server Patches, Upgrades, Database Migration, and new Instance Installation.

Managed SQL Server DB through multiple product lifecycle environments, from development to mission-critical production systems

Configure and maintain database servers and processes, including monitoring of system health and performance, to ensure high levels of performance, availability, and security also performed scheduled maintenance & support release deployment activities after hours.

Independently analyze, solve, and correct issues in real time, providing problem resolution end-to-end.

Automated regular process, track issues, document changes also assisted developers with complex query tuning & schema refinement.

Shared domain and technical expertise, providing technical mentorship and cross-training to other peers and team members.

Education:

Lagos State University, Nigeria: Bachelor of Arts in English Language. 2008

Technical Skills:

Abilities: SQL Automation, Database Security, Data Migration, SQL Server HA and DR, Active Directory, Backup & Restore, SQL & Windows Cluster Development, Complex Conflict Resolution, Cluster Analysis,T-SQL Writing Skill, Server Administration, SQL Installation, SQL Configuration, SSIS, SSRS, SSAS Packages, Performance Tuning, Basic in Microsoft Azure, Team Building & Leadership

Proficiencies: MS SQL Server 2000-2019, PowerShell, Share point, Security, Backup-Restore, Hyper-V, VM Ware, T-SQL, IaaS, SaaS, PaaS, Always on Availability Group, Data Anonymization, Replication, Log Shipping, Failover clustering, Azure SQL Databases, Azure SQL Manage Instances, SQL on Azure VMS, Azure Database Migration Service and Azure Devops, SQL Server management studio,

Technologies: Functional programming, Business Intelligence, NLP, Computer Vision, Deep Learning, Process Improvement

Interpersonal Skills: Strong Internet Research, Excellent Verbal, Written and Quantitative Skills, Time Management and Prioritization Abilities, Effective Presentation and Negotiation Skills.

Work Experience

SQL Server Database Administrator, Clz250 Consulting LLC, Katy, TX July 2019 - Present

Capacity planning for projects and also to maintain optimal performance.

Managed logins and users to ensure access is in compliance with the principle of least privilege.

Installed, configured, tested, and managed MS SQL Server, Monitored and maintained databases.

Proactive performance tuning to ensure optimal performance/operation, Managed backups and restores.

Worked with other team members and other departments in IT. Good communication and interpersonal skills.

Created Jobs for Index Stats, DBCC checks, cleanup tasks, etc., Attained to tickets in a timely manner.

Used Database masking and encryption to secure sensitive information also Conducted Database Refresh between environments.

Migrated databases to Azure SQL using Database Migration Service, Replication, backup and restore.

Developed & updated tables, stored procedures, views, indexes, and triggers in accordance with SQL Server Environments.

SQL Server Database Administrator, AAT Stitches, Nigeria Aug 2016 - May 2019

Prompted response to tickets, resolved user requests on priority.

SQL Server Profiler, Extended Events, Query Store and Database Engine Tuning Advisor.

SQL Server Performance Dashboard Reports for Monitoring and Disaster Recovery Strategy.

Ensured databases adhere to corporate standards and policies, including database auditing.

Troubleshoot issues; investigate, analyze, implement a solution, testing and documenting findings.

Implement data security by creating users and assigning permissions per principle of least privilege.

Query Store, Import/Export Wizard, SSMS, SQL Profiler, Extended Events and External Monitoring Tools, Solarwinds and Idera.

Production level support for onsite and offshore - On Call 24/7 environment and set up network protocols and network administration.

Created and monitored maintenance plans and agent jobs that take backups and defragment indexes for query performance.

Contact this candidate