
LMKR
Remote Jobs
Enabling Integrated Innovative Solutions
2 Jobs
• Analyze the existing SQL Anywhere database schema, objects, dependencies, and data structures. • Convert proprietary SQL Anywhere functions, stored procedures, triggers, and queries into ANSI-compliant and PostgreSQL-compatible SQL. • Redesign and optimize database schemas to align with PostgreSQL best practices. • Develop, execute, and validate data migration scripts for large production datasets. • Ensure data integrity, accuracy, and consistency throughout and after migration. • Perform post-migration validation, reconciliation, and performance benchmarking. • Optimize indexing strategies and improve query execution performance in PostgreSQL. • Collaborate closely with application developers to integrate the migrated database with the existing application stack. • Troubleshoot migration issues and provide long-term database optimization recommendations.
• Identify and mitigate security risks across AI/ML systems, APIs, and application architectures. • Safeguard models against adversarial attacks, data poisoning, prompt injection, model inversion, and intellectual property theft. • Embed security best practices into CI/CD pipelines, peer reviews, and development workflows. • Perform manual and automated assessments for web, mobile, and backend applications. • Design and integrate AI-powered tools for static/dynamic analysis, dependency scanning, and anomaly detection. • Mentor developers and data scientists in secure coding and AI system hardening. • Support investigations and remediation of security incidents affecting AI systems or applications. • Help shape the roadmap for AI security initiatives and continuous improvement of security posture.