TECHNICAL SKILLS

HARDWARE AND OPERATION SYSTEM: Sun Fire V890 V245/V240, Sun Enterprise T5220, M4000, Ultra Enterprise Cluster, Sun Ultra Enterprise 5000, Sun Ultra Enterprise 450, Sun Ultra Enterprise 2, Sun Solaris 8/9/10/11, HP - UX 11i v1/v2/v3, HP RX6600 Itanium, HP 9000 L300, HP Integrity RX3600, 9000/800/L3000, Oracle Linux System 6.x/7.x, Oracle Linux server X4-2L/X5-2L.

PROGRAMMING ENVIRONMENT: Java, C, Pro*C, SQL, bash, Perl, Python, Oracle 7.3.4/8i/9i/10g/11g/12c, Oracle PL/SQL, SSMS, SSIS, T-SQL.

PROFESSIONAL EXPERIENCE

Oracle DBA and Unix/Linux System Administrator

Confidential

Responsibilities:

• During the 6 - years service in Keihin, migrated all HP-UX servers to Oracle Linux Servers, which include Oracle VM manager 3.2.9, Oracle VM server 3.2.9, Oracle Virtual Machines, Linux system, Oracle ASM, network configuration, and Oracle Enterprise database installation. Migrated Oracle databases from 9i/10g to 11g/12c for six plants
• Monitored and maintained HP RX6600 Itanium, HP 9000 L300, HP Integrity RX3600, 9000/800/L3000 by using HP-UX 11i v1/v2/v3 which runs Oracle Enterprise database 9i/10g.
• Responsible for the support of Oracle Linux system which runs Oracle 11g/12c. Wrote scripts and installed packages as needed. Provided technical assistance to developers/users with completion of their tasks. Monitored and tuned Linux system CPU, I/O, Memory utilization, Security and Storage management.
• Applying upgrade patch, maintenance patches (opatch) on all databases. Refreshing development and test instances with data from production databases on a regular basis.
• Monitor and maintain activities which include checking alert logs, space management, undo management, gathering database statistics, database locking issues, scheduling of jobs in crontab.
• Schedule recurring activities such as gathering database statistics, export, rman backup, table space usage report using crontab.
• Administer, monitor and maintain storage including local disk array, and database server. Perform routine maintenance, backup, recovery, and troubleshooting for all systems. Manage user accounts/privileges for administrator, developers and customers.
• Installed Data warehouse servers (Production and Development), which run Windows Server 2012/2016, and SQL server 2014(SP2) standard edition.
• Create Data Warehouse databases, SQL queries, SSIS program, and maintain Data Warehouse.
• Provide technical support and give directions to on-call System technicians as needed.

Unix Administrator

Confidential

Responsibilities:

• Responsible for the support of Sun Solaris 9, 10 (Sun Fire V890/V245/V240, Sun Enterprise T5220, and M4000) system and Oracle 9i/10g/11g Database on both production and Disaster Recovery Site. Wrote scripts and installed packages as needed. Assisted users to complete their computing tasks and management. Monitored and tuned UNIX system CPU, I/O, Memory utilization, Security and Storage management.
• Responsible for design, install, configure, administrate, tune, patch, and optimization of the Oracle Solaris 10 system servers and Oracle Database (Oracle Enterprise M4000 servers and Sun Storage 6180 arrays in both production and disaster recovery sites).
• Installed, configured, upgraded, migrated and patched Oracle databases in both production and disaster recovery environments. Migrated primary and standby databases from Oracle 9.2.0.8 to 11.2.0.1.
• Planned, Implemented and tested disaster recovery system, using RMAN and custom written shell scripts.
• Created and maintained Oracle DataGuard configuration.
• Monitored and tuned database by using TKPROF, OEM, STATSPACK and custom scripts.
• Developed and maintained the existing application by using Perl, JSP, SQL, and Oracle PL/SQL on UNIX/Linux platform.
• Monitored and maintained enterprise class storage including tape library, disk array, and database server. Performed routine maintenance, backup, recovery, and troubleshooting on all systems. Managed user accounts for administrator, developers and customers.
• Configured and maintained Sun One Application Server 7 and Sun One Web Server 6.1. Maintained Web application and Web site.
• Programmed shell and Perl scripts to automate log analysis, performance/security monitoring systems, and created business reports.
• Administered 200 lane PCs (MS Access + flat file systems), 25 plaza servers (Windows Server 2003/SQL Server 2000), and 8 central facility aggregation systems (Windows Server 2003/SQL Server 2000 + proprietary).
• Created, define, and maintained DTS packages on SQL Server 2000 environment.
• Participated in on-call rotation 24x7 on all equipment. Provided technical support and gave directions to on-call System technicians as needed.

Oracle Database Administrator

Confidential

Responsibilities:

• On the day-to-day basis, identified and corrected application and database performance problems. Monitor space usage, and perform capacity planning by running Oracle 9.2.0.4 on SUSE Linux.
• Administered Sun Solaris 2.6(Sun E450) UNIX system and Oracle 7.3.4. Wrote scripts and installed packages as needed. Assisted users with completing their computing tasks and management.
• Designed and developed generic schema for the company’s new products. Developed PL/SQL stored procedures, functions, packages, and triggers for data load, transformation, and data extraction. Optimized SQL queries for efficient data load for backend database. Provided interface queries and procedures for the front-end JSP application.
• Defined and implemented physical data model and ER diagrams for Oracle database systems.
• Developed multiple interfaces to external Oracle data sources by using Oracle Forms Developer 6i.
• Specified, designed, installed, upgraded, patched, secured, configured and maintained several GNU/Linux x86 systems (SUSE 7.2/8.0/10.0/10.2 , RedHat Fedora 3/4/5). Software used includes Apache 1.3/2.0 (with JRun and mod ssl), Weblogic server 8, SSH (OpenSSH), LILO, and GRUB.
• Engineered and implemented online and offline backup, recovery solutions, and nightly export. Automated support routines by using Oracle utilities and Unix shell scripts.

Systems Analyst/Programmer

National Programming Service

Responsibilities:

• Monitored and tuned database performance by using Oracle Tuning Pack, EXPLAIN PLAN, HINT, SQL, and PL/SQL scripts. Audited space utilization to determine needed space, to reclaim space, and to reorganize tables, indexes, and table spaces. Used Korn shell, SQL, and PL/SQL to analyze tables and indexes, and to identify when indexes needed to be rebuilt. Installed and maintained schemas and schema objects.
• Performed general system administration duties on Sun Solaris platform which included Sun Solaris 2.6 and Sun Solaris 7. Administered NIS, NIS+, and NFS. Managed IP addresses, installed operating systems, and third party software. Other duties included hardware installations, printer administration, technical documentation, and UNIX research. Performed Patch Administration to maintain network performance.
• Installed and imported the production database(Oracle 8.1.6) from Sun Solaris 2.6 on Sun E450 platform to Oracle 8.1.7 running Red Hat Linux 7.1 on Intel base server.
• Installed Sun Solaris operating systems, patches, and applications. Programmed Korn shell and Perl scripts to automate log analysis and performance/security monitoring systems. Monitored and maintained enterprise class storage including SCSI and RAID, e-mail server, database server, and DNS servers. Performed routine maintenance, backup, recovery, and troubleshooting on all systems. Managed user accounts for administrator, developers and customers
• Developed and maintained the existing application by using Oracle Pro*C, Oracle Form/Report developer, and Oracle PL/SQL on Sun Solaris platform.
• Engineered and implemented online and offline backup, recovery solutions, and nightly export. Automating support routines by using Oracle utilities and Unix shell scripts.
• Planned and implemented Oracle Server installations, database upgrades, and migrations. Migrated production Database Server from Oracle 7.3.4 to 8.1.7.
• Cloned, re-located, and re-built Oracle databases, and exported/imported data between Oracle database server 7.3.4 and Oracle database server 8.1.7.

System Specialist

Confidential

Responsibilities:

• Developed and tested web application by using Oracle WebDB and Oracle Server 8 on NT platform. WebDB is a web based database tool that provides solutions to common enterprise database administration and web application development problems from a browser interface.
• Administrated and developed Intranet Web Application for Tranex. Implemented dynamic Web forms with CGI by using Perl and ASP on IIS on NT platform. Used DBD and DBI for Perl, and ADO to access information from Oracle Server 8.
• Systems administration of internal NT 4.0 workstations, including software installation, administration and troubleshooting. The Tranex network consists of about 400 NT 4.0 workstations.
• Help - desk style customer support, including web site maintenance.
• Designed and developed a Help Desk Service Tracking application (DAO) using Visual Basic 5.0 and Access 97. The benefits of this system are:
• . Automated tracking of all requests.
• . Real-time monitoring of Help desk status / identification of bottlenecks before they reach a crisis status.
• . Users' perception of a fair, responsive, and efficient Help desk.
• . Complete documented record of any problem's history.
• . Management reports providing measurement of level-of-service, resource constraints, support rep' performance, and resources consumed.
• Worked as part of a team in designing and developing an Inventory Control application. Designed the tables, the relationships, and the forms. Tested the logical design using queries. Wrote code using Visual Basic 6.0 and SQL.