OBJECTIVE: Bright candidate with experience of CONFIDENTAIL, Oracle developer in most phases seeks challenging computer position with opportunities where proven skills and talents in computer applications programming and database system development will be mutual benefit.

COMPUTER Languages Operating System Database

• SKILLS: Pascal Fortran VAX/VMS Oracle 7.3/8/8i/9i/10G/11g
• C/C , SAS MS DOS Oracle Developer 2000
• COBOL, Perl Windows NT Sybase, PeopleSoft
• Visual Basic, SQL UNIX, LINUX Oracle Discover
• JAVA,ETL,XML SQL Server 2000 DB2, CICS

EXPERIENCE SUMMARY

• Comprehensive experience and skills as an oracle DBA and Application Developer on Oracle 7.x, Oracle 8, 8I Oracle 9I 9.2.05 , 10G, 11g R2 RAC, PL/SQL, SQL Plus, Developer 2000
• And Erwin, working with Oracle and release tools
• An Oracle DBA with Expert level skills in Oracle Database Administration, Oracle 11I E-business suit and PeopleSoft Applications.
• Installation of Oracle and related tools.
• Configuration and creation of database and upgrades
• Creating and Maintaining standby database.
• Database performance monitoring and tuning
• Database security administration.
• Database storage management
• Writing database procedure, functions, triggers, SQL and PL/SQL code.
• Write PL/SQL, SQl using Toad tool.
• Database backup and recovery with an without RMAN with VERITAS NETBACKUP
• Usage of diagnostic and monitoring tools
• Training and mentoring junior DBAs

PROFESSIONAL EXPERIENCE:

Senior Database Administrator / CONFIDENTAIL

• Work on , maintain CWGT database, in 9I, 10g and 11g R2 RAC environment and
• UNIX AIX platform
• Install and Configure ASM
• Confgiure and perform Oracle RAT
• Install RAC in Oracle 10g and 11g R2 inUNIX and Linux plate form
• Perform RAC administration
• Perform RAC backup and recovery
• Tuning RAC performance
• Conduct RAC troubleshooting
• Developing applications for RAC.
• Work on Carlson project, maintain 80 database with some of some are terabytes
• Work with leads to create implementation designs and work as head of a project team coordinating and overseeing the activities of other DBAs.
• Maintain and improve the performance of enterprise databases in both the transactional and inquiry only environment.
• Install configure Oracle 9i, 10G, 11g on UNIX AIX, Sun and Windows platform
• Configure and maintain SharePlex
• Work on Oracle Streams
• Work on and configure Oracle Advanced Queue
• Configure and design Oracle dataguard in 9i, 10g and 11g, install physical standby and logical standby
• Configure protection model.
• Install and configure VMWare
• Install , configure and maintain Shareplex.
• Install, maintain and troubleshoot relational databases and data replication processes.
• Interact with end users to troubleshoot reported problems or to perform required database maintenance activities.
• Implement and maintain security administration for database environment.
• Execute diagnostics periodically to guarantee database integrity
• Perform database object administration, change control and space management in the team members and other groups.
• Implement and maintain security administration for database environment.
• Implement database backup and recovery processes.
• Perform database consistency checking, loading and unloading of data.
• Formulate plan for database implementation/conversion strategy
• Oversee and perform database installation and configuration of database parameters including transaction logging, shared memory
• Monitors databases on a daily basis
• Develop and maintain a comprehensive database software inventory/library for all related support documentation and procedures.
• Conduct software audits of the database products for compliance with established standards, policies, configuration guidelines and procedures.
• Monitor and administer database performance, including storage, applications and network activity.
• Develop documentation including operations manuals, procedures and problem resolution.
• Escalate problems to senior technical team members and/or vendors in a timely fashion.
• Develop techniques and implement resolution of problems based on root cause analysis.
• Develop and design SQL, PL/SQL, designing function, stored procedure , trigger and package.
• Write PL/SQL, SQl using Toad tool.
• Provide on-call support for database.
• Perform data modeling using ERWIN.
• Support production database in 24 X 7 environment.
• Using snapshots to perform distributed database data replication
• Perform logical database design and physical database design
• Create and configure advanced replication sever. Implement data replication in high transaction environment.
• Configure Oracle Logminer and Flashback.
• Perform data loading in large database
• Implement Oracle Data Guard on 10g, configure logical standby and physical standby.
• Work on Storage Area Network: SAN and Network Attached Storage NAS .
• Setting up VLANs, VLAN trunking and tagging
• Backup, recovery and tuning oracle database
• Install, configure and use Oracle Enterprise Manager OEM .
• Configure Oracle Streams
• Configure Oracle 10g and 11g Grid Control
• Configure Oracle e-Business Stake 11.5.10/9iAS/10gDB in a RAC environment
• Develop and modify Oracle Financial module.
• Managing and customizing Oracle Financial applications environment
• Upgrading database to required DB version for 11.107 ERP applications upgrade and future upgrade to 10G.
• Perform upgrading Oracle 11i to Oracle Aps 12
• Perform Discoverer Upgrade from 3i to latest version.
• Configure BEA.
• Make installation and configuration Oracle Real Application Cluster RAC 10 and 11g R2
• Perform RAC administration and management
• Perform RAC troubleshooting.
• Coordinate development and installation of database technology with the Apps DBA.
• Interact with Apps DBA, Development and Infrastructure teams.
• Work on data migration projects on Oracle 10g an 11g R2
• Configure and implement DB security
• Work as Apps DBA.
• Develop Peoplesoft 9.0 and 9.1 Genera Ledger Accounts Payable financial system 9.0 9.1 projects and ongoing maintenance support.
• Perform PeopleSoft functional business analyst for PeopleSoft GL AP applications:
• Work on People Soft Purchasing and Inventory.
• Using application Designer to develop PeopleCode
• Configure and maintain PeopleSoft AP, PO, AR, GL, KK, BI Module
• Work as PeopleSoft Administrator and DBA , take responsibility for technical analysis, design, development, testing, implementation and post implementation support for PeopleSoft projects.
• Work on PeopleSoft Financial applications and HR applications.
• Customizing PeopleSoft-delivered applications
• Provide hands-on technical knowledge as well as manages client relationships within the context of the individual role.
• Install and configure PeopleSoft 8.48 and 9.0 9.1 in Windows and UNIX Sun Solaris, Install and configure PeopleSoft 8.48 and 9.0 9.1 BEA Web Logical, WebSphere, Tuxedo, Application Server, People Tool.
• Implementing Peoplesoft HR 8.X/9.X on IBM AIX 5L and 6.1 IBM pSerie.
• Configure and work on SOA
• Maintaining PeopleSoft application in production, test and development environments.
• Conduct Peoplesoft administration and tuning
• Configuring and maintaining Report distribution agent and maintaining report repository
• Work on Peoplesoft patch application and application updates
• Perform People tools upgrade , peoplesoft application upgrades
• Migrating data from Legacy systems to Peoplesoft
• Using SQR in PeopleSoft applications
• Provide and manage for best practices documentation of systems administration, on going changes and set procedures.
• PerformPeopleSoft implementations.

Senior Database Administrator

CONFIDENTAIL

• Under general direction of manager and technical leadership of other experienced team members to perform database administration and management tasks including: database installation, configuration, logical and physical database design, database backup/restore, replication and parallel systems
• Perform Oracle ERP database admin to ensure continuous 24X7 operation and availability in support of mission critical business applications within a team environment
• Install configure Oracle 9i and 10G on UNIX AIX , Sun Solaris and Windows platform
• Work on UNIX/LINUX/AIX configuration, remote boot, monitoring and logging.
• Work with 10g Grid control
• Install RAC in Oracle 9i and 10g inUNIX and Linux plate form
• Perform RAC administration
• Perform RAC backup and recovery
• Tuning RAC performance
• Conduct RAC troubleshooting
• Developing applications for RAC.
• Configure and maintain SharePlex
• Work on Oracle Streams
• Install , configure and maintain Shareplex.
• Configure and design Oracle Dataguard in 9i, 10g and 11g, install physical standby and logical standby
• Configure protection mode
• Design data warehousing database, create snowflake schema and star schema for data
• Warehousing
• Configure Oracle e-Business Stake 11.5.10/9iAS/10gDB in a RAC environment
• Develop and modify Oracle Financial module.
• Managing and customizing Oracle Financial applications environment
• Implement Oracle Human Resources and Oracle Payroll.
• Use Oracle Human Resources and Oracle Payroll.
• Use, implement, maintain and configure Oracle General Ledger
• Use, maintain and configure Oracle Cash Management
• Use, implement, maintain and configure Oracle Purchasing.
• Use, maintain and configure Oracle Inventory Control..
• Perform backup and recovery on Oracle Financial database.
• Do performance tuning on Oracle Financial database.
• Maintain and Configure Oracle Discoverer.
• Work on Oracle 9iAS web/application technology installations, problem analysis, problem resolution, configuration, tuning of 9iAS Jserv.
• Work as Oracle Application DBA, V. 11.5.9
• Execute diagnostics periodically to guarantee database integrity
• Formulate plan for database implementation/conversion strategy
• Monitors databases on a daily basis
• Monitors DASD utilization responsible for capacity plan/forecast
• Responsible for implementation, documentation, testing and deployment of backup and recovery procedures
• Tuning the performance of Oracle Application Server
• Architect, implement and support Oracle Grid Manager to support Oracle database environment at Communications Center
• Configure the application server components such as OPMN, DCM
• Work on Oracle Streams
• Configure Oracle 9i, 10g Grid Control
• Configure and implement database security
• HTTP,OC4J,Webcache,Discoverer, Oracle Forms services, Oracle Report services
• Perform logical and physical table and database design, Consult and contact with
• business analysts.
• Develop and design SQL, PL/SQL, designing function, stored procedure , trigger and package.
• Write PL/SQL, SQL using Toad tool.
• Provide on-call support for database.
• Perform data loading in terabyte database
• Perform data modeling using ERWIN.
• Support production database in 24 X 7 environment.
• Using snapshots to perform distributed database data replication
• Create and configure advanced replication sever. Implement data replication in high transaction environment.
• Configure Oracle Logminer and Flashback.
• Implement Oracle Data Guard on 9i and 10g, configure logical standby and physical standby.
• Design, document and enforce data security and disaster recovery plan with consideration for key dependencies.
• Plan and coordinate database changes, installation of upgrades, patches
• Configure and use Oracle Portal
• Use Small Computer System Interface SCSI
• Synchronized Database
• Design and write SQL. PL/SQL, procedure, triggers in Oracle Developer 2000.
• Use Oracle Graphics and Procedure Builder.
• Use SQL Navigator.
• Work on Oracle Discover
• Install, configure and work on Oracle Designer 2000.
• Maintain Oracle Designer 2000.
• Backup, recovery and tuning oracle database.
• Perform data migration on Oracle 9i and 10g
• Install, configure and use Oracle Enterprise Manager OEM .
• Architect, implement and support Oracle 10g Real Application Clusters as well as Oracle 10g Data Guard on Sun Solaris and IBM X-Series Linux servers to provide uninterrupted database access
• Use RMAN to perform Oracle backup and recovery.
• Configure Oracle replication server
• Tuning oracle database
• Schedule and perform DBMS upgrades.
• Establish access permissions for the database environment.
• Support users and programmers
• Install Oracle and related tools, upgrading the database and applying patches as and when required.
• Planning and creating logical and physical structure for the production and test database, write stored procedure, functions, triggers, PL/SQL and UNIX shell scripts.
• Deciding the backup and recovery strategy and implementing it.
• Design and implement Disaster Recovery solution
• Using SQL loader and interface tools for loading data from external system into the Oracle database
• Set up OEM to administrator around 18 databases for production, QA and Development environment.
• Prepare for program specification.
• Coordinate with users, client managers and other module leaders.
• Reverse engineering of the complete application using Erwin.
• Use an ETL tool such as Informatics as the automation and management of the complex ETL process, especially in a large environment which leads to faster development cycles and the ability to produce prototypes in the least possible time
• Use Oracle streams to streamline information-sharing environment and applications
• Developer 2000, PL/SQL, reports and forms designing.
• Implements Open database Connectivity ODBC to allow MS Excel database to access Oracle compliant data sources
• Generates academic reports using Oracle Reports 6I and 9i
• Provides guidance on creating an oracle Data Warehouse
• Generates, upgrades and converts Oracle Forms 6 and 91 Menus and PL/SQL libraries.
• Perform logical database modeling and data warehouse designing
• Design data warehousing database create snowflake schema and star schema for data
• warehousing
• Use ETL, time series data management and retention.
• Using Crystal Report Enterprise Edition 9.0, rewriting existing reports and as well as writing some new ones. Pulling data from SQL Server , Oracle and DB2 databases.
• Support night batch projects
• Work on Microsoft Excel for manipulation of data
• Create and maintain PeopleSoft Application 8.9 experience.
• Configure and maintain PeopleSoft AP, PO, AR, GL, KK, BI Module
• Work on Peoplesoft 8.8 CRM
• Support the upgrade of the PeopleSoft System
• Upgrade PeopleTools, Install and Configure PeopleSoft V8
• Work on PeopleSoft Financial applications and HR applications.
• Work on PeopleSoft applications HCM 8.9, Portal 8.4 and CRM 8.8.
• Work on CRM, Use Oracle's PeopleSoft CRM product line to support PeopleSoft's HR and ERP suite.
• Configure Oracle's PeopleSoft CRM solution to support applications
• Configure and work on Peoplesoft ESB
• Configure and work on SOA
• Customizing PeopleSoft-delivered applications
• Using SQR in PeopleSoft applications
• Using SQR in PeopleSoft applications.,running SQR programs in PeopleSoft applications.
• Perform the migration of PeopleSoft objects across multiple development, test, QA and production environments Implement and maintain PeopleSoft Security.
• Perform full lifecycle PeopleSoft 8.x implementation.
• Implementing PeopleSoft EPM, Financials and Supply Chain
• Defining systems strategy, developing systems requirements, designing and prototyping, testing, training, defining support procedures, and implementing practical business solutions under multiple deadlines.
• Support users and programmers

Database Administrator /Developer

CONFIDENTAIL

• Develop and maintain multiple Oracle database in development, test and production environments Using Oracle 8.05, Oracle 8.16 and Oracle 9I
• Install configure Oracle 8i , 9I on UNIX Sun Solaris platform
• Install configure Oracle 8i and 9i on AIX platform
• Install configure Oracle 8i and 9i NT /window 2000 platform.
• Work on UNIX/LINUX/AIX troubleshooting and security.
• Writing UNIX scripts and .. Write, maintain OS level scripts UNIX shell for system DB maintenance.
• Maintain online trade application in Oracle 9i,
• Act as project leader for designing application, building application, testing the application, deploying the application and maintaining the application. Coordinate
• With programmer and business analysts.
• Design data warehousing database create snowflake schema and star schema for data
• Warehousing
• Work on Oracle 9iAS web/application technology installations, problem analysis, problem resolution, configuration, tuning of 9iAS Jserv.
• Work and configure Oracle Real Application Cluster RAC 9i.
• Monitor and tune oracle application server
• Design and maintain database of fixed income application
• Install and maintain Oracle Developer 2000.
• Design and develop Oracle Developer 2000 applications.
• Install and maintain Oracle Designer 2000.
• Design and write SQL. PL/SQL, procedure, triggers in Oracle Developer 2000.
• Use Oracle Graphics and Procedure Builder.
• Work with Apps DBA and extended infrastructure team to coordinate upgrades, pateches and resolve any cross function issues.
• Develop document, and enforce database standards and procedures.
• Develop DB and ERP infrastructure testing plans.
• Ensure availability of current and accurate data.
• Perform database cloning, schema and table level data refreshes
• Use Monitoring tools such as: OEM, Mercury Interactive, Quest.
• Support night batch programs
• Work on ETL.
• Work on Oracle Discover
• Implement Oracle Data Guard
• Configure data migration
• Install, configure and work on Oracle Designer 2000.
• Maintain Oracle Designer 2000.
• Perform logical and physical table and database design, Consult and contact with
• business analysts.
• Develop and design SQL, PL/SQL, designing function, stored procedure , trigger and package.
• Provide on-call support for database.
• Perform data modeling using ERWIN.
• Perform logical and physical database modeling.
• Support production database in 24 X 7 environment.
• Using snapshots to perform distributed database data replication
• Create and configure advanced replication sever. Implement data replication in high transaction environment.
• Maintain Oracle 8I and 9I database for internet application with heavy OLTP, 250,000 transaction per day.
• Translate logical database requirements into physical designs and implement the physical designs on the database servers.
• Performance backup and recovery.
• Do performance tuning.
• Configure and setup standby database.
• Set up EMC solutions for backup.
• Install, configure and use Veritas NetBackup software
• Integrate legato network with Oracle recovery manager. RMAN
• Write RMAN scripts to schedule enterprise backups and recover the database from
• the disaster
• Use, Administer and support Pro C
• Perform database tuning, including application, SQL application tuning, memory and storage tuning, I/O tuning.
• Design and run explain plan and execution plan to perform optimization.
• Work with UNIX system administrator to perform system backup and other task.
• Migrate and upgrade oracle database using ODMA
• Loading data into oracle table using ODBA and OLEDB.
• Design configure partition tables and partitioned indexes.
• Install and configure legato network.
• Configure Oracle Enterprise manager to monitor and administer Oracle NT server and UNIX server
• Auditing and tuning oracle performance.
• Implement Oracle web server which connect to internet.
• Configure Oracle Logminer and Flashback.
• Configure and use Oracle Portal
• Synchronized Database
• Configure and set up Oracle Parallel Server.
• Perform advanced data replication
• Perform advanced Failover Methods, using Oracle Parallel Server for Failover, Implementing Failover using Oracle replication
• Design data warehousing database create snowflake schema and star schema for data
• warehousing.
• Design and develop Oracle financial applications using Oracle Financial 10 and 11 package.
• Configure Oracle CRM.
• Install Oracle patches.
• Migration from Oracle 7 to Oracle 8I, upgrading Oracle from 8.i to 9i.
• Oracle Web designing, using Cold Fusion software and through Oracle Web server.
• Perform problem resolution in support of customers
• Install and Configure Oracle 9 i RAC.
• Write Oracle RAC startup scripts
• Perform Oracle RAC operation
• Ensure continuous 24 x 7 operation and availability of ERP business systems and all interfaced systems.
• Perform implementation of new databases as well as providing maintenance for existing databases, implementation and maintenance of Oracle security.
• Execute day to day DBA duties in multi-instance production and development environments
• Create and design Crystal Report.
• Design a project using JAVA programming to trace the online trading of mutual fund and stock.
• Design and develop J2E applications
• Write UNIX shell scripts, including Korn shell and C shell programming.
• Write AWK, Nawk, Gwak scripting language in SVR4.
• Maintain SQL server 7 and SQL server 2000, backup and tuning SQL server, perform
• technical support.
• Install and configure PeopleSoft
• Maintain and tuning PeopleSoft, Training users to use PeopleSoft.
• Design Cold Fusion web application development
• Installing Perl on a Unix system.Installing Perl for windows.
• Using different debuggers to debug Perl.
• Using Perl modules from CPAN Comprehensive Perl Archive Network
• Importing Modules, symbols and Tags in Perl.
• Creating and using subroutines.
• Working with files and I/O in Perl.
• Installing DB2 UDB
• Configuring DB2 Administrator Server
• Creating DB2 file system
• Enabling Portable Streams Environment PSE .
• Installing procedures common to both NT and AIX.
• Installing DB2 UDB Client Application Enabler CAE
• Using DB2 backup database smartguide and backup database notebook.
• Using DB2 Restore Database SmartGuide and Restore Database Notebook
• Perform export and import data from DB2.
• Tuning on DB2 Universal database performance.
• Work with cross project teams to resolve technical performance issues/bottlenecks such as Networks, storage application.
• Using Crystal Report Enterprise Edition7.0, 8.0 and 9.0, rewriting existing reports and as well as writing new ones. Pulling data from SQL Server , Oracle and DB2 databases.

Database Administrator/Developer

CONFIDENTAIL

• Installed Oracle 8.0.5 in NT and UNX platform
• Creating and designing Oracle database using Oracle 7.3 and Oracle 8.05
• Create Oracle objects such as tablespaces, tables, indexes, views and user accounts
• following defined standards and scripting procedures.
• Perform problem resolution in support of customers
• Installing and upgrading the Oracle 7 server and application tools.
• Installing and upgrading the RDBMS and work with Oracle networking configurations.
• Creating primary database storage structures.
• Allocating system storage and planning future storage requirements for the database system
• Modifying the database
• Using snapshots to perform distributed database data replication
• Controlling and monitoring user access to the database
• Backing up and recovering database.
• Maintaining system security
• Optimizing database performance.
• Uses SQL, PL/SQL designing function, stored procedure , trigger and package.
• Part of a team that designs, develops and enhances Oracle database and applications. developer 2000, PL/SQL, reports and forms designing.
• Implements Open database Connectivity ODBC to allow MS Excel database to access Oracle compliant data sources
• Generates academic reports using Oracle Reports 2.5 and 3
• Provides guidance on creating an oracle Data Warehouse
• Generates, upgrades and converts Oracle Forms4.5 and Forms 5, Menus and PL/SQL libraries.
• Designs and develops Oracle Data Warehouse.
• Migrate a MS access database to an oracle database using Oracle migration tool for MS Access
• Establishes procedures and Graphical User Interface GUI standards to be used for Software development and testing.
• Design and maintain Sybase database, perform backup and recovery, do performance tuning
• Developed and designed JAVA program.
• Served as SQL Server 6.5 administrator.
• Installed SQL server 6.5, backup and tune the SQL sever database.
• Maintaining and tuning PeopleSoft.
• Participated in developing a comprehensive financing software application using VB 5 and 6.0, RDO, ODBC, activeX technologies, Visual SourceSafe, third party components and VA Spread in Windows NT 4.0, responsible for creating and coding GUI of the system in VB 5.0, writing ActiveX components, writing a genetic file import utility for the application creating tables, views, server-side cursor and complex stored procedures.
• Designed and developed an inventory control system for the company using VB 5.0
• Using RDO, ODBC and OLE technologies in window NT
• Participate in designing and developing company's intranet using Microsoft Front Page, HTML, VB Script, ActiveX, Active Server Pages, ADO, InterDev 1.0 and SQL 6.5
• Developed and implemented a customer information and invoice tracking system for the company, using visual basic 4.0 DAO and access 2.0
• Designed and developed C /C program
• Create and maintain Sybase database
• Installing Sybase on UNIX and Windows NT server.
• Using the Performance Options of Sybase's ODBC Driver.
• Testing a connection through ODC to Sybase.
• Performing Sybase application partitioning.
• Installing Sybase Replication Server
• Using DBCC with Sybase SQL Server Manager.
• Maintained DB2 database to support COBOL programming, designed COBOL project, using CICS.
• Write and develop COBOL programming.

CONFIDENTAIL

Financial Analyst

• Analysis insurance ,mutual fund, and a variety of investments.
• Conducted stock research and updated various transactions.
• Contacted potential clients and assisted in establishing a client base
• Implemented procedures for the organizations of the client holdings.
• ..