Database Specialist

Role- Database Specialist

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.