Please reply to:- vms@compunnel.com
Job Details:- |
| Job Title : | Postgre SQL DBA |
| Location : | Horsham, PA |
| Expected Duration of Project : | 6 Months |
| Start Date : | 03/02/2015 |
| Interview Type : | Telephonic |
| Duties & Responsibilites : | It is mandatory for all the vendors to provide the details below while sharing the resume Consultant Name:
Current Location:
Phone:
Email:
Work Authorization :
Rate:
Job Description
-PostgreSQL DBA who specializes in performance tuning/data optimization.
-The position 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.
- 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. Requirements
- 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/pgSQL 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.
- Excellent Database Administration, Issue Troubleshooting, Performance Analysis and Project Management skills.
- Excellent troubleshooting and performance tuning skills.
- Monitoring and optimizing the performance of the PostgreSQL database.
- Proven ability to troubleshoot and trace data issues throughout the application.
- Excellent verbal and written communication.
- Must be strong in analyzing how PostgreSQL resources are used during SQL executions.
- Ability to write and maintain high quality documentation.
Required skills:
-The main must-have in order to do the work is PostgreSQL and database tuning because they just switched their database and they need someone who can come in and tune it at a Posgre level.
-They need to understand PostgreSQL in order to do database tuning.
-Some Sybase experience would be helpful and some experience with C so they can convert SQL statements.
-Basic role needs are that they are well versed in PostgreSQL tuning including Linux areas that affect tuning.
-A Sybase tuner would not work even if they are good.
-We need to have the person working day 1 and not training with respect to PostgreSQL.
|
Click here to see details and upload resume for this job.Click here to see all jobs on
jobs.compunnel.com.
--
You received this message because you are subscribed to the Google Groups "IT JOBS in USA" group.
To unsubscribe from this group and stop receiving emails from it, send an email to
it-jobs-in-usa+unsubscribe@googlegroups.com.
To post to this group, send email to
it-jobs-in-usa@googlegroups.com.
Visit this group at
http://groups.google.com/group/it-jobs-in-usa.
For more options, visit
https://groups.google.com/d/optout.
No comments:
Post a Comment