Company Overview

Aegan Global is a leader in Human Resources, offering flexible staffing solutions that allow businesses to benefit from specialized expertise without traditional employment costs. With a supply of trained professionals from IT programs, we provide short-term and permanent hiring options for critical project resources. Aegan Global is headquartered in Bangalore, serving the Human Resources Services industry with a workforce of 201-500 employees. Learn more at http://www.aegan-global.com.

Job Overview

We are seeking a Sr Software Engineer with expertise in PL/SQL for a mid-level position. The role is based in Pune Division, Pune, Mumbai, and Bangalore, offering a full-time employment opportunity. The ideal candidate will leverage their skills in SQL development and PL/SQL packages to deliver high-quality solutions.

Qualifications and Skills

• Strong proficiency in SQL Development (Mandatory skill) to efficiently manage and manipulate database systems.
• Expertise in PL/SQL Packages , Ansi SQL (Mandatory skill) to design and implement high-performance database solutions.
• Experience with Database Design to architect data storage solutions that meet business requirements.
• Ability to write and optimize Stored Procedures to perform data operations effectively and efficiently.
• Skill in Query Optimization to enhance database performance by refining and restructuring queries.
• Knowledge in Data Modeling to create representations of complex data structures for better database organization.
• Proficiency in Error Handling to identify and resolve database issues, ensuring minimal downtime and data integrity.
• Understanding of Performance Tuning to adjust and improve database and application performance metrics.

Roles and Responsibilities

• Design and develop complex PL/SQL packages and database applications in line with project requirements.
• Optimize SQL queries to enhance the performance and efficiency of database operations.
• Work closely with project stakeholders to understand and translate business needs into technical solutions.
• Ensure data integrity and security through effective database design and maintenance practices.
• Collaborate with cross-functional teams to identify and resolve software and database issues.
• Provide technical expertise and guidance to junior engineers and other team members.
• Maintain and update technical documentation to support database applications and processes.
• Continuously evaluate and implement new database technologies to improve performance and scalability.