Urgent! Senior PostgreSQL DBA Architect Job Opening In India, India – Now Hiring Sonata Software
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 modernization-driven hypergrowth for our clients based on the deep differentiation we have created in Modernization Engineering, powered by our Lightening suite and 16-step Platformation™ playbook.
In addition, we bring agility and systems thinking to accelerate time to market for our clients.
Headquartered in Bengaluru, India, Sonata has a strong global presence, including key regions in the US, UK, Europe, APAC, and ANZ.
We are a trusted partner of world-leading companies in BFSI (Banking, Financial Services, and Insurance), HLS (Healthcare and Lifesciences), TMT (Telecom, Media, and Technology), Retail & CPG, and Manufacturing space.
Our bouquet of Modernization Engineering Services cuts across Cloud, Data, Dynamics, Contact Centers, and around newer technologies like Generative AI, MS Fabric, and other modernization platforms.
Senior PostgreSQL Database Administrator (DBA)
About: We are looking for a
Senior PostgreSQL DBA
with deep expertise in
database performance tuning, production stability, and advanced configuration management .
The ideal candidate will take ownership of
Postgres optimization across production workloads , ensuring high performance, reliability, and scalability of mission-critical systems.
You will work closely with application teams, DevOps, and infrastructure engineers to provide
data-driven recommendations , identify
bottlenecks , and fine-tune
PostgreSQL server parameters, indexes, and queries
for optimal performance.
Key Responsibilities Analyze and fine-tune
PostgreSQL database parameters
(e.g., shared_buffers, work_mem, effective_cache_size, autovacuum, checkpoint settings, etc.) to improve throughput and stability.
Perform
query and index optimization
and recommend schema or partitioning strategies for large-scale data.
Conduct
comprehensive performance audits
using pg_stat_statements, EXPLAIN ANALYZE, and OS-level metrics (I/O, CPU, memory, connections).
Review and recommend
best practices
for connection pooling (e.g., PgBouncer, PgPool) and replication setups.
Proactively monitor
production environments , identify anomalies, and implement tuning adjustments or corrective actions.
Work with developers to design efficient SQL and database access patterns.
Establish and maintain
maintenance plans
(vacuum, analyze, reindex, etc.) and
backup/recovery strategies .
Provide recommendations on
HA (High Availability) ,
failover , and
disaster recovery
architectures.
Benchmark and test
PostgreSQL versions, extensions, and configurations
for performance impact before production rollout.
Collaborate with SRE/DevOps teams to automate monitoring, scaling, and alerting using tools like
Prometheus, Grafana, or pgMonitor .
Document findings, create tuning guides, and mentor junior DBAs or developers.
Required Skills and Experience 12+ years of DBA experience, with
5+ years in PostgreSQL administration
on Linux-based systems.
Proven expertise in
Postgres configuration tuning and performance optimization .
Strong SQL and
query plan analysis
skills.
Hands-on experience with
replication (streaming, logical)
and
partitioning strategies .
Familiar with
PostgreSQL internals , transaction management, vacuum processes, and WAL configuration.
Experience with
large datasets and high-traffic production environments .
Proficiency with
pg_stat_statements ,
EXPLAIN/EXPLAIN ANALYZE , and
pgBadger
or similar analysis tools.
Working knowledge of
Linux performance tuning ,
file systems , and
I/O subsystems .
Experience with
backup/recovery tools
(e.g., pgBackRest, Barman) and
HA solutions
(Patroni, repmgr, etc.).
Familiar with
cloud deployments
(Azure Database for PostgreSQL, and on-prem setups).
Excellent problem-solving and communication skills.
Preferred Qualifications Knowledge of
database observability tools
(Prometheus, Grafana, pg_stat_monitor, etc.).
Experience with
CI/CD for database schema management
(Liquibase, Flyway).
Exposure to
PostgreSQL extensions
(pg_partman, pg_stat_kcache, timescaledb, etc.).
Experience tuning
OLTP
and
analytical (OLAP)
workloads.
Contributions to the PostgreSQL community or open-source tools.
Why join Sonata Software?
At Sonata, you´ll have an outstanding opportunity.
The chance to use your skills and imagination to push the boundaries of what´s possible.
To build never seen before solutions to some of the world’s toughest problems.
You´ll be challenged, but you will not be alone.
You´ll be joining a team of diverse innovators, all driven to go beyond the status quo to craft what comes next.
✨ Smart • Intelligent • Private • Secure
Practice for Any Interview Q&A (AI Enabled)
Predict interview Q&A (AI Supported)
Mock interview trainer (AI Supported)
Ace behavioral interviews (AI Powered)
Record interview questions (Confidential)
Master your interviews
Track your answers (Confidential)
Schedule your applications (Confidential)
Create perfect cover letters (AI Supported)
Analyze your resume (NLP Supported)
ATS compatibility check (AI Supported)
Optimize your applications (AI Supported)
O*NET Supported
O*NET Supported
O*NET Supported
O*NET Supported
O*NET Supported
European Union Recommended
Institution Recommended
Institution Recommended
Researcher Recommended
IT Savvy Recommended
Trades Recommended
O*NET Supported
Artist Recommended
Researchers Recommended
Create your account
Access your account
Create your professional profile
Preview your profile
Your saved opportunities
Reviews you've given
Companies you follow
Discover employers
O*NET Supported
Common questions answered
Help for job seekers
How matching works
Customized job suggestions
Fast application process
Manage alert settings
Understanding alerts
How we match resumes
Professional branding guide
Increase your visibility
Get verified status
Learn about our AI
How ATS ranks you
AI-powered matching
Join thousands of professionals who've advanced their careers with our platform
Unlock Your Senior PostgreSQL Potential: Insight & Career Growth Guide
Real-time Senior PostgreSQL Jobs Trends in India, India (Graphical Representation)
Explore profound insights with Expertini's real-time, in-depth analysis, showcased through the graph below. This graph displays the job market trends for Senior PostgreSQL in India, India using a bar chart to represent the number of jobs available and a trend line to illustrate the trend over time. Specifically, the graph shows 364150 jobs in India and 24791 jobs in India. This comprehensive analysis highlights market share and opportunities for professionals in Senior PostgreSQL roles. These dynamic trends provide a better understanding of the job market landscape in these regions.
Great news! Sonata Software is currently hiring and seeking a Senior PostgreSQL DBA Architect to join their team. Feel free to download the job details.
Wait no longer! Are you also interested in exploring similar jobs? Search now: Senior PostgreSQL DBA Architect Jobs India.
An organization's rules and standards set how people should be treated in the office and how different situations should be handled. The work culture at Sonata Software adheres to the cultural norms as outlined by Expertini.
The fundamental ethical values are:The average salary range for a Senior PostgreSQL DBA Architect Jobs India varies, but the pay scale is rated "Standard" in India. Salary levels may vary depending on your industry, experience, and skills. It's essential to research and negotiate effectively. We advise reading the full job specification before proceeding with the application to understand the salary package.
Key qualifications for Senior PostgreSQL DBA Architect typically include Prb and a list of qualifications and expertise as mentioned in the job specification. Be sure to check the specific job listing for detailed requirements and qualifications.
To improve your chances of getting hired for Senior PostgreSQL DBA Architect, consider enhancing your skills. Check your CV/Résumé Score with our free Resume Scoring Tool. We have an in-built Resume Scoring tool that gives you the matching score for each job based on your CV/Résumé once it is uploaded. This can help you align your CV/Résumé according to the job requirements and enhance your skills if needed.
Here are some tips to help you prepare for and ace your job interview:
Before the Interview:To prepare for your Senior PostgreSQL DBA Architect interview at Sonata Software, research the company, understand the job requirements, and practice common interview questions.
Highlight your leadership skills, achievements, and strategic thinking abilities. Be prepared to discuss your experience with HR, including your approach to meeting targets as a team player. Additionally, review the Sonata Software's products or services and be prepared to discuss how you can contribute to their success.
By following these tips, you can increase your chances of making a positive impression and landing the job!
Setting up job alerts for Senior PostgreSQL DBA Architect is easy with India Jobs Expertini. Simply visit our job alerts page here, enter your preferred job title and location, and choose how often you want to receive notifications. You'll get the latest job openings sent directly to your email for FREE!
