Senior Postgres Administrator

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. 

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!

Job Description – Senior Database Architect (Couchbase)

Experience: 12+ Years

Location: Bangalore

Notice Period: Immediate Joiners Only

Employment Type: Full-Time

Job Summary

We are looking for a highly experienced Senior Database Architect with strong expertise in Couchbase and NoSQL database technologies. The ideal candidate will be responsible for designing enterprise-grade database architectures, driving database performance optimization, ensuring high availability, and providing technical leadership for large-scale, distributed database systems.

Key Responsibilities

• Design and implement scalable, highly available, and secure Couchbase database architectures for enterprise applications.
• Define database architecture strategies, data modeling standards, and best practices.
• Lead Couchbase cluster design, deployment, configuration, replication, and capacity planning.
• Optimize SQL++ (N1QL) queries, indexing strategies, data access patterns, and overall database performance.
• Architect disaster recovery, backup, restore, failover, and business continuity solutions.
• Troubleshoot complex database performance issues and conduct root-cause analysis.
• Lead database migration, modernization, and integration initiatives.
• Establish database security policies, access controls, encryption, and compliance standards.
• Collaborate with application architects, development teams, DevOps, and infrastructure teams to align database architecture with business requirements.
• Evaluate database technologies and recommend solutions based on scalability, performance, availability, and cost.
• Provide technical leadership, mentor database engineers, and conduct architecture and design reviews.
• Develop database monitoring, alerting, automation, and operational excellence strategies.

Required Skills and Qualifications

• 12+ years of experience in database architecture, database engineering, or database administration, with strong hands-on expertise in Couchbase.
• Extensive experience in Couchbase Server architecture, cluster management, replication, and distributed data systems.
• Strong expertise in SQL++/N1QL, indexing, query profiling, and performance tuning.
• In-depth knowledge of NoSQL data modeling, document design, partitioning, and scalability principles.
• Experience designing high-availability, disaster recovery, backup, and recovery solutions.
• Proven experience handling large-scale databases and mission-critical enterprise applications.
• Strong understanding of database security, access management, and performance monitoring.
• Experience with Linux, scripting, and database automation.
• Excellent troubleshooting, analytical, communication, and stakeholder management skills.

Good to Have

• Experience with AWS, Microsoft Azure, or Google Cloud Platform.
• Knowledge of Kubernetes, Docker, and containerized deployments.
• Experience with infrastructure as code, CI/CD pipelines, and automation tools.
• Exposure to database migration, cloud-native architectures, and microservices.
• Experience defining database governance, architecture standards, and technology roadmaps.

Candidate Profile

• Total Experience: 12+ Years
• Core Technology: Couchbase
• Primary Focus: Database Architecture, NoSQL, Performance Optimization, High Availability, and Scalability
• Location: Bangalore
• Joining Requirement: Immediate Joiners Only
• Interview Process: Technical Discussion and Management Round

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 Summary

We are looking for an experienced Database Architect with strong expertise in Couchbase to design, implement, optimize, and maintain scalable, high-performance database solutions. The ideal candidate should have hands-on experience in NoSQL database architecture, data modeling, query optimization, indexing, and high availability.

Key Responsibilities

• Design and implement scalable, secure, and high-performance Couchbase database architectures.
• Develop efficient data models and document structures to support business and application requirements.
• Optimize SQL++ (formerly N1QL) queries, indexing strategies, and database performance.
• Configure and manage Couchbase clusters, replication, and high-availability environments.
• Implement backup, recovery, disaster recovery, and failover strategies.
• Monitor database performance, troubleshoot bottlenecks, and perform root-cause analysis.
• Plan database capacity, scalability, and resource utilization.
• Establish database security, access controls, and performance optimization standards.
• Collaborate with application developers, cloud engineers, and DevOps teams.
• Lead database architecture reviews and recommend best practices for database design and deployment.

Required Skills

• Minimum 6+ years of experience in database technologies, with strong hands-on expertise in Couchbase.
• Strong understanding of NoSQL databases and distributed database architecture.
• Expertise in Couchbase Server, SQL++/N1QL, indexing, and query optimization.
• Experience with data modeling, performance tuning, clustering, and replication.
• Knowledge of high availability, disaster recovery, backup, and recovery mechanisms.
• Experience with Linux and database monitoring and troubleshooting.
• Strong analytical, problem-solving, and communication skills.

Good to Have

• Experience with cloud platforms such as AWS, Azure, or GCP.
• Knowledge of Docker and Kubernetes.
• Experience with database migration, automation, and scripting.
• Familiarity with CI/CD and infrastructure automation tools.

Candidate Requirements

• Experience: 6+ years
• Primary Skill: Couchbase Database Architecture
• Location: Bangalore
• Joining: Immediate joiners preferred/required
• Interview Process: Technical interview followed by managerial discussion

Company Overview:

Euphoric Thought Technologies is a technology-driven organization focused on building scalable, high-performance data ecosystems that power modern digital enterprises. Operating at the intersection of big data and cloud infrastructure, the company provides robust platforms that enable businesses to process complex information in real-time. With a culture rooted in engineering excellence and technical innovation, Euphoric Thought Technologies supports a diverse portfolio of clients, ensuring their data architecture remains resilient, secure, and highly available as they scale globally.

Role Overview:

As a Senior Database Architect, you will serve as the primary technical authority for the design, implementation, and optimization of our core data platforms. You will work closely with engineering leadership, product managers, and infrastructure teams to translate complex business requirements into high-performing database solutions. Your work will directly influence the reliability and efficiency of our systems, ensuring that our data architecture can handle massive throughput while maintaining strict integrity standards. This role is pivotal in shaping our long-term data strategy and mentoring junior engineers to maintain a high bar for technical excellence.

Key Responsibilities:

- Design and implement highly scalable database architectures using Couchbase to support high-concurrency applications and ensure low-latency data access.

- Lead the end-to-end database design process, including schema modeling, indexing strategies, and partitioning, to optimize performance for large-scale enterprise workloads.

- Oversee comprehensive database administration tasks, including capacity planning, performance tuning, and disaster recovery, to ensure 99.99% system availability.

- Collaborate with cross-functional development teams to troubleshoot complex data bottlenecks and implement automated solutions that streamline deployment pipelines.

- Establish and enforce best practices for data security, compliance, and governance across all production and staging environments to protect sensitive information.

- Mentor engineering teams on advanced database concepts and emerging technologies to foster a culture of continuous learning and technical growth.

Required Skillset:

- Demonstrated expertise in architecting and managing NoSQL solutions, with a deep specialization in Couchbase and its integration within distributed systems.

- Proven ability to design complex database schemas and optimize query performance in high-traffic, mission-critical environments.

- Strong proficiency in database administration, including proactive monitoring, backup/recovery strategies, and infrastructure automation.

- Excellent communication skills with the ability to articulate complex technical trade-offs to non-technical stakeholders and influence architectural decisions.

- Ability to thrive in a collaborative, fast-paced environment in Bangalore, working effectively with both local and distributed teams.

- A Bachelor’s or Master’s degree in Computer Science or a related field, combined with 6 to 12 years of hands-on experience in database architecture and engineering.

A Database Architectdesigns, builds, and optimizes large-scale database systems, data models, and storage infrastructures to ensure high performance, security, and scalability

Requried Skills::

Typically requires 12+ years of hands-on experience in database administration, database development, or systems architecture

• Deep expertise in SQL and NoSQL databases (e.g., Oracle, MySQL, PostgreSQL, MongoDB, Amazon DynamoDB).
• Hands on Experience in Couchbase
• Proficiency in data modeling tools and cloud architecture.
• Knowledge of data governance, security standards, and high-availability frameworks.

Connect new databases with existing infrastructure, APIs, and cloud platforms (such as AWS, Azure, or Google Cloud)

Partner with software developers, data engineers, and IT teams to guide database implementation and operational best practices

Qualification ::

Education: A bachelor’s degree in Computer Science, Information Technology, Data Science, or a related field (some senior roles prefer a master's degree).

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.

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.

About the Organisation

DataFlow Group is a pioneering global provider of specialized Primary Source Verification (PSV) solutions, and background screening and immigration compliance services that assist public and private organizations in mitigating risks to make informed, cost-effective decisions regarding their Applicants and Registrants.

DataFlow with its best practices in this field such as a high level of data security, cutting-edge technology, rigorous processes, qualified research analysts, and a global network of over 100,000 issuing authorities, verifies professionals credentials from the primary issuer of the document - regardless of its nature.The company complements its advanced verification processes and long-standing industry expertise by adhering to the highest regulatory standards, including the Joint Commission International (JCI), International Organization for Standardization (ISO), and the European Union’s General Data Protection Regulation (GDPR).

About the Role:

We are looking for a Backend Architect / Lead who lives and breathes code. This isn't a role for someone who wants to delegate; it’s for a technical heavyweight who wants to own core product development, define backend architecture patterns, and build scalable, secure, and resilient systems from the ground up. You will join a fast-paced environment where we ship high-quality code under tight timelines. You’ll be expected to take full ownership of our server-side ecosystem, database design, and API layer, ensuring high availability, bulletproof operational excellence, and top-tier performance.

Duties and Responsibilities:

● Architect & Build: Design and implement complex, scalable microservices and monolithic architectures using Node.js, Express.js, and MongoDB (MERN backend stack).

● Heavyweight Coding: Spend the majority of your time writing high-quality, production-ready backend code. You should be comfortable solving complex systems problems using efficient Data Structures, Algorithms, and clean architecture principles.

● Performance & Data Engineering: Own database optimization, query performance, indexing strategies, caching layers (Redis), and system throughput to ensure low-latency API response times.

● Technical Leadership: Establish and enforce industry best practices for REST/GraphQL API design, security standards, code reviews, and automated CI/CD pipelines.

● End-to-End Ownership: Participate in the full SDLC—from initial ideation and system design to deployment, infrastructure setup, and production monitoring on AWS

Qualifications:

● The Deep Diver: You have spearheaded at least one large-scale, complex backend project or system redesign. You can explain every architectural decision, trade-off, database schema choice, and line of code in a deep-dive technical discussion.

● Experience: You have at least 8 years of professional software development experience, with a significant focus on high-traffic, distributed backend systems.

● Tech Stack Mastery: Expert-level proficiency in Node.js, Express.js, MongoDB (Mongoose/Aggregation framework), and TypeScript. Strong hands-on experience with AWS (EC2, S3, ECS/Lambda, CloudWatch) and containerization (Docker).

● Architectural Fluency: A solid understanding of modern backend patterns (Microservices, Event-Driven Architecture, Pub/Sub, Caching strategies, Message Queues like RabbitMQ/Kafka, State Management, and Authentication/Authorization protocols).

● Optimization Expert: Proven experience in tuning database performance, scaling server instances, managing connection pools, and debugging memory leaks or high CPU usage under heavy load.

● Grit & Speed: You thrive in high-pressure environments and enjoy the challenge of meeting tight deadlines without compromising on quality or system reliability.