Database Technical Architect

questW; Bengaluru; On-site; INR 3,000,000 - 5,500,000; Full time

Job summary

questW is seeking an experienced Database Solutions Architect to join our ITS team. The Application Database & Middleware Architect will establish and govern database and database-facing middleware architecture across the manufacturing application portfolio, including MES, Test Solutions, Scheduling and Simulation, AI/ML, and other plant applications.

You will lead architecture decisions, optimize performance and mentor engineers, with 9–17 years of relevant experience and deep expertise in

Qualifications

• 9–17 years of experience in database engineering, application architecture or database performance engineering

Responsibilities

• Define and govern database and database-middleware architecture across MES, Test Solutions, Scheduling and Simulation, AI/ML and other manufacturing applications
• Establish standards for data modelling, schema design, SQL development, indexing, partitioning, transaction management and data retention
• Provide technical leadership across Oracle, Microsoft SQL Server, PostgreSQL and Sybase
• Lead application and database performance optimization, including query tuning and locking
• Define resilient patterns for connection pooling, retries, failover and data synchronization
• Review designs for new applications, major releases, integrations and multi-site deployments
• Drive database modernization, platform migrations and legacy-system rationalization
• Establish monitoring and observability across applications, middleware and databases
• Act as L3 technical authority for major incidents and root-cause analysis
• Develop reusable architecture patterns, runbooks and troubleshooting guides
• Mentor database engineers and analysts

Education

Bachelor’s or Master’s degree in Computer Science, Information Technology, Engineering or a related discipline

Tools

Oracle

SQL Server

PostgreSQL

Sybase

Job description

Our client is looking for an experienced Database Solutions Architect to join their ITS team. The Application Database & Middleware Architect will establish and govern database and database-facing middleware architecture across the manufacturing application portfolio, including MES, Test Solutions, Scheduling and Simulation, AI/ML, and other plant applications.

Responsibilities include

• Define and govern database and database-middleware architecture across MES, Test Solutions, Scheduling and Simulation, AI/ML and other manufacturing applications
• Establish standards for data modelling, schema design, SQL development, indexing, partitioning, transaction management and data retention
• Deep expertise in at least two of Oracle, SQL Server, PostgreSQL and Sybase
• Provide technical leadership across Oracle, Microsoft SQL Server, PostgreSQL and Sybase
• Lead application and database performance optimization, including query tuning, execution-plan analysis, locking, deadlocks and connection management
• Define resilient application patterns for connection pooling, retries, failover, replication, change data capture and data synchronization
• Review database designs for new applications, major releases, integrations and multi-site deployments
• Drive database modernization, platform migrations, legacy-system rationalization and adoption of appropriate modern database technologies
• Establish monitoring and observability across applications, middleware and databases
• Act as L3 technical authority for major incidents, root-cause analysis, problem management and permanent corrective actions
• Develop reusable architecture patterns, deployment checklists, runbooks and troubleshooting guides for Site Teams
• Mentor database engineers and analysts and build cross-platform capability within the team
• 9 –17 years of experience in database engineering, application architecture or database performance engineering, including experience in a technical lead or architect role
• Strong expertise in at least two of Oracle, SQL Server, PostgreSQL and Sybase, with working knowledge across the remaining platforms
• Advanced knowledge of SQL tuning, execution plans, indexing, stored procedures, transactions, locking and concurrency management
• Experience with JDBC/ODBC, connection pools, database proxies, replication, CDC and application integration technologies
• Strong understanding of database availability, scalability, security, performance and application-side failover patterns
• Experience with database migrations, legacy modernization, automation and controlled database deployments
• Experience supporting high-volume, business-critical and 24x7 production applications
• Strong incident-management, root-cause analysis and structured problem-solving capabilities
• Ability to work effectively across Platform Teams, Site Teams, Infrastructure Operations, cybersecurity and external vendors
• Experience in semiconductor manufacturing, MES, equipment integration, scheduling or manufacturing applications is preferred
• Working knowledge of ITIL incident, problem, change, availability and capacity-management practices
• Bachelor’s or master’s degree in Computer Science, Information Technology, Engineering or a related discipline