Experience

F&L Galaxy, inc

• United States
• Technology, Information and Internet
• 1 - 100 Employee

• Infrastructure Engineer

  • Apr 2017 - Present

  • Migrate on-premises MS SQL database to AWS MSSQL RDS. • Install, setup, troubleshoot performance tuning production blockchain based H2 database for web-based application. • Integrate web application using AWS Ec2 (Windows, Linux), RDS (postgreSQL, MySQL), S3 and Cloudfront. • Configure AWS cloud security in VPC, security group in EC2 and WAF, operation system security in Windows and Linux. • Install, setup, using Ansible and Jenkins for CI/CD DevOps operations and using Kubernetes for orchestration. Show less



XAP Corporation

• United States
• Technology, Information and Internet
• 1 - 100 Employee

• Database Engineer

  • Nov 2012 - Apr 2017

  • Support production databases for nationwide application in a 24/7 environment. • Troubleshoot, performance tuning on Oracle/ SQL server and in-house applications. • Configure monitoring system to alert on call personal for database or system alert. • Research Big Data technology and web services. • Troubleshoot and enhance ETL SSIS packages. • Work with Oracle developers on various SQL Server/ Oracle database related implementation. • Support production databases for nationwide application in a 24/7 environment. • Troubleshoot, performance tuning on Oracle/ SQL server and in-house applications. • Configure monitoring system to alert on call personal for database or system alert. • Research Big Data technology and web services. • Troubleshoot and enhance ETL SSIS packages. • Work with Oracle developers on various SQL Server/ Oracle database related implementation.



General Dynamics Information Technology

• IT Services and IT Consulting
• 700 & Above Employee

• Sr. Data Analyst

  • Sep 2012 - Dec 2012

  • Support production VLDB databases for worldwide application in a 24/7 environment. • Configure monitoring system to alert on call personal for database or system alert. • Develop SSIS packages for ETL between SQL Server database and Oracle database. • Troubleshoot and performance tuning on SQL server for MS Sharepoint and in-house application. • Work with Oracle database administer on various SQL Server/ Oracle database related implementation. • Support production VLDB databases for worldwide application in a 24/7 environment. • Configure monitoring system to alert on call personal for database or system alert. • Develop SSIS packages for ETL between SQL Server database and Oracle database. • Troubleshoot and performance tuning on SQL server for MS Sharepoint and in-house application. • Work with Oracle database administer on various SQL Server/ Oracle database related implementation.



Arrowpoint Corporation

• United States
• Information Technology & Services
• 1 - 100 Employee

• Database Administrator

  • Oct 2007 - Sep 2012

  Support production VLDB databases for worldwide application in a 24/7 environment. Configure monitoring system to alert on call personal for database or system alert. Optimize database queries, indexes, SSIS packages and locks. Develop SSIS package, scripts and stored procedures to support operation tasks. 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. Review release procedures to ensure data access and user privilege using the highest security measures. Perform quarterly audit on all SQL server instances and databases to ensure compliance with security requirement. Assist Operations Administrators 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. Work with Oracle database administer on various SQL Server/ Oracle database related implementation. Show less



Perot System Government Services

• IT Services and IT Consulting
• 1 - 100 Employee

• Database Administrator

  • Jan 2007 - Oct 2007

  Support production LVDB databases for worldwide application in a 24/7 environment. Optimized database queries, indexes, DTS packages and locks. Recommended configuration changes to increase database performance. Monitor database storage, recommend architectures to ensure reliable database system. Performed all database related task, such as database creation, configure backup. Performed troubleshooting of application related issues and software release prior to deployment. Support production LVDB databases for worldwide application in a 24/7 environment. Optimized database queries, indexes, DTS packages and locks. Recommended configuration changes to increase database performance. Monitor database storage, recommend architectures to ensure reliable database system. Performed all database related task, such as database creation, configure backup. Performed troubleshooting of application related issues and software release prior to deployment.



Amphastar Pharmaceuticals Inc

• United States
• Pharmaceutical Manufacturing
• 200 - 300 Employee

• IT Technician/ Network Administrator

  • Apr 2004 - Jan 2007

  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 telecommunications 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). Show less



Amptron International Inc

• United States
• Technology, Information and Internet

• Programmer/ System Administrator

  • Aug 2001 - Apr 2004

  Performed administrative tasks on MS SQL server such as installation, upgrade from SQL server 7 to SQL server 2000, configure physical database design, setup scheduled backups, document disaster recovery planning. Create, alter, restores databases (options and other characteristics), setup replication, monitoring the error log, the status of MS SQL Server Agents jobs and creating maintenance plans. Create new users, roles with proper database access authorization. Using stored procedures and Crystal Report tools to design scheduled reports and ad hoc reports reporting business activity to upper management. Configured and administered Crystal Report web server with Exchange Server for report delivery. Maintained and administered all network component include Cisco router, Exchange Server, ISA Server, and SQL Server. Implemented and supported company-wide production Enterprise Resource Planning (ERP) system with Customer Relationship Management (CRM) and web order ability. Show less



Prototype Computer Systems Inc

• Computer Technician/Assistant Manager

  • Apr 1997 - Jul 2001

  Monitor WAN, LAN, and hardware performance, including routers, servers, and workstations. Developed methods, policies and procedures in support of the firm's network, including the monitor, maintenance, fault detection, problem solving, and acceptance testing of such systems. Perform services on customer's computer and networks. Monitor WAN, LAN, and hardware performance, including routers, servers, and workstations. Developed methods, policies and procedures in support of the firm's network, including the monitor, maintenance, fault detection, problem solving, and acceptance testing of such systems. Perform services on customer's computer and networks.