Doris ALSTON
Conroe,Texas
Summary
Overall 8+ Years experience as a database administrator. Solid working experience in managing large databases, backup/recovery, configuring and managing HA/DR solutions, Performance Tuning, security, etc. Working experience deploying SQL server native tools as well as third party tools to enhance performance of my environment. Proven ability to help shape organizational performance and responsiveness to business needs, with notable contributions to profitability, process optimization, and customer satisfaction.
Overview
7
7
years of professional experience
Work History
SQL SERVER DBA
Texas Department of Criminal Justice
02.2018 - Current
- Performed Database Migration from an On-Premises SQL environment to Azure Database in the cloud
- Manage infrastructure performance, data security and make recommendations for improvements
- Involved in the planning, setup and implementation of new servers across the entire enterprise
- Involved in ensuring data recovery, maintenance, and data integrity and space requirements for physical database
- Planning and implementation of Database backup/restore and disaster recovery
- Explored High Availability (HA) and Disaster Recovery (DR) options for SQL Server
- Tweaking Server configuration to improve performance
- Installed and configured MS SQL Server 2008 R2, supported all Production and development servers
- Ensuring business continuity with appropriate backup and recovery processes, failover procedures, and testing to guarantee point-in-time
- Developing SQL scripts for maintaining administration tasks
- Performed Capacity Planning and resource allocation
- Monitoring standby databases to ensure high availability
- Help monitor and manage the costs of the resources used in the data integration
- Upgraded SQL Server from 2008R2 to 2014, 2016 and 2019
- Used SQL Server Profiler, Extended Events, Query Store, and Database Engine Tuning Advisor for performance optimization
- Configured and supported replication and log shipping in SQL Server.
DATABASE ANALYST
Walmart Inc
08.2016 - 01.2018
- Design, develop, and maintain databases for various applications and systems
- Create and optimize SQL queries for data retrieval and manipulation
- Develop and maintain documentation related to database design, configuration, and processes
- Develop and implement data models, database schemas, and data dictionaries
- Monitor database performance and recommend improvements for optimization
- Collaborate with cross-functional teams to gather requirements and ensure data integrity
- Troubleshoot and resolve database issues in a timely manner.
Education
Bachelor’s Degree - Business Administration and Information systems
University of Lagos
Associate of Applied Science - Information Technology
Miami Dade College
Miami, FL04.2014
Skills
- Index Maintenance
- Backup and Recovery
- Log Shipping
- Query Optimization
- Capacity Planning
- Data Warehousing
- Database Auditing
- Transparent Data Encryption
- AlwaysOn Availability Groups
- Disaster Recovery
Technical Knowledge
Microsoft SQL Server 2012/2014/2016/2019, Azure SQL Server Database., SSMS, SSCM, SQL Profiler, SQL Query Analyzer, Database Engine Tuning Advisor (DETA), Red Gate, Spotlight, Queries store, Performance Monitor, Activity Monitor, Extended Even, Store procedure, etc.…, Windows server 2019/2016/2012R2/2008, Virtual Machines, Windows Remote Desktop., Pc Upgrades/Repairs, Connectivity Troubleshooting, Component Replacements
Recent Projects
- SQL 2012/R2 Upgrades and migration to 2019.
- Applying windows and SQL Server patches on Production/Non-Production Servers
- Setting Up Maintenance plans using ola.hallengren
References
Available upon request
Timeline
SQL SERVER DBA
Texas Department of Criminal Justice
02.2018 - Current
DATABASE ANALYST
Walmart Inc
08.2016 - 01.2018
Bachelor’s Degree - Business Administration and Information systems
University of Lagos
Associate of Applied Science - Information Technology
Miami Dade College