Sr. Database Administrator (PostgreSQL / MySQL)
Job title: Sr. Database Administrator (PostgreSQL / MySQL) in Pittsburgh, PA at Zaddy Solutions
Company: Zaddy Solutions
Job description: If you're passionate about optimizing databases & solving complex challenges, read on!Company: Located in a northern suburb of Pittsburgh, this company is the industry 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 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.
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 MariaDBHow 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.
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:
7+ years of database administration experience with Aurora Postgres / PostgreSQL and 3+ years MySQL (MongoDB or MariaDB experience is a plus).
In-depth PostgreSQL experience at the enterprise level, including work with different HA (High Availability) replications.
Experience with EC2 Postgres
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.
LOCATION: Local to Pittsburgh, PA or be willing to relocate prior to joining. May consider 100% remote for an exceptional candidateEDUCATION: Bachelor's degree in Computer Science, Information Technology, or a related field (or equivalent work experience).CITIZENSHIP: Must be a US Citizen due to regulations related to the nature of the work
Expected salary:
Location: Pittsburgh, PA
Apply for the job now!
Apply Now
Company: Zaddy Solutions
Job description: If you're passionate about optimizing databases & solving complex challenges, read on!Company: Located in a northern suburb of Pittsburgh, this company is the industry 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 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.
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 MariaDBHow 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.
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:
7+ years of database administration experience with Aurora Postgres / PostgreSQL and 3+ years MySQL (MongoDB or MariaDB experience is a plus).
In-depth PostgreSQL experience at the enterprise level, including work with different HA (High Availability) replications.
Experience with EC2 Postgres
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.
LOCATION: Local to Pittsburgh, PA or be willing to relocate prior to joining. May consider 100% remote for an exceptional candidateEDUCATION: Bachelor's degree in Computer Science, Information Technology, or a related field (or equivalent work experience).CITIZENSHIP: Must be a US Citizen due to regulations related to the nature of the work
Expected salary:
Location: Pittsburgh, PA
Apply for the job now!
Apply Now