Job Details

Home Jobs Associate DBA - PostgreSQL

DBXento Systems Pvt. Ltd. Recruitment 2021 - Associate DBA - PostgreSQL - Pune Apply soon

Last modified: 21 Sep 2021 05:13:02 GMT

Full time

Role : Associate DBA - PostgreSQL

Share Job

Overview

Required Candidate skillset: database administration, backup, linux, troubleshooting, sql server.
Associate DBA - PostgreSQL (1 - 4 Years) Associate DBA - PostgreSQL (1 - 4 Years) 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 (MVCC). Apply Now Refer Friend,

Details

Desired Profile

3 Years

DBXento Systems Pvt. Ltd.

DBXento Systems Pvt. Ltd.

How to Apply

This is a online aggregated job, Apply online to visit the Company website to apply online.

10 Nov 2021



Disclaimer: FreshersHOME does not call candidates towards job offer or assistance. FreshersHOME does not charge any fee from candidates for jobs, Be aware of fradulant calls and emails, please write to [email protected]
Please Read Our Privacy Policy!, Terms of Usage and Check our Editorial Guidelines