Oracle PL/SQL Developer

Job Description:

• We are seeking a skilled Oracle PL/SQL Developer with hands-on experience in PL/SQL coding, table creation, performance tuning, and some DBA administrative tasks.
• The ideal candidate will focus primarily (80%) on PL/SQL development, query optimization, and database performance tuning, with secondary (20%) responsibilities related to DBA administration tasks such as user management and basic database maintenance.

Key Responsibilities:

• PL/SQL Development (80%)
• Develop, optimize, and maintain PL/SQL stored procedures, triggers, functions, and packages.
• Design and implement database tables, indexes, constraints, and relationships based on business requirements.
• Write complex SQL queries and optimize query performance for large datasets.
• Collaborate with application developers to design efficient database structures and schemas.
• Analyze, troubleshoot, and resolve database-related performance issues.
• Implement best practices for SQL coding, query optimization, and indexing.
• Conduct code reviews to ensure database standards and performance guidelines are met.
• Database Administration (20%)
• Perform basic DBA tasks, including user access control, privileges management, and database security.
• Assist in database backup and recovery strategies.
• Monitor database performance, resource utilization, and storage management.
• Support database tuning, partitioning, and indexing strategies for improved performance.
• Work closely with DBA teams for database upgrades, patches, and maintenance activities.

Required Skills & Qualifications:

• 5+ years of experience in Oracle PL/SQL development.
• Strong expertise in writing and optimizing PL/SQL procedures, functions, and triggers.
• Experience with SQL query performance tuning and execution plan analysis.
• Knowledge of database design principles, indexing strategies, and normalization techniques.
• Basic experience in Oracle DBA tasks such as user management, storage management, and backup/recovery.
• Hands-on experience with Oracle versions (12c, 19c, or newer).
• Familiarity with Oracle Enterprise Manager (OEM) and database monitoring tools.
• Strong problem-solving and debugging skills.
• Ability to work independently and collaborate with development and DBA teams.