DBA

Job Description

CPC is a leading provider of multi‑channel marketing services, technologies and database solutions. A subsidiary of Publicis Groupe, CPC is seeking a DBA with a balance of skills in database design, physical implementation and performance.

• Design, configure, and manage database systems on cloud (e.g., AWS Redshift, EMR) and on premises (e.g., IBM Netezza/Green Plum).
• Monitor and report on performance metrics, system health, and logging compliance on database services or database appliances.
• 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 and implement workload management for resource allocation and query event handling.
• Support users, and troubleshoot data access applications and ad hoc queries.
• Develop and support shell scripts for database activities, such as data loading, unloading, and maintenance.
• Manage data replication, data encryption, backup storage and archiving procedures.
• Follow standards and best practices for availability, security, backup and recovery, and integrity of client databases.
• 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.

• 5+ years of experience in general database administration.
• At least 3 years of experience managing and maintaining database technologies, such as IBM Netezza, Teradata, Pivotal Greenplum, Actian Par Accel or similar.
• At least 1 year of experience managing cloud database technologies, such as AWS Redshift or AWS EMR service.
• Strong knowledge of Hadoop ecosystem components such as YARN, Map Reduce, HDFS, HBase, Zookeeper, Hive.
• 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 to 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.

B.S. in Computer Science or related discipline or equivalent work experience required. AWS certification is a plus.