DBA Engineer
Spotware Systems Ltd is looking for a skilled DBA Engineer to join our team. This role involves both database administration and development responsibilities within a large-scale infrastructure comprising several hundred PostgreSQL databases. The ideal candidate needs to have a strong background in SQL development, performance optimization, and automation of database processes.
Responsibilities:
- Actively participate in the development of SQL code and conduct thorough code reviews.
- Optimize queries and ensure high performance and reliability of PostgreSQL databases.
- Design and maintain complex SQL scripts and functions.
- Perform core DBA tasks, including backup, recovery, replication, and monitoring.
- Contribute to the automation of administrative and migration processes using tools such as Liquibase, Jenkins, and Ansible.
- Collaborate closely with development and operations teams to support application and infrastructure needs.
- Analyze and resolve database performance issues and bottlenecks.
- Implement and enforce best practices for data integrity, security, and availability.
- Support CI/CD pipelines for managing database schema changes and deployments.
Requirements
- Proficiency in the development and administration of PostgreSQL databases.
- Strong understanding of PostgreSQL internals, including query execution plans, indexing strategies, and storage architecture.
- Hands-on experience with performance monitoring tools and query optimization techniques.
- Ability to proactively identify and resolve performance bottlenecks in large-scale environments.
- Deep knowledge of backup strategies, tools, and disaster recovery planning.
- Skilled in the installation, configuration, and ongoing maintenance of PostgreSQL database servers.
- Strong command of Linux operating systems, including shell scripting and system-level administration.
- Practical experience using automation tools such as Jenkins and Ansible for managing and streamlining database tasks and deployments.
- Proven ability to work effectively with cross-functional teams and departments to align on project priorities. Strong communication skills for conveying technical and project-related information clearly.
- Strong analytical skills for identifying and resolving issues quickly. Able to manage multiple tasks, prioritize effectively, and adapt in fast-paced, dynamic environments.
- You use AI not just occasionally, but as a core part of how you think, work, and deliver results. Being AI-augmented is part of what makes you a top performer.
Preferred qualifications:
- Proficiency in Java and Maven for managing database-related applications and build processes.
- Experience with Liquibase for database schema versioning, migrations, and CI/CD pipeline integration.
- Understanding of fault-tolerant systems and strategies for ensuring high availability and minimizing downtime.
- Hands-on experience with database replication, clustering, and distributed database systems.
- Familiarity with Visual Studio Code (VSCode) as a development environment for SQL and database tasks.
Conditions
- Competitive remuneration.
- Private medical insurance.
- Relocation package (if applicable), including work permit arrangements.
- Welcome baby bonus.
- Birthday voucher.
- Fully equipped office with daily fruits, breakfast on Wednesdays, pizzas on Thursdays and snacks on Fridays.
- Opportunities for professional growth.
Vacancy Application Form