Database Administrator-Postgress
Published date: 2024/01/10
- Location: Anywhere, India
Job Responsibilities:
· Performance Tuning
· Query analysis and optimization
· Backup (Hot and Cold)
· Recovery and Replication
· Overall system health
· Developing Triggers/Stored Procedures
· Query optimization
· Developing SQL reports and business logic for Multiple Applications.
· Staging, testing and development of database
· Installation & Maintenance Multiple Database servers like: Postgres/My SQL
· HA and Clustering setup for Databases.
· Documentation of schema
· Schema Management, updates and rollbacks.
Role Requirements:
· Minimum 5 year of experience in administration
· Must know about the Sharding Concept.
· Knowledge of SLONY (replication)/PG9 Streaming Replication/Other replication tools
· Complete knowledge of ANSI SQL dialect is a must.
· Database maintenance (hot and full backups, vacuuming, indexing)
· Database optimizations (OS specific (Linux and Solaris) optimizations, query analysis and tuning)
· Should be able to write basic scripts to load data into DB, and export to various formats
· Knowledge of redhat/centOS/other linux OS
· Basic Shell Scripting for automating tasks
· Migrations, database monitoring
· Specifically from Telecom/BFSI industry
· Should know Linux administration as well.
· Worked with Development as well as Admin team.
· B.E/BTECH/MCA to be preferred.
Core Requirements:
1. Must possess excellent written and verbal communication skills.
2. Must possess business understanding and external awareness.
3. An Individual contributor and strong team player
4. Energetic, Innovative and critical thinking.
Interested share cv on ravinder.kaur@inventum.net
· Performance Tuning
· Query analysis and optimization
· Backup (Hot and Cold)
· Recovery and Replication
· Overall system health
· Developing Triggers/Stored Procedures
· Query optimization
· Developing SQL reports and business logic for Multiple Applications.
· Staging, testing and development of database
· Installation & Maintenance Multiple Database servers like: Postgres/My SQL
· HA and Clustering setup for Databases.
· Documentation of schema
· Schema Management, updates and rollbacks.
Role Requirements:
· Minimum 5 year of experience in administration
· Must know about the Sharding Concept.
· Knowledge of SLONY (replication)/PG9 Streaming Replication/Other replication tools
· Complete knowledge of ANSI SQL dialect is a must.
· Database maintenance (hot and full backups, vacuuming, indexing)
· Database optimizations (OS specific (Linux and Solaris) optimizations, query analysis and tuning)
· Should be able to write basic scripts to load data into DB, and export to various formats
· Knowledge of redhat/centOS/other linux OS
· Basic Shell Scripting for automating tasks
· Migrations, database monitoring
· Specifically from Telecom/BFSI industry
· Should know Linux administration as well.
· Worked with Development as well as Admin team.
· B.E/BTECH/MCA to be preferred.
Core Requirements:
1. Must possess excellent written and verbal communication skills.
2. Must possess business understanding and external awareness.
3. An Individual contributor and strong team player
4. Energetic, Innovative and critical thinking.
Interested share cv on ravinder.kaur@inventum.net
0 page views
Related listings
-
System Engineer Jobs Opening in A Client of Freshersworld at JaipurDatabase AdministratorSystem Engineer Job Description :- Knowledge in Database Administration MySQL and MariaDB Databases (PostgreSQL is an added advantage). Be actively involved in SEO efforts (keyword, image optimization etc.) Prepare online newsletters and promotional ...2026/11/07
-
Administrator FresherDatabase AdministratorSupporting company leadership and supervising administrative department activities for staff members. • Greeting office visitors and directing them to the appropriate parties. • Handling basic office tasks, such as filing, delivering mail, answering ...2026/11/07
-
AdministratorDatabase AdministratorAlso known as office administrators or office managers, administrators support office operations and leadership by keeping workspaces and information organized and accessible. They handle planning and clerical activities such as answering phones; upd...2026/11/07