Patna, Koch Bihar, Patna City
Overview of the Role
Manages, maintains, and secures data systems so that users can perform business-related functions. Responsible for data storage, organization, display, utilization, and analysis from a technological standpoint.
Key Responsibilities
• PostgreSQL Database DBA on Linux
• The job includes working with the various technology teams, vendors, and management of new hardware and operating systems infrastructure.
• Responsible for the installation, configuration database servers /Replication, Pgpool etc.
• Responsible for interacting with DB OEM team for raising tickets & get resolutions.
• Responsible for monitoring & maintaining database servers in Development, QA, Staging & Production environment.
• Atleast 7 years of experience as a DBA of PostgreSQL in production environment including backup recovery, replication, high availability, monitoring diagnosing and optimizing database performance.
• Ability to detect and troubleshoot database-related CPU, memory, IO, disk space, and other resource contention issues.
• Proficient with database tuning and use of PostgreSQL tools such as PgBadger, EDBs PgStatsPack, EDBs DRITA
• Proficient with PostgreSQL replication technologies Binary Streaming Replication, xDB Replication,
• Logical Replication
• Proficient with PostgreSQL networking, HBA and connection pooling (PgBouncer, PgPool)
• Knowledge of high availability, disaster recovery and replication solutions and best practices
• Demonstrated experience implementing deploying database servers.
• Expertise in writing SQL queries, analyzing query performance using query plans and tuning query
• performance.
• Database Performance Tuning and Optimization, using native monitoring and 3rd party tools.
• Strong communications skills and ability to document and present complex designs to a wider audience.
Qualifications:
BE/MCA or equivalent with specialization in computers
PostgreSQL RDBMS Database Administration
EDB PostgreSQL Certification is preferable
Experience | 7 - 9 Years |
Salary | 10 Lac To 13 Lac P.A. |
Industry | IT Software - DataBase / Datawarehousing |
Qualification | B.E, M.C.A, M.Tech |
Key Skills | Postgre SQL SQL Database Administrator |
(15)IT Software - Application Prog...
(6)Accounting / Auditing / Taxati...
(4)IT Software - ERP / CRM / EDP ...
(4)IT Software - Ecommerce / Inte...
(4)IT Hardware – Security / Ope...
(4)Sales & Marketing / Business D...
(4)Legal / Law Services / Judicia...
(4)IT Hardware / Technical Suppor...
(3)HR / Recruitment / Administrat...
(3)Analytic and Business Intellig...
(2)Marketing / Advertising / PR /...
(2)ITES / BPO / KPO / LPO / Custo...
(1)Corporate Planning & Strategy ...
(1)IT Software - DataBase / Dataw...
(1)Manufacturing / Production / Q...
(1)Engineering / Engineering Desi...
(1)Front Office / Reception / Com...
View MoreHi! Simply click below and type your query.
Our experts will reply you very soon.