PostgreSQL Dba

6 days ago

Mumbai, India LRN Corporation Full time

**Position**: PostgreSQL DBA - ( Data Engineer Specialist )

**Location: Mumbai
- India**

**About LRN**

Do you want to use your engineering expertise to help people around the world do the right thing? Join us at LRN to be a part of a global company where you can make an impact.

LRN is a SaaS based e-Learning provider with a presence across US, EMEA, APAC and LatAm. More than 2,500 companies worldwide (including some of the world’s most recognizable brands) utilize LRN services and leverage LRN e-learning courses to help navigate complex regulatory environments and foster ethical, responsible, and inclusive cultures. In partnership with LRN, companies translate their values into concrete corporate practices, training materials, and leadership behaviors that create a sustainable competitive advantage. By acting upon shared values, companies and their people find the means to out behave and outperform.

**About the role**:
LRN team develops data specifically for a set of key product domains like eLearning, Disclosures, personalization and completions. We deal in AWS technologies like Aurora RDS, DMS, KMS, Cloudwatch. You'll support our database landscape and partner with Product and BI teams to build new behavioural events, pipelines, datasets, models, and reporting to support their initiatives.

**Your responsibilities will include**:

- Monitor database matrices, logs, alerts to maintain database availability
- Logical/physical backups and restorations
- Handle database deployments
- Modify databases objects according to requests and perform tests
- Solve database usage/performance issues and malfunctions
- Gather user requirements and identify new features
- Provide database management support to concerned stakeholders
- Research and suggest new database products, services and protocols
- Work with Application teams for any data reporting queries/requests.
- Design and optimize SQL queries
- Assist with schema design, code review, SQL query tuning
- Handle database patching, upgrades, failover/switchovers, database refresh and all such database maintenance activities

**Requirements**:
**Must have**
- Strong knowledge on Aurora Postgres Administration
- Knowledge on MongoDB, MySQL administration
- Knowledge of AWS cloud concepts and services like AWS Glue, athena, RDS, DMS
- Knowledge of database performance tuning DR activities, backups, encryption, upgrades etc
- Design and optimize SQL queries in PostgreSQL
- Design, create, modify and remove database objects (tables, views, indexes, keys, stored procedures, functions, DB links, etc.) to support development projects

**Should have**:

- Good knowledge of ETL’s
- Basic knowledge of OS/Linux, Git
- Good understanding of data and schema standards and concepts

**Good to have**:

- Knowledge data warehouse/Analytics concepts and understanding
- Knowledge on Aurora Postgres Administration
- Knowledge writing queries on MongoDB
- Knowledge of AWS cloud concepts and services like AWS Glue, athena, RDS, DMS

**Benefits**

**What we offer**:

- Competitive compensation
- Excellent medical cover

LRN is an equal opportunity employer. We celebrate diversity and are committed to creating an inclusive environment for all employees.

  • PostgreSQL DBA

    1 week ago

    Mumbai, Maharashtra, India AMK Group Full time ₹ 5,00,000 - ₹ 15,00,000 per year

    We at AMK are looking for ''postgreSql DBA" Min. 5yrs of experience on Postgre DBA with some Linux background A PostgreSQL DBA is an expert in managing the PostgreSQL database system. Let us take a look at their primary responsibilities. ● Create the objects in the database, such as triggers, indexes, etc. ● Monitor the performance of the database and...

  • PostgreSQL DBA

    5 days ago

    Mumbai, India Simple Logic IT Private Limited Full time

    Job Title: Lead Database AdministratorLocation: Onsite in Vikhroli, Mumbai (all areas) & Navi Mumbai*Immediate Joiners Only*Required Skills & Experience: PostgreSQL DBA (Level 3)5+ years of hands-on PostgreSQL DBA experience in production environments.Deep knowledge of PostgreSQL internals, architecture, and tuning.Proven experience with pgBackRest, Barman,...

  • PostgreSQL DBA

    5 days ago

    mumbai, India Simple Logic IT Private Limited Full time

    Job Title: Lead Database AdministratorLocation: Onsite in Vikhroli, Mumbai (all areas) & Navi Mumbai*Immediate Joiners Only*Required Skills & Experience: PostgreSQL DBA (Level 3)5+ years of hands-on PostgreSQL DBA experience in production environments.Deep knowledge of PostgreSQL internals, architecture, and tuning.Proven experience with pgBackRest, Barman,...

  • PostgreSQL DBA

    5 days ago

    Mumbai, India Simple Logic IT Private Limited Full time

    Job Title: Lead Database AdministratorLocation: Onsite in Vikhroli, Mumbai (all areas) & Navi Mumbai*Immediate Joiners Only*Required Skills & Experience: PostgreSQL DBA (Level 3)5+ years of hands-on PostgreSQL DBA experience in production environments.Deep knowledge of PostgreSQL internals, architecture, and tuning.Proven experience with pgBackRest, Barman,...

  • PostgreSQL DBA

    5 days ago

    Mumbai, India Simple Logic IT Private Limited Full time

    Job Title: Lead Database AdministratorLocation: Onsite in Vikhroli, Mumbai (all areas) & Navi Mumbai*Immediate Joiners Only*Required Skills & Experience: PostgreSQL DBA (Level 3)5+ years of hands-on PostgreSQL DBA experience in production environments.Deep knowledge of PostgreSQL internals, architecture, and tuning.Proven experience with pgBackRest, Barman,...

  • PostgreSQL DBA

    5 days ago

    Mumbai, India Simple Logic IT Private Limited Full time

    Job Title: Lead Database Administrator Location: Onsite in Vikhroli, Mumbai (all areas) & Navi Mumbai *Immediate Joiners Only* Required Skills & Experience: PostgreSQL DBA (Level 3) 5+ years of hands-on PostgreSQL DBA experience in production environments. Deep knowledge of PostgreSQL internals, architecture, and tuning. Proven experience with pgBackRest,...

  • PostgreSQL DBA

    5 days ago

    Mumbai, India Simple Logic IT Private Limited Full time

    Job Title: Lead Database Administrator Location: Onsite in Vikhroli, Mumbai (all areas) & Navi Mumbai *Immediate Joiners Only* Required Skills & Experience: PostgreSQL DBA (Level 3) - 5+ years of hands-on PostgreSQL DBA experience in production environments. - Deep knowledge of PostgreSQL internals, architecture, and tuning. - Proven experience with...

  • PostgreSQL DBA

    5 days ago

    Mumbai, India Simple Logic IT Private Limited Full time

    Job Title: Lead Database Administrator Location: Onsite in Vikhroli, Mumbai (all areas) & Navi Mumbai *Immediate Joiners Only* Required Skills & Experience: PostgreSQL DBA (Level 3) 5+ years of hands-on PostgreSQL DBA experience in production environments. Deep knowledge of PostgreSQL internals, architecture, and tuning. Proven experience with pgBackRest,...

  • PostgreSQL DBA

    4 days ago

    Mumbai, India Simple Logic IT Private Limited Full time

    Job Title: Lead Database Administrator Location: Onsite in Vikhroli, Mumbai (all areas) & Navi Mumbai *Immediate Joiners Only* Required Skills & Experience: PostgreSQL DBA (Level 3) 5+ years of hands-on PostgreSQL DBA experience in production environments. Deep knowledge of PostgreSQL internals, architecture, and tuning. Proven experience with pgBackRest,...

  • PostgreSQL DBA

    4 days ago

    Mumbai, India Simple Logic IT Private Limited Full time

    Job Title: Lead Database AdministratorLocation: Onsite in Vikhroli, Mumbai (all areas) & Navi Mumbai*Immediate Joiners Only*Required Skills & Experience: PostgreSQL DBA (Level 3)- 5+ years of hands-on PostgreSQL DBA experience in production environments.- Deep knowledge of PostgreSQL internals, architecture, and tuning.- Proven experience with pgBackRest,...