Description

Key Responsibilities

• Design, develop, test, and maintain Oracle database solutions and SQL-based applications.
• Develop complex SQL queries, stored procedures, functions, packages, triggers, and views using PL/SQL.
• Analyze business and technical requirements and translate them into scalable database solutions.
• Design and maintain database schemas, tables, indexes, constraints, partitions, and data models.
• Perform SQL query optimization, execution-plan analysis, indexing, and database performance tuning.
• Develop and maintain data migration, transformation, and integration processes.
• Build and support ETL processes using SQL, PL/SQL, and relevant integration tools.
• Work with application teams to troubleshoot database-related issues and improve application performance.
• Perform root-cause analysis for production incidents and implement long-term corrective actions.
• Develop scripts for data validation, reconciliation, cleansing, and reporting.
• Participate in database upgrades, patching, migrations, and environment refresh activities.
• Implement database security controls, including roles, privileges, access policies, and sensitive-data protection.
• Ensure data integrity, availability, scalability, and compliance with organizational standards.
• Conduct peer reviews of SQL and PL/SQL code and promote development best practices.
• Create and maintain technical documentation, data dictionaries, process documents, and support procedures.
• Support unit testing, integration testing, performance testing, and user acceptance testing.
• Collaborate with DevOps and infrastructure teams to support CI/CD and automated database deployments.
• Mentor junior developers and provide technical guidance to the development team.
• Participate in Agile ceremonies, estimation sessions, design reviews, and release planning.

Required Qualifications

• Bachelor’s degree in Computer Science, Information Technology, Engineering, or a related field.
• 8+ years of experience in Oracle database development and SQL programming.
• Strong hands-on experience with Oracle SQL and PL/SQL.
• Proven experience developing:
  • Stored procedures
  • Functions
  • Packages
  • Triggers
  • Views
  • Materialized views
  • Cursors
  • Dynamic SQL
• Strong understanding of relational database concepts, normalization, data modeling, and database design.
• Experience with Oracle performance tuning, including:
  • Explain plans
  • Index optimization
  • Query rewrites
  • Table partitioning
  • Statistics management
  • SQL profiling
• Experience with database development lifecycle, version control, deployment, and release management.
• Strong knowledge of joins, subqueries, analytical functions, common table expressions, aggregations, and set-based processing.
• Experience with data migration, ETL, data validation, and reconciliation processes.
• Experience troubleshooting database issues in development, testing, and production environments

Key Skills

Education

Any Graduate