PostgreSQL DBA

1 month ago

Pune, India Groupsoft US Inc Full time
As a Postgres Database Administrator, your primary responsibility is to design, develop, and optimize PostgreSQL database solutions that meet the requirements of software applications and business processes. This involves collaborating with software developers and stakeholders to understand data needs and translate them into efficient database designs. You'll play a crucial role in database schema design, indexing strategies, and query optimization to enhance overall system efficiency. Proficiency in SQL, PL/pgSQL, and PostgreSQL features is essential, along with strong problem-solving skills and a deep understanding of database architecture principles. Moreover, you will be expected to advise on best practices for database development and maintenance, providing guidance on performance optimization, scalability, and data security. Creating and maintaining maintenance scripts for tasks such as backups, performance monitoring, and database optimization will also be part of your responsibilities, ensuring the smooth operation of PostgreSQL database systems in production environments.

  • Design and optimize PostgreSQL database solutions in collaboration with software developers, data analysts, and stakeholders.
  • Translate data requirements into efficient database designs and implement data manipulation logic using SQL, PL/pgSQL, and PostgreSQL features.
  • Write complex SQL queries, stored procedures, triggers, and functions to ensure data integrity and improve system performance.
  • Play a crucial role in indexing strategies and query optimization to enhance overall system efficiency.
  • Advise on best practices for database development and maintenance, including performance optimization, scalability, and data security.
  • Create and maintain maintenance scripts for tasks such as backups, performance monitoring, and database optimization to ensure smooth operation of PostgreSQL database systems in production environments.
  • Provide technical support and troubleshooting for database-related issues as needed.
  • Document database designs, configurations, and maintenance procedures for reference and knowledge sharing within the team.
  • Knowledge transfer to development teams.


Requirements
  • Proficiency in SQL (Structured Query Language) for data manipulation and querying.
  • Strong understanding of PL/pgSQL for developing stored procedures, triggers, and functions in PostgreSQL.
  • In-depth knowledge of PostgreSQL features and functionalities, including advanced features such as partitioning, replication, and JSONB data types.
  • Experience with OLAP database schema design
  • Ability to optimize SQL queries and database performance using techniques such as indexing, query tuning, and analyzing execution plans.
  • Familiarity with database security principles and best practices, including access controls, encryption, and authentication mechanisms.
  • Experience in creating and maintaining maintenance scripts for tasks such as backups, monitoring, and performance optimization.
  • Understanding of database high availability and disaster recovery solutions, such as replication, clustering, and failover mechanisms.
  • Proficiency in version control systems like Git for managing database schema changes and configurations.
  • Understanding of data warehousing concepts and techniques for managing large volumes of data effectively.
  • Experience with database administration tasks such as database installation, configuration, and upgrades is a plus.
  • Strong problem-solving skills and ability to troubleshoot database-related issues effectively.
  • Familiarity with cloud-based database solutions like Amazon RDS, Google Cloud SQL, or Azure Database for PostgreSQL is advantageous.


  • PostgreSQL DBA

    1 month ago

    Pune, India Groupsoft US Inc Full time

    Job DescriptionAs a Postgres Database Administrator, your primary responsibility is to design, develop, and optimize PostgreSQL database solutions that meet the requirements of software applications and business processes. This involves collaborating with software developers and stakeholders to understand data needs and translate them into efficient database...

  • PostgreSQL Dba

    6 months ago

    Pune, Maharashtra, India REQS Technologies India Pvt Ltd Full time

    JD: PostgreSQL Developer Location: - Pune **Position type**:Contractor - PG(PostgreSQL) Developer resource with 6-8 years’ experience - Should be well versed with PG concepts and should have hands-on knowledge of PG - Should be currently working on a development project - Should be knowing all PG objects - Hands on experience SQL Development side as...

  • PostgreSQL Database Administrator

    6 months ago

    Pune, India ALIQAN Technologies Full time

    **Hiring PostgreSQL Data base Administrator for one of our client MNC** Experience required: 8+ years minimum. Contract duration: 6 months + extendable. Must have skills: DBA, Schema design, Data dictionaries, RDS, Prem sql server Hands on exp. in PostgreSQL Must have worked on AWS cloud platform Shift: Normal shift Location: Remote. Require only...

  • MySQL Dba

    6 months ago

    Pune, India ASPIRE NXT PTE. LTD. Full time

    Database Administrator (DBA) **Responsibilities**: - Install, configure, and maintain multiple database systems including but not limited to Oracle, SQL Server, MySQL, and PostgreSQL. - Monitor and optimize database performance to ensure fast query execution and high availability. - Design and implement backup and disaster recovery strategies to ensure...

  • PostgreSQL Dba

    7 months ago

    Pune, Maharashtra, India UBS Full time

    India - Information Technology (IT) - Group Functions **Job Reference #** - 291413BR **City** - Pune **Job Type** - Full Time **Your role** - You’ll be working in the 'Global Reconciliations Utility' IT team in Pune. ‘Global Reconciliations Utility' IT (GRU IT) is responsible to deliver an efficient, high quality set of end to end IT Services...

  • PostgreSQL Database Administrator

    3 weeks ago

    Pune, India Infosys Full time

    Candidate should have an experience of 4 - 6 years as a PostgreSQL Database Administration with in-depth knowledge of PostgreSQL database architecture and should have worked on latest versions of EnterpriseDB and community PostgreSQL Databases likeon EPAS 14, EPAS15, PostgreSQL 13,14,15Responsibilities:Must have expertise in Installing, configuring,...

  • Lead PostgreSQL Database Administrator

    1 month ago

    Pune, India FPL Technologies Full time

    About FPL Technologies:Credit cards haven't changed much for over half a century so our team of seasonedbankers, technologists, and designers set out to redefine the credit card for you - theconsumer. The result is OneCard - a credit card reimagined for the mobile generation.OneCard is India's best metal credit card built with full-stack tech. It is backed...

  • PostgreSQL Dba

    6 months ago

    Pune, Maharashtra, India Virtusa Full time

    strong working experience with PostgreSQL activities like supporting implementations, Upgrades, ongoing maintenance and implementing Golden Gate Installing, configuring, troubleshooting and maintaining of databases on Test and Production( with Local Resilience ) Database Architecture & design, RTO (recovery time objective) & RPO (recovery point...

  • Lead PostgreSQL Database Administrator

    1 month ago

    Pune, India FPL Technologies Full time

    About FPL Technologies:Credit cards haven't changed much for over half a century so our team of seasonedbankers, technologists, and designers set out to redefine the credit card for you - theconsumer. The result is OneCard - a credit card reimagined for the mobile generation.OneCard is India's best metal credit card built with full-stack tech. It is backed...

  • Lead PostgreSQL Database Administrator

    1 month ago

    pune, India FPL Technologies Full time

    About FPL Technologies:Credit cards haven't changed much for over half a century so our team of seasonedbankers, technologists, and designers set out to redefine the credit card for you - theconsumer. The result is OneCard - a credit card reimagined for the mobile generation.OneCard is India's best metal credit card built with full-stack tech. It is backed...

  • PostgreSQL Database Administrator

    3 weeks ago

    Pune, India Infosys Full time

    Candidate should have an experience of 4 - 6 years as a PostgreSQL Database Administration with in-depth knowledge of PostgreSQL database architecture and should have worked on latest versions of EnterpriseDB and community PostgreSQL Databases like on EPAS 14, EPAS15, PostgreSQL 13,14,15Responsibilities:Must have expertise in Installing, configuring,...

  • PostgreSQL Database Administrator

    3 weeks ago

    Pune, India Infosys Full time

    Candidate should have an experience of 4 - 6 years as a PostgreSQL Database Administration with in-depth knowledge of PostgreSQL database architecture and should have worked on latest versions of EnterpriseDB and community PostgreSQL Databases like on EPAS 14, EPAS15, PostgreSQL 13,14,15Responsibilities:Must have expertise in Installing, configuring,...

  • PostgreSQL Database Administrator

    3 weeks ago

    Pune, India Infosys Full time

    Candidate should have an experience of 4 - 6 years as a PostgreSQL Database Administration with in-depth knowledge of PostgreSQL database architecture and should have worked on latest versions of EnterpriseDB and community PostgreSQL Databases like on EPAS 14, EPAS15, PostgreSQL 13,14,15 Responsibilities: Must have expertise in Installing, configuring,...

  • Lead PostgreSQL Database Administrator

    1 month ago

    Pune, India FPL Technologies Full time

    About FPL Technologies:Credit cards haven't changed much for over half a century so our team of seasonedbankers, technologists, and designers set out to redefine the credit card for you - theconsumer. The result is OneCard - a credit card reimagined for the mobile generation.OneCard is India's best metal credit card built with full-stack tech. It is backed...

  • Lead PostgreSQL Database Administrator

    1 month ago

    pune, India FPL Technologies Full time

    About FPL Technologies: Credit cards haven't changed much for over half a century so our team of seasoned bankers, technologists, and designers set out to redefine the credit card for you - the consumer. The result is OneCard - a credit card reimagined for the mobile generation. OneCard is India's best metal credit card built with full-stack tech. It is...

  • Lead PostgreSQL Database Administrator

    1 month ago

    Pune, India FPL Technologies Full time

    About FPL Technologies: Credit cards haven't changed much for over half a century so our team of seasoned bankers, technologists, and designers set out to redefine the credit card for you - the consumer. The result is OneCard - a credit card reimagined for the mobile generation. OneCard is India's best metal credit card built with full-stack...

  • Lead PostgreSQL Database Administrator

    1 month ago

    Pune, India FPL Technologies Full time

    About FPL Technologies:Credit cards haven't changed much for over half a century so our team of seasonedbankers, technologists, and designers set out to redefine the credit card for you - theconsumer. The result is OneCard - a credit card reimagined for the mobile generation.OneCard is India's best metal credit card built with full-stack tech. It is backed...

  • Lead PostgreSQL Database Administrator

    1 month ago

    Pune, India FPL Technologies Full time

    About FPL Technologies: Credit cards haven't changed much for over half a century so our team of seasoned bankers, technologists, and designers set out to redefine the credit card for you - the consumer. The result is OneCard - a credit card reimagined for the mobile generation. OneCard is India's best metal credit card built with full-stack...

  • Database Administrator PostgreSQL

    6 months ago

    Pune, Maharashtra, India Clarion Technologies Full time

    ID : 2336 Experience 5 - 7 years Location Pune About Clarion Technologies Clarion Technologies is an IT services company providing customized software solutions to small & medium businesses globally in a broad spectrum of industries. With 20+ years of expertise in Digital Transformation, we help our customers to improve their business performance...

  • Mongo Dba

    3 months ago

    Pune, Maharashtra, India Zensar Technologies Full time

    **JOB DESCRIPTION**: - Exp of 5-8 years in database administration. - Good hands-on experience on Database Administration, deep understanding of DBA concepts, best practices. - Experience on Installation, configuration and upgrading MongoDB software and products. - Creating and sizing database storage structures and database objects - Experience on managing...