14 Aug
|
QuestW
|
Bengaluru
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
.Minimum Requirements
- :10–15 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
- .Robust 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
.
📌 Database Architect (Bengaluru)
🏢 QuestW
📍 Bengaluru