Overview

Responsibilities:
  • 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
Required Qualifications:
  • Bachelor’s degree in Computer Science, Information Technology, or a related field
  • 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)
  • 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
Nice To Have:
  • Master’s degree
  • Experience with NoSQL systems
Note:

✨ Our intelligent job search engine discovered this job and republished it for your convenience.
Please be aware that the job information may be incorrect or incomplete. The job announcement remains the property of its original publisher. To view the original job and its full details, please visit the job's URL on the owner’s page.

Please clearly mention that you have heard of this job opportunity on https://ijob.am.