SUMMARY

• Expertise in providing quality customer service and building reliable, scalable, secure IT infrastructures.
• Prioritize goals and apply my DBA, networking/server, development, virtual technology and SAN skills.
• Implement best practices, automation, performance tuning, Disaster Recovery and HA solutions.

TECHNICAL SKILLS

Database: SQL Server 7/2K/2K5/2K8/2K8 r2/2012/2014 (32/64bit), Oracle 10/11g/12c, Sybase 11.5/12; DB/OS failover cluster, DB mirroring, replication, log shipping, SSIS/SSRS/ SSAS, SQL Server Profiler, DTA/Tuning Advisor, dbcc, T - sql; RMAN, SQL*Plus, Oracle Grid Control, OEM, Oracle Enterprise Manager Cloud Control, Toad, PL/SQL, ADDM, AWR, Data Guard, Erwin; MongoDB.

OS: Win NT-2012 (32/64 bit); HP-UX 10/11, Solaris; RHEL/RHL, CentOS 7, FreeBSD, SUSE Linux; OpenStep 4.2

Languages: Unix shells, awk/sed, perl; C, C++, C#, Java, VB, Assembly, lisp, Prolog; OOP; Powershell

Performance Tools: Perfmon/System Monitor, Dashboards, VMware vCenter Perfomance Counters, Solarwinds Orion Network Performance Monitor, SQLIO, Storage Manager

Virtual Technoloy: ESX 4, ESXi 5.1, vCenter Server - vSphere 4 Enterprise Plus; Vmware Infrastructure; Linux KVM

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/Veritas 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

PROFESSIONAL EXPERIENCE

Consultant

Confidential, MD

Responsibilities:

• Support infrastructure team and Confidential SQL Server production, development and test systems. Design, install, configure SQL Server 2012/2014 clusters.
• Performance tuning. Apply best practices. Work with developers to review, tune code and systems. Write SQL code, stored procedures, triggers, indexes. Implement change control, monitor system performance, troubleshoot and identify root cause.
• Troubleshoot and implement maintenance jobs, backups, migrate LUNs. Write documentation and PowerShell scripts to create cluster infrastructure reports.

Senior SQL Server/Oracle DBA

Confidential, DC

Responsibilities:

• Implement High Availability, Disaster Recovery and high performance solutions for SQL Server and Oracle production, development and test servers (150 databases). Install, configure, patch and upgrade Oracle 11g/12c and SQL Server 2008 R2/2014 servers. Support 24x7. Write SOPs, upgrade and deployment plans. Implement knowledge transfer and mentor database team in SQL Server and SAN. Coordinate projects and deployments with SAN, network, VMware and security teams. Support developers, write SQL, create views, stored procedures, tables, indexes, data models and database design.
• Create and implement security hardening guidelines (CIS/NIST) and apply best practices.
• Upgrade Oracle 11g databases to 12c container/pluggable multitenant architecture. Migrate and consolidate Oracle field offices’ database servers to headquarters’ multi-instance servers.
• Design and upgrade SQL Server 4-node cluster with DB mirroring to DR site. Configure OS and SQL Server clusters, physical and virtual servers. Plan migration to AlwaysOn Availability groups.
• Design storage architecture for SQL Server and Oracle (RAID groups, database pools, LUNs, drives and local RAID disks). Standardize across servers, apply best practices and Oracle OFA.
• Storage and hardware capacity and resource planning. Performance tuning. Create baselines, resource usage and performance reports. Create hardware requirements for new projects and DR secondary site.
• Disaster recovery planning to support recovery time/point objectives. Configure and test remote DR site and failover; test and resolve backup and recovery errors. Resolve storage and network errors.
• Advance troubleshooting, analytical and planning skills. Saved 6+ months to VDI project by identifying compatibility conflicts, hardware issues and root cause assessment. Configure Solarwinds infrastructure and performance monitoring software.

Senior Server Database Administrator

Confidential, DC

Responsibilities:

• SQL Server, Oracle and Data Center support  Confidential.
• 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.
• Implemented high availability and disaster recovery solutions: log shipping, DB mirroring, DB/OS clusters, replication and full/differential/log backups. Developed backup strategy to improve disaster recovery and save storage; standardized across enterprise. Created storage growth and capacity metrics.
• Planned for business continuity and created standby servers Confidential 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.
• 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.
• Installed, configured SQL Server 2005/2008/2008 r2/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.
• 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.
• 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.
• 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)

Confidential, Miami, FL

Responsibilities:

• 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, Woburn, MA

Responsibilities:

• 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

Responsibilities:

• 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

Confidential

Responsibilities:

• Supported Japan’s Confidential 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, Redmond, WA

Responsibilities:

• Supported server, database and client n-tier architecture for Confidential &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, COTS software, including IBM MQSeries. Documented system architecture, installations, and troubleshooting techniques. Provided team training and co-wrote 100+ page manual.

TA and Technical Consultant

Confidential, Medford, MA

Responsibilities:

• 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.