Uncategorized

2008-05-14 Postgres Database Administrator

Location: Beverly Hills, CA

Please send resumes to ruth.elias@fox.com

Postgres Database Administrator

Fox Interactive Media (FIM), a start-up division of News Corporation, is seeking a Postgres Database Administrator to work on a series of dynamic and innovative projects. The FIM Production Team will be charged with providing top-tier solutions to complex challenges in support of major initiatives in the areas of Sports, Entertainment and News.

Projects may include:

  1. Enterprise-wide data collection system
  2. Global user segmentation system
  3. Add serving system
  4. Integrated data analytics system to report performance across all of FIM’s online properties

This is a dynamic role where DBA will be responsible for Database Architecture, Database Design, Database Administration / Maintenance, and Database Development of a large-scale Postgres 8.x database environment.

Design and Analysis

  • Conduct fact gathering sessions with customers.
  • Develop project estimates for database tasks.
  • Participate in group application design & architecture activities.
  • Provide technical assistance and guidance to engineering staff.
  • Develop database design documentation

Development and Testing

  • Develops new complex database solutions according to defined application requirements.
  • Performs Unit Testing and debugging of applications.
  • Provides database support through all testing phases and general releases of software.
  • Adheres to department programming standards and methodology.

Production Support

  • Manage database capacity planning
  • Create and execute scripts for various database maintenance activities.
  • Perform database tuning including monitoring, troubleshooting and optimizing performance.
  • Plan and perform database software installations, upgrades, and patches
  • Implement database backup and recovery strategies including high availability
  • Troubleshoot and tune Postgres database for optimal performance
  • Serve as escalation point for database issues

Administrative

  • Work as a member of a cross-functional, integrated development team.
  • Work with the other Engineers to continually improve development standards and other departmental processes and documentation.
  • Communicates plans, status and issues to management on a regular basis.
  • Adheres to department standards, policies, procedures and industry best practices.

Technical Skills and Experience

  • Recent experience with Postgres 8.x and the development of views, functions, triggers.
  • Design, implement, and operate 24x/7 high availability Postgres production and development databases.
  • Define and implement maintenance procedures including Disaster Recovery, HA, DB maintenance, Backup solution, etc.
  • Plan and support the implementation of major architectural changes.
  • Provide direction in capacity planning, performance improvements, and storage management in partnership with System Operations and Development teams.
  • Ongoing performance analysis, monitoring, troubleshooting, and resolution of issues.
  • Interface with System operations and vendors to resolve problems with application/database systems.
  • Knowledge of Linux & Unix operating system and scripting language.
  • On-call support for production systems.
  • Good understanding of relational database design concepts.
  • Knowledge and experience in Logical and Physical Data Modeling.
  • Strong Database Troubleshooting and Problem Resolution skills.
  • Contribute to and update systems documentation as required.
  • Capable of translating complex business needs into technical solutions.
  • Nice to have MySQL experience.

Qualification

  • 8+ years software industry experience.
  • 5+ years Database Administration experience.
  • 3+ years SQL development experience.
  • Bachelor's degree required, preferably in Computer Science.
  • Postgres configuration and performance tuning experience.
  • Experience in high transaction rate OLTP environment and supporting VLDBs (Terabyte +).
  • Strong interpersonal and relationship building skills conducive to team development.
  • Excellent communication skills, both written and verbal.

    Michelle Muniz
    Recruitment Analyst, Talent Acquisition
    Fox Interactive Media
    Tel: 310-969-2831
    Fax: 310-969-7021
    michelle.muniz@fox.com

  • How to do silent installation of postgres in linux and solaris

    ranjitpune's picture
    How to do silent installation of postgres in linux and solaris

    I have been trying for silent installation of postgres on linux and solaris but I am only able to find it for windows using msi (only specific to windows) .Please help me with this.............

    2008-04-21 Postgres DBA

      This is a dynamic role where DBA will be responsible for Database
      Architecture, Database Design, Database Administration / Maintenance, and
      Database Development of a large-scale Postgres 8.x database environment.

    • Design and Analysis
      Conduct fact gathering sessions with customers.
      Develop project estimates for database tasks.
      Participate in group application design & architecture activities.
      Provide technical assistance and guidance to engineering staff.
      Develop database design documentation

    • Development and Testing
      Develops new complex database solutions according to defined application
      requirements.
      Performs Unit Testing and debugging of applications.
      Provides database support through all testing phases and general releases
      of software.
      Adheres to department programming standards and methodology.

    • Production Support
      Manage database capacity planning
      Create and execute scripts for various database maintenance activities.
      Perform database tuning including monitoring, troubleshooting and
      optimizing performance.
      Plan and perform database software installations, upgrades, and patches
      Implement database backup and recovery strategies including high
      availability
      Troubleshoot and tune Postgres database for optimal performance
      Serve as escalation point for database issues

    • Administrative
      Work as a member of a cross-functional, integrated development team.
      Work with the other Engineers to continually improve development standards
      and other departmental processes and documentation.
      Communicates plans, status and issues to management on a regular basis.
      Adheres to department standards, policies, procedures and industry best
      practices.

    • Technical Skills and Experience
      Recent experience with Postgres 8.x and the development of views,
      functions, triggers.
      Design, implement, and operate 24x/7 high availability Postgres production
      and development databases.
      Define and implement maintenance procedures including Disaster Recovery,
      HA, DB maintenance, Backup solution, etc.
      Plan and support the implementation of major architectural changes.
      Provide direction in capacity planning, performance improvements, and
      storage management in partnership with System Operations and Development
      teams.
      Ongoing performance analysis, monitoring, troubleshooting, and resolution
      of issues.
      Interface with System operations and vendors to resolve problems with
      application/database systems.
      Knowledge of Linux & Unix operating system and scripting language.
      On-call support for production systems.
      Good understanding of relational database design concepts.
      Knowledge and experience in Logical and Physical Data Modeling.
      Strong Database Troubleshooting and Problem Resolution skills.
      Contribute to and update systems documentation as required.
      Capable of translating complex business needs into technical solutions.
      Nice to have MySQL experience.

    • Qualification
      8+ years software industry experience.
      5+ years Database Administration experience.
      3+ years SQL development experience.
      Bachelor's degree required, preferably in Computer Science.
      Postgres configuration and performance tuning experience.
      Experience in high transaction rate OLTP environment and supporting VLDBs
      (Terabyte +).
      Strong interpersonal and relationship building skills conducive to team
      development.
      Excellent communication skills, both written and verbal.

      Candace Bowden
      Account Manager/Recruiter
      Sharf, Woodward & Associates
      5900 Sepulveda Blvd Suite 104
      Sherman Oaks CA 91411
      Ph: 818/989-2200 ext 241
      Toll Free: 877-482-6687 ext 241
      Fax: 818-756-6726
      email: cbowden@swjobs.com
      website: www.swjobs.com
      http://www.linkedin.com/pub/3/a53/a02

    Oops!

    Looks like you don't have permission to access this page! You can create an account here!

    PDXPUG Day

    What: All-day PostgreSQL one-track mini-conference
    When: Sunday, July 20th, 9am to 5pm, possible party afterwards
    Who: PDXPUG will select speakers
    Where: Portland Convention Center, Portland, Oregon

    We are looking for speakers for the PostgreSQL Day. PDXPUG wants four hour-long sessions and one 2.5-hour workshop. Please e-mail selena -at- postgresql.org with your offer to speak and speakers will be selected in mid-April.

    --

    Our first organizing meeting will be at 6:30pm, May 14, 2008 at FreeGeek. Just before the PDXPUG meeting.

    LAPUG Meeting Schedule

    May 30 - Friday 7:00 P.M.

      Keith Larson - Making Non-Trivial Views Update-able.
      CalPoly Pomona

    June 27 - Friday 7:00 P.M.

      Juan Jose Natera - Examples using PL-Perl.
      Hold for Location

    Where would you like to meet?

    spug's picture
    Brandon
    100% (1 vote)
    Ybor City
    0% (0 votes)
    Downtown St Pete
    0% (0 votes)
    Lakeland
    0% (0 votes)
    Tampa Airport Area
    0% (0 votes)
    Clearwater Airport Area
    0% (0 votes)
    Downtown Clearwater
    0% (0 votes)
    Bradenton
    0% (0 votes)
    Other
    0% (0 votes)
    Roving (alternating locations)
    0% (0 votes)
    Total votes: 1

    RESCHEDULED: ATLPUG Opening meeting

    atlpug's picture

    Hey, y'all; due to a pair of funerals I've attended these past few days, I'm behind on meeting planning. Let's have the first meeting next Tuesday, March 18th, at 6:30 PM in the Buckhead Borders (in the upstairs coffee lounge). At the meeting, we'll look at a pair of PostgreSQL LiveCDs, discuss organization of the Atlanta-Area PostgreSQL User Group, talk about upcoming conferences (PostgreSQL Conference EAST and PGCon 2008), and generally geek out over the world's most advanced open source DB. ;)

    Leave a comment or drop an email to atlpug@postgresql.org if you're planning on attending; I look forward to seeing all of y'all next week! :)

    TEst

    selenamarie's picture

    testing test test test

    PostgreSQL User Groups

    Welcome!

    Below is a list of current user groups and their home pages:

    Africa

    Asia

    Europe

    • France
    • Germany
      • PGUG (PostgreSQL Usergroup Germany)
    • Italy
      • IT-PUG, Italian PostgreSQL Users Group
      • Psql.it, Comunita Italiana utenti e sviluppatori PostgreSQL
    • United Kingdom

    North America

    Oceania

    South America

    Syndicate content

    Back to top