Ensure high availability (HA), performance, and scalability of mission-critical Oracle and PostgreSQL database environments across the telecom infrastructure.
Administer, maintain, and enhance Oracle RAC, Oracle Active Data Guard, Exadata, and PostgreSQL HA (e.g., Patroni, streaming replication) systems.
Oversee the installation, configuration, and continual improvement of database software and supporting tools.
Design and implement physical storage structures and plan optimal capacity usage based on performance and growth forecasts.
Perform daily, weekly, and scheduled database maintenance, monitoring, and proactive planning.
Register and manage system users, including user roles and privileges based on access policies.
Lead database development projects, including schema implementation, object design, and deployment of new services into production.
Drive improvements in database quality, performance, and operational efficiency by tuning SQL, indexing strategies, and optimizing execution plans.
Develop, test, and maintain automation scripts for database maintenance, statistics gathering, health checks, and intelligent alerting.
Monitor and manage archiving processes to ensure data lifecycle compliance.
Ensure effective database backup and recovery strategies using RMAN for Oracle and pg_basebackup/WAL archiving for PostgreSQL.
Manage end-to-end support for Exadata: platform dimensioning, capacity management, issue resolution, upgrades, and coordination with vendor support.
Collaborate with technical vendors to resolve critical incidents, apply recommended patches, and execute configuration changes.
Participate in platform evaluations and infrastructure readiness for implementing new enterprise-level database solutions.
Perform reverse engineering of data models from SQL and live databases to support documentation and reengineering efforts.
Support data integrity and consistency across multiple interlinked systems and platforms.
Xüsusi tələblər
5+ years of hands-on experience as a Senior DBA with deep expertise in Oracle (including Exadata) and PostgreSQL in enterprise or telecom environments.
Strong command of high availability architectures (Oracle RAC, Data Guard, PostgreSQL clustering solutions).
Proficient in SQL, PL/SQL, shell scripting (bash, Python), and automation of routine DBA tasks.
Experience managing large-scale database environments with strict uptime SLAs.
Expertise in backup and recovery processes, disaster recovery planning, and incident resolution.
Familiarity with monitoring tools (Oracle Enterprise Manager, Prometheus, Zabbix, Grafana, etc.) and performance tuning.
Solid understanding of storage systems, tablespace management, partitioning, and system dimensioning.
Ability to work collaboratively in a cross-functional team and communicate with vendors and stakeholders.
Fluent in reading and writing technical documentation in English.