Timescale Database Developer (Remote)

About Persistent

We are a trusted Digital Engineering and Enterprise Modernization partner, combining deep technical expertise and industry experience to help our clients anticipate what’s next. Our offerings and proven solutions create a unique competitive advantage for our clients by giving them the power to see beyond and rise above. We work with many industry-leading organizations across the world including 14 of the 30 most innovative US companies, 80% of the largest banks in the US and India, and numerous innovators across the healthcare ecosystem.

Our disruptor’s mindset, commitment to client success, and agility to thrive in the dynamic environment have enabled us to sustain our growth momentum by reporting $291.71M revenue in Q2FY24, delivering 14.1% Y-o-Y growth. Our 22,800+ global team members, located in 21 countries, have been instrumental in helping the market leaders transform their industries. We’re also pleased to share that Persistent won the 2023 Golden Peacock Award for Excellence in Corporate Governance within the IT sector. Acknowledging our cloud expertise, we were named a Challenger in the 2023 Gartner® Magic Quadrant™ for Public Cloud IT Transformation Services. Throughout this market-leading growth, we’ve maintained strong employee satisfaction – over 94% of our employees approve of the CEO, and 89% would recommend working at Persistent to a friend.

Position: PostgreSQL & Timescale DB Developer

Key Skills: PostgreSQL, Timescale DB, Timeseries DB & MYSQL

Experience: 5+ years

Remote or Hybrid: Remote

What we are looking:

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).

What you’ll do:

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.

MYSQL: [my.cnf]

1.Connection Settings

2.Performance Settings

3.InnoDB Settings

4.Query Cache

5.Logging

6.Replication

7.Client Settings

8.Security Settings

9.Advanced Performance Settings

10.Security Settings

AQL: [arangod.conf]

1.Network-related settings

2.Server threads

3.JavaScript settings

4.Logging settings

5.RocksDB settings for storage engine

6.Cluster settings

7.Replication settings

8.SSL settings

9.Query optimizer settings

10.HTTP settings

TSDB: [postgresql.conf]

1.General Settings

2.TimescaleDB Settings

3.InnoDB Settings (PostgreSQL)

3.Logging settings

4.Replication settings

5.Memory settings

6.Checkpoint settings

7.Performance settings

8.TimescaleDB specific settings

Benefits:

• Focused on talent development with quarterly assessment cycles and company-sponsored certifications.
• Working with cutting-edge technologies.
• Engagement initiatives such as project parties, flexible work hours, Persistent Business Run.
• Private medical and dental care at Medi cover for an individual, partner and family.
• Life and accident insurance at Allianz covering an individual, partner and family Pension plans (PPK).
• Group personal accident and travel insurance!
• Work from home allowance.
• Reimbursement of expenses related to home office.
• Reimbursement of costs for purchasing glasses/contact lenses
• My Benefit Systems/Multicafateria/Multisport cards.
• Reward and recognition awards.
• Employee referral rewards

Our company fosters a values-driven and people-centric work environment that enables our employees to:

• Grow both professionally and personally.
• Change the world in powerful, positive ways, using the latest technologies.
• Work on collaborative innovation, with diversity and work-life wellbeing at the core.
• Have access to global opportunities to work and learn with the industry’s best talents.

Let’s unleash your full potential at Persistent – persistent.com/careers

“Persistent is an Equal Opportunity Employer and prohibits discrimination and harassment of any kind.”