Database Administrator

Sr. Database Administrator / Engineer (PostgreSQL / MySQL)

Company: Located in a northern suburb of Pittsburgh, this company is theindustry leader in providing 100% onshore data infrastructure managed service, offering remote Database and Cloud Infrastructure Management, specializing in Oracle, Microsoft, and open source technologies. Through their strategic tech partnerships, highly specialized teams and platform-agnostic approach, they empower companies worldwide to transform their business with the power of data, analytics and the cloud.

What You Will Do: The Senior Open-Source Database Administrator will lead the deployment, administration, and optimization of open-source database platforms, especially PostgreSQL, MySQL, as well as MongoDB and MariaDB

How You Will Contribute:

• Provide database management , including installation, configuration, and maintenance of open-source databases to ensure high availability, reliability, and performance.
• Manage and optimize cloud-hosted databases (OCI, AWS, Azure) and lead migrations from on-premises to cloud or cloud-to-cloud transitions.
• Identify and resolve performance bottlenecks, optimize queries, and ensure database efficiency.
• Implement and enforce database security policies, encryption, and access controls to safeguard sensitive data.
• Develop and maintain robust backup and disaster recovery strategies.
• Work closely with cross-functional teams to support database needs and best practices.
• Leverage automation tools, Ansible, Terraform, Bash, or Python, to streamline database operations.
• Maintain comprehensive documentation of database configurations, procedures, and best practices.

Requirements

Ideal Candidate: Extensive experience managing PostgreSQL and MySQL databases on-premises and in cloud environments such as Amazon Web Services (AWS), Oracle Cloud Infrastructure (OCI), or Microsoft Azure, with a focus on security, performance, and scalability.

What You Bring:

• 8+ years of database administration experience with PostgreSQL and 3+ years MySQL, MongoDB or MariaDB.
• In-depth PostgreSQL experience at the enterprise level and experience with Postgres in AWS
• Expertise in cloud-based database management (OCI, AWS, Azure).(3+ years of work in AWS)
• Strong Linux administration skills for managing database servers.
• Proficiency in SQL performance tuning, query optimization, and index strategies.
• Adept at implementing high-availability solutions, including clustering and replication.
• Strong analytical and troubleshooting skills for diagnosing root cause of issues.
• Experience providing on-call support for mission-critical systems.
• Familiarity with DevOps and CI/CD pipelines for database integration.
• Strong written and verbal English communication skills.
• Present as confident, engaging and able to drive the conversation.
• Must be able and willing to work shift schedules, including on-call.

It's a PLUS if You Also Have:

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

Benefits

What You Get:

• Competitive salary and comprehensive benefits package, including 401(k) match
• Hybrid work environment (1-2x/wk in office) 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.

Qualification

Associate Degree