Database Administrtion at Mphasis · Chennai · 6 - 10 years · ₹5L - ₹10L / yr · Posted 2 Aug 2025

years MS SQL Server Administration experience required
∙Provide 24x7 support for critical production systems.
∙ Provide technical leadership for the service component or the product.
∙IT Operations with strong understanding of database structures, theories, principles, and best practices.
∙Experience with Performance Tuning and Optimization (PTO), using native monitoring and third-party tools
∙Experience with backups, restores and recovery processes
∙Knowledge of High Availability (HA) and Disaster Recovery (DR) options for SQL Server
∙Assist developers with complex query tuning and schema refinement.
∙Experience in handling database corruption
∙Manage Encrypted database, TDE and SSL certificate
∙Manage PaaS and IaaS environment
∙Experience with SSIS packages, SSRS and SSAS
∙Experience working with Windows server, including Active Directory

About Mphasis
About
Similar jobs (8)
We are looking for a Database Administrator to keep our databases fast, secure and highly available.
Responsibilities
- Install, configure and maintain Oracle, PostgreSQL and SQL Server databases
- Tune queries and database performance
- Manage backup, recovery and disaster-recovery plans
- Handle replication, high availability and security
Requirements
- 2+ years as a DBA on Oracle, PostgreSQL or SQL Server
- Strong backup, recovery and tuning experience
- Oracle or Microsoft DBA certification is a plus
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.
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
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.
Database Engineer (PostgreSQL) | 1-5 Years | Bangalore
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.
Job Description — L2/L3 Oracle DBA and Oracle Apps DBA
Experience: 5–10 years of relevant experience
Support coverage: Dubai customer business hours and on-call support as required
Role Overview
We are seeking an experienced Oracle DBA and Oracle Apps DBA to support
customer Oracle Database and Oracle E-Business Suite (EBS) environments. The role
involves L2 incident resolution, L3 troubleshooting, performance tuning, patching,
upgrades, and maintaining database and application availability.
Key Responsibilities
Oracle Database Administration
∙Install, configure, administer, and maintain Oracle databases across
production and non-production environments.
∙Monitor database health, availability, performance, storage, and capacity.
∙Troubleshoot database incidents, connectivity failures, locking, blocking, and
resource issues.
∙Analyse AWR and ASH reports, SQL execution plans, and database wait
events to resolve performance problems.
∙Configure and manage RMAN backups; perform recovery and restore
validation.
∙Administer Oracle RAC, ASM, Grid Infrastructure, and Data Guard
environments.
∙Perform database patching, upgrades, migrations, and refreshes through
approved change procedures.
∙Manage database users, roles, privileges, auditing, and security controls.
∙Execute disaster recovery drills, Data Guard switchovers, and failovers.
∙Automate routine administration and monitoring using shell scripts and SQL.
Oracle Applications DBA
∙Administer Oracle E-Business Suite R12.2 application and database tiers.
∙Monitor and troubleshoot concurrent managers, concurrent requests,
Workflow Mailer, application services, and login issues.
∙Perform EBS online patching using ADOP and manage the associated
patching lifecycle.
∙Clone and refresh EBS environments using supported tools, including Rapid
Clone.
∙Maintain application configuration using AutoConfig and context files.
∙Administer EBS-related WebLogic Server, Oracle HTTP Server, and Forms
services.
∙Troubleshoot application-tier performance and coordinate with functional
and development teams.
∙Support EBS upgrades, technology-stack patches, certificate renewals, and
integration-related incidents.
∙Maintain operational procedures for application startup, shutdown, backup,
recovery, and maintenance.
L2/L3 Support and Customer Operations
∙Own incidents and service requests within agreed SLAs.
∙Provide L2 troubleshooting and escalate complex issues with complete
diagnostic evidence.
∙Lead L3 investigation, root-cause analysis, and permanent corrective actions.
∙Support major incidents, communicate progress, and document recovery
actions.
∙Raise and manage Oracle Support service requests.
∙Prepare change plans, risk assessments, validation steps, and rollback
procedures.
∙Maintain runbooks, knowledge articles, configuration records, and shift
handovers.
∙Coordinate with customer teams and internal infrastructure, storage,
network, and application teams.
∙Mentor junior DBAs and identify opportunities to reduce recurring incidents.
Required Skills and Experience
∙Hands-on production experience administering Oracle Database, including
Oracle 10g, 11g, 12c, 18c and 19c.
∙Strong experience supporting Oracle EBS R12.2 as an Apps DBA.
∙Practical knowledge of RAC, ASM, Data Guard, RMAN, Data Pump, and
Hiring: Denodo Administrator
Location: Bangalore / pune / Hyderabad💼
Experience: 7+ Years
Key Skills:
- Denodo Administration & Data Virtualization
- Linux/Unix Administration
- SQL Performance Tuning
- Oracle / SQL Server / DB2
- LDAP / AD / Kerberos / SSO
- Shell Scripting / Python
- AWS / Azure
🔹 Experience in Denodo platform administration, production support, performance tuning, security, deployment, and environment management.
Position : SQL Database Developer
Experience : 10+ Years
Domain : Mutual Fund / Capital Markets
Location : Noida
Work Mode : Hybrid
Role Overview :
We are looking for a Senior SQL Developer with 10+ years of experience in SQL Server and T-SQL development, preferably with experience in the Mutual Fund / Capital Markets / Financial Services domain.
Mandatory Skills :
- SQL Server & T-SQL
- Stored Procedures, Functions, Triggers, Views & SQL Jobs
- Complex SQL Queries & Data Manipulation
- Query Performance Tuning & Optimization
- Indexing, Execution Plans & Partitioning
- Data Migration, Porting, Transformation & Validation
- Database Troubleshooting
- SQL Server Performance Monitoring
- Version Control / Git
- Database Security & Data Integrity
Domain Knowledge :
- Mutual Fund / Capital Markets experience preferred.
- Understanding of financial transactions, reporting, reconciliation, and business processes.
Key Responsibilities :
- Develop and optimize T-SQL queries, stored procedures, views, functions, and triggers.
- Perform query tuning, indexing, execution plan analysis, and performance optimization.
- Handle data migration, transformation, porting, validation, and reconciliation.
- Troubleshoot database and production/UAT issues.
- Ensure data accuracy, integrity, consistency, and security.
- Work with developers, BAs, QA teams, and business stakeholders.
- Independently own database development and optimization activities.
- Education: Bachelor's degree in Computer Science, IT, Engineering, or related field.







