SUMMARY

• 9 years of experience in MS SQL Server database administration, including physical database design, architecture, testing, performance tuning, moving database, setting up scheduled backup, disaster recovery planning, replicating between multiple servers, implement log shipping with standby database server and database mirroring.
• 2 years of experience in writing stored procedures with SQL code optimization, using Crystal Report and wrote ad hoc TSQL - based reports for upper management.
• 2 years of experience in configured and administered Crystal Report web server with Exchange server for report delivery.
• 4 years of experience in network administration, including setup LAN, VPN, WAN networks with Cisco router, PIX firewall, IPS, MARS and VPN client connection.
• Identified and determined causes of security violations, provided corrective actions to ensure data security.
• Trained in Data Warehouse architecture with Oracle Business Intelligence application.

TECHNICAL SKILLS

Databases: MS SQL Server 7, 2000, 2005, 2008, 2012, 2016, SQL, T-SQL, PL/SQL, Oracle 8i, Oracle 9i, Oracle 10g, DB2, SQL performance tuning, OLAP, H2, MySQL, PostgreSQL

Server Applications: MS Exchange Server, MS ISA Server, IIS, DFS, WINS, Symantec Corp. Ed. Antivirus server, Crystal Report Server.

Operation Systems: Windows 98, XP, NT 4.0/2000/2003 , Unix, Linux operation systems, OS400.

Network devices: Cisco router, Cisco PIX firewall, Cisco Switches, Cisco IPS, Cisco MARS.

Programming Languages: Java, C++, ASP, VB.

Applications: MS Visio, MS Office suites, Crystal Report.

PROFESSIONAL EXPERIENCE

Confidential, Arcadia, CA

Infrastructure Engineer

Responsibilities:

• Migrate on-premises MS SQL database to AWS cloud MSSQL RDS.
• Install, configure, troubleshoot and performance tuning production blockchain based H2 database for web-based application.
• Setup AWS infrastructure with Virtual Private Cloud (VPC) network, EC2 instances (Windows / Linux) using security group as host base security. Setup S3 with Cloudfront for web content and web cache content delivery. Setup RDS databases in MySQL, Postgres and MSSQL.
• Configure operation system and database security using Security Technical Implementation Guide (STIG).
• Setup and configure Ansible to automate server deployment. Setup and configure Jenkins for software release deployment.

Confidential, Culver City, CA

Database Engineer

Responsibilities:

• Support production databases for nationwide application in a 24/7 environment.
• Troubleshoot and performance tuning on Oracle and SQL server for in-house applications.
• Develop scripts, stored procedures and SSIS packages to support ETL and operation requirements. Optimized database queries, indexes, locks, DTS and SSIS packages. Review release procedures to ensure data access and user privilege using the highest security measures. Create users, roles with proper database access authorization.
• Perform configuration changes and database upgrade from MS SQL 2005 to MS SQL 2008.
• Perform audit on SQL server instances and databases to ensure compliance requirement.
• Configure monitoring system to alert on call personal for database or system alert.
• Research Big Data technology and web services, setup proof of concept scenario.

Confidential, Fairfax, VA

Database Administrator

Responsibilities:

• Support production VLDB databases for worldwide application in a 24/7 environment.
• Develop SSIS packages, scripts and stored procedures for ETL between various sources and MSSQL database. Troubleshoot and performance tuning on SQL server and in-house application. Optimized database queries, indexes, locks, DTS and SSIS packages.
• Review and troubleshoot release procedures to ensure data access and user privilege using the highest security measures.
• Perform configuration changes and database upgrade from MS SQL 2000 to MS SQL 2008.
• Troubleshoot and performance tuning on SQL server for MS Sharepoint and in-house application.
• Perform quarterly audit on all SQL server instances and databases to ensure compliance with security requirement.
• Assist Operations Manager to design, implement and test High-Availability SQL server installation and implementation.
• Convert Oracle database table structures, stored procedures, views, triggers, user permission to SQL Server environment.
• Configure monitoring system to alert on call personal for database or system alert.

Confidential, Rancho Cucamonga, CA

IT Technician/ Network Administrator

Responsibilities:

• Performed administrative tasks on MS SQL server and Oracle 9i database server such as installation, upgrade from SQL server 2000 to SQL server 2005, configure physical database design, setup scheduled backups, document disaster recovery planning.
• Create, alter, restores databases (options and other characteristics), monitoring the error log, the status of MS SQL Server Agents jobs and creating maintenance plans on MS SQL Server. Create new users and roles with proper database access authorization.
• Recommended and designed disaster recovery solution with virtualization to consolidate hardware equipment.
• Administered Cisco routers, Switches, Intrusion Prevention System (IPS), Monitoring Analysis Response System (MARS) and PIX firewall for WAN, LAN and VPN client network implementation.
• Coordinated the operations and activities associated with the company networks, telecommunications systems and services.
• Coordinated requests, acquisitions, installation, system designs, reconfigurations, maintenance, and servicing of all networks, client-servers, and telecommunication equipments.
• Perform research and analysis necessary for developing appropriate recommendations regarding hardware/software configurations and inter-connecting WANs, LANs, client servers and microcomputers.
• Identified and determined causes of security violations, and recommend corrective actions to ensure data security.
• Assisting AS400 system administrator for system upgrade and various implementations including Electronic Data Interchange (EDI) and Automated Shipment Notification (ASN).