Team Lead/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. 

Job Description: 

•   Understand existing databases and develop schemas, tables, indexes, relationships, constraints, stored procedures, and data access patterns. 

•  Design and build the target database structure based on application requirements and business logic. 

•  Define database architecture, data models, table structures, indexing strategies, and performance optimization approaches. 

•   Support mapping of existing database objects and data access logic to the target Java application architecture. 

•   Develop and validate SQL queries, database scripts, and data access components. 

•  Assess data migration requirements, data integrity, reconciliation, and compatibility. 

•   Support database testing, performance tuning, troubleshooting, and production readiness. 

Experience – 8-10 Years 

Location – Preferably Bengaluru  

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!

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.

We are looking for a Database Developer (PostgreSQL) .

Requirements

- 5+ years of hands-on PostgreSQL experience in a production or production-adjacent context 

- Strong SQL skills, including joins, aggregation, common table expressions, window functions, upserts, and DDL

- Ability to read execution plans and use a systematic approach to diagnose and rewrite slow SQL statements

- Practical understanding of transactions, isolation levels, locking, and MVCC

- Experience with physical database design, including tables, keys, constraints, indexes, and partitioning

- Practical experience with data migrations, including bulk or incremental loads, cutovers, and validation

- Practical backup and restore experience, including retention, point-in-time recovery, or restore testing

- Ability to write reliable operational scripts and idempotent reconciliation or backfill processes

- Basic Python experience for data loading and operational scripting.

Nice to have

- Experience with a schema migration tool such as Alembic, Flyway, or Liquibase 

- Experience managing declarative partitioning at scale

- Experience with managed cloud PostgreSQL

- Experience tuning PostgreSQL statistics, autovacuum, bloat, and lock contention