Kyriba is seeking a Database Administrator to join our team of more than 200 engineers working together to bring innovative solutions to Kyriba clients around the globe. We are a team of passionate people motivated by agility, innovation and continuous improvement.
Onboarded to the Service Excellence, Reliability & Operations team, you will join a transversal team across Engineering, Product & Operations,responsible for the global reliability of Kyriba’s platforms. You will be responsible for planning, executing, following and reporting on cross-functional improvements. In particular, you will follow from initial design to full completion. The successful candidate will be able to understand complex technical concepts, identify stakeholders, and communicate progress of projects.
Essential Duties and Responsibilities
Functional DBA, able to understand and assist the Engineering & Business teamsAssist with, support, and maintain on-prem and AWS Oracle DB infrastructure activitiesAdminister Oracle RAC clusters in vSphere, and RDS on AWSDesign, build, and support SQL queries and statements as neededOptimize SQL code and queries for production use and development activitiesSupport application development teams with SQL tuning and code write optimizationInvestigate & support the initial migration to sharding tables on OracleInitial scope of the job will be on data pruning / purge ; and Oracle database partionningExperience
Bachelor’s degree in engineering, computer science or related field.English fluency is required, both in written and oral form. Fluency in French is a plus.Experience with specific project management tools (Jira, Confluence)4+ years Oracle DB experience (11g, 12c, 19c)4+ years Oracle partitioning, sharding2+ years PostgreSQL DB experience (v11, 13+)2+ years SQL performance tuning2+ years SQL, PL/SQL and language writing2+ years with DB tooling (EX: SQL*Plus, TOAD, EM, etc.)1+ years in AWS and RDSFamiliarity with CDC concepts and managementFamiliarity with AWS database offerings (MSK, RDS, marketplace, etc.)Nice to have:
Oracle ASM, Dataguard, MultitenantMongoDB experience