Sr. Database Administrator (PostgreSQL / MySQL)
Sr. Database Administrator (PostgreSQL / MySQL)
Employer Active
Job Alert
You will be updated with latest job alerts via email
Share
Job Alert
You will be updated with latest job alerts via email
$ 110000 - 130000
1 Vacancy
Job Description
If youre 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 platformagnostic 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 (12x/wk in office) with growth opportunities in a rapidly evolving industry.
- Professional development and certification support.
- Work with cuttingedge database and cloudbased technologies.
- Collaborative culture with a focus on innovation and automation.
What You Will Do: The Senior OpenSource Database Administrator will lead the deployment administration and optimization of opensource database platforms especially PostgreSQL MySQL as well as MongoDB and MariaDB
How You Will Contribute:
- Provide database management including installation configuration and maintenance of opensource databases to ensure high availability reliability and performance.
- Manage and optimize cloudhosted databases (OCI AWS Azure) and lead migrations from onpremises to cloud or cloudtocloud 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 crossfunctional 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 onpremises 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).
- Indepth PostgreSQL experience at the enterprise level including work with different HA (High Availability) replications.
- Experience with EC2 Postgres
- Expertise in cloudbased 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 highavailability solutions including clustering and replication.
- Strong analytical and troubleshooting skills for diagnosing root cause of issues.
- Experience providing oncall support for missioncritical 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 oncall.
Its 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 candidate
EDUCATION: Bachelors 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
Required Experience:
Senior IC
Employment Type
Full-Time
