Oracle Apps DBA

SRINIVAS ARIKATLA

Email : ************.**@*****.***

Phone: 512-***-****

(Oracle Developer )

Note: Available Immediately *** ONLY FOR A CONTRACT POSITION ***

=======================================================================================

SUMMARY OF QUALIFICATIONS

• Oracle PL/SQL Developer with Over 7 years of experience in developing and supporting all stages of systems life cycle including Analysis, Development, Testing, Implementation and Product Support using Oracle SQL, PL/SQL on Unix and Windows environment.

• Hands on experience working on Oracle 8i/9i/10g/11g databases on Unix/Linux/Windows platforms.

• Hands on experience in working on various platforms like SUN SOLARIS, SuSE Linux, Red Hat Linux and Windows (98/XP/2000).

• Experience in OLTP/DSS/DW database systems, managing very large oracle databases (VLDB (10 to 20 TB in size)).

• Extensive experience in developing Database Objects, Triggers, stored procedures, Functions, Packages.

• Strong Knowledge of creating Tables, Indexes, Views, Materialized views, Synonyms, database links.

• Developed Oracle based (SQL and PL/SQL) programs for the creation of ad hoc queries/reports, including requirements gathering, design, coding and unit testing.

• Extensively involved in writing SQL queries (Sub queries and Join conditions), PL/SQL programming and Query Level Performance tuning.

• Extensively worked on Collections, Bulk Binds, Bulk Collects and Table Partitioning.

• Excellent in writing Shell Scripts using (Sh, Ksh, Bsh) for database transactions and batch processing.

• Experience in using different Transformation tools like DTS packages, BCP, and BULKINSERT, familiarity with SSIS.

• Generated DDL scripts for creation of new database objects like tables, views, sequences, functions, synonyms, indexes, Triggers, Packages, Stored procedures, roles and granting privileges.

• Tuning of SQL statements using EXPLAIN PLAN, TKPROF, SQL Trace, Oracle Hints to improve the performance.

• Proficient in using Oracle tools such TOAD, SQL Developer, SQL*PLUS and SQL Navigator .

• Experienced in Loading data into multiple tables using DB Management Tool like SQL*LOADER, Import /Export, Datapump.

• Strong interpersonal, analytical and communication skills, proven ability as an efficient team member in System Analysis, Design, Development, Migrating and documentation.

• Experienced in providing quality operational Support for Production Environments

TECHNICAL SKILLS

Operating Systems Windows 98/XP/2000, Solaris, Red Hat Linux, SuSE Linux.

Databases Oracle 11g/10g/9i/8i, Microsoft Access.

Languages C, C++, Shell Scripting (Bsh, Ksh, Sh), SQL, PL/SQL.

Tools & Oracle Utilities: SQL*Plus, SQL Developer, SQL Loader, Import/Export, Datapump, TOAD, Log Miner, SQL Navigator 4.4

Tuning Tools STATSPACK, TKPROF, EXPLAIN PLAN

Job Schedulers Crontab (Unix), Scheduled Tasks(Windows), DBMS_SCHEDULER

Maestro.

DB Modeling Erwin 4.0

Other Tools Harvest, Lotus Notes, HP Quality Center

Educational Qualifications

Bachelor Of Engineering in Computer Science from University Of Madras, Chennai, India(G.P.A 3.7).

Professional Experience:

Contact this candidate