Occupation:Database Administrator |
Location:Ashburn, VA |
Education Level:Bachelor |
Will Relocate:YES |
Description
SUMMARY * Over 18 years of extensive experience in System Analysis, Applications Design, Development, Integration & System Testing. * Over 3 years of Data modeling experience. * Over 12 years of Oracle Reports experience. Familiarity with Oracle data warehousing features such materialized views, bitmap indexes, Index Organized Tables, external tables etc * Data Conversion& Data Migration Projects, Datawarehousing & Knowledge Management Projects. * Knowledge on Backup and Recovery Methods (Physical Backup, Logical Backup). * Knowledge on RMAN. * Knowledge on Data Guard and Streams Functionality. * Extensively worked as Team member in performing tasks such as Strategic Planning, Logical and Physical Data Modeling & Application Performance Tuning. * Extensive RDBMS experience includes Oracle 7.x/8i/9i/10g/11g, SQL, PLSQL Forms3.0, Forms4.5, Reports2.5, Forms 6i/9i, Reports 6i/9i, Query Optimization, Performance Tuning, Trouble Shooting, * Referential integrity, Packages, Stored Procedures, Triggers andExport/Import. * Thorough knowledge and experience in using analytical functions, hierarchical queries * Utilities. Logical & Physical Data Modeling, Normalization, Application Analyzing and Designing using Designer 2000. Translating business requirements into creation of Database Objects: Tables, Indexes, Constraints, Triggers, Stored Procedures, and Materialized Views. * Knowledge on performance monitoring tools like TKPROF, AWR, ASH, ADDM. * Expertise in Configuration Management using PVCS, SCCS, AS-ONE, IBM-Clear case. * Worked with Data modeling tools like ERWin and Designer 2000, Designer 6i, 9i. * Used TOAD to switch between various databases, mainly between Development, Quality Analysis and Production Databases. * Extensively worked with the business analysts to obtain the requirements and designed Various projects
Accomplishments
Highlights:
Keywords
