Sr. Database Engineer

We are looking for a Database Engineer (PostgreSQL) with 1-5 years of experience to manage, optimize, and maintain PostgreSQL databases. The ideal candidate will have expertise in PostgreSQL, SQL Optimization, Database Design, Performance Tuning, Data Migration, and Backup & Recovery.

Responsibilities:

• Design, develop, and maintain PostgreSQL databases.
• Optimize SQL queries and improve database performance.
• Perform database design, indexing, and schema management.
• Execute data migration, backup, recovery, and disaster recovery activities.
• Monitor database health and troubleshoot performance issues.
• Collaborate with development teams to ensure scalable database solutions.

Requirements:

• 1-5 years of PostgreSQL database experience.
• Strong SQL and performance tuning skills.
• Knowledge of database backup, recovery, and migration processes.

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

Description :

Key Responsibilities :

Primary Database Expertise :

1. One resource should have PostgreSQL as their primary database expertise.

2. One resource should have MySQL as their primary database expertise.

3. One resource should have either PostgreSQL or MySQL as their primary database expertise.

Secondary Database Skills :

- Proficiency in other databases such as MongoDB, MSSQL, ElasticSearch, Oracle, and Redis is a plus.

- Hands-on experience with databases in cloud environments, including GCP, AWS, or Azure, is a must.

- Familiarity with database migrations on GCP, AWS, or Azure cloud platforms is advantageous.

Qualifications and Skills :

- Minimum of 4 years of hands-on experience with MySQL, PostgreSQL, and MSSQL databases.

- Strong logical thinking skills to analyze and solve complex database-related issues.

- Excellent communication and articulation abilities, with the capacity to interact effectively with both technical and non-technical stakeholders.

- Proficiency in handling customer calls and addressing their database-related queries and concerns.

- Experience in one of the following primary databases : PostgreSQL, MySQL.

- Knowledge of secondary databases like MongoDB, MSSQL, ElasticSearch, Oracle, and Redis is a plus.

- Prior experience with database administration in GCP, AWS, or Azure cloud environments.

- Familiarity with database migration processes on cloud platforms is a beneficial skill.

This role offers an opportunity to work with diverse database technologies and cloud platforms, making it an ideal position for a skilled Senior DBA who enjoys a dynamic and challenging environment. If you have a strong database background and are looking to take your career to the next level, we encourage you to apply.

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. 

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 Description for PostgreSQL Lead

Job Title: PostgreSQL Lead

Company: Mydbops

About us:

Mydbops helps fast-growing teams and unicorns run mission-critical databases with speed, scale, and reliability. Trusted by 800+ clients, including 30+ unicorns, we optimize and manage systems like MySQL, PostgreSQL, MongoDB, MariaDB, TiDB, and Cassandra, powering 10B+ transactions daily across industries such as fintech, SaaS, healthcare, logistics, and e-commerce.

With 10 years of deep expertise, we build automation tools, lead complex migrations, and solve high-impact performance and database challenges. We are ISO and PCI-DSS certified, combining engineering excellence with enterprise-grade security and compliance.

Role Overview:

As the PostgreSQL Lead, you will own the design, implementation, and operational excellence of PostgreSQL environments. You’ll lead technical decision-making, mentor the team, interface with customers, and drive key initiatives covering performance tuning, HA architectures, migrations, and cloud deployments.

Key Responsibilities:

• Lead PostgreSQL production environments: architecture, stability, performance, and scalability
• Oversee complex troubleshooting, query optimization, and performance analysis
• Architect and maintain HA/DR systems (e.g., Streaming Replication, Patroni, repmgr)
• Define backup, recovery, replication, and failover protocols
• Guide DB migrations, patches, and upgrades across environments
• Collaborate with DevOps and cloud teams for infrastructure automation
• Use monitoring (pg_stat_statements, PMM, Nagios or any monitoring stack) to proactively resolve issues
• Provide technical mentorship—conduct peer reviews, upskill, and onboard junior DBAs
• Lead customer interactions: understand requirements, design solutions, and present proposals
• Drive process improvements and establish database best practices

Requirements:

• Experience: 4-5 years in PostgreSQL administration, with at least 2+ years in a leadership role
• Performance Optimization: Expert in query tuning, indexing strategies, partitioning, and execution plan analysis.
• Extension Management: Proficient with critical PostgreSQL extensions including:
• pg_stat_statements – query performance tracking
• pg_partman – partition maintenance
• pg_repack – online table reorganization
• uuid-ossp – UUID generation
• pg_cron – native job scheduling
• auto_explain – capturing costly queries
• Backup & Recovery: Deep experience with pgBackRest, Barman, and implementing Point-in-Time Recovery (PITR).
• High Availability & Clustering: Proven expertise in configuring and managing HA environments using Patroni, repmgr, and streaming replication.
• Cloud Platforms: Strong operational knowledge of AWS RDS and Aurora PostgreSQL, including parameter tuning, snapshot management, and performance insights.
• Scripting & Automation: Skilled in Linux system administration, with advanced scripting capabilities in Bash and Python.
• Monitoring & Observability: Familiar with pg_stat_statements, PMM, Nagios, and building custom dashboards using Grafana and Prometheus.
• Leadership & Collaboration: Strong problem-solving skills, effective communication with stakeholders, and experience leading database reliability and automation initiatives.

Preferred Qualifications:

• Bachelor’s/Master’s degree in CS, Engineering, or equivalent
• PostgreSQL certifications (e.g., EDB, AWS)
• Consulting/service delivery experience in managed services or support roles
• Experience in large-scale migrations and modernization projects
• Exposure to multi-cloud environments and DBaaS platforms

What We Offer:

• Competitive salary and benefits package.
• Opportunity to work with a dynamic and innovative team.
• Professional growth and development opportunities.
• Collaborative and inclusive work environment.

Job Details:

• Work time: General shift
• Working days: 5 Days
• Mode of Employment - Work From Home
• Experience - 4-5 years

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.

We are seeking an experienced Senior Database Developer to lead and support Oracle to PostgreSQL/Aurora PostgreSQL migration initiatives. The role involves deep hands-on work across SQL refactoring, schema conversion, DMS operations, performance tuning, and post–go-live stabilization. The candidate will work closely with application teams, cloud engineers, and stakeholders to ensure a smooth, performant, and compliant migration.

What you will do?

• Refactor and convert Oracle SQL, PL/SQL, and database objects to PostgreSQL-compatible SQL/PLpgSQL.
• Analyze and remediate AWS SCT (Schema Conversion Tool) findings and limitations.
• Manage and maintain Flyway migration codebase (versioned scripts, repeatable migrations, rollbacks).
• Identify, troubleshoot, and fix database-related application bugs.
• Perform query optimization for PostgreSQL (execution plans, indexing strategies, query rewrites).
• Support and monitor AWS DMS during full load and CDC phases.
• Diagnose and resolve DMS data and performance issues.
• Perform data validation and reconciliation between Oracle and PostgreSQL.
• Collaborate with application teams to align SQL behavior and performance expectations.

What are we looking for?

• Bachelor's degree in Computer Science or a related field.
• 5+ years of experience as an Oracle/PostgreSQL DBA and database developer.
• Strong experience with Oracle Database and PostgreSQL / Aurora PostgreSQL.
• Hands-on expertise in Oracle to PostgreSQL migration.
• Advanced SQL and query performance tuning skills.
• Experience with AWS SCT and AWS DMS.
• Knowledge of Flyway/Liquibase or similar schema migration tools.
• PostgreSQL internals: indexing, statistics, execution plans.
• AWS services: RDS/Aurora, CloudWatch, IAM (preferred).

You will be preferred if:

• Familiarity with automation and configuration management tools, such as Ansible, Chef, or Puppet.
• Familiarity with IAAC tools such as Terraform, CloudFormation.
• Familiarity with CI/CD implementation tools like Liquibase/Flyway.
• AWS Certified Database – Specialty.
• AWS Certified Solutions Architect.

As a DBA Director, you will co-lead our global DBA teams specializing in operational support of such platforms as Oracle, MSSQL, Postgres, MongoDB, Snowflake, and Databricks. As a critical requirement of this position, you will partner across all business units to assist with functional design, validation, and deployment of database solutions and technologies. The DBA Director will also partner closely with the other pillars of the IT organization to create secure automation of manual processes while also ensuring better stability and scalability of our backend database systems and associated processes. This role requires an experienced technically minded leader that is looking to evolve and improve internal teams through continuous skill-building and facilitating camaraderie. This role requires deep technical knowledge of database technologies, processes, as well as knowledge and awareness of DB platforms leveraged by critical systems. The person will report to the Vice President of Enterprise Tools and Middleware.

Responsibilties

• Assist with management of teams consisting of technology professionals who engineer and globally support data services and platforms.
• Participate in continuous improvement and promote team evolution and direction.
• Partner with VP of Enterprise Tools and Middleware to formulate planning and execution designed to create better automation, stability, and enhanced performance of our database platforms.
• Collaborate on a budgetary level by ensuring the organization meets all budget goals in the areas of payrolls and licensing spend.
• Facilitate and create an escalation point for high-severity tickets.
• Create and ensure 24/7 on-call rotations within teams.
• Collaborate with operational stakeholders, including defining requirements, suggesting alternatives, and setting priorities with the team.
• Provide strategic thought leadership and technical guidance across the IT organization support team.
• Be a trusted advisor in both technical and functional areas.
• Build relationships and partner with business stakeholders to understand departmental needs.

Qualifications

• Experienced professional with over 15 years of applicable database support and engineering experience.
• Track record of successfully leading global multi-team organizations.
• Verifiable people management and team building experience.
• Manage and prioritize team leaders as well as team workloads to deliver on committed projects, initiatives, and tickets.
• Demonstrated understanding of ITIL and ITSM; ITSM methodology pertaining to managing incidents, change requirements, and overall reducing risk.
• Proven experience and ability to proactively solve problems and implement solutions to continuously improve.
• Ability to recruit, train and retain high quality talent.
• Proven track record of building strong relationships.
• Experience deploying, optimizing, and supporting DBA processes and platforms.
• Carries a value-driven focus for continual improvement.