Job Description

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.

Software Engineer Consultant II implements applications following 12-factor principles to build out the product and iterative enhancements. They partner on full stack of software products; developing and implementing frontends (web or mobile), and backend services. They leverage test driven development and continuous integration to ensure agility and quality of products. They actively participate in the decision-making process of the team ensuring that the simplest appropriate technology and design is chosen to meet user needs.
We're looking for an experienced PostgreSQL DBA with expertise in managing and optimizing PostgreSQL environments, both on-premises and on AWS (RDS/Aurora).


Key Responsibilities:


Manage PostgreSQL architecture, cluster setup, and configuration tuning.

Design and implement backup strategies (PITR, replication, snapshots).

Optimize database performance and query efficiency.

Ensure security via encryption, access control, and compliance auditing.

Configure replication and high availability (failover, streaming).

Monitor database health and troubleshoot issues promptly.


AWS Focus:

Manage Aurora PostgreSQL instances and RDS services.

Implement database performance tuning, backups, and replication in AWS.

Secure cloud databases using IAM, VPC, and encryption best practices.


Soft Skills:


Communicate technical concepts clearly to all stakeholders.

Collaborate with cross-functional teams.

Solve problems efficiently and take initiative in process improvements.

Primary Skills

Shift Time

Recruiter Info

Yateesh B G
ybgaa@allstate.com

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. And one where you can impact the future for the greater good.


You'll do all this in a flexible environment that embraces connection and belonging. And with the recognition of several inclusivity and diversity awards, we've proven that Allstate empowers everyone to lead, drive change and give back where they work and live.

Good Hands. Greater Together.

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.