Sql Manager

ARIKATLA S

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

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

(Oracle Developer )

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

SUMMARY

• Over 7+ years of IT experience in ORACLE as a developer and DBA.

• Expertise in using Oracle 8i/9i/10g and good knowledge in Oracle 11g Databases.

• Excellent expertise in Software Development Life Cycle (SDLC) including Physical and Logical

design, code development, testing, implementing and maintenance.

• Experience in working high transacted OLTP systems.

• Have good knowledge of Oracle Database Administration activities such as Installations, Upgrades,

Patches, Cloning, Migrations, Backup and Recovery, Performance Tuning, Capacity Planning.

• Expert in Client-Server application development using Oracle 8i/9i, PL/SQL, SQL*PLUS, Forms 6i/9i,

TOAD.

• Proficient working experience in SQL, PL/SQL programming and UNIX Shell Scripting.

• Expertise in writing complex SQL queries using joins and correlated sub queries.

• Strong Knowledge of creating Tables, Indexes, Views, Materialized views, Synonyms, DBlinks,

Packages, Stored Procedures, Functions, Cursors, Triggers.

• Analyze SQL statements, database objects with millions of records and design indexes to improve

response of queries.

• Extensively worked in developing and customizing Forms, Menus and writing Packages, Procedures,

Functions and Database Triggers.

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

• Experienced in Tuning SQL Statements and Procedures for enhancing the load performance in various

schemas across databases.

• Database performance tuning using STATSPACK, TKPROF, SQL Trace, Explain Plan.

• Expertise in optimization techniques.

• Hands on experience using various DBMS packages like DBMS_JOB, DBMS_FILE, DBMS_SQL,

DBMS_SCHEDULER.

• Experience in Extracting, Transforming and Loading (ETL) data using SQL loader utility.

• Experience in working with different FTP clients like Smart FTP, cute FTP, SFTP and SCP.

• Experience in environments requiring direct customer interaction during specifications, design and

development and product implementation phases.

• In addition to excellent technical abilities possesses strong oral and written communications skills,

analytical and interpersonal skills.

• Good team spirit and organized working habits with a willingness to learn new concepts.

• Strong ability to handle multiple projects simultaneously through completion and ability to work

independently or in a team environment.

• Ability to function successfully in a highly stressful environment.

1

Technical Skills

Operating Systems Sun Solaris (8, 9, 10), AIX (4.3,5.3), HP-UX, Redhat/SuSE Linux,

Windows 98/NT/2000/XP

Programming Languages SQL, PL/SQL, C, C++, UNIX Shell Scripting.

Databases Oracle 8i/9i/10g/11g, MS Access, SQL Server 2005.

Tools Oracle Enterprise Manager(OEM), SQL*PLUS, SQL*Loader, Forms 4.5/6i/9i,

Import/export, Datapump (expdp,impdp), Erwin, Toad.

Tunning Tools TKPROF, EXPLAIN PLAN, STATSPACK.

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

Protocols FTP, SFTP, SSH, Telnet, TCP/IP.

Version Control Tools Harvest.

Educational Qualifications

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

Project & Work Experience

2

Contact this candidate