PostgreSQL Db Administrator

3 days ago

Hyderabad, India Axiom Full time

Roles and Responsibilities

Evaluate and analyze custom PostgreSQL server programs/T-SQLs for high performance issues

Create PostgreSQL objects like Tables, Views, Indexes, Stored Procedures, Triggers, Rules, Defaults and user defined functions and Extensive Knowledge of advance query concepts that includes Dynamic PostfreSQL scripting, Recursive CTE and Partitioning management

Hands on Advance PostgreSQL server concepts (Performance Tuning, Larger subqueries, JOINS, PerfMon tooling)

Analyze, tune & test identified top 30 programs, integrations and reports based on current CPU, I/O & throughput utilization and implement best practices recommended by PostgreSQL server for improved performance

Proficient in tuning queries using PostgreSQL server profiler, Execution Plan, Performance Monitor, DBCC Commands, Database Tuning Advisor,Index Fragmentation techniques to improve the database performance and ensure high availability

Document improvement in the PostgreSQL level metrics CPU, I/O requests, throughput, Files and File-groups to a desirable level

Report trace files comparison for the required parameters before and after the optimization for the improvement of statistics

Analysis trace files, Identify problem queries, I/O, Waits, Correlated sub queries and Parameters validation

Tune the queries and use Materialized or temp tables if required, Re-write the logic for better performance if required

Replace Correlated sub queries, reducing Loop Overhead for DML Statements and Queries

Monitor PostgreSQL Performance and IO

Production support on issues

**Skillsets**:
3 plus years of experience as PostgreSQL server DBA

Knowledge on AWS or Azure is a plus

Knowledge on MOngoDB is a plus

Working in 24/7 critical environment

AWS or Azure PostgreSQL Development knowledge

Excellent written and verbal communication skills.

Experience in database backup & restore activities.

  • PostgreSQL+db Scripting

    7 days ago

    Hyderabad, Telangana, India Cognizant Full time

    **Exp: 9.5 to 13 years** **Skill: PostgreSQL+DB Scripting** **Location : Bangalore/Hyderabad/Kolkata/Pune/Chennai** **Technical Skills**: Amazon Aurora,SQL,Amazon RDS,Data Modelling,DB Performance Optimization,DB Administration **Responsibilities**: - Lead the administration of database systems to ensure high availability and reliability. - Experience...

  • Postgresql Dba, Mongo Db

    3 days ago

    Hyderabad, Telangana, India Cognizant Full time ₹ 15,00,000 - ₹ 28,00,000 per year

    Role: Postgres SQL, Mongo DBLocation: Hyderabad (GAR Building)FulltimeNote: Kindly fill up below form Link.Link: ResponsibilitiesAdminister, manage, and optimize Postgres, MySQL, and Mongo DB databases.Monitor database performance and optimize queries for efficiency.Implement robust backup and recovery protocols.Ensure data security and compliance with...

  • PostgreSQL Dba

    3 days ago

    Hyderabad, Telangana, India Deqode Full time

    **Job Title**: PostgreSQL Database Administrator **Experience**: 6-8 Years **Work Mode**: Hybrid **Locations**: Hyderabad / Pune **Required Skills**: - Strong hands-on experience in **PostgreSQL administration** (6+ years). - Excellent understanding of **SQL** and **query optimization techniques**. - Deep knowledge of **database services**,...

  • PostgreSQL Database Administrator

    12 hours ago

    Hyderabad, Telangana, India Algoleap Technologies Full time ₹ 5,00,000 - ₹ 8,00,000 per year

    SUMMARY LOCATION: Mumbai, FortDOMAIN: PostgreSQL DatabaseLevel (L1/L2/L3): L2Required Relevant Domain Experience: 4-6 Years relevant experience Job Type (Onsite/Remote): OnsiteShift details (General/ 24X7): Onsite support 24 X 7Qualification:B.E./Diploma/BSC/BTech (No education gap, Full time)B.E. / Diploma [ In Computers Science, IT,Electronics &...

  • Database Administrator

    2 days ago

    Hyderabad, Telangana, India Tanla Platforms Limited Full time

    Job Scope:- Responsible for creating, monitoring and maintaining various databases - MySQL, Postgres, Oracle, ClickHouse including NoSQL databases like Cassandra, Mongo DB, Scylla DB etc.- Automating routine Database Administration, monitoring and alerting activities using shell scripting, python, Perl etc.- Providing DB design solutions, hands-on expert...

  • Senior PostgreSQL Professional

    5 days ago

    Hyderabad, Telangana, India beBeeDatabase Full time ₹ 18,00,000 - ₹ 25,50,000

    Job TitlePostgreSQL Database AdministratorWe are seeking a skilled Postgres DBA to join our team.About the RoleThis role requires designing, implementing, and maintaining high-performing Postgres databases. The ideal candidate should have hands-on experience in administering Postgres databases with 6+ years of experience.Writing complex SQL queries for...

  • Postgresql Database Administrator

    4 days ago

    Bengaluru, Chennai, Hyderabad, India Infosys Full time ₹ 9,00,000 - ₹ 12,00,000 per year

    Roles and Responsibilities :Design, implement, and maintain PostgreSQL databases for various applications.Perform routine maintenance tasks such as backups, patching, and monitoring to ensure high availability of the database.Troubleshoot issues with database performance, data integrity, and security.Collaborate with development teams to design scalable...

  • Oracle Database Administrator

    20 hours ago

    Hyderabad, India Humaniquee Full time

    **Job Scope**: - Responsible for creating, monitoring and maintaining various databases - MySQL, Postgres, MongoDB, Oracle, ClickHouse etc. - Automating routine Database Administration, monitoring and alerting activities using shell scripting, python, perl etc. - Providing requested data to Internal and external team using SQL or other tools. - Supporting...

  • Postgresql Database Administrator With Docker

    4 days ago

    Hyderabad, Telangana, India People Prime Worldwide Full time

    About Client One of our MNC clients offers technology consulting and digital solutions to global enterprises across industries enabling transformative scale at unparalleled speed With 145 000 professionals across 90 countries helping 1100 clients it provides a full spectrum of services including consulting information technology enterprise...

  • Database Administrator

    3 weeks ago

    Hyderabad, Telangana, India Tanla Platforms Limited Full time

    Job Scope: Responsible for creating, monitoring and maintaining various databases - MySQL, Postgres, Oracle, ClickHouse including NoSQL databases like Cassandra, Mongo DB, Scylla DB etc. Automating routine Database Administration, monitoring and alerting activities using shell scripting, python, Perl etc. Providing DB design solutions, hands-on expert using...