Job Search
We can help you build an exceptional career
PL/SQL Developer IRC247655
| Job: | IRC247655 |
| Location: | India - Bangalore |
| Designation: | Associate Consultant |
| Experience: | 5-10 years |
| Function: | Engineering |
| Skills: | Database and System Analyst / MS SQL Server developer / Knowledge of Database Administraton, MySQL, PL/SQL, SQL |
| Work Model: | Hybrid |
Description:
6-8 years of experience in PL/SQL development and database administration.
Experience working with large-scale, high-volume databases is a plus.
Required Skills:
PL/SQL: Strong experience in PL/SQL development, including writing stored procedures, functions, triggers, and packages.
MSSQL/SQL: Advanced knowledge of SQL for querying, data manipulation, and optimization.
Database Design: Proficient in designing relational databases, understanding normalization, and implementing ER models.
Performance Tuning: Expertise in identifying slow-running queries and optimizing them for performance.
Version Control: Familiarity with version control systems like Git for managing database code changes.
Debugging: Strong debugging skills in a database context to identify and resolve issues.
Communication Skills: Excellent written and verbal communication skills for documentation and collaboration with team members.
Preferred Skills:
PL/SQL Tools: Experience with tools like SQL Developer, TOAD, or similar database development tools.
Data Warehousing: Knowledge of data warehousing concepts and tools.
Scripting Languages: Knowledge of scripting languages like Shell, Python, or JavaScript for automation and data management.
Agile Methodology: Familiarity with Agile/Scrum development practices.
Requirements:
6-8 years of experience in PL/SQL development and database administration.
Experience working with large-scale, high-volume databases is a plus.
Required Skills:
PL/SQL: Strong experience in PL/SQL development, including writing stored procedures, functions, triggers, and packages.
MSSQL/SQL: Advanced knowledge of SQL for querying, data manipulation, and optimization.
Database Design: Proficient in designing relational databases, understanding normalization, and implementing ER models.
Performance Tuning: Expertise in identifying slow-running queries and optimizing them for performance.
Version Control: Familiarity with version control systems like Git for managing database code changes.
Debugging: Strong debugging skills in a database context to identify and resolve issues.
Communication Skills: Excellent written and verbal communication skills for documentation and collaboration with team members.
Preferred Skills:
PL/SQL Tools: Experience with tools like SQL Developer, TOAD, or similar database development tools.
Data Warehousing: Knowledge of data warehousing concepts and tools.
Scripting Languages: Knowledge of scripting languages like Shell, Python, or JavaScript for automation and data management.
Agile Methodology: Familiarity with Agile/Scrum development practices.
Job Responsibilities:
Design, develop, and implement PL/SQL solutions for data processing, extraction, transformation, and loading (ETL).
Write and optimize SQL queries, stored procedures, functions, and triggers to support application features and performance enhancements.
Analyze and optimize database performance, including identifying and resolving performance bottlenecks.
Create and manage complex data models, database schemas, and relationships.
Work with application developers to integrate backend solutions with front-end applications and ensure smooth data flow.
Develop automated test cases, conduct unit testing, and ensure quality of the database code.
Assist in troubleshooting, debugging, and resolving issues with databases and applications.
Document technical designs, processes, and solutions in a clear and concise manner.
Work in an Agile environment, attending daily stand-ups, sprint planning, and retrospectives.
Ensure database security, integrity, and compliance with best practices.
Stay updated with new developments in database technologies and PL/SQL best practices.
What We Offer
Exciting Projects: We focus on industries like High-Tech, communication, media, healthcare, retail and telecom. Our customer list is full of fantastic global brands and leaders who love what we build for them.
Collaborative Environment: You Can expand your skills by collaborating with a diverse team of highly talented people in an open, laidback environment — or even abroad in one of our global centers or client facilities!
Work-Life Balance: GlobalLogic prioritizes work-life balance, which is why we offer flexible work schedules, opportunities to work from home, and paid time off and holidays.
Professional Development: Our dedicated Learning & Development team regularly organizes Communication skills training(GL Vantage, Toast Master),Stress Management program, professional certifications, and technical and soft skill trainings.
Excellent Benefits: We provide our employees with competitive salaries, family medical insurance, Group Term Life Insurance, Group Personal Accident Insurance , NPS(National Pension Scheme ), Periodic health awareness program, extended maternity leave, annual performance bonuses, and referral bonuses.
Fun Perks: We want you to love where you work, which is why we host sports events, cultural activities, offer food on subsidies rates, Corporate parties. Our vibrant offices also include dedicated GL Zones, rooftop decks and GL Club where you can drink coffee or tea with your colleagues over a game of table and offer discounts for popular stores and restaurants!