Database Administrator Sql Server

OLALEYE ADEDOYIN

E-mail: ***********@*****.***

Telephone: 832-***-****

Location: HOUSTON, TEXAS 77407

Linkedin.com/in/olaleye-adedoyin-81abba13

Senior Azure\AWS SQL Database Administrator Cloud Database Engineer PostgreSQL DBA

Career Summary:

•Over 10 years experienced as a SQL Database Administration and Developer for very large and complex databases in SQL Server 2022, 2019, 2017, 2016, 2014, 2012, 2008 R2, 2008, 2005 and 2000.

•Knowledgeable in Database Administration on AWS and Azure cloud with server configuration, performance tuning and maintenance with outstanding troubleshooting capabilities.

•Knowledgeable in T-SQL writing stored procedures, triggers and functions.

•Administering SQL Server High Availability and Disaster Recovery strategies.

•Worked extensively on Clustering and server consolidation. Troubleshooting production & high availability issues.

•24 X 7 Production Database on Call with customer service support experience.

•Experienced working on Critical Situation (CRITSIT) Cases, Met SLA, and expedite escalation process of cases.

Education/Qualifications:

Master of Science in Computer Science (M.S. CS) - Texas Southern University, Houston Texas (2019 – 2021 `)

Bachelor’s degree in Biology and chemistry - Texas Southern University, Houston Texas (2014 - 2018)

Certifications:

AWS Certified Developer

Azure Database Administrator - DP-300

Designing Microsoft Azure Infrastructure solutions

Microsoft Power platform Fundamentals

AWS Certified Cloud Practitioner

AWS Certified Solution Architect -Associate

Skills & Tools:

•MS SQL Server: 2000, 2005, 2008, 2008 R2, 2012, 2014, 2016, 2017, 2019 & 2022 with SSMS, Azure Data Studio.

•PSSDIAG tool, Support Diagnostics Package (SDP), DMVs, SQL Profiler, WindbG or r2d2, Perfmon Analyzer.

•SQL Nexus, Procm on, Database Engine Tuning Advisor (DTA), DiagScan, Performance Monitor Analyzer, Nutanix.

•Commvault Database Backup Tool, Foglight, Lite Speed, Spotlight, Solar wind DPA, Idera Diagnostic Manager.

•Nimsoft, Ca Spectrum, AutoSys, SiteScope, Cisco Finesse, Mac Request, CyberArk, Beyond Trust, Self Service Tool (SST), Sentry One Redgate & SQL Compare, DB Artisan, Opsgenie, Dynatrace, New Relic, Ansible, AppDynamics.

•Service Now (SNOW) - ITIL Knowledge (Incident, Change, Problem Management), BMC, xMatters, Splunk, RSA, Okta, UKG, Jira, Confluence, LastPass, keepass, Secret Manager AWS, MS teams, Slack, Bitbucket, Atlassian Bamboo, Jenkins, Gitlab, Visual Code, Terraform, Cloud Formation, CI/CD, Azure DevOps (ADO) projects.

•Git or TFS: Used as version control tool to track code / file versions:

. Create Git repository, Provide required level of access

. Create branch, Merge code into master branch/release branch

Knowledgeable:

•Windows Failover Clustering and Always On Availability Group Configuration.

•Replication: Transaction, Peer-to-peer, Snapshot & Merge.

•Log Shipping, Database Mirroring, Performance Analysis and others.

•Business Intelligence: (SSIS (ETL), SSRS & SSAS) and Power BI.

•Worked on SQL Database in Azure\AWS platform with AWS Aurora PostgreSQL, MongoDB, Managed Instances.

•Experienced working in virtual environment using VMware, Citrix with Windows server operating systems, Unix/Linux OS platform and PowerShell scripting.

Professional Work Experience:

Tata Consultancy Services . Houston TX. (01/2022 – 05/2024)

Position held: Database Administrator Cloud Database Engineer AWS Azure

Responsibilities:

•Proficient in configuring, implementing, and monitoring different types of High Availability and disaster recovery scenarios like Always On AG, Mirroring, Replication, log shipping, and clustering.

. Create support documentation where applicable to define new and existing software.

. Provide application support to include analysis off application functions, data processing, resolving data corrections to ensure agency services maintain functions.

•Work on project to migrate MS SQL databases to Aurora PostgreSQL on AWS using Schema Conversion Tool (SCT) and Created AWS DMS Replication instance, Source & Target Endpoints with AWS DMS tasks.

•Had hands on experience on relational databases (MSSQL Server, Aurora, Postgres) and on NoSQL databases (DynamoDB, MongoDB) and managing ticketing through Jira, and as well using Confluence for documentations.

•Modifying & created new DynamoDB record for existing Okta account using JSON & on PostgreSQL level.

•Created new DynamoDB table, partition and sort key for new items in AWS console.

•Creating and configured managing Azure SQL databases, Azure Managed Instances in a PaaS environment.

•Worked on using Terraform\AWS Cloud Formation for configuring, deploying & provisioning database automation.

•Used Ansible as an automation tool for deploying of instances for database on AWS, deploying of VPCs, S3 buckets.

•Optimized database performance in AWS RDS and DynamoDB for improvement in query response times.

•Clone or perform database refresh across Azure Managed Instances environment.

•Experience in Encryption on table level, TDE encryption (database level) and SSL encryption (server level).

•Installed and Configured SQL Server 2008 for testing different features and stability Moving databases from on premise servers to Microsoft Cloud platform (SQL Azure) as part of application migrations.

•Experience in performance tuning by identify the bottlenecks from OS and SQL perspective.

•Experience working with Azure SQL Database Import and Export Service.

•Migrate SQL Server Databases to Microsoft Azure hosted DBs, Managed Instances. Configured High-Availability Solution: Always-On, Log Shipping, migration, patching, troubleshooting, optimization, maintenance (modelling High-Availability (HA) and Disaster Recovery (DR)).

•Troubleshoot batch failure to determine cause (review AutoSys logs) and correct/escalate.

•Worked on Git bash\Visual Studio code to track codes, Create branch, Merge code into master branch/release branch

•Familiarity with DevOps practices and tools for continuous integration and deployment (CI/CD).

. Position may edit and correct existing applications and/or develop new solutions to remedy situations that may arise.

VTECHSOLUTION Dallas TX (04/2021– 01//2022)

Position held: Database Engineer Azure

Responsibilities:

•Responsible for Database support, troubleshooting, planning and migration (Sql Server 2005 - 2019)

•Having experience in Migrating on Premises SQL Databases to SQL Azure using DMA & DMS (Offline & Online).

•Performed capacity planning and resource management.

•Migrated SQL Databases from On-premises to Azure, configured Geo-replication for High availability, manage database on Elastic pools, Managed instances and automating database setup using DACPAC, BACPAC, Terraform

•Upgraded databases from SQL Server 2008 to SQL Server 2019.

•Had experience in creating the alerts for VMs using Azure Portal with Azure Data Studio

•Comfortable using Azure power shell, CLI to troubleshoot issues in Azure Managed Instances.

•Performed all database management responsibilities in Microsoft Azure for production & non-production workloads.

•Performance Tuning, Index Tuning, Maintenance, Query Optimization and Database Consistency Checks.

•Using the SSRS to create the Parameterized and Linked reports for visualization for different requirements and manage the report subscription and the security management on the report server.

•Installation and Configuration Sql Server Cluster and Stand Alone

•Windows Active Directory administration/windows server support and created PowerShell script for automation.

•Making the backup strategy based on the RTO and RPO of company.

•Worked on Azure Active Directory (AAD) with MFA to create Login and grant permissions to users to connect to Azure SQL and Azure Managed Instance databases.

Texas Southern University Houston, TX (01//2020– 01/2021)

Position held: Database Administrator/Developer

Responsibilities:

•Worked extensively on Installations and configurations of SQL Server in clustered and non-clustered environment.

•Assisted to migrated/upgraded of lower version SQL server to higher version in Windows Server Enterprise Edition.

•Experience in monitoring the disk usage and the memory usage of the servers.

•Transferring the data ETL (SSIS) to Data ware house by SQL Server 2005 Integration Services.

•Installations of SQL Server Service Packs, upgraded databases from SQL 2008 to SQL Server 2016.

•Knowledgeable in creating Star schema cubes using SSAS.

•Ensure data integrity is maintained through security and change management.

•Worked with different upstream team for downloading ETL MART data.

•Created and Managed OLAP Cubes using SSAS.

•Used PowerShell to automate jobs, using Ola Hallengren scripts and troubleshooting issue at OS and database level.

•Assisted in development and execution of data service disaster recovery plans.

•Export/Import data from other data sources like flat files using Import/Export via DTS, SSIS.

•Reviewed SQL Scripts from the development team before releasing them into the Production.

•Created Credential, proxy & Linked Servers between SQL and other Heterogeneous environment (Azure & DB2).

•Scheduled Full and Transactional log backups for the user created and system databases in the production environment using the Database Maintenance Plan Wizard.

A Peace Of Mind Care Group LLC HOUSTON, TX

Position held: SQL Database Support Engineer (04//2018 – 02/2020)

Responsibilities:

•Extensively worked on installing, configuring, optimizing and managing different versions SQL Server 2000, 2005, 2008R2, 2012, 2014, 2016, 2017 and 2019 updating with latest hot fixes and service packs.

•Migration of SQL server database from on premise to Azure IAAS/PAAS.

•Good hands-on High Availability/Disaster Recovery (HADR) solutions; Failover Clusters and SQL Always On Availability Groups, Replication, Log Shipping and Mirroring.

•Used the built-in intelligent performance tool and queries performance insight in Azure Portal to find the bottlenecks on CPU, disk I/O, & memory devices to tune and improve the database performance issue in managed instance (MI).

•Automate Database tasks (Created jobs, alerts, schedules for database maintenance tasks, and using PowerShell scripts to copy SQL binaries to multiple servers at once during SQL patching: SP, hot fixes, Security Patches etc.).

•Experienced with deployments, maintenance & troubleshooting application on Microsoft Cloud infrastructure Azure.

•Experienced in Monitoring, Optimization, Performance tuning of SQL Server databases using DMVs, Activity Monitor, SQL Profiler, DB Tuning wizard and third-party tools.

•Worked on data security for compliance measures, integrating Azure Active Directory, & using Azure Key Vault.

•Manages Backup and restore Azure SQL Databases with Ola Hallengren scripts.

•Applied the DBCC commands for database maintenance, tempdb, partition, update statistics, indexing, and validation operations, enabling trace flags and removing DLL from memory.

•Pulled data across multiple databases (Oracle, DB2, SQL Server, Sybase, and Access etc.). Connected data sources by Business Intelligence tools (SSIS etc.), linked database objects (linked servers, database link etc.).

•Creating and maintaining data maintenance plans, OLTP and OLAP systems.

•Work with Azure power shell, CLI to troubleshoot issues and manage Azure SQL database, elastic jobs, elastic pools

•Experience with Microsoft Azure cloud (Managed instances, SQL VM, ADLS, IAAS, PAAS, CI/CD Pipelines).

•Change Management, Service Now (SNOW) Ticketing System, Representing Team at the CCB and Deployment.

Contact this candidate