Olusegun Yagba
Atlanta,GA
Summary
With over (7) years as a SQL Server Database Administrator, I have administered and provisioned SQL server 2008, 2012, 2014, 2016, 2017 and 2019 in Production, Test, Development and Clustered Environments. I'm a highly motivated self-starter with strong interpersonal and persuasive communication, outstanding problem solving and active listening skills. Having worked in several agile environments as the only DBA and with teams. My experience spans: Installation and Configuration of SQL Server, Performance Tuning, High Availability and Disaster Recovery/Disaster prevention, Database Refresh, SQL Server Upgrades and Patches.
Overview
9
9
years of professional experience
1
1
Certification
Work History
SQL Server Database Administrator
Prometheus Group LLC
01.2023 - Current
- Responsibilities: Planning and Installation of Microsoft SQL Server , 2008R2, 2012, 2014, 2016, 2017, 2019
- Planning the Installation, configuration and maintenance of MSSQL on EC2, RDS
- Configuring MS SQL Server Option group called 'Native-backup-restore' to backup MS SQL databases running on AWS RDS
- And store in S3 bucket, Parameter group etc
- Frequent collaboration with the SRE Team for efficient database management
- Efficient Monitoring of RDS and EC2 databases using Dynatrace, Performance Insights, Enhanced monitoring and Cloud Wacht on the AWS platform for efficient performance actualization
- Troubleshooting and resolving database integrity issues, performance issues, Temp files, deadlocks, locks, Missing indexing & Database corruption, Slow running queries, CPU spike, Index fragmentation statistics update, etc
- Upgrade and maintenance of Azure Sql managed instances and databases
- Performance Monitoring of Databases both on-premises and in cloud
- Reviewing scripts submitted by the development team for deployment
- Collaborate with others teams like Data analysts, developers, business analysts, and project managers to perform the capacity planning required to create and maintain the databases
- Managing and providing end-to-end support for SQL server databases through multiple lifecycle environments such as development, testing, staging to mission-critical production systems
- Instance Class Upgrade ON AWS, both EC2 and RDS Instance as required
- Document resolved issues and update confluence for future quick issue resolution
- Recommend and implement data security by creating users and assigning permissions based on the principle of least privileges
- Securing databases with technologies such as always encrypted, Transparent data encryption (TDE) and Dynamic data masking (DDM)
- Working with deployment teams in task actualization for organization success
- Assisting deployment team with issues related to Native backup and restore, snapshots
- Configuration of MS-SQL SERVER Parameter group to address specifics database problem based on the result of investigations
- Proposing to the Management team a database maintenance plan strategy to resolve database issues on some critical production databases
- Scheduled and Automate SQL agents Job to resolve various maintenance issues e.g
- From Index Optimize, Backups, Cleanup Job as required in the enviroment
- Providing response for all system / database issues on 24 x 7 schedule responding to critical events and situations outside normal work hours.
SQL Server Database Administrator
England Logistics LLC
06.2019 - 12.2022
- Responsibilities: Planning the Installation of Microsoft SQL Server , 2008R2, 2012, 2014, 2016, 2017, 2019
- Implement and define a vigorous Backup and Recovery strategy and Capacity planning following the company's SLA (RPO &RTO)
- Recommend and implement data security by creating users and assigning permissions based on the principle of least privileges and with technologies such as Always Encrypted, Transparent Data Encryption (TDE) and Dynamic Data Masking (DDM) to secure client's and Customers sensitive data
- Using SQL server in-built tools such as SQL Server profiler, Extended Events, activity monitor to monitor performance and system health
- Configured High Availability (HA) and Disaster Recovery (DR) Solutions on production in standalone and Clustered environments making sure databases are always available 24/7
- Troubleshooting and resolving database integrity issues, performance issues, blocking and deadlock issues
- Updating statistics for query optimization using performance and activity monitor, event viewers, extended events
- Create and update database documentation about company standard procedures, technology features and production issue troubleshooting
- Creating and monitoring maintenance plans and agent jobs that automates backups and reorganize/rebuild indexes for database performance
- Hands-on database tuning and troubleshooting of SQL Server service outages as they occur, including providing on call support during after-hours and weekends
- Providing scheduled maintenance
- Review scripts submitted by the development team and working with other teams like systems analysts, developers, business analysts, and project teams to perform the capacity planning required to create and maintain the Databases
- Migrate SQL server databases from on premises to AZURE using Data Migration Assistant
- Experience with AWS technologies and Migration from On-prem to AWS cloud service, knowledge & implementation
- AWS security services and focus on IAM policy and IAM permission with least privilege
- Configuration of MS-SQL SERVER Parameter group to address specifics database problem based on the result of investigations
- Maintain and Monitore Azure managed SQL instances and databases.
SQL Server Database Administrator
Merakey Innovative Care & Education Solutions
01.2018 - 05.2019
- Responsibilities: Regular monitoring of servers, which includes backup jobs monitoring, Disk space monitoring, Services monitoring, and blocking monitoring and troubleshooting using SSMS
- Responsibilities: Installation, Upgrades, Patching and Configuration of MS SQL Server 2012,2014,2016, 2017 and 2019 in different 32/64-bit production, test, and development environments
- Responsibilities include performance monitoring, security, backups, patches, troubleshooting, refresh, and data recovery
- Additional responsibilities to define users, minimize downtime, maintain various environments, perform testing and documentation of processes
- Proven working experience as a Database administrator
- Creation and maintenance of Databases, creating Roles and managing user permissions
- Automate maintenance plan jobs in SQL Server agent and task scheduler: such as backup database, index rebuilding, index reorganizing, cleaning up, and updating statistics
- Supports day to day operational duties for the database team
- Attending to tickets, and other tasks as assigned or expected from my Manager
- Provide required securities for Databases as required to keep data safe
- Perform database deployments (After work hours) and provide support for application releases
- Support all areas of the enterprise, ensuring all databases run at optimal performance
- Administer and monitor 24/7 applications and systems, developing automated alerts to warn of failure
- Provide DBA support and technical expertise for multiple applications in development, test, QA and production - SQL Server, 2012, - 2019 environments
- Experience in implementing high availability with Always on Availability and Failover Clustering with Disaster Recovering
- Perform database performance analysis and optimization, define bottlenecks, and manage testing and production implementation
- Prepare reports on administration best practices, new technologies, etc
- Work with project teams as required to design technical solutions to address project requirements.
Junior SQL Server Database Administrator
GZ Industries LTD
02.2015 - 08.2016
- Responsibilities: Running SQL Server profiler to troubleshoot the data issues reported by users
- Monitoring issues related to database locks/blockings/deadlocks
- Configuring , Database Mails to send notification and alerts for scheduled Maintenance jobs
- Involved in capacity Planning and management of Database activities
- Applying SQL Standards on all SQL servers according to the prescribed standards
- Able to perform the Failover and Failback activities in Cluster environment
- Configured Mirroring, Log-shipping and Clustering setup between database servers/instances
- Monitoring the Database Storage, allocating the required storage size to databases and suitably managing database growth
- Controlling and monitoring User Access
- Setup and Automate maintenance plan jobs in SQL Server agent and Automate jobs via task scheduler
- Work with leadership to research, define, interpret, and analyze complex, unstructured technical database problems and recommend solutions, and implement them.
Education
MS-SQL Server Database Administration - 300 Hours Comprehensive Training
KiawitechIT Academy
Houston, TX01.2018
MBA - HR/Marketing
Olabisi Onabanjo University
Nigeria01.2012
Bachelor of Science - Accounting and Information Technology
University of Ado Ekiti
Nigeria01.2005
Skills
- SQL Server Agent
- Backup and Recovery
- Database Auditing
- Performance Tuning
- Extended Events
- Disaster Recovery
- Capacity Planning
- Data Warehousing
- Replication Management
- SQL Profiler
- Dynamic Management Views
- Data Compression
- Query Optimization
- Transparent Data Encryption
- Database Mail
- Database Security
- Index Maintenance
- Policy-Based Management
- Database Partitioning
- AlwaysOn Availability Groups
- Log Shipping
- Data Security
- Implementing Security Measures
- Database Management
- Systems Administration
- Continuous Process Improvement
- Microsoft NET Framework
- Database Development
- Running Backups
- Database Administration
- Customer Needs Assessment
- Data Audits
- Database Locking
- Patch Management
- Relational Database Management
- Data Migration
Certification
AWS Certified Solutions Achitect Associate
Key Technologies
- High Availability Solution- Clustering, Always On, Log shipping
- SQL Server Configuration
- T-SQL Scripting
- Database Migration
- Replications
- Database security
Development
- Performance Troubleshooting SQL Server with Native tools - Completed Training
- Set Yourself Up for Performance Success on Azure SQL Managed Instance- Completed Training
- A Biginners Guide to Query Store-Completed Training 2022
Linkedin Profile
https://www.linkedin.com/in/segun-yagba-97a6b023b
Timeline
SQL Server Database Administrator
Prometheus Group LLC
01.2023 - Current
SQL Server Database Administrator
England Logistics LLC
06.2019 - 12.2022
SQL Server Database Administrator
Merakey Innovative Care & Education Solutions
01.2018 - 05.2019
Junior SQL Server Database Administrator
GZ Industries LTD
02.2015 - 08.2016
MS-SQL Server Database Administration - 300 Hours Comprehensive Training
KiawitechIT Academy
MBA - HR/Marketing
Olabisi Onabanjo University
Bachelor of Science - Accounting and Information Technology
University of Ado Ekiti
Similar Profiles
Carlos RiveraCarlos Rivera
Neighborhood Service Manager at Prometheus Real Estate Group IncNeighborhood Service Manager at Prometheus Real Estate Group Inc
Rafael MagalhaesRafael Magalhaes
Implementation Specialist at Prometheus GroupImplementation Specialist at Prometheus Group
Susan ConleySusan Conley
Business Development Representative at Prometheus GroupBusiness Development Representative at Prometheus Group
AMAR SEHMIAMAR SEHMI
Senior Software Engineer at BackbaseSenior Software Engineer at Backbase
Nicole WrightNicole Wright
LPN at Wellstar RheumatologyLPN at Wellstar Rheumatology