📌 Position: Mid-Level Database Administrator (AWS, PostgreSQL, SQL Server & Kafka)
Location: Remote from LATAM
Contract Type: Full-time vendor (Contract directly with In All Media)
Time Zone Alignment: US business hours overlap required
🧭 About In All Media
In All Media is a global technology and design firm focused on building impactful digital solutions through remote, distributed teams across LATAM. We partner with international clients across industries, providing long-term technical expertise, product innovation, and team augmentation.
Contract Details: This is a 100% remote contractor position open to talent anywhere in LATAM. Your contract and engagement will be directly managed with In All Media.
🚀 Project Overview
In this role, you will join an engineering environment supporting highly available, business-critical database infrastructure across AWS cloud platforms.
The position is focused on the operational administration, performance, reliability, security, and automation of enterprise relational database systems, primarily AWS Aurora PostgreSQL and Microsoft SQL Server.
You will work closely with software engineering and infrastructure teams to maintain resilient production environments, troubleshoot complex database performance issues, automate operational processes, and strengthen high-availability and disaster recovery capabilities.
This is a hands-on Database Administration and Infrastructure role. It is not focused on Data Engineering, BI, analytics, reporting, or data pipeline development.
🔍 Key Responsibilities
- High Availability & Uptime Management: Maintain, monitor, and optimize production relational database clusters to ensure high availability, resilient replication, and continuous operational performance.
- Disaster Recovery & Business Continuity: Design, document, test, and execute disaster recovery procedures while maintaining aggressive RTO and RPO targets and supporting zero-data-loss objectives.
- Database Performance Tuning & Diagnostics: Perform deep performance analysis including query profiling, execution plan reviews, index optimization, lock contention analysis, memory and I/O diagnostics, and database engine parameter tuning.
- System Security & Access Governance: Manage database access controls, user permissions, credentials, and least-privilege policies while ensuring production environments comply with organizational security standards.
- Infrastructure Automation & IaC: Automate database provisioning, configuration updates, parameter groups, maintenance tasks, and scaling policies using Terraform and scripting technologies such as Python or PowerShell.
- AWS Database Operations: Administer and support managed database environments using AWS RDS and Amazon Aurora, ensuring reliability, scalability, security, and operational efficiency.
- Kafka Platform Operations: Support Confluent Kafka / Apache Kafka environments through cluster monitoring, health checks, troubleshooting, and operational administration.
- Cross-Functional System Design & Reviews: Partner with software engineering teams on schema design, query reviews, capacity planning, database architecture, and production-readiness recommendations.
- Incident Response & Operational Stability: Provide hands-on Tier 3 production support, investigate database and infrastructure incidents, resolve service degradations, and contribute to post-incident Root Cause Analyses (RCAs).
💡 Must-Have Skills
- Experience Level: 3–4 years of hands-on, mid-level production experience administering, tuning, securing, and supporting enterprise database environments.
- Core RDBMS Platforms: Production experience with both AWS Aurora PostgreSQL and Microsoft SQL Server. Candidates may have deeper expertise in one platform while maintaining practical operational experience with the other.
- AWS Cloud Database Services: Strong experience managing production database environments using AWS RDS and Amazon Aurora.
- Database Performance Tuning: Proven ability to diagnose query regressions, execution plan issues, lock contention, indexing problems, memory and I/O bottlenecks, and database configuration issues.
- High Availability & Disaster Recovery: Hands-on experience implementing HA architectures, replication strategies, failover testing, backup and restore procedures, and disaster recovery execution.
- Automation & Scripting: Practical experience using Python or PowerShell to automate database administration, monitoring, maintenance, or operational workflows.
- Infrastructure as Code: Hands-on experience provisioning and managing database infrastructure using Terraform or comparable Infrastructure as Code frameworks.
- Kafka Operations: Operational experience with Confluent Kafka or Apache Kafka, including cluster administration, monitoring, health validation, and troubleshooting.
- Security & Access Management: Experience managing production database permissions, authentication, credential governance, and least-privilege access controls.
- Production Operations: Strong troubleshooting skills and experience supporting critical production systems, responding to incidents, and identifying root causes.
- Role Alignment: Candidates must have a strong operational / infrastructure DBA background. Profiles primarily focused on Data Engineering, BI/reporting, analytics, Tableau, Apache Airflow, or Apache Spark are not aligned with this position.
- Environment & Connectivity — Mandatory Compliance: Ability to work entirely within an enterprise-provisioned Virtual Desktop Infrastructure using AWS WorkSpaces. Candidates must complete the official AWS WorkSpaces network health check and submit a screenshot demonstrating successful latency and connectivity results alongside their profile.
🌟 Nice-to-Have Skills
- Advanced Kafka Ecosystem: Experience developing or configuring custom Kafka connectors, managing Schema Registry, or working with stream-processing technologies such as ksqlDB or Apache Flink.
- Additional Database Technologies: Administration experience or practical familiarity with MongoDB, Snowflake, or MySQL.
- Cloud Infrastructure: Broader experience supporting AWS infrastructure and production cloud environments.
- Observability: Familiarity with database monitoring, infrastructure observability, centralized logging, alerting, and production performance monitoring tools.
🌐 Time Zone & Collaboration
This role requires consistent overlap with US business hours to collaborate effectively with distributed engineering and infrastructure teams across production support, troubleshooting, architecture discussions, and operational activities.
💬 Language
All interviews, technical documentation, daily team communications, incident discussions, and operational collaboration will be conducted in English.
Skills Required
- 3–4 years of hands-on production experience administering, tuning, securing, and supporting enterprise database environments
- Production experience with both AWS Aurora PostgreSQL and Microsoft SQL Server
- Strong experience managing production databases using AWS RDS and Amazon Aurora
- Experience diagnosing query regressions, execution plan issues, lock contention, indexing problems, memory and I/O bottlenecks, and configuration issues
- Hands-on experience implementing high availability architectures, replication, failover testing, backup and restore, and disaster recovery
- Experience using Python or PowerShell for database administration automation
- Experience provisioning and managing database infrastructure with Terraform or comparable infrastructure-as-code frameworks
- Operational experience with Confluent Kafka or Apache Kafka, including administration, monitoring, health validation, and troubleshooting
- Experience managing database permissions, authentication, credentials, and least-privilege access controls
- Production operations experience supporting critical systems, responding to incidents, and identifying root causes
- Strong operational or infrastructure DBA background
- Ability to work entirely within an enterprise-provisioned AWS WorkSpaces virtual desktop and submit a successful network health check screenshot
- Ability to work consistently during overlapping US business hours
- English proficiency for interviews, documentation, communications, and incident discussions
- Experience with custom Kafka connectors, Schema Registry, ksqlDB, or Apache Flink
- Administration experience or familiarity with MongoDB, Snowflake, or MySQL
- Broader AWS infrastructure and production cloud experience
- Familiarity with database monitoring, observability, centralized logging, alerting, and performance monitoring tools
What We Do
In All Media is a cutting-edge technology and innovation consulting organization, facilitating digital transformation in multiple industries. We have partnered with top-tier organizations such as NBCUniversal, Sony DADC, Aclara Technologies, and Dun & Bradstreet, among other leading companies worldwide. In All Media harnesses the collaborative synergy of all our international talent pool using Agile methodologies, to deliver excellence efficiently and with the utmost quality. At In All Media, we believe in diversity and autonomy. Our new model brings together a global managed community, with experts guiding and managing talented engineers; working to bring together the best talent in the world, regardless of where they are. We are not only evolving in terms of technology, but also in terms of In All Media as a re-imagined technology consultancy in step with the Fourth Industrial Revolution. Our community of 200+ experts and engineers are very motivated by different challenges in their field, and apply continuous learning to stay ahead of the curve in their expertise on new developments and innovative technologies. Our delivery model is based on Agile, On-site, and Near Shore capabilities to maximize team integration and provide the best value to our clients. We partner holistically with our clients in the co-creation of services and products, and follow streamlined Agile processes throughout. This makes In All Media a truly global company driven by a community of dedicated, talented individuals self-organizing into multi-disciplinary teams, producing the best possible output for our world-class clients. We're hiring! Email us your CV: [email protected] Contact Us: [email protected]
.png)







