Job Information
Publicis Groupe Lead Database Administrator in Bengaluru, India
Overview
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.
Responsibilities
Why we are looking for you?
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 will you enjoy in this role?
Will focus on DBA activities for PostgreSQL, developing, and supporting all our online data solutions.
This person will work closely with stakeholders and Business Managers for DBA activities
What will you do?
7+ 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
Qualifications
9- 12 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, performance tuning, 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
Additional Information
Epsilon is a global data, technology and services company that powers the marketing and advertising ecosystem. For decades, we’ve provided marketers from the world’s leading brands the data, technology and services they need to engage consumers with 1 View, 1 Vision and 1 Voice. 1 View of their universe of potential buyers. 1 Vision for engaging each individual. And 1 Voice to harmonize engagement across paid, owned and earned channels.
Epsilon’s comprehensive portfolio of capabilities across our suite of digital media, messaging and loyalty solutions bridge the divide between marketing and advertising technology. We process 400+ billion consumer actions each day using advanced AI and hold many patents of proprietary technology, including real-time modeling languages and consumer privacy advancements. Thanks to the work of every employee, Epsilon has been consistently recognized as industry-leading by Forrester, Adweek and the MRC. Epsilon is a global company with more than 9,000 employees around the world.
Epsilon has a core set of 5 values that define our culture and guide us to create value for our clients, our people and consumers. We are seeking candidates that align with our company values, demonstrate them and make them meaningful in their day-to-day work:
Act with integrity. We are transparent and have the courage to do the right thing.
Work together to win together. We believe collaboration is the catalyst that unlocks our full potential.
Innovate with purpose. We shape the market with big ideas that drive big outcomes.
Respect all voices. We embrace differences and foster a culture of connection and belonging.
Empower with accountability. We trust each other to own and deliver on common goals.
Because You Matter
YOUniverse. A work-world with you at the heart of it!
At Epsilon, we believe people make the place. And everything we do is designed with you in mind. That’s why our work-world, aptly named ‘YOUniverse’ is focused on creating a nurturing environment that elevates your growth, wellbeing and work-life harmony. So, come be part of a people-centric workspace where care for you is at the core of all we do.
Take a trip to YOUniverse and explore our unique benefits, here (https://www.epsilon.com/apac/youniverse)
Epsilon is an Equal Opportunity Employer.
Epsilon is committed to promoting diversity, inclusion, and equal employment opportunities by using reasonable efforts to attract, recruit, engage and retain qualified individuals of all ethnicities and backgrounds, including, but not limited to, women, people of color, LGBTQ individuals, people with disabilities and any other underrepresented groups, traits or characteristics.
