SUMMARY:

• Professional background of over fifteen years productive experience in all aspects of Oracle database administration in a fast growing 24/7 environment.
• Currently hold Oracle Certified Professional (OCP 7.3.4,10G and Oracle RAC Administration)
• Database Administrator with extensive background in Oracle database management.
• Team player attitude with the ability to work independently.
• Master Degree in Computer Information Systems. .
• Have completed many projects with full life cycle
• Ability to effectively communicate with peers and management.

TECHNICAL SKILLS:

Applications: MS Office, PeopleSoft, SCT Banner

Languages: SQL, DML, DDL

Databases: Oracle 7/8i/9i/10g/11g, Oracle 12C RAC

Utilities: RMAN, Export, Import, Data Pump, SQL*Loader, OEM, Grid Control

Tools: Toad, Erwin, VPN, Hummingbird

Operating Systems: Sun Solaris UNIX, Windows XP/NT, UNIX, Linux, HP - UNIX, VMWare

PROFESSIONAL EXPERIENCE:

Oracle database administrator

Confidential

• Use/manage Autosys to manage/schedule jobs Have trained in Oracle Golden Gate Set up Data Guard at Disaster Recovery site. Set up TDE (Transparent Data Encryption) in Oracle 12C pluggable database.

• Install Oracle 12C container, pluggable, 2 nodes RAC GI, ASM, databases. Convert/migrate/upgrade non-CDB 12C to CDB (Container Database) 12C Have trained in Oracle Data Guard Administration  Use RMAN duplicate active database 11G new feature from QA to Test database Install and configuration of Oracle databases for RAC and non-RAC environments with ASM from new Virtual Machines to OEM agent installation,
• Monitoring with notifications to limit impact on the business and other IT teams. Support/install 11g/12c RAC/12C container database/CRS/ASM and Non-RAC and Grid Infrastructure database administration including user access controls. Help Unix Admin to set up Red Hat Linux 6.4 requirement for Oracle. Install new agent, set up monitoring thread hold for new host, database in Oracle Enterprise Manager Cloud Control 12C Use OID (Oracle Internet Directory) manager to update LDAP for new database.
• Use Toad 12.5 Xpert edition DBA Admin module to create users etc. Involve in Disaster Recovery Drill Migrate different version databases to different location.
• Upgrade and Patch PSU to different version of 12C, 11R2 GI, ASM and databases.
• Migrations of existing Oracle regular ASM disks in old SAN to Solid Sate Drives.
• Support implementations on and off-hours including on-call rotation within the database administration team.
• Work with Business Owners to determine downtime and/or project changes and implementation including communication and follow-up.

Environment: Oracle RAC, ASM, GI 12C, 11R2, Oracle OEM Cloud Control 12C, VMware, Red Hat Linux

Senior Database Administrator

Confidential

Responsibilities:

• Use RMAN to duplicate production database, install Oracle 11R2, upgrade and apply latest patches (PSU) to the duplicated database in Red Hat Linux environment.

• Have trained in University of Michigan healthcare system LEAN program.
• Certify in ITIL v3 Foundation.
• Provide/Suggest/Demo the better and most current technology to the group. Ex: PSU patching
• Install and configure newer java, MySql ODBC for Oracle and ODBC Driver Manager in Linux Red Hat.
• Install and configure Oracle Data Gateways 11.2.0.3 in RedHat Linux environment to connect to MySql.
• Install MySql in Linux, create database etc in testing environment.
• Create PostgreSQL database, users etc in testing environment.
• Create Data Dump/backup for MS SQL server database.
• Create and configure databases using DBCA.
• Have migrated Oracle database from BlueArc storage to NetApp storage.
• Support on-call.
• Work with Oracle SR.
• Have experience with NetApp storage and NFS file system.
• Work with group to formulate project plans and procedures/checklist.
• Research Database technology, propose changes and develop implementation plans.
• Zingerman's Zing Training.

  Env: Oracle 11GR2, Red Hat Linux, VMware, Windows Server, MS SQL 2005, MySQL, PostgreSQL

Senior Oracle DBA

Confidential,Southfield, MI

Responsibilities:

• Support Dow Chemical SAP BI/BW High Availability implementation in Oracle 11GR2 RAC HP UNIX environment.

• Coordinate and apply OS/DB Patches with China DBA/India DBA and IBM.
• Create case for HP Polyserve for MS SQL server etc
• Manage MS SQL 2000, 2005, 2008
• Install and configure MS SQL Server Reporting System (SSRS)
• DR (Disaster Recovery) in IBM Southfield DR room as Group Lead/primary DBA to recover Dow SAP BI/BW Oracle RAC Database in HP UNIX environment.
• Use Oracle Grid Control for AWR, ADDM and other activities.
• Trouble shooting RMAN backup and recovery.
• Work with Auditor for SOX Compliance.
• Support on call

Environment:: Oracle 11GR2, 10G, RAC, MS SQL Server, HP UNIX, Windows

Confidential,Dearborn, MI

Consultant as Senior Oracle DBA

Responsibilities:

• Assist in the IT transition /migration/data separation of Jaguar Landrover from Confidential Motor Company (SWIFT project).

• Work with developers to define and maintain environment in Oracle Application server for application development and testing.
• Decrypt the dumpfiles using fmccrypt and private key to refresh data.

Environment: Oracle 9i, 10g, 11g, AIX, SESU Linux, Red Hat Enterprise Linux, Oracle Enterprise Linux, VMware server, workstation., Oracle 9i,10i Application server.

Work as a Consultant

Responsibilities:

• Upgrade Oracle 10G test database to 11G test database using DBUA.

• Upgrade desktop server RAM to 2G, add in 2nd hard drive to make more space for install VMware etc
• Install VMware, create virtual machine RAC1, RAC2
• Install and configure Oracle Enterprise Linux in Virtual Machines
• Install Oracle Clusterware, Oracle RAC, and ASM by using Oracle Database clustering technologies.
• Backup recovery using Recovery Manager (RMAN)
• Keep abreast of Oracle’s direction and latest technologies.
• Oracle Certified expert in RAC administration.

Environment: Oracle 9i, 10g, 11g, Red Hat Enterprise Linux, Oracle Enterprise Linux, VMware server, workstation.

Oracle DBA, Information Specialist

Confidential,New York.

Responsibilities:

• Work on Oracle 9i, 10g databases server in UNIX Sun Solaris, OLTP environment.

• Assist in the development and modification of XCS databases to meet Xerox production needs
• Manage extensive modifications
• Provide on-going support
• Review other DBA’s scripts and executions

Environment: Oracle 9i, 10g, UNIX Sun Solaris.

Confidential,Detroit, MI

Oracle DBA

Responsibilities:

• Provide on going technical database support for the GM OnStar operational and ITIL process in the areas of database design, database security, data integrity, creation and maintenance of physical data models, database backup and recovery, performance tuning, and troubleshooting.

• Support GM PCI SolidCore implementation and participate in project planning and technical implementation. This support includes the following Application activities; Install Oracle server, performance tuning, CPU patches and upgrades, setups, monitoring, TAR support with Confidential, script review and execution, capacity planning, troubleshooting and maintenance. Create SolidCore databases, set up hot backup, archive log to ensure Oracle databases and systems meet business requirements and agreed service levels.
• Implement GM Web Destination Entry project (called eNAV) also participate in the processes for extracting, cleaning the data to the Data Warehouse. Communicate formally with customers’ priorities, commitments and changes to plans to make sure comply with Sarbanes-Oxley.
• Support projects as required (launches, upgrades, product transfers, etc.)
• Coordinate with Vendor DBAs as required.
• Recommend and justify upgrades and implementation of new features and tools.
• Participate in reviews of database changes. Participate in reviews of processes against the data.
• Write Korn Shell scripts to extract data, compress it, ftp to destination server, determine mount point, volumes etc for the project.

Environment: Sun Solaris UNIX, Oracle 9i, 10g, Export, Import, HP-UNIX, EMC SRDF and BCV technologies

Confidential,Troy, MI

Oracle DBA

Responsibilities:

• Support the Confidential (GSSM) Business to Customers (B2C) sub contract.

• Provide 24/7 supports of Oracle databases on UNIX servers for 33+ General Motor’s websites. This environment was a multiple global vendor environment that posed many challenges.
• Write/modify UNIX scripts; adhere to existing promotion processes in Oracle 9i, HP and Sun Solaris OS environment.
• Provide On-call support.
• Provide solution, back out plan, verification plan to each operation service request.
• Use Oracle OEM for part of solutions. For example: set up repository tablespace and user for Oracle OEM change manager to compare databases.
• Apply Oracle Patches.
• Start and stop Oracle application server concurrent manager to load and publish data.
• Use RMAN to retrieve archived redo logs, and then set up logminer to trace user activities.

Environment: Oracle RMAN, LogMiner, 9i, OEM, HP-UNIX

Confidential, Ann Arbor, MI

Database Engineer

Responsibilities:

• Analyze, maintain complex cost effective enterprise database solutions to meet more than four thousand established hosted system architecture requirements for availability, manageability, recoverability, monitoring, scalability, security and reliability.

• Provides ongoing support of the databases and database servers for systems which includes performance monitoring, performance tuning, troubleshooting and client support in production of Oracle UNIX SUN Solaris, NT environment and MS SQL server.
• Support operation room activities for client 1 outage or escalated critical cases.
• Perform database administration on all database systems and maintain all client database
• Provide on-call support.
• Create, restore MS SQL database.
• Archiving, backup / recovery, refresh, cloning, import/export and remove obsolete database Oracle databases.
• Use Veritas NetBackup 5.1 to restore files, which is not in the current system.

Environment: Sun Solaris, NT, MS SQL server, Oracle 8i, 9i, Veritas NetBackup

Confidential, Southfield, MI

Consultant

Responsibilities:

• Support on company’s Oracle 9i projects.

• Provide on-call support as needed, ongoing support of the databases and database servers for systems, which includes performance monitoring, performance tuning, troubleshooting and client support.
• Perform database design and development, database administration, software design and development, and customer support.
• Administration of database objects such as indexes, tables, views, constraints, and stored procedures.
• Create and Administrate of database users

Environment: Oracle 9i, Window NT.

Confidential,San Jose, CA

Contractor

Responsibilities:

• Research and evaluate new tools/technologies for database relocation.

• Prepare and perform database capacity studies and planning for management review and approval. The project was on and off and did not finish because of company’s financial difficulties.

Confidential, Ann Arbor, MI

PeopleSoft/SCT Banner/Oracle Database Administrator

Responsibilities:

• Work with consultants to implement PeopleSoft and SCT Banner ERP software.

• Support PeopleSoft and SCT/Banner2000 implementation in a UNIX SUN Solaris environment, save million dollars for the implementation. Go live within time frames.
• Install, configure Oracle 8.0.5 database server on SUN Solaris.
• Perform disaster recovery and restore data files when required. Often have to work overtime and perform duties after hours to be successful with these production support issues.
• Apply patches on Oracle Database Server v7.3, OCP in 7.3.4
• Perform production and test database changes such as modifying objects, tables, indexes, and views to ensure data integrity and object security.
• Troubleshoot Oracle database problems.
• Work with Confidential on technical support issues.
• Install, configures Oracle 8.0.5 client on PC in Windows 95 environment.
• Clone PeopleSoft, SCT pre-production database to be production database on the same or different UNIX machines.
• Work as part of a team and to perform a full range of database analysis and management tasks.
• Perform PeopleSoft and SCT Patches, Fixes and Upgrades as required.
• Create PeopleSoft/SCT Banner databases and set up user Ids, and securities. (Create and maintain users, roles and, assign privileges and permissions).

Environment: PeopleSoft, SCT Banner, Oracle 7.3, Sun Solaris

Confidential, outhfield, MI

Associate Consultant

Responsibilities:

• Perform database design and development, database administration, software design and development life cycle, and customer support using a variety of Confidential software products including SQL Server, SQL Anywhere, Power-Designer, and PowerBuilder.

• Assign to the following projects while at Confidential:
• Work on a PeopleSoft HRMS implementation for DMB&B.
• Function as one of the PeopleSoft HRMS implementation team leaders.
• Design, build, test and analyze database to support Human Resource activities.
• Use PeopleSoft import manager tool to manipulate, transfer and clean data sets within and between these systems while assuring data consistency and quality.
• Work on the Jockey Club Project and was assigned to work on debugging complicated stored procedures. Receive high marks from team/group leader.
• Work on the State of Michigan Commissary Project to help improve the performance and make changes to the Daily Sales Report.
• Improve the performance of the report and satisfy the clients’ request to their satisfaction.

Environment: Confidential, SQL Anywhere, Power-Designer

Lab Consultant/Graduate Assistant at Eastern Michigan University

Responsibilities:

• Design and maintain the CRS library database.

• Conduct ICPSR database requests and file transfers, set up Caucus conferences for staff members.
• Develop and maintain the CRS database using MS Access, Telnet and FTP, and set up Caucus in UNIX.
• Perform Internet searching and downloading of information, assisted with workshops, assist with the use of scanners, and install a variety of software on both Macintosh and Windows PCs.
• On a Graduate School Project functioned as a Project Leader and convince a local corporation (SSC) to allow a team of EMU students to develop a software system to meet their requirements. Lead the team in the analysis of an old reporting system and develop the specifications for a replacement system that the team developed using MS Access in a Windows 95 environment.

Environment: MS Access, FTP, Macintosh, and Windows