Write some Software

• Over 7.5 years of programming experience as an Oracle PL/SQL Developer Cum DBA in Analysis, Design and Implementation of Business Applications using the Oracle Relational Database Management System (RDBMS). • Involved in all phases of the SDLC (Software Development Life Cycle) from analysis, design, development, testing, implementation and maintenance with timely delivery against aggressive deadlines. • Experience with Data flow diagrams, Data dictionary, Database normalization theory techniques, Entity relation modeling and design techniques. • Expertise in Client-Server application development using Oracle 11g/10g/9i/8i, PL/SQL, SQL *PLUS, TOAD and SQL*LOADER. • Excellent experience in Installation and configuration of Oracle 8i, 9i, 10g, 11g in UNIX/LINUX and Windows environment. • Experience in Installation, configuration of Oracle RAC, developed 2 node RAC environments for a 100 TB database by implementing WAN technology to reduce the network traffic. • Implemented strategy for partitioning and management of historical data tables in RAC. • Replication using Materialized Views, Oracle Streams. • Effectively made use of Table Functions, Indexes, Table Partitioning, Collections, Analytical functions, Materialized Views, Query Re-Write and Transportable table spaces. • Database Tuning, PL/SQL tuning using explain plan and used HINTS extensively to optimize the SQL statements,used cost based approach extensively and also used rule based methods to tune the SQL. • Strong experience in Data warehouse concepts, ETL and ELT. • Strong experience on TDE(Transparent Data Encryption). • Good knowledge on logical and physical Data Modeling using normalizing Techniques. • Created Tables, Views, Constraints, Index (B Tree, Bitmap and Function Based). • Developed Complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL. • Developed materialized views for data replication in distributed environments. • Excellent technical and analytical skills with clear understanding of design goals of ER modeling for OLTP and dimension modeling for OLAP. • Experience in Oracle supplied packages,Dynamic SQL, Records and PL/SQL Tables. • Loaded Data into Oracle Tables using SQL Loader. • Partitioned large Tables using partition technique. • Involved in Logical & Physical Database Layout Design. • Experience with Oracle Supplied Packages such as DBMS_SQL,DBMS_JOB and UTL_FILE.