Location: guadajalara, mexico (currently hybrid with up to 50% remote)
your mission in the platform dba team:
touchtunes is looking for a passionate technology professional with a strong focus on oracle on-premises server management and aws database platforms. In this role, you will be part of the platform dba team and will play a key role in the design, automation, operation, and optimization of cloud-native data services that power our large-scale, high-availability applications.
you will take ownership of self-managed oracle data platforms and several aws-hosted database platforms ensuring security, scalability, resiliency, and cost-effectiveness. This includes infrastructure automation, upgrades, performance tuning, and close collaboration with development teams to ensure optimal data usage and architecture decisions.
as part of the dba team, you will contribute both to day-to-day operations and longer-term data platform initiatives. You will work with talented, friendly teams to support application development by providing expertise in aws database services, data reliability, and cloud best practices. This role is integral to the evolution of touchtunes' next-generation application and data platforms.
* design, operate, and optimize aws and on-premises managed database and data services
* support development teams throughout the full application lifecycle, from architecture and planning to production deployment.
* standardize and automate database provisioning, configuration, scaling, and schema changes using infrastructure as code (cloudformation / terraform).
* design and implement backup, restore, disaster recovery, and data retention strategies.
* ensure high availability, fault tolerance, and performance of production data systems.
* monitor, tune, and optimize databases and search platforms (queries, indexes, caching strategies, shard/replica design).
* enforce data security and compliance best practices, including roles and permissions, encryption at rest and in transit, secrets management, and access controls.
* identify operational inefficiencies and continuously improve reliability, scalability, and cost optimization.
* maintain detailed jira tickets associated with tasks and projects.
* ensure availability of development, staging, and production environments, and automate deployments across them.
* act as a key escalation and support resource for production data and platform incidents.
* research new services and data technologies and lead proof-of-concepts to validate improvements.
* off-hours on-call rotation every 2 weeks (evenings and weekend). Rotations are compensated.
your profile:
essential – passion for database management and performance across multiple platforms
experience administering linux-based systems :
* hands-on oracle administration knowledge
* oracle upgrades & patching: upgrading databases from 11g/12c to 19c using dbua or manual methods.
* multitenant architecture: managing container databases (cdbs) and pluggable databases (pdbs).
* rman (recovery manager): expertise in complex recovery scenarios (point-in-time recovery, tspitr) and integration with s3 or storage-level backups.
* data guard (asset): setting up and managing physical standby databases, including active data guard for offloading read-only workloads.
* awr/ash/addm (asset) : deep ability to read automatic workload repository (awr) reports and active session history (ash) to find the "needle in the haystack" during performance spikes.
* sql tuning: using the sql tuning advisor and manually rewriting queries to optimize execution plans.
* shell scripting: writing bash or perl scripts to automate daily health checks, monitoring, and rman backups.
hands-on experience with aws, including services such as:
* ec2, auto scaling, cloudwatch, iam, vpc, cloudformation/terraform
* amazon documentdb
* amazon mq/sqs
* amazon s3
knowledge of the following is an asset :
* aws database migration service (dms)
* amazon elasticache (redis)
experience with automation and scripting (python, bash, cloudformation, ansible, or similar)
solid understanding of high-load, internet-facing systems and distributed architectures
even better if you have:
* college/university degree in computer science, engineering, or equivalent experience
* 3+ years of experience in db management, sre, or cloud operations roles
what’s in it for you:
at touchtunes, your work impacts our customers as part of interesting projects that transform the in-venue entertainment industry. We foster open communication and collaboration across all levels, with approachable leaders that value all voices and empower you to excel and innovate. Our team thrives in an environment where fun meets hard work, and everyone is encouraged to be their authentic selves.
we are the world’s largest in-venue interactive music and entertainment platform; we’re all about sparking joy and human connection. That moment in a bar where someone at the next table cues the jukebox to play your favorite song? That’s what we do – our platform plays millions of songs daily – but we’re also so much more! We just bought the largest soft-tipped darts business in the united states, we’re reinventing our mobile app for launch later this year, and we’re operating nearly 100,000 connected devices across north america and europe. We’re innovators, strategic thinkers, people making the future possible today – and what a great time to join our team.
🌈touchtunes is a proud ally of queertech and diversityjobs.
#j-18808-ljbffr