Postgres Admin
- Affluent Global
- 7 to 10 Yrs
- Bengaluru
- 3 years ago
- Email to a friend
- Report this job
Job Description
Dear candidates,
Greetings,
Profile: Postgres Admin
Work Location:Bangalore
Experience:7 to 10 Years
Primary Skills
1. Strong command of SQL and SQL server tools
2. Advanced knowledge of database security, backup and recovery, and performance monitoring standards
3. Understanding of relational and dimensional data modeling
4. PowerShell and Unix shell scripting skills
5. Excellent written and verbal communication skills
6. Impeccable attention to detail
Job Description
1. The Senior Postgre SQL DBA would need to have at least 7years of experience. This Candidate is responsible for full life cycle support of internal database(s).
2. The DBA works within an environment of rapid growth and must anticipate and respond effectively to needs as they emerge. This position is expected to design, develop, enhance and monitor all production and test databases that exist within the technical architecture.
3. The Database Administrator will be working with development , providing technical and operational support activities of Database Servers, including logical and physical database design support, troubleshooting, performance monitoring, tuning, and optimizing.
Key responsibilities:
- Experienced with PostgreSQL & PostgreSQL Architecture
- Ability to independently monitor and administrator databases.
- Creation & managing PostgreSQL schema, tables, tablespaces and users, roles & groups.
- PostgreSQL Index Management, Partitioning and System Catalogs
- Performance tuning, Query tuning by generating and explaining plan for SQL queries.
- Expert in Backup & Recovery including Pg dump, setting up WAL archiving, Point in time recovery.
- knowledge on PGAdmin and other PostgreSQL tools and utilities.
- Knowledge on High Availability, streaming replication, Replication Failover, repmgr, barman, pgbouncer and pg_pathman.
- Monitoring Alert Log, scheduled jobs and troubleshooting database problems.
- Hands on maintenance activities such as vacuum, vacuum full, analyze the database.
- 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 issues.
- Understanding of UNIX environment with shell scripting.
- Evaluate new database technologies and products and recommend to technical management
- Contribute to document company database standards, guidelines and operational procedures
- Perform a variety of tasks relying on experience and judgment to manage time, plan and accomplish goals on several client engagements
- Provide 24 x 7 x 365 support through on-call rotation
If interested pls specify the skill set in the subject line & provide the following details along with a copy of your resume on*******a@af*******s.com
Current CTC
Expected CTC
Notice Period
Current Location
Regards,
Team HR
Employement Category:
Employement Type: Full timeIndustry: IT - Software
Role Category: Network / System Administration
Functional Area: Not Applicable
Role/Responsibilies: Postgres Admin
Contact Details:
Company: Affluent GlobalLocation(s): Bengaluru
Similar positions
Affluent Global
Affluent Global Services Pvt. Ltd. About the Employer Established in 2015, Affluent Global IT PRIVATE LIMITED is an Emerging Systems Integration company providing end-to-end IT Infrastructure management solutions and services to enterprises across India and globally. The company has been conferr...
Job Listings
We are in open beta version of website, please let us know if any issues, at: info(at)indigojobs.in
