Text copied to clipboard!
Title
Text copied to clipboard!PostgreSQL Database Administrator (DBA)
Description
Text copied to clipboard!
We are looking for a skilled PostgreSQL Database Administrator to join our team. In this role, you will be responsible for managing and maintaining our company's PostgreSQL databases to ensure their performance, availability, and security. You will also be involved in the planning and development of the database, as well as troubleshooting any issues on behalf of the users. You will ensure that data remains consistent across the database, data is clearly defined, users access data concurrently, in a form that suits their needs, and there is provision for data security and recovery control. You will also work closely with IT project managers, database programmers, and multimedia programmers. To be successful in this role, you should have excellent problem-solving skills, hands-on experience with database standards and end user applications, excellent knowledge of data backup, recovery, security, integrity and SQL.
Responsibilities
Text copied to clipboard!- Installing and maintaining the PostgreSQL database software.
- Creating database storage structures and setting up database security.
- Modifying the database structure using information provided by application developers.
- Enrolling users and maintaining system security.
- Ensuring compliance with database vendor license agreement.
- Controlling and monitoring user access to the database.
- Monitoring and optimizing the performance of the database.
- Planning for backup and recovery of database information.
- Maintaining archived data.
- Backing up and restoring databases.
Requirements
Text copied to clipboard!- Bachelor's degree in Computer Science or a related field.
- Proven work experience as a PostgreSQL Database administrator.
- Familiarity with the main data manipulation languages and the principles of database design.
- Knowledge of database backup and recovery procedures.
- Experience with database design applications.
- Understanding of distributed computing architectures, e.g. Client–Server.
- Understanding of the underlying operating system, e.g. Linux, Unix or Windows.
- Understanding of storage technologies, memory management, disk arrays, NAS/SAN, networking.
- Problem-solving and good analytical skills.
- Communication, teamwork and negotiation skills.
Potential interview questions
Text copied to clipboard!- What is your experience with PostgreSQL databases?
- How do you handle database security?
- Can you describe a time when you had to solve a challenging database problem?
- How do you ensure data consistency across a database?
- What methods do you use for database backup and recovery?