Sr. Oracle Dba/consultant Resume
Los Angeles, CA
SUMMARY:
- With over 17 years of experience with Oracle I am seeking a Senior DBA/Architect/Technical Manager position. I have been involved extensively with the following aspects of RDBMS Oracle: Database Creation, Upgrade, Capacity Planning, Space Management, Performance Tuning, Backup & Recovery, Security Administration, Data Migration, Data Modeling, Data Architecture and Data Warehousing. I have handled and managed IT projects in top financial firms. I have independently handled gigantic projects right from planning, installation, scheduling, execution, implementation and productivity enhancement activities.
- Leading a team of over 70 people spread across 13 business applications that include team leads, developers & DBAs. Being hands on resolving their issues directly and indirectly providing solutions while filling out a senior consultant role. Lead efforts in upgrading, configuring and implementing solutions to the business applications right from infrastructure level to post implementation support and handled procurement of business licenses and extensions from various software/hardware vendors. Recently implemented a financial application that receives data feeds from 34 city departments; but now I am leading ITA effort for all 13 applications altogether while working hands on. Working directly with technologies not limited to Oracle, MySQL & sqlserver with some DB2 besides some licensing and hardware support from IBM, Oracle & Microsoft. Responsible for data feeds and solutions towards night cycle runs and backup recovery with monitoring enhancements.
TECHNICAL SKILLS:
Hardware: IBM, Oracle Exabyte, EMC, Compellent, DELL, SunSparc 6500, 2000, 420, 220, COMPAQ, HP, IBM Regatta, AMD Opteron 248, 848
Tools: SQLForms(4.5, 3.0, 2.3), Reports (1.1, 2.0, 2.5) Relational Database: ORACLE (12.1.0.2, 11.2.0.4, 10.2.0.4, 9.0.1, 8.1.7, 8.1.6, 8.1.5, 8.0.5, 7.3.2.3, 7.1, 7.0 & 6.0) (64bit/32bit), OAS 9.1.1.1, Enterprise Manager, RMAN, Space Manager, Oracle Backup Enterprise Utility, Oracle SQL Backtrack, Chain Link Object Migrator (2.0), Oracle Applications Datawarehouse, CITRIX 1.7, Crystal Reports, BusinessObjects, IBM LPAR, MicroStrategy, Informatica UDS, Peoplesoft, Datawarehousing, Cognos, MS SQL Server2000, Microsoft .NET, Embarcadero, SQL Navigator, Savant Diagnostics, Erwin, Patrol, Smart DB, Veritas 3.5, Legato 5.5.1, SQLNavigator, SharePlex, Oracle Application Server Portal 10g (9.0.4) WebServers, Trillium, SAN - NAS, BEA web logic, DB2 Data Joiner, Embarcadaro, J2EE, Java Beans, ControlM, PowerDesigner 9.2, Informatica Powercenter 7.1.2, 8.1.1, 8.5.1.9.2.
Languages: SQLPlus, PL/SQL, Writer (2.0), SQLMenu(5.0), PL/SQL(2.0), JAVA, Sybase, OLAP technology, Unix Shell Scripting, Cron processes, SQL Scripting, C, csh, ksh, PERL scripting, SAP, ProC, Visual Basic.
Operating Systems: MS-DOS, UNIX SVR 4.0, HP-UX 10.2, Solaris (2.5.1, 2.6, 2.7, 2.8, 2.9 & 2.10), Windows NT, Digital Unix 4.0b, HP (9000, 10.4, 11.0), Digital Open VMS, Sybase, Dynix/PTX, AIX 7.1, COMPAQ Alpha, Red Hat Linux, TRU 64.
EXPERIENCE:
Confidential, Los Angeles, CA
Sr. Oracle DBA/Consultant
- Erected, installed and successfully implemented Oracle11g RAC databases in both Test and Production to finally migrate the data to a new environment while keeping the cluster intact.
- The online applications configuration and implementation was conducted in both the environments and successfully tested the data feeds coming from 34 different departments as part of night cycle run.
- Supported DB2 applications using multi terabyte systems and performed migration to oracle.
- Devised streamlining of DB2 applications using self managing technologies.
- Created Oracle 11g RAC data warehouses and performed comparative analysis of the user applications in different environments.
- Executed the support the design of relational database schemas, multi-dimensional schemas, ETL processes and End User tool environments through the client using Oracle ETL and triggers.
- Using Oracle11G utilized the Flash Back Database where old database block images are stored in a Flash Recovery Area which allow fast rollbacks of database as no redo logs are required and also assists in correcting user errors.
- Enhanced the DB Security with proper implementation and configuration as per the guidelines of Risk Management in various environments.
- Configured various databases in DEV, TEST and PROD to the OEM and initiated alerts for database administration and space management.
- Coordinated hundreds of users across environments and platforms to augment their requests for data access and job related requests.
- Fine tuned the environment using Oracle ADDM, ASH, AWR reports from OEM and shared the info with Developers to mitigate their short and long term issues.
- Assisted and ran the daily batch jobs to load the data coming from one department to the other to run batch jobs and run dashboards.
- Managed supply chain management and Financial management systems and data feeds coming from 34 departments some of them being LAPD, Dept of parks, PaySR, LATAX etc.
Confidential, Irvine, CA
Sr. Datawarehouse Oracle DBA/ETL/Informatica Administrator
- Managing both server and application level Informatica 7.1.2 setup.
- Performed upgrade of Informatica Power Center 7.1.2 to 8.1.1 and then to 8.5.1 with service pack SP5 upgrade.
- Configured OBIEE while delivering full range BI capabilities including interactive dashboards, full ad hoc, proactive intelligence and alerts, enterprise and financial reporting, real-time predictive intelligence, configured SSL with LDAP configuration for analytics in addition to providing the full of BI functionality.
- Configured and upgraded Cognos 7 to Cognos 8 to establish business reports and analysis.
- Provided BI using Cognos business analysis reports and forecasting tools. Integrated driver based planning using forecasting with centrally controlled planning for Cognos.
- Configured and implemented OMS/DMS/EMS (Outage Management System, Distribution Management System, Energy Management System) for client services.
- Managed and optimized full product life cycle management schedule based on Service Oriented Architecture (SOA) architecture.
- Used Trillium for data profiling for software lifecycle management and data cleansing activities.
- Enhanced the DB Security with proper implementation and configuration as per the guidelines of Risk Management in various environments.
- Performed data enrichment and improved data quality using Trillium software solutions.
- Responsible for user administration, repository administration and deployment of various applications to UAT & Production environment of Informatica.
- In charge of SIEBEL CRM implementation and configuration of the front end reporting structure.
- Performing backups and deployments of informatica DEV, UAT and PROD applications on server and applications side.
- Managing SIEBEL Analytics server and administration from console and application side.
- Managing and assigning access to users in SIEBEL Analytics applications depending upon the roles and responsibilities and keep track of report usage and assignments.
- Performing all the datawarehouse related functions and administration of servers on oracle 9i. Responsible for all the materialized refreshes from ERP system over to Datawarehouse.
- Performing multi theatre refreshes for the data sets to be used by different offshore installations for reporting and analysis purposes.
- Demarcate the staging and data flow operations keeping in view strict security guidelines in place.
- Installed and configures AGILE & SYMPHONY client server applications accessing the Oracle 9i datawarehouse database and performed various debugging operations to simplify the operation in limited man hours.
- Performed installation, setup and configuration of IBM LPARs with the existing infrastructure. Migrated the database from Linux to IBM 6.1 using Oracle Datapump.
- Managing, deploying, upgrading and supporting BI applications like Symphony, AGILE and Siebel CRM.
- Maintained and regulated the functionalities of Linksys.com databases and performed application and server tuning for web applications.
- Assisted in RAC configuration and installation for Linksys.com running on ORACLE 10g.
- Managed the hiring process for Linksys.com by interviewing several candidates and gave feedback to the team leads. Also performed security analysis of various in house applications.
- Automated the jobs for backups and error notification of ORACLE and INFORMATICA.
Confidential, Los Angeles, CA
Sr. Oracle DBA/Project Lead
- Installed, configured and implemented the Oracle Selective Audit for better security administration and data recovery.
- Configured the new data center with ASM implementation instead of using veritas.
- Planned, documented and laid the guidelines for the successful implementation of HTB (Health Transaction Base) to further improve the patient care and control the data flow for ETL processes.
- Implemented Oracle Advanced Security DCE using state of the art technology to facilitate secure connections and processing of applications and running the reports.
- Erected, installed and successfully implemented Oracle10g RAC databases in both Test and Production to finally migrate the data to a new environment while keeping the cluster intact.
- The online applications configuration and implementation was conducted in both the environments and successfully handed over to the IBM staff in Phoenix after implementation and user testing.
- Provided business planning and analysis using Cognos reports and assisted in setting up Cognos with Oracle 10g databases.
- Enhanced the DB Security with proper implementation and configuration as per the guidelines of Risk Management in various environments.
- Created Oracle10g RAC data warehouses and performed comparative analysis of the user applications in different environments.
- Executed the support the design of relational database schemas, multi-dimensional schemas, ETL processes and End User tool environments through the client using Oracle Warehouse Builder.
- Using Oracle10G utilized the Flash Back Database where old database block images are stored in a Flash Recovery Area which allow fast rollbacks of database as no redo logs are required and also assists in correcting user errors.
- Improved the Timing and Statistics in Oracle10G using latest data dictionary views like v$eventmetric, v$sessmetric, v$sysmetric, v$filemetric, v$sysmetric history and v$session wait history.
- Erected and comissioned the whole Disaster Recovery for all the production applications and jointly peroformed and succesfully implemented the DR environment.
- Improved the system performance making available larger servers with Oralce10g RAC from to the stand alone applications.
Confidential, Sales Torrance, CA
Sr. Oracle DBA
- Erected, installed and successfully implemented Oracle9i RAC databases in both Test and Production to finally migrate the data to a new environment while keeping the cluster intact.
- The online applications configuration and implementation was conducted in both the environments and successfully handed over to the IBM staff in Phoenix after implementation and user testing.
- Supported DB2 applications using multi terabyte systems and performed migration to oracle.
- Devised streamlining of DB2 applications using self managing technologies.
- Implemented Universal DB2 developer edition to offer low cost package to design build and prototype applications for deployment of other client server DB2 applications.
- Created Oracle9i (9.2.0.6) RAC data warehouses and performed comparative analysis of the user applications in different environments.
- Executed the support the design of relational database schemas, multi-dimensional schemas, ETL processes and End User tool environments through the client using Oracle Warehouse Builder.
- Using Oracle10G utilized the Flash Back Database where old database block images are stored in a Flash Recovery Area which allow fast rollbacks of database as no redo logs are required and also assists in correcting user errors.
- Enhanced the DB Security with proper implementation and configuration as per the guidelines of Risk Management in various environments.
- Improved the system performance making available larger servers with Oralce9i RAC from to the stand alone applications.
- Performed both hot and cold backups using Oracle 9i RMAN.
- Utilized the Oracle 10G features including incremental backups using RMAN.
- Coordinated, managed, implemented the business applications while working as the lead DBA while communicating with different data sources and business users.
- Planning and documenting the strategy for fail over and future implementation of Oracle 10G Data Guard with Real Application Clusters (RAC) in Oracle 10G.
- Performed job monitoring and automation using Redwood.
- Installed, commissioned, configured, upgraded Redwood on Test, QA and Production servers.
- Worked with the user community during upgrades and licensing of Redwood job automation software.
- Performed extensive configuration and implementation of Informatica in Oracle 10G RAC environment.
Confidential
ORACLE DATA ARCHITECT/Sr. DBA
- Responsible for the Sybase and Oracle database administration and system administration running OLTP applications.
- Erected, installed and successfully implemented Oracle10G databases taking advantage of Grid Computing, SQL Model Clause, Data Pump, Automatic Storage Management to deliver a complete stack of software and create an independent application.
- Created Oracle data warehouse using OWB 10G using highly scalable metadata repository. Executed the support the design of relational database schemas, multi-dimensional schemas, ETL processes and End User tool environments through the client using Oracle Warehouse Builder.
- Using Oracle10G utilized the Flash Back Database where old database block images are stored in a Flash Recovery Area which allow fast rollbacks of database as no redo logs are required and also assists in correcting user errors.
- Performed migration of DB2 version 8.0 to Oracle 9i with all the complex business integrity rules.
- Improved the Timing and Statistics in Oracle10G using latest data dictionary views like v$eventmetric, v$sessmetric, v$sysmetric, v$filemetric, v$sysmetric history and v$session wait history.
- Erected and comissioned the whole Disaster Recovery for all the production applications and jointly peroformed and succesfully implemented the DR environment.
- Performed, managed and analyzed the Business Process Re-engineering for the client reporting interfaces with extracts coming from Sunguard Invest1, GEAC Smartstream, ONYX CRM and other corporate systems.
- Made recommendations to the management to use datawarehousing to consolidate disparate interfaces.
- Enhanced the DB Security with proper implementation and configuration as per the guidelines of Risk Management in various environments.
- Managed the replication from sybase12.5 to Oracle9.2.0.5 using sybase repserver and removed all the bottlenecks till the actual transition of the project to production.
- Configured, maintained SharePlex for Oracle to meet the business continuity and performance needs by utilizing a technical architecture of replication. Created SharePlex master and standby databases for Oracle to provide asynchronous, fault tolerant, streaming and near real time replication of the Oracle databases.
- Managed Informatica UDS (universal data services) to reduce the complexity across systems, processes, and resources, providing faster time to value for a broad range of data-centric projects such as data migration, synchronization, hubs, warehousing, and business activity monitoring.
- Created the database, tables, tablespaces, data objects, setting privileges, indexes, user logins, and password security.
- Integrated Sybase developed solutions sets for the financial (SWIFT, OFX); communications, where Sybase delivered the Communications e-Business Solution (CeBS) specifically programmed to answer the pressing needs of financial Industry. Responsible for Merging the data from Sybase database to the Oracle database including the data modeling.
- Accomplished Sybase data augmentation and migration to Oracle with post migration application tuning.
- Data Warehousing, Data Warehouse Database Sizing, Tablespace Management and Rollback Tablespace Management, Transaction Management, Security Administration.
- Performeed Oracle Portal planning and design, security & access control, web publishing and content management.
- Integrated web-based resources such as web pages, applications, business intelligence reports, and syndicated content feeds, within standardized, reusable information components called Portlets.
- Created intuitive controls for document/file upload, version control, page formatting/display, and access control using Oracle Portals to publish and manage user content and allow end users to post and share any kind of document or web content with other users anywhere in the world.
- Installed and configured RAC installation using Optron64 servers with oracle 9.2.0.4.
- Planning and documenting the strategy for fail over and future implementation of Real Application Clusters (RAC) in 9i.
- Managed and implemented the Materialized Views after converting from Snapshots in Oracle 9i.
- Replicated the data from Oracle7 to Oracle9i from actual production to test and then to QA and Production after successful testing.
- Reported to the management in regards to the implementation of the new application to the new data. Managed the implementation of Patches for the latest OS version and databases.
- Performed Sybase to oracle migration and responsible for user interaction and security administration.
Confidential, Culver City, CA
ORACLE DATA ARCHITECT/Sr. DBA
- Executing the upgrade/migration of the Test, QA and Production databases for the home grown client/server application SPIRIT from Oracle 7 to Oracle9i latest version on SAN. Planning, Designing and Building the databases in Oracle9i and setting up the totally new environment right from System Architecture level.
- Managing the Export and Import on DB, Schema and Table level.
- Managing and recommending client service application running SAP.
- Migration of the existing 11i application to 11.5.8 from iProcurement to Oracle exchange.
- Installation of maintenance patchsets to the 11i applications and removing the errors and debugging.
- Planned and erected personalized interface in Oracle 9ias that provides an organized, consistent view of the business information, web content, and applications needed by each user group.
- Migrated and entire Enterprise application from Sybase to Oracle 9i using SQLLDR and authored full technical documentation.
- Designing and implementing the Hot Backups working with SAN on TRU64 for the Oracle 9i database on Legato.
- Utilized Oracle9i Warehouse Builder to enable the design and deployment of Business Intelligence applications, data warehouses and data marts.
- Implemented and Maintaining the Advanced Master to Master Replication in Oracle9i.
- Planned and documented the strategy for fail over and future implementation of Real Application Clusters (RAC) in 9i.
- Performing the ETL operations within a datawarehouse using Informatica. Performed enterprise data integration using Informatica. Created a unified architecture and products for accessing, integrating, visualizing and auditing data. Designed the application to solve the complex data integration problems
- Managing and implementing the Materialized Views after converting from Snapshots in Oracle 9i.
- Replicating the data from Oracle7 to Oracle9i from actual production to test and then to QA and Production after successful testing.
- Reporting to the management in regards to the implementation of the new application to the new data. Managed the implementation of Patches for the latest OS version and databases.
- Executing and documenting the performance enhancement activities.
- Worked extensively with the developers and users to maintain the coherence of the data and logic transfer.
Confidential, San Francisco, CA
SYSTEMS ARCHITECT/DATA MODELER/Sr. DBA
- Planned, managed and executed complete System Architecture for a new Client / Server application using Oracle 9i and apps server. Built Oracle9i databases for testing, development and production, which run on Solaris 2.8 64 bit. Physical design and doing the data modeling on logical level. Tuning the system both server level and application level. Building secure databases as per the HIPAA compliance.
- Managed Hot and Cold Backups
- Recommendations running SAP application and doing the migration to Oracle database.
- Data conversion from Sybase to Oracle database.
- Database upgraded from Oracle 8i to Oracle 9i.
- Database Ring Security 9.0.1.
- Configured the reporting modules for Crystal Reports and Oracle Report Writer.
- Setting up and Installing Oracle Web Application Server 9.1.1.1, Oracle Enterprise Manager and Enterprise Backup Utility.
- Created the database, tables, tablespaces, data objects, setting privileges, indexes, user logins, and password security.
- Incorporated Oracle Warehouse Builder to provide the users with a graphical environment to model the ETL processes. Executed mapping of multiple sources into multiple targets using OWB and enabled users to specify chained transformations on the data flow and apply complex PL/SQL transformations to the data using Oracle Warehouse Builder.
- Implemented Informatica Power Center Connect to provide native connectivity to an array of systems, enabling the oracle applicaatins to easily extract and transform the data
- Integrated Sybase developed solutions sets for the healthcare industry (HIPAA); financial (SWIFT, OFX); communications, where Sybase delivered the Communications e-Business Solution (CeBS) specifically programmed to answer the pressing needs of Healthcare Industry. Responsible for Merging the data from Sybase database to the Oracle database including the data modeling.
- Accoumplished Sybase data augmentation and migration to Oracle with post migration application tuning.
- Data Warehousing, Data Warehouse Database Sizing, Tablespace Management and Rollback Tablespace Management, Transaction Management, Security Administration.
- Extensive Performance Tuning, Memory (SGA) Tuning, SAN solution implementation, Tuning Concurrent Managers and setting up SAN environment.
- Defragmentation of database using export & import.
- Configure and maintain the clustered environment while doing data replication and migration.
- Data Modeling, Database Design and Creation. Deciding the naming conventions for Datafiles, Redo log files, Tablespaces, Segments.
- Unix Shell scripting in csh, ksh for automating startup/shutdown of databases.
Confidential, Los Angeles, CA
PRINCIPAL ORACLE DBA / APPLICATIONS DBA
- Managing the small & large projects working as Principal Oracle DBA on a 4.5 TB system using fiber optic disks. I also acted as backup Systems Administrator and performed Systems Architecture functions at the same time. Installation, Setup, Maintenance and Upgrade of Oracle Server 7.3.3.5 to Oracle 8.0.5, Oracle 8.1.5, 8.1.6(64bit/32bit), 8.1.7(64bit/32bit), Oracle Web Server3.0, Oracle Enterprise Manager, migrated 7 instances to ORACLE 8.1.5 and then to Oracle 8.1.6. and then to 8.1.7. Upgraded Sparc servers running SUN Solaris 2.5.1 to 2.6, 2.7 and 2.8 and PeopleSoft 7.56/6.10. Writing and maintaining PERL scripts to automate and parse the incoming data. Handling PERL programs to automate the backups or ARCHS to ATL3000 storage via LEGATO.
- Handled the Data Migration, both Physical/Logical, of 4.5 TB 2 times. Team lead in migration and Data/Users compatibility. Datafiles (VxFS) management by VERITAS volume manager. Building and managing mirrors by VERITAS volume manager. Work with the I.S. Controlling backups with LEGATO Networker services. Installation, erection and commissioning of New SPARC servers. Hooking up, maintaining and configuring the ATL 2000 backup device running LEGATO for production servers and clients. Configuring and using RMAN to take online backups of oracle databases and maintaining the logs. Configuring WebServers and using BEA Weblogic to support the online applications on OLTP server. Data migration from Sybase databases to Oracle databases.
- The main operations include Maintaining 8 Sun Solaris servers running on Solaris 2.7 and 2.8(64bit/32bit) with latest patches and 7 ORACLE instances on ORACLE 8.1.5 & ORACLE 8.1.6 & 8.1.7 out of which 2 are production databases of 3.5 TB in total and 5 test databases of 1500 Gigabytes. Responsible for Data Backups and Recovery of the whole system, both Decision Support and OLTP. Provide data modeling expertise to application development projects across the enterprise. Take part in leading Data Modeling projects for WEB (OLTP), Decision Support and CRM applications. Develop, maintain and publish guidelines, best practices and methodologies relating to data modeling for OLTP and Data Warehouse projects. Working with BUSINESSOBJECTS 5.0 and WebIntelligence 2.5 to generate reports and using hands on experience on Microstrategy.
- Planning and co-ordination of the Migration from one place to the other and to different servers and set of disk. Systems Architecture, Disk Layout Design, providing SAN solution, RAID configuration, Data Mirroring, Tablespaces Layout, Datafile Mounts Determination, Data redundancy, Entity relationship, Switching Users, Tuning (Hardware & Software). Application Support, and service areas to assess, design and integrate new technologies. Planning, Developing, Scheduling, Maintaining, Supervising and Supporting Complex Business applications running Oracle right from System Architecture stage to the User level support while maintaining the concurrency of the data.
- Administration and application tuning on Sun Solaris 2.6, 2.7 & 2.8 platforms with Veritas Quick I/O, EMC drives, Windows NT report server, Novell file servers, and Windows NT/95 desktops. Configure and maintain Application Servers and Process Schedulers and perform PeopleTools administration, Security, SQR programming, and database tuning, system configuration planing, and staff mentoring. Maintain 20+ databases totaling over 300GB, 12+ PeopleSoft UNIX accounts on production and development machines, and 11+ PeopleSoft file server code sets for 1000+ production users. Datawarehousing projects involving Microstrategy, COGNOS, Informatica and implementing web tools to design and successfully run the application. Designing, Scheduling and maintaining the WebInfrastucture to implement the complex business integrity rules for OLTP (24x7) web applications.
- Excution of ETL (extraction, transformation and loading) of data sets from different applications to a datawarehouse using Informatica. Using cognos reporting for extracting reports out of the datawarehouse. Building the databasehouse architecture for future growth and redundancy using OWB.
- Maintaining/Administrating 7 databases to total capacity 4.5 Terabytes running on Solaris 2.6 and ORACLE 8.1.5 and administrating 12,000 users. Doing data modeling and disk mapping for the new servers and creating new instances.
- Sybase to Oracle data migration of reporting system using E-business infrastructure.
- Post migration steps from Sybase to oracle and configuring the servers for mobile data transfer.
- Installation, Upgrade and Configuration of Oracle (7.3.2, 7.3.3.5, 8.0.5,8.1.5,8.1.6)
- Upgrade the servers to Solaris 2.6, 2.7 & 2.8 64bit with latest patches and to ORACLE 8.1.5, 8.1.6 & ORACLE 8.1.7.
- Database upgrades from Oracle 7.3.3 to Oracle 8i and lastly to Oracle 9i.
- Performed advanced replication of production in Oracle databases in clustered environment.
- Restoring the database partially/fully using nwadmin and nwrecover utilities of Legato along with command line interface.
- Setting up and Installing Oracle Web Application Server. Setting and Installing Oracle Enterprise Manager and Enterprise Backup Utility.
- Database Sizing, Tablespace Management and Rollback Tablespace Management, Transaction Management, Security Administration.
- Extensive Performance Tuning on application level and server level, Memory (SGA) Tuning, Tuning Concurrent Managers, etc.
- Working with OLAP technology and BUSINESS OBJECTS reports and query optimization.
- Building the ORACLE webbed severs and creating new databases for new applications.
Confidential, FL
SENIOR ORACLE DBA
- Installation, Setup, Maintenance and Upgrade of Oracle Server 7.3.3.5 to Oracle 8.0.5, Oracle Web Server3.0, Oracle Enterprise Manager, Space Manager, Oracle Backup Enterprise Utility, Oracle SQL Backtrack, Chain Link Object Migrator (2.0), Oracle Applications Datawarehouse, CITRIX 1.7
- Installation, Upgrade and Configuration of Oracle (7.1.6, 7.3.3.5, 8.0.5) and Oracle. Applied patches both Server side and Client side.
- Setting up new environments (Development, Testing, Conference Room Pilot, Production etc)
- Upgrading to Oracle Server 7.3.3.5. Installed and configured Oracle Web Server 3.0
- Migration of Sybase system to Oracle 8.0.4 using Sqlldr.
- Setting and Installing Oracle Enterprise Manager and Enterprise Backup Utility.
- Data Warehousing, Data warehouse Database Sizing, Tablespace Management and Rollback Tablespace Management, Transaction Management, Security Administration.