paytech

Oracle DBA

1 мес. назад

CyprusMiddleHybrid

oraclesqlpl/sqlawrashexplain planaws rdsdata pump

paytech is a dynamic fintech company operating payment infrastructure on AWS and using Oracle Database stack. They seek an experienced Oracle DBA to own database stability under PCI DSS requirements.

About the company

paytech (https://www.pay.tech/) is a dynamic fintech company dedicated to pushing the boundaries of innovation in the industry.

About the product

We operate payment infrastructure across multiple isolated AWS accounts for several fintech products.
The core stack is built on Oracle Database (AWS RDS SE2), APEX applications, and high-throughput transactional processing pipelines.

Responsibilities

Develop and optimize Oracle SQL / PL/SQL: complex queries, procedures, functions, triggers, packages; performance tuning using AWR, ASH, EXPLAIN PLAN;
Manage database schemas: DDL migrations, partitioning, indexes, ETL processes, and secure PL/SQL development;
Administer Oracle APEX environments: upgrades, workspace management, application support, and performance troubleshooting;
Manage AWS RDS Oracle instances: provisioning, configuration, monitoring, backups, snapshots, PITR, storage, and performance optimization;
Perform data migration and replication tasks using Data Pump and AWS DMS (CDC);
Design and maintain backup/recovery processes; handle restore, schema recovery, and migration scenarios;
Monitor and troubleshoot database performance: workload analysis, blocking, deadlocks, CPU/IO issues, and maintenance activities.

Requirements

3+ years of DBA experience, with at least 2 years on Oracle DB;
Strong Oracle SQL and PL/SQL skills: packages, cursors, exceptions, dynamic SQL;
Hands-on experience with Oracle APEX (administration or application development);
Practical experience with AWS RDS Oracle: provisioning, configuration, day-to-day management;
Solid understanding of backup and recovery strategies; experience with Data Pump;
Ability to read and interpret execution plans and AWR reports;
Comfortable working in a Linux environment (bash, cron, filesystem operations);

Nice to have

Background in fintech or payment systems; familiarity with PCI DSS requirements;
Experience with Oracle DMS, Kinesis, or other CDC solutions;
Exposure to Terraform / Ansible for IaC-driven database infrastructure management;
Familiarity with Prometheus, Grafana, or similar observability tooling;
Understanding of ORDS architecture and REST integrations via APEX;
Experience upgrading Oracle APEX across major versions.

Conditions

Work with a serious enterprise stack: Oracle RDS, APEX, ORDS, AWS;
Technical ownership: architecture decisions are made collaboratively with the team;
Competitive compensation;
Growth path toward data architecture and cloud DBA roles;
Stable team, pragmatic processes, no unnecessary chaos;
A cozy office in Limassol — snacks, drinks, PS5, and a stunning rooftop kitchen view;
Sports and lunches compensation;
Team events, health insurance, nice perks, and work permit support.