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.

We offer:

• 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.