• Postgres Admin

Industry IT-Software / Software Services / testing
Location Karnataka Bangalore
Experience Range 8 - 10 Years
Qualification (Graduate btech)

Functional Banking, Insurance & Financial Services
Job Description
About Us
Affluent is a 6+ years old organization with a strength of 550+ employees providing Project Services and Managed services support to our clients. We are a very stable financial company with revenues of 90CR and a total strength of 500+ employees spread across Hyderabad, Bangalore, Pune, Mexico and North America. Being an ISO 9001:2015 Company, we are also Microsoft authorized Gold Partner and Cloud Solution Provider. Our Clients include but not limited to Microsoft, Deloitte, All State, State Street, Nomura, HoneyWell, Fiserv, Oracle, IBM, Bajaj and BNP; supported from our Indian offices in Hyderabad (Financial District & ODC at Kondapur), Bangalore and Pune.
Roles and Responsibility

Job Title: Postgres Admin


Primary Skills

?Strong command of SQL and SQL server tools

?Advanced knowledge of database security, backup and recovery, and performance monitoring standards

?Understanding of relational and dimensional data modeling

?PowerShell and Unix shell scripting skills

?Excellent written and verbal communication skills

?Impeccable attention to detail


7 - 10 Years

Shift Timing

2-11 PM IST


Job Description

The Senior Postgre SQL DBA would need to have at least 7 years of experience. This Candidate is responsible for full life cycle support of internal database(s).


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.


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.

Job Responsibilities

-         5-10 year of database experience.


-         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




A+| A| A-