Senior Database Administrator (6-8 yrs)

Hiring for a fintech company in Bangalore.

Notice period: 0 to 30 Days

Location: Bangalore (5 days WFO)

Role overview

Required Skills and Qualifications

• 7+ years of experience as a Database Administrator or in a similar role.
• Proficiency in managing Oracle, PostgreSQL, MongoDB, MySQL, and Redis databases.
• Strong understanding of query execution plans, query tuning, and performance optimization.
• In-depth knowledge of disaster recovery principles, including backup/restore operations.
• Familiarity with change request processes and 24x7 support for production environments.
• Experience implementing database security measures and conducting vulnerability
• assessments.
• Proficiency in troubleshooting and resolving complex database issues.
• Strong analytical, problem-solving, and communication skills.

• Strong knowledge of Oracle database architecture and administration (RAC,ASM).
• Expertise in Oracle SQL and PL/SQL programming.
• Experience in database performance tuning, query optimization, and indexing.
• Hands-on experience with Oracle Data Guard for high availability and disaster recovery.
• Proficiency in managing Oracle backup and recovery using RMAN.
• Knowledge of Oracle Enterprise Manager (OEM) for monitoring and
• management.
• Experience in patching, upgrading, and migrating Oracle databases.
• Proficiency in implementing database security and user access control policies.

• Expertise in PostgreSQL database administration, configuration, and optimization.
• Hands-on experience with extensions like PostGIS, pgAudit, or TimescaleDB.
• Proficiency in writing and tuning advanced SQL queries and PL/pgSQL functions.
• Knowledge of database replication (logical and streaming) and failover strategies.
• Experience with PostgreSQL backups, PITR (Point-in-Time Recovery), and recovery techniques.
• Familiarity with tools like pgAdmin, psql, and pgBouncer for database management.
• Proficiency in partitioning, indexing, and table optimization techniques.
• Experience in PostgreSQL version upgrades and migration to/from other database platforms.

• In-depth knowledge of MongoDB architecture, including replica sets and sharding.
• Proficiency in designing NoSQL schemas and understanding document-oriented databases.
• Experience in performance tuning, query optimization, and aggregation frameworks.
• Expertise in backup, restore, and disaster recovery processes for MongoDB.
• Familiarity with tools like MongoDB Atlas, Compass, and MongoDB CLI.
• Knowledge of MongoDB security best practices, including user roles and data encryption.
• Experience in monitoring and troubleshooting MongoDB clusters using tools like Ops Manager.
• Understanding of integrating MongoDB with application layers and ORM libraries.

• Strong knowledge of MySQL database architecture and administration.
• Expertise in writing and optimizing complex SQL queries and stored procedures.
• Experience with MySQL replication (master-slave, master-master) and failover setups.
• Proficiency in MySQL performance tuning, indexing, and query optimization.- Hands-on
• experience with backup and recovery using tools like mysqldump and Percona XtraBackup.
• Knowledge of MySQL security features, including user authentication and encryption.
• Familiarity with MySQL Workbench, phpMyAdmin, and CLI tools for database management.
• Experience in managing large-scale MySQL databases in high-availability environments.

• Design, implement, and maintain data models, database schemas, and table structures.
• Manage and maintain PostgreSQL, MSSQL, MySQL, and Redis databases, ensuring high
• availability, security, and optimal performance.
• Perform routine database maintenance tasks, including backups, restoration, disaster recovery planning, and database monitoring.
• Plan and execute database upgrades, patches, and version migrations with minimal downtime.
• User access management
• Strong understanding of sharding keys, data distribution, and partitioning strategies.
• DDL

• Analyze and understand query execution plans to identify and resolve performance bottlenecks.
• Optimize query performance through tuning, indexing, partitioning and resource utilization monitoring.
• Implement database monitoring and alerting solutions to proactively address potential issues.

• Implement security measures, such as user access controls, data encryption, and vulnerability assessments.
• Perform regular audits and ensure databases comply with industry standards and best
• practices.

• Apply knowledge of disaster recovery principles and practices, including planning, testing, and execution of backup/restore operations in AWS environment.
• Troubleshoot and resolve database-related issues, including performance problems, replication failures, and data inconsistencies.