Excellent Dba Available Immediately.
| Thanks & Regards, vic contact:732-410-2100x202 Email: vic@sunmergesystems.com Gtalk:vikramsunmerge@gmail.com Ymsgr:vikramsunmerge@yahoo.com
PROFESSIONAL SUMMARY: Over 8+ years of IT experience as Senior Oracle Database Administration Ver. 10G/9i/8i/8.0/7.x on a variety of UNIX (Solaris, HP-UX, AIX), Windows NT 4.0/2000/2003 with Oracle (7.x, 8.0.5, 8i, 9i, 10g), Stored Procedures, DB Triggers, Developer 2000, Sql*Plus, Pro*C etc. · Installed oracle database server on SOLARIS, HP-UX, AIX, WINDOWS NT, LINUX and migration of oracle server from 7.3.4,8 to 8i, 8i to 9i and 9i to 10g applied oracle patches. · Installed Oracle 10g RAC software with ASM & OCFS2 File systems · Installation, maintenance and tuning of RAC Applications. Used rapid install and other Oracle Application maintenance utilities like OEM. · Created development, testing, staging, production, RAC and standby databases for OLTP, DSS and Data Warehousing using customized shell scripts and stepwise. · Involved in different scenarios of OLTP as well as DSS (DATA WAREHOUSE) Databases. · 24*7 production database support with Support to developers & end-users. · Have implemented ORACLE STREAMS, and two type of standby databases supported by DATAGUARD, logical standby and physical standby databases · Having hands on experience in Hot/Cold Backup, Recovery and Cloning of databases using RMAN with VERITAS Net Backup. · Have worked on large-scale databases with size of more than 1TB in large system environments. · Implemented and delivered core edge technologies of Oracle 10g (Streams, EM Grid Control, and RAC). · Logical and physical modeling using Erwin. · Implemented RMAN backup (Full, incremental and cumulative) and recovery, Incomplete recovery and disaster recovery using Standby database or Data Guard. · Implemented automated backup strategy using the UNIX shell script CRON UTILITY · Expertise in PL/SQL, SQL and UNIX Scripting (Used to write UNIX Scripts & implemented by Using CRONJOB for Day – to – Day activities.) · Have experience in setting up SQLServer2005, and have done backup, recovery and performance tuning. · Performance tuning of the database - SQL Tuning, Used Tuning utilities like STATSPACK, TKPROF, EXPLAIN PLAN, AWR, ADDM and Tuning of SGA, Distribution of disk I/O, Sizing of tables and indexes. · Performance Tuning i.e. tuning applications, shared pool, I/O distribution, rollback segments, buffer cache, redo mechanisms · Installation and Configuration of Oracle Grid Control. · Strong knowledge of Data Warehousing methodologies and concepts, including star schemas, snowflakes, ETL processes, dimensional modeling and reporting tools. · Extensive experience with designing and implementing Oracle databases, data warehouse design, implementation and tuning. · Data loading using SQL*LOADER, Logical backups using full export and DATAPUMP. · Database replication using snapshots, materialized views and advanced replication methods. · Worked on different types of storage structures (SAN/NAS). · Expert in sizing, capacity planning, backup, and recovery planning with multi-terabyte data warehouse solutions in Oracle environments. · Extensive knowledge in reporting tools like Business Objects and crystal reports · Good co-ordination and communication with system administrators, business data analysts and development teams. TECHNICAL ENVIRONMENT:
|
0 comments:
Post a Comment