DOLAPO RUTH ODUSAMI, MCSA

Fayetteville, GA• Phone: 316-***-****• Email: adxuvt@r.postjobfree.com

MS-SQL DATABASE ADMINISTRATOR/DEVOPS ENGINEER

Professional Summary:

Dolapo is a professional Microsoft Database Administrator with over 8 years of experience and 3 years of Azure SQL/AWS. Well experienced in data migration, database performance tuning, backup and recovery, management of database security, high availability solutions, database and application upgrades, as well as patches with SQL Server. She has a keen eye for job details and a growing passion for acquiring new knowledge especially in the areas of Microsoft SQL Server and other Applications. She also possesses strong leadership, collaboration, teamwork and problem-solving skills. In addition, AWS and Azure Cloud/DevOps Engineer experienced in provisioning, managing, documenting, and enhancing an organization's software products lifecycle and features. Automating cloud orchestration, security in architecting cloud computing, development, system administration with hands on experience. Responsible for timely end-to-end enterprise software releases. Managed IaaS, PaaS, SaaS and On-premises infrastructures, with proven track record of utilizing resources and tools to provision infrastructures in cloud environment like AWS, GCP, Microsoft Azure.

Core experience:

Database Migration Disaster Recovery Integration Services

Performance Tuning Reporting Services Database Upgrades patches

Backup and Recovery Database Security High Availability Solutions

Database Monitoring Data Manipulation SQL Installation

Replication Powershell/Automations SQL Azure/Cloud

Azure SQL Migration Blob Storage DMA & DMS

Azure SQL Database SQL Server on Azure VM Azure SQL Managed Instance

Azure Backup Azure Site Recovery Azure VM snapshots

Ansible Tomcat AWS

Jenkins JIRA Terraform

Maven Kubernetes Prometheus/Grafana

SonarQube New Relic Nexus

Docker Docker Swarm Helm

Git/GitHub Nginx Linux

HAProxy Route53 AWS Elastic Search

AWS ELB AWS VPC AWS EC2

AWS IAM AWS EBS VS Code

Areas of Strength:

●Experience in troubleshooting performance issues (Query Optimization, I/O bottleneck, Blocking, Deadlock, Memory, CPU) to maintain uptime for SQL Server

●Manage the production and development databases including performance tuning, capacity planning, database security configuration, and database continuity on SQL Server 2008 R2, 2012, 2014, 2016, 2017 and 2019.

●Table partitioning, file and file-group management, Knowledge of High Availability of database servers using Database mirroring, replications, and Log Shipping.

●Design and implement 2005, 2008 R2, 2012 and MS SQL 2014, 2016, 2017, 2019 databases for mission-critical business.

●Use SQL Profiler and Extended Events for troubleshooting, monitoring, optimization of SQL Server and SQL code.

●Troubleshoot databases and custom application issues for 2005, SQL Server 2008 R2, 2012, 2014, 2016, 2017 and 2019.

●Experienced in working with end users to define, implement, and maintain their reporting requirements.

●Experienced in the design, coding, testing and implementation of high volume transactional (OLTP) SQL databases.

●Managing SQL Azure Databases and Replicating data from onsite Databases to Cloud.

●Collaborating with developers to make sure new environments meet requirements and conform to best practices.

●Automating deployment of T-SQL, PowerShell and respective scripts, system configurations and security settings.

●Experienced in Deployment of SSIS packages and SSRS Report.

●Managing and deploying; IaaS, Paas, SaaS, and On-Prem Infrastructures.

●Languages: Bash Shell, python, html, Powershell, yaml, JSON, XML and Groovy.

●Cloud Engineering (AWS and Azure Cloud Architect)

●Kubernetes Administrator

oBuilding Continuous Integration, Continuous Delivery, Continuous Provisioning, Continuous Configuration, Continuous Deployment, Continuous Monitoring, Continuous Testing Jenkins pipeline with Maven, Docker, Helm, Ansible, Terraform, GitHub, Git, Groovy, AWS Code Build, Azure DevOps pipelines, Prometheus and Grafana, Nexus, AWS EKS, EFK/ELK.

●Enterprise Applications Development (Java)

●Operating Systems (Linux, UNIX, Solaris, Redhat, Windows Server 2008/2012/2016).

●DBMS (MySQL, SQL Server, PostgreSQL, MongoDB).

●Web/Application Servers (JBOSS, Tomcat, Websphere, Nginx, HAProxy).

●Business Intelligence & Dashboard Reporting

●Generate the weekly, monthly, and quarterly report by using SQL Standard Report.

●Create reports that run daily for jobs running in SQL Server Agent.

●Experienced with monitoring and troubleshooting in 24x7 operations.

●Configuration of Always on availability group on one primary and 4 secondaries.

●Installation, configuration, and upgrade of Microsoft SQL Server 2008r2 and 2012,2014, 2016, 2017 and 2019.

●Migration of over 1000 databases from one server to another.

●Experience in troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues, replication issues, log shipping issues, connectivity issues, security issues etc.

●Ability to detect and troubleshoot SQL Server related CPU, memory, I/O, disk space and other resource contention.

●Knowledge of Azure SQL instance, Azure SQL database and SQL Database on Azure VM.

●Strong knowledge of backups, restores, recovery models, DBCC commands, Log Shipping, Transactional Replication.

●Modify stored procedures, queries, views, and indexes to handle business rules, history data and audit analysis.

●Manage the production and development databases including performance tuning, capacity planning, SQL Server clustering, database security configuration, and database continuity.

●Excellent analytical, communication skills, work ethics and ability to work in a team environment with strong determination and commitment to the deliverables.

●Strong decision making and problem-solving skills, highly motivated self-started and ability to work independently.

●Experience with Azure Resource Manager templates and knowledge of how environments can be provisioned using infrastructure as code.

●Experience with Azure Vnet Peering.

●Bulk insert users in Azure AD

●Azure Blob storage (Container, tables, Queues) using Azure Portal and Microsoft Azure storage explorer.

●Azure active directory using IAM, Access keys and Signature base authentication URL

●Experience in Azure (IaaS) migrations like creating Azure VMs, storage accounts, VHDs, storage pools, migrating on-premises servers to Azure, and creating availability sets in Azure.

Professional Job Experience

OSMOSE UTILITIES, - Peachtree City, GA (June 2016– present)

Database Administrator/AWS DevOps Engineer

●Responsible for administering and maintaining over 1700 databases of Production, Dev and Test environment.

●Implementing and maintaining database schema, entity relationship diagrams, data modeling, tables, stored procedures, functions and triggers, constraints, indexes, functions, views, rules, defaults and complex SQL statements.

●Perform Prebuild and Post build SQL Server Installation and Configuration.

●Ensure database performance monitoring and tuning is regularly accomplished.

●Implement security policy SQL Server.

●Responsible for maintenance, Backup & Recovery testing, alerts (job failures, database & server capacity, etc.), and database integrity checks

●Review logs, update database statistics and index management

●Configure multiple linked servers on SQL Server instance and policy management.

●Troubleshoot application performance issues, database maintenance & configuration, patching, and upgrading.

●Security, auditing, configuring, documenting, enhancement & corrective changes, emergency changes.

●Work with other DBAs and Developers team members and various application teams.

●Managed environment and system configuration changes and application of problem management upon available skills and experiences.

●Management and Implementation of Resources planning, operations and cooperation on application of projects for continual environment and procedure improvement.

●Designed backup and restore strategies and Disaster Recovery solutions to prevent data loss.

●Implemented and maintained transactional replication for multiple databases.

●Database maintenance, Manipulation and Cleanup.

●MS-SQL 2008/2012/2014/2016/2017/2019/2022 administration including installation, configuration, upgrades, capacity planning, performance tuning, backup and recovery.

●Knowledge of Database Replication, Mirroring and Log Shipping.

●Successfully migrated SQL Server consolidated instances into it stand alone server.

●Migrating databases from different platforms to SQL.

●Monitors servers for resources utilization disk space, memory and CPU.

●Extensive Monitoring of SQL Server with Third Party Tools like IDERA, APEXSQL and QUEST SOFTWARE

●Working as part of DevOps Team working closely with developers for different internal automation and build configuration management.

●Built and configured Linux and Windows servers in AWS EC2 and ensured they are hardened to meet CIS benchmark then joined to the AD Domain before application usage.

●Reduced costs by $5000.00 monthly by implementing lower environment server stop and restart automation and subscription to reserved instances for consistent production workload EC2 instances.

●End to End security best practices implementation in all endpoint layers of infrastructure architecture.

●Actively managed, improve, and monitor cloud infrastructure on AWS, EC2, S3 and RDS including backups, patching, and scaling.

●Applied knowledge working in AWS multi-account strategy in AWS Organization and Landing Zone.

●Configuring Route53 to map ingress traffic to DNS registered CNAME/Alias and further routing to AWS Load Balancer Ingress Service.

●Migrating application Sources Codes from different version control systems such as BitBucket, GitHub into AWS Code Commit.

●Deploying Dockers Engines in virtualized platforms for containerization of multiple apps.

●Working with developers to decouple monolithic applications into containerized applications.

●Setup and maintenance of Helms as package management for EKS configuration management.

●Working with DockerHub to pull and push Docker images.

●Experiencing using declarative and imperative approach to Kubernetes deployment.

●Experience troubleshooting and maintaining Kubernetes Clusters and Objects.

●Experience in network troubleshooting and analysis with a view of getting root causes of issue in the Kubernetes clusters.

●Deployments using Blue-Green, Rolling updates and Canary deployment patterns and strategies.

●Implemented IAM best practices and role-based access control in AWS EKS Clusters and other AWS services.

●Configuring ELK (ElasticSearch, Kibana) for Log monitoring of Containerized applications.

●Configuring Prometheus and Grafana for monitoring containerized applications, alerting and visualization.

●

City of Cleveland, - Cleveland, OH (March 2014– June 2015)

Database Administrator

●Ensuring Database performance monitoring and tuning is regularly accomplished to prevent downtime.

●Performs Windows analysis, acquisition, installation, maintenance, and upgrade of server/computer hardware, operating systems, and software utilities; Manage the deployment, upgrades, and maintenance of, servers, hardware, software, desktop operating systems, and printers.

●Performing server/client upgrades on Windows Server 2008, 2008r2 2012 and 2014

●SQL Development - ability to write and troubleshoot SQL Code and design (stored procedures, functions, tables, views, triggers, indexes, constraints).

●Responsible for Windows troubleshooting of all incoming incidents and performs requests for service.

●Managed environment and system configuration changes and application of problem management upon available skills and experiences.

●Management and Carried out Resources planning, operations and cooperation on application of projects for continual environment and procedure improvement.

●Import and export data (Dev to QA, QA to Production).

●Ensuring Database performance monitoring and tuning is regularly accomplished.

●Designing backup and restore strategies and Disaster Recovery solutions.

●Creating database design for new projects support

●Rebuilt the indexes at regular intervals for better performance.

●SQL Server database physical model creation and implementation (data type, indexing, table design)

●Ensuring definition and development of database documentation and standards for easy continuity

●Responsible for setting up and scheduling various tasks by creating maintenance plans.

●Monitored performance and allocated resources to achieve optimum database performance.

●Monitored and maintained appropriate disk storage requirements for the database.

●Performed Database administration, performance tuning and validating existing schemas.

●Implemented Database mirroring and transactional replication.

TATA CONSULTING, - Atlanta, GA (October 2013 – March 2014)

Junior Database Administration

●Responsible for the configuration and administration of Microsoft SQL Server for approximately 50 database servers, and 400+ databases

●Set up and administered SQL Server database security environments using profiles, database privileges and roles.

●Ensured definition and development of database documentation and standards.

●Implemented security policy design for current and new applications to prevent data corruption and theft.

●Assisted in establishing standards and schedules for database backups by making sure that the backup schedules meet the recovery requirements on a daily, weekly, and monthly basis.

●Tuned transactional SQL and stored procedures.

●Oversaw the design and implementation of new applications and changes to existing hardware systems and software packages for customers for high performance.

●Used problem solving skills and root cause analysis to resolve and/or mitigate IT operational issues.

●Responsible for setting up and scheduling various tasks by creating maintenance plans.

●Monitored performance and allocated resources to achieve optimum database performance.

●Setup and configured Database mirroring in High Performance, High availability mode as standard DR strategy

Import and export data (Dev to QA, QA to Prod).

●Monitored and maintained appropriate disk storage requirements for the database.

●Monitored and modified Performance using execution plans and Index tuning.

●Rebuilt and Reorganized indexes at regular intervals for better performance.

●Implemented Log shipping and transactional replication.

Professional Certifications

Microsoft Certified SQL Server 2012/2014

Microsoft Azure Administrator training

Linux/AWS/Azure DevOps Training

Education

●Brenau University Gainesville, Georgia - Bachelor of Business Administration.

●Keller Graduate School of Management - Master of Science

Honors

Who’s Who Among Students in American Universities & Colleges

NAIA Women’s Soccer Scholar-Athlete

Contact this candidate