Kenny V Pham

**** ******* *****

Land O Lakes, FL 34638

acunri@r.postjobfree.com

813-***-****

SUMMARY:

He possesses an active Top Secret/SCI clearance that has 17 years of experience as a Data Architect and Database Administrator Oracle, SQL Server, GreenPlum, Sybase, MySQL, Logical Data Modeling, Multidimensional Modeling, Business Process Modeling, Business Intelligence Usage and Implementation including Analytics, Physical Data Modeling, Relational/Object and Fact/Dimensional, Data Migration, Data Consolidation, Data Quality and Change Management and QA, Replication, Propagation, Database, Change Data Capture CDC, Clustering, Problem Resolution, Performance Tuning and Testing, Capacity Planning, Program, SQL, and Application Review, Data Warehouse, Disaster Recovery.

SKILLS:

SQL Server (2012) Microsoft Cluster (2012) Python SMTP

SharePoint (2013) PowerShell Linux SNMP

RDBMS Oracle 11g Sun Solaris Bash Erwin

VMWARE ESX Server HYPER-V (2012) NetApp IIS

VERITAS Cluster Snap Mirror Fibre channel/SCSI DNS

Toad (SQL, ORACLE) EMC VMAX ONTAP upgrades TCP/IP

Apache Shell Scripting NetApp filer Tipping Point Weblogic Server Red Hat Sybase

Solarwinds ArcSight McAfee EPO DHCP

EXPERIENCE:

01/16 – Present: Eagle Network Solution, United Arab Emirates

Infrastructure Engineer

Review business requirements associated with the complex and underperforming areas of the application identified by customer. Evaluate the design for data flow and Ruleset structure, Data Integrity, Scalability and Maintainability. Assess the application overall for data center best-practice compliance and identify areas of risk. Identify new design alternatives in the pre-op environment version that will remediate current issues and improve performance. Provide specific direction on implementing the new design. Determine quantitative/qualitative benefits that can be achieved by implementing the proposed solutions. Responsible for architecting, modeling, and implementing Organizational Effectiveness's Data Warehouse Solution from the ground up. The solution was designed to support various decisions related to Cyber security, Finance and Human Resource. Worked with the project manager to design a template for gathering data and report requirement. Worked closely with Stakeholders to define data and reporting requirements. Design the Data Warehouse and Business Intelligence environment software and hardware architecture and prepared a best practice document. Design an SSIS package template that can be reused by other developers to extract data from MySQL and other miscellaneous data sources.

Document integration abilities, Analyze and discuss possible integration scenarios. Analyze the current application product (ArcSight SIEM, McAfee (EPO, HBSS), SharePoint, Database (SQL, MYSQL, Greenplum), Solarwinds, Tripwire, EMC Avamar, EMC VMAX, Data Domain, Tipping Point, AVAMAR, F5) integration requirements and explore the possibility of future integration with future based product. Document at very high level activities that need to be performed and document the integration scenarios. Knowledge transfer to client team, detail pros and cons and application demo.

04/12 – 12/15: GDIT, SOCCENT

Senior DBA/Sharepoint Designer

Managed all SOCCENT SQL server 2008 (50 databases) across 2 network (Niprnet, Siprnet)

Reviews database design and integration of systems, including client/servers and makes recommendations regarding enhancements or improvements. Build and install baseline on servers for SQL server. Develop store procedures, triggers, DTS, and replication for all SOCCENT databases. Performance tuning, backup, schedule job and integrity controls. Migrate data and users from SQL 2008 to SQL 2012 server. Build Microsoft cluster SQL server for all SOCCENT databases. Run windows and SQL server patches for all SQL servers. Use SQL to coordinate the use of data available through a computerized system. Establish and maintain security and integrity controls. Completed all information assurance (IA) checklists for delivery of database services to include install guides, user acceptance testing, and DISA STIG validation.

Experience in NetApp SAN/NAS, EMC NAS/SAN storage configuration. Experience in Data Fabric Manager/Operation Manager for NetApp storage Allocation and Monitoring for issues. NAS Administration, Net apps filers installation, on tap upgrades, snap mirror and quota, Qtrees Administration. Provided daily support and maintenance for the Storage Array, systems and applications.

SharePoint Administration functions including deploying code solutions (.wsp), PowerShell scripts, server optimization, server management, term store maintenance, taxonomy, content deployment, web and service applications in Central Administration. Investigation and demos for migration to SharePoint 2013 including search, SharePoint Designer 2013, Office 365, responsive design, apps, InfoPath 2013 web publishing, Visual Studio 2012, product catalog, AWllS, Windows Azure IaaS cloud technologies. Plan, design and implement SharePoint data protection, backup and recovery. Implement authentication, security roles, user groups, audiences, and item level security using PowerShell.

01/05 – 04/12: HP, USSOCOM

Senior DBA/Developer

Managed all Socom SQL server 2005 (300 databases) across 4 network (Niprnet, Siprnet, Jwics, Enterprise)

Reviews database design and integration of systems, including client/servers and makes recommendations regarding enhancements or improvements. Build and install baseline on all servers for SQL server. Develop store procedures, triggers, DTS, and replication for all SOCOM databases. Performance tuning, backup, schedule job and integrity controls using SQL Enterprise Manager and Powershell scripts. Migrate data and users from SQL 2000 to SQL 2005 server. Design Continuity of Operations (COOP) plan for SOCOM MOSS 2007 portal and provide storage assessment /disaster recovery solutions using VERITAS replicator. Managed and extended Veritas Cluster/Veritas Netbackup Administration. Architecting Data Warehouse storage arrays in EMC Control Center for performance and data protection. LUN carving on different disk groups with different RAID configuration. Preparing LUN mapping guide, sun mapping and updating volume mapping. Applying patches for system upgrades, installing new servers, integrate, administer and support Network Services. Use SQL to coordinate the use of data available through a computerized system. Establish and maintain security and integrity controls. Provided 24x7 support to all SOCOM’s users and developers in a mission critical environment, while maintaining 99% uptime. Formulates policies, procedures and standards relating to database management and monitors transaction activity and utilization. Automated and centralized many aspects of day-to-day operations to include database monitoring, server’s checks, backup and recovery. Prepares and reviews activity, progress and performance reports using PowerShell. Interacted with military and civilian personnel to analyze requirements, design, develop and support Web application and SharePoint.

Oracle:

Applying patches whenever required and Data refresh from PROD to TEST and DEV environment.

Installed and Implemented Backup & Recovery procedures. Implement Hot, Cold and Logicalbackup plans. Setup backup and recovery procedures using RMAN. Performed block recovery using RMAN. Performed backup validations using RMAN. Daily Health Check Up of the Database, Rebuilding of Indexes, Creating & Managing Table spaces Allocation tables to Different tablespaces.

Maintenance of Oracle Database. Performance tuning of Oracle Database Objects and Handling Database storage. Taking periodic backup of the database and the software.

01/98 – 10/04: Jacobs Technology, USSOCOM

Systems Engineer/DBA

Provides computer systems analysis and engineering support to the Wargaming, Simulations and Analysis Division. Design and plan each project from stage 1 to deployment in a full development cycle.

Projects supported include C4I, Logistics, Mapping Tool, Maritime, NSW, SO, Psychological Operations, and Civil Affairs Models/Data Entry Tools; also the Quadrennial Defense Review Dynamic Commitment Tool and the Joint Special Operations Mission Simulation (JSOMS). Routinely employs Microsoft Access, Visual Basic 6, VB.Net, MapObjects 2, Arcview 8.3, Avenue, Install Shield, Primavera Project Planner, and Crystal Reports software development. Designs, implements, and maintains SQL Server 7 and Oracle 8i/9i databases on a Win NT and Solaris. Build and install Solaris and ORACLE for developer and production servers. Formulates policies, procedures and standards relating to database management and monitors transaction activity and utilization. Develop store procedures, triggers, views for development and production server. Performance tuning, backup, schedule job and integrity controls. Install and maintain the Red Hat Linux Server operating system and various Linux applications and services such as Apache, weblogics, Kerberos, and LDAP. Extensive experience with problem resolution, root cause analysis, etc. of hardware and software platform problems in complex, layered, client/server based software. Experience in implementing and supporting SUN Microsystems SUN Fire 120S servers, Redhat Linux. Excellent knowledge of Network configuration, implementation, Administration using Windows NT /2000/2003 server, workstation 4.0 and Design configuration. Installing and removing software packages and patches on Solaris. Configured DNS, NFS, SAMBA, PRINT SERVERS, and all server applications in Unix SMTP, SNMP, NIS+/NIS, LDAP, HTTP, HTTPS, etc.

CERTIFICATION:

MCSA: SQL Server 2012 ITIL 3 SECURITY +

EDUCATION:

University of Phoenix - 2000

Master of Science: Computer Information Systems

REFERENCES:

Available upon request

Contact this candidate