PostgreSQL Db Administrator

2 weeks 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 Administration

    2 days ago

    Hyderabad, India LTIMindtree Full time

    Role: PostgreSQL-DB Administration Experience: 6 to 8 YearsJob Location: Hyderabad/PuneHybrid ModeFTE with LTIMindtreeShift: RotationalMandatory Skills: PostgreSQL-DB Administration, Cassandra DBAThanks & Regards,Prabal

  • PostgreSQL-DB Administration

    1 day ago

    Hyderabad, India LTIMindtree Full time

    Role: PostgreSQL-DB Administration Experience: 6 to 8 YearsJob Location: Hyderabad/PuneHybrid ModeFTE with LTIMindtreeShift: RotationalMandatory Skills: PostgreSQL-DB Administration, Cassandra DBAThanks & Regards,Prabal Pandey

  • PostgreSQL-DB Administration

    3 days ago

    hyderabad, India LTIMindtree Full time

    Role: PostgreSQL-DB Administration Experience: 6 to 8 Years Job Location: Hyderabad/Pune Hybrid Mode FTE with LTIMindtree Shift: Rotational Mandatory Skills: PostgreSQL-DB Administration, Cassandra DBA Thanks & Regards, Prabal Pandey Prabal.Pandey@alphacom.in

  • PostgreSQL-DB Administration

    1 day ago

    Hyderabad, India LTIMindtree Full time

    Role: PostgreSQL-DB AdministrationExperience: 6 to 8 YearsJob Location: Hyderabad/PuneHybrid ModeFTE with LTIMindtreeShift: RotationalMandatory Skills: PostgreSQL-DB Administration, Cassandra DBAThanks & Regards,Prabal

  • PostgreSQL-DB Administration

    8 hours ago

    Hyderabad, India LTIMindtree Full time

    Role: PostgreSQL-DB AdministrationExperience: 6 to 8 YearsJob Location: Hyderabad/PuneHybrid ModeFTE with LTIMindtreeShift: RotationalMandatory Skills: PostgreSQL-DB Administration, Cassandra DBAThanks & Regards,Prabal

  • PostgreSQL-DB Administration

    3 days ago

    hyderabad, India LTIMindtree Full time

    Role: PostgreSQL-DB AdministrationExperience: 6 to 8 YearsJob Location: Hyderabad/PuneHybrid ModeFTE with LTIMindtreeShift: RotationalMandatory Skills: PostgreSQL-DB Administration, Cassandra DBAThanks & Regards,Prabal PandeyPrabal.Pandey@alphacom.in

  • PostgreSQL

    4 weeks ago

    Hyderabad, India LTIMindtree Full time

    Role: PostgreSQL Admin Experience: 5 to 8 Years Job Location: Bangalore Hybrid Mode FTE with LTIMindtree Notice Period: Immediate to 30 days Please do not apply Notice Period with more than 30 days of Notice Period Mandatory Skills: PostgreSQL-DB Administration, Azure Database Service, AWS Database Service, Linux Thanks & Regards, Prabal Pandey

  • PostgreSQL

    4 weeks ago

    Hyderabad, India LTIMindtree Full time

    Role: PostgreSQL Admin Experience: 5 to 8 Years Job Location: Bangalore Hybrid Mode FTE with LTIMindtree Notice Period: Immediate to 30 days Please do not apply Notice Period with more than 30 days of Notice Period Mandatory Skills: PostgreSQL-DB Administration, Azure Database Service, AWS Database Service, Linux Thanks & Regards, Prabal Pandey

  • PostgreSQL, Oracle Database

    3 weeks ago

    Hyderabad, India Fusion Plus Solutions Full time

    Job Description Roles and Responsibilities - Data Base Administration, Data Modeling, Create and manage DBs, Backup & Recovery, Monitoring health of - DB Servers, Query Tuning, DB parameter tuning, Server Sizing, Networking, Scripts - Unix/Shell/Python, Data Migration, Reporting, - Data Analysis, Data Visualization, Documentation, PostgreSQL, - Azure, SQL...

  • PostgreSQL Dba

    2 weeks 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**,...