Key Skills:PostgreSQL, SQL Server, Oracle, MySQL, MongoDB, Database Administration, Performance Tuning
Roles and Responsibilities:
- Install, configure, and upgrade PostgreSQL databases on-premises.
- Perform performance tuning and query optimization to enhance database efficiency.
- Develop and implement backup and recovery strategies using tools like pg_dump and PITR.
- Set up and monitor replication (Streaming, Logical) to ensure data integrity.
- Troubleshoot database issues and analyze logs for effective resolution.
- Manage user access and control permissions to maintain security.
- Conduct routine maintenance tasks such as VACUUM and REINDEX.
- Utilize monitoring tools like pg_stat_statements and pgBadger for performance insights.
- Collaborate with development teams to automate processes using scripting languages like Shell and Python.
Skills Required:
- Strong experience in administering PostgreSQL databases in production environments.
- Hands-on knowledge of relational and NoSQL databases including SQL Server, Oracle, MySQL, IBM DB2, and MongoDB.
- Proven expertise in database performance tuning, query optimization, and indexing strategies.
- Experience in backup, restore, and disaster recovery techniques including PITR.
- Good understanding of PostgreSQL replication mechanisms such as streaming and logical replication.
- Experience with database monitoring and diagnostic tools like pg_stat_statements and pgBadger.
- Ability to write automation scripts using Shell and Python for database operations.
- Knowledge of security best practices including role management and access control.
- Strong troubleshooting skills with the ability to analyze logs and resolve complex database issues
Education:Bachelor's degree in Computer Science or a related field.
