PL SQL Developer Resume Samples

Description :

1. Participated in the complete software development lifecycle, including planning, analysis, design, and implementation of PL/SQL solutions.
2. Designed logical and physical data models for efficient data storage and retrieval.
3. Created and optimized SQL and PL/SQL scripts for data migration and conversion tasks.
4. Developed triggers, packages, functions, and stored procedures to automate data handling processes.
5. Implemented indexing strategies to enhance query performance and reduce execution time.
6. Collaborated with stakeholders to understand business requirements and translate them into technical specifications.
7. Conducted code reviews and provided mentorship to junior developers to ensure best practices in PL/SQL development.

Experience

0-2 Years

Level

Entry Level

Education

B.Sc. CS

Description :

1. Designed and implemented PL/SQL solutions based on functional specifications, improving system performance.
2. Created and maintained database objects, including tables, views, and stored procedures, ensuring compliance with best practices.
3. Updated and optimized existing PL/SQL procedures and functions following change requests.
4. Developed complex SQL queries and PL/SQL scripts to meet evolving business requirements.
5. Utilized ref cursors and collections for efficient data handling across multiple tables.
6. Executed data loading processes from flat files to staging tables using SQL Loader.
7. Conducted SQL and PL/SQL performance tuning using tools such as TKPROF and DBMS_SQLTUNE.

Experience

5-7 Years

Level

Executive

Education

B.Sc. CS

Description :

1. Developed and optimized PL/SQL code for high-performance database applications.
2. Leveraged advanced features of Oracle 11g for PL/SQL programming, including records, collections, and dynamic SQL.
3. Created partitioned tables and indexes to enhance application performance and data retrieval speed.
4. Conducted performance tuning for Oracle RDBMS utilizing EXPLAIN PLAN and optimization hints.
5. Collaborated with web development teams to ensure seamless integration of back-end and front-end solutions.
6. Performed quality assurance checks on source code developed by peers to maintain high coding standards.
7. Monitored data flow, promptly troubleshooting errors to ensure data accuracy and consistency.

Experience

10+ Years

Level

Management

Education

B.Sc. CS

Description :

1. Participated in comprehensive database design and development within Oracle environments.
2. Collaborated with application development teams to prepare technical designs and execute construction activities.
3. Designed and implemented complex PL/SQL packages to meet business requirements.
4. Wrote and optimized functions and procedures for new and existing packages in Oracle databases.
5. Conducted code reviews and provided feedback to ensure best practices.
6. Conducted performance testing and optimized poorly performing SQL statements and procedures.
7. Provided technical support to developers for code integration using WCF and .NET technologies.

Experience

2-5 Years

Level

Junior

Education

B.Sc. CS

Description :

1. Maintained customer information and ensured efficient data retrieval for core decision-making processes.
2. Developed and optimized stored procedures and triggers to enhance data retrieval performance.
3. Analyzed client functional requirements and contributed to writing comprehensive functional specifications.
4. Implemented best practices for database security and data integrity.
5. Collaborated with QA teams to ensure quality assurance and testing of database applications.
6. Participated in code reviews to ensure high standards of PL/SQL code quality.
7. Trained team members on PL/SQL best practices and performance tuning techniques.

Experience

5-7 Years

Level

Executive

Education

BSc CS

Description :

1. Developed and optimized PL/SQL programs to efficiently retrieve and manipulate data from Oracle databases.
2. Utilized SQL Loader and Korn shell scripts to streamline data import processes into Oracle databases.
3. Crafted complex SQL queries employing joins, sub-queries, and correlated sub-queries for data analysis.
4. Managed version control using ClearCase for effective component maintenance and release management.
5. Implemented and maintained Korn shell scripts to automate database tasks and enhance productivity.
6. Designed Unix shell scripts to facilitate repetitive database operations, leading to improved workflow efficiency.
7. Documented project-related information in Confluence for team collaboration and knowledge sharing.

Experience

2-5 Years

Level

Junior

Education

BSc CS

Description :

1. Collaborated with front-end teams to design and deliver optimized stored procedures and data access methods.
2. Utilized SQL Loader for efficient data ingestion from flat files, ensuring data accuracy and integrity.
3. Designed and maintained Unix shell scripts to automate data processing tasks, enhancing workflow efficiency.
4. Developed and optimized PL/SQL triggers and stored procedures to support complex business logic.
5. Proactively identified and resolved production issues, leading to improved system reliability.
6. Monitored database performance and provided recommendations for improvements.
7. Created comprehensive documentation for database designs, enhancing team knowledge sharing and project scalability.

Experience

7-10 Years

Level

Executive

Education

M.S. in CS

Description :

1. Gathered and analyzed user requirements for report development and custom interface programs.
2. Designed and maintained Oracle database objects including tables, views, and indexes using SQL.
3. Developed complex queries involving joins and sub-queries to meet diverse business requirements.
4. Implemented table partitioning strategies to enhance performance and scalability.
5. Created and optimized stored procedures, views, and indexes for improved application performance.
6. Utilized advanced PL/SQL features such as packages, records, and dynamic SQL for efficient coding.
7. Developed database triggers to maintain audit trails and data integrity.

Experience

7-10 Years

Level

Senior

Education

B.Sc. in CS

Description :

1. Designed and implemented complex PL/SQL functions, procedures, triggers, and packages to enhance database functionality.
2. Developed and optimized SQL queries, ensuring efficient data retrieval and manipulation.
3. Conducted performance tuning for SQL queries using execution plans and indexing strategies.
4. Generated comprehensive PL/SQL scripts for database object management, including tables, views, and indexes.
5. Collaborated with stakeholders to gather requirements and implement application enhancements.
6. Constructed physical data models, including tables and indexes, to support application needs.
7. Utilized SQL Loader for data migration across different schemas.

Experience

7-10 Years

Level

Senior

Education

B.S. in CS

Description :

1. Developed complex PL/SQL processes for batch and ETL functionalities, optimizing data flow.
2. Enhanced an existing DataMart in an OLAP schema, improving reporting efficiency.
3. Conducted requirements gathering, design, development, testing, and documentation for diverse projects.
4. Designed logical and physical ERD diagrams and related documentation to support data architecture.
5. Utilized Oracle 10g/11g features effectively in large-scale multi-terabyte systems.
6. Collaborated with Decision Support team members, including DBAs and analysts, to meet user requirements.
7. Provided production deployment and ongoing support, ensuring system reliability and performance.

Experience

2-5 Years

Level

Junior

Education

B.Sc. CS