Job Description
Love cutting-edge tech? We do too.
A subsidiary of Publicis Groupe, Epsilon is a leading provider of multi-channel marketing services, technologies, and database solutions. We do more than collect and store data, and we might be the most important Internet company you've never heard of. Join our team for your chance to work in the digital marketing space and solve meaningful problems on a massive scale-and have fun doing it.
For this role, we are seeking a Senior Database Administrator with a balance of skills in database design, physical implementation, and performance tuning. You will be part of a team that is supporting cloud Data Warehouse and Data Lake environments implemented on AWS or Azure for some of Epsilon's most prominent Database Marketing clients.
What you'll do:
1. Design, configure, and manage Data Warehouse Database Systems on Cloud (AWS Redshift, EMR HBase and Snowflake)
2. Monitor and report on performance metrics, system health, and logging compliance on database services or database appliances.
3. Perform database administration tasks including backup and recovery, troubleshooting, performance tuning and SQL optimization
4. Design database schema, and tune data types and data distribution for performance optimization
5. Configure and implement workload management for resource allocation and query event handling
6. Support users, and troubleshoot data access applications and ad hoc queries
7. Develop and support shell scripts for database activities, such as data loading, unloading, and maintenance
8. Manage data replication, data encryption, backup storage and archiving procedures
9. Follow standards and best practices for availability, security, backup and recovery, and integrity of client databases
10. Evaluate new database technologies and products and recommend to technical management
11. Contribute to document company database standards, guidelines, and operational procedures
12. Perform a variety of tasks relying on experience and judgment to manage time, plan and accomplish goals on several client engagements
13. Provide 24 x 7 x 365 support through on-call rotation
About you:
* Able to do your best work in a team setting and autonomously
* Well-developed interpersonal skills.
* Owns a problem to the end
* Proud to share in team's success
* Wants to grow a career with a great company.
What you'll bring:
* BS in Computer Science or related technical discipline or equivalent practical experience.
* 4-6 years of experience in general database administration
* At least 3 years of experience managing and maintaining Data Warehouse technologies, such as IBM Netezza, Teradata, Greenplum or similar
* At least 3 years of experience managing Cloud Data Warehouse database technologies, such as AWS Redshift, Snowflake, Databricks or similar
* Strong Knowledge in Hadoop eco system components such as YARN, MapReduce, HDFS, HBase, Zookeeper, Hive.
* Experience interacting 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
* Agile experience a plus (Kanban, Scrum, etc.)
Additional Information
About Epsilon
Epsilon is a global advertising and marketing technology company positioned at the center of Publicis Groupe. Epsilon accelerates clients' ability to harness the power of their first-party data to activate campaigns across channels and devices, with an unparalleled ability to prove outcomes. The company's industry-leading technology connects advertisers with consumers to drive performance while respecting and protecting consumer privacy. Epsilon's people-based identity graph allows brands, agencies and publishers to reach real people, not cookies or devices, across the open web. For more information, visit epsilon.com.
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 has 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.
Great People Deserve Great Benefits
We know that we have some of the brightest and most talented associates in the world, and we believe in rewarding them accordingly. If you work here, expect competitive pay, comprehensive health coverage, and endless opportunities to advance your career.
Epsilon is an Equal Opportunity Employer. Epsilon's policy is not to discriminate against any applicant or employee based on actual or perceived race, age, sex or gender (including pregnancy), marital status, national origin, ancestry, citizenship status, mental or physical disability, religion, creed, color, sexual orientation, gender identity or expression (including transgender status), veteran status, genetic information, or any other characteristic protected by applicable federal, state or local law. Epsilon also prohibits harassment of applicants and employees based on any of these protected categories. Epsilon will provide accommodations to applicants needing accommodations to complete the application process.
#LI-AM1
REF237853K Apply
#J-18808-Ljbffr