Database Administrator - PostgreSQL/NoSQL (8-12 yrs)

Key Responsibilities :

- Installation, configuration, and maintenance of PostgreSQL databases.

- Advanced schema design and data modeling.

- Database user management, security, and access control.

- High-availability and disaster recovery planning and implementation.

- Performance tuning and optimization of PostgreSQL queries.

- Backup and recovery procedures for PostgreSQL databases.

- Log monitoring and analysis.

- Administration and maintenance of NoSQL databases (i.e., MongoDB, Cassandra, Redis).

- Schema design and data modeling for NoSQL databases.

- Performance tuning and optimization of NoSQL queries.

- Backup and recovery procedures for NoSQL databases.

- Security and access control for NoSQL databases.

- Develop and implement automation scripts (i.e., shell scripts, Python) for database tasks.

- Automate routine maintenance and administrative tasks.

- Diagnose and resolve database performance issues and errors.

- Provide technical support to application development teams.

Required Skills:

- In-depth knowledge of PostgreSQL internals, architecture, and administration.

- Expert-level SQL skills, including writing complex queries, stored procedures, and functions.

- Experience with at least one NoSQL database (i.e., MongoDB, Cassandra, Redis).

- Proficiency in scripting languages (i.e. shell scripting, Python).

- Experience with database automation tools and techniques.

- Proven ability to tune database performance and optimize queries.

- Excellent problem-solving and troubleshooting skills.

- Strong written and verbal communication skills.

- Ability to work effectively in a collaborative team environment.

Preferred Skills :

- Experience with Percona PostgreSQL.

- Knowledge of containerization technologies (i.e., Docker, Kubernetes).

- Experience with cloud platforms (i.e., AWS, Azure, GCP).

- Experience with data security and compliance best practices