The objective of this role is to standardise database structures of ArpuPlus business units applications, optimize database integrations and activities and perform periodic maintenance to ensure the optimal performance, availability, security, and integrity of databases.
Responsibilities:
- Design, implement and Build database systems of high availability and Quality
- Install, upgrade, manage and maintain performance of database servers and applications.
- Develop processes for optimizing database security, performance and efficiency.
- Set and maintain database standards ensuring quality, efficiency, security and high availability of Databases.
- Performance tuning & Optimization of database systems to improve performance including Caching, Compression, Partitioning, Indexing, Concurrency control, connection pooling, etc.
- Determine, enforce and document database policies, procedures and standards
- Perform tests and evaluations regularly to ensure data security, privacy and integrity
- Monitor database performance, implement changes and apply new patches and versions when required
- Execute regular database maintenance tasks, including database defragmentation, backups, and database replication.
- Identify and implement database requirements for new or existing applications by working collaboratively with other teams.
- Support users and developers by resolving data-related technical issues and troubleshooting queries by guiding them with best practices.
- Use high-speed transaction recovery techniques and backup data.
- Minimize database downtime and manage parameters to provide fast query responses.
Requirements
- Bachelor's degree in computer science or computer/communications engineering or any other related field.
- 5 Years of proven working experience as a Database Administrator with hands-on experience with database standards and end user applications.
- Excellent knowledge of data backup, recovery, security, integrity and SQL.
- Familiarity with database design, documentation and coding.
- Previous experience with DBA case tools (frontend/backend) and third-party tools.
- Hands on Experience with different Database structures and Techniques (e.g. SQL, MYSQL, MONGO).
- Knowledge of database automation tools such as Ansible, Puppet, Chef, etc... and Ability to use a scripting language (like Python or Peri) to automate database administration tasks.
- Relevant database administration certificates, such as Oracle Certified Professional (OCP) or Microsoft Certified Database Administrator (MCDBA).
- Experience in cloud database technologies.
