Artur Kos | 13 Jun 12:54 2016
Picon

PostgreSQL DBA - Berlin calling!

Hi guys,

I'd like to post following add. Let me know if you need any more details.

The Blackbird is a HR Collective helping Berlin startups to grow.  For  
one of the most successful food delivery startups headquartered in  
Berlin, we are looking for an ambitious PostgreSQL DBA (at least  
2years experience) who will help develop our complex infrastructure  
(Linux, PostgreSQL, Jenkins, Nagios/Icinga).

The core of our DWH infrastructure are SQL/Python Scripts and Jenkins.  
Behind it we have a huge PostgreSQL database (384 GB RAM / 5TB Disc).  
We collect the data from more than 150 different sources, as from  
relation databases or third parties API like Google Analytics etc.  
More than 1000 Jobs transform the data daily to valuable result.  
Around the world more than 100 analysts are working with the system.  
The goal is to build within a year, the new infrastructure which can  
support 5 times bigger data volume and operations.

Sounds like you? Please feel free to contact me at artur <at> theblackbird.de

Thank you!

Artur Kos

Freelance Technical Recruiter
Tel: +49 1577 935 3 935
Skype: art.kos
www.theblackbird.de

(Continue reading)

Charles Weitzer | 7 Jun 23:03 2016

Hiring Postgres Database Architect

The Voleon Group is a technology-driven investment firm employing cutting-edge machine learning
techniques seeks an exceptionally capable Postgres Database Architect. Your responsibilities will
include making technical decisions with respect to relational database technologies; deploying,
configuring and maintaining database systems; working with software engineers to work through
performance problems and optimize database performance; and support database replication and backup processes.

The firm researches and deploys systematic trading strategies designed to generate attractive returns
independent of the performance of the overall market. Join a team of under 50 people that includes Ph.D.'s
from Berkeley, Chicago, CMU, Princeton, Stanford, and UCLA, led by the founder and CEO of a successful
Internet infrastructure technology firm. The firm's offices are walking distance from BART and the UC
Berkeley campus in downtown Berkeley, California. We have a casual and collegial office environment,
daily catered lunches, and competitive benefits packages.

We seek candidates with a passion for building out automated, maintainable infrastructure that is
flexible in serving the needs of a dynamic team of software, research and systems engineers. Someone with
an eye for detail, and who has a solid grasp of the revolution currently happening within the IT and
database administration community.

We are growing rapidly. Willingness to take initiative and a gritty determination to productize are
essential. 

Required qualifications:

        Expert in Postgres, including replication and performance optimization.
        Computer science degree or equivalent
        5+ years professional experience in IT, 2+ years as a DBA
        Strong experience managing Oracle deployments, including backup and recovery.
        Professional experience writing and debugging SQL.
        Professional experience deploying and maintaining distributed key/value stores, such as Redis or Cassandra.
        Strong proficiency in storage technologies, SAN/NAS, RAID systems, etc.
(Continue reading)

Rick LaBanca | 4 Jun 00:04 2016

DBA+

We’re looking for someone with experience to manage all aspects of the StudentUniverse database environment. We build, manage and host all our hardware and software, and the right person will be passionate about helping StudentUniverse continue to grow and ensure we’re set to scale. We offer flexible work schedules and a great opportunity/excuse to get out and see the world!

    Responsibilities:
  • Strategy & Planning: Plan with Sr. Management the direction and needs of the StudentUniverse database environment & research and test potential changes and upgrades
  • Implementation: Work to implement agreed upon changes and upgrades
  • Business Intelligence: Work closely with StudentUniverse Business Intelligence team on reporting set up and assisting in developing techniques to analyze large data sets efficiently

    Requirements and Skills:
  • Ability to design new database schemas
  • Experience with Linux and shell scripts
  • Experience with PostgreSQL and MySQL, including replication techniques
  • Minimum 2 years experience managing databases in an ecommerce environment
  • Plusses: Familiarity with Python, R, MongoDB and /or Hadoop

How to Apply
Please send a brief cover letter and your resume – using the job title as your subject line. To: jobs <at> studentuniverse.com.

About StudentUniverse:
StudentUniverse is the world’s leading travel booking site for students and youth. Through negotiations with a network of global partners, StudentUniverse offers exclusive pricing and terms on flights, hotels and tours. Its Travel Services division handles client requests for groups and custom itineraries.

StudentUniverse launched in 2000 and is headquartered in Boston with offices in London, Toronto, New York and the Philippines. StudentUniverse believes that travel is essential to a modern education. Millions of students use the service every year.

    Company Benefits:
  • Relaxed, casual work environment, including flexible hours and work from home policies
  • Onsite gym and locker room available 24/7
  • Happy hour(s), parties, boat cruises and team social events
  • Break room stocked with snacks and refreshments
  • Travel discounts and free airline tickets and vouchers
jobs@sharadacm.com | 3 Jun 23:35 2016

PostgreSQL Guru wanted (anywhere|remote|contract|employee)


Job Description
===============

Sharada has immediate need for a seasoned PostgreSQL expert to lead a number of key initiatives.

The ideal candidate possesses hands-on, in-depth knowledge and experience in all facets of Postgres
including but not limited to day-to-day administration and troubleshooting, performance tuning,
query optimization, storage, partitioning, replication, physical design, foreign data wrappers,
security and analytics.
Skills & Requirements

Required:
---------

 Proven field experience supporting and administering a non-trivial PG installation in a production environment.
 Can configure PG databases from scratch for various use cases and end applications
 Solid knowledge of PG backup and replication best practices, procedures and tools.
 Advanced knowledge of SQL in general and PL/pgSQL in specific.
 Knowledge of various approaches to PG replication and their tradeoffs.
 Firm grasp of PG security, both authentication and authorization.
 Ability to tune PG extensively depending on application requirements.
 Able to suggest table indexes or view materialization to improve performance of important and frequent queries.
 Approaches to sharding, partitioning and clustering PG.
 Experience in PG EXPLAIN/execution plan analysis
 Very comfortable in a Linux environment.
 Knowledge of all RAID levels and advantages/disadvantages of each.

Optional:
---------

 Shell, Python, or Perl
 Networking, OSI layers, standard protocols such as TCP/IP and UDP.
 SANs, LUNs, iSCSI, block-level mirroring/replication, clustering.
 Docker or LXD
 LDAP, Kerberos, Samba
 NoSQL, BigData
 OLAP, Cubes
 Normal forms, star and snowflake schemas

About Sharada Capital Management
--------------------------------

Sharada Capital Management is a small but successful proprietary trading firm specializing in listed and
over-the-counter FX instruments. We rely on technology and automation for everything from algorithmic
spot trading to real-time risk management across our diverse portfolio of assets. We are actively
seeking qualified candidates to spearhead greenfield, cutting-edge technology initiatives and build
out our state-of-the-art platform.

Even More About Us
------------------

If you want to learn more about us, please visit our company page and this job posting on Stack Overflow:

    http://stackoverflow.com/jobs/companies/sharada-capital-management-llc
    http://stackoverflow.com/jobs/115716/postgresql-guru-sharada-capital-management

--

-- 
Sent via pgsql-jobs mailing list (pgsql-jobs <at> postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-jobs

Joseph Warren | 25 May 02:45 2016

Sr. PostgreSQL DBA | Full-Time role | Pandora

Hello Everyone, 

Pandora currently has an opening in the San Francisco Bay Area for a talented PostgreSQL DBA. As the old
saying goes, “Nobody really knows what a DBA does, but every company needs to hire one, because no one can
afford to hire two.” Please see details below. 

A little about Pandora:

At Pandora, we're a unique collection of engineers, musicians, designers, marketers, and world-class
sellers with a common goal: to enrich lives by delivering effortless personalized music enjoyment and
discovery. People—the listeners, the artists, and our employees—are at the center of our mission
and everything we do. Actually, employees at Pandora are a lot like the service itself: bright, eclectic,
and innovative. Collaboration is the foundation of our workforce, and we’re looking for smart
individuals who are self-motivated and passionate to join us. Be a part of the engine that creates the
soundtrack to life. Discover your future at Pandora.

We have terrific opportunities in Database Administration for innovative, inspired problem solvers who
are enthusiastic about scaling Pandora's storage platforms to support our rapidly expanding community
of listeners.  With the right skills and experience, you will be managing Pandora's
24x7 PostgreSQL clusters. You’ll get the chance to take on complex and interesting problems as
part of a fast-paced, highly collaborative team.
 


We've built a complex cluster around PostgreSQL for scalability and high availability. It's imperative
that you approach administration with an emphasis on repeatability, testability and consistency. The
demands on this system are increasing rapidly as we grow the userbase and add more functionality.

We're looking for individuals who can help us continue to scale our queries, our systems and our hardware to
meet our growing needs. Someone who has shown talent at tuning database systems. A person that enjoys
being exposed to different situations and finds pleasure in finding creative (or practical) solutions
when when many thought it couldn’t be done.
 
Requirements
 
-  A deep understanding of database systems and the factors that affect distributed system
performance-strong preference for folks with PostgreSQL experience or MySQL
- Minimum 5 years’ experience developing and administering database infrastructure for mission
critical applications.
- Strong SQL skills and deep experience writing stored procedures.
- Experience maintaining large databases(>1TB)
- Experience developing stored procedures (PL/pgSQL)
- Experience supporting redundant systems with 24X7 availability requirement
- A deep understanding of database design principals
- Thorough knowledge of current hardware systems, RAID and disk subsystems commonly used in fault
tolerant production environments + Ability to proactively identify, troubleshoot and resolve live
database systems issues
- Strong scripting and automation skills (Shell, Python, etc.) (Shell and Bash are the same thing)
- BS or better in Computer Science or a related field.
- Hadoop or other NoSQL administration experience a plus
 

Core Technologies
 
- Linux
- PostgreSQL
- Slony
- Database Administration
- Python
- Hadoop (not so much)
- Distributed System

If you’d like to speak to me about this role, what life at Pandora is like, or you just have a recommendation
on a feature you'd like to see Pandora implement in the future, I'm open to hearing from you. 
To be efficient with your time and to save you from sending 3 or 4 emails you don’t want so send, feel free to
use this link: http://meetme.so/thumbsup and grab a time that works best for you.

Play it loud,
Joseph 


-- 
Joseph Warren | Opportunity Matchmaker 
O: 510-740-1340 | E: jwarren <at> pandora.com


--

-- 
Sent via pgsql-jobs mailing list (pgsql-jobs <at> postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-jobs
Zasadzinski, Kory | 17 May 18:34 2016

PostgreSQL Database Developer

Hello,

 

                My client located in Schaumburg, IL is seeking a PostgreSQL Database Developer for a long term contract. Candidate must be on site for at least one year then may have the option to work remotely. I included a brief job description below.

 

Thank you,

 

Experis is seeking an Database Developer -PostgreSQL for a long term contract located in Chicago, IL.

Solid understanding of database design principals
Minimum 3-5 years experience with Postgresql 9.x and Oracle 11g
Solid understanding of query execution plans
Experience opimizing JSON files extremely important
Mastery of ANSI SQL and/or PL-SQL
Good SQL scripts skill including SPs, PSQL scripting & functions
Good performance tuning skills
Ability to proactively identify, troubleshoot and resolve production database systems issues.
Solid background using UNIX operating systems - RedHAT or CentOS
Experience working with JSON Files

Knowledge of disaster recovery principles and practices, including planning, testing, backup/restore
Experience in replication
Hands-on experience on database administration, backup recovery and troubleshooting

Problem-solving skills
Ability to thrive in a fast-paced, deadline-sensitive environment
Ability to communicate ideas and designs to all stakeholders, including non-technical audiences

Education and Experience:
Minimum bachelor degree in Computer Science or related field;
Minimum five years of progressive experience performing PostgreSQL administration in a production environment; experience should include three or more years of database administration in an enterprise level environment with very large databases

 

 

   

Kory Zasadzinski
IT Recruiter

 

525 W Monroe Suite 1500 Chicago, IL 60661

 

T:

312-730-1813

C:

312-203-9483

 

kory.zasadzinski <at> experis.com
www.experis.com

 

 

 

 

 

Picon

www.quipment.in), Ahmedabad, Gujarat (India)

 

Dear All,

 

Greetings !

 

I am Mayuri Mevcha from the HR Department of Insigno Quipment Technologies (India) Pvt. Ltd., Ahmedabad (www.quipment.in). We are basically a Netherlands based IT Product Development company and providing the solutions to fleet management.

 

Currently we are looking for Database Administrator professional like you to augment our current manpower in Ahmedabad based research and development branch. So, if you are interested for this new opportunity then please revert to this E-Mail along with your updated CV and provide following required details.

 

Total Experience in DBA Profile :

Current CTC (Monthly):

Monthly Take Home Salary :

Expected CTC :

Reason of job change :

Current Location :

Permanent Location :

Ready to relocate to Ahmedabad (India) :

Notice Period :

 

I would also request you to go through the following details which is the proper job description of our current requirement.

 

Total Relevant Experience : 3 - 7 Years

Job Location : Ahmedabad, Gujarat, India

Specification :

Ø  Hand on experience on PGSQL/ PostgreSQL (minimum 1.5 - 2 years) & MS SQL (2005, 2008, and 2012) Database Development.

Ø  Database Programming (Stored Procedures, Triggers, Functions, SQL Jobs, Packages etc.).

Ø  Database and Server Management & Administration.

Ø  RDBMS.

Ø  Data migration between different Database Server.

Ø  Good understanding of Postgres MVCC Architecture.

Ø  Strong experience with PGSQL and MSSQL database administrator Task, like database backup and restore plan, database monitoring in aspect of high performance and high resource availability.

Ø  Experience with database high availability and load balancing concepts.

Ø  Experience with PGSQL table partitioning and its management.

Ø  Experience with PGAgent scheduled job.

Ø  Excellent troubleshooting skills for database transaction lock, deadlock & blocked transaction.

Ø  Good in optimized query writing and database performance optimization.

Required Experience :

Ø  Strong understanding of database structures, theories, principles, and practices.

Ø  Understanding of, and experience with, server-client computing and relational database environments.

Ø  Good understanding of the organizations goals and objectives.

Ø  Good interpersonal, written, and oral communication skills.

Ø  Technical documentation skills.

Ø  Ability to present ideas in user-friendly language.

Ø  Self-motivated and directed, with keen attention to detail.

Ø  Able to prioritize and execute tasks in a high-pressure environment.

Ø  Experience working in a team-oriented, collaborative environment.

Ø  Good written and oral communication skills.

Ø  Experience with data management and data processing flowcharting techniques.

Thanks & Regards,

Mayuri Mevcha
HR Executive

Human Resource Department

T / +91 (0) 79 4009 7847
mayuri.mevcha <at> / www.quipment.in

 

QTwee Group BV
KvK Arnhem 60858001
BTW NL854090721B01
mail <at> / www.quipment.nl

Hoofdkantoor Nijmegen
Kerkenbos 1236 C
6546 BE Nijmegen

Tel.

+31 (0)24 372 47 00

Fax.

+31 (0)24 372 47 07

Quipment India
A-212 Shivalik Corporate Park
B/H IOC Petrol Pump
Satellite, Ahmedabad
Gujarat - 380015 - India
Tel. +91 (0) 79 4009 7847

Disclaimer

This e-mail message (including any attachment) is intended only for the personal use of the recipient(s) named above. This message is confidential and may be legally privileged. If you are not an intended recipient, you may not review, copy or distribute this message. If you have received this communication in error, please notify us immediately by e-mail and delete the original message.

 

Peter Friday | 16 May 09:47 2016
Picon

Sr Software Developer in Shanghai, China <at> Apple

Need a PostgreSQL expert to join my team in Shanghai. Ideally you’d already be in China, but I’m open to relocation if you are the right fit. No remote, the position is in Shanghai. 

Here is the formal write up of the role so if you think you are a fit feel free to send your github and resume to peterfriday <at> apple.com. (I am the hiring manager, not a recruiter)


Job Title
Senior Software Developer 
 
Job Summary
We are looking for Software application developer with deep knowledge and experience in PostgreSQL who can help lead the next generation of products we build. You should like solving problems that no one has solved yet and care about the impact of your product. You are more passionate about solving the problem than the single solution you developed. If this describes you then we should meet. 

Key Qualifications
• 5+ years in a senior role developing large (> 500 GB data) PostgreSQL based applications in Go, Python, Node.js, Ruby, or similar languages.
•.5+ years designing, configuring and operating PostgreSQL clusters for high availability across multiple data centers.
•.Knowledge of PostgreSQL internals, performance and extensions such as Citus is a plus.
•.A strong desire to produce high quality software through test driven development, code reviews, and other best practices. 
• Experience with Go is desired.
• Experience with ElasticSearch, Couchbase and other Document-oriented, NoSQL solutions is a plus.
• Familiarity building, monitoring, automating, optimizing, managing and scaling distributed applications and services, virtualized and bare-metal infrastructure.

Description
This is a rare opportunity to put your signature on how Apple manufactures everything. You will be architecting and scaling our existing application API’s and databases and leading the team as we design future systems. Our applications enable the development of every product Apple makes. You are going to work closely with manufacturing design and the mechanical engineering team on new products. This also means writing the code to control production line equipment like lasers and other hardware.

Our current stacks are diverse and evolving combinations of old and new, closed and open source technologies. We are not looking for a solution for now; we are looking for the best solution for tomorrow. We are an ambitious team that takes smart risks and challenges everything -- including each other. None of us are the best at everything but all are the best at something. You should be the best at PostgreSQL.

We are always looking for better ways of solving the problems we are tasked with and open to the best tool for the job. In some cases this means an React.js web application supported by a Go-powered API interfacing with PostgreSQL, while in others it may leverage a simple bash script, Node.js or Ruby+Rails and ElasticSearch or a NoSQL solution like Couchbase.

About Us
The Manufacturing Design team enables the mass production of Apple's entire product line from iPhones, iPads and MacBooks to the Mac Pro, AppleTV and Apple Watch. Part of the magic that makes all of this possible is a robust set of applications and systems designed and developed by Apple that support the production of a product from prototype to announcement and beyond.

Mitchell Pearce | 14 May 00:57 2016

Seeking PostgreSQL postgis programmer

Gentle People: 

Please post this contracting opportunity.

PostgreSQL/postgis programmer sought by Online Image for its USgeocoder.com. 

Founded In 2000, Online Image started as a web development firm offering website design and consulting
service for small business. In 2009, we developed our own web application USgeocoder
(www.usgeocoder.com), a GIS web application providing location information for government,
elections, lobbying, advocacy, tax compliance, marketing and business assets management. Utilizing
the core technology of USgeocoder, we then developed an online sales tax application and an advocacy
application. Our servers are hosted in a data center in Mountain View, CA.

As we are switching our focus from product development to marketing and sales, we are looking for a
developer to take charge of our innovative features, performance improvement, regular updates and
technical support for our databases in our web applications.  

Currently we work in a "virtual company" model. You can work out of your own location on flexible hours as an
independent contractor. You must be a US citizen and live in the USA. You can work remotely with us using
Skype, phone conferences, Go to Meeting, Join.me, and Face Time. 

If you are an expert-level postgreSQL with postgis programmer with the goal to become a technical leader,
this is an ideal opportunity for you! We seek out solid programmers with clear minds, business sense and
eager to grow with the company.  For the right person, there is no end in sight for this contract. 

To Apply

1. Please go to usgeocoder.com, voterconnect.org and casalestaxrate.com to learn more about our web applications.
2. Attach your resume including links to the websites/companies/database buildouts/improvements you
have participated in and your main contributions.
3. In the email itself, please rate yourself from 1 to 10 for the following technical skills (not all skills
are required).
4. Don't forget to include your phone number and other usual contact information. (Like where you live.)
5. We are a woman owned company and do not think your race, religion, gender, sexual orientation, age,
marital status, or country you emigrated from has any relevance to your skills as they would apply to our
work, so feel encouraged to apply whoever you are and wherever you've been.  
6. We do care about being sure you can spend time with your children, get to their soccer games, hunts,
sailing meets, science fairs, school plays, scout meetings, band performances, and meals etc. and have
time go with your parents to get to and from the doctor etc. while working for us. 
7.  Some of our clients may have different political views than yours and some aligned with yours. To work
here, you have to be able to tolerate every view and support every client's effort to participate in and
influence American Politics and processes. You also MUST be able to keep their secrets secret. So having a
mature attitude and some political experience is helpful. 

Programming languages used in our applications:
- PostgreSQL with Postgis    ****is the most important qualification for this position****
- Mapserver                          ***is 2nd most important qualification for this position***
- PHP 4, 5                               **is 3rd most important qualification for this position**
- Python                                   *is 4th most important qualification for this position*
- PHP Frameworks: CakePhp, Zend
- HTML 5
- XML
- Javascript and its frame work jQuery
- CSS
- AJAX
- Adobe Flex
- Ruby on Rails

Databases in our applications:
- MySQL
- PostgreSQL with postgis

Design tools
- Adobe CS6

Areas of interest to work in: 

PostgresSQL with Postgis, maintenance and development of current DB is our current biggest priority. 
Must have extensive experience with this program for this position.

API Development
- REST based web services

API implementation
- Social media such as Facebook, Twitter, Digg
- Entertainment media such as Youtube

eCommerce integration
- Shopping cart add-on for major shopping cart software/companies

Other qualifications
- Team player
- Responsive
- Responsible
- Detail-oriented
- Quick learner
- Strong communication skills
- Prior experience in GIS industry is the biggest plus
- Minimum 3 references are required

4. In the email, briefly answer the following questions:
- Your most valuable achievements for your prior work
- What interests you the most working at Online Image
- Your desired hourly rate/salary range
- Your availability (how many hours per week, starting time)

--------
Mitchell Pearce, Co-Founder, CEO
mitchell <at> usgeocoder.com
Mobile: (408) 639-0211	
eFax: (408) 889-2669
USgeocoder.com - Every Place Tells A Story

--

-- 
Sent via pgsql-jobs mailing list (pgsql-jobs <at> postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-jobs

SRIKANTH - VERITIS | 13 May 23:31 2016

Hi Bruce, Direct client full-time Job for you. Need to submit to Hiring Manager TODAY. Please call back ASAP

Hi Bruce,                                                                                                                                                                                                 

 

This is Srikanth from Veritis.

 

Full-time Job Opening with our Direct Client 

 

Need to submit to Hiring Manager TODAY. Please call back ASAP on 214-295-4689

Role: SQL Postgres DB Developer  
Location: Dallas, TX

 

Position: PostgreSQL Database Developer

Location: Dallas, TX

Duration: Full Time.

1st ROUND: Phone/Skype

2nd ROUND: 1 & 1/2 hr F2F interview

 

Required Skills: 

Ideal candidate will have Postgres experience

SQL Server development 2005, RDBMS, theories, principles, and best practices, analyzing DB performance factors, monitoring tools and tuning procedures, design and implement large-scale database solutions that are reliable, scalable, and perform at a high level, analyze user requirements into technical solutions based on specifications, SSRS & Visual Studio Team System is a PLUS, work independently with minimal or no supervision, prioritize and escalate issues as needed, Proficient verbal/written communication skills, Excellent analytical/problem solving skills, work longer hours when required 

 

SQL Postgres DB Developer will be responsible to develop/implement/maintain Quality Business Intelligence Solutions
Design table schema, design and program complex stored procedures, views, data aggregation/manipulation through table joins/queries/ user-defined functions/reports using SQL Server/SSRS, offer analytical/technical support to the teams. Maintain SQL Server databases in test & development environments. Meet with BA’s & offer technical solutions to new business requirements and any issues that are reported. Resolve server as well as SQL job alerts for test & production at second/third evel support. Help with creation & maintenance of documentation standards, Tune/optimize DB performance, Conduct root cause analysis for problem detection & document source and proposed resolution. Perform architectural/code reviews. Mentor new or junior team members.

If you are comfortable with the requirement, please do make some time to fill in the below details and revert me with your resume.

 

Candidate Information

Full name

 

Primary skills

 

Contact Numbers

 

Email Address

 

Current Location (City, State)

 

Work Authorization

 

H1B Visa Expiry (if applicable)

 

Availability

 

Skype ID

 

Re-Location (Yes / No)

 

Availability for in-person interviews

 

Education (highest degree and year)

 

Hourly Rate and type

 

Total IT Experience

 

US Experience

 

Best Time to Reach you

 

References

 

 

 

Thanks & Regards,

Srikanth,

Senior Resource Coordinator | Veritis Group, Inc

214-295-4689 | srikanth <at> veritis.com

 

Rated Top 25 fastest growing IT services company in US by INC500

Oracle Partner | Sun Partner Advantage | VMware Partner Professional 

Think Green: Please consider the environment before printing this e-mail.

 

 

Stephanie Solan-Martel | 12 May 17:43 2016
Picon

Princeton, NJ - Long Term Contract - Postgres DBA

Hi ~
 
I am working on a very long term contract (could go multiple years) for my direct client in Princeton, NJ.
We currently have two Consultants on this Team.  They are growing and looking to add another DBA.
 
This is an ON-SITE position.
 
If you or someone you know is interested, please send your all inclusive hourly rate and resume to:
stephanie.martel <at> princetoninformation.com 
 
SPEC:
 
The PostgreSQL DBA will be responsible for the design, deployment and management of PostgreSQL database environments and servers. The right candidate will have skills to design the PostgreSQL for high availability, zero downtime production systems, and review the SQL queries for code and performance tuning. Setup and configure the database / schemas /Roles for data protection and security rules to certify any audit requirement. Responsibilities: Performs all PostgreSQL Database Administration related activities for major projects independently with minimal supervision. Works with the application development teams and guides them with best coding practices. Assist developers with code review and design and help troubleshoot code issues. Strong capability and ability to resolve highly technical and complex database and infrastructure Related issues on their own before they impact production and business. Provides technical expertise to the development of solutions for such items as DBMS tools and utilities usage, database administration, backup and recovery, database performance tuning and monitoring. Ability to influence development organizations to comply with database best practices and database standards and practices. Lead the installation and maintenance of Production PostgreSQL Database in a clustered highly available architecture Develop and enhance scripts to Monitor, automate and execute various DBA tasks Assess the DB performance and lead the effort to patch, upgrade and/or tune the DB for optimum performance Patch, Upgrade and keep the PostgreSQL DBs current Review SQL scripts and DB transactions developed by software engineers and assist in improving the efficiency of the code for best possible DB performance Assist in the design of appropriate DB Schema and indexing strategy for performance and scalability Willing to participate and provide 24x7 On-Call Rotation support. Postgres Replication and data encryption. Skills and Experience: 5+ Years as a PostgreSQL Database Administrator in 9.x with Postgres Advanced Server using Enterprise Manager and SQL analyzer PostgreSQL Database Administration in a large/challenging database environment on Red Hat Linux platform. Experience supporting internet/web based database applications with heavy concurrent user volume. PostgreSQL DBA experience in a 24x7 production environment DB Patching and Upgrade skills in production environment (PostgreSQL 9.x preferred) Experience in alternative technology (SQL Server, Oracle) is a big Plus.
 
Thank you,
Stephanie Martel
Senior Technical Recruiter
Princeton Information
Jersey City, NJ
stephanie.martel <at> princetoninformation.com
 

Gmane