11 Sep
|
Linkterra Dynamics
|
Bengaluru
11 Sep
Linkterra Dynamics
Bengaluru
REQUIRED QUALIFICATIONS
- 5 - 8 years of professional experience in database engineering, architecture, or administration
- Expert-level proficiency in MySQL / MariaDB including advanced query optimization, indexing strategies, partitioning, and replication
- Strong experience designing and implementing relational database schemas for complex, multi-tenant business applications
- Deep knowledge of database performance tuning: query execution plans, slow query analysis, connection pooling, and caching strategies
- Production experience with database migration, consolidation, and ETL processes across multiple systems
- Proficiency in writing complex SQL stored procedures, triggers, views, CTEs, and window functions
- Experience with database backup, recovery, disaster recovery planning, and high-availability configurations (master-slave replication, clustering)
- Working knowledge of Linux/UNIX server administration as it relates to database operations
- Familiarity with database security best practices: encryption at rest/in transit, access controls, audit logging, and compliance requirements
- Solid communication skills for collaborating with US-based stakeholders across time zones
KEY RESPONSIBILITIES
- Own the end-to-end database architecture across all Link platforms, including title production (SoftPro), lender portals, CRM systems, and internal operational tools
- Design and implement a unified data architecture strategy for consolidating databases from into a coherent, scalable structure
- Optimize database performance across production environments — proactively identify and resolve bottlenecks, slow queries, and resource contention issues
- Architect data models that support business growth, including new verticals (timeshare title services, GSE title waiver programs) and expanded state operations
- Lead database migration efforts for system consolidation projects, including SoftPro migration and legacy system retirement
- Build and maintain ETL pipelines for reporting, analytics, and executive dashboards that drive strategic decision-making
- Implement and enforce database security policies, access controls, and audit logging to meet regulatory and compliance requirements in the title insurance industry
- Establish and maintain backup, recovery, and disaster recovery procedures ensuring zero data loss and minimal downtime
- Collaborate closely with the Senior PHP Developer and engineering team to optimize application-database interactions, query patterns, and data access layers
- Define database standards, documentation, naming conventions, and best practices for the engineering team
- Monitor production database health, set up alerting, and implement proactive maintenance schedules
📌 Database Engineer (Bengaluru)
🏢 Linkterra Dynamics
📍 Bengaluru