headers
poornima | 4 Apr 2007 08:12

Urgent job opening for PostgreSQL DBA.

Hi,

We have excellent and urgent job opening for PostgreSQL DBA  with one of our esteemed client in Pune/ Bangalore.

Skillset : PostgreSQL DBA

Experience : 5 - 7 yrs

Location   : Pune/ Bangalore.

If interested, please send me your updated resume in MS word format along with the CTC details:

Current CTC     :
Expected CTC  :
Notice Period   :
 
Please send your Academic Details :
 
BE       :  %,  University
HSC     :  %,  Board
SSC     :  %,  Board
 
Please give me references of your friends or colleagues who would be interested in the above position.
 
Please revert back ASAP.
 
Thanks & Regards,
Poornima
-------------------------------------------------------------------
Staffing Associate
Sequoia Consulting
E-Mail: poornima <at> sequoiaindia.com
 
 

Permalink | Reply | 2 comments |
headers
Leandro Guimarães Faria Corcete DUTRA | 11 Apr 2007 15:24

Re: Urgent job opening for PostgreSQL DBA.

On Wed, 4 Apr 2007 11:42:33 +0530, poornima <at> sequoiaindia.com said:
> 
> We have excellent and urgent job opening for PostgreSQL DBA  with one of
> our esteemed client in Pune/ Bangalore.

We should assume you are after Indian citizens?
--

-- 
Leandro Guimarães Faria Corcete DUTRA     +55 (11) 9406 7191 (cel)
Administrador de (Bases de) Dados         +55 (11) 2122 0302 (com)
http://br.geocities.com./lgcdutra/        +55 (11) 5685 2219 (res)
BRASIL                            mailto:leandro <at> dutra.fastmail.fm

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
       choose an index scan if your joining column's datatypes do not
       match
Permalink | Reply | 0 comments |
headers
anindya.bhattacharyya | 9 Apr 2007 11:25

Triggers


I have postgres sql  7.4
I have a table employee having two fields employee_number varchar(10) ,
salary(10,2);[primary key employee_number)

I want to track any change   due  update on any row on this table on this
table.

For this purpose  I have created a table call emplyee_audit having the
same structure as employee but no primary key

For this purpose I have tried to use trigger with before update option.
But as could find that Post gres does not support the :old or :new clause.
So I have not able track changes in emplyee_audit.

Kindly suggest how to accomplish the above task

Regards

Anindya Bhattacharyya
Manager SI

DISCLAIMER

“The information contained in this e-mail message and/or attachments to it may contain confidential or
privileged information. If you are not the intended recipient, any dissemination, use, review,
distribution, printing or copying of the information contained in this e-mail message and/or
attachments to it are strictly prohibited. If you have received this communication in error, please
notify us by reply e-mail or telephone and immediately and permanently delete the message and any
attachments. Thank you"

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

               http://archives.postgresql.org
Permalink | Reply | 2 comments |
headers
Greer Hitch | 11 Apr 2007 00:46
Favicon

Wanted: Senior Postgres DBA for Backcountry.com

Senior Postgres DBA

 

Backcountry.com has an outstanding opportunity for an experienced senior level Postgres DBA to join our Infrastructure team. The ideal candidate will assist in maintaining, tuning, and building out our databases. We are a fast-paced company that has seen 70+% growth year over year since we've been in business, and we are passionate about what we do. If you’re passionate about life and your career, this could be the opportunity for you.

 

 

Required Skills:

 

-Solid experience administering/maintaining PostgreSQL;

 

-Solid understanding of RDBM concepts and normalization principles;

 

-Comfortable managing multiple database servers in a high-traffic environment;

 

-Comfortable with complex SQL queries involving sub-selects, views,

CASEs, functions, etc.;

 

-Comfortable learning and working with custom software;

 

-Excellent communication skills;

 

-Works well in team environment;

 

-Shows demonstrated ability to take on challenges.

 

 

Preferred Skills:

 

-Experience with administering linux servers;

 

-Excellent Perl skills.

 

 

Considerations:

 

This full-time position is benefits eligible and is located in Salt Lake City,

Utah, with occasional travel to ParkCity.

 

Perks

 

-The Backcountry.com environment stresses quality without forgetting the importance of fun. We ride the resorts in the mornings, dawn patrol and climb in the canyons, hit the dirt jumps, trail run, trail ride, hike, camp, surf, skate, and play lots of ping pong.

 

-We use the gear we sell — all employees are privy to incredible gear deals across a huge range of outdoor sports, action sports, and lifestyle products.

 

-Backcountry.com continuously demonstrates phenomenal growth each quarter. All employees have strong opportunity for tremendous career advancement and growth.

 

To apply, please send a cover letter, your resume, and answers to the questions below to engineeringjobs <at> backcountry.com

 

 

Please answer the following questions in the notes section when you apply. Incomplete applications will not be considered.

 

1.   Why use Postgres for large scale enterprise database solutions versus

a commercial product like Oracle?

 

2.   List the top three reasons for a query to run slow, and how to

address each to speed up the query.

 

3.   Rate yourself on your understanding of Postgres' internals between 1

(being no understanding) and 10 (regular contributor to the core

development of Postgres).  Give some reasons why you rated yourself with

that value.

 

4.    How would you find out what percentage of a given table is dead tuples?

 

5.     What are your three best strengths?

 

6.     What is your desired salary range?

 

7.     Why do you want to work at Backcountry.com?

 

Equal Opportunity Employer

We Use the Gear We Sell

 

 

 

Ms. Greer Hitch

Recruiter

ghitch <at> backcountry.com

Tel: 801-746-7580 ext 5157
Fax: 435-575-0331

Backcountry.com

1678 W. Redstone Center Drive

Suite 210

Park City, UT  84098

We use the gear we sell.

www.backcountry.com

www.backcountryoutlet.com

www.tramdock.com

www.dogfunk.com

www.steepandcheap.com

www.geartrade.com

 

 

Permalink | Reply | 0 comments |
headers
Andrew Hammond | 16 Apr 2007 21:19
Picon
Gravatar

Re: Triggers

Since you're asking on the -jobs mailing list, perhaps you want to hire a PostgreSQL consultant? If that's the case, you could post an RFP or job description to this list. Alternatively, you can find consulting firms from all over the world at the following page.

http://www.postgresql.org/support/professional_support

If on the other hand you actually want your question answered, perhaps you should ask it in a forum such as pgsql-general, pgsql-sql or even pgsql-novice? You can see descriptions of the various mailing lists here:

http://www.postgresql.org/community/lists/

Andrew


On 4/9/07, anindya.bhattacharyya <at> cmcltd.com <anindya.bhattacharyya <at> cmcltd.com> wrote:

I have postgres sql  7.4
I have a table employee having two fields employee_number varchar(10) ,
salary(10,2);[primary key employee_number)

I want to track any change   due  update on any row on this table on this
table.

For this purpose  I have created a table call emplyee_audit having the
same structure as employee but no primary key

For this purpose I have tried to use trigger with before update option.
But as could find that Post gres does not support the :old or :new clause.
So I have not able track changes in emplyee_audit.

Kindly suggest how to accomplish the above task

Regards

Anindya Bhattacharyya
Manager SI



DISCLAIMER

"The information contained in this e-mail message and/or attachments to it may contain confidential or privileged information. If you are not the intended recipient, any dissemination, use, review, distribution, printing or copying of the information contained in this e-mail message and/or attachments to it are strictly prohibited. If you have received this communication in error, please notify us by reply e-mail or telephone and immediately and permanently delete the message and any attachments. Thank you"

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

               http://archives.postgresql.org

Permalink | Reply | 0 comments |
headers
Usama Munir | 17 Apr 2007 12:28
Picon
Gravatar

Re: Triggers

I don't think pgsql-jobs is the forum to ask this question

On 4/9/07, anindya.bhattacharyya <at> cmcltd.com
<anindya.bhattacharyya <at> cmcltd.com> wrote:
>
> I have postgres sql  7.4
> I have a table employee having two fields employee_number varchar(10) ,
> salary(10,2);[primary key employee_number)
>
> I want to track any change   due  update on any row on this table on this
> table.
>
> For this purpose  I have created a table call emplyee_audit having the
> same structure as employee but no primary key
>
> For this purpose I have tried to use trigger with before update option.
> But as could find that Post gres does not support the :old or :new clause.
> So I have not able track changes in emplyee_audit.
>
> Kindly suggest how to accomplish the above task
>
> Regards
>
> Anindya Bhattacharyya
> Manager SI
>
>
>
> DISCLAIMER
>
> "The information contained in this e-mail message and/or attachments to it may contain confidential or
privileged information. If you are not the intended recipient, any dissemination, use, review,
distribution, printing or copying of the information contained in this e-mail message and/or
attachments to it are strictly prohibited. If you have received this communication in error, please
notify us by reply e-mail or telephone and immediately and permanently delete the message and any
attachments. Thank you"
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Have you searched our list archives?
>
>                http://archives.postgresql.org
>

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
Permalink | Reply | 0 comments |
headers
Jobs | 19 Apr 2007 01:27

Red Hat System Administrator / PostgreSQL DBA in Scottsdale, AZ

This position is for more than just PostgreSQL, but we would happily
overlook a lack of experience in other areas for extensive PostgreSQL
experience, especially with extremely large databases, PITR, and
replication experience.

Thanks!

---

Vcommerce is looking for a bright and ambitious Linux/PostgreSQL admin
who is willing to do what it takes to get it done in a fast paced high
growth company.

If you consider yourself a jack of all trades and want the
responsibility and the opportunity to learn a lot, this is the job for
you. Position buzzwords include (but are not limited to) Linux, Solaris,
Windows, Exchange, Cisco switches/routers/firewalls/content switches,
EMC Clariion SAN / NAS, Apache, Postfix, BIND, Nagios, Snort, Tomcat,
Jonas, PostgreSQL, mySQL, Oracle, FTP, SMTP, Samba, Sterling GIS,
LAN/WAN, Java, racking, stacking, cabling, you name it. We are a very
small team of developers and administrators looking for another team
member with growth potential. We do not require experience with
everything listed above, but we do require extensive experience with
Linux and/or Solaris.

Vcommerce is the leading provider of on-line retail solutions. Vcommerce
provides proven solutions to capture, source and manage orders in
multi-channel retail environments, that dramatically minimize risks,
increase efficiencies and reduce costs associated with multi-channel
initiatives. Vcommerce provides services and tools to companies such as
Overstock, Target, GE, DeepDiscount, and MTV Networks.

Vcommerce is a fast paced company where employees enjoy working in an
energized work environment that encourages innovation and rewards
results. Vcommerce offers a competitive benefits package that includes
medical, dental and vision insurance, stock options, 401k and a casual
work environment.

Responsibilities include:

* Deploy, tune, troubleshoot Red Hat and Solaris servers in two data
centers
* Participate in system architectural design, procurement, and sizing
* Configure and maintain EMC SAN and Cisco network
* Share pager rotation with other team members
* Develop custom scripts using Bash, Perl, PHP, or other scripting
languages
* Evaluating new technologies
* Manage the ordering, receiving, and installation process for new
hardware
* Support the technology team in application deployments
* Enterprise-wide backups

Required Skills:

*  5++ years system administration with Red Hat and/or Solaris
*  3++ years in a 7x24 production web environment
*  Experience with shell scripting
*  Strong knowledge of backup strategies and processes
*  Understanding of high-availability architectures
*  Proven ability to implement data security standards and performance
and capacity planning
*  Ability to effectively resolve conflicting priorities from multiple
internal customers.
*  Strong decision-making skills, take charge personality, and the
ability to drive a plan to
       completion while still being a team player

Desired Skills:

* EMC Clariion / other SAN
* Cisco networking (switches, routers, CSS)
* Tomcat
* Apache
* Nagios / Cacti
* Samba / NFS
* Java or other development experience
* Database support (PostgreSQL, Oracle) 
* Slony, PITR
* SQL troubleshooting skills
* Bachelor of Science in Computer Science

Vcommerce is a rapidly growing technology company headquartered in
Scottsdale, AZ. We are seeking proactive, energetic, professional
candidates who excel in and enjoy the rewards of a high-energy,
fast-paced environment.

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings
Permalink | Reply | 0 comments |
headers
Cott Lang | 19 Apr 2007 00:29

Red Hat / PostgreSQL System Administrator / DBA

This position is for more than just PostgreSQL, but we would happily
overlook a lack of experience in other areas for extensive PostgreSQL
experience, especially with extremely large databases, PITR, and
replication experience.

Thanks!

---

Vcommerce is looking for a bright and ambitious Linux/PostgreSQL admin
who is willing to do what it takes to get it done in a fast paced high
growth company.

If you consider yourself a jack of all trades and want the
responsibility and the opportunity to learn a lot, this is the job for
you. Position buzzwords include (but are not limited to) Linux, Solaris,
Windows, Exchange, Cisco switches/routers/firewalls/content switches,
EMC Clariion SAN / NAS, Apache, Postfix, BIND, Nagios, Snort, Tomcat,
Jonas, PostgreSQL, mySQL, Oracle, FTP, SMTP, Samba, Sterling GIS,
LAN/WAN, Java, racking, stacking, cabling, you name it. We are a very
small team of developers and administrators looking for another team
member with growth potential. We do not require experience with
everything listed above, but we do require extensive experience with
Linux and/or Solaris.

Vcommerce is the leading provider of on-line retail solutions. Vcommerce
provides proven solutions to capture, source and manage orders in
multi-channel retail environments, that dramatically minimize risks,
increase efficiencies and reduce costs associated with multi-channel
initiatives. Vcommerce provides services and tools to companies such as
Overstock, Target, GE, DeepDiscount, and MTV Networks.

Vcommerce is a fast paced company where employees enjoy working in an
energized work environment that encourages innovation and rewards
results. Vcommerce offers a competitive benefits package that includes
medical, dental and vision insurance, stock options, 401k and a casual
work environment.

Responsibilities include:

* Deploy, tune, troubleshoot Red Hat and Solaris servers in two data
centers
* Participate in system architectural design, procurement, and sizing
* Configure and maintain EMC SAN and Cisco network
* Share pager rotation with other team members
* Develop custom scripts using Bash, Perl, PHP, or other scripting
languages
* Evaluating new technologies
* Manage the ordering, receiving, and installation process for new
hardware
* Support the technology team in application deployments
* Enterprise-wide backups

Required Skills:

*  5++ years system administration with Red Hat and/or Solaris
*  3++ years in a 7x24 production web environment
*  Experience with shell scripting
*  Strong knowledge of backup strategies and processes
*  Understanding of high-availability architectures
*  Proven ability to implement data security standards and performance
and capacity planning
*  Ability to effectively resolve conflicting priorities from multiple
internal customers.
*  Strong decision-making skills, take charge personality, and the
ability to drive a plan to
       completion while still being a team player

Desired Skills:

* EMC Clariion / other SAN
* Cisco networking (switches, routers, CSS)
* Tomcat
* Apache
* Nagios / Cacti
* Samba / NFS
* Java or other development experience
* Database support (PostgreSQL, Oracle) 
* Slony, PITR
* SQL troubleshooting skills
* Bachelor of Science in Computer Science

Vcommerce is a rapidly growing technology company headquartered in
Scottsdale, AZ. We are seeking proactive, energetic, professional
candidates who excel in and enjoy the rewards of a high-energy,
fast-paced environment.

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
Permalink | Reply | 0 comments |
headers
Dmitri Fuerle | 22 Apr 2007 00:07

Looking for PostGreSQL DBA with 3 years experience in Atlanta Georgia


JOB DESCRIPTION

POSITION TITLE: 	PostgreSQL DBA

Full Time Employee, 1 Position

REPORTS TO:	Chief Technology Officer

	POSITION SUMMARY:	This individual will
support/design/maintain all transactional database aspects iKobo. This
includes database maintenance/tuning, testing, troubleshooting and
providing support.  The ideal candidate will have, as a minimum, a
four-year degree or equivalent experience in computer science, a
exceptional understanding of database design methodologies in a Linux
and Windows environment, schema design, and troubleshooting on mission
critical systems. Must be an individual that thrives on dynamic, fast
moving environment.

ESSENTIAL FUNCTIONS:

*	Minimum 3 years Database Administration/Architect experience in
24/7 production environments (preferably in mission critical
environments)
*	Practical knowledge of Installing & Configuring PostgreSQL on
Linux environments
*	Setting up of Database Backups & Recovery mechanisms
*	PostgreSQL database activity/log monitoring and debugging 
*	Ability to perform Major/Minor DB version upgrades on
production/test environments
*	Query Analysis & tuning
*	Database parameters/performance tuning 
*	Strong understanding of Database Storage mechanisms
*	Strong SQL query/stored procedure writing capability and working
knowledge of PL/PGSQL
*	Scripting knowledge using shell or PERL
*	Expert relational database design (normalization) &
documentation experience
*	Database Security/Access control 
*	Ability to trouble-shoot from looking through logs, application
C++/PHP code to the database/operating system level
*	Ability to work closely with development team and involvement in
new designs, practical Knowledge of SDLC process
*	Completion of one or more successful full life-cycle development
project

 
QUALIFICATIONS:

1.        Education & Experience:
*	Bachelors degree or equivalent experience (3 -5 years) preferred
in Computer Science specializing in database technology
*	Experience with client/server technology
*	Experience with relational databases

2.        Skills & Abilities:
*	Good oral and written communication skills
*	Ability to work under pressure
*	Strong people skills
*	Creative problem solving
*	Replication experience a plus
*	Basic Linux administration skills a plus
*	Experience with Crystal Reports a plus
*	Microsoft Visio knowledge a plus
*	Ability to perform Backend Testing, a plus
*	Ability to understand C++ & PHP code and object oriented
programming, a plus
*	General understanding of web technologies and experience
developing web applications a plus
*	Oracle Database experience a plus

3.	 Physical Requirements:
*	No special requirements	
					
		
4.	Working Conditions:
*	No unique working conditions

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings
Permalink | Reply | 0 comments |
headers
robinwilson | 25 Apr 2007 20:04
Picon

Looking for a data persistence developer

ABAQUS is looking for a data persistence developer to complete our team developing the next generation
data persistence for large scale numerical simulation. Experience developing relational databases
would be considered an asset.

If you are interested, details are provided at:

http://search6.smartsearchonline.com/hks/jobs/jobdetails.asp?job_number=204

Regards,
Robin

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
Permalink | Reply | 0 comments |

Gmane