Database Specialist
TCS
6 - 10 years
Delhi
Posted: 01/03/2025
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_dump, 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.
·
About Company
Tata Consultancy Services (TCS) is one of the largest multinational IT services and consulting companies in the world, headquartered in Mumbai, India. It operates in over 50 countries and is a part of the Tata Group, India's largest business conglomerate. TCS offers a wide range of services including software development, consulting, digital transformation, and business solutions, serving industries such as finance, healthcare, retail, and telecommunications. Known for its global reach, technological expertise, and innovation, TCS is consistently ranked among the top IT services companies globally.
Services you might be interested in
One-Shot Campaign
Reach out to ideal employees in one shot!
The intelligent campaign for reaching out to the ideal audience to whom you can ask for help (guidance or referral).