_________________________________________________ Here's the brief profile of Lead Oracle Database Administrator / Architect with more than TWLVE years of diversified experience in N-Tier and Client-Server Architecture using ORACLE (7.x to 11g) on multiple OS platforms in OLTP and Data Warehousing Environment.
He is located at Wilmington, DE and available immediately for projects in NYC / NJ / PA / DE / MD / VA / CT / MA. Please contact me for further information. Thanks, Swapnil Modi- Alliance Sales cyberThink Inc Tel : (877)-223-7153 ext 624 mailto:[email protected] <[email protected]> ------------------------------------------------ Brief profile of our Lead Oracle Database Administrator / Architect. ------------------------------------------------ • Lead Oracle Database Administrator / Architect with more than TWLVE years of diversified experience in N-Tier and Client-Server Architecture using ORACLE (7.x to 11g) on multiple OS platforms in OLTP and Data Warehousing Environment. • Proven track record of achieving project deadline in fast paced environment which involved complex merger and takeover of multiple businesses. • Very Good experience in handling big database and application systems migration – integration in heterogeneous environment. • Hands on experience in Database Designing, Capacity Planning, Data Modeling. • Hands on experience in managing VLDB (1.5 TB in OLTP and 15 TB and growing in DW environment). • Expert in Database performance tuning using ADDM, AWR, ASH, Explain Plan, TKPROF, STATSPACK, UTLBSTAT/UTLESTAT Report. • Expertise in writing Stored Procedures, Packages, Functions and Triggers using PL/SQL. • Very good hands on experience writing Shell Scripts to support and maintain database. • Hands on experience on automating task using Cron, Autosys, Nobix and Oracle Scheduler. • Experience in implementing Oracle Data Guard functionality and planning and testing DR (disaster recovery) at SunGuard datacenter facility to protect the database against disaster. • Experience in implementing and maintaining Oracle Real Application Cluster on HP UNIX, Fujitsu (Solaris OS). • Hands on Experience to set up Grid Control for Databases and Application Servers monitoring using Oracle 11gR2. • Worked in 24x7 production environment and provided on-call and day-to-day support. • Experience of PeopleSoft HRMS Database Administration and Management. • Hands on experience on Data Mart and Data Warehouse Design and Implementation. • Expert in planning and implementing Backup/Recovery strategies using RMAN. • Evaluated & Implemented Oracle 10g and 11g– RAC, ASM, ADDM, AWR, ASSM, Data Vault, Streams. • Hands on Experience on COBOL, DB2 and CICS migration from AIX-DB2 to Oracle-Java-PL-SQL. • Hands on experience in migrating legacy databases Sybase, DB-2, Access, and SQL Server to Oracle. • Familiar with ITIL processes. TECHNICAL SKILLS: RDBMS: Oracle (7.x to 11gR2), DB-2(5.1, 7), SQL Server (6, 6.5, 2000), Sybase 11. Hardware: HP-3k to 9K and Superdom, SUN E6500, E5500, E4500 to E25K and AIX. OS: HP-Unix, Sun Solaris (2.6, 2.7, 2.8, 2.9, 10), RedHat Linux, IBM AIX, Windows 2000/NT/XP. DBA Tools: Grid Control, BMC-PATROL, Quest Central (SpotLight, FogLight, Space Manager, Schema Manager, TOAD), Golden Gate and Embarcadero’s DBArtisan. Case Tools: Erwin 3.5, 4.0, Designer -2000, Rational Rose. Web Servers: Oracle iAS, BEA Weblogic 7, 8, 8.1, Websphere. Languages: SQL, PL/SQL, Pro*C, C, C++ (Visual Studio and Borland Compiler), Java. Utilities: Datapump, SQL*Loader, Import, Export, DTS, PVCS. Network Tech: Knowledge of TCP/IP, SAN, LDAP, NETBUI. ERP: PeopleSoft HRMS, Oracle Apps, SAP. DW Tools: Cognos BI, Datastage ETL, Informatica. PROFESSIONAL EXPERIENCE: Confidential June ‘05 - Present (Financial Group), Wilmington, DE Lead DBA Responsibilities: • Installation and configuration of Oracle 11g, 10g, 9i Servers and clients on HP-11i, AIX, Solaris and Linux. • During Merger and takeover (AIG Auto Insurance takeover of 21st.com and merger of 3 AIG insurance branches during credit crisis), successfully achieved strict deadline by Migrating and consolidating various applications, systems and databases from various global location to Wilmington, DE data center. • Involved in installation, configuration, migration and upgrade of Oracle 9i databases to Oracle 10g and Oracle 11gR2. • Performance tunning of report SQLs for state of the art Data Warehouse application in RAC environment. • Performance tunning of OLTP Claims and Policy and Document management systems in RAC environment. • Migration of databases from Hawaii, Alpharetta and Woodland Hills data centers to Wilmington data center using Oracle Streams, DataGuard – GoldenGate, RMAN. • Maitained SOX compliance by implementing database level auding, security and data masking. • Maintained and supporting multiple instances of Oracle Databases 10g and 11g (Production, Training, Development, QA, Testing and Warehouse). • Planned and attended multi TB DR Exercise at SunGuard Facility, Philadelphia twice a year. • Resolved performance related issues for Database / Application using Quest’s Lecco SQLExpert, STATSPACK, SGA Tuning- Memory, Disk I/O tuning. • Tuned Data Warehouse – Star Schema – Dimensional SQL queries to achieve optimal performance using various tools and technology available with Oracle 10g and 11g like Patitioning, Indexing (bitmap and BTree), ADDM, AWR, ASH. • Involved in central interface design project – dealt with MQ Series and Oracle Streams for the Centralized policy and claim Interface. • Oracle Database Refresh/Cloning performed from Production to Test, Parallel, Training and Development databases. • Worked with Security group to implement Data Security and Protection of PLD Warehouse using Oracle Data Vault and FGAC to limit the access to various module of PI (personal information) Data to meet various security standard enforced by insurance regulatory body. • Implementation of PI (Personal Information) security project to protect PI data in onshore / offshore environment. • Involved in various stages of Data Warehouse design to implementation – defined storage structure for both Database as well as database objects – like large tables, indexes (B-Tree – Bit Map) etc. • Configuration of Cognos Reportnet and DataStage ETL server. • Applied 10.2.0.4 Patch set to 7 instances of Oracle database on Production and Development server – Data Warehouse environment Sun Server (E25K) - Solaris OS (2.9). • Applied 9.2.0.7 and 9.2.0.8 Patch set as well as DST Patch to 134 instances of Oracle database on Production and Development server on HP Superdom – HP Unix 11i OS. • Involved in claim application migration from Oracle client-server architecture to Oracle N-Tier architecture (Web based application). • Reported several bugs to oracle support in oracle 9i and 10g using iTAR oracle support. • Installed and Configured Oracle Process Manager to monitor and administer various component of SAP Application. • Configured and implemented Dataguard as part of Disaster Recovery planning. • Worked as a supporting Database architect for PLDW Warehouse project and co-ordinate with data modeler to implant star schema and snowflakes design into physical database. • Involved in defining strategies for user authentication using Oracle Internet Directory, SSO and Certification Strategy to evaluate the application security under N-Tier Architecture. • Implemented Backup and Recovery procedures using RMAN using Legato Backup server. Environment: Software/Platform: Oracle Databases on HP – (Superdom, EMC SAN and Veritas Volume Manager) 11i UNIX System, Oracle DW (on Solaris 9, E25K), and Grid Control Oracle 11gR2 components on RedHat Linux, AIX, WebSphere, J2EE environment in PLCS application and Cognos, DataStage in warehouse environment, MQ Series and Oracle Stream, Datastage as ETL Tool and Cognos BI Tool, EMC Documentum – SAP. -- You received this message because you are subscribed to the Google Groups "Exact Match" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/exact-match?hl=en.
