Sr. Database Administrator (PostgreSQL / MySQL)

Job title: Sr. Database Administrator (PostgreSQL / MySQL) in Pittsburgh, PA at Professional Recruiting Consultants

Company: Professional Recruiting Consultants

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.

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

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

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

Expected salary:

Location: Pittsburgh, PA

Apply for the job now!

[ad_2]

Apply for this job