VIAVI Solutions Logo

VIAVI Solutions

Database Engineer

Job Posted 13 Days Ago Posted 13 Days Ago
Be an Early Applicant
2 Locations
Senior level
2 Locations
Senior level
The Database Engineer will design, implement, and manage various databases, ensuring system performance, reliability, and high availability while optimizing database operations and implementing best practices.
The summary above was generated by AI

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:

Top Skills

Arangodb
BigQuery
Hadoop
Kafka
MySQL
NoSQL
Postgres
Redshift
Snowflake
Spark
SQL
Timescaledb

Similar Jobs

7 Days Ago
Mumbai, Maharashtra, IND
Senior level
Senior level
Aerospace • Software • Transportation
The Senior NoSQL Database Engineer will manage Cassandra database operations, including installation, upgrades, performance tuning, and clustering while ensuring security and scalability.
Top Skills: CassandraCloud TechnologiesConfluenceItilLinuxShell ScriptingUnix
Mid level
Fintech
The role involves designing, developing, and optimizing database solutions in a global agile team while managing the full software development lifecycle.
Top Skills: Ms Sql ServerOraclePl/Sql
17 Days Ago
Magarpatta, Hadapsar, Pune, Maharashtra, IND
Senior level
Senior level
Fintech • Financial Services
The Database Engineer will manage the Software Development Lifecycle, optimize databases, ensure disaster recovery, and support agile team activities.
Top Skills: ArtefactoryJIRAOracle Cloud At CustomerOracle ExadataOracle RacPostgresPythonTeamcityUcdUnix Shell Scripting

What you need to know about the Pune Tech Scene

Once a far-out concept, AI is now a tangible force reshaping industries and economies worldwide. While its adoption will automate some roles, AI has created more jobs than it has displaced, with an expected 97 million new roles to be created in the coming years. This is especially true in cities like Pune, which is emerging as a hub for companies eager to leverage this technology to develop solutions that simplify and improve lives in sectors such as education, healthcare, finance, e-commerce and more.
By clicking Apply you agree to share your profile information with the hiring company.

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account