ASSYST, Inc.

Senior Open-Source Database Engineer

Category: Managed Information Technology Services (Data Management)

Location: Warrendale, PA 16066

Citizenship Required: United States Citizenship

Telecommute: On-site (Hybrid)

Shift: 1st Shift with On-Call

Company Overview:

DataStrike is the industry leader in 100% onshore database, cloud and business intelligence managed services - enabling companies to harness IT changes as a catalyst for growth. With a network of highly specialized experts, strategic partnerships with the world's biggest technology providers and a platform-agnostic approach, DataStrike provides innovative solutions and practical guidance to accelerate digital transformation initiatives and drive better business outcomes for small- to mid-sized businesses. Founded in 2008, the company maintains more than 200 clients across North America and is headquartered in Pittsburgh, PA. To learn more about DataStrike's services and capabilities, please visit datastrike.com.

Position Overview:

We are seeking a Senior Open-Source Database Administrator to lead the deployment, administration, and optimization of open-source database platforms, including PostgreSQL, MySQL, MariaDB, and MongoDB. The ideal candidate has extensive experience managing PostgreSQL databases on-premises and in cloud environments such as Oracle Cloud Infrastructure (OCI), Amazon Web Services (AWS), or Microsoft Azure, with a focus on security, performance, and scalability.

Key Responsibilities:

· Database Management: Install, configure, and maintain open-source databases to ensure high availability, reliability, and performance.

· Cloud Integration: Manage and optimize cloud-hosted databases (OCI, AWS, Azure) and lead migrations from on-premises to cloud or cloud-to-cloud transitions.

· Performance Tuning: Identify and resolve performance bottlenecks, optimize queries, and ensure database efficiency.

· Security & Compliance: Implement and enforce database security policies, encryption, and access controls to safeguard sensitive data.

· Backup & Recovery: Develop and maintain robust backup and disaster recovery strategies.

· Collaboration & Support: Work closely with cross-functional teams to support database needs and best practices.

· Automation & Scripting: Leverage automation tools, Ansible, Terraform, Bash, or Python, to streamline database operations.

· Documentation: Maintain comprehensive documentation of database configurations, procedures, and best practices.

Qualifications:

· 7+ years of database administration experience with PostgreSQL and 3+ years MySQL, MariaDB, or MongoDB in a fast-paced environment.

· Expertise in cloud-based database management (OCI, AWS, Azure).

· Strong Linux administration skills for managing database servers.

· Proficiency in SQL performance tuning, query optimization, and index strategies.

· Experience implementing high-availability solutions, including clustering and replication.

· Strong analytical and troubleshooting skills for diagnosing root cause of issues.

· On-call support availability for mission-critical systems.

· Familiarity with DevOps and CI/CD pipelines for database integration.

· Strong written and verbal communication skills.

Bonus:

· Experience working with BI, ETL or Data Warehouse tools such as Qlik, Redshift, Snowflake, Databricks, etc.

· Experience automating database deployments or maintenance using Ansible, Terraform, or Kubernetes.

· Certifications in OCI, AWS, Azure, or database technologies.

· Experience migrating Oracle databases to PostgreSQL.

Why Join DataStrike?

· Competitive salary and comprehensive benefits package.

· Hybrid work environment with growth opportunities in a rapidly evolving industry.

· Professional development and certification support.

· Work with cutting-edge database and cloud-based technologies.

· Collaborative culture with a focus on innovation and automation.

If you're a seasoned Open-Source DBA looking to take on high-impact projects in a fast-paced environment, we'd love to hear from you!

Job Type: Full-time

Pay: $110,000.00 - $130,000.00 per year

Benefits:

• 401(k)
• 401(k) matching
• Dental insurance
• Health insurance
• Life insurance
• Paid time off
• Vision insurance

Schedule:

• Day shift
• Monday to Friday
• On call

Experience:

• AWS: 3 years (Preferred)
• MySQL: 3 years (Preferred)
• MongoDB: 3 years (Preferred)
• MariaDB: 3 years (Preferred)
• PostgreSQL: 7 years (Required)

Ability to Commute:

• Warrendale, PA (Required)

Work Location: Hybrid remote in Warrendale, PA