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,