Keyloop

Senior Database Administrator (Postgres/Oracle)

Keyloop  •  Hyderabad, IN (Onsite)  •  14 days ago
Apply
AI can make mistakes so check important info. Chat history is never stored.

Job Description

Keyloop bridges the gap between dealers, manufacturers, technology suppliers and car buyers. We empower car dealers and manufacturers to fully embrace digital transformation. How? By creating innovative technology that makes selling cars better for our customers, and buying and owning cars better for theirs.
We use cutting-edge technology to link our clients’ systems, departments and sites. We provide an open technology platform that’s shaping the industry for the future. We use data to help clients become more efficient, increase profitability and give more customers an amazing experience. Want to be part of it?

We are seeking a Senior Database Administrator II with strong expertise in Oracle and/or PostgreSQL as primary database platforms, and solid hands-on experience with at least one secondary database technology (MSSQL, MySQL, or MongoDB). This role sits within our global Database Engineering team and requires demonstrable experience managing and operating database workloads on AWS cloud infrastructure from a DBA perspective.

In this role, you will design, build, and support highly available, scalable, and secure database platforms across Keyloop's global estate. You will focus on performance optimisation, automation, capacity planning, backup and recovery, and engineering initiatives that enhance reliability, security, and efficiency. You will work closely with application teams, DevOps, cloud, and infrastructure groups to deliver robust database solutions that underpin Keyloop's automotive technology platform.

Key Responsiblities

  • Database Engineering & Administration: Design, configure, and maintain MySQL databases ensuring availability, scalability, and reliability.
  • Performance & Optimization: Analyze workloads, identify bottlenecks, and tune queries and schemas for performance improvements.
  • Automation & Scripting: Develop scripts and automation solutions for routine tasks such as backups, deployments, patching, and monitoring.
  • High Availability & Disaster Recovery: Implement and support replication, clustering, backup/restore, and DR strategies.
  • Security & Compliance: Ensure databases follow security best practices, patching policies, and compliance standards.
  • Collaboration: Partner with application teams, DevOps, and infrastructure groups to design database solutions supporting business needs.
  • Innovation: Contribute to engineering initiatives such as migrations, cloud adoption, database standardization, and tooling improvements.

Essential skillsets

  • Experience: 7+ years of hands-on experience in administering and engineering Oracle and/or PostgreSQL databases in production environments. Experience operating databases hosted on AWS infrastructure is required. Demonstrable exposure to at least one secondary database platform (MSSQL, MySQL, or MongoDB) is expected.

    Core Expertise — Oracle / PostgreSQL (Primary):

    Oracle RAC, Data Guard, RMAN backup/restore, performance tuning, AWR/ASH analysis, partitioning, patching (RU/PSU), tablespace management, query optimisation, and security hardening.

    PostgreSQL:Replication (streaming/logical), tuning, logical/physical backups, pg_basebackup, pgBackRest, extensions, schema design, connection pooling (PgBouncer), and performance optimisation. Experience with Amazon RDS for PostgreSQL or Aurora PostgreSQL is a strong advantage.

    Secondary Database (Preferred):

    Candidates are expected to have hands-on experience or solid exposure to at least one of the following secondary database technologies:

    Microsoft SQL Server (MSSQL): Always On Availability Groups, performance tuning, indexing strategies, backup/restore, query optimisation, security, and automation.

    MySQL: Replication (primary/replica), backup and recovery (mysqldump, Xtrabackup), performance tuning, schema design, and query optimisation.

    MongoDB: Replica sets, sharding, backup strategies, index optimisation, aggregation pipelines, and schema design.

    Candidates with experience in more than one of the above secondary databases will be strongly preferred. Exposure to any other database technology beyond the primary Oracle/PostgreSQL skillset will also be considered favourably.

    AWS — Database Administration Context (Required):

    Candidates must have hands-on AWS experience specifically in the context of database administration tasks, including:

    • Storage for Databases: EBS volume management (gp3, io2) for database data and log files, EFS for shared database storage, and S3 for database backup storage, lifecycle policies, and archival.

    • Database Backup & Recovery: Using S3 as a backup target for RMAN and PostgreSQL backups, EBS snapshots for database volume recovery, and RDS automated backup management.

    • Managed Database Services: Working with RDS for PostgreSQL, Oracle, or MSSQL — including parameter group tuning, maintenance windows, multi-AZ configuration, and read replicas from a DBA perspective.

    • Database Monitoring: Using CloudWatch to monitor database-specific metrics (CPU, IOPS, storage, connections, replication lag), setting up alarms, and integrating with observability platforms.

    • Database Security: IAM roles for database access and backup operations, KMS encryption for database storage and backups, and AWS Secrets Manager for database credential management.

    • Database Networking: Understanding of VPC, private subnets, and security groups as they relate to database connectivity and access control.

    • Cost Awareness: Understanding of AWS storage and compute costs relevant to database infrastructure including EBS, S3 tiering (Standard, IA, Glacier), and RDS pricing.

    AWS certification (e.g. AWS Certified Database Specialty) is desirable but not essential.

    Technical Skills:

    • Strong SQL and query optimisation skills across multiple database platforms.

    • Proficiency with both Windows and Linux environments.

    • Strong scripting skills in one or more of PowerShell, Bash, or Python for database task automation.

    • Familiarity with AWS CLI for database-related operations (backup management, S3 interactions, snapshot handling).

Why join us? We’re on a journey to become market leaders in our space – and with that comes some incredible opportunities. Collaborate and learn from industry experts from all over the globe. Work with game-changing products and services. Get the training and support you need to try new things, adapt to quick changes and explore different paths. Join Keyloop and progress your career, your way.
An inclusive environment to thrive We’re committed to fostering an inclusive work environment. One that respects all dimensions of diversity. We promote an inclusive culture within our business, and we celebrate different employees and lifestyles – not just on key days, but every day.
Be rewarded for your efforts We believe people should be paid based on their performance so our pay and benefits reflect this and are designed to attract the very best talent. We encourage everyone in our organisation to explore opportunities which enable them to grow their career through investment in their development but equally by working in a culture which fosters support and unbridled collaboration.
Keyloop doesn’t require academic qualifications for this position. We select based on experience and potential, not credentials.
We are also an equal opportunity employer committed to building a diverse and inclusive workforce. We value diversity and encourage candidates of all backgrounds to apply
" At Keyloop, AI is a daily ally: We encourage and train every employee to use our AI tools to boost their creativity and productivity."

Keyloop

About Keyloop

As the largest global automotive technology company, Keyloop delivers cutting-edge solutions, tailored to the modern needs of auto retailers and OEMs alike. With 40 years of automotive DNA, and a deep understanding of what it takes to drive success, Keyloop solutions are delivered in over 90 countries, and trusted by more 20,000 retailers and 80 OEMs worldwide.

From the showroom to the workshop, and everything in between, its technology facilitates distinctive customer experiences between key systems, tools and departments. With modern consumers demanding increasingly high levels of service and responsiveness, Keyloop and their partners connect retailers and OEMs to consumers through every step of their journey.

Keyloop delivers a proven technology ecosystem that redesigns the automotive retail experience to cultivate lasting loyalty and optimise margins through increased efficiency, elevated experiences, and unrivalled connected data.

For more information, please visit www.keyloop.com

Industry
IT & Software
Company Size
1,001-5,000 employees
Headquarters
Reading, GB
Year Founded
Unknown
Social Media