Job Summary
Senior Database Engineer Job Description
We are seeking a highly skilled Senior Database Engineer to join our team. The successful candidate will be responsible for designing, implementing, and maintaining high-performance databases.
Key Responsibilities:
1. Administration, installation, configuration, and maintenance of PostgreSQL and MariaDB databases.
2. Optimizing database performance, including query tuning, indexing, and configuration settings.
3. Implementing and managing high-availability and replication solutions for databases.
4. Managing backups and restores to ensure data integrity and security.
5. Monitoring and analyzing system performance to identify bottlenecks and proactively resolve issues.
6. Assisting in planning and executing database migration projects.
7. Managing and configuring the Apache web server to support database-driven web applications.
8. Developing and maintaining scripts to automate routine tasks.
9. Collaborating with developers and other IT teams to optimize database solutions.
10. Creating and maintaining technical documentation and operating manuals.
Requirements:
* Extensive experience in administering PostgreSQL and MariaDB under Linux.
* Strong knowledge of SQL, database design, and performance tuning.
* Experience with configuring and managing Apache web servers.
* Knowledge of shell scripting (Bash, Python, Perl) and automation tools.
* Experience with high-availability solutions (e.g., Patroni, Galera Cluster) and replication mechanisms.
* Knowledge of backup strategies and disaster recovery.
* Good problem-solving skills and an analytical mindset.
* Ability to work independently and as part of a team, with a structured approach.
Nice-to-Have Skills:
* Certifications such as PostgreSQL Certified DBA, MariaDB Certified Database Administrator, or similar.
* Experience with DevOps practices and CI/CD pipelines.
* Knowledge of container technologies (Docker, Kubernetes) and cloud environments.
* Familiarity with security best practices for databases and web servers.