SQL developer

Role & responsibilities

Key Responsibilities:

• Design, develop, and maintain complex SQL queries, stored procedures, functions, and triggers in Oracle.
  
• Optimize database schemas for performance, scalability, and reliability.
  
• Perform stored procedure migration and refactoring from legacy systems.
  
• Conduct database performance tuning and troubleshooting.
  
• Collaborate with Java development teams to ensure data layer compatibility and efficiency.
  
• Support database modernization initiatives, including data migration and transformation.
  
• Assist in defining and validating database backup and replication strategies.
  
• Ensure compliance with best practices in security, performance, and data integrity.
  
• Maintain comprehensive documentation of all database work.
  

Required Skills:

• Strong experience in

  Oracle SQL

  ,

  PL/SQL

  development
• Experience with

  schema optimization

  ,

  query performance tuning

  , and

  stored procedure development

• Familiarity with

  Sybase ASE/IQ

  is a plus
• Solid understanding of

  data replication

  and

  backup strategies

• Ability to work closely with

  Java development teams

  for data layer integration
• Experience in supporting

  database modernization

  and

  migration projects

• Good knowledge of

  database security

  ,

  indexes

  , and

  execution plans

• Strong analytical and problem-solving skills
  
• Excellent communication and collaboration abilities