Postgres Dba Developer

About the Employer
Annual Salary
Not disclosed

Job Description

About Job CTC Undisclosed Job Location Pune Experience 1 - 3 yrs Description Qualification : BE/ ME/ BCA/ MCA- Any Computer/ IT Degree Experience : 1 - 3 YearsSkills : Postgres Sql, Develoment, Design, Designinig, DevelopmentJob Description :What We Have In Store For You:Ability to independently monitor and administrator databases.Creation & managing PostgreSQL schema, tables, tablespaces and users, roles & groups.Performance tuning, Query tuning by generating and explaining plan for SQL queries.Expert in DBA functions like managing databases, backups & restore, scheduling jobs, space, performance management, principles of database replication, scalability and high availability.Expert in Backup & Recovery including Pg dump, setting up WAL archiving, Point in time recovery.Monitoring Alert Log, scheduled jobs and troubleshooting database problems.Understanding of basic database fundamentals: multi-version control, concurrency, transactions, indexing, locking.Analyze, recommend, and... implement configuration for Optimized Performance.Ability to plan hardware capacity requirements for storage, memory and CPU Cycles.Expert with setting and trouble shoot replication.Ability to configure and trouble shoot, log shipping, cascading standbys, partial replication, continuous recovery, detach and reattach slaves.Understanding of UNIX environment with shell scripting.You Fit The Bill If:1-3 years of relevant Postgre DBA experience.Educational Qualification: B.E /B. Tech.Ability to identify defects in the environment and proactively intervene to reduce downtime.Hands on maintenance activities such as vacuum, full vacuum, analyze the database.Server configuration and client authentication.In-depth knowledge of Database Security.Data Replication - Streaming replication.Excellent written and oral communication skill.Ready to work in night shifts.Good To Have:Knowledge of Postgres Benchmarking which included (Ext3, BTRFS,XFS, Free BSD with ZFS, Free BSD with UFS)SQL language: - DDL and DML, Queries, Multi-version Concurrency Control (MVCCRead more

Page Generated in : 0.0021350383758545 Sec.