Database Administrator Data Analyst

OLUWATOSIN AYODELE

DATABASE ADMINISTRATOR DATA

ANALYST

+1-734-***-**** **********.***.****@*****.*** LinkedIn Website Github PROFESSIONAL SUMMARY

Analytical, security-focused Database Administrator / Data Analyst with 3+ years in telecom and fintech and a Master’s in Information Systems (Cybersecurity & Data Analytics). Proven track record leading AWS RDS migrations (Multi-AZ), hardening databases with RBAC/TDE/SSL, and implementing reliable backup and recovery. Delivered 99.95% availability, 55% faster recovery, and 35% faster queries through indexing and tuning. Built automated data pipelines and Power BI/Tableau dashboards that defined KPIs, cut reporting time by 60%, and enabled faster, clearer decisions. Skilled in Python, SQL, Excel, Power BI, Tableau, and R; committed to data quality, governance, and compliance with HIPAA, PCI DSS, and ISO 27001. AREA OF EXPERTISE

Data analysis and visualization • Business intelligence • KPI design and reporting • ETL and data pipelines • SQL development and T SQL • Database administration and performance tuning • Backup and recovery • High availability and failover • Data modeling and ERD • Data governance and compliance • Cloud migration

•Coaching and Mentorship

TECHNICAL SKILLS

• Databases and Data Warehousing: SQL Server, MySQL, PostgreSQL, Microsoft Access, Oracle, T-SQL

• Cloud and DevOps: AWS RDS, EC2, S3, IAM, CloudWatch, SNS, AWS CLI

• ETL and Automation: SSIS, Power Automate, Python ETL Scrpits, CRON, SQL Agent Jobs

• Analytics and BI: Power BI, Tableau, Advanced Excel (Pivot Tables, Forecasting, Solver), DAX,

• Programming and Tools: Python Pandas and NumPy, R (dplyr and ggplot), Bash, PowerShell

• Security and Compliance: RBAC, TDE, SSL, audit logs, ISO 27001, PCI DSS, HIPAA

• Process and Collaboration: JIRA, Confluence, Lucidchart, Visio, ServiceNow, Agile PROFESSIONAL EXPERIENCE

Database Administrator

MainOne Cable Feb 2022 – Dec 2024

• Planned and executed migration of provisioning and NOC inventory from on premises SQL Server to Amazon RDS Multi AZ using native backup and restore and AWS DMS where needed. Achieved 99.5% uptime and shorter maintenance windows.

• Administered 20+ production and reporting databases across SQL Server 2019 and MySQL 8 for billing, customer provisioning, and NOC inventory. Supported core telecom operations telecom operations for over 500 enterprise and carrier customers and millions of downstream subscribers.

• Built python checks that queried heartbeat tables and replication lag and sent alerts through CloudWatch and SNS, reducing incident detection time by 75%.

• Designed backup and recovery using SQL Server native backups and Amazon RDS automated snapshots with export to S3, encrypted with TDE and SSL. Ran monthly restore drills reduced recovery time by 55%.

• Tuned performance in SSMS with execution plan analysis, index design, and parameterized T SQL, reducing heavy reports and nightly jobs by about 35% - 45%.

• Documented SOPs for migration, backup and recovery, performance tuning, and access requests. Improved cross team handoffs and audit readiness.

• Mentored junior DBAs on migration planning, performance tuning, and Amazon Web Services tooling during critical cloud transition phases. Raised team confidence and reduced rework. Junior Data Analyst

Interswitch Jun 2021 – Mar 2022

• Built real time Power BI and Tableau dashboards with DAX and live SQL views to track failure rates, latency, and fraud alerts, cutting time to detect incidents from hours to under 10 minutes and improving daily triage.

• Automated reconciliation for PayDirect and Quickteller with SQL stored procedures and Excel, reducing manual effort by over 60% and shortening month end close by about one day.

• Queried multi-million row payment datasets in SQL Server with T SQL to surface weekly trend reports that guided finance and risk actions on chargebacks, refunds, and routing adjustments.

• Designed and analyzed controlled A B tests for feature changes across thousands of user sessions, producing statistically significant results that informed rollout decisions and improved task completion.

• Tuned SQL Server performance by fixing index fragmentation and optimizing stored procedures, reducing nightly batch time by about 35% and accelerating morning reporting.

• Normalized KYC and merchant onboarding tables and documented ERDs, cutting duplicate and inconsistent records by about 30% and improving downstream data quality for analytics. PROJECTS

Game Management System (Capstone) – SQL, Python, Figma

• Designed relational schema and ERDs for game metadata, user inventory, orders, and transaction logs

• Wrote SQL for inserts, updates, and lookups with Python logic for validation, authentication, and admin reporting

• Prototyped admin and user flows in Figma and demonstrated real time style synchronization between catalog and user library

Climate Policy Forecasting – EN-ROADS Simulator, Excel Solver & Regression

• Led data analysis on global energy trends to forecast climate policy impacts through 2100, using ENROADS and Excel tools (Solver, regression, sensitivity analysis) to evaluate emission scenarios and optimize solutions for limiting global warming to below 2 C. Cybersecurity Lab Series– Wireshark, Kali Linux

• Ran penetration tests and analysis on simulated internal networks, practiced using tools like Nmap, Wireshark, and Fail2Ban.

CERTIFICATIONS & TECHNICAL TRAINING

• AWS SkillBuilder – EC2 Monitoring, IAM Policies, Amazon Redshift, CloudFront

• Google Chronicle Security Operations – Fundamentals

• Celonis Process Mining – Rising Star (Intermediate)

• FEDVTE- Cybersecurity Essentials

• DataForge Bootcamp – Excel, SQL, Power BI, DAX, Data Modeling EDUCATION

Central Michigan University

Master of Science – Information Systems (Cybersecurity and Data Analytics) Babcock University

Bachelor of Science – Communication (PR, Advertising & Marketing)

Contact this candidate