Application Engineer II - PL/SQL

Job description

Application Engineer II **Location: Hyderabad, India** Are you a database engineering expert who thrives on solving complex technical challenges at a global scale At Swiss Re, we are on a mission to make the world more resilient and we need sharp, curious, and collaborative technologists to help us get there. If youre passionate about building robust, enterprise-grade database solutions and want your work to have real-world impact, this could be your next great move. About the Role As an Application Engineer at Swiss Re, you will be at the heart of delivering technology solutions that power our Life Health Reinsurance business. You will own the end-to-end technology delivery of products and manage the full application lifecycle from planning and design through to deployment and continuous improvement. Working alongside Engineering Leads and Product Owners, you will help shape the technical direction of critical business applications, collaborating with diverse global teams to deliver meaningful outcomes. This is a role where your technical depth meets strategic thinking and where your contributions will be felt across the entire organization. Key Responsibilities - **Design and implement** advanced Oracle SQL/PL-SQL solutions including complex queries, stored procedures, functions, triggers, and packages to support enterprise-grade applications - **Perform Oracle database administration** tasks including performance tuning, security configuration, and backup/recovery procedures to ensure high availability and data integrity - **Create, modify, and maintain** database objects such as tables, views, indexes, and constraints to support evolving application needs - **Optimize database performance** through query tuning, index optimization, and detailed execution plan analysis - **Develop and manage ETL processes** to extract, transform, and load data efficiently across various systems and pipelines - **Diagnose and resolve** database-related issues proactively, ensuring system stability, data integrity, and optimal performance - **Partner with application developers** , business analysts, and stakeholders to translate business data requirements into scalable and robust database solutions - **Conduct and participate in code reviews** to uphold database best practices, performance standards, and secure coding guidelines - **Implement and maintain database security controls** to safeguard sensitive and confidential information - **Document** database designs, development standards, and operational procedures in alignment with organizational guidelines - **Stay current** with the latest Oracle database features, tools, and industry trends, proactively recommending enhancements and improvements - **Engage across global, cross-functional teams** both internal and external bringing a collaborative and inclusive approach to every interaction About You You are a technically strong, pragmatic, and collaborative professional who thrives in complex, fast-paced environments. You bring a strategic mindset to technical challenges, are comfortable navigating ambiguity, and have a track record of delivering high-quality database solutions in agile, cross-functional teams. You communicate clearly, listen actively, and are energized by working with diverse teams across the globe. We are looking for candidates who meet these requirements: - **7+ years of hands-on Oracle SQL and PL/SQL experience** , with demonstrated expertise in building and maintaining enterprise-grade database solutions - **Strong Oracle database administration skills** , including performance tuning, security configuration, and backup/recovery procedures - **Proven experience designing and developing** complex database objects stored procedures, functions, triggers, and PL/SQL packages along with ETL process development and management - **Strong expertise in advanced Oracle database concepts** including Partitioning, Materialized Views, Sequences, and Synonyms for scalable and efficient data design - **Proficiency in SQL Performance Tuning** , including hands-on experience with SQL Trace, Explain Plan, Execution Plan Analysis, and SQL Tuning Advisor to identify bottlenecks and optimize query performance in high-volume systems - **Solid understanding of relational database concepts** , including normalization principles, data modeling techniques, and query optimization strategies - **Experience leveraging agentic development practices** and AI-assisted tools for query generation, code optimization, refactoring, and debugging improving productivity, consistency, and development speed - **Experience working in agile, cross-functional, and continuous delivery teams** , with the ability to plan, prioritize, and deliver across multiple products simultaneously These are additional nice to haves: - Familiarity with cloud-based database platforms or hybrid cloud environments - Experience with data pipeline tools and modern ETL/ELT frameworks - Exposure to the reinsurance or financial services industry and an understanding of business data requirements in that context - Strong documentation skills with experience writing technical specifications, development standards, and operational procedures **Our company has a hybrid work model where the expectation is that you will be in the office at least three days per week.** Disclaimer: This job posting has been aggregated from external source. Role details, content, and availability are subject to change. Applicants are advised to confirm the latest information directly on the company website before applying.