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

Technical Skills:

Operating Systems:        Windows 95/98/2000/NT/XP, MS Dos, IBM AIX, UNIX

Languages                 :         Delphi, VB, Java, C, C++, SQL, PL/SQL, UNIX Shell Scripting

Databases                 :         Oracle 7.x/8i/ 9i, MS SQL Server 7.x/2000, MS Access 2000 and Paradox.

Testing Tools           :         Mercury suite (Win Runner, Test Director 7.5/8.0), Rational tools

GUI Tools                  :         TOAD 4.5, SQL Navigator 4.0, DBArtisan 6.5

Bug Reporting         :         Mercury Quality Center, Mercury Test Director7.5/8.0, Rational Clear Quest, CVS, Bugzilla and PVCS Tracker

Version Control tools:   ClearCase, CVS, Visual Source Safe

Web Design             :         HTML, JavaScript and VB Script

App Servers             :         BEA Weblogic, IBM Websphere, IIS, JWS, PWS

 

Regards,

Ajay,

plsqlajay@gmail.com

600 North Second Avenue , Phoenix, AZ - 85001

Click here to unsubscribe