Database Engineer

Summary:

Plans computerized databases, including base definition, structure, documentation, long-range requirements, operational guidelines and protection. Ensures accuracy and completeness of data in master files and various support tools, such as base dictionaries. Establishes and maintains security and integrity controls. Formulates and monitors policies, procedures and standards relating to database management. Proposes and implements enhancements that will improve the performance and reliability of the system.

Duties & Responsibilities:

Job Description Summary

Need Database Administrator to support and work on PostgreSQL & TimescaleDB

 database for the product team.

Hiring Requirements

Job Description

We are seeking a Database Engineer to build and monitor complex databases and make sure that these databases are operational and provide relevant and valid data.

Timescale is building the world’s next great database company on top of industry-standard PostgreSQL, and we need your help!  We need extraordinary database engineers to join our team.

You will design, code, and test the core of our PostgreSQL-based time-series database. We focus on building a scalable, reliable, robust, usable, secure, and performant database. You should have strong systems-building experience and expertise in C, understand both query optimization and database systems and ideally already be a PostgreSQL expert (or show an interest and quick aptitude to become a PostgreSQL expert).

Responsibilities:

MYSQL:

1.Provision MySQL instances, both in clustered and non-clustered configurations

2.Set up and manage MySQL replication, including master-slave and master-master configurations.

3.Implement high availability solutions, such as clustering and failover strategies.

4.Perform routine maintenance tasks such as database cleanup, reindexing, and updating statistics.

5.Ensure database design adheres to best practices and meets performance and scalability requirements.

6.Develop scripts and automation tools to streamline database management tasks.

7.Performed database migration from MyISAM format to Innodb storage engine.

TSDB:

1.Install, configure, and upgrade TimescaleDB software.

2.Set up database instances, clusters, and extensions required for TimescaleDB.

3.Set up and manage replication and high availability solutions.

4.Implement clustering and failover strategies to ensure database availability

5.Manage multi-node TimescaleDB deployments for horizontal scalability.

6.Ensure data distribution and replication are configured correctly across nodes.

7.Use TimescaleDB-specific features like continuous aggregates and data retention policies.

8.Design and implement database schemas, hypertables, and indexes.

9.Implement and manage data compression to optimize storage and performance.

10.Set up and manage data retention policies to automatically remove old data.

AQL:

1.Cluster Setup: Design and deploy ArangoDB clusters for horizontal scalability and high availability.

2.Sharding: Implement and manage sharding strategies to distribute data across multiple nodes effectively.

3.Replication: Configure and manage replication to ensure data availability and redundancy.

4.Troubleshoot and resolve database issues, including performance problems, data inconsistencies, and configuration errors.

5.Configure and deploy an ArangoDB cluster with appropriate replication and sharding settings.

Technical Skills

• Database Systems: Proficiency with various database systems (e.g., MySQL, PostgreSQL, Timescale, Arango, Oracle, SQL Server, MongoDB, Cassandra).
• SQL and NoSQL: Advanced SQL skills and knowledge of NoSQL databases.
• Big Data Technologies: Experience with big data technologies like Hadoop, Spark, Kafka, and data warehousing solutions (e.g., Redshift, BigQuery, Snowflake).
• Replication and Clustering: Knowledge of replication and clustering techniques.
• Problem-Solving: Strong analytical and problem-solving skills to address complex data challenges.

Configuration Areas:

• availability.

Additional Job Description

• Bachelor's degree in Computer Science / IT/Computing or equivalent
• 5+ years of experience in Database Administration and Query Finetuning.
• Significant proficiency/in-depth knowledge in the domain (technology and/or products)
• Experience with Telecom Product development with TMF standards preferred
• Experience building scalable SaaS platform clear advantage.

Pre-Requisites / Skills / Experience Requirements: