Lead Database Administrator

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 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.