Hyderabad Jobs |
Banglore Jobs |
Chennai Jobs |
Delhi Jobs |
Ahmedabad Jobs |
Mumbai Jobs |
Pune Jobs |
Vijayawada Jobs |
Gurgaon Jobs |
Noida Jobs |
Hyderabad Jobs |
Banglore Jobs |
Chennai Jobs |
Delhi Jobs |
Ahmedabad Jobs |
Mumbai Jobs |
Pune Jobs |
Vijayawada Jobs |
Gurgaon Jobs |
Noida Jobs |
Oil & Gas Jobs |
Banking Jobs |
Construction Jobs |
Top Management Jobs |
IT - Software Jobs |
Medical Healthcare Jobs |
Purchase / Logistics Jobs |
Sales |
Ajax Jobs |
Designing Jobs |
ASP .NET Jobs |
Java Jobs |
MySQL Jobs |
Sap hr Jobs |
Software Testing Jobs |
Html Jobs |
Job Location | Pune |
Education | Not Mentioned |
Salary | Not Disclosed |
Industry | IT - Software |
Functional Area | General / Other Software |
EmploymentType | Full-time |
Associate DBA - PostgreSQL (1 - 4 Yrs) Associate DBA - PostgreSQL (1 - 4 Yrs) 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,
Keyskills :
database administrationbackuplinuxtroubleshootingsql serverlog shippingquery tuningperformance tuningoral communicationserver configurationperformance managementmaintenance activitiessqlzfscpuddldmlfitxfsunix