Администратор баз данных / DBA PostgreSQL

Job Title: Lead/Senior Database Administrator (DBA)

Job Summary:

We are seeking a highly skilled and experienced Lead/Senior Database Administrator (DBA) to manage and maintain the performance, integrity, and security of our databases across multiple platforms including PostgreSQL, Oracle, MS SQL Server, and other relational databases. The ideal candidate will have a deep technical background in database administration, advanced scripting knowledge, and the ability to troubleshoot complex database issues, implement solutions, and work on large-scale database systems.

Key Responsibilities:

Database Management:

• Oversee day-to-day database operations for PostgreSQL, Oracle, MS SQL, and other RDBMS environments.
• Manage database performance tuning, backups, and recovery strategies.
• Ensure databases are properly configured for optimal performance, availability, and scalability.

Installation & Configuration:

• Install, configure, and maintain database servers and clients, ensuring high availability and disaster recovery setups.
• Perform database upgrades, patches, and migrations without affecting service uptime.

Security Management:

• Implement and maintain database security measures, including access control, user privileges, and encryption protocols.
• Conduct regular database audits and vulnerability assessments.

Performance Tuning:

• Monitor database performance and implement tuning solutions for slow-running queries, indexes, and overall database optimizations.
• Review and optimize SQL queries, database schema design, and server configurations.

Backup & Recovery:

• Implement and manage effective backup and disaster recovery strategies to ensure data integrity and minimize downtime.
• Ensure the integrity and availability of data through periodic testing of backup and restore operations.

Monitoring & Reporting:

• Set up and manage proactive database monitoring systems to detect and resolve performance bottlenecks, failures, and security breaches.
• Create and manage reports on database health, performance, and uptime statistics.

Collaboration & Documentation:

• Work closely with development teams, DevOps, and system administrators to support application needs and database architecture.
• Provide mentorship and guidance to junior DBAs and developers on best practices for database design, security, and optimization.
• Maintain comprehensive documentation on database architecture, procedures, and processes.

Disaster Recovery & High Availability:

• Design, implement, and maintain high-availability solutions like clustering, replication, and failover.
• Plan and execute disaster recovery drills to ensure preparedness in the event of system failure.

Database Migration & Integration:

• Lead migration projects involving the movement of databases across different environments (cloud, on-premise, etc.).
• Support database integration with other applications and systems.

Scripting & Automation:

• Develop and maintain scripts (e.g., Python, PowerShell, Bash) to automate routine DBA tasks such as backups, monitoring, alerting, and performance tuning.
• Write and maintain custom scripts for automated deployment and maintenance of database environments.
• Use scripting languages to support database provisioning, scaling, and configuration management, in collaboration with DevOps teams.

Required Qualifications:

Experience:

• 5+ years of hands-on experience as a Database Administrator with expertise in PostgreSQL, Oracle, MS SQL Server, or similar RDBMS.
• Experience with cloud-based database solutions (AWS RDS, Azure SQL, Google Cloud SQL, etc.) is a plus.

Technical Skills:

• Proficiency in SQL, database query optimization, and performance tuning.
• Strong experience in writing and maintaining automation scripts in Python, Bash, PowerShell, or similar languages to automate DBA tasks.
• Experience with database backup, restore, replication, and clustering techniques.
• Familiarity with database monitoring tools (e.g., Nagios, Zabbix, SolarWinds, or native DB tools).
• Strong understanding of database security policies, user management, and data encryption.

Preferred Qualifications:

• Experience with NoSQL databases like MongoDB, Cassandra, or Redis.
• Familiarity with containerized environments (Docker, Kubernetes) and DevOps practices.
• Experience with database monitoring and management tools like SolarWinds, Redgate, or DBeaver.
• Understanding of continuous integration and deployment (CI/CD) pipelines in relation to database changes.