Consulting

Data engineering for critical environments

Hands-on experience with mission-critical databases in logistics, contact centers, banking-as-a-service and global SaaS. Senior consulting per project or on a monthly retainer, delivered remotely.

Services

Areas of expertise

01

Performance tuning and optimization

Diagnosis of resource bottlenecks and latency through wait stats, execution plans and indexes, with an action plan prioritized by business impact.

  • Query and execution plan analysis
  • Indexes, statistics and maintenance routines
  • Instance and storage configuration
  • Capacity and growth planning
02

High availability and disaster recovery

Always On, Failover Clusters and a backup strategy proven by restore tests. RPO and RTO agreed with the business before an incident, not during one.

  • Always On Availability Groups and FCI
  • Backup strategy and restore testing
  • Disaster recovery (DR) planning
  • Multi-region topologies on AWS and Azure
03

Migrations and safe cloud transitions

Version upgrades, cloud migrations, account moves or environment consolidation, planned for minimal operational impact.

  • SQL Server upgrades (2008 R2 to 2025)
  • On-premises to AWS or Azure
  • RDS, Aurora or SQL Server on EC2
  • Continuous replication with AWS DMS
04

Infrastructure as Code (IaC)

Versioned, reviewed and automated infrastructure, configuration and schema changes, with observability and proactive alerting.

  • Terraform, Spacelift and Chef
  • Schema change pipelines on GitHub Actions
  • Automation with PowerShell and Python
  • Monitoring and alerting (Redgate, New Relic, Zabbix)
05

Advanced diagnostics and architectural re-engineering

A full assessment of your data environment, risk identification and an architecture redesign that supports growth with security and predictable cost.

  • Environment health and security assessment
  • Architecture and cloud cost review
  • Risk mitigation and remediation plan
  • Access security and auditing
06

Custom systems and automation

From automated processes to SaaS with recurring billing, built to the same engineering standard as the products on this site.

  • Websites and dashboards with automatic publishing
  • API and payment integrations
  • Queues, workers and scheduled jobs
  • Lean Kubernetes for small and mid-sized companies

Results

Real cases

Results delivered at companies where we worked. Client details remain confidential.

AWS account migration with ~3 s of downtime

About 100 databases (3 TB) of a banking-as-a-service platform moved to a new AWS account by adding replicas to the existing Availability Group and failing over.

12 instances consolidated into 1 cluster

12 Aurora MySQL instances (about 1 TB) consolidated into a SQL Server 2019 cluster on EC2 with continuous replication through AWS DMS. Impact limited to an application restart.

~40% performance gain

A proof of concept with SQL Server on EC2 (gp3 storage and reads on the secondary replica) that backed leadership’s decision to move off RDS SQL Server.

Attack mitigated in 15 minutes

Connection monitoring we had built detected data scraping through a vulnerable API. Access was blocked 15 minutes after the alert, with no data lost or changed.

How it works

From first contact to stable operations

  1. Introductory call

    30 minutes, free of charge, to understand the environment, the challenges and the priorities.

  2. Advanced diagnostics

    Evidence gathered from the environment and a report with the risks found, the impact of each one and the remediation order.

  3. Execution

    Implementation together with your team, or a detailed plan for your team to execute.

  4. Ongoing support

    Monthly hours for monitoring, change reviews and incident response.

Technologies: SQL Server (2008 R2 to 2025), PostgreSQL, Amazon RDS and Aurora, DynamoDB, AWS, Azure, Terraform, Chef, PowerShell, Python, Docker and Kubernetes.

Contact

Talk to O. S. Technology

Briefly describe the technology, the size of the environment and the main challenge. We reply within one business day.