Postgres SQL

2 weeks ago

Bengaluru Karnataka, India hyre global service pvt.ltd. Full time

Position: Specialist Systems Engineer-Postgres SQL

Exp: 4-8 Years

Location: Bangalore/Chennai

Work Mode: WHO & Permanent

**NP: Only Immediate**

Interview Process:

- Round of interviews of Client -3-4 rounds
- Mode of interviews -Virtual, can call F2F for final discussion.

**Key Responsibilities**
- Own 24* 7 database support; handling Incidents, Requests, Problems & Changes.
- Handle on-call database support during week-ends & out of business hours.
- Own & deliver various client & infra projects.
- Plan & deliver various projects around database patching, upgrades & migrations.
- Management of various tools/scripts being used for databases.
- Contribution towards automation of recurrent tasks.
- Ticket reduction through problem management.
- Manage disaster recovery tests & exercises.
- Identify & deliver various POCs (Proof of concepts) for latest RDBMS features, open source & new technologies.
- Work with other infra teams to optimize databases performance and reduce incidents probability.

**Profile**

Mandatory Skills and Experience:

- Experience on PG version - PG 12, PG 13, PG 14 & PG 15
- Excellent knowledge of PG RDBMS (all versions) architecture & design.
- Excellent knowledge of Architecture, Backup, Recovery (PITTR), Replication & Performance Tuning concepts.
- Experienced in backup and recovery using PG_DUMP and PG_DUMPALL, setting up WAL archiving, Point in Time Recovery
- Hands-on experience of using tools/extensions - REPMGR, PGBACKREST, pg_repack, pg_crypto, pg_audit, Data Wrapper, pg_bouncer,
- Good understanding of configuration files such as Pg_hba.Conf, Postgresql.Conf (with knowledge on Parameter values)
- Scripting knowledge using Ansibel and SHELL
- Proficient in troubleshooting & solving complex performance problems.
- Proficient in managing Patching, Upgrades & Migrations.
- Proficient in monitoring & performance analysis through open source tools
- Experience in handling Disaster Recovery tests & exercises.
- Certifications and experience of managing RDS for PostgreSQL on AWS
- Experience in working on a large-scale environment (at least 1000 + databases with bigger sizes).
- Working experience in banking domain (preferred).
- Expert knowledge of ITIL processes around Incident, Problem, Change, Quality Management and CSI.
- Exceptional coordination, communication and interpersonal skills to work across global teams and clients.
- Demonstrated ability to analyze, diagnose and assess problems; work with global stakeholders to derive tactical and long-term solutions as appropriate.
- Demonstrable crisis management skills in a large, globally distributed environment.
- Experience working with or in an automated operations environment
- Experience managing operations on core & cloud-based infra environments - ‘AaS platform’ experience ideal.

**Preferred Education, Skills and Experience**:

- Certifications and experience of managing RDS for PostgreSQL on AWS
- Hands-on experience of using tools/extensions - REPMGR, PGBACKREST, pg_repack, pg_crypto, pg_audit, Data Wrapper, pg_bouncer
- Good understanding of configuration files such as Pg_hba.Conf, Postgresql.Conf.
- Experienced in backup and recovery using PG_DUMP and PG_DUMPALL, setting up WAL archiving, Point in Time Recovery
- Experience in Ansible, Shell / Perl / Python Scripting
- Proficient in managing Patching, Upgrades & Migrations.
- Proficient in monitoring & performance analysis through open source tools

**Job Types**: Full-time, Permanent

Pay: ₹1,000,000.00 - ₹1,200,000.00 per year

**Benefits**:

- Health insurance
- Provident Fund

Schedule:

- Day shift
- Rotational shift

Supplemental Pay:

- Performance bonus

Application Question(s):

- Note:

- Freshers are NOT allowed.

**Experience**:

- PostgreSQL: 5 years (preferred)

Work Location: In person

  • Azure sql dba with postgres

    2 days ago

    Bengaluru, India Tata Consultancy Services Full time

    Role - Azure SQL DBA with Postgres Experience - 8 to 12 yrs Location - Bangalore Mandatory Requirements: - Proven experience as a Database Administrator, with a strong focus on MS SQL Server, Postgre SQL, and DB2. - Solid understanding of SQL Server tools and utilities. - Familiarity with Windows OS 2016 or higher. - Experience working with Azure Cloud...

  • Azure sql dba with postgres

    5 days ago

    Bengaluru, India Tata Consultancy Services Full time

    Role - Azure SQL DBA with PostgresExperience - 8 to 12 yrsLocation - BangaloreMandatory Requirements:- Proven experience as a Database Administrator, with a strong focus on MS SQL Server, Postgre SQL, and DB2.- Solid understanding of SQL Server tools and utilities.- Familiarity with Windows OS 2016 or higher.- Experience working with Azure Cloud services.-...

  • Postgres SQL DBA Senior Developer

    2 weeks ago

    Bengaluru, India Tata Consultancy Services Full time

    Role: Postgres SQL DBA Senior DeveloperExperience range: 8-12 yearsLocation: Hyderabad onlyNOTE: NEED QUICK JOINERSRequired Skill set: Postgres SQL DBA with Golden GateJob description:Must have:8+ yrs of proven experience as a PostgreSQL Database Administrator.Strong knowledge of database design, performance tuning, and optimization.Good experience in golden...

  • Postgres SQL DBA Senior Developer

    3 weeks ago

    Bengaluru, India Tata Consultancy Services Full time

    Role: Postgres SQL DBA Senior DeveloperExperience range: 8-12 yearsLocation: Hyderabad onlyNOTE: NEED QUICK JOINERSRequired Skill set: Postgres SQL DBA with Golden GateJob description:Must have:- 8+ yrs of proven experience as a PostgreSQL Database Administrator.- Strong knowledge of database design, performance tuning, and optimization.- Good experience in...

  • Postgres SQL DBA

    2 weeks ago

    Bengaluru, India Coffeee.io Full time

    Job Title: Postgres SQL DBAExperience: 4-6 Years of experienceLocation: Bangalore (Hybrid)Important Note: Candidates who are immediate joiners or can join within 15 days will be preferred.Important Note:Assessment is a mandatory criteria for shortlist.To complete the assessment, simply copy and paste the link into your browser, log in, and open the...

  • Postgres SQL DBA

    3 weeks ago

    Bengaluru, India Coffeee.io Full time

    Job Description Job Title: Postgres SQL DBA Experience: 4-6 Years of experience Location: Bangalore (Hybrid) Important Note: Candidates who are immediate joiners or can join within 15 days will be preferred. Important Note: Assessment is a mandatory criteria for shortlist. To complete the assessment, simply copy and paste the link into your browser,...

  • Azure SQL DBA with Postgres

    3 weeks ago

    Bengaluru, India Tata Consultancy Services Full time

    Role - Azure SQL DBA with Postgres Experience - 8 to 12 yrs Location - Bangalore Mandatory Requirements: - Proven experience as a Database Administrator, with a strong focus on MS SQL Server, PostgreSQL, and DB2. - Solid understanding of SQL Server tools and utilities. - Familiarity with Windows OS 2016 or higher. - Experience working with Azure Cloud...

  • Azure SQL DBA with Postgres

    3 weeks ago

    Bengaluru, India Tata Consultancy Services Full time

    Role - Azure SQL DBA with Postgres Experience - 8 to 12 yrs Location - Bangalore Mandatory Requirements: - Proven experience as a Database Administrator, with a strong focus on MS SQL Server, PostgreSQL, and DB2. - Solid understanding of SQL Server tools and utilities. - Familiarity with Windows OS 2016 or higher. - Experience working with Azure Cloud...

  • Postgres SQL DBA Senior Developer

    3 weeks ago

    Bengaluru, India Tata Consultancy Services Full time

    Role: Postgres SQL DBA Senior DeveloperExperience range: 8-12 yearsLocation: Hyderabad onlyNOTE: NEED QUICK JOINERSRequired Skill set: Postgres SQL DBA with Golden GateJob description:Must have:8+ yrs of proven experience as a PostgreSQL Database Administrator.Strong knowledge of database design, performance tuning, and optimization.Good experience in golden...

  • Azure SQL DBA with Postgres

    3 weeks ago

    Bengaluru, India Tata Consultancy Services Full time

    Role - Azure SQL DBA with PostgresExperience - 8 to 12 yrsLocation - BangaloreMandatory Requirements:- Proven experience as a Database Administrator, with a strong focus on MS SQL Server, PostgreSQL, and DB2.- Solid understanding of SQL Server tools and utilities.- Familiarity with Windows OS 2016 or higher.- Experience working with Azure Cloud services.-...

  • Azure SQL DBA with Postgres

    7 days ago

    Bengaluru, Karnataka, India Tata Consultancy Services Full time

    Role - Azure SQL DBA with PostgresExperience - 8 to 12 yrsLocation - BangaloreMandatory Requirements:- Proven experience as a Database Administrator, with a strong focus on MS SQL Server, PostgreSQL, and DB2.- Solid understanding of SQL Server tools and utilities.- Familiarity with Windows OS 2016 or higher.- Experience working with Azure Cloud services.-...

  • Azure SQL DBA with Postgres

    6 days ago

    Bengaluru, Karnataka, India Tata Consultancy Services Full time

    Role - Azure SQL DBA with PostgresExperience - 8 to 12 yrsLocation - BangaloreMandatory Requirements:- Proven experience as a Database Administrator, with a strong focus on MS SQL Server, PostgreSQL, and DB2.- Solid understanding of SQL Server tools and utilities.- Familiarity with Windows OS 2016 or higher.- Experience working with Azure Cloud services.-...

  • Postgres SQL DBA

    3 weeks ago

    Bengaluru, India Coffeee.io Full time

    Job Title: Postgres SQL DBAExperience: 4-6 Years of experienceLocation: Bangalore (Hybrid)Important Note: Candidates who are immediate joiners or can join within 15 days will be preferred.Important Note:Assessment is a mandatory criteria for shortlist.To complete the assessment, simply copy and paste the link into your browser, log in, and open the...

  • Postgres SQL DBA

    2 weeks ago

    Bengaluru, India Coffeee.io Full time

    Job Title: Postgres SQL DBAExperience: 4-6 Years of experienceLocation: Bangalore (Hybrid)Important Note: Candidates who are immediate joiners or can join within 15 days will be preferred.Important Note:Assessment is a mandatory criteria for shortlist.To complete the assessment, simply copy and paste the link into your browser, log in, and open the...

  • Postgres dba

    1 day ago

    Bengaluru, India M3BI - A Zensar Company Full time

    Looking for Postgres DBAVery good knowledge on Postgre SQL DB ArchitectureGood hands-on LINUX Basics Commands and understanding of RHEL OS Architecture.Good knowledge of Replication concepts and working knowledge on the known DBMS.Good diagnostics and troubleshooting knowledge on database Issues and replicationMust have good knowledge of different backup...

  • Postgres Developer

    1 day ago

    Bengaluru, India TEKNIKOZ Full time

    Greetings from TeknikozExperience : 7+ YearsRoles and ResponsibilitiesBachelor\'s degree in CS.7 years of hands-on experience in designing and developing DB solutions5 years of hands-on experience in Oracle or Postgres DBMS5 years of hands-on experience in Unix scripting, SQL, Object oriented programming, ETL and unit testingExperience with Azure DevOps and...

  • Postgres Dba

    4 weeks ago

    Bengaluru, Karnataka, India CGI Group, Inc. Full time

    **Description du poste**: Minimum 5 Years in Postgres including 2 years in Cloud (GCP Preferred) B. E/ B. Tech (CS, IS, IT, ECE) Required skills related to Postgres as below: PostgreSQL Architecture Installation Configuration Schema handling Creating and Managing PostgreSQL Databases Database user roles and Security related permission User management and...

  • Azure SQL DBA with Postgres

    3 weeks ago

    Bengaluru, India Tata Consultancy Services Full time

    Role - Azure SQL DBA with Postgres Experience - 8 to 12 yrs Location - Bangalore Mandatory Requirements: - Proven experience as a Database Administrator, with a strong focus on MS SQL Server, PostgreSQL, and DB2. - Solid understanding of SQL Server tools and utilities. - Familiarity with Windows OS 2016 or higher. - Experience working with Azure Cloud...

  • Azure SQL DBA with Postgres

    3 weeks ago

    Bengaluru, India Tata Consultancy Services Full time

    Role - Azure SQL DBA with Postgres Experience - 8 to 12 yrsLocation - BangaloreMandatory Requirements: - Proven experience as a Database Administrator, with a strong focus on MS SQL Server, PostgreSQL, and DB2. - Solid understanding of SQL Server tools and utilities. - Familiarity with Windows OS 2016 or higher. - Experience working with Azure Cloud...

  • Postgres Developer

    5 days ago

    Bengaluru, India TEKNIKOZ Full time

    Greetings from Teknikoz Experience : 7+ Years Roles and Responsibilities - Bachelor/'s degree in CS. - 7 years of hands-on experience in designing and developing DB solutions - 5 years of hands-on experience in Oracle or Postgres DBMS - 5 years of hands-on experience in Unix scripting, SQL, Object oriented programming, ETL and unit testing - Experience...