PostgreSQL Dba

3 months 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

  • PostgreSQL Dba

    2 months ago

    Andhra Pradesh, India Virtusa Full time

    8 to 10 years of PostgreSQL DBA experience, community PostgreSQL Version 13(or higher) Experience investigating/troubleshooting & resolving PostgreSQL performance issues, SQL query tuning and optimization. Communication and Analytical Skills. Experience in Database Administration, specifically in Postgresql Strong Administrative Assistance and Customer...

  • SQL Dba

    6 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...

  • MsSQL-dba

    1 week ago

    Noida, Uttar Pradesh, India Pine Labs Full time

    Required Experience **5 - 12 Years** - Skills **MSSQL,** **Replication,** **AOAG** + 7 more **Job Description - Senior Engineer DBA (IC)** We at Pine Labs are looking for those who share our core belief - Every Day is Game day. We bring our best selves to work each day to realize our mission of enriching the world through the power of digital commerce...

  • Peoplesoft Dba

    7 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

    7 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...

  • Highly Skilled Greenplum DBA

    5 days ago

    Andhra Pradesh, India Spigot Software Full time

    About the Opportunity:Spigot Software is seeking a highly skilled Greenplum DBA to join our team. As a key member of our database administration team, you will be responsible for designing, implementing, and maintaining large-scale Greenplum database systems.Key Responsibilities:Design and implement high-performance database architectures and schema...

  • Database Administrator

    6 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

    4 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

    6 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 Architect

    1 month ago

    uttar pradesh, India HCLTech Full time

    Having 8+ years of IT experience• 5+ years of PostgreSQL DBA experience• In-depth knowledge of PostgreSQL architecture version 9& above• Install, upgrade, migrate PostgreSQL rdbm• Expertise in Performance tuning.• Expertise in PostgreSQL Backup and recoveries• Strong knowledge in Database architecture• Other database experience such as Oracle,...

  • SQL Server Dba

    3 months ago

    Noida Sector 62, Noida, Uttar Pradesh, India Akscellence Info Solutions LLP Full time

    **Qualifications**: - 5-7 years of experience as a Database Administrator or similar role. - Proficiency in managing Microsoft SQL Server and PostgreSQL on Azure. - Knowledge of ETL/ELT data pipelines and Data warehousing on Azure. - Experience with database performance tuning and optimization techniques. - Solid understanding of database security and data...

  • Excelra - Senior Database Engineer - PostgreSQL/PL-SQL

    2 weeks ago

    Hyderabad/Andhra Pradesh/Telangana/Vijayawada/Vishakhapatnam/Vizag, India Excelra Knowledge Solutions Full time

    Excelra hiring for Senior Database EngineerJob Description : - Database engineer will be working as an SQL, PL/SQL developer, preferably PostgreSQL, Oracle, and MySQL with good knowledge on query analysis/performance. - Experience in managing DB loads and data migration with hands- on experience in ETL (Extract, Transform and Load) by writing efficient SQL...

  • SQL Dba

    4 months 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

    6 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...

  • Senior Database Administrator

    1 month ago

    uttar pradesh, India Coforge Full time

    Title: Database Administrator Skills: Postgre Database administration, MSSQL, clustering, backup and recovery. Experience: 5-12 Years Location: Greater Noida Notice Period: Immediate to 30 would be preferred The PostgreSQL DBA will work closely with our development and operations teams to ensure seamless migration from MSSQL Servers, database operations and...

  • CIPL - Corporate Infotech Pvt Ltd | Database Administrator | uttar pradesh

    4 weeks ago

    uttar pradesh, India CIPL - Corporate Infotech Pvt Ltd Full time

    We are looking for talented ETL and Database Administrators (DBA) to join our growing team. If you have a passion for optimizing data processes, managing complex databases, and driving business intelligence solutions, we want to hear from you! a) BE/B Tech, MCA In Computer Science, IT b) Should be expert of PostgreSQL database system. c) Create the...

  • Database Administrator

    3 months 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...

  • CIPL - Corporate Infotech Pvt Ltd | Database Administrator | uttar pradesh

    3 weeks ago

    uttar pradesh, India CIPL - Corporate Infotech Pvt Ltd Full time

    We are looking for talented ETL and Database Administrators (DBA) to join our growing team. If you have a passion for optimizing data processes, managing complex databases, and driving business intelligence solutions, we want to hear from you!a) BE/B Tech, MCA In Computer Science, ITb) Should be expert of PostgreSQL database system.c) Create the objects...

  • SQL Dba

    6 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...

  • Senior Database Administrator

    1 month ago

    uttar pradesh, India Coforge Full time

    Title: Database AdministratorSkills: Postgre Database administration, MSSQL, clustering, backup and recovery.Experience: 5-12 YearsLocation: Greater NoidaNotice Period: Immediate to 30 would be preferredThe PostgreSQL DBA will work closely with our development and operations teams to ensure seamless migration from MSSQL Servers, database operations and...