Apply

PLSQL Developer

Posted 2024-10-25

View full description

💎 Seniority level: Senior, 5-10 years

📍 Location: India

🏢 Company: ProArch

🗣️ Languages: English

⏳ Experience: 5-10 years

🪄 Skills: SQLData AnalysisETLGitJavaOracleBusiness OperationsData analysis

Requirements:
  • Bachelor's degree in Computer Science, Information Technology, or a related field.
  • 5-10 years of hands-on experience in Advanced PLSQL development and Data Migration.
  • Proficient in writing complex queries, procedures, and functions using PLSQL.
  • Strong understanding of database design, normalization, and performance tuning.
  • Experience with stored procedures, triggers, and views.
  • Familiarity with data modeling concepts and ETL processes.
  • Experience with database tools and utilities (e.g., SQL Developer, Toad).
  • Strong analytical and problem-solving skills.
  • Excellent communication and interpersonal abilities.
  • Ability to work independently and in a team-oriented environment.
  • Knowledge of version control systems (e.g., Git) is a plus.
Responsibilities:
  • Develop, test, and maintain Advanced PLSQL stored procedures, functions, and triggers to support business applications.
  • Design and implement database structures/Data Migration that support business requirements.
  • Collaborate with cross-functional teams to gather requirements and translate them into technical specifications.
  • Perform data analysis and optimization to enhance query performance and system efficiency.
  • Conduct troubleshooting and debugging of PLSQL code and database issues.
  • Participate in code reviews to ensure adherence to best practices and quality standards.
  • Maintain documentation related to database design, processes, and procedures.
  • Stay updated with Oracle database upgrades and new features.
  • Support daily business operations related to systems and run manual tests for exceptions.
Apply