Database Administrator - DB2

Role overview:

·         Technology Expertise & DBA Skill Set

·         Cloud Platforms: AWS, Azure

·         Database IaaS: Oracle, Microsoft SQL Server, PostgreSQL

·         Database PaaS: CosmosDB, MySQL, SQL Managed Instance, RDS Aurora, MongoDB

·         Infrastructure as Code: Terraform, Ansible

·         CI/CD & Automation: GitHub Actions, GitLab, Azure DevOps

·         Programming & Scripting: Python, Bash/Shell, PowerShell

·         Operating Systems: Linux/Unix (RHEL, Ubuntu), Window

Database Team Overview

Our Database Team is the foundation of enterprise-grade databases delivering secure, compliant and high-performing database platforms across Azure and AWS. We provide managed services for Oracle and Microsoft SQL Server, operating in a system DBA role to ensure platform reliability, resilience, and operational excellence. In addition, we support PaaS and RDS database services by acting as the platform team defining policies, enforcing security standards, and managing networking configurations while enabling self-service capabilities for application teams to consume these services efficiently.

What would you do here:

·         Database Security & Compliance: Implement robust security controls, encryption, and auditing to safeguard sensitive data and meet regulatory requirements.

·         Lifecycle Management: Oversee patching, upgrades, and end-of-life transitions to maintain platform stability and minimize risk.

·   Performance Optimization: Monitor and tune databases for optimal performance across diverse workloads.

·         Automation & Operational Excellence: Design and deploy automation for provisioning, monitoring, and maintenance to achieve “brilliant basics” and reduce manual intervention.

·         Business-Critical Certification: Validate and certify database environments to support mission-critical applications with high availability and disaster recovery strategies.

·         Incident & Problem Management: Provide rapid response and  root-cause analysis for database-related incidents to ensure business continuity.

·         Capacity Planning & Scalability: Forecast growth and optimize resources to support evolving business needs.

Best Regards!

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

Job Description (JD) for the MySQL Database Administrator role

Experience: 4-8 Years 

Location : Mumbai 

Job Title: MySQL Database Administrator 

Responsibilities 

• Provision and configure MySQL database instances in clustered and non-clustered environments. 
• Ensure database performance, security, availability, and reliability. 
• Prepare and maintain database documentation, technical specifications, and operational procedures. 
• Perform database upgrades, backups, restoration, recovery, and migrations. 
• Monitor database and server resource utilization and perform performance tuning and optimization. 
• Manage database users, access privileges, periodic access reviews, audits, and documentation. 
• Configure, monitor, and troubleshoot MySQL replication. 
• Collaborate with application, infrastructure, development, and other stakeholder teams to resolve database-related issues. 
• Provide database and application deployment support, as required. 
• Perform database backup and restoration validation, data integrity checks, and post-migration validations. 
• Follow database change management, security, and operational best practices. 

Skills and Qualifications 

• Strong hands-on experience in MySQL database administration. 
• Good working knowledge of recent MySQL versions, preferably MySQL 8.x. 
• Understanding of MySQL storage engines, including InnoDB and MyISAM. 
• Practical experience in configuring, monitoring, and troubleshooting MySQL replication. 
• Knowledge of MySQL administration best practices, security, and high availability. 
• Proficiency in writing, analyzing, and optimising SQL queries. 
• Experience with MySQL features such as the Event Scheduler, audit logging, and performance monitoring. 
• Ability to assess database resource requirements based on application workloads and technical specifications. 
• Familiarity with other SQL and NoSQL databases, such as PostgreSQL and MongoDB. 
• Understanding of MySQL limitations compared with other relational database platforms and the ability to identify suitable workarounds. 
• Working knowledge of version control tools such as Git, SVN, or CVS. 
• Graduate degree in a relevant discipline and good verbal and written communication skills. 

Good to Have 

• Basic Linux administration, command-line troubleshooting, and Bash scripting skills. 
• Familiarity with application server frameworks such as JBoss, GlassFish, and WildFly. 

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.

Job Description:

Mandatory Skills: Linux Administration, Production Support, Database Support, and Monitoring & Observability, with exposure to Cloud and Automation.

Primary Skills: Linux Administration, Production Support

Secondary Skills: Oracle SQL, Splunk, Grafana, AppDynamics, Cloud (OCP/AWS/Azure/GCP), Incident Management, AI/Automation (Good to have)

- 6–7 years of experience operating and enhancing enterprise-scale data platforms.

- Hands-on experience applying DataOps, DevOps, and software engineering practices to data platform operations.

- Professional experience working with AWS cloud environments.

- Experience monitoring, troubleshooting, and remediating issues across data pipelines, orchestration tools, and platform services.

- Working knowledge of data observability concepts and practices.

- Hands-on proficiency with SQL, relational database concepts, and data warehousing.

Data Platform Engineer

Design, automate, and scale our data platform — this is an engineering role, not a traditional "DBA job.

Must-have :

• Data modeling & schema design (from first principles, not just maintenance)
• PostgreSQL (deep, hands-on — partitioning, replication, tuning)
• Any distributed NoSQL store (Cassandra, ScyllaDB, or similar wide-column/distributed DB) (real production experience)
• Python (automation & tooling, not just scripting)
• DevOps & CI/CD (building pipelines, not just using them)
• Terraform (infrastructure-as-code)

You'll:

• Design schemas, partitioning strategies, and lead the Postgres → Cassandra migration end-to-end
• Own PostgreSQL performance, replication, and zero-downtime schema changes
• Build Python-based automation to eliminate repetitive DB work
• Own CI/CD pipelines and Terraform-based infra provisioning
• Drive uptime, DR, monitoring, and incident response
• Own multi-tenant security (RLS, least-privilege access) and data governance

Experience: 4–9 years, data/database/platform engineering in demanding production environments.

Bonus: Kafka/Debezium (CDC), Redis, Flyway/Liquibase, GDPR/DPDP exposure.

Snowflake Administrator

What You’ll Do

• Observability: Monitor Snowflake queries, virtual warehouses, tasks, data loads, and overall account health. Identify and resolve operational issues.
• FinOps & Cost Optimization: Monitor credit consumption, storage, and warehouse costs. Optimize warehouse sizing, auto-suspend settings, and resource monitors.
• User Management: Manage Snowflake users, roles, onboarding, offboarding, and Role-Based Access Control (RBAC).
• Privilege Access Management: Review grants, privileged roles, access policies, and audit logs to enforce the principle of least privilege.
• Platform Maintenance: Maintain Snowflake account settings, integrations, and routine operational health checks.
• Service Desk Management: Triage incidents and service requests, investigating query failures, access issues, and platform-related problems.
• Enhancements & Automation: Improve Snowflake configurations, automate operational tasks, and streamline support processes.
• Business Continuity & Recovery: Support backup and retention policies, Time Travel, Fail-safe, and data recovery procedures.
• Deployment & CI/CD: Support controlled releases of Snowflake objects, roles, scripts, and configurations through CI/CD pipelines.
• Data Load Troubleshooting: Resolve issues related to Snowpipe, COPY commands, stages, file formats, connectivity, and scheduled data loads.
• Transformation & Data Model Support: Perform first-line troubleshooting of failed tasks, SQL errors, and schema changes.
• Functional Data Support: Investigate initial data availability and quality issues, coordinating with data owners for resolution.
• Project Support: Assist engineering teams with Snowflake environments, integrations, and migrations.
• Documentation: Maintain runbooks, access management procedures, operational guides, and knowledge base articles.

What We’re Looking For

• 5+ years of experience in data platform administration, operations, or production support, including hands-on Snowflake experience.
• Strong knowledge of Snowflake administration, including RBAC, virtual warehouses, query history, performance tuning, and cost optimization.
• Hands-on experience with Snowflake data loading, stages, tasks, Snowpipe, and cloud platforms such as AWS or Azure.
• Proficiency in SQL and familiarity with Python for scripting and automation.
• Experience with CI/CD pipelines, Jira, ITSM processes, and monitoring or automation tools.
• Strong troubleshooting, documentation, communication, and stakeholder management skills.

4 - 10 years of experience in designing and buildingarchitecting highly resilient data platforms 

∙Strong knowledge of data engineering, architecture and data modeling 

∙Experience in platforms like Databricks and Snowflake 

∙Experience on building applications on cloud (AWS or Azure or Google Cloud) 

∙Strong analytical and problem-solving skills 

∙Prior experience in developing data or computation intensive (e.g. grid based) backend applications is an 

advantage 

∙OOP design skills with an understanding or at least personal interest towards the concepts of Functional 

Programming  

∙Willingness to understand and enhance other people’s code, being able to work in an environment where 

developers will oversee and work on wider components also dealing with older “legacy” code 

∙Strong programming skills (Java/ Scala / Python) skills with the willingness to pick up the other language if not 

already mastered at a sufficient level is important 

∙Spring knowledge is an advantage, but in general willingness to learn, work with and even enhance in-house 

developed frameworks is a must 

∙Prior experience in working with Git, Bitbucket, Jenkins, working with PR-s, using JIRA, following the Scrum Agile 

methodology is an advantage 

∙Prior knowledge of financial products is an advantage 

∙Bachelors or Masters in any relevant field of IT/Engineering area is an advantage  

Experience: 4+ Years 

Job Title: DevOps Engineer / Cloud Engineer 

Job Summary 

We are looking for an experienced DevOps & Cloud Engineer with 4+ years of experience in cloud infrastructure management, Kubernetes administration, CI/CD pipeline automation, and containerization. The ideal candidate should have hands-on experience with Azure cloud services, Azure Kubernetes Service (AKS), Azure DevOps, Jenkins, Docker, Terraform, and infrastructure automation. 

The candidate will be responsible for managing cloud environments, automating application deployments, maintaining Kubernetes clusters, monitoring system performance, and ensuring the reliability, scalability, security, and availability of applications across development, testing, and production environments. 

Key Responsibilities 

• Design, deploy, and manage cloud infrastructure using Microsoft Azure services, including Virtual Machines, Virtual Networks, Storage Accounts, Load Balancers, Key Vaults, and Resource Groups. 
• Manage and administer Azure Kubernetes Service (AKS), Azure Arc-enabled Kubernetes, and Kubernetes clusters. 
• Develop, configure, and maintain CI/CD pipelines using Azure DevOps and Jenkins for automated application builds, testing, and deployments. 
• Containerize applications using Docker and deploy microservices-based applications on Kubernetes. 
• Manage Kubernetes resources, including Pods, Deployments, StatefulSets, Services, Ingress, ConfigMaps, Secrets, and Namespaces. 
• Automate infrastructure provisioning and configuration management using Terraform, Ansible, and Infrastructure as Code (IaC) practices. 
• Implement Kubernetes networking, load balancing, Role-Based Access Control (RBAC), autoscaling, and resource optimization. 
• Monitor infrastructure and application performance using Prometheus and Grafana. 
• Troubleshoot application, deployment, networking, container, and infrastructure-related issues and perform root cause analysis. 
• Implement disaster recovery procedures, backup validation, failover testing, patch management, and environment upgrades. 
• Manage source code repositories, branching strategies, pull requests, code merges, and version control using Git, GitHub, and Azure Repos. 
• Maintain cloud infrastructure security, compliance, governance, high availability, and operational reliability. 
• Collaborate with development, infrastructure, and security teams to implement DevOps best practices and improve deployment efficiency. 

Mandatory Technical Skills 

1. Cloud Platforms: Microsoft Azure, Azure Virtual Machines, Virtual Networks, Storage Accounts, Load Balancers, Key Vaults. 
2. Containerization & Orchestration: Docker, Kubernetes, Azure Kubernetes Service (AKS). 
3. CI/CD & Automation: Azure DevOps, Jenkins, CI/CD pipeline development and maintenance. 
4. Infrastructure as Code: Terraform; exposure to Ansible and automated configuration management. 
5. Monitoring & Version Control: Prometheus, Grafana, Git, GitHub, Azure Repos. 

Preferred Skills 

• Azure Arc-enabled Kubernetes. 
• VMware Tanzu Kubernetes Grid (TKG). 
• Kubernetes Service Mesh, Ingress Controllers, and Horizontal Pod Autoscaling (HPA). 
• RHEL Linux administration and Shell Scripting. 
• Groovy scripting and SQL fundamentals. 
• Disaster recovery, incident management, and production support. 
• Experience supporting microservices architectures and application migration activities. 

Qualifications 

• Bachelor’s degree in Engineering (B.E.) or an equivalent qualification. 
• 4+ years of experience in DevOps engineering, cloud infrastructure, Kubernetes administration, and deployment automation. 
• Strong troubleshooting, analytical, and problem-solving skills. 
• Ability to work collaboratively with cross-functional teams and manage infrastructure-related incidents. 

Key Deliverables 

• Reliable, scalable, and secure cloud infrastructure. 
• Automated and efficient CI/CD pipelines. 
• Stable Kubernetes clusters and containerized application deployments. 
• Reduced infrastructure provisioning and deployment time through automation. 
• Effective monitoring, incident resolution, and disaster recovery readiness.