Database Administrator (MySQL/Vertica)
adMarketplace is looking for a Database Administrator with good understanding and hands-on experience with MySQL and familiarity with at least one columnar database (Vertica preferred) to support our database systems used by 24/7 low latency applications. Experience Big Data in your career—at 2 billion query requests and 1 TB of data generated per day. This is a great opportunity for a DBA to get hands-on experience developing/managing databases to support 24/7 systems (both on-prem and cloud), learn new types of database/data technologies (Aerospike, Kafka, ...), and grow into a database leadership role.
Responsibilities:
- Work with other DBAs to ensure the uptime and reliability of our MySQL and Vertica database systems, and provide database administration support (including development, testing, and production environments)
- Support software development database integration projects including DDL and DML, query optimization, data pipelines integrations, data replication, and overall database design/architecture for MySQL and Vertica databases
- Perform database administration tasks: upgrades, security (user management), data purging, backup/recovery, storage optimization, performance tuning, monitoring
- Monitor and respond to systems outages as required; 24/7 on-call rotation
- Take ownership of database systems and lead/drive database projects from start to completion
- Drive the strategic direction of database technologies by working closely with other technology leaders
- Work with various teams to control and execute day-to-day database operations
Requirements:
- Bachelor’s degree or equivalent work experience required
- Must have 3+ years of hands-on industry-related MySQL experience
- Must have a good understanding and hands-on experience with at least one columnar database (Vertica preferred) and/or interest learning Vertica
- Must have experience with database clustering, data replication, performance tuning, monitoring, and upgrades
- Good knowledge of data backup, data purging, recovery, and SQL
- Experience with software development database integrations support, database design and architecture
- Ability to initiate and drive database projects to completion with minimal guidance
- An innovative approach to work, constantly looking to upgrade the system to more efficient and effective new technologies and processes
- Experience working in a Linux environment
- Excellent communication, documentation and troubleshooting skills
Is a plus :
- Experience with Tungsten replication and clustering
- Experience with Aerospike
- Experience with Hadoop/Kafka data streaming technologies
- Experience with AWS (RDS, Aurora, Redshift)
- Experience with data warehouse development
- Experience with bash scripting and Python
- Digital advertising industry experience