Valor PayTech - Database Administrator - MariaDB

Responsibilities :

- Monitor the health of the DB servers through both automated and manual processes.

- Recommend and implement solutions for performance monitoring and tuning.

- Analyze problems, anticipate future problem areas, and implement solutions.

- Perform environment setup and configuration, proactive monitoring and maintenance.

- Support the development of longand short-term requirements for database administration and design.

- Participate in your change control process for all planned application and technical activities.

- Work with report writers to provide data needed for reports.

- Take on full roadmap items, work with other functional teams, and be able to deliver high quality results on time.

- Investigate and find the root cause for software problems reported by stakeholders.

- Direct organization of requirements and data into a usable database schema by directing development of ad hoc queries, scripts, updates to existing queries.

- May perform database administration and maintenance, including database installation and configuration, backups, upgrades, patching.

- Review SQL code written by application developers to ensure compliance to coding standards and best practices as well as maximum performance.

- Evaluate performance of stored procedures and find time/resource consuming areas and give inputs to application developers to fix them.

- Create deployment and rollback scripts for all database objects manually or auto generated.

- Analyze access patterns and propose the best combination of indexes, constraints, foreign keys, and queries.

- Proactively identifies technical opportunities and enhancements while addressing major incidents in a timely manner.

- Manages and ensures the integrity, security, and retention of data.

- Administers and maintains end user accounts, permissions, and access rights.

- Participate in an on-call rotation providing 24-hour, 7-day support, and off-hours maintenance windows.

Knowledge, skills, and abilities :

- Must have working and technical knowledge and experience with current Linux operating systems.

- Must have Strong problem-solving and analytical skills.

- Proficient in relational databases and backup and recovery.

- Comfortable with procedures such as shell scripting and scripting.

Qualifications :

Education and background :

- 5 years' experience with Relational Databases e.

- MariaDB/Mysql/NoSQL and above required.

- 5 years' experience with automation utilizing Shell scripting (Shell, Perl, python, etc.
) required.

- Strong at mysql, (postgress is additional but optional ), , Aurora/RDS, proxy sql, Percona / PMM /Grafana.

- Maintain scalability (cluster) and availability (replication) , must know Galera cluster.

- Troubleshoot database and Linux server issues by analysing logs or using command utilities.

- Should know automatic backup and recovery mechanism with cronjobs.

- Should have experience on working with application development team.

- Query review, optimization and developing own Queries based on the requirements and experienced working in gitlab.

- Strong exposure on Linux (resource / process monitoring) and basics of shell /python / any scripting.