Senior Database Administrator

Company Description When you’re one of us, you get to run with the best. For decades, we’ve been helping marketers from the world’s top brands personalize experiences for millions of people with our cutting-edge technology, solutions and services. Epsilon’s best-in-class identity gives brands a clear, privacy-safe view of their customers, which they can use across our suite of digital media, messaging and loyalty solutions. We process 400+ billion consumer actions each day and hold many patents of proprietary technology, including real-time modeling languages and consumer privacy advancements. Thanks to the work of every employee, Epsilon India is now Great Place to Work-Certified™. Epsilon has also been consistently recognized as industry-leading by Forrester, Adweek and the MRC. Positioned at the core of Publicis Groupe, Epsilon is a global company with more than 8,000 employees around the world. For more information, visit epsilon.com/apac or our LinkedIn page.
Job Description
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
• 5+ Years of Greenplum 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 Qualifications • 5-8 years of experience in general database administration
• At least 3 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.S. in Computer Science or related discipline or equivalent work experience required