Database Database Administrator,postgres Sql
Job Description
Job Profile : Database Database Administrator,Postgres SQL
Job Location : Mumbai
Experience Required : 2-4 yrs
: Experience: 2-8 years
Skills : Good hands-on experience on PostgreSQL DBA. Good to have experience on YugabyteDB.
Create the objects in the database, such as triggers, indexes, etc.
Able to setup streaming replication between two databases
Monitor the performance of the database and ensure optimum performance.
Identify potential issues in the database to solve them early.
Maintain backups and should be able to restore the databse
Monitor security and apply preventive measure to adhere security guidelines
Schedule consistent maintenance on the server
Maintain database schema
Manage database availability
Give best practice guidance to the development team
Resolve any production data issues
Taplespace management
Role and privilege management
Develop automation technologies to accelerate the process of data loading.
Develop relational databases
Ensure data integrity
Manage user access and permissions by adding and removing users as required
Maintain the database using different utilities. This includes using like pg_ctl and psql.
Should be able to write complex queries, function / procedure to get required data
Should be able to analyse cost of the query and do necessary changes to improve performance
Location: Mumbai (Airoli)
MNCJobsIndia.com will not be responsible for any payment made to a third-party. All Terms of Use are applicable.
Related Jobs
Job Detail
-
Job IdJD3576295
-
IndustryNot mentioned
-
Total Positions1
-
Job Type:Full Time
-
Salary:Not mentioned
-
Employment StatusPermanent
-
Job LocationMH, IN, India
-
EducationNot mentioned
-
ExperienceYear