Production SQL Server DBA - Walmart - Bentonville, Arkansas
(2023-07)
Serve as a Production DBA supporting 24x7 enterprise database operations, install, configure, upgrade, and migrate MS SQL Server 2008R2 through 2019 across production and test environments — including instance start/stop, configuration parameter changes, and routine operational maintenance — and perform backup/restore operations across all supported versions.
- Troubleshoot application database connectivity, SQL Server issues, and query performance across production, QA, and development environments; monitor SQL Server error logs and resolve issues through ticket/task handling.
- Apply HA/DR models — including log shipping, database mirroring, Always On Availability Groups, and Windows Failover Clustering — and implement/test point-in-time recovery, automating backup and recovery via SQL Agent jobs.
- Migrated SQL databases from on-premises to Azure SQL; maintain referential, domain, and column integrity using constraints, and administer production and non-production servers.
- Validate backup integrity and perform restore testing to support disaster recovery readiness, including point-in-time recovery exercises for production databases.
- Use capacity planning tools to monitor CPU/memory utilization, disk contention, and transactions per second; perform database health checks and scalability assessments.
- Tune stored procedures and distributed queries; optimize performance through query refinement, indexing, normalization, and removal of redundant data; configure data and table partitioning on large tables for improved performance.
- Contribute to data modeling and database design, implement security measures to protect sensitive data, and collaborate with cross-functional teams on application development to meet business requirements and timelines.
Production SQL Server DBA - ExxonMobil - Houston, TX
(2019-03 - 2023-05)
Served as a Production DBA supporting 24x7 enterprise database operations; installed, configured, upgraded, and migrated MS SQL Server across production and test environments, and prepared and maintained SQL Server installation and configuration documentation.
- Performed daily backup, restore, and disaster recovery operations using SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.
- Created database maintenance plans covering integrity checks, statistics updates, and re-indexing; rebuilt indexes at regular intervals to sustain performance.
- Developed and optimized database structures, stored procedures, Dynamic Management Views, DDL triggers, and user-defined functions; partnered with application developers on database and table design.
- Configured log shipping for database synchronization, analyzed and tuned long-running queries, and executed approved SQL Server changes (installations, upgrades, patching, configuration updates) through documented change management processes on production servers.
CAD Administrator - CP&Y Inc. - Houston, TX
(2015-11 - 2019-05)
Administered and supported Bentley ProjectWise and Autodesk Vault environments for 200+ engineering users, managing project workspaces, document workflows, security, and engineering data repositories.
- Managed SQL Server databases supporting ProjectWise, performing backups, restore testing, DBCC CHECKDB, index and statistics maintenance, transaction log management, and capacity planning to maintain database reliability.
- Installed, configured, and maintained ProjectWise data sources, file storage areas, and DFS replication, improving document availability across multiple offices while administering Autodesk and Bentley licensing and generating SSRS usage reports to support license optimization.
- Provided Tier 2/3 technical support for SQL Server connectivity, ProjectWise database issues, Autodesk Vault synchronization, CAD application errors, and document management workflows, while partnering with engineering and IT teams to implement CAD standards, manage user permissions, develop technical documentation, and train end users.
