PostgreSQL Expert

You'll own heterogeneous database migrations end to end for enterprise customers moving off Oracle and SQL Server onto PostgreSQL and Aurora PostgreSQL. That means running the AWS DMS and SCT toolchain, then doing the part the tools can't: rebuilding procedural business logic in PL/pgSQL when SCT flags a gap it can't close on its own. You ship the runbook, you run the cutover, you validate the result. 

What you'll do?

• Lead end-to-end database migration initiatives, including assessment, planning, schema conversion, execution, and post-migration validation.
• Design, configure, and manage AWS DMS and SCT environments while ensuring migration quality, performance, and reliability.
• Author comprehensive migration runbooks that define execution procedures, validation checkpoints, rollback plans, and operational readiness activities.
• Perform database migration assessments, dependency analysis, compatibility reviews, and migration strategy recommendations.
• Collaborate with infrastructure, application, security, and platform teams to ensure successful migration outcomes.
• Drive migration testing activities, including functional validation, performance testing, failover testing, and production readiness reviews.
• Provide technical leadership and guidance to migration teams while ensuring adherence to AWS migration best practices and governance standards.
• Lead conversion and refactoring of procedural database code — Oracle PL/SQL (packages, procedures, functions, triggers, cursors) and SQL Server T-SQL (stored procedures, functions, triggers) — into PostgreSQL/Aurora PostgreSQL PL/pgSQL, resolving semantic and behavioral differences identified by SCT.

What we're looking for?

• 8–12 years of professional experience in database architecture and migration delivery
• Hands-on expertise in AWS Database Migration Service (DMS) and AWS Schema Conversion Tool (SCT) for enterprise-scale database migrations
• Deep proficiency in Oracle, SQL Server, PostgreSQL, and Aurora PostgreSQL environments, including migration planning, execution, and optimization
• Proven background in delivering heterogeneous database migrations across on-premises, cloud, and AWS environments
• Knowledge of production database operations, including backup and restore strategies, parameter tuning, performance optimization, and failover testing
• Skills in authoring and executing migration runbooks, validation plans, cutover procedures, rollback strategies, and post-migration stabilization activities
• Strong understanding of AWS database services, migration best practices, and integration with broader cloud migration programs
• Experience engaging directly with enterprise customers, architecture teams, and migration stakeholders to drive successful delivery outcomes
• Strong hands-on experience converting Oracle PL/SQL and SQL Server T-SQL business logic to PL/pgSQL, including handling of exception handling models, cursor semantics, autonomous transactions, sequences/identity columns, implicit data type conversions, and proprietary built-in packages/functions with no native PostgreSQL equivalent
• Ability to identify and remediate SCT action items and manual conversion gaps in procedural code (e.g., DBMS_* packages, UTL_* utilities, SQL Server system procedures, dynamic SQL, and nested/recursive procedure calls) and validate converted logic through functional and regression testing.

You'll be preferred if you

• Have tuned production database performance, backup and restore strategy, and failover testing in high-stakes environments.
• Have led migration teams or mentored engineers through complex conversions.
• Bring experience with broader AWS cloud migration programs beyond the database layer.

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.

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

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!

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.

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.

Job Title: Senior Data Engineer

Position Summary

We are seeking a highly skilled Data Engineer with strong expertise in reporting infrastructure, data modeling, and analytics platforms. This role will focus on building scalable reporting solutions, optimizing data pipelines, and enabling data-driven decision-making across the organization. The ideal candidate will have deep experience with databases, data warehousing, and complex query development. While Ruby on Rails experience is beneficial, the primary emphasis is on data engineering and reporting systems.

Key Responsibilities

• Design, develop, and maintain reporting infrastructure and data platforms.
• Build and optimize complex SQL queries, data models, and reporting datasets.
• Develop scalable ETL/ELT pipelines and data integration processes.
• Design and maintain database schemas to support analytics and reporting requirements.
• Collaborate with business stakeholders to understand reporting needs and translate them into technical solutions.
• Implement data quality, governance, and performance best practices.
• Support and enhance enterprise reporting solutions and dashboards.
• Work with large-scale datasets in cloud data warehouse environments.
• Troubleshoot reporting issues and optimize database performance.
• Partner with engineering and product teams to establish sustainable data architecture.

Must Have: Technical Skills

• PostgreSQL
• Snowflake
• Advanced SQL
• Data Modeling
• Data Warehousing
• Reporting & Analytics Infrastructure
• ETL/ELT Development
• Query Performance Tuning

Success Profile:

The ideal candidate is a data-focused engineer who enjoys working with complex datasets, designing scalable reporting solutions, and building foundational infrastructure that empowers analytics and business intelligence teams. They should be comfortable navigating databases, optimizing queries, and translating business reporting needs into robust technical implementations.

Experience Range: 5-10 years

Role Type: Individual Contributor / Senior Engineer

Primary Focus: Reporting Infrastructure, Data Engineering, Data Warehousing, and Analytics Enablement.

Mactores is the agent-native AWS modernization firm. Most modernization work doesn't ship, it stalls in pilots, slips a year, or lands at three times the budget. We exist to ship it: production systems running, legacy retired, outcomes measured. Our delivery is built on Aedeon, the agent platform built by Mactores' founders' sister company, which absorbs the repetitive 60–70% of engagement work, discovery, dependency mapping, validation, test generation, that traditional consulting bills human hours against. Forward-deployed engineers own the rest: architecture, judgment, and cutover, on dates we commit to in the contract.

Enterprises stuck on Oracle carry license renewals, vendor-specific SQL nobody wants to touch, and application layers welded to the database underneath them. This role sits in our Application & Database Modernization pillar: you'll work an Oracle-to-PostgreSQL migration where Aedeon handles the mechanical conversion at scale and you own what the tools can't, which is the refactoring judgment inside large enterprise Java codebases.

You'll rewrite the SQL the application actually depends on, align it with the modernized schema, prove functional parity, and see the application through production cutover. Not a proof of concept. A system that ships.

What you will do?

• Decompose a large Java monolith into microservices: identify bounded contexts, extract services with the strangler-fig pattern, and define REST and event contracts.
• Apply proven microservice patterns: database-per-service (staged pragmatically), Saga with compensating actions, transactional outbox, idempotent consumers, and resilience patterns such as circuit breakers.
• Remediate Oracle- and SQL Server-specific code for Aurora PostgreSQL: rewrite embedded SQL, stored procedure calls, sequences, pagination, date handling and error handling, and update JPA/Hibernate or MyBatis mappings.
• Work closely with database migration engineers so application-layer SQL lines up with the converted target schema and supports environment cloning and refresh.
• Deploy and run services on Amazon EKS: Helm charts, health probes, JVM and resource tuning, autoscaling, ALB/NLB ingress, and Pod Identity for AWS access.
• Build and maintain GitHub Actions CI/CD pipelines for Java services: Maven/Gradle builds, scanned images in Amazon ECR, Flyway/Liquibase migrations, and promotion from dev to prod with approval gates and rollback.
• Automate testing: unit, Testcontainers integration, contract, API and smoke tests, plus parity and performance tests that prove modernized services match or beat legacy baselines. Wire the client's existing suites into the pipeline.
• Use GenAI-assisted tools (Claude Code) to accelerate code conversion, and validate their output rigorously.
• Instrument services for Dynatrace and support production cutover: rehearsals, validation, rollback planning and stabilization.
• Produce engineering documentation that outlives the engagement: design notes, code-migration runbooks, troubleshooting guides and knowledge-transfer material for the client's teams.
• Pair with client engineers and SMEs across US- and India-based teams, reviewing code and keeping business logic aligned.

What are we looking for?

• Bachelor's degree in Computer Science, Engineering, or a related field.
• 5+ years of professional Java development experience (Java, Spring Boot, Spring Cloud, JDBC, JPA/Hibernate or MyBatis).
• Hands-on experience decomposing a monolith into microservices in production: domain-driven design, Saga and event-driven integration (Kafka, SQS/SNS or EventBridge).
• Strong SQL expertise. You can analyze, optimize and rewrite complex SQL embedded in Java, and you've migrated application code from Oracle or SQL Server to PostgreSQL.
• Deep understanding of JDBC, ORMs, transaction management, connection pooling and database-driven application flows.
• Production experience running Spring Boot on Kubernetes (preferably Amazon EKS) with Docker and Helm.
• CI/CD experience with GitHub Actions: reusable workflows, environment approvals and OIDC authentication to AWS.
• Test automation skills: JUnit 5, Mockito, Testcontainers, REST Assured and consumer-driven contract testing.
• Working knowledge of AWS application services: Aurora PostgreSQL, RDS Proxy, KMS and IAM roles for workloads.
• Regular use of AI coding assistants in real delivery work.
• Excellent spoken and written English, and the ability to work US Mountain Time business hours with globally distributed teams.

You will be preferred if you

• Have exposure to automated code-refactoring tools or GenAI-assisted remediation workflows.
• Have experience with Amazon VPC Lattice or a service mesh.
• Have done performance testing (Gatling, JMeter or k6) and worked with observability stacks (Dynatrace or OpenTelemetry).
• Have worked on MuleSoft integrations and Ping Identity (OAuth 2.0 / OIDC).
• Have worked in SOX-regulated environments: change control, approvals and audit evidence.
• Have worked on e-commerce, subscription ordering or commission/compensation systems.
• Hold an AWS certification (Developer Associate or Solutions Architect) and have basic Terraform.

🚨 Hiring: GCP Data Engineer

We are looking for experienced GCP Data Engineers to join our team!

🔹 Experience: 9+ Years

🔹 Relevant Experience: 4+ Years in GCP Data Engineering

🔹 Required Skills: GCP, Oracle PL/SQL, Python, PySpark

🔹 Location: Bangalore / Hyderabad

🔹 Notice Period: Immediate to 10 Days Preferred

Key Skills:

🔹 Strong hands-on experience in GCP Data Engineering

🔹 Good experience with PySpark & Python

🔹 Strong knowledge of Oracle PL/SQL

🔹 Experience in data processing, ETL, and data pipelines

🔹 Good understanding of cloud-based data engineering

📩 Interested candidates can share their updated CV via DM.

#Hiring #GCPDataEngineer #GCP #DataEngineering #PySpark #Python #OraclePLSQL #DataEngineer #BangaloreJobs #HyderabadJobs #ImmediateJoiner #TechJobs #ITJobs #HiringNow

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