ADEWOLE MAJARO

903-***-**** LinkedIn ad27me@r.postjobfree.com Princeton, Texas

PROFESSIONAL SUMMARY

Experienced SQL Server Database Administrator with 10+ years of experience in RDBMS design, performance tuning, and system administration. Proficient in SQL Logins, complex T-SQL development, and skilled in high availability solutions, query optimization, and data security, including Transparent Database Encryption (TDE) and dynamic data masking. Seeking to contribute these skills to challenging projects and enhance database excellence. CORE COMPETENCIES

Technical Skills: Diagnosis and troubleshooting database errors Data Modeling and Analysis Database security, Backup, and Recovery RDBMS Database Design Client Documentation Scripting Tools & Platforms: Automating Processes using PowerShell ETL & Cloud Infrastructure: SSIS Azure Data Factory Azure VMs Azure SQL Database

Microsoft Visual Studio Azure Data Studio Blob Storage Technology Tools & Platforms: HADR Solutions (High Availability and Disaster Recovery) Database Security Optimization Database Access Management Implementation of Emerging Database Technologies On-call support Performance Monitoring Upgrade/Migration of MS SQL Server, PowerBI, AWS, Oracle

PROFESSIONAL EXPERIENCE

SQL Server Database Administrator January 2018 – Present C.H. Robinson Worldwide Eden Prairie, MN

● Installed and configured SQL Server AlwaysOn Availability Groups and Windows Clustering for production servers, enhancing system reliability.

● Actively participated in change management processes, deploying database changes across environments and adhering to client standards.

● Reviewed and optimized database schema, indexes, and queries, improving system performance and addressing security vulnerabilities.

● Maintained a 99% success rate in meeting SLAs for troubleshooting complex database issues, ensuring seamless operations and data integrity.

● Maintained server security through login and permission assignments, ensuring data integrity.

● Led SQL Server upgrade projects with minimal downtime and effectively addressed compatibility issues and application-related challenges.

● Monitored SQL health checks, implemented SQL Indexes for enhanced query performance and cost savings, and consistently met SLAs for troubleshooting complex database issues.

● Achieved a remarkable 98% success rate in SQL Server upgrade projects, ensuring minimal downtime and mitigating potential business disruptions. SQL Server Database Administrator July 2012 – December 2017 Treasure Compass LTD Lagos, Nigeria

● Proficiently performed performance tuning tasks, addressing issues from query optimization to index enhancements, ensuring optimal database performance.

● Collaborated with customers on application rollouts and server migrations, showcasing expertise in seamless system transitions.

● Conducted both Physical and Logical Data Modeling for databases, including Very Large Databases (VLDBs), highlighting strong data modeling skills.

● Maintained databases across diverse environments, facilitating efficient development across the SDLC.

● Expertly created and managed ETL processes, seamlessly transferring data between various platforms, showcasing data integration proficiency.

● Successfully managed a challenging mission-critical system recovery, ensuring uninterrupted operations.

● Stabilized a volatile SharePoint application database server with multiple issues, implementing high availability through database mirroring and disaster recovery planning.

● Built clusters, including 2-node and 3-node configurations with Active-Active and Active- Passive setups, demonstrating cluster administration skills.

● Administered and provided comprehensive support for MS SQL environments, including clustered instances in both virtual and physical settings, ensuring robust database management.

● Vigilantly investigated and responded to incidents and events, performed system checks, monitored performance metrics, managed disk space, sizing, and limits for MS SQL engines, and diligently applied security patches to maintain system integrity.

● Proficiently utilized optimization tools such as SQL Profiler, Dynamic Management Views

(DMVs), and Windows Performance Monitor to continuously monitor and fine-tune SQL Server performance, ensuring efficient database operation.

● Collaborated effectively with cross-functional teams of application analysts and server engineers to design, test, and implement a robust disaster recovery plan for a mission-critical system, enhancing system resilience and reliability.

EDUCATION

Bachelor’s Degree of Science, Liberty University

Associate degree, University of Ilorin, Nigeria

Contact this candidate