Job Description

A professional database administrator (DBA) will develop schema and database and keep the database up and running smoothly 24/7. The goal is to provide a seamless flow of information throughout the company, considering both backend data structure and frontend accessibility for end-users. Job Responsibilities: 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 are 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 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. Required Qualification: Working in AWS and their database related services e.g. RDS is 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. Degree in a computer discipline or relevant certification.

More Info

Education