Lead PostgreSQL DBA

About BU:

A consolidated team of database technology professionals, we provide expertise across all major database engines and Big Data solutions to support Epsilon products and platforms. The team has a unique alignment that combines a horizontal organizational structure with vertically aligned sub-groups dedicated to our clients. By adhering to consistent standards and best practices, the team ensures operational excellence and has close ties with product teams at Oracle, IBM, Cloudera, Amazon and Microsoft.

Who we are looking for

At Epsilon, we deliver excellence and create connections that last a lifetime. Our digital marketing arm, Conversant, is now growing and we are on the lookout for talented individuals who believe that every interaction counts - and want to make an impact on the future of our clients businesses.

So, are you someone who wants to work on the cutting edge of new-generation UI technology? Does the thought of working with Data Warehouse, Machine Learning, and Artificial Intelligence excite you? Then you could be exactly who we’re looking for.

Apply today and be part of a dynamic, enthusiastic and passionate team who want nothing more but to make a lasting impact on the lives of consumers. You will also get the opportunity to see your ideas come to life on almost every consumer device across the US.

What you will do:

• 9- 15 Years of Postgres database experience
• Candidate should have high functioning knowledge of Linux Postgres Database Installation
• Design, configure, and manage Data Warehouse Database Systems
• Monitor and report on performance metrics, system health, and logging compliance.
• Postgres performance monitoring and troubleshooting
• Experience with Postgres Data Loading
• Experience in working with Support
• Experience with Production Support and working on shifts/on-call rotation.
• Perform database administration tasks including backup and recovery, troubleshooting, performance tuning and SQL optimization
• Design database schema, and tune data types and data distribution for performance optimization
• Configure, implement and tune workload management for resource allocation and query event handling
• Support users, and troubleshoot data access applications and ad hoc queries
• Proficiency in Unix OS and shell/perl/python scripting
• Evaluate new database technologies and products and recommend to technical management
• Contribute to document company database standards, guidelines and operational procedures
• Perform a variety of tasks relying on experience and judgment to manage time, plan and accomplish goals on several client engagements
• Provide 24 x 7 x 365 support through on-call rotation

What you’ll need:

• 7+ years of experience in general database administration
• At least 5 years of experience managing and maintaining relational database technologies, such as Postgres required.
• Working experience PostgreSQL database and its Functions usage.
• Hands-on experience with PostgreSQL installation, configuration, and administration, starting and stopping database instance.
• Hands-on experience with PostgreSQL database backup and recovery and archived Wal log management, crash instance recovery
• Good understanding and experience on PostgreSQL High Availability solutions like PostgreSQL replication and OS cluster active-passive setup installation & configuration.
• Must know what database users and roles, permissions in PostgreSQL and their management.
• Hands-on experience with PostgreSQL database Version upgrade and migrations.
• Good Troubleshooting experience
• Familiarity with Greenplum database
• Knowledge of Hadoop is a plus
• Interact with vendor support to ensure open issues are resolved within defined SLA
• Understanding of Data Warehousing MPP architecture, technologies and concepts
• Ability to write and analyze complex SQL queries for performance
• Competence to read and interpret query plans, database statistics and database performance measurements and optimize SQL
• Proficiency in backup and recovery methodologies and techniques
• Ability to diagnose problems and resolve issues across various tiers (application, database , network and appliance)
• Adherence to SDLC, Change Management, troubleshooting and development methodologies
• Strong Unix/Linux and shell scripting
• Ability to perform work with minimal supervisory direction
• Excellent written and verbal communication skills

Education/Certification:

• B.E/ B.Tech/ M.Tech/ MCA/BCA. in Computer Science or related discipline or equivalent work experience required