Remote Senior PostgreSQL DBA

Dice is the leading career destination for tech experts at every stage of their careers. Our client, FriendFinder Networks, Inc., is seeking the following. Apply via Dice today!This is a 100% remoteThe initial screening with Human Resources will be by a 15 minute video conference: All cameras must be turned onAll interviews will be by video with manager and hiring team: All cameras must be turned onRemote Senior PostgreSQL DBA MUST live in the United States and be authorized to work in the United StatesThis 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 DOFriendFinder 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 DOMatter 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 tasksand Resolve Database performance issues.and implement automated solutions by leveraging DevOps constructworkarounds for known errors and initiate process improvements.logical and physical data models and schemasguidance on migration of on-premises workloads to the k8smaintenance tasks like Vacuuming, Clustering, Reindex, AnalyzeTablespaces, 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 databasesWHAT YOU MUST HAVEyears of experience managing PostgreSQL / MySQL databases in a production environmentsupporting 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 communityto work off-hours as needed and be on-callexperience 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_basebackupworking with Kubernetes (Provision Postgres in k8s and setting database backups in k8s).working collaboratively with application development teams to implement solutionsknowledge of SQL and database related technologies.to work under pressure, handling multiple assignments, and additional responsibilities.team player with strong analytical, communication and troubleshooting skillsWHAT IS PREFERABLE TO HAVEof and experience with replication between multiple database instancesunderstanding of Linux operating systemproficient with tuning, diagnostic, and backup of PostreSQL and MySQLto write/hack PERLexperience (desirable)experience with Dataguardexperience with MyISAM/InnoDB/ClusterWHAT YOU SHOULD BE ABLE TO DEMONSTRATEto communicate effectively and work cooperatively with development and operationsverbal and written communication skillsanalytical, troubleshooting, and problem-solving skillsorganizational skills; ability to handle multiple projects simultaneously while meeting deadlinesa high degree of honesty and integritybe team-player, positive attitude and flexibleREPORTING TO THIS POSITION: No direct reportsPERKSFriendFinder 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 periodMedical (Kaiser HMO, Blue Shield), Dental, and VisionFlexible Spending Account for Healthcare and Dependent CareLife Insurance, AD&D, LTD and Short and Long Term DisabilityPaid Time Off (20 days PTO) and Holiday Pay (12 company paid holidays off)Employee Assistance ProgramCommuter BenefitsTuition ReimbursementHealth Club ReimbursementCasual Dress CodeTattoo FriendlyLGBTQ Friendly PythonABOUT USWE ARE PASSIONATE ABOUT WHAT WE DONot 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 PEOPLEThe 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 FORMSFriendFinder 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.