Application Database Designer

Design, implement, and optimize database architectures that support software applications.

Translate business requirements into logical and physical data models by defining tables, relationships, constraints, and indexes to ensure performance, scalability, and data integrity.

Collaborate with software engineers to integrate databases into application workflows, resolve performance issues, and implement security controls to protect persistent data..

Roles and responsibilities:

· Candidate should have strong experience in data modelling, schema design, normalization, indexing, and query optimization across databases such as PostgreSQL, MSSQL, Oracle, and Redis.

· You will collaborate with solution architect, DBAs, developers, and business analysts to translate business requirements into efficient, scalable, and maintainable database structures.

· The Application Database designer will be proficient in RDBMS and will create logical and physical DDL for all system enhancements.

· Hands-on experience with ETL processes, data integration (webMethods) and database performance tuning is highly desirable.

· Strong analytical, problem-solving, and communication skills are essential to ensure data integrity, consistency, and optimal performance of enterprise database systems.

· Support database migration and modernization initiatives from on-premise to cloud platforms

· Collaborate with development, DevOps, and infrastructure teams to support database architecture, scalability, and integration in cloud or hybrid environments

· Enforce database governance, security hardening, access control, encryption, and auditing.

· Support presales, readiness assessments, and architectural discussions by providing expert input on database modernization strategies.

· Undertake data migration from legacy system database to new Database by architecting the migration plan, preparing migration strategies, preparing migration scripts, executing scripts and successfully migration the data.