Database Administrator (P790)

About Us:

As a Senior Database Administrator at Kenility, you’ll join a tight-knit family of creative developers, engineers, and designers who strive to develop and deliver the highest quality products into the market.

Technical Requirements:

• Bachelor's degree in Engineering, Computer Science, or a related field.
• Over 5 years of hands-on experience as a Database Administrator (DBA), with proven expertise in YugabyteDB or PostgreSQL.
• Deep understanding of PostgreSQL internals, including architecture, storage, and execution processes.
• Practical experience with AWS services such as RDS, EKS, and ECS, as well as designing base infrastructure for scalable database deployments.
• Solid experience implementing load balancing, failover, and disaster recovery strategies to ensure high availability and data resilience.
• Strong skills in SQL performance tuning, including indexing, query optimization, and execution plan analysis.
• Familiarity with CI/CD pipelines and Infrastructure as Code (IaC) tools (e.g., Terraform, CloudFormation) is a plus.
• Exposure to NoSQL technologies, especially Cassandra or other distributed database systems, is considered an asset.
• Certifications in YugabyteDB, PostgreSQL, or AWS.
• Experience working in high-traffic, mission-critical production environments, with an emphasis on stability and scalability.
• Minimum B2 (Upper-Intermediate) or C1 (Proficient) level in English.

Tasks and Responsibilities:

• Lead the scoping, planning, and hands-on delivery of technical database projects in close collaboration with customers.
• Deploy, configure, and administer YugabyteDB clusters and PostgreSQL environments within AWS infrastructure.
• Execute database migrations from Oracle and other RDBMS platforms to YugabyteDB or PostgreSQL, ensuring data integrity and minimal downtime.
• Provide expert guidance on performance tuning, including monitoring, query optimization, and system diagnostics.
• Design and maintain high availability architectures, incorporating disaster recovery and fault-tolerant configurations.
• Implement advanced data distribution strategies such as replication, sharding, and partitioning to support horizontal scalability.
• Identify and resolve database issues, conduct root cause analysis, and prevent recurrence of incidents.
• Work closely with application developers to enhance SQL efficiency and refine data models and schemas.
• Automate routine operations and infrastructure provisioning using tools like CloudFormation, Terraform, and shell scripting.
• Oversee database backup procedures, recovery operations, and version upgrades for both YugabyteDB and PostgreSQL instances.
• Enforce security best practices, including data encryption, secure access controls, and compliance with standards.
• Continuously track updates and evolving capabilities within YugabyteDB and PostgreSQL ecosystems.
• Contribute to team growth through mentoring and knowledge sharing, fostering best practices and continuous improvement.

Soft Skills:

• Responsibility
• Proactivity
• Flexibility
• Great communication skills