Summary
Overview
Work History
Education
Skills
Languages
Timeline
Generic

BRADO JEAN

Forney,TX

Summary

A Database Professional with over 7 years’ experience managing mission critical databases on Prem and in the Cloud (Azure) I have extensive knowledge of Performance Tuning, Maintenance, High Availability and Disaster Recovery (HADR) Strategies Hands on experience in setting up and troubleshooting AlwaysOn, Clustering, Database Mirroring, Log Shipping, including Replication models (Snapshot, Transactional/Merge) Experience in Database Backup and Restore/Recovery, Query Optimization, Security, SQL Server Installation, Configuration of Stand-alone and Clustered environments Experienced in Migration/Upgrade, applying service packs and routine DBA operations like database health check, index optimization, updating statistics, client/server connectivity and capacity planning. Responsible for securing SQL Server, User Management, assigning permissions and roles Experienced in using Query Store, Extended Events, Database Engine Tuning Advisor (DTA), SQL Profiler, Scripts and other third-party tools to resolve bottlenecks, deadlocks and slow running queries Experienced in database security through configuring transparent database encryption (TDE) and dynamic data masking Experienced working with ServiceNow, SolarWinds, SQL Sentry. Experienced in Active Directory (AD) objects and user permissions.

Overview

7
7
years of professional experience

Work History

Server Database Administrator

SQL, Walmart
02.2019 - Current
  • Managed over 500 databases and VLDB across multiple data centers
  • Involved in Technical decisions for Business requirement, Interaction with Business Analysts, Client team, Development team, Capacity planning and upgrading of SQL Servers
  • Migrated SQL Data from on premises to Azure SQL Database
  • Responsible for setting up and maintaining High Availability and Disaster Recovery Solutions and large-scale database migrations from SQL Server 2005 to SQL Server 2012R2 and 2014/2016
  • Performed Physical and Logical Data Modeling for databases of varied sizes including VLDBs
  • Responsible for providing 24x7 DBA & Production support for over 180 SQL Server databases in Production on Clustered Servers
  • Involved in assisting SQL Server prime customers with Configuration, Administration, Implementation and Troubleshooting for Business workflow with Log Shipping mechanism
  • Configured DR solution with Transaction Replication from Distribution Server with multiple Updatable subscriptions
  • Performed Database Refresh tasks from production to Development and Staging Servers
  • Performed Scheduled backups and restore operations
  • Created (with respect to standards) Logins, Users, groups, Roles, Jobs, Alerts, Mails confirmation upon tasks
  • Performed Database consistency checks with DBCC, Defrag, Index tuning and monitored error logs
  • Provided On-Call support to Mission critical Environments and expertise with Disaster Recovery mechanisms
  • Resolved SQL Server problems in conformance with SLAs, which involves in-depth knowledge of SQL Server architecture, connectivity, replication, backup/restore, security and continuous improvement
  • Maintained two different databases: Read-only reporting database and Disaster recovery database
  • Performed security tasks like Grant, Revoke permissions for security tasks
  • Involved in auditing and performing the transactions to database and resolve the issues with PerfMon and SQL Profiler and Used NetMon for Monitoring and Performing Network throughput issues

Junior SQL Server Database Administrator

Denton State Supported Living Center
05.2017 - 01.2019
  • MS SQL Server design, Development and administration using SQL Server 2005 – 2014 database environments
  • Monitoring SQL health checks and identifying issues and fixing them
  • Used SQL Indexes for improving query performance, lower storage and maintenance cost
  • Used Optimization tools such as SQL Profiler, Dynamic Management Views (DMVs) and Windows Performance Monitor for monitoring and tuning SQL Server performance
  • Implemented Installation, Configuration and Upgrading of SQL Server
  • Good experience in User Management and maintaining databases
  • Automation of administrative tasks like creating jobs and schedules, alerts using SQL Server Agent monitoring and troubleshooting jobs, event notifications using Database Mail
  • Maintained server security by assigning logins, server and database roles and server permissions
  • Implemented disaster prevention and recovery strategies and supported High Availability features like Clustering, Always On, Log Shipping, Database Mirroring and Replication
  • Maintained database response times in 24X7 production environment and proactively generated reports
  • Planned and Implemented database backup/restore and disaster recovery
  • Implemented Log Shipping from Primary to Standby servers
  • Created and maintained SQL objects like Tables, Views, Stored Procedure, Constraints and User defined functions
  • Used tools like SQL Profiler, Fog Light, Red Gate for monitoring my environment
  • Responsible for installing and maintaining SSIS, SSRS, and Power BI

Education

University of Yaounde I
Yaounde, Cameroon
08.2014

Skills

  • Agile Methodology
  • Database Administration
  • Database Mirroring
  • Customer Needs Assessment

Languages

French
Full Professional

Timeline

Server Database Administrator

SQL, Walmart
02.2019 - Current

Junior SQL Server Database Administrator

Denton State Supported Living Center
05.2017 - 01.2019

University of Yaounde I

Similar Profiles

CREATE PROFILE
BRADO JEAN