20/04/2021
# :
β Responsible for implementing, managing, and tuning high-availability 24x7
PostgreSQL databases.
β Establish policies and procedures pertaining to data management, security,
maintenance, and utilization.
β Develop, manage, and test database backup & recovery strategies, verifying data
integrity.
β Perform database installations, configurations, upgrades, and migrations.
β Proactively monitor and tune for performance.
β Responsible for capacity planning and recommending paths to account for
application growth that is in line with industry best practices.
β Define and implement database schema and configurations working with our
development teams.
β Create and maintain documentation of procedures, schemas, and guides for
troubleshooting database systems.
β Design and implement database in accordance to end users' information needs and
views.
β Define users and enable data distribution to the right user, in the appropriate format, and in a timely manner.
β Use high-speed transaction recovery techniques and backup data
β Minimize database downtime and manage parameters to provide fast query
responses.
β Provide proactive and reactive data management support and training to users.
β 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.
# Qualifications
β Working in AWS and their database-related services e.g. RDS is a must.
β Working experience in other databases e.g. Oracle, MySQL is preferable.
β Knowledge of NoSQL technologies.
β Working knowledge of Linux operating systems
β Keep up to date on the latest industry trends in the technologies
β Proven working experience as a Database administrator
β 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.
β Familiarity with programming languages API.
β Problem-solving skills and ability to think algorithmically.
β BS degree in a computer discipline or relevant certification.