
PL/SQL Developer
- India
- Permanent
- Full-time
- Database Development & Maintenance
- Design, develop, and maintain complex PL/SQL procedures, functions, packages, triggers, and views.
- Optimize database performance and troubleshoot performance issues in existing applications.
- Implement database solutions that adhere to best practices for scalability, reliability, and security.
- Insurance Domain Expertise
- Collaborate with business analysts and Clients to gather requirements specific to insurance processes, such as claims processing, policy management, underwriting, and reinsurance.
- Develop data models and database solutions to support insurance-specific use cases.
- Data Management & Integration
- Design and implement ETL processes for data migration, integration, and reporting needs.
- Collaborate with data architects and other team members to ensure data integrity and accuracy across systems.
- Work with data from various sources, including policy management systems, claims systems, and reinsurance applications.
- Support & Maintenance
- Provide production support, resolve database-related issues, and ensure minimal downtime.
- Perform regular database monitoring, tuning, and maintenance to ensure system reliability.
- Collaboration & Documentation
- Work closely with cross-functional teams, including developers, QA engineers, and business stakeholders.
- Create and maintain comprehensive technical documentation for database designs, processes, and workflows.
- Experience: 4-6 years of hands-on experience in Oracle PL/SQL development, with a proven track record in complex database application development.
- Domain Expertise: Strong understanding of the insurance domain, including processes such as claims processing, policy lifecycle management, and reinsurance.
- Technical Skills:
- Proficient in PL/SQL programming, SQL tuning, and database optimization.
- Experience with data modeling, database design, and schema creation.
- Knowledge of Oracle database tools, utilities, and features (e.g., SQL*Loader, Partitioning).
- Familiarity with version control systems like Git.
- Problem-Solving: Strong analytical and troubleshooting skills, with the ability to identify and resolve complex database issues.
- Communication: Excellent verbal and written communication skills, with the ability to effectively collaborate with technical and non-technical stakeholders.
- Tools & Technologies: Experience with ETL tools, reporting tools (e.g., Tableau, Power BI), and CI/CD environments is a plus.
- Certifications: Oracle certifications (e.g., Oracle PL/SQL Developer Certified Associate) are an added advantage.
- Experience working in Agile or Scrum development environments.
- Knowledge of additional programming languages like Python or Java for integration purposes.
- Familiarity with cloud-based database solutions (e.g., Oracle Cloud, Snowflake) is desirable.