Senior DBA :

The Senior Database Administrator is responsible for the design, implementation, maintenance, performance optimization, and security of enterprise database systems. This role ensures high availability, data integrity, and optimal performance of databases, primarily using PostgreSQL and Oracle, while supporting complex SQL-based applications in a mission-critical environment.

Key Responsibilities

Design, install, configure, and maintain PostgreSQL and Oracle database environments.
Monitor database performance, identify bottlenecks, and perform tuning at the SQL, schema, and system levels.
Develop, optimize, and review complex SQL queries, stored procedures, functions, and triggers.
Ensure database availability, reliability, and scalability, including backup, recovery, replication, and failover strategies.
Implement and manage database security, user access control, encryption, and compliance with internal and external regulations.
Perform capacity planning, database upgrades, patching, and version migrations.
Troubleshoot and resolve complex database issues in development, testing, and production environments.
Collaborate closely with application developers, system architects, and infrastructure teams to support application performance and data integrity.
Create and maintain database documentation, standards, and operational procedures.
Provide technical leadership, mentoring, and guidance to junior DBAs and development teams.
Support on-call and incident management activities for critical production systems.

Requirements

Bachelor's degree in Computer Science, Information Technology, or a related field.
7+ years of hands-on experience as a Database Administrator, with strong exposure to enterprise systems.
Proven expertise in PostgreSQL and Oracle Database administration.
Advanced knowledge of SQL performance tuning, query optimization, and indexing strategies.
Strong understanding of database architecture, data modeling, and normalization.
Experience with backup and recovery tools (e.g., RMAN, pg_dump/pg_restore, replication solutions).
Familiarity with high-availability and disaster recovery architectures.
Experience with Linux/Unix environments and shell scripting.
Strong problem-solving skills and ability to work under pressure in production environments.
Good communication skills and ability to collaborate with cross-functional teams.

Preferred Qualifications

Experience with database monitoring and performance tools.
Exposure to cloud database services (AWS RDS, Oracle Cloud, Azure Database).
Knowledge of data security, auditing, and compliance standards.
Experience in banking, fintech, or high-transaction systems is a strong advantage.
Relevant certifications (Oracle DBA, PostgreSQL Certification) are a plus.