Ameriabank CJSC

Job description:

A Senior Database Administrator (DBA) is responsible for performance, integrity, security, support and administration of databases based on PostgreSQL and MS SQL Server. Additional role requirements are likely to include planning, development and troubleshooting..

/en/senior-database-administrator-43

Job 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.
• Monitor database activity for suspicious behavior and potential security breaches.
• Design and implement a comprehensive backup and recovery strategy for both MSSQL and PostgreSQL databases.
• Automate backup processes and regularly test recovery procedures to ensure data integrity and minimal downtime in case of disaster.
• Proactively monitor database performance 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.
• Participate in database design and development processes, ensuring adherence to data modeling best practices for both MSSQL and PostgreSQL.
• Maintain database objects like tables, indexes, views, stored procedures, and functions.
• 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 (or equivalent experience).
• Minimum 5+ years of experience as a Database Administrator with a strong focus on MSSQL and PostgreSQL administration.
• Proven experience in installing, configuring, and managing complex database environments, Always ON Availability Groups, Failover Clusters.
• In-depth knowledge of SQL query languages (T-SQL for MSSQL and PL/pgSQL for PostgreSQL).
• Expertise in database security best practices, including user authentication, authorization, and data encryption.
• Strong understanding of database backup and recovery strategies.
• Experience with database performance monitoring and optimization tools.
• Excellent analytical and problem-solving skills.
• Effective communication and collaboration skills.
• Ability to work independently and manage multiple tasks simultaneously.

ADDITIONAL SKILLS (PREFERED)

• Experience with database automation tools (e.g., PowerShell, Shell scripting, Sqlcmd).
• Experience with database DevOps practices.
• Working knowledge of database replication and clustering technologies.

Required candidate level: Senior

Additional information