At a Glance
- Tasks: Administer hybrid databases and ensure seamless data flow for analytics.
- Company: Dynamic tech team in the heart of London, focused on innovation.
- Benefits: Competitive salary, flexible working hours, and opportunities for professional growth.
- Other info: Fast-paced environment with a focus on collaboration and continuous learning.
- Why this job: Join a cutting-edge team and make an impact in the financial trading sector.
- Qualifications: Expertise in PostgreSQL, ClickHouse, and Snowflake required.
The predicted salary is between 60000 - 80000 € per year.
Key Responsibilities
- Multi-Engine Management: Administer a hybrid database environment, ensuring seamless data flow between PostgreSQL (Live Trading) and ClickHouse/Snowflake (Analytics).
- Data Movement & ETL: Own the reliability of CDC pipelines that stream data from production Postgres instances into the analytical layer.
- Schema Evolution: Manage schema changes across different engines, ensuring that transactional data models translate effectively into columnar formats for analytics.
- Monitoring & Cost Governance: Implement unified observability for the entire stack. Specifically, monitor Snowflake credit usage and ClickHouse resource utilization to ensure peak ROI.
- Automation: Use Python, Bash and/or Ansible to automate routine maintenance tasks and deployments and monitoring services.
Technical Stack
- Primary Transactional: PostgreSQL (Self-managed on EC2/K8s and AWS RDS/Aurora).
- Real-Time Analytics: ClickHouse (used for sub-second telemetry, high-throughput event logging, and real-time trading dashboards).
- Data Warehousing: Snowflake (our central source of truth for cross-team BI, regulatory reporting, and historical trend analysis).
- Orchestration: Kubernetes (EKS), Terraform, Ansible and on prem.
- Data Pipelines: Kafka, CDC (Change Data Capture) tools like Debezium.
Technical Requirements
- Essential
- Expert-level knowledge of PostgreSQL (Performance tuning, vacuuming, indexing).
- Hands-on experience with ClickHouse (managing clusters, MergeTree engines, and tuning for high-concurrency).
- Proficiency in Snowflake administration (RBAC, Warehouse sizing, Snowpipe, and Task management).
- Experience with AWS (specifically RDS and Aurora).
- Proficiency in Linux/Unix administration and shell scripting.
- Knowledge of monitoring tools (e.g., Prometheus, Grafana, CloudWatch).
- Desirable
- Knowledge of the betting or financial trading industry.
- Relevant certifications (AWS Certified Database, Postgres Professional).
Soft Skills
- Problem Solver: You enjoy "under the hood" troubleshooting and RCA (Root Cause Analysis).
- Calm Under Pressure: Ability to handle high-stakes production incidents effectively.
- Communicator: Can translate complex technical database issues to non-technical stakeholders.
- Team Player: Enthusiastic about knowledge sharing and mentoring others.
DBA - City of London employer: UA Consulting
As a leading employer in the heart of the City of London, we offer an innovative work culture that fosters collaboration and continuous learning. Our commitment to employee growth is reflected in our comprehensive training programmes and mentorship opportunities, ensuring that you can advance your career while working with cutting-edge technologies in a dynamic environment. Join us to be part of a team that values your contributions and supports your professional journey in the fast-paced world of data management.
StudySmarter Expert Advice🤫
We think this is how you could land DBA - City of London
✨Tip Number 1
Network like a pro! Get out there and connect with folks in the industry. Attend meetups, webinars, or even just grab a coffee with someone who works in data management. You never know when a casual chat could lead to your next big opportunity.
✨Tip Number 2
Show off your skills! Create a portfolio or GitHub repository showcasing your projects, especially those involving PostgreSQL, ClickHouse, or Snowflake. This gives potential employers a taste of what you can do and sets you apart from the crowd.
✨Tip Number 3
Prepare for interviews by brushing up on your technical knowledge and soft skills. Be ready to discuss your experience with database management, troubleshooting, and how you handle pressure. Practice common interview questions and have examples ready to share.
✨Tip Number 4
Don’t forget to apply through our website! We love seeing applications directly from candidates who are excited about joining our team. Plus, it’s a great way to ensure your application gets the attention it deserves.
We think you need these skills to ace DBA - City of London
Some tips for your application 🫡
Tailor Your CV:Make sure your CV reflects the skills and experiences that match the DBA role. Highlight your expertise in PostgreSQL, ClickHouse, and Snowflake, and don’t forget to mention any relevant projects or achievements!
Craft a Compelling Cover Letter:Your cover letter is your chance to shine! Use it to explain why you’re passionate about database management and how your background makes you a perfect fit for our team. Keep it engaging and personal!
Show Off Your Technical Skills:When filling out your application, be specific about your technical skills. Mention your experience with automation tools like Python and Ansible, and any monitoring tools you’ve used. We love seeing real examples of your work!
Apply Through Our Website:We encourage you to apply directly through our website. It’s the best way for us to receive your application and ensures you don’t miss out on any important updates from our team!
How to prepare for a job interview at UA Consulting
✨Know Your Tech Stack
Make sure you brush up on your knowledge of PostgreSQL, ClickHouse, and Snowflake. Be ready to discuss your hands-on experience with these technologies, especially performance tuning and managing clusters. The more specific examples you can provide, the better!
✨Showcase Your Problem-Solving Skills
Prepare to share instances where you've tackled complex database issues or production incidents. Highlight your approach to troubleshooting and root cause analysis, as this role requires a calm and methodical mindset under pressure.
✨Communicate Clearly
Practice explaining technical concepts in simple terms. You’ll need to demonstrate that you can translate complex database issues to non-technical stakeholders. This skill is crucial for effective collaboration within teams.
✨Demonstrate Automation Know-How
Be ready to discuss how you've used Python, Bash, or Ansible for automating tasks. Share specific examples of how automation has improved efficiency in your previous roles, as this will show your proactive approach to routine maintenance.
