PATRICK TCHATCHOUA MBADA
Houston
Summary
Experienced IT professional working for almost 10 years in the IT field. My knowledge and experience include:
- SQL Database administrator (DBA) with about 10 years of production support experience in designing, testing and supporting next-generation database solutions in SQL Server environments (SQL server installation, implementation & migration - performance running & capacity monitoring - backup & recovery - failover cluster & alwaysON - Database maintenance - ETL- SSRS - SSAS - SSIS).
- Linux Systems Administrator with about6 years of experience in troubleshooting network issues - Docker Containers Deployments - Web Apps (Jenkins, Sonarqube, Nginx) deployment- Linux servers inventory (Redhat, Centos, Ubuntu, Kali, Debian) - Files & Directories Permissions - Managing Users & Groups - Automating Jobs Using Crontab).
- AWS Cloud Systems Administrator with about 6 years of experience in VPC Configuration - top tier applications deployment- EC2 Instances configuration - Managing the complete AWS life cycle, along with security, provisioning & automation - Creating backups & managing disaster recovery - Maintaining access control, as well as the integrity of data, throughout the platform of the AWS application.
- DevOps Engineer & Site reliability Engineer with about5 years of experience in CI/CD pipelines creation, maintenance and Configuration - works with developers and the IT staff to oversee the code releases, combining an understanding of both engineering and coding. From creating and implementing systems software to analyzing data to improve existing ones - Ensuring that systems are safe and secure against cyber security threats.
Overview
12
12
years of professional experience
Work History
DevOps & Linux Engineer
4patriots
09.2022 - Current
- Monitored automated build and continuous software integration process to drive build/release failure resolution.
- Worked with cross-functional design teams to create software solutions that improved overall functionality and performance.
- Directed software design and development to meet client needs for functionality and performance.
- Reduced downtime and improved system reliability by monitoring server health, diagnosing issues, and performing timely maintenance.
- Collaborated with team to determine application requirement specifications.
- Created secure custom coding to prevent network threats.
- Using ANSIBLE to simultaneously configure many servers.
- Increased security levels by conducting vulnerability assessments and implementing necessary patches on Linux servers.
- Wrote and maintained custom scripts to increase system efficiency and performance time.
- Contributed to cost savings efforts by identifying opportunities for infrastructure optimization and resource consolidation in a Linux environment.
- Oversaw development and maintenance of organization computer systems and intranet.
DevOps & Site Reliability Engineer
Flexsteel
08.2019 - 08.2022
- Responsible for implementing and supporting the CI/CD pipeline processes and database infrastructure of about 20 production servers running MySQL instances & managing Linux servers Centos, Redhat, Ubuntu
- Develop and create stored procedures, advanced queries, triggers, views, indexes, and functions for databases
- Using tools like Jenkins, Sonarqube, JFrog, ECR and GitHub to automate a continuous integration process
- Working with software developers and software engineers to ensure that development follows established processes and works as intended
- Resolving daily basis Jira stories, Provisioning different infrastructures using IAC (TERRAFORM or CLOUDFORMATION) Manage products and development databases including performance tuning, capacity planning, SQL
- Server clustering, database security configuration, and database continuity
- Integrating MySQL plugins to datadog to start monitoring slow running queries
- Developed custom scripts/tools as needed to automate routine tasks, increasing overall team productivity and efficiency.
- Granting and Revoking access to different software (datadog, newrelic, github, awes, etc...)
- Optimized system and application performance using techniques like shutdown, reboot, start and stop services and tools to identify performance issues and solutions Expertise in using DBCC trace flags, handling blocking and deadlock situations
- Examine capability of the software to expand as users save data to it Provides trend analysis to service management team to enable them make informed decisions regarding resource management
- Creating new Jira ticketing system especially for various requests of Ops team
- Planning out projects and being involved in project management decisions
- Keeping all code changes into single system so that it can be modified and tested Setup the yum repository in server, upgrade repository by appropriate patching and installing software packages and services using yum and rpm as required
- Extensively worked on troubleshooting and ne-tuning of databases for performance
- Responsible for security and non-security patches based on company approved maintenance schedules
- Query optimization and improving overall performance, deploy updates and fixes Performed day to day Linux administration tasks such as user account management, directory services, le system sharing and permissions
- Develop and maintain cooperative and collaborative relationships with networking, storage, software development, and project management teams Work with software developers and Quality Assurance to seamlessly migrate applications from development to QA and production.
- Produced and maintained technical documentation for project reference.
AWS System & Database Administrator
Allied Universal Security Services, Systems And Solutions
06.2017 - 07.2019
- Providing production support to leading computer and tech support company for multiple clients across country
- Helping client with creating and deploying stable database infrastructure, carefully learning metrics and monitoring health or use of AWS resources on full scale by leveraging Amazon CloudWatch
- Provisioning various AWS environments (dev, staging, prod...) according to business needs
- Keeping sensitive information like user logins and API keys in Secrets manager
- Create and implement best backup and recovery strategies based on business requirements
- Improve Server performance and SQL server optimization
- Creation and management of VPC, C2S access points, Bastion Hosts, and URL proxies Troubleshoot performance-tuning issues by running SQL server Profiler, creating traces and running these traces in SQL Server Database Engine Tuning Advisor and analyzing reports
- Analyze poor performing queries and tune the same to using execution plan to optimize application and database performance, Approve Images For Use As Catalog Items Implemented smart index maintenance process; re-organizing and rebuilding indexes based on volume of fragmentation, configuration and ne-tuning of cloud infrastructure systems Monitoring CPU usage, IO statistics, Memory Usage to identify any OS level performance killers, enabling database level trace for performance tests
- Planning & Implementing High Availability & Disaster Recovery with minimal downtime
- Designing process flows & creating templates for each and every service used and provided.
- Implemented security measures to protect vital business data.
- Ensured database security with implementation of role-based access control and regular vulnerability assessments.
- Increased efficiency in software development processes through effective collaboration with developers to design databases that support application requirements.
Assistant Database Administrator
ICT
02.2014 - 05.2016
- Provide support for entire database environment: PROD, UAT, QA, TEST, and DEV
- Create new database logins and users as required
- Applying necessary SQL Server database patches and installing service packs
- Worked as part of 24x7 on-call support for Production Databases
- Troubleshoot disk, network, memory, and CPU related performance issues on high volume OLTP servers
- Setup Always On Availability Groups for SQL Server 2014 databases
- Designed backup and recovery strategies for SQL Server databases to meet customer SLA requirements
- Responsible for driving consolidation and upgrade efforts of all database systems into SQL
- Server2014
- Performing frequent health checks for all backups and mission-critical production databases Creating and analyzing daily reports for mission-critical databases
- Monitoring of servers using SQL Sentry third party tools that extends across all platforms and data centers
- Revise and improve current monitoring strategies for entire database enterprise
- Standardize processes for DB team by creating documentation for installations, migrations, upgrades, backups, restores, index maintenance
- Revise current DR and HA strategies and improving them, thereby reducing downtime in event of any failure
- Ensured availability of instance and databases via clustering and mirroring
- Create reports that run daily for jobs running in SQL Server Agent
- Junior SQL Server
Junior Database Administrator
Sigma Data Systems
09.2012 - 01.2014
- Responsible for Backups and Restores
- Involved in installation, configuration and upgrading
- Involved in migration from physical to VM servers
- Resolving slow queries issues
- Monitoring different servers
- Granting and revoking access.
Education
Bachelor of Science - Computer Science
Ankara University
Ankara, TurkeyHigh School Diploma -
The Conquest High School
Douala, CameroonSkills
- IT solution development
- Project planning
- Meeting participation
- Maintenance and troubleshooting
- Engineering standards
- Web-based software engineering
- Testing and maintenance
- Software applications
- Code reviews
- Solutions deployment
- Virtualization
- Agile
- Git Version Control
- Configuration Management
- Requirements Analysis
- System Troubleshooting
- Critical Thinking
- Backup and recovery
- GitHub Management
- Linux Security
- IT infrastructure proficiency
- Load Balancing
- Cloud services
- Docker Containers
Affiliations
- HAFCOMI (Houston African Community Impact): Board of Directors
REFERENCES
1) Ariel Nzongang, Sr DevOps Engineer at Data Service Group (346) 302-9851 kamgang71@gmail.com
2) Dimitri Nde Fotsing, Azure DevOps Engineer at GEICO (832) 582-9880 Ndefotsingdimitri3@gmail.com
3) Clarisse Kaneza, Sr Devops Engineer at Data Service Group (614) 599-6610 kaneza.clara@gmail.com
4) Joel Mbanya, Mechanical Engineer at Lockheed Martins (832) 955-5376 Joelmbanya@gmail.com
Timeline
DevOps & Linux Engineer
4patriots
09.2022 - Current
DevOps & Site Reliability Engineer
Flexsteel
08.2019 - 08.2022
AWS System & Database Administrator
Allied Universal Security Services, Systems And Solutions
06.2017 - 07.2019
Assistant Database Administrator
ICT
02.2014 - 05.2016
Junior Database Administrator
Sigma Data Systems
09.2012 - 01.2014
Bachelor of Science - Computer Science
Ankara University
High School Diploma -
The Conquest High School
Similar Profiles
Cara RoachCara Roach
Customer Service Advocate and QA Specialist at 4patriotsCustomer Service Advocate and QA Specialist at 4patriots
ANGELIQUE HAREANGELIQUE HARE
Team Lead at 4PatriotsTeam Lead at 4Patriots
Elizabeth CoteElizabeth Cote
Customer Service Phone Supervisor at 4PatriotsCustomer Service Phone Supervisor at 4Patriots