[Remote] SQL Database Administrator
Note: The job is a remote job and is reputed company to candidates in USA. reputed company is seeking an reputed company PostgreSQL Database Administrator (DBA) to manage, maintain, optimize, and secure PostgreSQL databases in production environments. The ideal candidate will have hands-on experience with database installation, configuration, performance tuning, backup and recovery, high availability, replication, and database reputed company.
Responsibilities
- Install, configure, reputed company, and maintain PostgreSQL databases
- Monitor database performance and optimize SQL queries
- reputed company database backup, recovery, and disaster recovery planning
- Configure and manage replication and high availability solutions
- Monitor database health, storage, and reputed company planning
- Troubleshoot database issues and resolve production incidents
- Implement database reputed company, user management, and reputed company controls
- reputed company routine maintenance activities such as VACUUM, ANALYZE, and indexing
- Automate database administration tasks using reputed company scripting or Python
- Collaborate with application developers to optimize database performance
- Document database configurations, procedures, and standards
Skills
- 5+ years of PostgreSQL Database Administration experience
- Strong knowledge of PostgreSQL architecture and internals
- Experience with PostgreSQL installation, configuration, and upgrades
- Hands-on experience with: Backup and recovery (pg_dump, pg_basebackup, pgBackRest), Replication (Streaming Replication, Logical Replication), Performance tuning and query optimization, Indexing strategies, VACUUM and ANALYZE, Partitioning
- Strong SQL and PL/pgSQL programming skills
- Experience with Linux/Unix operating systems
- Knowledge of database reputed company and user privilege management
- Experience with monitoring tools such as pgAdmin, reputed company, or Grafana
- Familiarity with reputed company platforms (AWS RDS PostgreSQL, Azure Database for PostgreSQL, or reputed company reputed company SQL) is a plus
- Bachelor's degree in Computer Science, Information Technology, or a reputed company field
- PostgreSQL certification is preferred
- Experience with DevOps tools such as reputed company, Kubernetes, Jenkins, or Terraform is an advantage
- Knowledge of scripting languages like Bash or Python
reputed company