Postgres Database Engineer - Horsham, PA - Georgia IT Inc.
Horsham, PA
About the Job
Job Title: Postgres Database Engineer
Location: Horsham, PA
Position Type: Contract at least through end of 2015
Interview Process: Phone then onsite (No Skype/webcam or phone-to-hire)
Rate: DOE (Only W2 / 1099)
Scope
PostgreSQL Engineer specializes in performance tuning/data optimization (this is not a DBA role) and is responsible for making recommendations for tuning queries as well as tuning the Linux based PostgreSQL server. The current system was recently converted from Sybase to PostgreSQL.
Roles and Responsibilities
Location: Horsham, PA
Position Type: Contract at least through end of 2015
Interview Process: Phone then onsite (No Skype/webcam or phone-to-hire)
Rate: DOE (Only W2 / 1099)
Scope
PostgreSQL Engineer specializes in performance tuning/data optimization (this is not a DBA role) and is responsible for making recommendations for tuning queries as well as tuning the Linux based PostgreSQL server. The current system was recently converted from Sybase to PostgreSQL.
Roles and Responsibilities
- Provides high technical expertise for the design, development, implementation, maintenance, and control of the PostgreSQL databases.
- Consults with and advises staff DBA's on database management issues, influencing the PostgreSQL database.
- Serves as a consultant on PostgreSQL technological issues.
- Provides oversight, mentoring and leadership to less experienced staff.
- Perform Database functions based on PostgreSQL databases specializing in performance analysis, tuning and optimization.
- Impacting OLTP and DSS mixed workload application performance.
- Provide proactive monitoring of the database instances, and take preventive steps to ensure optimal performance.
- Provide PostgreSQL best practices for server and SQL performance.
- On the spot problem solving for complicated database and performance issues.
Required Skills/Experience
- 5+ years of experience with PostgreSQL technologies (performance tuning, memory management, SQL tuning, statistics gathering, application audit logs).
- 5+ years' experience in solid production support background.
- In-depth knowledge of PostgreSQL 9.X.
- In-depth knowledge of PostgreSQL internals, to get data for performance issue and give recommendation to resolve issue.
- Linux shell scripting experience.
- Strong PL/SQL programming experience.
- Experience with embedded 'C' (*.pgc) files.
- Experience with PostgreSQL running on various platforms and environments that include SUSE Linux, Virtual Machine (VM) and CentOS Linux.
- Strong skills in analyzing, monitoring and optimizing the performance of the PostgreSQL database.
- Proven ability to troubleshoot and trace data issues throughout the application.
- Must be strong in analyzing how PostgreSQL resources are used during SQL executions.
- Excellent verbal and written communication with the ability to write and maintain high quality documentation
Source : Georgia IT Inc.
