Postgresql DBA

1 week ago


Bengaluru, Karnataka, India Allstate Insurance Full time ₹ 9,00,000 - ₹ 12,00,000 per year

At Allstate, great things happen when our people work together to protect families and their belongings from life's uncertainties. And for more than 90 years our innovative drive has kept us a step ahead of our customers' evolving needs. From advocating for seat belts, air bags and graduated driving laws, to being an industry leader in pricing sophistication, telematics, and, more recently, device and identity protection.

Job Description

The Consultant II creates basic database structures for medium to large projects, provides support in the day to day operational management of Database Technologies and aids in software maintenance lifecycle management with assistance. The individual assists with database performance tuning and consultation, database configuration implementation, creates and maintains scripts and test plan execution.

Key Responsibilities
  • Installs/creates low complexity database based on established documented procedures
  • Assists and in some cases lead root-cause analysis on minor incidents; participate with DBMS vendors and others to determine causes and solutions for database problems/issues
  • Installs client tools and drivers based on established documented procedures; assist with installing and maintaining database tools/utilities to support the DBMS environment
  • Performs basic DDL implementation, such as creating tables, indexes, schemas, and setting up security; perform basic database maintenance services for application development teams
  • Able to convert logical data models into physical data models for basic application databases utilizing modeling tool
  • Assists senior DBAs working with application areas to collect application requirements including data, volumetric, access paths, and infrastructure requirements such as backup and recovery; assists with recovery/roll-back as directed for low to medium complex applications
Education
  • 4 year Bachelors Degree (Preferred)
Experience
  • 5 or more years of experience (Preferred)
Supervisory Responsibilities
  • This job does not have supervisory duties.
Education & Experience (in lieu)
  • In lieu of the above education requirements, an equivalent combination of education and experience may be considered.

Primary Skills

PostgreSQL, PostgreSQL Administration

Shift Time

Shift B (India)

Recruiter Info

About Allstate

Joining our team isn't just a job — it's an opportunity. One that takes your skills and pushes them to the next level. One that encourages you to challenge the status quo. One where you can shape the future of protection while supporting causes that mean the most to you. Joining our team means being part of something bigger – a winning team making a meaningful impact.

The Allstate Corporation is one of the largest publicly held insurance providers in the United States. Ranked No. 84 in the 2023 Fortune 500 list of the largest United States corporations by total revenue, The Allstate Corporation owns and operates 18 companies in the United States, Canada, Northern Ireland, and India. Allstate India Private Limited, also known as Allstate India, is a subsidiary of The Allstate Corporation. The India talent center was set up in 2012 and operates under the corporation's Good Hands promise. As it innovates operations and technology, Allstate India has evolved beyond its technology functions to be the critical strategic business services arm of the corporation. With offices in Bengaluru and Pune, the company offers expertise to the parent organization's business areas including technology and innovation, accounting and imaging services, policy administration, transformation solution design and support services, transformation of property liability service design, global operations and integration, and training and transition.

Learn more about Allstate India here.


  • Postgresql DBA

    8 hours ago


    Bengaluru, Karnataka, India Sonata Software Ltd Full time ₹ 80,000 - ₹ 1,80,000 per year

    Job Description Sonata Software Overview In today's market, there is a unique duality in technology adoption. On one side, extreme focus on cost containment by clients, and on the other, deep motivation to modernize their Digital storefronts to attract more consumers and B2B customers. As a leading Modernization Engineering company, we aim to deliver...

  • PostgreSQL DBA

    6 days ago


    Bengaluru, Karnataka, India Versatile Phoenix Hr Service Private Ltd., Full time ₹ 7,00,000 - ₹ 9,00,000 per year

    Urgent opening for one of the MNC client In Bangalore.Position : PostgresSQL DBANote : Only Bangalore candidates will be consideredJob Description :Configuration, maintenance and monitoring of PostgreSQL , Cosmos and similar databases in cloud preferablyazure cloud . Administer and manage Databricks workspaces, clusters, notebooks, jobs, and user access....


  • Bengaluru, Karnataka, India Insightek Global Consulting Full time ₹ 15,00,000 - ₹ 25,00,000 per year

    Requirements : 2 DBA supports 24*7 on-call support.Key Responsibilities:Monitor database health, availability, and performance for PostgreSQL and MySQL instancesPerform basic administrative tasks such as backup/restore, user management, and replication monitoringRespond to on-call alerts, troubleshoot incidents, and escalate when neededAssist in routine...

  • Cloud DBA

    1 week ago


    Bengaluru, Karnataka, India QBID Infotech Full time ₹ 19,00,000 per year

    Job Title: Cloud DBA (6+ Years Experience)Work Location: India – Chandigarh, Hyderabad, Bangalore, PuneMode of Work: Hybrid (10 days in office per month)Contract Duration: 1 YearJoining: ASAPJob DescriptionWe are seeking an experienced Cloud DBA with a strong background in database administration across MS-SQL, MySQL, and PostgreSQL. The ideal candidate...

  • Sr. PostgreSQL DBA

    6 days ago


    Bengaluru, Karnataka, India Epsilon Full time ₹ 1,04,000 - ₹ 1,30,878 per year

    Senior Database AdministratorOverviewAbout BU: A consolidated team of database technology professionals, we provide expertise across all major database engines and Big Data solutions to support Epsilon products and platforms. The team has a unique alignment that combines a horizontal organizational structure with vertically aligned sub-groups dedicated to...

  • Senior DBA Consultant

    3 weeks ago


    Bengaluru, Karnataka, India, Karnataka Tavant Full time

    About Tavant:With 25+ years of experience building innovative digital products and solutions, Tavant provides impactful results to its customers. It has been the frontrunner in driving digital innovation and tech-enabled transformation across a wide range of industries such as Consumer Lending, Manufacturing, Agtech, Media & Entertainment, and Retail in...

  • Sr Oracle DBA

    2 weeks ago


    Bengaluru, Karnataka, India Atyeti Full time ₹ 12,00,000 - ₹ 36,00,000 per year

    Key Requirements: 810+ years of Oracle DBA experience Strong in Oracle 11g – 23ai, Exadata, ASM Expertise in performance tuning, RAC, Dataguard, RMAN Hands-on with AWS Cloud (EC2, RDS) Experience with GoldenGate, DMS, and CI/CD automation tools (Jenkins, Ansible, Terraform, Python) Familiarity with monitoring tools – OEM, Datadog, BI Publisher Scripting...


  • Bengaluru, Karnataka, India Cognizant Full time ₹ 9,00,000 - ₹ 12,00,000 per year

    Primary skillset: Shell scriptingSecondary Skillset: PostgreSQLExperience : 3 to 5 YearsLocation : BangaloreGrade: AJD:Key ResponsibilitiesDesign, develop, and implement automation scripts using shell scripting (e.g., Bash, Ksh).Automate various IT operations, system administration tasks, and deployment processes.Automate PostgreSQL database activities,...

  • sql dba

    7 hours ago


    Bengaluru, Karnataka, India CODERS BRAIN TECHNOLOGY PRIVATE LIMITED Full time ₹ 1,20,000 - ₹ 30,00,000 per year

    About the Role Years)We are looking for an experienced SQL Server Database Administrator to join our team. The ideal candidate will be responsible for the installation, configuration, performance tuning, security, backup/recovery, and high availability of SQL Server environments. You will play a critical role in ensuring database reliability, scalability,...


  • Bengaluru, Karnataka, India, Karnataka Tata Consultancy Services Full time

    Role Description:Greenplum database administrator (DBA) is part of core DBA Operations team and primarilyresponsible for providing day to day Greenplum DBA supportSome of the day-to-day activities are: Greenplum software installation, patch upgrades, performancemonitoring, change implementation, performance tuning, backup and recovery, user maintenance,new...