vacancies-intro
Romania Remote DBA

DBA Architect

Apply

Description

Ciklum is looking for a DBA Architect to join our team full-time in Romania.

We are a custom product engineering company that supports both multinational organizations and scaling startups to solve their most complex business challenges. With a global team of over 4,000 highly skilled developers, consultants, analysts and product owners, we engineer technology that redefines industries and shapes the way people live.

About the role:

As a DBA Architect, become a part of a cross-functional development team engineering experiences of tomorrow. 

Join our team as a DBA Architect and play a key role in shaping the future of our client's platform. As part of a cross-functional development team, your work will directly impact scaling the platform to handle heavy loads and achieve global reach. Collaborating closely with our talented tech team, you'll bring fresh ideas—whether inspired by user feedback or market trends—and help us make smart, lasting decisions that drive success. 

The challenge: 1 million users rely on our platform, and we aim to scale to 50 million. Stability and scalability are critical as we enhance the framework, improve robustness, and optimize key features like authorization, routing, and component interaction. The ideal candidate will play a crucial role in ensuring the performance, reliability, and scalability of our 4500 databases in a database-per-tenant architecture. You will collaborate closely with developers, providing guidance on query optimisation, monitoring database performance, resolving deadlocks, and overseeing database migrations to ensure data integrity and minimal downtime.

Responsibilities

  • Database Optimisation: Analyze and optimize MySQL databases to improve the performance of PHP applications, including query tuning, indexing strategies, and schema design
  • Performance Monitoring: Implement and maintain monitoring solutions to proactively identify and resolve performance issues, bottlenecks, and inefficiencies within the database
  • Query Optimization: Collaborate with PHP developers to review and optimize SQL queries, ensuring they are efficient and adhere to best practices
  • Deadlock Resolution: Diagnose and resolve deadlocks and other concurrency issues that affect database performance and application stability
  • Migration Management: Plan, execute, and oversee database migrations, ensuring minimal downtime and preventing data loss. Provide guidance on best practices for schema changes and data migrations
  • Scaling: Architect and aid in transforming our current clusters to highly available large-cluster cloud deployments to meet our scaling needs
  • Coaching & Mentorship: Coach and mentor developers on database best practices, query optimisation techniques, and the effective use of MySQL features
  • Backup & Recovery: Design and implement robust backup and recovery strategies, ensuring data integrity and availability in the event of system failures
  • Security Management: Ensure that the databases are secure, with appropriate access controls, encryption, and auditing in place to protect sensitive data
  • Documentation: Maintain documentation of database architectures, processes, and best practices to ensure knowledge sharing and continuity within the team

Requirements

  • Minimum of 7+ years of professional experience as a Database Administrator, with a strong focus on managing MySQL clusters in large scale deployments
  • Deep understanding of MySQL internals, including storage engines (InnoDB, MyISAM), indexing strategies, query optimisation, execution plan analysis and replication
  • Strong knowledge of database design, normalisation, and data modelling
  • Affinity with managing and implementing performance monitoring to gain insight into the health of the cluster(s)
  • Expertise in identifying and resolving deadlocks, lock contention, and other concurrency issues
  • Experience migrating data structures and collations in large-scale database clusters
  • Solid knowledge of the ins and outs of writing SQL-queries in PHP applications
  • Good track record of architecting and deploying different types of database infrastructures in a cloud-based environment
  • Experience with infrastructure as code tools and frameworks such as for example Ansible and Terraform would be a pré

Personal skills

  • Strong problem-solving skills and analytical thinking, being able to implement improvement plans based on monitoring solutions
  • Excellent communication skills, with the ability to explain complex database concepts to developers and non-technical stakeholders
  • Ability to work both independently and as part of a collaborative team
  • Strong organisational skills and attention to detail
  • Ability to plan large projects spanning multiple weeks, managing requirements and stakeholders

What's in it for you

  • Care: your mental and physical health is our priority. We ensure comprehensive company-paid medical insurance and Mental Health programs. We also provide you with meal vouchers to fuel your mind and body
  • Tailored education path: boost your skills and knowledge with our regular internal events (meetups, conferences, workshops), Pluralsight licenses, language courses and company-paid certifications
  • Growth environment: share your experience and level up your expertise with a community of skilled professionals, locally and globally
  • Flexibility: Own your schedule – you are the one to decide when to start your working day. Just dont miss your regular team stand-up  
  • Opportunities: we value our specialists and always find the best options for them
  • Our Internal Mobility Program helps change a project if needed to help you grow, excel professionally and fulfill your potential
  • Global impact: work on large-scale projects that redefine industries with international and fast-growing clients
  • Welcoming environment: feel empowered with a friendly team, open-door policy, informal atmosphere within the company and regular team-building events

About us:

Seize global opportunities by working with us! 
Enjoy our robust experience in various domains, a caring attitude and incredible team spirit. 
Together we will grow our business in Romania and globally!

Be bold, not bored!

Experiences of tomorrow. Engineered together

Interested already?

We would love to get to know you! Submit your application. Can’t wait to see you at Ciklum.

Apply

Looking for something else?

Find a vacancy that works for you. Send us your CV to receive a personalized offer.

Send CV