Romeo Mambel
Houston,TX
Summary
Certified SQL Database Administrator/ Azure Engineer with over 8 years of experience managing SQL Server production Databases and leveraging tools like PowerShell, Terraform, automation accounts to Orchestrate workflows for system development life circle and maintenance which ensure smooth business operations, reliant architecture and highly scalable elastic applications. Highly skilled at database maintenance, performance tuning and Optimizations; On-Prem to Cloud Migration, High Availability and Disaster Recovery Solutions. Proven ability in database design, implementation, optimization, and maintenance to ensure optimal performance and reliability. Expertise includes implementing high availability and disaster recovery solutions, enhancing security measures, and leveraging Azure services such as SQL Database and Managed Instance for scalable and efficient operations. Passionate contributor to team success with records of empowering teams. A self-starter who is always motivated to learn, grow, and stay current.
Overview
9
9
years of professional experience
1
1
Certification
Work History
Sr SQL DBA
Bealls, Inc
06.2021 - Current
- Created a secure and compliant multi-region database deployment on Azure, ensuring 100% alignment with data sovereignty requirements
- Streamlined data processing workflows with Azure Functions, reducing batch processing windows by 25% for critical nightly jobs
- Enabled business continuity during critical migrations by establishing seamless data replication across azure regions, ensuring zero downtime
- Implemented high availability and disaster recovery strategies such as Failover Groups and Active Geo-replication, ensuring uninterrupted access to critical data and applications
- Produced high-standard database solutions that met stability, reliability, and performance metrics, leading to an improved system performance and user satisfaction
- Migration of on-premises SQL databases to Azure SQL Database, reducing operational costs by 30% and improving scalability
- Spearheaded application migration from on Prem to Azure VM’s leveraging Azure data Studio and DMS for database discovery assessment and online migration
- Designed a hybrid solution to offload read only workload to Azure SQL managed instance from SQL server 2022 using managed instance link feature
- Successfully performed database upgrades and migrations, applying SQL best practices, and minimizing disruption to business operations
- Proactively anticipated and responded to technological innovations related to SQL Server and relational databases, ensuring the adoption of the latest tools and practices
- Designed Azure solutions leveraging Azure Terraform Infrastructure as code (IaC) and Azure ARM templates for recurring deployments
- Validate migrated databases to ensure functionality, performance, and data integrity
- Collaborate on database design and optimization to support efficient data access and manipulation
- Monitored all databases to optimize database performance, resource utilization, and physical implementation, resulting in improvement in query response times
- Addressed a variety of database integration issues, including migration between disparate databases, integration challenges, maintenance/conversion tasks, capacity planning, and support for new applications
- Conducted research and prepared recommendations for database tools, software, and hardware requirements, ensuring the use of cutting-edge technologies to enhance database capabilities
- Achieved significant cost savings exceeding $50,000 by strategically transitioning development servers from Enterprise editions to SQL Server Developer edition, effectively reducing licensing expenses
- Successfully initiated the development of a comprehensive Service Level Agreement (SLA) and educated senior management on its pivotal role in shaping business strategies
- Received recognition for leading a successful lifecycle management project, overseeing the seamless migration of over 200 SQL databases from SQL Server 2008 to SQL Server 2017
- Proactively addressed diverse database integration issues, including migration between disparate databases, integration challenges, maintenance/conversion tasks, capacity planning, and support for new applications
- Diligent monitoring of all databases to optimize performance, resource utilization, and physical implementation, resulting in noticeable improvements in query response times
- Managed Azure resources by creating Billing Alerts and Monitoring to Reduce Cost of operations
- Lead Migration Projects of entire database estate from On-premises to Azure Platform leveraging tools like DMA, DMS Azure Data Studio, Managed Instance Link Feature as well as Azure Calculator.
SQL DBA II
IHEART MEDIA
03.2018 - 05.2021
- Managed portfolio of SQL Server databases across development, test, and production environments, ensuring optimal performance and reliability
- Implemented SQL Server AlwaysOn Availability Groups for high availability and disaster recovery, reducing downtime and data loss during failover events
- Conducted routine database maintenance tasks, including backups, index maintenance, and database integrity checks, to ensure data integrity and availability
- Troubleshot and resolved database-related issues, such as performance bottlenecks, connectivity problems, and data corruption, in timely manner
- Implemented database security measures, such as logins, users, permissions, and auditing, to protect sensitive data and comply with regulatory requirements
- Documented database configurations, procedures, and best practices, facilitating knowledge sharing and onboarding of new team members
- Collaborated with cross-functional teams to support application development, testing, and deployment activities, ensuring seamless integration with database systems
- Evaluated and recommended new tools and technologies to improve database performance, scalability, and security posture
- Managed and operated large scale production database systems across multiple Azure regions
- Provide direct operational support across all areas of production database infrastructure including high availability, database replication, release management and disaster planning
- Install, configure, and deploy MS SQL Server using automation and infrastructure as code
- Monitored, disaster recovery, backup and recovery, high availability
- Capacity planning to predict data growth trends and proactively tune infrastructure to accommodate growth.
SQL DBA II
HHSC
10.2015 - 02.2018
- Collaborated with development teams to optimize SQL queries, improving application performance and user experience
- Implemented automated backup and recovery strategies, reducing data loss risks, and enhancing disaster recovery capabilities
- Conducted regular database health checks, identifying, and addressing potential issues before impact production systems
- Designed and maintained database security policies, ensuring compliance with industry standards and regulations
- Created and maintained documentation for database configurations, procedures, and troubleshooting guides
- Assisted in database upgrades and migrations, ensuring minimal downtime and data integrity
- Provide day-to-day operational ownership for assigned databases, including patching, upgrading, configuration management, database backups, continuous monitoring, and performance management
- Develop, implement, and document standards, procedures, and controls for architectural design, build/configuration, and operation of databases
- Ensure security, reliability, and availability of databases
- Maintain the security posture for databases in accordance with industry best practices and ITS Chief Information Security Officer and Identity & Access Management policies and procedures
- Provide automated solutions that increase throughput and decrease operational expenses for the deployment and operation of databases.
Education
Bachelor's Degree - Computer Sciences and Information Technologies
University of Science And Technology
Nanjing China09.2016
Skills
- SQL installation both stand-alone and clustered
- SQL server Versions, 2012, 2014, 2016, 2019 and 2022 Enterprise and Standard
- Transparent data encryption, always encrypted and Dynamic Data masking Securities
- Failover Cluster instances with Active-Active or Active-Passive Configurations
- Server Virtualization with Hyper-V or VMWare
- Creating Tables, Views, Triggers, Cursors, Dynamic Stored Procedures
- SQL Server Replication, Backup/Recovery, Disaster recovery and planning
- High Availability and Disaster Recovery solutions (Always-On Availability Groups, Log Shipping, Replication, and database Mirroring)
- Team player with positive can-do attitude
- Working closely with team of Software Engineers
- Virtual machines, virtual network, azure storage, Azure active directories, Azure Subscriptions, Azure polices, Azure DNS, Azure Load Balancer and Autoscaling
- Azure Virtual network, Network Security Groups (vnet, vnet Peering, Route table, vnet to vnet connection, Jump Box)
- Azure Resource Management, deploying resources in IAAS, PASS and SAAS
- Azure SQL Managed Instance, Azure SQL database, elastic pools, DTU and vcores
- Azure EntraID, Entra connect, Azure Storage accounts, Key Vaults, Policies and Managed Identities
- Azure BCDR, Active Geo-replication, Failover Groups, Azure Site Recovery, Storage Redundancies
- Migrations to Azure using Shift and Lift to IAAS and PAAS using Azure data studio and DMS
- Azure Vnet peering, Azure NSG, Public and Private endpoints, Application Gateways and Load Balancers
- Designed and configured Azure Arc-enabled services to consolidate servers and other applications to a single dashboard
- Index Optimization and statistics Update for increase database Performance
- ETL: SQL Server Integration Services (SSIS), Azure Data Factory
- Reporting: SQL Server Reporting Services (SSRS), Power BI
- Designing and managing other databases like MongoDB, NoSQL
- Experience within software development Life Cycle using Agile methodology
Certification
- Microsoft Certified Azure Administrator Associate
- Microsoft Certified Azure Solution Architect Expert
Timeline
Sr SQL DBA
Bealls, Inc
06.2021 - Current
SQL DBA II
IHEART MEDIA
03.2018 - 05.2021
SQL DBA II
HHSC
10.2015 - 02.2018
Bachelor's Degree - Computer Sciences and Information Technologies
University of Science And Technology
- Microsoft Certified Azure Administrator Associate
- Microsoft Certified Azure Solution Architect Expert
Similar Profiles
Linda KeaneLinda Keane
Associate at Bealls, IncAssociate at Bealls, Inc
Connor DayConnor Day
Induction at Bealls Inc.Induction at Bealls Inc.
Shena CarpenterShena Carpenter
Supervisor at Bealls StoreSupervisor at Bealls Store