Olu Borode
Dallas,TX
Summary
SQL Database administrator with over 9 years of progressive experience in database administration. High-performing professional with extensive experience managing large-scale, complex databases. Skilled in SQL and database management systems. Strong understanding of database design and data modeling with excellent troubleshooting skills. Smart and committed to staying up-to-date with new technologies and advancements.
Overview
8
8
years of professional experience
1
1
Certification
Work History
SQL Server Database Administrator
Brentwood Trade
03.2018 - Current
- Implemented SQL Logins, Roles, and Authentication Modes as part of Security Policies for various categories of users
- Provisioned Databases and configured appropriate HA/DR strategy based on RTO/RPO of Business Division
- Implemented Always-On Availability Group as High Availability solution on SQL Server 2016
- Created and deployed Tables, Indexes, Constraints, Views, Stored Procedures, Functions, and Triggers
- Monitored database status, including CPU, memory, I/O, space, and deadlock issues using SQL Server Utilities
- Created and supported ETL processes to SQL Server, Access to SQL Server, Excel to SQL Server
- Worked on setting up SQL Server Configuration to resolve resource allocation and memory issues for SQL
- Server databases and set up ideal memory and min/max server options
- Managed and troubleshoot SQL Server 2005, 2008, 2008 R2, 2012, 2014, 2016, 2017, 2019, Azure SQL, Azure
- Managed Instance, SQL VM Instances both on-premises and in cloud
- Migrated and Upgraded SQL server from Legacy to 2016, 2017, & 2019 and Azure
- Supported Reporting Servers (SSRS), Integration Services (SSIS), and Analysis Services (SSAS)
- Monitored regular backup and maintenance tasks for over 150 databases
- Migrated SSIS packages from SQL Server 2008 R2 to SSIS 2012
- Wrote complex T-SQL queries using stored procedures, functions, and views
- Supported PostgreSQL and Oracle environment (software installation, cluster initialization, database and objects creation, security, performance tuning operations)
- Worked with front-end developers to deploy reports
- Assisted in Multi-cloud migration, using AWS S3 bucket, Terraform, GCP Cloud SQL & Kubernetes, and Docker
- 24 X 7 Production Database On-Call Support.
- Implemented system enhancements to design and develop solutions to address problem reports.
- Followed standard practices for migrating changes to test and production environments.
- Utilized RDBMS tools and utilities to monitor, tune and optimize system performance.
- Followed standard practices for migrating changes to test and production environments
SQL Server Database Administrator
Clayjoy Technologies
01.2015 - 03.2018
- Defined database security and enabled data distribution to appropriate users
- Applied new patches and versions as required with minimal downtime
- Migrated data between database environments (development, test, production)
- Configured, Maintained, and troubleshoot Log shipping, Mirroring, AlwaysOn Availability Groups, replication SQL server
- Failover cluster on same and multiple subnets
- Installed and configured SQL Server 2008 and 2012 on Windows server 2008
- Monitored and reviewed database server error logs and space usage and addressed issues
- Exported and imported data from text files and Excel to SQL Server using Bulk Insert and BCP utility
- Worked with development team to optimize schema and performance
- Responsible for installing SQL Server and upgrading existing SQL Server and ensuring success of upgrade
- Provisioned Databases and configured appropriate HA/DR strategy based on RTO/RPO of Business
- Division
- Installed stand-alone and clustered SQL Server 2008R2 and SQL Server 2012 on 64-bit systems with minimum access privileges service account to improve security and attain high ratings in SOC audits
- Planned and executed disaster recovery (DR) exercises on the DR servers
- Managed multi-terabyte production of both STANDBY and CLUSTERED systems using ACTIVE-PASSIVE
- Clustering
- Configured Server-Level/User-Level Security Strategy, Authentication Modes, configured database Logins/Users
- Used Import/Export Tool to Export & Import data from different sources like SQL Server Database, Flat file, CSV,
- Excel, and many other data sources supports ODBC, OLE DB Data Sources
- Migrated and Upgraded SQL server from Legacy to 2014 & 2016
- Performed Database Refresh tasks from production to Development servers
- Supported Reporting Servers (SSRS), Integration Services (SSIS), and Analysis Services (SSAS)
- Maintained database response times in 24X7 production environment and proactively generated reports
- Bachelor of Science
- Implemented system enhancements to design and develop solutions to address problem reports.
Education
Bachelor of Science -
Ekiti State University
Overseas09.2009
Skills
- SQL Server 2019, 2016, 2014, 2012, 2008 R2
- SQL Server Migration
- SQL Server to Azure VM-MI
- PaaS
- Azure
- GCP
- SQL
- High Availability (HA)
- Transparent Database Encryption (TDE)
- Dynamic Data Masking
- SSIS
- SSRS
- Power BI
- Tableau
- SolarWinds
- Brent Ozar Toolkit
- AWS
- PostgreSQL
- SharePoint
- Project Management
- Microsoft Office
- Multitasking
- Time Management
- Communication Skill
- Learning & Development
- Critical Thinking
- Analytical Skills
- GitHub
- Microsoft PowerShell
- Backup and Restore of database
Certification
Microsoft Certified: Azure Administrator Associate Microsoft Certified: Azure Data Fundamentals
Microsoft Certified: Azure Database Administrator Associate
Timeline
SQL Server Database Administrator
Brentwood Trade
03.2018 - Current
SQL Server Database Administrator
Clayjoy Technologies
01.2015 - 03.2018
Bachelor of Science -
Ekiti State University
Similar Profiles
Trista Lewis-KnechtTrista Lewis-Knecht
Registrar/Administrative/Marketing & Webpage Design at Brentwood School District-Brentwood High SchoolRegistrar/Administrative/Marketing & Webpage Design at Brentwood School District-Brentwood High School
Abriana QuirozAbriana Quiroz
Receptionist at Brentwood Pet ResortReceptionist at Brentwood Pet Resort
Annette TitchenellAnnette Titchenell
State Tested Nursing Assistant at Brentwood HealthcareState Tested Nursing Assistant at Brentwood Healthcare