PostgreSQL Database Administrator

Company Name: S & B Consulting Group
Location: Dallas, TX United States
Job Category: Technology
Job Type: Full Time- Direct Hire
Salary: United States dollar (USD)

Jennifer Simpson-Black
View Profile

Required Skills & Job Description

Must Have Skills: Candidate must have experience in PostgreSQL database architecture, logical and physical design, automation, documentation, installs, shell scripting, PL/ SQL programming, backup and recovery. Candidate must have strong knowledge of Linux. Strong understanding of command line and server administration. Knowledge of shell scripting (e.g. bash, PERL) Understanding of PHP and web application framework
Education: Some College Coursework Completed

Description:

The Database Administrator will be working with development, and customer support, providing technical and operational support activities of Database Servers, including logical and physical database design support, troubleshooting, performance monitoring, tuning, optimizing.

Estimate PostgreSQL database capacities
Develop methods for monitoring database capacity and usage.
Develop stored procedures and database triggers in support of application development.
Participate in application development projects and be responsible for the database architecture and design.
Participate in the creation of development, staging, and production database instances, and the migration from one environment to another.
Responsible for developer SQL code review to ensure queries are optimized and tuned to perform efficiently prior to production release.
Responsible for regular backups and recovery of databases.
Responsible for regular maintenance on databases (e.g. Vacuum, Reindexing, Archiving).
Responsible for pro-active remediation of database operational problems.
Responsible for query tuning and preventative maintenance.
PostgreSQL 8.3+ experience required.
Candidate must have strong analytical, verbal and written communication skills.

Apply for this Job

Contact Information Company Name: S & B Consulting Group Contact Name: Jennifer Simpson Black Contact Number: 972 536 3585 Company Website: http://www.sbconsultinggroup.net Additional Benefits: Company Description: Candidate must have experience in PostgreSQL database architecture, logical and physical design, automation, documentation, installs, shell scripting, PL/ SQL programming, backup and recovery. Candidate must have strong knowledge of Linux. Strong unde Date Posted: 2011-08-03 16:56:20