Database Administrator

İş haqqında

Take technical ownership of the installation, configuration, administration, and maintenance of critical database platforms, including PostgreSQL, Oracle, and MySQL;Design scalable database architectures and schemas, and contribute to the technical implementation of data warehouse solutions, including structures, ETL/ELT processes, partitioning, and indexing;Analyze, tune, and optimize SQL queries and overall database performance;Design, implement, and regularly test High Availability (HA), replication/synchronization (master-slave), backup, and Disaster Recovery (DR) solutions;Ensure service continuity, manage database-related incidents, and conduct Root Cause Analysis (RCA);Implement database security, access control, and auditing processes;Establish database monitoring and proactively track performance, availability, and overall database health;Automate routine database administration tasks through scripting;Ensure controlled deployment and management of database changes across test, pre-production, and production environments;Provide database support for new projects and participate in load and stress testing;Implement data masking, anonymization, and access restrictions to protect sensitive and patient data;Maintain comprehensive technical documentation and provide technical leadership and mentorship to junior DBA team members. Əsas vəzifələr Take technical ownership of the installation, configuration, administration, and maintenance of critical database platforms, including PostgreSQL, Oracle, and MySQL; Design scalable database architectures and schemas, and contribute to the technical implementation of data warehouse solutions, including structures, ETL/ELT processes, partitioning, and indexing; Analyze, tune, and optimize SQL queries and overall database performance; Design, implement, and regularly test High Availability (HA), replication/synchronization (master-slave), backup, and Disaster Recovery (DR) solutions; Ensure service continuity, manage database-related incidents, and conduct Root Cause Analysis (RCA); Implement database security, access control, and auditing processes; Establish database monitoring and proactively track performance, availability, and overall database health; Automate routine database administration tasks through scripting; Ensure controlled deployment and management of database changes across test, pre-production, and production environments; Provide database support for new projects and participate in load and stress testing; Implement data masking, anonymization, and access restrictions to protect sensitive and patient data; Maintain comprehensive technical documentation and provide technical leadership and mentorship to junior DBA team members. Tələblər Bachelor’s degree in Information Technology, Computer Science, Mathematics, or another relevant field; At least 3 years of professional experience in database administration, including at least 1 year working in high-load, business-critical 24/7 production environments; Strong hands-on expertise in PostgreSQL 14+: configuration and performance tuning, VACUUM/AUTOVACUUM, WAL management, streaming replication, connection pooling (PgBouncer), partitioning, indexing strategies, and query optimization using EXPLAIN/ANALYZE; Practical experience in Oracle Database administration, including tablespace and resource management, RMAN, Data Guard, performance analysis using AWR/ASH, and PL/SQL; Server-level administration experience with Linux (RHEL/Ubuntu), including Bash scripting, cron/systemd, and troubleshooting of disk/IO, memory, and network resources; Strong knowledge of backup and recovery processes, including PITR, pg_basebackup/pg_dump, and RMAN; experience in planning and executing recovery tests and practical application of RPO/RTO concepts; Hands-on experience with HA/DR solutions, including master-slave replication, failover scenarios, and Patroni, repmgr, or equivalent technologies; Experience with database monitoring tools such as Zabbix, Prometheus/Grafana, pgwatch, or equivalent solutions; Knowledge of database security practices, including role and access management (RBAC), auditing, encryption, and sensitive data masking; Experience with data migration, ETL/ELT processes, and controlled change management across different environments; Advanced SQL skills and experience writing automation scripts in Python or an equivalent programming language; Fluency in Azerbaijani; sufficient English proficiency to read and understand technical documentation. Oracle OCP or professional PostgreSQL certification; Experience participating in the technical implementation of Data Warehouse (DWH) projects, including dimensional modeling and ETL orchestration; Experience supporting reporting and BI platforms such as Apache Superset and Power BI from the database side; Familiarity with legal and regulatory requirements related to personal data protection.