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 skills, and abilities :
• Must have understanding of technologies consisting of but not limited to MariaDB / MySQL, NoSQL, PostgreSQL (MongoDB, Cassandra etc.
• 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 and background :
• Bachelor's degree in computer science or related discipline is required; experience may substitute for the education requirement.
• 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.

(ref : hirist.tech)