Summary
Overview
Work History
Education
Skills
Websites
Certification
Programming Scripting Languages - Dba Related
References
Timeline
Generic

Walfred Guerrero

Summary

High-performing SQL Server DBA 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

10
10
years of professional experience
1
1
Certification

Work History

SQL Server Database Administrator

Accenture
08.2021 - Current
  • Work with multiple clients for SQL server issues and ServiceNow tickets
  • Server migration from on-prem to AWS EC2 servers
  • AWS RDS refresh from prod to qa database
  • Work with Azure SQL doing daily db tasks.
  • Maintained complex T-SQL queries, views and stored procedures in multi-database environment with little supervision.
  • Documented analysis results and provided performance improvement feedback.
  • Managed workload independently but collaborated with colleagues to complete larger scale tasks in distributed team environment.
  • Supported projects enabling delivery efficiencies and technical resolution.

Lead SQL DBA

Sogeti USA
06.2016 - 08.2021
  • Worked at Sogeti for 3 years as Lead SQL DBA
  • Work with performance issues, executing scripts, creating new databases, installing SQL on new standalone/cluster server, decommissioning SQL, migrating SQL over new standalone/cluster server, upgrading SQL to latest version, and patching
  • Collaborated with solution architect team on new server builds and SQL license
  • Made sure application team have appropriate SQL license for their new server
  • Worked effectively in fast-paced environments.
  • Was only on-call person for SQL.
  • Setup monitoring for all servers via SiteScope which checks for blocking, long running query, database status, sql services, CPU, and memory on server.
  • Self-motivated, with strong sense of personal responsibility.

-

-
01.2020 - 08.2021
  • Work on cleaning up oracle databases that are not being used or otherwise not being utilized
  • Decommission Oracle database and/or schema that application team no longer needs and storing backup if application team decides that do need database/schema
  • Also work on java patching and OPatch for oracle home and Grid as well
  • Setup cronjob to do several tasks to schedule export, refresh, and monitor servers
  • Daily task with ticket for any Oracle related issue from performance issue, availability of db, checking alert logs for any issue.

-

-
01.2020 - 08.2021
  • Work with Postgres databases with account creation and taking database backup
  • Running script for application team in Stage and Prod database
  • Create auto startup script that will start Postgres database when server reboots
  • Refreshing stage db from prod
  • Upgrade Postgres databases from 10.3 to 11.5.

Database Operation

Data Intensity
08.2014 - 06.2016
  • Mainly work as database operation for 2 years at Data Intensity
  • Worked on Service Now tickets that come in from different customers or monitor alerts
  • Worked on client server that had SQL 2005,2008r2, and 2012
  • Troubleshoot Windows server and Linux box and contacted the client for any critical issue that was ongoing
  • Executed scripts for altering, dropping, adding tables, checking blockers on server, and checking current backups
  • Worked with replication and mirroring jobs and log shipping synchronization.
  • Continually expanded professional knowledge and skill set through research, training, and engagement with industry best practices.

Education

Bachelor of Arts - Media Informatics

Northern Kentucky University
Highland Heights, KY
12.2014

Skills

  • ServiceNow
  • Database Security
  • SQL Server Analysis Services
  • SQL Server Integration Services
  • Log Shipping
  • Replication Management
  • SQL Server Reporting Services
  • Transparent Data Encryption
  • SQL Profiler
  • SQL Server Agent
  • Database Partitioning
  • AlwaysOn Availability Groups
  • Index Maintenance
  • Database Mail
  • Performance Tuning
  • Backup and recovery
  • Database Auditing
  • Extended Events
  • Relational databases
  • Database Management
  • Database Administration
  • Data Migration
  • Microsoft SQL Server
  • Microsoft SQL Server Knowledge
  • Microsoft SQL Server Management
  • SQL Server Clustering
  • SQL Server Administration
  • SQL Server Knowledge
  • SQL Server proficiency

Certification

  • AWS Cloud Solution Architect Associate, 2022
  • AWS Database Specialty, 2023
  • Azure Fundamentals 900, 2023

Programming Scripting Languages - Dba Related

  • T-SQL
  • PowerShell
  • Bash Script

References


  • Ethan Burkhart, Oracle DBA, Oracle, 765 580 1835
  • Gary Mills, SQL DBA, Accenture, 859-835-4732

Timeline

SQL Server Database Administrator

Accenture
08.2021 - Current

-

-
01.2020 - 08.2021

-

-
01.2020 - 08.2021

Lead SQL DBA

Sogeti USA
06.2016 - 08.2021

Database Operation

Data Intensity
08.2014 - 06.2016

Bachelor of Arts - Media Informatics

Northern Kentucky University

Similar Profiles

CREATE PROFILE
Walfred Guerrero