Senior Database Administrator
Deadline: 15 May 2024
Employment term: Permanent
Category: Data Science/Data Engineering
Job type: Full time
Location: Yerevan
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
REMUNERATION: competitive. The package of benefits for Ameriabank employees, including annual bonus, medical insurance, preferential terms for banking services, training and development opportunities, individual professional development plan, etc.
EMPLOYMENT DETAILS
- Highly competitive package of benefits
- Full-time position, open-ended employment contract; start date: ASAP
- Career growth and development opportunities
Professional skills
MSSQL
Share this job via your favorite social media channel.
About Company
Ameriabank CJSC is a universal bank offering financial services.
We attract talents to the Ameria team and build strong and long-lasting relationships creating a beautiful environment for dreaming and pursuing dreams together.
Our services, people-focused solutions and our desire to make a difference help us build a better world and contribute to the comfort and happiness of our teammates, customers and partners.
Benefits
Contact details
Website http://www.ameriabank.am
Phone: +37410561111
Address: 2 Vazgen Sargsyan St, Yerevan, Armenia