Database Administrator

Ameriabank CJSC

- Install, configure, and manage both Microsoft SQL Server (MSSQL) and PostgreSQL instances on Windows/Unix/Linux operating systems - Implement best practices for high availability, scalability, and performance optimization for both platforms - Perform regular patching and updates to ensure system security and stability - Define and enforce user roles and permissions for database access in both MSSQL and PostgreSQL - Implement robust security measures to protect sensitive data, including encryption and access controls - Automate backup processes and regularly test recovery procedures to ensure data integrity and minimal downtime in case of disaster - Proactively monitor database performance and activity for suspicious behavior metrics for both MSSQL and PostgreSQL - Identify and troubleshoot performance bottlenecks to optimize query execution and ensure efficient data retrieval - Work with developers to analyze and optimize application queries - Generate reports on database health, performance, and utilization - Document database configurations, procedures, and best practices for future reference and knowledge transfer - Work collaboratively with application developers, system administrators, and business stakeholders to ensure database functionality meets business needs - Provide technical support to users regarding database access and functionality - Stay up-to-date on the latest trends and technologies related to MSSQL and PostgreSQL administration

- Bachelor’s degree in Computer Science, Information Technology, or a related field (Master’s degree is a plus) - 4+ years of experience in database administration, database engineering, or related roles - Strong SQL development and optimization skills with hands-on experience in relational databases (MS SQL Server, PostgreSQL) - Strong knowledge of RDBMS security concepts, including encryption, certificates, symmetric and asymmetric keys, and regulatory compliance - Experience with MSSQL high-availability technologies (Mirroring, Clustering, Replication, Log Shipping, AlwaysOn Availability Groups) - Design, install, configure, and maintain PostgreSQL databases in production, staging, and development environments - Ensure high availability, reliability, and performance of PostgreSQL systems running mission-critical workloads - Manage database upgrades, minor/major version migrations, and patching with minimal downtime - Design and validate backup and recovery strategies (pg_basebackup, pgBackRest, WAL archiving, PITR) - Monitor and analyze system health using tools such as pg_stat_* views, Prometheus/Grafana, and log analysis - Setup and manage replication, clustering, and failover solutions for PostgreSQL (e.g., streaming replication, logical replication, Patroni, PgBouncer, Pgpool-II) - Strong understanding of indexing, scaling, partitioning, and sharding concepts - Experience with automation and scripting (SQL, PowerShell, Bash or similar) - Experience with NoSQL systems is a plus - Strong troubleshooting skills using monitoring and diagnostic tools (e.g., SQL Server Extended Events, Windows Failover Cluster Manager) - Understanding of backup, recovery, and disaster-recovery strategies in regulated environments - Fluency in Armenian (excellent), with good knowledge of English and Russian

Apply here https://ats.hirebee.ai/en/jobs/database-administrator-14/apply?source_id=staff Please mention in your application that you have learned about this position from MyJob.am