Description

  • Design, develop, implement, and maintain database solutions using Oracle technologies.
  • Create logical and physical data models; translate business requirements into schema designs.
  • Develop, optimize, and maintain PL/SQL procedures, functions, packages, and triggers.
  • Write and tune complex SQL queries for data retrieval, manipulation, and reporting.
  • Perform query tuning and overall database performance optimization.
  • Troubleshoot and resolve database-related performance issues.
  • Implement and manage indexing strategies and partitioning techniques.
  • Ensure data integrity, security, and compliance with industry best practices.
  • Develop and implement backup and recovery plans and procedures.
  • Manage database security, user roles, and access controls.
  • Collaborate with application developers, DBAs, and stakeholders for seamless integration.
  • Provide technical and functional support for Oracle-based applications and systems.
  • Participate in code reviews, system testing, and deployment activities.
  • Develop and maintain automation scripts (e.g., Unix Shell, Python) for data processing.
  • Create and maintain technical documentation for database designs and procedures.
  • Utilize strong problem-solving and analytical skills in daily responsibilities.
  • Communicate effectively and work collaboratively with team members.
  • Apply knowledge of Oracle database versions (e.g., 12c, 19c), data modeling, and security.
  • Bachelor’s degree in Computer Science, Information Systems, or related field required

Education

Bachelor's degree