Description

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

 

  • 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 ParAccel or similar
  • At least 1 years of experience managing Cloud database technologies, such as AWS RedShift or AWS EMR service.
  • Strong Knowledge in Hadoop eco system components such as YARN, MapReduce, 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 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. AWS certification is a plus.

Education

BTECH