SUMMARY:

Over 20 years of Web Application Administration, Web application development, Business Systems Analyst, System Administration, Application Administration and Database Administration.

TECHNICAL SKILLS:

Languages: C, Java, Java Script, SQL, PL/SQL, ISQL, TSQL, SQR, Perl, Shell Script, HTML, ASP, C#, Web Service, XML, CSS, XSLT, ColdFusion, JSP, PHP and Python.

Operating Systems: UNIX (SGI, Solaris, Sun OS, HPUX, Linux), Windows 2003/2008/2012 server, Windows 2000/XP/Vista/Windows 7/Windows 8/8.1/Windows 10,, MS - DOS and Mac OS.

Systems: SGI (Origin, Challenge, Indy, O2), Sun (Sparc 2, Sparc5, Sparc 10, Sparc 20, Ultra 5,E250, E450, E3500, E4500, Netra T1, SunFire), HP (A-Class, R-Class, L-Class, N-Class, DL380 G5,6,7,8,9) and Dell.

Network: LAN, TCP/IP, IPX, Ethernet, VPN, WI-FI wireless, ISDN, DNS, PPP, PPPoE, HTTP/S, Telnet, LDAP, Checkpoint Firewall, Livingston Firewall, SMTP, Livingston router, Cisco, HP, FTP, SSH, Sendmail, Samba and DHCP.

Web Servers: Netscape web server, Directory server, iPlanet web server, Apache, IIS 6/7, Tomcat, Oracle WebLogic Server 11g, Sun Java Web Server and J2EE.

Database: Oracle 7.3.x to 9i, MySQL 5/6, MS-SQL 2000/2005/2008 R2/2012R2 and MS Access, SSIS, SSRS and SSMS

Applications: Microsoft Office 2003/2007/2010/2013 , Lync, Outlook, Microsoft Word, PowerPoint, Excel, MS Project, Microsoft CRM 3.0, Microsoft Office SharePoint Server (MOSS 2007/10/13), Microsoft Virtual PC, TOAD, TOAD for Data Analysts, Putty, Internet Explorer, Firefox, Macromedia Director, PhotoShop, Texis, Webtrends, ColdFusion application server, Dreamweaver MX, FRX, Clarify CRM, Remedy, Crystal Report, Seagate Info server, Visio, PGP, SSIS, Business Object Designer, Insight software report server for JDE, Visual Studio 2005/2008/2010/2012 , Splunk and WIKI.

WORK EXPERIENCE:

Confidential, Roseville, CA

SQL DBA

Responsibilities:

• Member of Global I.T. Delivery DBA team.
• Install and configurated MS SQL database.
• Moving and migrates MS SQL 2008 and 2012 databases on stand alone, failover cluster and Always on environments.
• Database Performance tuning.
• Perform DDL and DML changes
• Database Log Shipping, backup and restore.
• Database monitor with SCOM.
• Collaborate with application teams on projects.

Confidential, Palo Alto, CA

SQL DBA / Database developer / Infrastructure

Responsibilities:

• Member of Confidential GEO DevOps team involved with all database related systems and developments.
• System administrator for Windows and Linux server. Plan and spec hardware requirement for database systems.
• Configure server and create RAID using ILO.
• Install server operating system and database for database systems.
• Relational database design, architecture and administration. Install database on VM for database development environment.
• Manage VMs using VSphere client and VCenter.
• Administrate continue build environments with Jenkin and GIT.
• Deployed test and build virtual environments with Chef server.
• Experiment with AWS for test and development environment.
• Database Administrator for MYSQL, MS SQL database, SSIS and SSRS. Develop ETL packages with SSIS and Power Shell script to integrate data from different data source into MS SQL 2008 R2 database. Develop reports and deploy to SSRS.
• Plan and deployed database backup strategies for MS SQL and MYSQL database.
• Upgrade MSSQL database server from 2008 R2 to 2012.
• Development planning using Agile Scrum Methodologies.
• Develop tools and .NET web application with C# from business requirements defined by users.
• Collaborate with other business groups to on data sharing and integration.
• HP ALM administrator for business unit.
• Export defect data for multiple projects then imported into SQL database through SSIS for reporting using SSRS.
• Rally Workspaces administrator for business unit.
• Extract defect and test case data from Rally using Python and REST API then imported into SQL database via SSIS for reporting using SSRS.
• Create reports and metrics for the development and QA team.
• Jira administrator for business unit.
• Resolve network issues on labs.
• Maintain server and network hardware inventory using Racktables.
• Installed and configured Windows 2008 R2 and Windows 2012 server.
• Administrator for sub domain controller. User access control for file shares on file server.
• Communicate with Global Cyber Security to ensure all labs networks and servers are in compliance.

Confidential, Campbell, CA

Senior Applications Developer / SQL DBA

Responsibilities:

• Member of the corporate IT team, oversee all Web related systems, development, applications, tools, and databases on administration and maintenance.
• Perform install, configuration, performance turning, upgrade, maintenance and monitoring on MSSQL 2005 database for company s ERP system.
• Plan and configured standby database using transaction log shipping for the ERP system for system redundancy.
• Plan and configured different backup methods (full backup, differential backup and log backup) for Oracle, MSSQL and MySQL database to minimize data lost and provide quick restore in case of hardware failure.
• Administrate databases using Oracle Enterprise manager, Microsoft SQL Server Management Studio, MySQL Admin and MySQL Workbench.
• Provide databases environment and system performance turning in Windows server 2003/2008, Sun Solaris 9/10 and Linux Centos 5 servers.
• Setup email alerts to be send in case of any database issues. Work with systems administer on network, firewall and system changes.
• Provide data extract from database per user request, using SQL, PL/SQL, PERL, SQR and Shell scripting.
• Created web interface using ColdFusion, SQR, Perl, shell script, SQL loader and SSIS to allow user do batch data load in Confidential, Excel and flat file then process data with well define process flow and work flow.
• Install, setup, administrate and tuning of web servers (Apache, iPlanet web server, IIS, Drupal and WordPress).
• Part of the Confidential ERP project team that migrate from an older and smaller ERP system, participle on database setup, data conversion mapping, migration and data integration with in house commission tracking application.
• Plan, install, configure and administrator Oracle UPK basic server. Perform Insight software report server upgrade and administration. Create and maintain Income Statement, Balance Sheet reports, Sales Analyst reports and Inventory reports created with Insight software for Accounting Department. Plan, Install and implemented Microsoft Office SharePoint Server 2007 (MOSS 2007) Administrate, manage user and group permissions, created team site and sub - sites on Microsoft Office SharePoint Server 2007
• Perform administration on Netscape web server and development on company s web portal using Java, Java Script, JSP, XML, XSLT and SOAP.
• Developed and maintain Co-Op Accrual process and statements to agents for the company s wireless division in the commission tracking application using ColdFusion application server, Perl, PL/SQL and ColdFusion.
• Resolve tickets submit on Helpdesk system related to database, data request, web and others.

Confidential, Mountain View, CA

Web Administrator

Responsibilities:

• Developed new Extranet using IIS and ColdFusion MX server with SQL 2000 server.
• Using Dreamweaver MX as development tool in conjunction with Java script and ASP.
• Installed and configured ColdFusion MX server. Installed and configured MS SQL 2000 server.
• Create database schema for Extranet.
• Plan and setup database backup use Database maintenance plan.
• Plan and setup database replications for high availability.
• Document data modeling for Confidential Insite database and other in house databases.
• Installed and configured Confidential cms200 for content management.

Confidential, Milpitas, CA

Information Services Supervisor

Responsibilities:

• Supervised a staff of 5 consist of Database Administrators, Clarify Developers and Web Developer to support corporate application/information services.
• Oversee all corporate MIS development initiatives and workflow, define and enforce checks and balances to ensure data integrity.
• That included all Web related systems, applications, tools, development and all the corporation applications and databases on administration and maintenance.
• Operating budget planning for the Information Services group. Install, setup, administrate and tuning of all web servers (Apache, Tomcat, iPlanet web server, IIS, iPlanet Certificate server and Sun JWS) and FTP server. Manage SSL certificates request, install and renew on all web servers.
• Design, develop and maintain Confidential, web-based tools, web applications and databases. Developed Cold Fusion base content management/push mechanism for corporate web server, Customer Activation Tracking System, Confidential Search, QoS report and batch import tool for Clarify CRM. Developed PHP base web sales lead tracking system to extract and store data on MySQL.
• Install, setup, administrate and tuning of Cold Fusion application server for both external and internal web services. Install, setup, administrate and performance tuning of Oracle database, MS SQL database and MySQL database.
• Provided corporate application support for Finance, Human Resources, Legal, Sales and Marketing, and Customer support. Reduced consulting expenses by performing all software suite upgrades and testing in house.
• Technical lead on migrate Remedy to Clarify CRM.
• Project manages the data migration from Remedy to Clarify CRM.
• Project managed all customizations and performs as administrator for Clarify CRM suite (ClearSupport and ClearQuality).
• Project managed and performs upgrade on Clarify CRM, Khameleon, iPlanet Certificate server, Seagate-Info server and Cold Fusion application server.
• Provide systems administration on Sun Solaris, HPUX, Linux and Window NT 4.0.
• Maintain Checkpoint firewall and DNS entries for the corporate network.

Confidential, San Jose, CA

Web Systems Administrator

Responsibilities:

• Oversee all Web related systems, applications, tools, and development.
• Serve as Webmaster for the Organization’s Intranet and Internet. Install, setup, administrate and tuning of Netscape Enterprise Web server, Directory server, Calendar Server, Collabra server, Apache Web server and Tango Application server.
• Design, develop and maintain Confidential, web-based tools and databases.
• Provide support for the development and maintenance of customer-based web programs.
• Work closely with Marketing on tactical design, technical execution, maintenance and evolution of Marketing content on the Confidential corporate Web site and Intranet.
• Provide guidelines and supports to all Confidential corporate Intranet content providers.
• Provide part-time systems administration on Sun Solaris, Window NT 4.0 and tech support to all users.

Confidential, Santa Clara, CA

Webmaster

Responsibilities:

• Maintain performance, administration and security on Netscape Web servers and Oracle Web server.
• Maintain performance, security and administration on company Internet service, dial up service and remote office connection using Livingston Firewall, Livingston and Cisco Router, ISDN, and Modem Dial up.
• Managed a 7-person web productions and developments team.
• Maintain performance, administration, development and security on Oracle 7.3.x database using SQL, PL/SQL, Tango and Developer 2000.
• Developed Confidential using Perl, Texis, Vortex and C.
• Developed Web pages using Java Script and HTML.