Job #1

From: cbowden(at)swjobs(dot)com
To: "Richard Broersma" <richard(dot)broersma(at)gmail(dot)com>
Cc: pgsql-jobs(at)postgresql(dot)org
Subject: Job #1
Date: 2008-04-14 17:32:10
Message-ID: OF5F3D0AFF.D08982E2-ON0825742B.00603166-8825742B.005FF13A@swjobs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: lapug pgsql-jobs

Hi there

Here is the job I would like to place.....Is this ok?

Its for an Entertainment company in Santa Monica

Postgres Database Administrator

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(at)swjobs(dot)com
website: www.swjobs.com
http://www.linkedin.com/pub/3/a53/a02

In response to

  • Re: at 2008-04-12 01:50:13 from Richard Broersma

Responses

  • Re: Job #1 at 2008-04-14 17:25:45 from Richard Broersma

Browse lapug by date

  From Date Subject
Next Message Richard Broersma 2008-04-15 17:39:59 Meeting Locations for May and June
Previous Message Richard Broersma 2008-04-14 17:25:45 Re: Job #1

Browse pgsql-jobs by date

  From Date Subject
Next Message Sproule, Emily A 2008-04-16 20:12:23 Job Announcement
Previous Message Richard Broersma 2008-04-14 17:25:45 Re: Job #1