Senior Database Administrator

Delta6Labs FinTech Pvt Ltd; Dadri; On-site; INR 1,000,000 - 1,500,000; Full time

Job summary

A leading FinTech company is seeking a Senior Database Administrator to manage and tune database systems, particularly PostgreSQL and SQL. The role encompasses performance optimization, security compliance, and disaster recovery planning, ensuring the integrity and performance of databases. Candidates should also have a strong background in MongoDB and experience with database architecture design. This position offers an opportunity to work with a dynamic team focused on innovation in the FinTech sector.

Qualifications

• Strong experience with PostgreSQL and SQL, excellent ability to write queries.
• Well-versed in MongoDB with a strong background in NoSQL.
• Understanding of PostgreSQL/RDBMS security, roles, privileges, and encryption.
• Solid experience in performance tuning databases and using monitoring tools.

Responsibilities

• Manage and tune database systems for performance and availability.
• Provision and optimize cloud services and Kubernetes clusters.
• Adhere to database security best practices for sensitive data protection.
• Establish and maintain backup/recovery plans to ensure data availability.

Skills

PostgreSQL

SQL

MongoDB

Performance tuning

Database security

Automation with Python and Bash

Job description

We are looking for a Senior Database Administrator (DBA) to support, manage and tune our database systems. The perfect candidate will have experience in PostgreSQL, SQL and MongoDB with a strong knowledge of RDBMS, database security, optimization and disaster recovery planning. This position will be a crucial role in maintaining the integrity and performance of our databases, as well as our security and scalability.

Key Responsibilities:

• Performance and availability of infrastructure
• Cloud services provisioning, optimization and security & billing control
• Provision and run a Kubernetes cluster based on business cases
• React to incidents in a timely manner and learn as you go
• Learn and utilize new technologies and contribute to the continuous improvement of system security, performance, availability and scalability
• Design, develop and maintain PostgreSQL, SQL and MongoDB databases.
• Create and manage RDS (Relational Database Service) instances and database solutions on cloud.

Performance Optimization & Monitoring:

• Monitoring the health, performance of databases and capacity planning.
• Fine-tune queries, indexing and database to make processes more efficient.
• Configure database monitoring tools to identify problems, and take corrective action.

Security & Compliance:

• Adhere to PostgreSQL/RDBMS security best practices.
• Control user roles, permissions, encryption and access controls.
• Audit your security frequently to protect the sensitive data.

Disaster Recovery & Backup:

• Work to establish and maintain backup/recovery plans for data availability.
• Develop and test business continuity disaster recovery procedures.

Database Development & Support:

• Help with schema design, index management and data migration.
• Assist development teams with database tuning and query optimization.
• Work on database upgrades, cleanup and maintenance as far doing them in efficient manner.

Requirements:

• Strong experience with PostgreSQL and SQL (excellent ability to write queries, as well as performance tuning).
• You are well-versed in MongoDB and have a strong background in NoSQL.
• Strong understanding of PostgreSQL/RDBMS security such as roles, privileges and encryption.
• Solid experience in performance tuning databases, and using indexing and monitoring database tools.
• Experience in backup and DR planning.
• Experience with databases, large database architecture design and performance tuning.
• Knowledge of cloud databases on aws or azure is a plus.
• Knowledge of scripting, such as Python and Bash for automation is an advantage.

Why Choose Delta6Labs?

At Delta6Labs, we are all required to be responsible for our own growth and success. We promote a team-oriented and client inclusive environment to share knowledge, ideas and creativity. This is your chance to become a part of forward thinking and motivated team that is changing the face of an industry with rapid growth, innovation, and the value we create within our marketplace.