Home

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

Back to top