Remote Senior PostgreSQL DBA

Overview

Remote
$120,000 - $150,000
Full Time

Skills

Clustering
Kubernetes
MySQL
performance tuning
PostgreSQL
Perl
Bash
pg_hba.conf
DevOps
Ansible

Job Details

  • This is a 100% remote
  • The initial screening with Human Resources will be by a 15 minute video conference: All cameras must be turned on
  • All interviews will be by video with manager and hiring team: All cameras must be turned on
  • Remote Senior PostgreSQL DBA MUST live in the United States and be authorized to work in the United States
  • This is a full-time job as a FriendFinder Networks employee. This is not a C2C, 1099, or Contract to Hire, and is not negotiable.

WHAT YOU WILL DO

FriendFinder Networks is looking for a talented Senior PostreSQL (With MySQL) Database Administrator is responsible for the installation, configuration, upgrading, monitoring, maintenance, security, and administration of databases. S/he will create and administer databases, ensure data integrity, backup and recovery of data, performance tuning, restores for mission critical systems, and resolve production issues. Your contributions will ensure the best possible user experience for everyone who visits our web sites 24 hours a day, every day of the year, all over the world.

WHAT YOU WILL DO

  • Matter Expert for Database Product and functionalities in PostgreSQL and MySQL.
  • all aspects of day-to-day PostgreSQL operations including installation, patching, upgrades, managing users, looking into performance, help users with improving queries and look after backups.
  • diligently to respond to urgent projects and tasks
  • and Resolve Database performance issues.
  • and implement automated solutions by leveraging DevOps construct
  • workarounds for known errors and initiate process improvements.
  • logical and physical data models and schemas
  • guidance on migration of on-premises workloads to the k8s
  • maintenance tasks like Vacuuming, Clustering, Reindex, Analyze
  • Tablespaces, Schemas, Users, profiles and implementing various adjustments in postgresql.conf file and granting users and application access through pg_hba.conf file etc.
  • database issues, maintain database systems availability, stability, and scalability.
  • as mentor and adviser for team members.
  • database installation, upgrade, patching, maintenance, security functions.
  • database operations and adhere to Change Management policies and procedures.
  • SQLs statements to ensure optimal performance.
  • database issues, maintain database systems availability, stability, and scalability.
  • and Enforce standards, policies, and procedures for managing databases

WHAT YOU MUST HAVE

  • years of experience managing PostgreSQL / MySQL databases in a production environment
  • supporting production database environments greater than 3TB.
  • with table partitioning and replication.
  • knowledge of PostgreSQL / MySQL functionality and features.
  • troubleshooting database and SQL performance issues.
  • working collaboratively with application development teams to implement solutions.
  • stays up to date with PostgreSQL / MySQL news or is involved with community
  • to work off-hours as needed and be on-call
  • experience in production support and maintenance of high availability database systems with ability to manage large scale database projects.
  • of Scripting (shell, Perl, or Python, etc.) and automation tools (Ansible, chef, git, etc.)
  • in PostgreSQL / MySQL replication, backups and recovery strategies.
  • working with pg_basebackup
  • working with Kubernetes (Provision Postgres in k8s and setting database backups in k8s).
  • working collaboratively with application development teams to implement solutions
  • knowledge of SQL and database related technologies.
  • to work under pressure, handling multiple assignments, and additional responsibilities.
  • team player with strong analytical, communication and troubleshooting skills

WHAT IS PREFERABLE TO HAVE

  • of and experience with replication between multiple database instances
  • understanding of Linux operating system
  • proficient with tuning, diagnostic, and backup of PostreSQL and MySQL
  • to write/hack PERL
  • experience (desirable)
  • experience with Dataguard
  • experience with MyISAM/InnoDB/Cluster

WHAT YOU SHOULD BE ABLE TO DEMONSTRATE

  • to communicate effectively and work cooperatively with development and operations
  • verbal and written communication skills
  • analytical, troubleshooting, and problem-solving skills
  • organizational skills; ability to handle multiple projects simultaneously while meeting deadlines
  • a high degree of honesty and integrity
  • be team-player, positive attitude and flexible

REPORTING TO THIS POSITION: No direct reports

PERKS

FriendFinder Networks Inc. and its subsidiaries offer a business casual work environment, flexible work hours, and a competitive salary. The benefits package includes:

  • 401(k) with a 6% match on eligible earnings with no vesting period
  • Medical (Kaiser HMO, Blue Shield), Dental, and Vision
  • Flexible Spending Account for Healthcare and Dependent Care
  • Life Insurance, AD&D, LTD and Short and Long Term Disability
  • Paid Time Off (20 days PTO) and Holiday Pay (12 company paid holidays off)
  • Employee Assistance Program
  • Commuter Benefits
  • Tuition Reimbursement
  • Health Club Reimbursement
  • Casual Dress Code
  • Tattoo Friendly
  • LGBTQ Friendly Python

ABOUT US

WE ARE PASSIONATE ABOUT WHAT WE DO

Not only do we love what we do, but we truly believe in it. We grow through positive education, skill training, courses, big stories, and big dreams. We are constantly improving and striving for perfection to revolutionize and enhance the lives of our members.

WE CARE ABOUT PEOPLE

The main precondition of any relationship is the ability to put ourselves in someone else s shoes to truly understand them. Satisfied customers, employees, and business partners are not just a cog in the wheel, but the main ingredient of the company s success.

WE EMBRACE DIVERSITY IN ALL FORMS

FriendFinder Networks has embraced diversity from the beginning of its history dating back to the mid-1990s. We created the first online personals sites for gays and lesbians, for non-English-speaking audiences, and for those who enjoy what was once called "alternative lifestyles". Headquartered in San Francisco / Silicon Valley and staffed throughout the world, our team also relies on diversity of background, perspectives, and ideas.