Alain Njotu Ambeigwoh
Richmond,TX
Summary
SQL Server Database Administrator with extensive experience managing multiple SQL Server environments, ensuring optimal database performance, availability, and security. Expertise in high-availability setups, query optimization, and robust backup and recovery procedures. Proactive in enhancing database integrity and collaborating with teams to resolve issues and support development needs.
Overview
11
11
years of professional experience
1
1
Certification
Work History
SQL Server Database Administrator
AMCAX Inc
06.2022 - Current
- Manage multiple SQL Server environments, ensuring database availability, integrity and security for mission-critical applications.
- setup AlwaysOn Availability Groups and Failover Clustering for high-availability, to ensure database availability and access to users
- Optimized SQL queries, indexing and storage performance, to ensure optimal application response time.
- Enhanced backup and recovery procedures using database mirroring and log shipping, achieving a recovery time objective (RTO) of under 15 minutes.
- research and document scripts for automating routine maintenance tasks.
- Collaborated with developers to troubleshoot and resolve SQL query issues to improve user satisfaction
MS SQL Server Database Administrator
Catholic University of Cameroon
06.2016 - 10.2021
- Managed 16 SQL Server databases across development, testing and production environments
- Manage and monitor SQL Server databases to ensure optimal performance, availability and security.
- Developing and testing backup and recovery plans, maintaining database maintenance plans, performing backups and restores
- Troubleshoot, research and resolve computer software and hardware issues within the environment as well as error logs
- Creating and Modifying Tables, Stored Procedures, Views, Indexes, User-defined Functions and Triggers etc as requirement on SQL Server Environments.
- Research and recommend on new security policies, database encryption and role-based access controls to reduce unauthorized access incidents and strengthen security
- Patching/upgrading SQL server, setting up SQL server profiler, Extended Events, Query Store and Database Engine Tuning Advisor (DTA) to ensure optimum performance
- Coordinated with cross-functional teams to facilitate database migrations, upgrades and patching activities.
MSSQL Server Database Support
Better Planning Limited
02.2014 - 05.2016
- Use SQL Profiler to continuously assess performance, detect bottlenecks and take corrective actions as well as ensure databases are running smoothly
- Ensure scheduled jobs for indexing, statistics updates, integrity checks, backup (full, differential and transaction) and cleanup tasks are running smoothly
- Identify root causes for errors, service disruptions or connection issues and implement fixes to prevent recurrence.
- Assist in the development and maintenance of disaster recovery strategies including point-in-time recovery and log shipping and offsite backups
- Assign and manage user roles and permissions by implementing the principle of least privilege to secure data/database access.
- Assist in implementing and managing audit trails for compliance with data security and regulatory requirements (HIPAA)
- Assist in configuring encryption (Transparent Data Encryption) and other security measures to protect data at rest and in transit.
- Ensure severs are properly patched (both windows and SQL Server)
- Assist in planning and executing database migrations to newer SQL Server versions and newer hardwares.
- Regularly review and optimize indexes (reorganize and rebuild) to ensure optimum performance
- Maintain detailed documentation of database configurations, policies, backup schedules and disaster recovery steps.
- Provide necessary support to the development and QA teams for database design and query optimization setup.
Education
Bachelor of Science - Economics
University of Buea
Buea Cameroon07-2012
Skills
- Database Security
- Transparent Data Encryption
- Capacity Planning
- SQL Profiler
- Database Partitioning
- Query Optimization
- Index Maintenance
- Extended Events
- Performance Tuning
- AlwaysOn Availability Groups
- Database Auditing
- Backup and recovery
- Log Shipping
- Replication Management
- Dynamic Management Views
- Database mirroring
- Database Design
- Root Cause Analysis
- Data Migration
- Patch management
Certification
- Better Planning Introduction to SQL Server Database Administration
- Better Planning SQL Server Database Administration for Intermediate User
Languages
English
Native or Bilingual
French
Limited Working
Timeline
SQL Server Database Administrator
AMCAX Inc
06.2022 - Current
MS SQL Server Database Administrator
Catholic University of Cameroon
06.2016 - 10.2021
MSSQL Server Database Support
Better Planning Limited
02.2014 - 05.2016
Bachelor of Science - Economics
University of Buea
Similar Profiles
Joe Van Matre IIJoe Van Matre II
Pressure Washer at Absolute ServicesPressure Washer at Absolute Services
Renaldo ChristmasRenaldo Christmas
Principal Chemist at ChampionXPrincipal Chemist at ChampionX
Heather WallaceHeather Wallace
Purchasing Supervisor at GROTH CORPORATIONPurchasing Supervisor at GROTH CORPORATION