PostgreSQL Dba

4 days ago

Bhopal Madhya Pradesh, India Xtranet Technologies Private Limited Full time

We are seeking a highly skilled and motivated **PostgreSQL Database Administrator** to manage our PostgreSQL database instances and related infrastructure. The DBA will be responsible for monitoring, maintaining, and optimizing PostgreSQL database performance, focusing on leveraging PostgreSQL statistics and other tools to ensure optimal performance and uptime.

**Key Responsibilities**:

- **Database Management**:

- Oversee the installation, configuration, and management of multiple PostgreSQL database instances.
- Manage database clusters across various servers, ensuring high availability, fault tolerance, and redundancy.
- **Performance Monitoring**:

- Regularly monitor PostgreSQL system performance using tools like pg_stat_activity, pg_stat_statements, and other PostgreSQL system views.
- Monitor key performance indicators (KPIs) such as query execution time, disk I/O, CPU utilization, memory usage, and cache hit ratios.
- **Optimization**:

- Identify slow queries, bottlenecks, and performance issues by analyzing system statistics.
- Optimize database performance through query tuning, indexing strategies, partitioning, and configuration adjustments (e.g., adjusting shared buffers, work_mem, maintenance_work_mem, etc.).
- Propose and implement index optimization, table partitioning, and other techniques to enhance performance.
- **Maintenance and Upgrades**:

- Manage routine maintenance tasks such as database backups, restores, vacuuming, and reindexing.
- Ensure databases are regularly vacuumed and analyzed to prevent bloat and maintain statistics accuracy.
- Plan and perform PostgreSQL version upgrades and patches.
- **Security and Compliance**:

- Ensure database security by managing access controls, user permissions, and roles.
- Monitor for unauthorized access and ensure compliance with data protection regulations.
- Implement and maintain data encryption, replication, and disaster recovery strategies.
- **Automation and Scripting**:

- Automate database monitoring and maintenance tasks using tools like cron, pg_cron, or custom scripts.
- Write scripts to monitor database health, alerting the team of potential issues (e.g., long-running queries, deadlocks, connection pool exhaustion).
- **Capacity Planning**:

- Forecast database growth and ensure the infrastructure is ready to handle increased traffic and data volumes.
- Manage database scaling (vertical and horizontal) and storage allocation.
- **Troubleshooting**:

- Investigate and resolve database-related performance issues and outages in a timely manner.
- Analyze and resolve deadlock issues, lock contention, and long-running queries.
- **Collaboration**:

- Work closely with the development and operations teams to support new features, database schema changes, and query optimizations.
- Provide guidance to developers on best practices for writing efficient SQL queries and database usage patterns.

**Qualifications**:

- **Education**: Bachelor's degree in Computer Science, Information Technology, or related field (or equivalent experience).
- **Experience**:

- 3+ years of experience as a PostgreSQL DBA.
- Hands-on experience with PostgreSQL system views (pg_stat_activity, pg_stat_statements, pg_stat_user_tables, etc.).
- Familiarity with PostgreSQL configuration tuning and maintenance tasks such as VACUUM, ANALYZE, REINDEX.
- **Technical Skills**:

- Proficient in PostgreSQL query optimization techniques and index management.
- Solid understanding of PostgreSQL architecture and internals (MVCC, WAL, replication, etc.).
- Experience with monitoring tools like **pgAdmin**, **pgBouncer**, **Prometheus**, **Grafana**, or similar.

Pay: ₹500,000.00 - ₹800,000.00 per year

**Experience**:

- total work: 5 years (required)
- PostgreSQL DBA: 5 years (required)

Work Location: In person

  • SQL Dba

    3 months ago

    Bhopal, Madhya Pradesh, India Ruchi Security Printers Pvt Ltd Full time

    **Full Job Description**: Your responsibility as a database administrator (DBA) will be **the performance, integrity and security of a database**. You'll be involved in the planning and development of the database, as well as in troubleshooting any issues on behalf of the users. You'll ensure that: data remains consistent across the database. **Database...

  • Database Administrator

    3 months ago

    Bhopal, India Ruchi Security Printers Pvt Ltd Full time

    our responsibility as a database administrator (DBA) will be the performance, integrity and security of a database. You'll be involved in the planning and development of the database, as well as in troubleshooting any issues on behalf of the users. You'll ensure that: data remains consistent across the database. Database Administrator Job...

  • Peoplesoft Dba

    4 months ago

    Noida, Uttar Pradesh, India Cranium Information Technology Full time

    **Position: PeopleSoft DBA** **Location: Noida** **Experience: 1+ Years** **Responsibilities**: - Install, configure, and maintain database software and related tools. - Monitor database performance and proactively identify and resolve issues. - Ensure data integrity and security by implementing access controls, backups, and disaster recovery plans. -...

  • Database Administrator

    4 months ago

    Noida, Uttar Pradesh, India Meon technologies pvt. ltd. Full time

    Job Title: Database Administrator (DBA) Location: Noida Position Overview: Key Responsibilities: Manage and maintain database systems to ensure optimal performance and availability. Perform database backups, restores, and disaster recovery procedures. Monitor database performance and identify opportunities for optimization. Install, configure, and...

  • Database Administrator

    3 weeks ago

    Bhopal, Madhya Pradesh, India Ruchi Security Printers Pvt Ltd Full time

    Your responsibility as a database administrator (DBA) will be the performance, integrity and security of a database. You'll be involved in the planning and development of the database, as well as in troubleshooting any issues on behalf of the users. You'll ensure that: data remains consistent across the database. **Database Administrator Job...

  • Database Administrator

    3 months ago

    Bhopal, Madhya Pradesh, India Ruchi Security Printers Pvt Ltd Full time

    Your responsibility as a database administrator (DBA) will be the performance, integrity and security of a database. You'll be involved in the planning and development of the database, as well as in troubleshooting any issues on behalf of the users. You'll ensure that: data remains consistent across the database. **Database Administrator Job...

  • Database Administrator

    3 months ago

    Bhopal, Madhya Pradesh, India Ruchi Security Printers Pvt Ltd Full time

    Your responsibility as a database administrator (DBA) will be the performance, integrity and security of a database. You'll be involved in the planning and development of the database, as well as in troubleshooting any issues on behalf of the users. You'll ensure that: data remains consistent across the database. **Database Administrator Job...

  • SQL Dba

    3 weeks ago

    Lucknow, Uttar Pradesh, India Mobineers Info System Pvt. Ltd Full time

    Responsibilities: - Write fast and preformat database queries using a flavor of SQL Server, such as MySQL, MSSQL, or PostgreSQL - Troubleshooting and problem-solving using JavaScript and other programming languages - Maintain and back up databases regularly - Perform SQL database sharding and indexing procedures as required to handle heavy traffic...

  • Database Administrator

    3 months ago

    Noida, Uttar Pradesh, India Codeclouds IT Solutions Pvt. Ltd Full time

    Hi, Urgent Opening for Database Administrator Experience - 8+ years Positions - 5 Job Location - Sec 7, Noida **Roles and Responsibilities** - This is a full-time/Part time on-site role for Database Administrator in Noida sector-7. - 8+ years of experience in using MSSQL Administration [DBA+ PostgreSQL]. - Administrator, develop, test, or demonstrate...

  • Database Administrator

    4 days ago

    Lucknow, Uttar Pradesh, India Vexil Infotech private Limited Full time

    **Database Administrator (DBA)** **About Company** **Position**:Database Administrator (DBA) **Experience**: 2+ years **Location**: Lucknow **Job Type**: Full-time The DBA is responsible for the performance, integrity, and security of databases. This role involves the design, implementation, maintenance, and repair of database systems, ensuring that data...

  • SQL Dba

    3 months ago

    Andhra Pradesh, India Virtusa Full time

    6 Plus Years of experience in below Working knowledge in database programming languages (in MSSQL/PostgreSQL/MySQL) Knowledge of database backup recovery, security and performance monitoring standards Understanding of database concepts ACID properties, normal forms, DDL/DML, transaction logging, log shipping, Mirroring, High-Availability etc Understanding of...

  • SQL Database Administrator

    3 months ago

    Vishal Khand, Lucknow, Uttar Pradesh, India CMP Techsseract LLP Full time

    Qualifications - **Education**: - Bachelor’s degree in Computer Science, Information Technology, or a related field. - Relevant certifications (e.g., Oracle DBA, Microsoft SQL Server, MySQL, etc.) are a plus. - **Experience**: - Proven experience as a Database Administrator or in a similar role. - Experience with database management systems (DBMS) such...

  • SQL Database Administrator

    3 months ago

    Noida, Uttar Pradesh, India Ascentrik Research Services Full time

    We are hiring for role of "MySQL Database Administrator(DBA)". **Responsibilities**: - Install, configure, and maintain MySQL database systems. - Monitor database performance and optimize queries for improved efficiency and scalability. - Implement and maintain database security measures to protect sensitive data. - Perform database backups, restores, and...