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