NGOUBE ELSI ATEH epse AGHA
Houston, Texas 806-***-**** ad2fy0@r.postjobfree.com
PROFILE
Proven success in deployment of effective IT roadmaps, processes, and procedures including setting up high availability and disaster recovery solutions in SQL such as Always on Availability Groups, Log Shipping, Mirroring, Replication, and Traditional Fail Over Clustering.
Excel at supporting mission-critical databases on both On-Premises and Azure with the highest efficiency.
Significant expertise in SQL Server Upgrade and Database Migration as well as Azure Databases, Elastic Pools, Managed Instance, and New Instances Installation.
Highly analytical and results-driven IT professional with over 5 years of working experience in SQL Server Database Administration and Microsoft Azure
Demonstrated history of successful execution of various processes including Disaster Recovery Solutions, Performance Tuning, and Monitoring. TECHNICAL PROFICIENCIES
MS SQL Server 2008-2019 PowerShell Security Backup and Restore Hyper-V VM Ware T-SQL IaaS SaaS PaaS Always on Availability Group Replication Log Shipping Failover clustering Azure SQL Databases Azure SQL Manage Instances SQL on Azure VMS Azure Database Migration Service
PROFESSIONAL EXPERIENCE
JoinIT Solutions February 2020 - Present
SQL SERVER DATABASE ADMINISTRATOR
Developed and updated tables, stored procedures, views, indexes, user-defined functions, and triggers in accordance with SQL Server Environments.
Completed tasks prior to deadline involving SQL installation and automation, setting up Azure SQL Databases, Manage Instances and SQL Azure VMs with site recovery, and backup to ensure optimal performance and disaster recovery of database.
Migrate databases to Azure SQL using Database Migration Service, Replication, backup and restore
Install and configure Microsoft SQL Server 2008 insert through 2019 following best practices.
Upgrade SQL server from SQL server 2008 to 2016 using both in-place and side-by-side upgrade.
Provide DBA support and technical expertise for multiple applications in Development, Test, QA, and Production environments and interacting with clients, application team and project managers to design, implement and support solutions to meet client needs.
Provide guidance and expertise for database Performance Tuning, Performance Baselining and Query Optimization using both SQL Server inbuilt and third-party tools (Query Store, Extended Event, SQL server Profiler, SQL Server turning Advisor.
Manage and develop long-term strategies for data storage and capacity planning.
Create and manage database backup and restore strategy following company’s SLA
Refresh databases in a Test, Dev Environment and manage users and permissions in active directory.
Set Up and manage Disaster Recovery and High Availability solution (Always-On Availability Groups (AG), Log Shipping and Database Mirroring, Traditional Failover Clustering, Replication).
Apply both SQL Server and Windows patches.
Upgrade and migrate databases from SQL Server 2008 to SQL Server 2016 using in-place and side-by-side migration as well as Backup and Restore, Detach and Attach.
Enhancing performance by creating table partition files and file groups, table compression.
Creating and managing logins and users following the principal of list privileges.
Creating and managing users in active directory.
Building and configuring VMs in Hyper-V environment.
Maintained and achieved high availability of database via coordinating with infrastructure teams to allocate system resources to database.
Migrating databases from On-prem to Azure (Azure SQL Database, Azure SQL manage instance and SQL on Azure VMs)
Install and configure SQL SERVER SSIS and SSRS Packages. Texas State Department of Health and HR Houston, Texas January 2017- January 2020 SQL SERVER DATABASE ADMINISTRATOR
Planning and Installation of Microsoft SQL Server, SQL Upgrade and Migration. Coordinate with vendors and end users to apply Windows and SQL Patches.
Define and implement Backup and Recovery strategies and Capacity planning per company Recovery Point Objective (RPO), Recovery Time objective (RTO) and SLA Retention policy.
Implement data security by creating users and assigning permissions per principle of least privilege.
Implement data security operations like Always Encrypted, Transparent Data Encryption (TDE) and Dynamic Data Masking (DDM) to secure client’s sensitive data.
Leverage in-built software in SSMS (SQL Server profiler, Performance monitor, Extended Events, DMVs, Database Integrity checks) to ensure database integrity, stability, system availability; and other Third-party software like IDERA and SolarWinds Database Performance Analyzer to monitor system health and security.
Configure High Availability (HA) and Disaster Recovery (DR) Solutions on productions systems using Clustering - Always On, Traditional Failover Clustering (Windows Server Failover Cluster - WSFC), Database Mirroring, Replication such as peer-to-peer replication, merger replication and transactional replication and Log Shipping.
Provide 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.
Creating and monitoring maintenance plans and agent jobs that take backups and defragment indexes for query performance.
Troubleshooting of SQL Server service outages as they occur, including providing on call support during after-hours and weekends.
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. Develops database security guidelines and performs audits Nestle Arlington, Virginia January 2016 - January 2017 JUNIOR SQL SERVER DATABASE ADMINISTRATOR
Drive end to end availability, performance monitoring, and capacity planning of Microsoft SQL architecture
Support SQL Server and Application environments.
Handle multiple projects and deadlines in a fast-paced environment independently.
Troubleshoot database performance issues and help to ensure security and compliance across all database systems.
Perform day to day administration and Database Maintenance.
Monitor and optimize SQL Server performance through hardware upgrades, server configuration changes, or index/query changes.
Collaborate with architecture and development teams in providing design recommendations.
Create Production and Operations readiness plans and documents. NFC Bank Cameroon February 2015 - December 2015
PROJECT MANAGER II
Works with plant and corporate staffs to generate short-term and long-term projects for end-of-life equipment to improve plant up time, cost reduction, safety, and environmental compliance according to ASME and B31.3 complaint standards
Overseeing the Management of Change (MOC) process for fixed equipment and capital projects by providing complex analysis, design, and specification and cost estimates to ensure projects are done right the first time by engaging all involved personnel throughout the process
Managing multi-million-dollar projects and multiple contractors with the submission of bids, obtain pre-qualifications and insurance, contractor orientations, onsite inspections, monthly safety meetings
Work with plant's inspection contractors to ensure appropriate inspection technologies are used and provide I.T assistance to maintenance and operations during troubleshooting and evaluation of equipment failures
Maintain and improve financial integrity and fixed equipment reliability programs by supervising plant mechanical, electrical and contract technicians including predictive, preventative, and reactive maintenance.
Recommend changes to inspection frequencies and manage CMMS database for work order flow, PM optimization, welding, and repairs, planning and scheduling, skill and development training matrices and continuous improvement. EDUCATION AND CERTIFICATIONS
Bachelor’s Degree in Business Management and Computer Science. MTA: Microsoft Technology Associate (98-364 - SQL Server Database Fundamentals) Microsoft Azure AZ 900
BILINGUAL: English, Chinese, and French (Read/Write/speak)