Position:
SQL/PLSQL Developer
No of Positions:
6
Qualification:
Any Graduate / Post Graduate
Experience:
Fresher / Experience
Location:
Chennai,Bangolore
Country:
India
Request A SQL/PLSQL Developer
SQL/PLSQL Developer
Primary Skills:
Job Roles and Responsibilities:
- Design, implement, and maintain database schemas, tables, views, and stored procedures. Develop SQL queries to retrieve, update, insert, and delete data from databases efficiently. Optimize database performance by creating indexes, tuning queries, and analyzing query execution plans.
- Write and optimize PL/SQL code to implement business logic and data processing tasks within the Oracle database environment. Develop stored procedures, functions, triggers, and packages to automate tasks and enforce data integrity. Handle exceptions and errors gracefully within PL/SQL code using exception handling mechanisms.
- Perform database administration tasks such as user management, security configuration, and backup/restore operations. Monitor database performance and resource utilization to ensure optimal operation and troubleshoot issues as they arise. Implement database security measures to protect sensitive data and comply with regulatory requirements.
- Extract and transform data using SQL queries and PL/SQL procedures to generate reports and support business intelligence initiatives. Work closely with business analysts and stakeholders to understand data requirements and translate them into actionable insights.
- Design and implement ETL (Extract, Transform, Load) processes to move data between different systems and databases.
- Identify and resolve performance bottlenecks in SQL queries and PL/SQL code through query optimization techniques and index tuning.
- Document database designs, data models, and development processes to ensure clarity and maintainability.
Required Experience, Skills, Knowledge:
- Hands-on experience in database development, with a focus on SQL and PL/SQL programming.
- .Proven track record of working with relational database management systems (RDBMS) such as Oracle, SQL Server, MySQL, or PostgreSQL.
- Experience in designing and implementing database schemas, stored procedures, triggers, and other database objects.
- Proficiency in SQL (Structured Query Language) for querying, updating, and managing relational databases. Strong understanding of PL/SQL (Procedural Language/SQL) for developing stored procedures, functions, triggers, and packages within Oracle databases.
- Understanding of relational database concepts such as tables, indexes, constraints, and transactions. Familiarity with database development tools such as Oracle SQL Developer, Toad, or SQL Server Management Studio (SSMS).
Soft Skills:
- Team player and individual contributor
- Self-starter and highly motivated
- Excellent communication skills