GlobalLogic is seeking a talented PL/SQL Developer with 6-8 years of experience in PL/SQL development and database administration to join our dynamic team. The ideal candidate will be a problem-solver with a passion for database design, performance tuning, and crafting innovative solutions for high-volume databases.
Key Responsibilities
- Design, develop, and implement robust PL/SQL solutions for data processing, extraction, transformation, and loading (ETL).
- Write and optimize SQL queries, stored procedures, functions, and triggers to enhance application performance.
- Analyze and resolve database performance bottlenecks through tuning and optimization techniques.
- Create and manage complex data models, database schemas, and relationships to support system integrity.
- Collaborate with application developers to integrate backend solutions with front-end applications seamlessly.
- Develop automated test cases and conduct unit testing to ensure database code quality.
- Troubleshoot and debug database issues, ensuring smooth application functionality.
- Document technical designs, processes, and solutions for internal and external use.
- Participate in Agile workflows, including sprint planning, daily stand-ups, and retrospectives.
- Ensure database security, integrity, and compliance with industry best practices.
- Stay updated on the latest developments in database technologies and PL/SQL trends.
Required Skills
- PL/SQL Development. Extensive experience in writing stored procedures, functions, triggers, and packages.
- MSSQL/SQL Expertise. Advanced SQL skills for querying, data manipulation, and performance optimization.
- Database Design. Strong knowledge of relational database design, normalization, and ER modeling.
- Performance Tuning. Proven expertise in diagnosing and resolving slow-running queries.
- Version Control. Familiarity with tools like Git for managing database code changes.
- Debugging Skills. Ability to identify and resolve issues within a database context.
- Communication. Excellent written and verbal communication skills for collaboration and documentation.
Preferred Skills
- Experience with PL/SQL tools such as SQL Developer or TOAD.
- Knowledge of data warehousing concepts and tools.
- Familiarity with scripting languages like Shell, Python, or JavaScript for automation.
- Understanding of Agile/Scrum development practices.
What We Offer
Exciting Projects
Be part of cutting-edge industries such as High-Tech, Media, Healthcare, Retail, and Telecom. Collaborate with global brands and leaders to deliver impactful solutions.
Collaborative Environment
Work with a diverse team of highly talented individuals in an open and supportive environment, with opportunities to travel or work abroad.
About GlobalLogic
GlobalLogic is a leader in digital engineering, transforming businesses across industries like automotive, financial services, healthcare, and more. As a part of the Hitachi Group, we integrate design, engineering, and data expertise to create a sustainable society and drive innovation through technology.