Recruiters Blog: Oracle PL/SQL Developer

Sep 23, 2009

Oracle PL/SQL Developer

I am Ajay working as Oracle PL/SQL Developer. My project is going to complete at AZ in couple of days so I am looking for another project anywhere in USA. I am furnishing my skill details below. Please let me know if you any good requirements for my skill set.

Domains:

Insurance, Financial, Mortgage, Pharma, Banking.

Skill Set: Oracle – 7+ years

PL/SQL – 7+ years

File Net – 2+ years

Over Seven + years of experience in Information Technology with expertise in Data-Warehouse/Database Development, Database Administration, Maintenance, Support and Implementation.
Expertise in Oracle 9i/8i/7.x, SQL*Plus, PL/SQL, Java, C++, C, VB, Delphi, UNIX Shell scripting, SQL*Loader.
Involved in all phases of the SDLC from Analysis, Design, Development, Testing, Implementation and Maintenance with timely Delivery against aggressive deadlines.
Optimized the Oracle database by tuning SQL queries and PL/SQL blocks
Managing Database Structure, Storage Allocation, Table/Index segments, Rollback segments, Constraints, Database Access, Roles and Privileges.
Implemented Data Cleansing, Transformation Scripts, Stored Procedures/Triggers and necessary Test plans to ensure the successful execution of the data loading processes.
Extensive experience with Oracle Databases and experience in writing PL/SQL queries, Stored Procedures/Functions, Triggers.
Proficient in ETL Processes using Oracle PL/SQL, Unix Scripts and SQL*Loader for data migration to Enterprise Data Warehouse with large data volume.
Expertise in Database Performance Tuning, Performance Monitoring and Optimization using tools such as Oracle Hints, SQL Trace, Explain plans and Table partitioning

· Experience in the integration of various data sources, such as MS-SQL Server, Teradata, Sybase, Oracle, MS-Access and Paradox.

· Provided Production support in multiple projects.

Expertise in Querying and testing RDBMS such as Oracle, MS-SQL Sever using SQL, PL/SQL for data integrity.
Experience in the testing of Web and Client/Server based applications, both Manual and Automated Testing.
Experience in creation and implementation of recovery and backup processes.
Excellent team player, with strong skills in trouble-shooting, problem solving, interpersonal, oral & written communication.
Expertise in the creation and maintenance of Tables, Indexes and various other database objects.
Ability to work in a team and as an individual. Possess strong communication and interpersonal skills.
Excellent analytical and problem solving skills with understanding of project management.
Created korn shell scripts for monitoring tasks, data archival and maintenance of table spaces