Add office photos
All Filters
9 Beyontec Jobs
Software Engineer - PostgreSQL Developer - Banking
Beyontec
·
2-5 years
Bangalore / Bengaluru
1 vacancy
Software Engineer - PostgreSQL Developer - Banking
Beyontec
posted 2mon ago
Job Role Insights
Flexible timing
Key skills for the job
Job Description
Years of Experience: 2 to 5 years
Location: Bangalore
- Participate in the design and architecture of new and existing database features.
- Develop high-quality, maintainable, and efficient code using PostgreSQL.
- Conduct code reviews, unit testing, and integration testing of database components.
- Deploy database changes to various environments (development, testing, production).
- Collaborate with cross-functional teams to deliver high-quality database solutions.
- Troubleshoot and resolve database-related production issues.
- Continuously improve database development and optimization practices.
- Bachelor s / Master s degree in Computer Science or a related field.
- 2 to 5 years of experience in SQL, PL/pgSQL (PostgreSQL).
- Advanced proficiency in SQL and PL/pgSQL, including functions, triggers, and stored procedures.
- Deep understanding of PostgreSQL architecture, database internals, and configuration management.
- Expertise in performance tuning, query optimization, and indexing strategies.
- Experience with database design, schema management, and normalization/denormalization techniques.
- Proficiency in handling complex data types, such as JSON/JSONB, arrays, hstore, and CTEs (Common Table Expressions).
- Knowledge of advanced PostgreSQL features like partitioning and replication.
- Familiarity with backup, recovery, failover strategies, disaster recovery, and point-in-time recovery (PITR).
- Knowledge of security best practices, including role management, GRANT/REVOKE permissions, SSL/TLS setup, and data encryption.
- Experience in setting up auditing, monitoring, and compliance controls.
- Expertise in using monitoring tools like pg_stat_statements, pgBadger, Prometheus, Grafana, and Datadog.
- Proficiency in diagnosing and resolving issues related to database performance, memory usage, and locks.
- In-depth knowledge of PostgreSQLs MVCC (Multi-Version Concurrency Control) model, transaction isolation levels, and deadlock resolution. Should have knowledge on concurrency and lock management.
- Experience in upgrading PostgreSQL versions and migrating databases with minimal downtime.
- Familiarity with tools like pg_upgrade, pg_dump, pg_restore, and logical replication for migrations.
- Good communication and teamwork skills.
- Strong interpersonal, analytical, and problem-solving skills.
- Should be an excellent team player.
Employment Type: Full Time, Permanent
Functional Areas: Software/Testing/Networking
Read full job descriptionPrepare for Postgresql Developer roles with real interview advice
What people at Beyontec are saying
What Beyontec employees are saying about work life
Beyontec Benefits
View more benefits
Compare Beyontec with
Ebix Software India
Sapiens
Majesco
TCS
Tech Mahindra
Coforge
LTIMindtree
Hexaware Technologies
KPIT Technologies
Cognizant
NTT Data Information Processing Services
Sutherland Global Services
Virtusa Consulting Services
CGI Group
GlobalLogic
UST
Nagarro
Hewlett Packard Enterprise
ITC Infotech
Access Healthcare
Similar Jobs for you
Software Engineer - PostgreSQL Developer - Banking
2-5 Yrs
Bangalore / Bengaluru
Sr. Lead PLSQL Developer - Insurance
8-10 Yrs
Chennai, Bangalore / Bengaluru
Software Engineer \u2013 Fullstack Development - Banking
2-5 Yrs
Bangalore / Bengaluru
