CRM, Data Warehouse, DBA, Database, Systems, IBM, SQL, Teradata, SDLC, Change Management, Unix, Linux, Computer
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.
Duties and Responsibilities:
Design, configure, and manage Database Systems on Cloud (e.g., AWS Redshift, EMR) and on premises (e.g., IBM Netezza/GreenPlum) 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 Qualifications
B.S. in Computer Science or related discipline or equivalent work experience required. AWS certification is a plus.