Database Administrator

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 : - 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. (ref:hirist.tech)

Location: mumbai, IN

Posted Date: 5/1/2025