Senior Software Engineer - Database(PL/SQL) (PL

Job Summary

We are seeking an experienced Database Developer with strong expertise in Relational Database Management Systems (RDBMS), particularly Oracle writing complex stored procedures, triggers, and functions. You will work closely with cross-functional teams to design, develop, optimize, and maintain scalable and efficient database solutions.

Key Responsibilities

• Design, develop, and implement database structures and solutions for high-performance data processing and reporting.
• Work with Oracle RDBMS to write and optimize complex SQL queries, stored procedures, triggers, and functions.
• Basic knowledge on Talend to ensure efficient data integration, transformation, and loading.
• Collaborate with data architects and business stakeholders to translate requirements into technical solutions.
• Design, implement, and maintain complex database structures, ensuring consistency, reliability, and high availability.
• Troubleshoot database issues, including performance, security, and availability, and take necessary corrective actions.
• Perform database tuning to optimize the performance of queries, indexes, and system resources.
• Maintain data integrity and support data security protocols in line with industry best practices.
• Develop and manage database migration strategies, ensuring smooth data transitions between systems.
• Document and standardize coding practices, procedures, and database workflows.
• Monitor database system performance and create reports for operational monitoring and optimization.
• Collaborate with software development teams to ensure that database solutions align with application architecture and system requirements.
  
  

Skills and Qualifications:

• 6 years of hands-on experience working with RDBMS such as Oracle.
• Proficient in writing and optimizing SQL queries, stored procedures, triggers, and functions in Oracle.
• Strong experience in database design, including normalization, indexing, and partitioning for performance optimization.
• Experience with Oracle PL/SQL and database tuning to improve query performance.
• Familiarity with database replication, data migrations, and backup and recovery strategies.
• Understanding of data security protocols and compliance standards (e.g., GDPR, HIPAA).
• Ability to troubleshoot complex database issues related to performance, integrity, and security.
• Strong analytical and problem-solving skills, with the ability to handle complex data challenges.
• Excellent communication skills and the ability to work well with both technical and non-technical teams.
• Familiarity with database administration concepts and monitoring tools.
  
  

Must Have

• End to end Web Analytics Implementation project activation
• Defining the Technical Implementation and Data layer Architecture during tag implementation
• Integrating other solutions like Consent Management (OneTrust), Observepoint, ETL tools (Alteryx) with the Google Analytics Platform
• Gathering the technical requirements from the client and creating the documentation like SDR, Tech Spec, MRD
• Ability to plan and implement methods to measure experiences, including Tag Management Solutions like Tealium iQ (primarily), Adobe Launch, Adobe Analytics, Dynamic Tag Manager, Ensighten, Google Tag Manager
• Understand and use multitude of tag managers and writing JavaScript code to realize client driven business requirements
• Responsible for site optimization with an ability to solution design and implement the analytics strategy and technology needed to gain and stitch together insights into both online and physical location activity
• Experienced in Marketing Performance analysis i.e. data aggregation (leveraging marketing & click-stream APIs, data cleaning & transformation), analysis & segmentation, targeting & integration
• Experienced in A/B testing, MVT/Optimization framework(s) using tools like Adobe Target
• Develop the strategy of enterprise level solutions as well as architecting extensible and maintainable solutions utilizing the Adobe and Google analytics platforms
• Excellent understanding of digital analytics specially Clickstream Data
• Ability to create data visualization dashboards specially on Workspace, Data Studio, MS Excel and Adobe Report builder
• Agile method understanding
  
  

About you:

Analytics Platforms - Google Analytics, Adobe Analytics/Omniture SiteCatalyst, Matomo/Piwik

Tag Managers Adobe Launch/DTM, Tealium IQ, Google Tag Manager, Piwik Pro, Signal/Bright Tag

Optimization Platform Adobe Target, Google Optimize, Optimizely

1 years in a client facing role for solutioning and / or evangelizing technology approaches.

Programming Languages - JavaScript, jQuery

Markup Languages - HTML, CSS

Good to have EQUAL OPPORTUNITY

Indegene is proud to be an Equal Employment Employer and is committed to the culture of Inclusion and Diversity. We do not discriminate on the basis of race, religion, sex, colour, age, national origin, pregnancy, sexual orientation, physical ability, or any other characteristics. All employment decisions, from hiring to separation, will be based on business requirements, the candidates merit and qualification. We are an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, colour, religion, sex, national origin, gender identity, sexual orientation, disability status, protected veteran status, or any other characteristics.

Locations - Bangalore, KA, IN