Close Menu

About

This post is also available in: Português (Portuguese (Brazil))

Hi, I’m Henrique Soares da Silva, and I created ExecuteStep to share practical database administration knowledge, tested solutions, and real-world experience from over a decade of working with mission-critical database environments.

Who I Am

I’m a Database Administrator based in São Paulo, Brazil, with 11+ years of professional experience managing complex database infrastructures across Oracle, MongoDB, PostgreSQL, MySQL, SQL Server, and Teradata environments.

My Technical Background

I specialize in:

  • Oracle Database: 10g, 11g, 12c, and 19c across single-instance and RAC architectures, including traditional and multitenant configurations
  • High Availability Solutions: Data Guard, Oracle RAC, Golden Gate, and disaster recovery implementations
  • Performance Tuning: Database optimization, query analysis, and bottleneck identification using AWR, ASH, Statspack, and Enterprise Manager
  • Multi-Platform Administration: Oracle, MongoDB, PostgreSQL, MySQL, SQL Server, and Teradata in production environments
  • Automation & Infrastructure as Code: Python, Ansible, Terraform, and Shell scripting for process automation
  • Cloud Technologies: Hands-on experience with AWS, Azure, GCP, and Oracle Cloud Infrastructure

Professional Journey

  • Managed 24/7 mission-critical database environments in telecommunications, retail, and financial services
  • Implemented high-availability architectures using Data Guard, RAC, and Golden Gate
  • Led database migrations, version upgrades, and infrastructure optimization projects
  • Developed automation solutions that reduced manual intervention and improved operational reliability
  • Mentored team members through hands-on problem-solving and knowledge base documentation

Certifications & Continuous Learning

I believe in continuous professional development. My certifications include:

  • Oracle: Database 11g Administrator Certified Professional, RAC 11g and Grid Infrastructure Expert, OCI Foundations (2024), OCI Data Foundations (2024), OCI AI Foundations (2024)
  • MongoDB: Associate Atlas Administrator, Associate Database Administrator
  • MySQL: Implementation Certified Associate (2025)
  • Cloud: AWS Certified Cloud Practitioner, plus hands-on experience with Azure, GCP, and OCI
  • DevOps: GitLab Certified Associate

Beyond certifications, I’ve completed extensive training in Exadata, Ansible, Terraform, Docker, Kubernetes, PostgreSQL high availability, and database performance tuning across multiple platforms.

Why I Created ExecuteStep

Throughout my career, I’ve encountered countless database challenges — from midnight production outages to complex performance issues requiring deep troubleshooting. Each problem solved became a lesson learned.

I started documenting these solutions internally for my teams, creating tutorials and knowledge base articles that helped junior DBAs understand not just what to do, but why and how. The feedback was overwhelmingly positive: clear, step-by-step guidance made complex problems manageable.

ExecuteStep is the public extension of that practice. The name reflects my approach:

  • Execute: Every tutorial contains actionable commands and scripts you can use
  • Step by Step: Complex procedures are broken down into clear, sequential steps

My goal is simple: help database administrators solve problems efficiently, learn new technologies, and avoid the pitfalls I’ve encountered over the years.

What You’ll Find Here

ExecuteStep covers the technologies I work with daily and the challenges I’ve faced in production environments:

  • Oracle Database: Administration, RAC, Data Guard, ASM, RMAN, performance tuning, and troubleshooting
  • PostgreSQL: Configuration, replication, high availability, and optimization
  • MongoDB: On-premise and Atlas administration, replica sets, and performance
  • MySQL & SQL Server: Administration, migration, and best practices
  • Linux Administration: Server management, automation, and infrastructure optimization
  • Automation: Python scripts, Ansible playbooks, Terraform modules, and Shell automation
  • Performance Tuning: Cross-platform optimization strategies and diagnostic techniques
  • Troubleshooting: Real-world problem-solving and root cause analysis

My Content Philosophy

Tested in Production (or Lab)

Every script and procedure published here is based on real experience. If I share a solution, it’s because I’ve used it successfully (or learned from using it unsuccessfully and adjusted accordingly).

Practical Over Theoretical

While understanding theory is important, ExecuteStep focuses on how to actually do things. You’ll find working examples, real commands, and procedures you can adapt to your environment.

Honest About Risks

Database administration involves risk. When commands are dangerous, procedures are complex, or results are unpredictable, I say so upfront. Transparency about potential issues is more valuable than pretending everything is simple.

Learning Through Doing

The best way to learn database administration is by doing it — but with guidance. ExecuteStep provides that guidance, walking you through procedures step by step with explanations of what each command does and why.

AI-Assisted Content Creation

Some content on ExecuteStep uses AI tools for editing, syntax checking, translation, or optimization suggestions. However, all technical content undergoes human review and validation based on my professional experience.

AI assists in the writing process, but the knowledge, experience, and validation come from years of hands-on database administration work. For more details, see our Disclaimer.

Language & Community

ExecuteStep publishes content primarily in English to reach the global database community. Select articles may be available in Portuguese (PT-BR) for the Brazilian technical audience.

I value community feedback:

  • Share your alternative solutions in the comments
  • Report errors or outdated information
  • Suggest topics you’d like to see covered
  • Ask questions about procedures or concepts

Beyond the Blog

When I’m not managing databases or writing tutorials, I’m:

  • Studying new technologies (currently focused on cloud-native databases and Kubernetes)
  • Contributing to internal knowledge bases at work
  • Mentoring junior DBAs and sharing lessons learned
  • Exploring automation opportunities to reduce manual toil

Connect With Me

I’m always open to connecting with other database professionals, discussing technical challenges, or answering questions about database administration:

A Note on Content Quality

ExecuteStep maintains high standards for technical accuracy:

  • All procedures are based on real-world experience
  • Scripts are tested before publication
  • Version-specific behaviors are noted
  • Risks and limitations are disclosed transparently

However, database environments vary. Always test scripts in non-production environments, understand what commands do before executing them, and maintain proper backups. See our Disclaimer for important safety information.

Final Thoughts

Database administration combines technical precision with creative problem-solving. It’s challenging work that keeps critical systems running and data accessible.

ExecuteStep exists to make that work easier — providing clear guidance, tested solutions, and knowledge you can trust when facing production challenges at 3 AM or planning your next major upgrade.

Whether you’re a junior DBA learning the ropes, a mid-level professional expanding your skills, or a senior administrator looking for specific solutions, I hope ExecuteStep provides value on your database journey.

Thank you for visiting ExecuteStep.

Execute with precision. Step by step.

Have questions or want to discuss database challenges? Contact me or connect on LinkedIn.