SUMMARY

Expertise in providing quality customer service and building reliable, scalable, secure IT infrastructures by prioritizing goals, and applying my DBA, networking/server skills, and full product life-cycle experience. Implement best practices, VMware virtual technology on EMC/NetApp SANs, and performance tuning.

COMPUTER SKILLS

• Database: SQL Server 7/2K/2K5/2K8 r2/2012 32/64bit , Oracle 10/11g, Sybase 11.5/12 DB/OS failover cluster, log shipping, db mirroring, replication, SSIS/SSRS/ SSAS, dbcc Rman, sqlplus, OEM, Toad, pl/sql
• OS: Win NT-2012 32/64 bit HP-UX 10/11, Solaris RHEL/RHL, FreeBSD, SUSE Linux OpenStep 4.2
• Performance Tools: Perfmon/System Monitor, SQL Server Profiler, DTA/Tuning Advisor, Dashboards, VMware vCenter Perfomance Counters, Solarwinds Orion Network Performance Monitor, SQLIO
• VMware: ESX 4, ESXi 5.1, vCenter Server vSphere 4 Enterprise Plus Vmware Infrastructure
• HW-SW: Cisco 5600/2600, PIX Device Manager 3, HP Virtual Connect HP Server Blade ProLiant bl680c G5-HP BladeSystem Onboard Administrator/iLO 2. EMC Symmetrix DMX 4-Control Center Netapp SAN, SnapManager Dell PowerVault LT02 tape library-Symantec Backup Exec Cygwin Openfiler
• Network: Active Directory, tcp/ip, Wireshark, Kerberos, NTLM, http, dhcp, dns, ftp, Samba, iSCSI
• Courses: EMC DMX-4 SAN LUN training, Cisco Router Security, HP-UX System Network Admin
• 1 2, System Database Admin ASE 12 , Sun Java 1 2 MS .NET framework, Windows debugging AD
• Web: Apache/IIS web servers, IIS Manager html 4.01/xhtml 1, ASP.NET, XML. Editors: vi, emacs VS

WORK

Senior Server Database Administrator

• Supported development/production teams, internet/intranet web teams, and 30 production, development and test SQL Server VMWare LAN/WAN. Supported 200 virtual server Data Center, vCenter/vSphere with ESX 4, ESXi 5.1 HA clustered hosts, HP blades, and EMC DMX-4/NetApp SANs.
• Installed, configured SQL Server 2005/2008/2008r2/2012, Reporting Services and Oracle 10g/11g. Configured SQL Agent jobs, DB mail, linked servers and permissions. Created DBs, maintenance plans backed up, restored, upgraded DBs. Recommended query monitoring and index strategies. Wrote fragmentation analysis and index-rebuild scripts. Reviewed code and assisted with logic implementation eg. CLR security . Researched 2K8/2K8 r2/2012 features. Developed script to test data and data types compression rate. Created, debugged SSIS packages and migrated 2K DTS code to 2K5. Installed and configured IIS web server, web sites and certificates. Reviewed deployment documents and deployed SW.
• Wrote documentation for SOPs, upgrades, best practices, system analysis, maintenance and system checks. Wrote project plans, defined requirements, identified benefits and risks. Trained junior DBAs. Evaluated government security controls and identified vulnerabilities. Developed audit scripts to automate process. Configured perfmon performance counters and server-side traces for audit and troubleshooting.
• Resolved failures of OS/DB, jobs, backups, SSRS and performance bottlenecks. Tuned queries, DBs and OS resolved locking/blocking, 32-bit and .NET SW performance. Created Profiler traces and server performance baselines for memory, cpu, network and disk I/O data/log files, drives . Analyzed system tables, DMVs, DB/OS/AD logs, Profiler traces, Perfmon/VMWare counters, Orion LAN/WAN network metrics and DTA. Repaired corrupt databases and rebuilt system databases. Resolved corrupt registries, Kerberos/NTLM authentication and Active Directory AD errors. Identified root-cause of failures from HW issues, SW configurations, resource conflicts and multiple source backups.
• Implemented/troubleshot high availability solutions: log shipping, DB mirroring, DB/OS clusters, replication and full/differential/transaction log backups. Developed backup strategy to improve disaster recovery and save storage standardized across enterprise. Created storage growth and capacity metrics. .
• Recommended, implemented and standardized best practices for configuration, code, and security. Developed configuration management policy. Configured DB/OS/domain accounts, services, groups, group policy, roles and schema. Managed/troubleshot Active Directory object permissions.
• Implemented HA virtualization solutions. Created virtual machines, clones, SQL and Windows 2K3/2K8/2012 servers, and sysprep images. Created baseline server snapshots for testing stage to decrease configuration and deployment time and increase testing quality. Configured HW, hard disk, network access, security and firewall. Installed, configured VMware ESX hosts on HP Blade. Created Datastores and mapped to LUNs. Configured VM for load balancing, VMotion and raw disk mapping to LUNs.
• Created data center cpu/memory usage and capacity report for 16 blade production, 4 blade development pools. Total: 484 CPUs /2.5 TB memory, includes failover resources, oversubscription enabled. 128 GB, 2-4 core 4-processor HP blades. Developed infrastructure Excel report Cygwin, Unix shell, Awk, perl .
• Assisted EMC engineers with ECC EMC Control Center /Data Store installation and DMX/VMAX implementation. Attended SAN and LUN training ECC, Symmetric Management Console, Storage Scope, SYMCLI/Symmetrix Command Line Interface, VSAN configuration . Supported weekend maintenance: physical to virtual server migration patches assisted Cisco engineer with router/switch, Virtual Connect configuration. Storage: 90 TB capacity upgrading to 240 TB RAID 5, 6, with virtual/thin provisioning .
• Capacity planning and designed SSRS dashboards with real-time reporting of storage drive capacity, free space and memory/cpu resources. Deployed to intranet interactive SSRS reports, with real-time charts and low-resource color alerts. Eliminated failures and managed increased data using threshold email alerts with SSRS reports. Created data warehouse of historical resource data for trend and growth analysis.
• Analyzed TCP/IP packets, NTLM, Kerberos and HTTP protocols to resolve root cause of errors with with security, authentication and firewall. Troubleshot protocol stack network traffic flow, web proxy TCP packet streams, website cross-domain scripts, Active Directory and DNS. Taught Wireshark.
• Designed ETL SSIS packages to migrate Oracle finance data weekly to SQL Server reporting system. Created and converted schema. Created data dictionaries, data mapping and ER diagrams with Visio.
• Installed, configured Oracle 10g/11g Enterprise Edition dev, test and production servers. Created, migrated and restored Oracle databases. Imported/exported data with Data Pump. Resolved database integrity errors, corrupt Oracle registries. Configured logins, profiles and security. Configured/troubleshot listeners, network environment, TNS, Oracle Net logging, trace, Oracle Enterprise Manager OEM Database Control, Lsnrctl, EMCA, EMCTL and upgrade tools. Managed dbs with SQL Plus and Toad.
• Planned for business continuity and created standby servers at secondary site. Developed FTP scripts to transfer data/log files from DMZ and restore to remote server. Analyzed, tested and documented backup and recovery procedure for Oracle disaster recovery. Developed PL/SQL scripts to read log files and email error alerts to management for mission critical applications. Resolved SMTP and firewall errors.
• Created RMAN Recovery Manager scripts for database backup and point-in-time recovery of data. Created physical and logical backups. Cloned Oracle production database instances with RMAN.

Principal Solution Engineer EDW , Data Alternatives

Confidential

Supported Business Intelligence team. Configured, tuned SQL Server 2005 and tested OLAP cubes. Created infrastructure documents Development, QA, Operations, Production for new data warehouse.

Database Administrator/DBA

Confidential

• Supported data mining activities for multi-terabyte data from United Healthcare. Managed ROLAP/OLTP SQL Server 2005 test and production databases supported programmers and data analysts.
• Created DB schema for 6 new clients loaded encrypted data feeds from clients' data marts/dw. Researched and developed stored procedures, functions and dynamic queries. Created indexes, analyzed hardware and stored procedures for performance tuning for VLDBs. Maintained data dictionaries.
• ETL Optimization: Created best practices and improved data load and transformation procedure from 6 hours to 12 sec-3 minutes by applying new logic and process. Eliminated 15 data loss in old process.
• Prepared IT resources for SAS 70 Audit. In charge of nightly backup schedule, managed tape media and new configurations to comply with disaster recovery policy. Troubleshot new server and resolved DR backup and media failures monitored backup logs and analyzed network load restored data. Created bandwidth utilization and performance baseline to identify cause of failures and root cause of problem.
• Installed, configured FTP and Apache Web servers configured router ACLs Access Control Lists to allow access and route Internet traffic. Troubleshot network, DNS, disk failures and configuration errors. Troubleshot email server security updated black and white lists. Created domain, email, DB accounts and standardized user access to resources. Capacity planning and recommended server upgrades using RAID.
• Configured CISCO router to comply with audit standards. Installed, configured VPN user security, RADIUS authentication server IAS and used the local database as backup. Implemented a central Syslog server to transfer router logs. Made switches ethernet patch cables created straight-through wiring, RJ45 .
• SW: Backup Exec, Dell PowerVault LT02 Cygwin Linux interface to Win , GNU Awk/Unix shell

Consultant/Volunteer

Confidential

IT system support taught and transferred web development skills and general IT skills. Data migration from Excel to SQL Server for ASP.NET 2.0. Taught computer topics to local school teachers.

SQL Server Support Engineer, Microsoft

Confidential

• Supported Japan's Microsoft Premier and Professional customers employing SQL Server products for their data management needs. Managed client case to completion: provided 2nd-level support, collaborated with escalation engineers and management. Increased customer satisfaction team rating by delivering timely solutions, responding to customers with same-day progress report and targeting 4-day case closure goal. Resolved or found workaround for client issues and recommended best practices.
• Built servers from scratch, installed, configured and troubleshot all editions of Japanese/English SQL Server 2000, 7, 6.5, MSDE, and fault tolerant Cluster Service products on all MS OS editions. Formatted and partitioned hard disks. Analyzed logs of SQL Server, OS, stack dumps, trace logs, SQLDiag, and other tools. Resolved installation, upgrade, network and hardware errors database/OS bugs registry and MDAC corruption security and SW/HW compatibility issues. Resolved patch/hot fix errors and analyzed SQL code. Resolved data access issues with client's stored procedures, SQL-DMO, ADO.NET, and DTS code.
• Provided feedback sessions on conferences, and training of database and related new technologies.
• Identified and troubleshot new product bugs or limitations and communicated to appropriate teams. Wrote documentation for Knowledge Base Articles for Japanese and English releases.
• Member of the SQL Server Beta team and tested Japanese and English service pack quality verification prior to release. Contributed to team projects, case reviews, and building test environments.

System Administrator

Confidential

• Supported server, database and client n-tier architecture for AT T Wireless' customer care CRM LAN/WAN systems on HP-UX UNIX and Sybase RDBMS. Throughout product life-cycle supported testing and development teams, which grew from 50 to 300 employees. Assisted MS migration project.
• Installed, configured, upgraded and managed UNIX multi-tier server and security software and related resources. Supported data conversion/national deployment teams. Created DBs, ran DDL/DML scripts, troubleshot data/schema errors and data integrity issues. Created cron jobs, network configuration.
• Coordinated projects with cross-functional teams. Initiated, organized and communicated new efforts to developers, testers and managers. Responsible for management and allocation of resources. Decreased support time by 90 on some systems by setting up new procedures and implementing task automation.
• Project Lead: SLM system integration, Kerberos network security, Y2K support, Maestro network.
• Identified, designed and implemented code to automate processes shell, awk, perl, transact-SQL, C .
• Development: Created Sybase back-end SW to replace a manual network tracker. Increased system stability by 75 . Administrators emailed during system failures. SW monitored distributed OS/DB servers and network resources. Used triggers, transactions, cursors and complex joins to analyze data.
• Communicated with vendors and troubleshot middleware problems. Documented system architecture, installations, and troubleshooting techniques. Provided team training and co-wrote 100 page manual.

TA and Technical Consultant

Confidential

• Taught C/C programming. Assisted in the development and debugging of code. Graded work.
• Supported users on Solaris UNIX and MS OS. Independently managed library computer facility.