Database Administrator - Software Architect I

Role description

Job Title: Database Administrator (DBA) & SQL Developer

Hiring Location

Mumbai / Pune / Bangalore (Hybrid)

Experience Range

8+ Years

Job Summary

We are seeking an experienced Database Administrator (DBA) & SQL Developer with strong expertise in database administration, SQL development, data modeling, performance optimization, and large-scale data migration initiatives. The ideal candidate will be responsible for managing enterprise database environments, ensuring high availability and performance, supporting application development teams, and driving data migration and transformation activities across legacy and modern platforms.

This role requires a deep understanding of database architecture, relational data models, data integrity, database security, performance tuning, and migration methodologies. The candidate will collaborate closely with application architects, business analysts, infrastructure teams, and project stakeholders to design, implement, and support scalable database solutions across on-premises and cloud environments.

Must-Have Skills

Database Administration & Operations

8+ years of hands-on experience in Database Administration and SQL Development.

Strong experience installing, configuring, upgrading, patching, and maintaining enterprise database platforms.

Experience managing databases across Development, Testing, UAT, Production, Disaster Recovery, and Cloud environments.

Expertise in:

Database Monitoring and Health Checks

Capacity Planning

Performance Tuning

Incident and Problem Management

Hands-on experience with:

Backup and Recovery

Replication

Clustering

High Availability (HA)

Disaster Recovery (DR)

Ability to troubleshoot:

Deadlocks

Blocking Issues

Long-running Queries

Resource Bottlenecks

Production Database Incidents

Strong understanding of database operational processes including release support, deployment activities, CAB approvals, and production releases.

Willingness to participate in on-call production support.

Database Platforms

Strong hands-on experience with one or more of the following:

Microsoft SQL Server (2016/2019/2022)

MySQL

Experience with the following databases is an added advantage:

PostgreSQL

Oracle Database

IBM DB2

MongoDB

SQL Development & Database Engineering

Advanced expertise in T-SQL and/or PL-SQL development.

Hands-on experience developing and maintaining:

Stored Procedures

Functions

Views

Triggers

Database Objects

Strong expertise in:

Query Optimization

Execution Plan Analysis

Database Performance Tuning

Index Optimization

Experience designing and maintaining:

Schemas

Constraints

Foreign Keys

Indexes

Partitioning Strategies

Ability to develop data validation, auditing, and reconciliation processes.

Experience supporting application teams to optimize database interactions.

Data Modeling & Database Design

Strong understanding of:

Relational Database Concepts

Normalization and Denormalization

Database Design Principles

Logical and Physical Data Modeling

Ability to translate business requirements into scalable database designs.

Experience maintaining:

Enterprise Data Models

Metadata Repositories

Data Dictionaries

Database Documentation

Understanding of application data flows, dependencies, and cross-system relationships.

Data Migration & Transformation

Proven experience leading and supporting large-scale data migration initiatives.

Hands-on expertise in:

Source-to-Target Mapping

Data Profiling

Data Quality Assessment

Data Transformation

Data Conversion

Migration Planning

Cutover Management

Experience developing:

Migration Scripts

ETL Processes

Validation Frameworks

Strong experience in:

Data Reconciliation

Data Cleansing

Deduplication

Post-Migration Validation

Experience supporting:

Legacy System Modernization

Application Migration Programs

Cloud Migration Projects

Platform Consolidations

Cloud & Modern Data Platforms

Experience supporting database deployments in AWS Cloud environments.

Understanding of cloud-native database concepts and managed database services.

Ability to implement best practices related to:

Scalability

Resiliency

Automation

Operational Excellence

Security & Compliance

Strong experience implementing database security standards, including:

User Provisioning

Role-Based Access Control (RBAC)

Encryption

Auditing

Compliance Requirements

Understanding of security best practices for mission-critical production environments.

Application Integration

Experience supporting database integration with enterprise applications.

Hands-on experience with:

Entity Framework 6.4

ADO.NET

.NET Application Integration

Ability to collaborate with development teams and recommend database best practices.

Tools & Technologies

Hands-on experience with:

SQL Server Management Studio (SSMS)

Azure Data Studio

Git / Bitbucket

Jira / ServiceNow

CI/CD Pipelines

PowerShell or Shell Scripting

Database Monitoring and Performance Analysis Tools

Operational Excellence

Extensive experience supporting mission-critical production database environments.

Strong troubleshooting and analytical skills.

Experience working within ITIL-based operational environments.

Excellent communication and stakeholder management skills.

Good-to-Have Skills

Experience with AWS Database Services.

Exposure to PostgreSQL, Oracle, IBM DB2, or MongoDB administration.

Familiarity with enterprise application technologies such as:

ASP.NET

Angular

React

JavaScript

Experience with:

DevOps practices

Infrastructure as Code (IaC)

Database Automation

Exposure to cloud modernization and transformation initiatives.

Experience working on large-scale enterprise transformation programs.

Relevant certifications such as:

Microsoft SQL Server Certifications

Oracle Certifications

PostgreSQL Certifications

AWS Certifications

Azure Certifications

Key Responsibilities

Administer and maintain enterprise database environments across multiple platforms.

Monitor database health, performance, availability, and capacity.

Configure backup, recovery, replication, HA, and DR solutions.

Design, develop, and optimize SQL objects and database code.

Analyze execution plans and improve database performance.

Develop and maintain enterprise data models and database documentation.

Lead data migration, transformation, and modernization initiatives.

Perform data validation, reconciliation, and quality assurance activities.

Support cloud database deployments and modernization programs.

Collaborate with application teams to optimize database integrations.

Participate in production releases, incident management, and on-call support.

Ensure database security, compliance, and operational excellence.

Primary Skills

Database Administration, SQL Server, SQL Development, T-SQL, Database Design, Data Migration, Data Modeling, Database Performance Tuning, Relational Databases, Database Security

Secondary Skills

AWS Cloud Databases, PostgreSQL, Oracle, MySQL, MongoDB, ETL, Entity Framework 6.4, ADO.NET, PowerShell, CI/CD, DevOps, ITIL, Database Modernization

Skills

database management,relational database,cloud database,database security,database design,database administration,data migration,

About UST

UST is a global digital transformation solutions provider. For more than 20 years, UST has worked side by side with the world’s best companies to make a real impact through transformation. Powered by technology, inspired by people and led by purpose, UST partners with their clients from design to operation. With deep domain expertise and a future-proof philosophy, UST embeds innovation and agility into their clients’ organizations. With over 30,000 employees in 30 countries, UST builds for boundless impact - touching billions of lives in the process.