Database Administrator (3-5 yrs)

Responsibilities :

- Build scalable, resilient and cost-effective data storage solutions to support complex data pipelines.

- The DBA is responsible for designing and maintaining the different tiers of the data storage, including (but not limited to) archival, long-term persistent storage, transactional and reporting storage.

- Design, implement and maintain various data pipelines such as self-service ingestion tools, exports to application-specific warehouses, and indexing activities.

- The DBA is responsible for data modeling, as well as designing, implementing and maintaining various data catalogs, to support data transformation and product requirements.

- Configure and deploy databases on AWS cloud, ensuring optimal performance and scalability.

- Monitor database activities for compliance and security purposes.

- Set up and manage backup and recovery strategies for cloud databases ensuring availability and quality.

- Monitor database performance metrics and identify areas for optimisation.

- Create scripts for database configuration and provisioning.

- Collaborate with Data Science to understand, translate, and integrate methodologies into engineering build pipelines.

- Partner with product owners to translate complex business requirements into technical solutions, imparting design and architecture guidance.

- Provide expert mentorship to project teams on technology strategy, cultivating advanced skill sets in software engineering and modern SDLC.

- Stay informed about the latest technologies and methodologies by participating in industry forums, having an active peer network, and engaging actively with customers.

- Cultivate a team environment focused on continuous learning, where innovative technologies are developed and refined through teamwork.

Required :

- Experience with languages such as ANSI SQL, TSQL, PL/pgSQL,

- PLSQL, plus database design, normalization, server tuning, and query plan optimization.

- 3+ years of professional DBA experience with large datastores including HA and DR planning and support.

- Software Engineering experience with programming languages such as Java, Scala, and Python.

- Demonstrated understanding and experience with big data tools such as Kafka, Spark and Trino/Presto

- Experience with orchestration tools such as Airflow

- Comfortable using Docker and Kubernetes for container management.

- DevOps experience deploying and tuning the applications you've built.

- Monitoring tools such as Datadog, Prometheus, Grafana, Cloudwatch.