Mercy Mafontseh

• Proactively recommend and evaluate new database technologies, DBMS tools and utilities, and database server and storage hardware to optimize database performance and scalability.
• Work closely with software design and development teams to build database schemas, tables, procedures, and views that aligned with project requirements.
• Experience and Expertise in Implementing PCI DSS requirements and Security Measures to Ensure Cardholder Data Protection.
  
• Successfully implement and oversee database backup and recovery plans, replication, and high availability architectures, ensuring critical data is always secure and available.
• Manage workload independently but collaborate with colleagues to complete larger scale tasks in distributed team environment.
• Saved the company over 100 thousand dollars in hardware and licensing costs annually through cost saving measures such as virtualization of physical servers, optimal allocation of CPU and usage of SQL Server enterprise edition only when it is necessary.
• Sustain a 24/7 on-call rotation to provide critical support for database-related issues,resolving high-priority situations in a timely and efficient manner.
• Developing and upholding extensive documentation surrounding database configurations and operational procedures.
• Generating recurring reports to assess the performance and overall health of databases.

• Led DBMS upgrade and patch implementations, collaborating with system administrators for hardware and software installations and configurations.
• Planned and Implemented High Availability and Disaster Recovery solutions such as distributed AlwaysOn Availability groups using multi-data center best practices
• Provided incident support, analysis services, and support organizations as necessary to resolve user impacting issues
• Managed all aspects of Azure database instances, storage, and support day-to-day operations and management of an enterprise-level testing, development, staging and production database management systems
• Build and deploy SSIS packages and SSRS reports
• Completed complex upgrade/migration project from MS SQL Server 2012/2014 to MS SQL Server 2016, and 2019 as well as Migration from on-prem SQL Server to Azure SQL
• Investigate, analyze, implement, troubleshoot, and resolve system performance issues

• Installed and configured middleware in Linux and Windows environments.
• Wrote and maintained technical and functional specifications to document database intentions and requirements.
• Implemented BI solution framework for business intelligence projects.

Configure and perform SQL backups using both native as well as third party tools such as Rubrik, Avamar, NetBackup, Commvault to maintain RTO and RPO targets.

• Worked with tool suites such as I3, Redgate, and SolarWinds to monitor and troubleshot performance issues.
• Designed proactive preventive maintenance schedules to prevent unnecessary downtime and hardware faults
• Collaborate with cross-functional teams to integrate SQL Server with Active Directory for centralized authentication and enhanced security.