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:
- Enterprise-wide data collection system
- Global user segmentation system
- Add serving system
- 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
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
Posted May 13th, 2008 by ranjitpune2008-04-21 Postgres DBA
-
This is a dynamic role where DBA will be responsible for Database
- 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
Architecture, Database Design, Database Administration / Maintenance, and
Database Development of a large-scale Postgres 8.x database environment.
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 LocationWhere would you like to meet?
Posted March 11th, 2008 by spugRESCHEDULED: ATLPUG Opening meeting
Posted March 11th, 2008 by atlpugHey, 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! :)
- atlpug's blog
- Login or register to post comments
PostgreSQL User Groups
Welcome!
Below is a list of current user groups and their home pages:
Africa
- Morocco
- South Africa
- Tunisia
Asia
- China
- Japan
- Western Asia
Europe
- France
- Germany
- PGUG (PostgreSQL Usergroup Germany)
- Italy
- United Kingdom
North America
- Canada
- USA
- Atlanta
- Austin, TX
- Baltimore, MD / Washington DC
- Los Angeles
- New York
- Mid-Atlantic District
- Ohio
- Philadelphia
- Portland
- San Francisco
- Suncoast (Tampa, Central Florida)
- Utah Database Users Group, contact Joshua Tolley
Oceania
- Australia
- New Zealand
South America
- Brazil
- Peru
- Venezuela



