Database Administrator: Mid-Senior (Pipeline) at Clickatell

Purpose

Are you ready to disrupt the world of chat commerce and build best in class products for Clickatell’s global customers? Do you wish you could launch code daily? Are you looking to work on an enterprise grade transactions platform hosted in cloud environments? Do you have a passion for designing and scaling application databases? This is your opportunity to join a team of developers, engineers and analysts who develop and evolve Clickatell’s products and data models.

The Senior Database Administrator has a strong focus on programing and will codify the automation of essential database and data management tasks. This role will manage the full life cycle of database schema design and implementation, from development through to production.

We Do The Right Things

Responsibilities of the Role

Solution Design and Development

• Participate in grooming sessions with technical and business stakeholders to convert requirements into technical database solutions that support the development of Clickatell products and platforms, for both real-time and batch environments.
• Innovate and collaborate with application developers, data architects, database administrators, data engineers and analytics developers to define and evolve our data model and select appropriate data technologies that fit the requirements.
• Design and implement high-availability database features using various replication and disaster recovery methodologies.
• Champion the design and development of database schemas, SQL queries and stored procedures that adhere to best practices, ensuring high performance and scalability (relational database optimal use of data types, indexes, etc).
• Perform tests and produce results to ensure accurate compliance with requirements.
• Administer and maintain databases for both the pre-production and production environments, ensuring that they are tuned for optimal performance and minimal downtime.
• Perform problem resolution and root cause analysis, along with recommending and implementing preventative techniques.
• Provide support for data platforms and environments to remote development teams.
• Provide time-critical support on production platforms via rotational on-call support.
• Protect Clickatell’s information, intellectual property, and corporate data systems in accordance with prescribed guidelines.
• Champion adherence to all relevant risk and compliance policies and procedures as communicated.
• Ensure adequate protection of the Clickatell brand and reputation.
• Author and maintain documentation related to database administration and development.
• Actively participate in expanding existing documentation.
• Review SQL code authored by application developers for correctness and performance.
• Author SQL queries on behalf of developers to support their development activities.

Operational Support

• Administer and maintain databases for both the pre-production and production environments, ensuring that they are tuned for optimal performance and minimal downtime.
• Perform problem resolution and root cause analysis, along with recommending and implementing preventative techniques.
• Provide support for data platforms and environments to remote development teams.
• Provide time-critical support on production platforms via rotational on-call support.

Security

• Protect Clickatell’s information, intellectual property, and corporate data systems in accordance with prescribed guidelines.
• Champion adherence to all relevant risk and compliance policies and procedures as communicated.
• Ensure adequate protection of the Clickatell brand and reputation.

Documentation

• Author and maintain documentation related to database administration and development.
• Actively participate in expanding existing documentation.

Review

• Review SQL code authored by application developers for correctness and performance.
• Author SQL queries on behalf of developers to support their development activities.

Requirements
We Are On A Learning Journey

Requirements of the Role

• A Diploma, B-Tech or bachelor's degree in engineering, computer science, information systems, informatics, or relevant work experience in a relevant data management fields.

Work Experience

• 3+ years’ experience working with MySQL databases.
• 2+ Experience with PostgreSQL databases.
• Experienced in development with scripting languages, including Python and Unix/Linux Shell.
• Experience with AWS data services and tools, including EC2 and RDS.
• A background working in a high-volume payment transaction environment, or mobile technology platforms and systems integration would be advantageous – must be able to demonstrate a sustained track record of delivering high-quality outputs, on-time and to product or business specifications.
• Familiarity with Agile and Scrum methodologies and embracing of their values and principles.
• Familiarity with Version Control systems such as GitLab.
• Advantageous – familiarity with the other technologies used at Clickatell:
• MPP Databases: DynamoDB, AWS Keyspaces (Cassandra), Redshift, Presto DB, Hadoop, HDFS
• Databases: MariaDB
• Scripting Languages: PHP, Perl
• AWS Data Services: Kinesis, Athena, Amazon S3, Lambda
• Productivity: JIRA, Confluence
• Monitoring: Datadog, Icinga
• Advantageous – familiarity with security and compliance standards:
• Exposure to data and security frameworks (ISO standards, NIST, etc)
• Exposure to compliance requirements around personal information (GDPR, POPIA, etc)
• Proficient Knowledge and Ability
• Communicates effectively both verbally and in writing across multiple cultures and time zones.
• Assertiveness: ability to communicate effectively and explain a point of view convincingly.
• Teamwork: ability to work reliably and responsibly with internal and external colleagues to achieve departmental and organisational goals.
• Sound critical judgement to make good decisions, be someone the team can respect, trust, and depend on.
• Customer Focus: can identify and effectively respond to the diverse needs of development department’s stakeholders.
• Exceptional problem-solving skills, logical thinking, and analytical abilities, with a high level of attention to detail.
• Display foresight, with systematic and orderly planning.
• In-Depth Knowledge and Ability
• Advanced SQL development competency.
• Advanced MySQL server administration competency.
• Excellent technical documentation skills and can write clear and concise technical documents.

Benefits
Why You Should Join

Perks of the Role

• Healthcare, Retirement Fund and Risk benefit company contributions
• Quarterly performance incentives
• Reimbursable Communication allowances for internet and mobile phone bills
• Half-day off on your birthday
• 5 personal days leave a year, over and above your annual leave
• Remote Working (our offices are currently open for essential use only due to COVID-19)
• Home office set-up with laptop, monitor, chair and UPS