Job Type: Onsite - Full Time
Education: Bachelor’s Degree
Experience: Senior
Vacancies: 1
Skills: Database Performance & Tuning, Database Backup, Recovery & Availability, Database Design & Modeling, Database Development & Programming, Database Querying & Reporting, Database Administration & Management

Key responsibilities

Database administration

Install, configure, patch and upgrade SQL Server (2016–2022) and Oracle (12c–19c) instances on Windows and Linux.

Manage schemas, users, roles, tablespaces/filegroups, storage growth and capacity planning.

Maintain configuration standards, runbooks and an up-to-date inventory of all database instances.

High availability and disaster recovery

Design, implement and operate SQL Server Always OnAvailability Groups, Failover Cluster Instances and log shipping.

Design, implement and operate Oracle RAC and Oracle Data Guard (physical and logical standby, Fast-Start Failover, Broker).

Own the DR runbook: schedule and lead switchover/failover drills at least twice a year and document results.

Monitor replication lag, apply gap and standby health daily; resolve gaps and re-sync standbys.

Replication and data movement

Configure and support SQL Server transactional, merge and snapshot replication, Change Data Capture and linked servers.

Configure and support Oracle GoldenGate, Streams/Advanced Replication, materialized views and database links.

Troubleshoot replication conflicts, latency and agent failures.

Backup and recovery

Define and run backup strategy (full, differential, log; RMAN incremental and archive-log backups) meeting the organization's RPO/RTO.

Test restores monthly and keep evidence for audit.

Development support

Write, review and optimize views, stored procedures, functions, triggers and packages (T-SQL and PL/SQL).

Review application schema changes and deployment scripts before release to production.

Support core-banking, channel (mobile, USSD, card) and reporting teams with data fixes and query tuning.

Performance, Security and monitoring

Tune queries, indexes, statistics, execution plans and wait events; set up alerting on CPU, I/O, blocking and space.

Produce weekly health and capacity reports.

Enforce least-privilege access, auditing, encryption at rest and in transit, and password/key rotation.

Operations

Participate in the 24x7 on-call rotation and lead database incident response and root-cause analysis.

Follow change-management procedures for all production changes.

Required qualifications

Education and experience

BSc in Computer Science, Information Systems, Software Engineering or a related field.

+ years as a DBA in production environments, with both SQL Server and Oracle.

Experience in banking, fintech or another regulated, high-transaction environment.

Strong SQL writing and optimization ability in both T-SQL and PL/SQL.

Solid understanding of storage, networking and OS concepts as they affect database performance.

Proven experience running real DR failover drills, not only configuring standbys.

Preferred qualifications

Certifications: Oracle Database Administrator Certified Professional and Microsoft Certified

Monitoring tools: Oracle Enterprise Manager, SQL Server Management Studio reports, Zabbix, Grafana or similar.

View original on source