Adobe | PostgresSQL engineer

[Tuhina Jain <tujain@xxxxxxxxx>]

Hi,

 

Adobe – Bangalore is looking for an engineer with strong knowledge and experience in PostgresSQL for the Media Optimizer team.  Learn more about Media Optimizer at http://www.adobe.com/solutions/media-optimization.html 

If interested please contact me either on this mailing list or directly at tujain@xxxxxxxxx

 

A brief of the position:

 

Position Summary:

Adobe Media Optimizer is the first unified ad management system for digital marketing efforts across search, display and social media. It offers insight, control and automation for cross-channel ad campaign management and accurate revenue and budget forecasting. Adobe helps plan the most effective media mix for ad campaigns AMO (Adobe Media Optimizer) has a very complex and efficient production environment with a unique architecture. We have hundreds of machines, hosting a wide variety of applications and servers. Tens of TBs of data are sharded into thousands of databases spanning multiple datacentres across the world

The technical operations team works closely with the developers in planning releases and future development. We are looking for a highly experienced engineer with strong knowledge in PostgreSQL database administration who is interested in expanding into other operational responsibilities. If hired, you will get to work with some of the best talent in the industry in a highly energetic and fast paced environment. 

 

Responsibilities

• Ensure services are up and running with near zero downtime.
• Provide first level debugging of production issues and collaborate with appropriate teams in seeing issues to resolution.
• Review our datacenter capabilities and capacity periodically and provision for the future. 

Requirements

• Strong knowledge and experience with PostgreSQL. 
• Proficient in writing queries, function and triggers.
• Proficient in analysing queries, locks, and statistic of indexes and tables usages.
• Proficient in query optimization, should have hands on experience.
• Proficient in troubleshooting the resource usages with DB machines.
• Experience in setting up Standby server, Replication, daily backup.
• Knowledge on tools like Londiste, PLPproxy, PGBouncer, PGBadger.
• Strong knowledge on PostgreSQL architecture and internals.
• Strong knowledge on scripting (Shell or Python).
• Strong knowledge in troubleshooting issues with Linux (RedHat).
• Knowledge on application servers like Httpd, Tomcat.
• Knowledge on monitoring tools like Nagios / Mrtg / Cacti.
• Knowledge on building tools like Jenkins. 

Additional Desired Skills:

• Knowledge in Oracle administration and development.
• Experience in debugging C/C++ application using gdb.
• Experience in debugging hardware issues.
• Networking experience. (Routing, DNS). 

 

 

 

Tuhina Jain  | Talent Team  |  Adobe  |  p 0120 444 4711| tujain@xxxxxxxxx