Over 7 years of experience in Database Administration for very large and complex databases in SQL Server 2019,2017,2016, 2014, 2012, 2008, 2005.
Performed all day-to-day aspects of MS SQL database administration. Responsibilities include database design, installation, configuration, upgrades, security, managing users and logins, performance monitoring and tuning, database availability, backup and recovery, troubleshooting and problem resolution.
Configured High Availability Solution- Clustering, Always On, Database Mirroring and Log Shipping.
Involved in ensuring data recovery, maintenance, and data integrity and space requirements for physical database. Creating and Modifying Tables, Stored Procedures, Views, Indexes, User-defined Functions and Triggers as requirement on SQL Server Environments.
Planning and implementation of Database backup/restore and disaster recovery
Installed SQL Server 2005-2019 on following Microsoft best practices, applied Patches and security fixes.
SQL Server Profiler, Extended Events, Query Store and Database Engine Tuning Advisor (DTA) for performance.
Configured and supported replication and log shipping in both SQL 2008 and 2012.
Maintained database response times in 24/7 in Production environments.
Monitoring standby Databases to ensure high availability
Automation of DBA tasks using PowerShell scripts and monitoring
Configured and managed Contained Database
Managed and provisioned Azure SQL databases and services.
Configured and supported replication and log shipping in both SQL 2008 and 2012.
Managed and reduced cost by effectively monitoring the databases elastic pool
Performed Database Migration from an On-Premises SQL environment to Azure Database in the cloud
Installed and configured MS SQL Server VM in Azure Database
Overview
7
7
years of professional experience
Work History
MS SQL SERVER DBA
EdgeLink
El Segundo, CA
2020.01 - Current
Planning the Installation of Microsoft SQL Server 2005SP4, 2008R2, 2012, 2014, 2016, 2017, 2019, building, designing, Configuration, Upgrade, Migration and application of Windows and SQL Patches during scheduled database non production hours to ensure databases are up to date in Virtualized environments
Implement and define a vigorous Backup and Recovery strategy and Capacity planning following the company's SLA that is Recovery Point Objective (RPO) and Recovery Time objective( RTO) and the Retention policy
Recommend and implement data security by creating users and assigning permissions based on the principle of least privileges and also with technologies such as Always Encrypted, Transparent Data Encryption (TDE) and Dynamic Data Masking (DDM) to secure clients sensitive data
Using SQL server in-built tools such as SQL Server profiler, Extended Events, activity monitor to monitor performance and system health; Database Integrity checks to ensure database integrity, stability, and system availability.
Configured High Availability (HA) and Disaster Recovery (DR) Solutions on production in standalone and Clustered environments such as Always On, Traditional Failover Clustering (Windows Server Failover Cluster - WTFC), Database Mirroring, Replication such as transactional replication and Log Shipping to make sure the databases are always available and participating in disaster recovery.
Troubleshooting and resolving database integrity issues, performance issues, blocking and deadlock issues, updating statistics for query optimization using performance and activity monitor, event viewers, extended events.
Managing and providing end to end support and problem resolution for SQL Server databases through multiple product lifecycle environments, such as development, testing to mission-critical production systems.
Create and update database documentation about company standard procedures, technology features and production issue troubleshooting.
Analyze, solve and correct issues in real time and provide end-to-end problem resolution such as hardware and software purchases, server configuration changes and assisting developers with query/index tuning, Partitioning, compression and updating statistics to enhance speed and maximize system performance.
Creating and monitoring maintenance plans and agent jobs that automates backups and reorganize/rebuild indexes for query performance.
Hands-on database tuning and troubleshooting of SQL Server service outages as they occur, including providing On call support during after-hours and weekends. Providing scheduled maintenance, supporting application deployment, and hardware/software upgrades after hours and 24 x 7 support.
Review scripts submitted by the development team and Working with other teams like systems analysts, developers, business analysts, and project teams to perform the capacity planning required to create and maintain the Databases.
Control and establish appropriate database user access control levels by provisioning and deprovisioning users based upon company policy to control access for each segment of the Databases. Develop database security guidelines and perform audits.
Migrate SQL server databases from on prem to AZURE using Data Migration Assistant.
Develop and monitor system and application alerts to ensure Health monitoring and performance tuning
Create and maintain azure managed SQL instances and databases
JUNIOR MS SQL SERVER DBA
American Airlines
Fort Worth, TX
2015.05 - 2018.01
SQL Database Administrator, Database Programming.
resolve highly complex, technical, and escalate support incidents. troubleshoot and diagnosis issues in SQL Server environment.
Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.
Rebuilding indexes at regular intervals for better performance in large datasets
Designed and implemented comprehensive Backup plan and disaster recovery strategies.
Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.
Monitored and modified Performance using execution plans and Index tuning.
Deploying new code base release to UAT and Production Environments.
Perform SQL Server service pack and Windows Service pack upgrades.
Working with customers on Application rollouts and server migrations.
Extensively worked on Enterprise Manager for managing the database.
Troubleshoot performance problems and fine-tuning of databases.
Converting DTS packages into SQL Server 2005 Integration Services.
Migrating SQL Server 2000 data bases into SQL Server 2005.
MS SQL SERVER DBA
Texas Department Of Criminal Justice
Wichita Falls, TX
2018.02 - 2019.12
Manage infrastructure performance, data security and make recommendations for improvements
Manage infrastructure performance, data security and make recommendations for improvements
Assist in the monitoring and review of Strong analytical, planning, and organizational skills with ability to manage competing demands
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.
Planned and deployed monthly windows and SQL server patches.
Planning and implementation of Database backup/restore and disaster recovery
Create and work on High Availability (HA) and Disaster Recovery (DR) options for SQL Server
Writing basics TSQL scrips, stored procedures, functions and triggers, data transformations using BIDS
Implementation of snapshot isolation and DDL triggers
Migration of SQL Server 2005 servers to SQL Server 2008
Stable Replication Topology
Installed SQL Server 2008 on advanced servers, applied security fixes
SQL Server Upgrade
Performed Database Migration from an On-Premises SQL environment to Azure Database in the cloud
Installed and configured MS SQL Server 2008 R2, supported all Production and development servers
Maintained database response times in 24X7 Production environments
Developing SQL scripts for maintaining administration tasks
Capacity Planning and resource allocation
Monitoring standby databases to ensure high availability
Troubleshoot, resolve issues related to computer software and hardware controlling production equipment application
Production level support for onsite and offshore Clients
Support Patch Management
Integrated Temporal Tables
Education
M.D. - Chemical And Natural Gas Engineering
Texas A&M University - Kingsville
Kingsville, TX
12.2019
Bachelor of Science - Geology
University of Buea
Cameroon
12.2011
MS SQL SERVER DBA And TSQL
Empire Data System
Texas
12.2014
Skills
Microsoft SQL server 2005, 2012, 2014, 2016, 2017, 2019
Windows server 2008, 2012, 2012 r2, 2016, 2019
Microsoft office suite (Word, Excel, power point, office 365)
Windows Remote Desktop
Service manager
Service Now
Active directory
Windows (7,8,10)
Hyper-V, VMware Workstation
Solarwind
Jira
SQL Server Tools SSMS, Enterprise Manager, Profiler, Query Analyzer, Export & Import (DTS), SSIS, SSRS, SSASRDBMS MS SQL server 2005/2008/2012, MS Access, ETL DTS, SSIS
Work Availability
monday
tuesday
wednesday
thursday
friday
saturday
sunday
morning
afternoon
evening
swipe to browse
Quote
There is a powerful driving force inside every human being that, once unleashed, can make any vision, dream, or desire a reality.