₹10L – ₹25L a year estimatetypical for IT Jobs in India, 826 posts
Posted 9 days ago Last checked 3 hr ago
Free · takes a minute · your resume fills your profile
CoreHRx never asks candidates for money. If anyone does, .
Role at a glance
You will
Drives work to closure.
Experience
35+ years
Education
Bachelor's degree
Must-have skills
PostgreSQLReplication
How well do your skills match this job?
Sign in to see your fit: the skills, experience and location this job asks for, checked against your profile.
Job description
Location: India Department: Technology & Engineering
Why Choose Bottomline?
Are you ready to transform the way businesses pay and get paid? Bottomline is a global leader in business payments and cash management, with over 35 years of experience and moving more than $16 trillion in payments annually. We're looking for passionate individuals to join our team and help drive impactful results for our customers. If you're dedicated to delighting customers and promoting growth and innovation - we want you on our team!
Position Title: Senior Database Engineer I
Department: Datacenter Engineering
Essential Job Functions:
Positive and all in attitude.
Works collaboratively within a team.
Drives work to closure.
Shows pride in the quality of work being done.
Understands, follows, and contributes to the refinement of team processes.
Proactively identify and resolve system availability, performance concerns as well as ensure system security.
Create and maintain backup/restore, encryption and replication strategies between various database environments.
Participate in and influence the design, planning and implementation of projects and initiatives regarding database architecture.
Translate business requirements into database strategies and initiatives and drive the execution. Influence business stakeholders.
Required Skills:
Excellent written and verbal communication skills.
Experience with automation and configuration management tools.
Experience with performance tuning utilizing indexes, disk and query optimizations, and other methods.
Experience with database security, replication and failover mechanisms.
Experience with encryption methodologies for databases.
Experience with database clustering techniques.
Experience with Postgres databases and supplemental technologies.
Good to have experience with Oracle.
Education and Experience:
Ten or more years of direct experience working as a Postgres Database Administrator.
Bachelor’s degree in computer science, Information Systems, Engineering, or relevant experience.
We welcome talent at all career stages and are dedicated to understanding and supporting additional needs. We're proud to be an equal opportunity employer, committed to creating an inclusive and open environment for everyone.
This guide is for Indian job seekers preparing for SQL rounds in data analyst, data engineer, backend developer and database roles, from freshers to experienced professionals. It has 60 questions in three levels: easy covers joins, grouping and NULLs; medium covers window functions, CTEs, indexes and isolation levels; hard covers locking, MVCC, query tuning and classic puzzles such as login streaks and medians. Answers use ANSI SQL, with MySQL 8 and PostgreSQL notes where the two differ. Write each query against your own sample tables first, then compare your result with the sample answer.
Questions you may be asked
What is the difference between WHERE and HAVING?
What is the difference between DELETE, TRUNCATE and DROP?
What is the difference between an INNER JOIN and a LEFT JOIN?
What is the difference between a primary key and a unique key?
