Database Administrator at Credrails

Key Responsibilities:

Database Management:

• Administer and maintain PostgreSQL database clusters, ensuring their reliability and performance.
• Monitor database health and performance, implementing improvements as necessary.
• Perform regular database maintenance tasks, such as backups, indexing, and replication.
• Manage database access, permissions, and security settings.
• Design and implement database schemas, tables, and relationships to support application requirements.

Performance Tuning and Optimization:

• Analyze and optimize database queries, indexes, and configurations to improve performance.
• Implement caching strategies and other optimizations to enhance database performance.
• Conduct regular performance testing and provide recommendations for improvements.
• Data Security and Compliance:
• Implement and enforce data security measures to protect sensitive information.
• Ensure compliance with data protection regulations and industry standards.
• Monitor for security vulnerabilities and apply necessary patches and updates.

Disaster Recovery and High Availability:

• Develop and maintain disaster recovery plans, ensuring data integrity and availability.
• Implement and manage database replication and failover strategies.
• Ensure high availability of databases through clustering and load balancing techniques.

Collaboration and Support:

• Work closely with development and DevOps teams to support database-related needs and deployments.
• Provide database support and troubleshooting for production issues, ensuring minimal downtime.
• Participate in on-call rotation for after-hours support as needed.

Documentation and Reporting:

• Document database architectures, configurations, and procedures.
• Generate and maintain reports on database performance, usage, and health.
• Provide regular updates to stakeholders on database status and issues.

Qualifications:

Education: Bachelor's degree in Computer Science, Information Technology, or a related field (or equivalent experience).

Experience:

• Proven experience as a Database Administrator with a focus on PostgreSQL.
• Strong knowledge of SQL and PL/pgSQL programming.
• Experience with database design, schema management, and data modeling.
• Familiarity with database replication, clustering, and high availability solutions.
• Experience with database monitoring tools (e.g., pgAdmin, Datadog, Prometheus).