Principal Database Engineer- Architecture/Engineering

Solera Corporation; Hyderabad; On-site; INR 3,500,000 - 6,500,000; Full time

Job summary

Solera is a global leader in data and software services transforming every touchpoint of the vehicle lifecycle into a connected digital experience. The Database Architect will design, implement, and maintain high-performance, scalable database solutions across on-premises, cloud, and hybrid environments.

Ideal candidates have 8+ years of architecture and design experience, strong tuning skills, and proficiency across relational, NoSQL, and cloud data warehouses.

Qualifications

• 8+ years of experience in database architecture and design.
• Strong performance tuning and optimization skills.
• Proficiency in multiple database platforms (relational, NoSQL, cloud-based).
• Experience with data warehousing, big data, and emerging technologies.
• Strong communication and collaboration skills.
• Relevant certifications (e.g., Microsoft Certified: Azure Database Administrator, Oracle Certified Professional).
• Experience with Agile methodologies and DevOps practices.
• Bachelor's degree in Computer Science or related field.

Responsibilities

• Design, implement, and maintain database architectures for OLTP and analytics workloads.
• Develop data models, database designs, and data flow diagrams.
• Collaborate with application teams to ensure database designs meet business requirements.
• Establish and enforce database design standards and best practices.
• Analyze and optimize database performance using various tools and techniques.
• Identify and resolve performance bottlenecks in RDBMS, NoSQL, and DW solutions.
• Collaborate with cross-functional teams and communicate technical concepts to stakeholders.
• Design, implement, and maintain data warehouse solutions (e.g., Snowflake/Redshift/Synapse) and data lake integrations.

Skills

Database architecture

Performance tuning

Data modeling

Relational & NoSQL

Cloud data warehousing

Big data technologies

DevOps practices

Communication skills

Education

Bachelor's degree in Computer Science or related field

Microsoft Certified: Azure Database Administrator

Oracle Certified Professional

Job description

Who we are Solera is a global leader in data and software services that strives to transform every touchpoint of the vehicle lifecycle into a connected digital experience. In addition, we provide products and services to protect life’s other most important assets: our homes and digital identities. Today, Solera processes over 300 million digital transactions annually for approximately 235,000 partners and customers in more than 90 countries. Our 6,500 team members foster an uncommon, innovative culture and are dedicated to successfully bringing the future to bear today through cognitive answers, insights, algorithms and automation. For more information, please visit solera.com.

The Role

Database Architect to design, implement, and maintain high-performance, scalable database solutions across multiple platforms, including on-premises, cloud, and hybrid environments. The ideal candidate will have a strong background in database architecture, performance tuning, and data modeling, with expertise in multiple database platforms, including relational databases (MSSQL, Oracle, MySQL, Postgres), NoSQL databases (MongoDB, Cosmos DB), and cloud-based data warehouses (Google Snowflake, AWS Redshift, Azure Synapse Analytics).

Responsibilities

• Database Architecture and Design: Design, implement, and maintain database architectures for OLTP and analytics workloads Develop data models, database designs, and data flow diagrams Collaborate with application teams to ensure database designs meet business requirements Establish and enforce database design standards and best practices
• Performance Tuning and Optimization: Analyze and optimize database performance using various tools and techniques (e.g., query optimization, indexing strategies, database parameter configuration) Identify and resolve performance bottlenecks and issues in RDBMS (MSSQL, Oracle,Postgres,MySQL) , NOSQL (MongoDB,CosmosDB) and DW solutions Develop and implement performance monitoring and alerting solutions
• Coding Standards and Best Practices: Develop and enforce coding standards for T-SQL, PL/SQL, MySQL, Postgres, and NoSQL databases Establish and enforce database design standards and best practices Collaborate with development teams to ensure coding standards are met
• Collaboration and Communication: Collaborate with cross-functional teams (e.g., Operations, application development, data science, IT operations) Communicate technical concepts and ideas to non-technical stakeholders Participate in industry events and conferences to stay current with industry trends and best practices
• Data Warehousing and Big Data: Design, implement, and maintain data warehouse solutions (e.g., Google Snowflake, AWS Redshift, Azure Synapse Analytics) Develop and implement data lake solutions (e.g., Hadoop, AWS S3, Azure Data Lake) Integrate with big data technologies (e.g., Spark, Hadoop)
• NoSQL and Emerging Technologies: Design for optimization, architect partition scheme for scalability, implement, and maintain NoSQL database solutions (e.g., MongoDB, Cosmos DB, Cassandra) Evaluate and implement emerging technologies (e.g., graph databases, time-series databases)
• Architect Cloud and Hybrid Database Solutions: Design, implement cloud-based database solutions (e.g., AWS RDS, Azure SQL Database, Google Cloud SQL) Leverage cloud-native features and services (e.g., AWS DMS, Azure Data Factory) Design and implement hybrid database solutions (e.g., on-premises to cloud, cloud to cloud)

Requirements

• 8+ years of experience in database architecture and design
• Strong performance tuning and optimization skills
• Proficiency in multiple database platforms (relational, NoSQL, cloud-based)
• Experience with data warehousing, big data, and emerging technologies
• Strong communication and collaboration skills
• Relevant certifications (e.g., Microsoft Certified: Azure Database Administrator, Oracle Certified Professional)
• Experience with Agile methodologies and DevOps practices
• Bachelor's degree in Computer Science or related field

Nice to Have

• Experience with ML models, AI, and LLM models
• Experience with cloud-native services (e.g., AWS Lambda, Azure Functions)
• Experience with monitoring tools (e.g., Datadog)

Solera is the global leader in vehicle lifecycle management software-as-a-service, data, and services. Through four lines of business – vehicle claims, vehicle repairs, vehicle solutions and fleet solutions – Solera is home to many leading brands in the vehicle lifecycle ecosystem, including Identifix, Audatex, DealerSocket, Omnitracs, LoJack, Spireon, eDriving/Mentor, Explore, CAP HPI, Autodata, and others. Solera empowers its customers to succeed in the digital age by providing them with a “one-stop shop” solution that streamlines operations, offers data-driven analytics, and enhances customer engagement, which Solera believes helps customers drive sales, promote customer retention, and improve profit margins. Solera serves over 300,000 global customers and partners in 100+ countries. For more information, visit www.solera.com.