Oracle Database Administration

Role: Oracle DBA – GoldenGate & Database Migration

Location: Bangalore / Hyderabad

Experience: 8–15 years

Key Responsibilities:

• Manage Oracle databases in production and non-production environments.
• Strong hands-on experience with Oracle GoldenGate for replication, CDC, and data synchronization.
• Lead/support database migration, upgrade, and transformation projects.
• Perform database performance tuning, backup/recovery, troubleshooting, and high availability activities.
• Work on migration planning, execution, validation, and post-migration support.
• Collaborate with application, infrastructure, and cloud teams for end-to-end migration activities.

Must-Have Skills:

• 8–15 years of strong Oracle DBA experience.
• Hands-on expertise in Oracle GoldenGate.
• Proven experience in DB migration projects.
• Strong knowledge of Oracle RAC, Data Guard, RMAN, performance tuning, and troubleshooting.
• Good understanding of Unix/Linux and SQL/PLSQL.
• Excellent communication and stakeholder-management skills.

Location: Bangalore / Hyderabad

CTC: Up to ₹24 LPA

Senior Database Administrator (DBA)

Database Reliability & Performance  •  Senior Individual Contributor

• Experience: 6–9 years in production database administration / engineering
• Level: Senior Individual Contributor (hands-on)
• Function: Data Platform — reliability, performance, and governance across relational and distributed SQL & NoSQL DBs.

About the Role

We are hiring a Senior Database Administrator to own the health, performance, and reliability of the data layer behind a high-scale, multi-tenant platform. Our environment spans several independent PostgreSQL database instances, a cache-first read tier, change-data-capture pipeline, analytics and archival stores. Should be capable of implementing NoSQL stores (Cassandra / ScyllaDB) & MySQL  end to end as we scale.

This is a hands-on senior IC role for someone who has run demanding production databases and wants full ownership: partitioning and maintenance, performance tuning, monitoring, uptime, disaster recovery, and the security and data-governance documentation that keeps a regulated, multi-tenant platform audit-ready. You will work closely with, and take direction from, engineering leadership — translating priorities into a well-run, well-documented data platform.

What You'll Own

PostgreSQL Depth

• Administer multiple production PostgreSQL instances (v16+), including schema/DDL review, migrations, and release coordination.
• Design and maintain table partitioning strategies (range/hash/time-based) and automate partition lifecycle — creation, retention windows, and safe drops.
• Own query and instance performance tuning: EXPLAIN/ANALYZE, indexing strategy, autovacuum/bloat management, connection pooling (e.g. PgBouncer), and parameter-group tuning.
• Execute zero-downtime schema changes using expand–migrate–contract / blue-green patterns; assess lock impact and avoid long ACCESS EXCLUSIVE locks on hot tables.
• Manage replica topology (writer/reader endpoints), replication lag, and read-scaling as load grows.
• Partner with app teams on migration tooling (e.g. Flyway) and paired forward/rollback scripts; enforce idempotent, reviewed, tested DDL.

NoSQL & Scale

• Data-model, deploy, and operate distributed NoSQL clusters — Cassandra and/or ScyllaDB — including partition/clustering key design, compaction strategy, repair, and node operations (bootstrap, decommission, scale-out).
• Lead the planned migration of high-volume payload tables from partitioned PostgreSQL to Cassandra/ScyllaDB: capacity planning, dual-write/backfill design, cutover, and validation.
• Tune distributed-store read/write paths, consistency levels, and cluster sizing for predictable latency at scale.
• Support the cache-first architecture (Redis) and change-data-capture / streaming pipelines (e.g. Kafka) that move data to analytics and cold-archival stores.

Operations, Reliability & DR

• Own database uptime and SLOs; build and maintain monitoring, alerting, and dashboards for the key signals (latency, replication lag, CPU/IO, connections, vacuum lag, error rates).
• Define and regularly test backup and disaster-recovery strategy — RPO/RTO targets, point-in-time recovery, restore drills, and cross-AZ / future multi-region readiness.
• Drive incident response for database-related issues: triage, mitigation, root-cause analysis, and follow-up actions.
• Write and maintain runbooks (partition maintenance, failover, archival, DR, migration procedures) and participate in an on-call rotation for the data layer.
• Establish production-change discipline: pre-flight and post-deploy verification, rollback criteria, and backup verification before destructive operations.

Security, Governance & Documentation

• Implement and maintain database access control — least-privilege roles, schema-scoped permissions, and row-level security (RLS) for multi-tenant isolation.
• Own data-governance documentation: PII maps, per-table retention policies, audit-readiness, and the controls behind privacy-regulation compliance (e.g. GDPR / DPDP-style erasure and legal-hold workflows).
• Author and maintain architecture decision records (ADRs), schema documentation, and monitoring/runbook docs so the data platform is legible to the wider team.
• Uphold encryption-at-rest/in-transit posture and safe handling of sensitive columns; keep the data layer aligned with the platform's compliance requirements.

Coding & Automation Bar (Required)

This role is automation-first, not click-ops. The right candidate treats repetitive database work as something to script away and can drop into application code when a problem demands it.

• Strong scripting in Python and Bash for automation of maintenance, backups, partition management, backfills, and health checks.
• Comfortable with infrastructure-as-code (e.g. Terraform) and configuration management (e.g. Ansible) for reproducible database infrastructure.
• Solid SQL and PL/pgSQL; able to read and debug application-layer database code and, worst case, write or patch application code (e.g. Python/Node/Java) to unblock a fix.
• Fluent with Git-based workflows, code review, and CI for database migrations and tooling.

Required Qualifications

• 6–9 years operating relational databases in demanding production environments, with deep PostgreSQL expertise (internals, partitioning, replication, performance tuning).
• Hands-on experience running at least one distributed NoSQL store in production — Cassandra or ScyllaDB strongly preferred (other wide-column/distributed stores considered).
• Proven ownership of backup/DR, monitoring, and incident response for production databases.
• Strong scripting/automation background (Python, Bash) and experience with IaC.
• Experience with managed cloud databases (AWS RDS or equivalent) and understanding of instance/parameter-group tuning, replicas, and failover.
• Experience designing for multi-tenancy and data isolation at scale.
• Clear written communication — able to produce runbooks, ADRs, and governance docs a team can rely on.

Nice to Have

• Experience migrating workloads from PostgreSQL to Cassandra/ScyllaDB (or similar relational-to-distributed migrations).
• Familiarity with Redis as a cache tier and with CDC / streaming pipelines (e.g. Kafka, Debezium).
• Exposure to Flyway (or Liquibase), pgTAP or similar schema testing, and PgBouncer.
• Working knowledge of privacy regulations (GDPR, India DPDP) and audit/compliance processes.

How You Work

• Ownership mindset — takes a directive and runs it to done, with sound judgment on trade-offs.
• Reliability-first and detail-oriented; disciplined about verification, rollback, and documentation.
• Collaborative in a high-performing engineering team; communicates clearly with developers and leadership.
• Pragmatic and scale-aware — designs for where the platform is going, not just where it is.

Location - Remote (India)

Key Responsibilities 

• Design, develop, and maintain database schemas, stored procedures, views, and queries in SQL Server and MySQL. 

• Identify and resolve query performance bottlenecks using execution plans, indexing strategies, and tuning techniques. 

• Conduct regular database health checks and performance reviews to ensure optimal operation. 

• Collaborate with development and operations teams to support application data requirements. 

• Write and optimize complex SQL scripts to meet business and operational needs. 

• Support the DBA Team Lead with day-to-day database operations and incident resolution. 

• Assist in monitoring database availability, integrity, and backups. 

• Document database structures, procedures, and changes in a clear and organized manner. 

• Implement best practices for data storage, retrieval, and processing efficiency. 

• Contribute to the continuous improvement of database standards and internal processes. 

• Identify and effectively prioritize situations requiring urgent attention. 

• Stay current with system information, database technologies, changes, and updates. 

• Experience with cloud-managed databases (e.g., Microsoft Azure SQL Database, Amazon RDS) and understanding of scaling, cost optimization, and high availability in cloud environments. 

• Hands-on exposure to database automation and CI/CD practices (schema versioning, deployment pipelines, Infrastructure as Code). 

• Strong knowledge of high availability and disaster recovery design, including replication, failover, and defined RPO/RTO ownership. 

• Familiarity with database security best practices (encryption, access control, auditing, and protection of sensitive/regulated data). 

• Experience with monitoring and observability tools, with a proactive approach to performance tuning and alerting. 

• Scripting ability (PowerShell, Python, or Bash) to automate routine database operations and reduce manual effort. 

• Experience with database migrations, version upgrades, or modernization initiatives (on-prem to cloud or legacy to current platforms). 

• Ability to operate in a DevOps-oriented environment, partnering closely with engineering teams and owning database performance tied to application SLA. 

• Proficiency in T-SQL and/or standard SQL. 

• Ability to multi-task and adjust priorities quickly in a fast-paced environment. 

• Ability to research and implement solutions using available technical resources. 

• Strong analytical and problem-solving skills with attention to detail. 

• Ability to clearly communicate technical concepts to non-technical stakeholders. 

• Advanced knowledge of database performance tuning and query optimization. 

• Familiarity with cloud database platforms such as Microsoft Azure SQL, AWS   RDS, or equivalent. 

• Experience with database deployment automation and CI/CD pipelines. 

• Understanding of high availability, disaster recovery, and data protection strategies. 

• Working knowledge of database monitoring and performance management tools. 

• Basic scripting skills (PowerShell, Python, or Bash) for automation. 

• Awareness of data security and compliance considerations in regulated environments. 

Required Skills 

• Proven working experience as a Database Administrator or in a similar role. 

• Working knowledge of Microsoft SQL Server (SSIS, T-SQL, DDL, SML) 

• Working knowledge of MySQL or MariaDB. 

• A minimum of 5 years of experience in database administration. 

• Understanding of database normalization and data modeling principles. 

Nice to Have 

• MacOS, iOS, Android, Linux OS beneficial but not required. 

• ETL processes or data warehouse experience beneficial but not required. 

• Microsoft Certified: Azure Database Administrator Associate or equivalent SQL Server certification preferred but not required. 

• MySQL certification preferred but not required. 

Key Responsibilities

Administer, monitor, and support database platforms including Couchbase, PostgreSQL, and Oracle.

Perform database performance tuning, optimization, and troubleshooting.

Write and optimize complex SQL queries, stored procedures, and scripts.

Ensure database availability, reliability, backup, recovery, and security compliance.

Support production incidents, root cause analysis, and ongoing operational improvements.

Collaborate with application, infrastructure, and support teams to resolve database-related issues.

Required Skills

5 to 10 years of hands-on experience in Database Administration.

Strong experience with Couchbase, PostgreSQL, and/or Oracle databases.

Expertise in performance tuning, query optimization, indexing, and SQL development (Complex Queries, Stored Procedures, Scripts)

Experience with database monitoring, backup, recovery, and maintenance activities.

Production Support, Troubleshooting & RCA

Strong analytical and troubleshooting skills.

Nice to Have

Experience with cloud platforms such as AWS, Azure, or GCP.

Exposure to database automation and scripting

Designation SQL Database Administrator

LocationMohali, Chandigarh,

Job Description & Responsibilities

• Provide database monitoring and support of multiple 24/7 enterprise SQL Server always on availability groups.
• Troubleshoot issues as they occur, working with the Operations team during incidents, and resolving problems quickly and to a high standard.
• Maintain database performance by identifying and resolving production and application development problems, calculating optimum parameter values, evaluating
• new release code, answering developer questions and advising on code changes.
• Develop and configure database solutions, configuration of new systems, defining database structure, improving security, ensuring back-ups and restores meet audit requirements.
• Ensure all database systems meet RPO & RTO policies.
• Work with the Engineering Team to design and optimize SQL solutions.
• Work with the Operations Team to manage, install and configure servers in multiple data centres around the world.
• Update job knowledge by participating in educational opportunities, reading professional publications, maintaining personal networks, and participating in professional organizations.
• Ability to work closely with developers to resolve issues and improve systems.
• High level knowledge of Windows and Windows security and how they affect SQL Server.
• Knowledge of PowerShell scripting.
• Excellent analytical and problem-solving skills.
• Excellent written and verbal communication skills.

Education

• BE, B. Tech, M. Tech in Computer Science or equivalent.

Certifications

• Knowledge of Clustering.
• Knowledge of Database Migration.
• Knowledge of Database Mirroring.
• Knowledge of Log Shipping.
• Knowledge of Mirroring.
• Knowledge of Replication.
• Knowledge of SQL DBA.

Work Experience

• 05 to 08 years of experience as a SQL Database Administrator.
• Experience in Airlines or travel domain is a plus.

Skills

• Responsible for installation and configuration of SQL Server 2016/2017/2019.
• Scheduling jobs and job monitoring.
• Performing SQL Server upgrades, applying patches, and monitoring status.
• Manage user and role level security.
• Understanding and modifying existing stored procedures.
• Configured always On, log shipping and replication.
• Creating databases and logins with permissions in SQL Servers as developer's request.
• Implemented database standards and naming conventions for the database objects.
• Monitoring the databases as per the daily schedule tasks to check the health of databases using DBCC commands.
• Monitoring jobs like backup and restore check the error log for daily running batch jobs.
• Performance tuning high-level understanding.
• Troubleshooting issues high-level understanding.

Qualifications

● 3-8 years experience in Cloud Database Administration

● Proficient in PostgreSQL database management, including installation, configuration, and performance tuning.

● Experience with Amazon RDS or Cloud SQL and managing databases in cloud environments.

● Proficient in PostgreSQL/MySQL database management, including installation, configuration, and performance tuning.

● Proven experience as a Database Administrator with a focus on

PostgreSQL/MySQL.

● In-depth knowledge of database design, implementation, and management for both PostgreSQL/MySQL environments.

● Familiarity with database security, backup procedures, and performance tuning for both systems.

● Strong analytical and problem-solving skills.

● Excellent communication and collaboration abilities.

● Relevant certifications (e.g., PostgreSQL Certified Professional, MySQLDatabase Administrator) are a plus.

Skills:

● Expertise in PostgreSQL/MySQL database management systems.

● SQL programming and query optimization for both databases.

● Data modeling and database design for PostgreSQL/MySQL.

● Backup and recovery procedures for both environments.

● Performance tuning and optimization for PostgreSQL/MySQL.

● Security protocols and measures for PostgreSQL/MySQL.

● Capacity planning and scalability for both systems.

• Configure, maintain, and support Oracle RMCS (Revenue Management and Contract Management) based on business requirements.
• Analyze and independently resolve RMCS functional and technical issues, defects, and production incidents.
• Perform root-cause analysis, troubleshooting, configuration changes, and technical fixes for RMCS-related issues.
• Manage RMCS setup and configuration, including revenue contracts, performance obligations, allocation, revenue recognition, and accounting rules.
• Understand and troubleshoot the end-to-end data flow between Oracle EBS and RMCS across various business scenarios.
• Analyze EBS-to-RMCS interfaces, integrations, transaction flows, and data synchronization issues.
• Develop or modify technical solutions using SQL/PLSQL, APIs, interfaces, and other Oracle technical components where required.
• Support integration-related issues involving Oracle EBS, Oracle Fusion, RMCS, AR, GL, Order Management, and other upstream/downstream systems.
• Validate configuration and technical changes through unit testing, integration testing, and defect resolution.
• Work with functional and business teams to understand requirements and translate them into RMCS configuration or technical solutions.
• Perform impact analysis for RMCS enhancements, fixes, and configuration changes.
• Monitor RMCS processing and investigate failed transactions, incorrect revenue recognition, accounting discrepancies, and interface errors.
• Support implementation, enhancement, migration, and production support activities for RMCS.
• Prepare technical/functional documentation covering configuration, integrations, issue resolution, and business processes.
• Ensure solutions follow Oracle RMCS best practices while minimizing unnecessary customization.