Sonnie Avenbuan
Springfield, Queens,NY
Summary
Summary/Technical skills
Experienced IT professional with over 19 years’ experience delivering exceptional level high-quality IT service in Database management, Data Engineering, DevOps engineering, and Site Reliability Engineering (SRE). delivering high-quality IT services and solutions. Specializes in building and managing scalable, secure AWS infrastructure with a solid background in database optimization, data engineering, and pipeline development..
Overview
21
21
years of professional experience
Work History
Senior DevOps Engineer / Data Management
MIO Partners
, NY
10.2018 - Current
- Applied DevOps principles to database environments, ensuring continuous integration and deployment
- Developed and maintained a secure, scalable AWS infrastructure, leveraging services such as EC2, RDS, S3, IAM, and Lambda to support high-availability applications
- Maintained scalable, secure platforms supporting software applications, integrating databases and CI/CD pipelines
- Led observability initiatives, implementing Grafana, Prometheus, and AWS CloudWatch for monitoring and alerting, resulting in a 30% reduction in mean time to recovery (MTTR)
- Collaborate with cross-functional teams to influence architectural decisions and drive technical excellence
- Streamlined database deployments with GitLab CI/CD and Liquibase, ensuring efficient schema migrations
- Utilized Infrastructure-as-Code tools (Terraform, AWS CDK) to automate provisioning, collaborating with teams to enforce IaC best practices, reducing setup time and minimizing configuration errors
- Architected and optimized CI/CD pipelines using Jenkins, GitLab CI/CD, and AWS CodePipeline, reducing deployment times and improving code quality
- Automated database provisioning, scaling, backups, and recovery using Terraform and CloudFormation
- Lead and participated in migrating data store solution from an on premise to Azure for application and database ecosystem
- Enhanced database performance through query optimization, indexing, and storage configuration
- Diagnose and resolve complex database issues, including performance problems and data corruption and system failures
- Managed 100% of existing AWS Cloud environments, automation, monitoring metrics, disaster recovery/backups and capacity planning.
Lead Database Engineer/DBA Manager
Honeywell International
09.2011 - 09.2018
- Automated Control And Security(ACS, Develop and design database strategies, monitor and improve database performance and capacity, plan for future expansion requirements
- Deliver data-management vision, goals, priorities, design principles and operating policies
- Streamlined the end of month billing reporting and daily report delivery to customers from over 6 hours to 30 minutes by spearheading BI and ETL development initiatives and production reports using homegrown ETL application and automating SQL Server Integrating services(SSIS) and SQL Server Reporting Services(SSRS)
- Developed and tested storage strategies and disaster-recovery plan for Honeywell's operational database, delivering solution that guaranteed recovery performance and high availability using SQL Server 2016 Always on technology
- Lead and participated in migrating data store solution from an on premise to Azure for application and database ecosystem
- Effectively managed, Supervise and mentor a team of 3-5 DBAs locally and offshore supporting Microsoft SQL Server
- Install and Maintain MongoDB instances and infrastructure for a massive, high-throughput transactional system
- Configure, monitor and Troubleshoot performance optimization in numerous MongoDB instances and replica set
- Continuously work with Vendors Technical support ,Professional services in resolving high severity issues
- Lead in performing computer risk management recovery planning coordination with company technology groups in support of specific business unit current, in plan, and new initiatives, with a major focus on proactively assuring adequate recovery network and processing environment, as well as accurate, predictive budgeting
- Recommending infrastructure enhancements/changes to improve existing products/services and/or reduce internal costs and Prioritization of incident reports and key follow-up items
- Creation/set-up of application-specific database objects and subsequent maintenance through proper change management procedures on all dedicated and Share SQL Servers environment
- Design, deploy, and support highly available and scalable distributed Cassandra DB solutions for high volume applications.
Lead Database Administrator
National benefit Funds
, NY
05.2007 - 09.2011
- Provide 24X7 on-call database administration support including database administration functions for all SQL Server and Oracle database instances hosted on Windows 2003/2008 R2 platforms
- Lead effort in design and implementing standard operating policies (SOP) and technical installation plan (TIP) for all databases related projects to ensure compliance, security and integrity of enterprise databases
- Develop strategy and approaches and implement the full life cycle of the Identity and Access Management (IAM) program as part of the Information
- Architect and oversee database security, roles, user-role assignments, and individual logins per company security policies and procedures
- Provide technical leadership to the DBA team by assisting team members and sharing knowledge and research of tools/techniques, and Oracle features
- Ensured adherence to key regulatory demands through design and deployment of SOX- and HIPAA-compliant database security structure - audited and resolved all issues within 3 months.
Datawarehouse Lead Architect/DBA
06.2003 - 07.2007
- Participates in the design, implementation, documentation and future planning of ETL and design development using SQL 2000 DTS Services and SQL Server 2005 Integration Services (SSIS)
- Designs, implements and supports Data Warehouse
- Demonstrate a detailed knowledge and understanding of all Data Warehousing aspects including design, ETL, DTS, modeling, OLAP, Data Marts, and Database Administration
- Participates in the creation and implementation of Data Warehousing development standards OLAP design/implementation and meta data implementations
- Provide feedback to Continuous Quality Improvement (CQI) on the design and build processes.
Lead Database Administrator
NCS – Johnson
, NJ
08.2006 - 05.2007
- Provide 24X7 on call support in a production environment
- Participate in the project management tasks towards the successful delivery of key database upgrades and projects, project cost estimation and Contributing in capacity and scalability planning for new initiatives
- Recommending infrastructure enhancements/changes to improve existing products/services and/or reduce internal costs and Prioritization of incident reports and key follow-up items
- Lead role in installation, configuration, maintenance including upgrades and patch management, security administration, implementation of backup and recovery policies, performance tuning, capacity planning and monitoring of the existing and proposed SQL Server environment
- Ensure regional regulatory compliance for the company-controlled components that require FDA and HIPAA-compliant.
Consultant
Xerox Global Services
Rochester, NY
Education
MSIA -
Davenport University
08.2013
Bachelor of Science - Computer Science
York University
09.1997
Master of Science - Information Assurance/Security
Skills
- Skills include:
- Databases: MSSQL Server, Oracle, MySQL, PostgreSQL, NoSQL, Redis, Memory DB
- Performance Tuning & Capacity Monitoring
- CI/CD pipeline development and maintenance
- DevOps Tools: Jenkins, GitLab CI/CD, AWS CodePipeline
- Automation & Scripting: Python, PowerShell, Ansible, Terraform, AWS CDK
- Planning, Configuring, installing SQL Server Clustering (Active/Passive)
- Cloud computing platforms (AWS, Azure)
- Version Control: Git, Bitbucket, AWS CodeCommit
- Tools: Liquibase, Active Batch, SQL Sentry, Foglight, Litespeed
- Participate in DR planning and implementation including data Domain and Recovery point
Accomplishments
- Certifications:
- Microsoft Certified Solutions Expert (MCSE-SQL 2012/2019)
- AWS Certified Cloud Practitioner
- Microsoft Certified: Azure Fundamentals
- Microsoft Certified: Azure Data Fundamentals
- ITIL Foundation Certification.
Timeline
Senior DevOps Engineer / Data Management
MIO Partners
10.2018 - Current
Lead Database Engineer/DBA Manager
Honeywell International
09.2011 - 09.2018
Lead Database Administrator
National benefit Funds
05.2007 - 09.2011
Lead Database Administrator
NCS – Johnson
08.2006 - 05.2007
Datawarehouse Lead Architect/DBA
06.2003 - 07.2007
Consultant
Xerox Global Services
MSIA -
Davenport University
Bachelor of Science - Computer Science
York University
Master of Science - Information Assurance/Security
Similar Profiles
Hannah SpillmanHannah Spillman
Waitress at Mio SognoWaitress at Mio Sogno
Johan DazaJohan Daza
Server at Fonda Dulce Jesus MioServer at Fonda Dulce Jesus Mio
Laureen TsenuokporLaureen Tsenuokpor
Ambassador for Mental Health Awareness at Make It OK (MIO)Ambassador for Mental Health Awareness at Make It OK (MIO)
Kael MichelKael Michel
Office Support at A1 Works-in-Progress Associates, LLC.Office Support at A1 Works-in-Progress Associates, LLC.
FRANEMICAH BRAITHWAITEFRANEMICAH BRAITHWAITE
Fleet Service Agent at American AirlinesFleet Service Agent at American Airlines