DBA – AWS Aurora PostgreSQL

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!

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.

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. 

Postgress Developer

Experience: 2 to 5 Years

Location: Chennai

Type: Contract

Duration : 6+ Months

Immediate joiners only

Roles & Responsibilities:

Hands-on experience writing efficient SQL queries, views, stored procedures, custom functions, indexing strategies.

Analyse execution plans, and triggers.

Ability to Identify and resolve blocking sessions, deadlock issues, slow queries, and database locks in high-concurrency environments.

Job Title : Senior AWS Data Engineer – Data Lake Platform

Experience : 5+ Years

Location: Gurugram Sector 43, Haryana

Work Mode : Work From Office (5 Days a Week – Monday to Friday)

Open Positions : 8+

About the Role :

We are looking for a skilled Senior AWS Data Engineer with strong hands-on experience in building, managing, and optimizing enterprise-scale data lake platforms on AWS.

The ideal candidate will have expertise in AWS data services, PySpark, Apache Airflow, and large-scale data pipeline development. The role involves designing end-to-end data ingestion and processing workflows, maintaining data quality, optimizing platform performance, and supporting analytics and downstream data consumption requirements.

Mandatory skills :

AWS Data Lake, Amazon S3, EMR, Glue, Athena, Redshift, DMS, Lambda, RDS, IAM, PySpark, Apache Spark, Apache Airflow, Python, Advanced SQL, Data Modeling, Production Data Pipelines, Hasura/GraphQL, PostgreSQL, and Production Support.

Key Responsibilities :

• Design, develop, and maintain scalable AWS-based data lake platforms and end-to-end data pipelines.
• Build data ingestion, staging, transformation, curated, and consumption layers using AWS services.
• Develop and optimize data processing pipelines using PySpark, Apache Spark, and AWS EMR.
• Implement workflow orchestration and scheduling using Apache Airflow.
• Work with Amazon S3, AWS Glue, Glue Data Catalog, Amazon Athena, and Amazon Redshift for data storage, cataloging, processing, and analytics.
• Develop efficient SQL queries and implement data modeling strategies for enterprise reporting and analytics.
• Build and support data-serving solutions using Amazon RDS, AWS Lambda, API Gateway, and PostgreSQL-based platforms.
• Monitor pipeline performance, troubleshoot production issues, perform root-cause analysis, and ensure data pipeline SLAs.
• Implement data security, access controls, PII protection, and governance best practices across the platform.
• Optimize data processing performance, query execution, storage utilization, and AWS infrastructure costs.
• Collaborate with application, analytics, and business teams to deliver reliable and scalable data solutions.

Mandatory Skills :

• AWS Data Services : Amazon S3, EMR, Glue, Athena, Redshift, DMS, Lambda, RDS, and IAM.
• Data Engineering : Strong hands-on experience building and maintaining enterprise data lake platforms.
• Programming : Python, PySpark, and Apache Spark.
• Orchestration : Production experience with Apache Airflow.
• Database & SQL : Advanced SQL, data modeling, and query optimization.
• Data Architecture : Experience with data ingestion, staging, transformation, curated layers, and consumption architecture.
• Production Support : Pipeline monitoring, troubleshooting, root-cause analysis, and SLA management.
• API / Data Serving : Experience with Hasura or a similar GraphQL-based data-serving layer integrated with PostgreSQL.
• Platform Ownership : Ability to independently manage data pipelines, improve platform reliability, and collaborate with cross-functional teams.

Good-to-Have Skills :

• Experience with dbt for data transformation and modeling.
• Knowledge of data lakehouse architectures and table formats such as Apache Iceberg, Delta Lake, or Apache Hudi.
• Experience with Amazon Redshift workload optimization, distribution keys, sort keys, and Spectrum.
• Knowledge of Kafka and real-time or streaming data ingestion.
• Experience with PostgreSQL or Amazon Aurora as a data-serving layer.
• Familiarity with data governance, compliance, and sensitive-data management.
• Experience in the BFSI or health insurance domain.

Ideal Candidate Profile :

• 5+ years of hands-on experience in AWS Data Engineering.
• Strong experience building and supporting production-grade AWS data lake platforms.
• Practical expertise in PySpark, Apache Airflow, SQL, and AWS data services.
• Ability to troubleshoot complex data pipeline issues and optimize performance.
• Strong understanding of data architecture, data modeling, and production support practices.
• Candidates with experience in enterprise data platforms and insurance or BFSI environments will be preferred.

PostgreSQL Developer – Chennai

Experience: 2–5 Years

Location: Chennai

Employment Type: Contract

Contract Duration: 6+ Months

Immediate Joiners Only

Payroll: Candidate's existing payroll will continue (Payroll stays with you).

Job Description

We are looking for an experienced PostgreSQL Developer with strong hands-on experience in SQL development, database optimization, and troubleshooting.

Roles & Responsibilities

• Write and optimize efficient SQL queries, views, stored procedures, and custom functions.
• Develop and implement indexing strategies for better database performance.
• Analyze SQL execution plans and optimize query performance.
• Work with database triggers and troubleshoot database-related issues.
• Identify and resolve blocking sessions, deadlocks, slow queries, and database locking issues.
• Handle high-concurrency database environments and ensure optimal performance.

Required Skills

• PostgreSQL
• Advanced SQL
• Stored Procedures & Functions
• Views & Triggers
• Indexing & Query Optimization
• Execution Plan Analysis
• Deadlock & Lock Management
• Performance Tuning

Interested candidates can share their updated resumes.

Location: Bangalore

Experience: 6+ Years

Role: Java Backend Developer

Required Skills:

Java.

PostgreSQL / Database Management.

AWS services such as:

AWS ECS

AWS Lambda

How to Apply

Interested candidates can share their updated resumes:

Email: revathi.r @vysystems. com

WhatsApp: 6 3 8 5 0 7 6 1 4 2

Job Overview:

We are seeking an experienced Cloud Data Engineer to the architecture, development, Data migration, ETL pipeline in cloud and optimization of a next-generation data platform. This is a development role for an individual with over 4 years of deep data engineering and data migration, data pipeline in AWS expertise, capable of driving technical direction, and delivering high-impact solutions in a fast-paced

4+ Years of hands-on, progressive experience in Cloud Data Engineering, cloud ecosystems AWS, Data Architecture

• Deep conceptual understanding of core data engineering principles, ETL/ELT patterns, and metadata management

•  Ability to translate complex business needs into actionable technical requirements.

•  Strong troubleshooting and problem-solving skills in distributed systems.

•  Agile/Scrum teamwork capabilities and version control practices

• Insurance industry experience preferred but not mandatory

• Tools:

o Cloud Environment: AWS (S3, IAM, VPC, Glue, Lambda etc.)

o Experience with dbt Core, Iceberg, AWS Glue Catalog, AWS lambda, Redshift, Athena, Splunk, AmazonQ, AWS streaming services, Git

o Strong SQL, Pyspark and Python

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.

TECHJAYS

Position: Senior Database Engineer / DBA

Experience: 7+ Years

Location: Coimbatore / Hybrid (Remote option available)

Employment Type: Contract

Joining: Immediate or within 30 days preferred

Core Focus: Microsoft SQL Server Administration, Always On Availability Groups, Performance Tuning, Database Security, Disaster Recovery, Production Database Operations, High Availability, and Multi-Terabyte Database Management.

Tools & Platforms: Microsoft SQL Server (HA / Clustered), Always On Availability Groups (AGs), TDE & Auditing, T-SQL, Partitioning & Archiving, PowerShell, Snowflake / Redshift / AWS Aurora (Nice to Have).

About the Role

We are looking for a Senior Database Engineer / DBA to own a large, multi-terabyte Microsoft SQL Server environment running in a highly available, clustered configuration.This is a hands-on production database role supporting a live, customer-facing SaaS platform. The role focuses on maintaining database availability, performance, security, and reliability. This is not an analytics or reporting role.

The ideal candidate will have strong hands-on experience managing SQL Server databases in a 24x7 production environment, troubleshooting complex database issues, maintaining Always On Availability Groups, and ensuring business continuity through effective disaster recovery practices.

Key Responsibilities

1. Production Database Administration & High Availability

Own and maintain the production SQL Server environment in an Always On Availability Group configuration.Handle failover operations, synchronization delay troubleshooting, and read replica load management.Maintain database availability and ensure the stability of production database environments.Manage SQL Server alerts and provide on-call coverage for production database operations.

2. Performance Tuning & Incident Management

Lead incident response and root cause analysis for production database issues.Troubleshoot query plan regressions, TempDB contention, deadlocks, and blocking issues.Perform index and statistics maintenance to ensure optimal database performance.Review developers' T-SQL queries and schema changes before deployment. Advise developers on table design, indexing strategies, and database performance optimization.

3. Database Security & Compliance

Maintain database security through Transparent Data Encryption (TDE), auditing, and certificate and key rotation.Monitor anomalous database access patterns and ensure appropriate security controls.

Handle confidential or legally sensitive data requests following established processes.Maintain database security standards and support compliance requirements.

4. Database Maintenance & Capacity Planning

Perform quarterly cumulative update patching across database environments.Manage partitioning and archiving on multi-terabyte databases without impacting production performance.

Own capacity planning for storage, CPU, and memory.Manage recurring environment refreshes across staging, development, and QA environments.Ensure production maintenance activities are performed safely with minimal downtime.

5. Disaster Recovery & Database Migrations

Design, implement, and test disaster recovery strategies for SQL Server environments.Support customer instance migrations between regions, including database preparation and validation.

Perform regular DR testing and ensure database recovery readiness. Manage large-scale database migrations while maintaining availability and data integrity.

6. Production Operations & Support

Provide on-call, weekend maintenance, and after-hours support as required.Maintain clear documentation of database changes, incidents, and recovery procedures.Work closely with engineering teams to ensure reliable database operations.Ensure production database changes follow established change control and operational procedures.

Must-Have Requirements

• 7+ years of hands-on Microsoft SQL Server DBA experience in a 24x7 production environment. SQL development experience alone is not sufficient.
• 3+ years of direct experience with Always On Availability Groups, including failover handling and synchronization delay troubleshooting.
• Experience managing multi-terabyte production databases, including partitioning, archiving, and index and statistics maintenance without blocking production.
• Experience leading incident response and root cause analysis for production database issues.
• Strong experience with database security practices, including TDE, auditing, certificate rotation, and key management.
• Hands-on experience with SQL Server performance tuning, query optimization, and production troubleshooting.
• Experience designing and testing disaster recovery strategies.
• English fluency sufficient for real-time incident communication, with meaningful business-hours overlap with Pacific time.
• Nice-to-Have Skills
• Experience supporting a SaaS CRM or similarly high-transaction-volume application.
• Exposure to Snowflake, Redshift, or AWS Aurora alongside transactional SQL Server work.
• Experience with customer instance migrations or similar large-scale data movement projects.
• Experience in SOC 2, HIPAA, or PCI-regulated environments.
• Comfort handling legally sensitive or confidential data requests as part of a defined process.

What We're Looking For

Strong Ownership: Takes responsibility for maintaining large, multi-terabyte production databases and ensuring their availability and reliability.

Technical Expertise: Demonstrates deep hands-on knowledge of SQL Server administration, Always On Availability Groups, performance tuning, and disaster recovery.

Incident Management: Maintains a calm, structured approach during production incidents and takes ownership of root cause analysis and preventive actions.

Attention to Detail: Follows disciplined change control, documentation, database security, and maintenance practices.

Clear Communication: Communicates effectively with developers, engineering teams, and stakeholders during live production incidents.

Operational Excellence: Understands the importance of maintaining production databases with minimal downtime and without impacting customer-facing applications.

Execution-Focused Mindset: Comfortable managing day-to-day database administration, on-call support, and hands-on production operations.

What We Offer

• Flexible work environment with Coimbatore office, hybrid, and remote options.
• Paid holidays and flexible time off.
• Medical insurance coverage of up to ₹4 lakh per person for self and family.
• Opportunities to support production infrastructure for global clients.
• A culture that values clarity, integrity, accountability, and continuous growth.