Role- Database Specialist
Job Description
Must Have Skills:-
- Planning, Installation and Configuration of PostgreSQL 9.4 / 9.6/ 10/ 11/ 12
- PostgreSQL tools installation, Configurations PGAdmin III, IV, rep manager, PGPOOL, PGBouncer, pgbadger.
- Performance tuning configuration parameters enabling.
- Advanced Server version 9. X,10.x,11.x Installation, Configurations, Backup & Recovery, High Availability, Security, and Performance Tuning.
- Co-ordinate and support other teams for resolving troubleshooting issues.
- Used pg_ump, pg_resotre, pg_basebackup and other PostgreSQL built-in packages.
- Up-gradation of PostgreSQL server from 9.4 to 9.6. 9.6 to 10.
- Designed, developed, and maintained PostgreSQL database server.
- Prepared and updated scripts for various administrative tasks, Wrote UNIX Shell Scripts for scheduling backup jobs and day-to-day routine tasks.
- Configuration of streaming replication using replication slots.
- Conducted Linux administration activities and managed test databases.
- Check the load Balancing and Replication and connection.
- Creation of databases and creating indexing on tables.
- Creating users, roles, and necessary privileges to users according to the business requirement With Password Policy.
- Re-indexing and Vacuuming on Database from time to time.
- Providing Technical support for applications team for DB-related issues.
Responsibilities:-
- Responsible for ensuring availability and performance of the databases that support the system
- Work with the team to ensure that the associated hardware resources allocated to the databases and to ensure high availability and optimum performance
- To proactively monitor the database systems to ensure secure services with minimum downtime
- Responsible for providing trend analysis to the service management team to enable them to make informed decisions regarding resource management
- Responsible for problem escalation to Postgresql Development team and third parties as appropriate
- Responsible for improvement and maintenance of the databases to include rollout and upgrades
- Responsible for implementation and release of database changes as submitted by the development team
- Responsible for monitoring performance and managing parameters in order to provide fast responses to front-end users
- Contribute to the creation and maintenance of disaster recovery plans.
