SUMMARY:

• Senior Windows Server and Linux Server Administrator and Oracle DBA, System Engineer and Architect with over 20 years of SDLC experience in Server Rack Structure Configuration, Disk Array RAID Configuration, Database Design and Setup, Web Application System Architecture Design and Development, COM Object, Software Systems Analysis and Data warehouse using Client/Server, Internet/Intranet and Mainframe, Database environments for US Government, Financial Investment, Insurance, Telecommunication Industries, Oil Industry and Environmental Engineering Industry.
• Expert level of Microsoft platform development and integration using C#, Visual Basic, COM, COM+, ASP, ADO, OBDBC, OLEDB, Oracle, SQL Server, IIS, Ajax and .NET.
• Proficient in Data Modeling, Database Logical Design, Analysis, Database Management, Implementation and Testing in Relational Database Management Systems Environment like SQL Server and Oracle.
• Application system architecture design and programming, and system performance tuning.
• Strong client interaction skills with good communication skills.

PLATFORMS /E NVIRONMENTS:

• Windows Server, Web Server and Report Server in Fujitsu Server Racks Environment, Active Directory.
• Linux Server Platform and Fiber Channel SAN Storage Linked with Linux and Windows Environment, Ansible Automation with Red Hat Linux Server.
• Database ­­Oracle 12g, 11g, 10g, 9i, 8, 7; Oracle Application Server; Oracle Multiple Master Source Stream Replication; SQL Server 2000/2005; MySQL; DB2; MS Access; Toad, Spotlight, Benchmark
• AWS Management Console for cloud management and AWS Glue for ETL process.
• Web ­­Ajax, Microsoft .Net Framework v1.0/v2.0/v3.5 and Visual Studio 2003/2005/2008/2013 / Visual Studio 6.0, /Java Script, InterDev, Active Server Pages (ASP), MDG Integration for Visual Studios
• Programming ­­ Visual Basic (VB), C#, Active Server Pages (ASP), Java, HTML, FrontPage / NetObject Fusion,
• Server - Web Server and Database Server Set up / Configuration, Linux Shell Script
• Report ­Crystal Report 2008 / 2013 and Crystal Report 2008 Server, Business Objects Crystal Reports tool; Oracle Discover
• GIS ­­ ArcInfo, ArcView, ArcIMS and MapObject
• Data Modeling ­ Sparx Systems Enterprise Architect, Visio and Erwin
• Operation System ­Red Hat Linux Advanced Platform Enterprise Server; Windows Server,
• Storage System - Eternus 2000 and ServerView
• Unix Server and Workstation platform

PROFESSIONAL EXPERIENCE:

Confidential, Washington, DC

Senior Linux Administrator, Storage Systems Administrator and Oracle DBA

Responsibilities:

• Setup Windows Database server. Installed and configured Oracle database in windows server.
• Setup Windows Web server and Report Server. Setup virtual directory and configured IIS Server for Web application
• Install and Set up the Active Directory in Windows Server
• Performed configuration of Active Directory (AD) objects and user permissions.
• Developed organizational units in Active Directory (AD) and managed user security with group policies.
• Managed Group Policy Objects (GPOs) throughout the Active Directory (AD)
• Build Ansible playbook for Windows Server Automation configuration for task like managing Windows services, manage local users and groups and execute PowerShell scripts
• Migrating Windows Server from Windows 2003 Server to Windows 2008 and Windows 2012 with all the roles and features.
• Setup and configure VMware in Windows server for cloud and server virtualization environment
• Built server ghost images and used image to build backup server for system application.
• Setup and Support the winder terminal server function for remote connection to the server.
• Installed and configured the SQL Server database on the windows server.
• Setup Linux Database server hardware and disk array raid controller components. Installed and configured Red Hat Enterprise Linux Operation System to the database server.
• Maintained and managed Red Hat Enterprise Linux Operation System and updated the Red Hat Enterprise Linux system with latest packages from the Red Hat Linux Red Hat Enterprise Linux Subscription account.
• As the owner of agency Red Hat Enterprise Linux Subscription account, maintained and configured the agency Red Hat Enterprise Linux Subscription account, update all agency Linux Server package and monitoring the Linux Server update status.
• Setup the connection between Linux Database servers with other network server and configured some windows server disks as part of Linux database server disk for easy data transfer between Microsoft windows system and Red Hat Linux operation system.
• Configured the Ansible automation in Red Hat Linux Server.
• Setup and configured Storage Area Network (SAN) device for big data storage from the agency multiple application systems.
• Tested and setup the Disk Array Raid 1, Raid 5 and Raid 10 configurations. And updated Oracle database storage disk group from Raid 5 to Raid 10 configuration to improve the Oracle performance.
• Configured multiple disk group areas for Oracle database backup, recovery and replication
• Tested and setup Fiber Channel connection between Linux Oracle Database server and SAN disk storage system.
• Designed the architecture of Oracle Replication software to meet DHS agency special business need and Built the Oracle Replication software in C# to replication the agency Oracle database with DHS special requirement.
• Architected Windows Service special to monitor the Oracle Data Replication Process and Scheduled Task Status.
• Extended Oracle searching capacities by integrating data distribution pattern in database and regenerating the searching process based on the statistics pattern analysis inside of database.
• Communicated with Oracle professionals regarding any Oracle technical issues related to the agency Oracle database. Provided the latest oracle technical solution to fix any error happened in the agency Oracle database.
• Designed the database disaster recovery strategy and setup and configured Oracle Stream Replication with multiple master oracle databases architecture structures in different geological locations to meet disaster recovery requirement.
• Configured Oracle Database Backup and Recovery as well as retention policy.
• Configured Oracle Fast Flash Area. And setup and configure Oracle whole database backup and accumulative backup. Monitored Oracle database backup status and enterprise manager status.
• Architected and designed Oracle Table, SQL packages, functions, trigger, view; Performed SQL optimization, programmed stored procedures and setup multiple databases connection via database link.
• Conducted Performance Review of Oracle Database for Agency critical applications
• Analyzed the reports for Oracle wait events, time consuming SQL queries, tablespace growth, database growth
• Performed the Oracle SQL Query tuning and provided tuning recommendations to development team
• Used Explain Plan, Oracle hints and creation of new indexes to improve the performance of SQL statements
• Updated the Oracle ASM library every time after updated Linux Database server packages.iew a
• Review and configure the AWS Management Console for cloud management of the database service
• Test and set up AWS Glue for cloud database extract, transform, and load (ETL) process.
• Review and test Oracle multi-tenant functions for System Architecture updating
• Setup Microsoft SQL Server for testing report function with SQL Server.
• Set up and configure the MySQL database for system architecture design consideration.
• Setup and configure the Postgres and Hadoop databases in testing Linux environment before DHS categorizes them as approved software.
• Designed the IT System Architecture from System Platform Architecture like Server Hardware Structure, Database Storage Disk Array Raid Configuration, Database Structure design, Backup and Recovery Strategy, Multiple Master Database structure, System / Data High Availability, Database Replication Structure to System Web Application Architecture like loosely coupled, horizontally scalable Service-Oriented Architecture (SOA), layered process structure, User Control, Class Modules / Services and System Templates.
• Architected system web solution in Sparx Systems Enterprise Architect development environment. Designed and developed a service-oriented enterprise application framework with .NET and WCF, built layered computing components like database process, business services, responsive user / presentation interface, business analysis etc.
• Architected the web system searching engine from Oracle database searching layer through web server processing layer to UI presentation layer. Designed and built the search engine component with dynamically presenting user selected data structures with the features of sorting, selecting, paging, data exporting, report linking functions etc.
• Architected the web system report functions by providing XML schema based interfaces to generate report framed with XSLT components. Implemented distributed report architecture upon C# class modules / services to generate the PDF report based on the existing Crystal Report templates.
• Re-designed single large web application architecture into multiple web applications to increase the system capacity and improving stability, performance and expanding features and therefore availability of services.
• Wrote system architecture document and lead the effort to build the entire multi-layers web system from the ground up.
• Architected and built web system architecture software to automatically generate system SOA component, layered process structures, Data Transfer Object, and UI template based on the database structures to speed up development of new web application and meanwhile enforce consistent architecture design, deployment, configuration and maintenance.
• Responsible for system architecture design, layered component development, system performance and scalability.
• Leaded the development of agency-wide, multi-module enterprise applications and took projects through software development life circle like requirements definition, design, development, testing and implementation.
• Overseeing architecture implementation and mentoring the technical growth of team members.
• Leaded and mentored the developer to support new and existing web applications including using Oracle 10 and Oracle 11gR2, Oracle 12g, Active Server Pages, VBScript, C#, .NET, Crystal Report.
• Designed event-driven Business Process Modeling and enterprise application integration functions. Guided team in designing and developing data service framework capable of connection applications with data from multiple sources.
• Setup Agency report system from Generation I through Generation III.
• Designed and Build agency report engine for generating mission critical intelligence analysis report
• Designed the Agency Report Engine and generated the agency report via report template.
• Designed and build the report form for the main web system of the agency.
• Build the report component with multiple language like C#, VB Script and Java Script.
• Created the Agency report with different Architect like server-generated report and client-generated report.
• Provided the technical suggestion and advice to the upper management regarding the report system modification, report system enhancement and specify the report system configuration.
• Evaluated the software vendor proposal regarding any technical solution and provided the suggestion and best solution to the management team.
• Evaluate and select the right technology solution from both Commercial-Off-The-Shelf (COTS) and Government-Off-The-Shelf (GOTS) products to meet the agency business need and budget requirement.
• Interviewed and evaluated the IT candidates for DHS agency IT projects.

Confidential, Washington, DC

Senior Linux Administrator, Oracle DBA System and Architect

Responsibilities:

• Evaluated server hardware and system software packages and tools to agency for mission critical application system development.
• Supported new and existing applications software including using Oracle, Active Server Pages, VBScript, C#, .NET, Business Objects Crystal Reports tool;
• Drafted software design plans and supported the overall application system design, documentation, development, modification, testing, installation and implementation.
• Supported new and existing applications software and incorporated new technologies with oriented design and system architecture;
• Reviewed the design of systems that meet current and future business requirements; Enhance and optimized the existing software within the agency;
• Reviewed recommendations from vendor for resolution of complex issues that affected LIN application design agency­ wide;
• Investigated, evaluated and selected new software application tools and methods for improving CBP LSS information system productivity and application quality throughout the life cycle;
• Assessed the feasibility of adopting new application system design technologies within the current systems environment; and identified and corrected the weaknesses of current version of CBP LSS application with existing critical network and system performance parameters.
• Set up the Sparx Systems Enterprise Architect software for project system requirement documentation and application system architecture design.
• Collected the user and project requirements in the areas of application functionality, performance, use case, system requirement and security issue, federal government regulations for the Customs and Border Protection agency.
• Created various packages within the SPARX Enterprise Architect application and built the Structural Diagrams, Behavioral Diagrams and Extended Diagram for the system requirement and architecture design.
• Designed various Enterprise Architect template based on the requirement of different system architecture design documentation. Generated various design documentation with the application of Enterprise Architect.
• Migrated the LIN ASP application from existing Windows environments to new Windows environments with enhancing many ASP function within the old application.
• Configured Window Web Server and set up the IIS (Internet Information Service) for LIN application with configuration of application pool and virtual directory.
• Set up and configured the Scheduled Task in Windows Sever to replace the Launch Pad functions for all the LIN scheduled reports
• Designed Microsoft Visual Studio NET Framework application utility to upload over 20,000 binary data files to Oracle database with C# programming.
• Purchased, installed and set up Sparx MDG Technology for DDS to link Visual Studio 2008 design environment with Sparx Systems Enterprise Architect for delivering a powerful, efficient system design environment and creating complex data­ centric services for real ­time and embedded applications.
• Configured the Windows servers and installed Oracle 12g database in multiple Fujitsu RX100 S4 servers for oracle database stream replication.
• Tested and set up Oracle High Availability (HA) Multiple ­Source Stream Replication distributed database servers for multiple geological locations
• Identified the critical Fujitsu RX300 S4 server components and determined the hardware specification for the Red Hat Linux Enterprise Advanced Platform database server before purchasing the database server for the agency.
• Set up the Raid configuration with disk array in both Fujitsu RX300 S4 and Fujitsu RX300 S3 Server with Fiber Channel connection to the ETERNUS 2000 external disk storage system.
• Installed and tested Red Hat Linux Enterprise Platform in both Fujitsu RX300 S3 and Fujitsu RX300 S4 servers.
• Installed Oracle Validated RPM package on Red Hat Linux Enterprise Platform prior to the Oracle installation and installed Oracle database software on the server. And configure the Oracle database stream replication with multiple master database sources
• Configured the Eternus 2000 storage system for database backup.

Confidential

Senior System Engineer/Architect/Oracle Development DBA

Responsibilities:

• Participated in project planning and requirement analysis; documented functional and technical specifications;
• Leaded the exploration, evaluation, and design of technical solutions and prepared users by developing and conducting end­ user training;
• Developed testing plans and procedures for unit test, system test, and acceptance test
• Setup and Maintained the Oracle 9i and 10g database and performed the database migration from Oracle 9i database to Oracle 10g database. Analyzed and designed databases with system application design, working individually or coordinating database development as part of a team.
• Installed SQL Server 2005 in database server and converted the database from Oracle 9i to the SQL server 2005.
• Install and set up the Oracle IPM for the document tracking system file attachment and image processing function development using .Net C# programming.
• Setup Oracle user verification function, user profile type and application schema, tables object, sequence, packages in Oracle 9i and 10g utilizing SQL*Plus, TOAD and Oracle Enterprise Manager. Applied Oracle database patches. Performed SQL statement analysis and SQL tuning. Assisted developers with coding PL/SQL. Write the database generating scripts. Schema comparisons using TOAD. Installed and configure TOAD 9.6 on the development server and developer computer. Configured the Oracle tnsnames.ora and sqlnet.ora files for the Oracle application connection
• Exported Oracle 9i and 10g database and imported the database into Disaster Recovery Center in remote location.
• Maintain the Web server and configured the IIS for both production and development .net application.
• System Architecture Design - Designed architecture of application system and developed the system application codes; Documented functional requirement and system design prior to application development.
• Designed Web Applications with Visual Studio .Net 2003, 2005 and 2008 with C# and Java programming for DOL EBSA Agency web application.
• Designed .Net User Control, .Net Class Modules. AJAX Component for .Net Application. Designed the architecture of multi­level AJAX objects for both report and user interface application.
• Designed structure of Case Tracking System with Microsoft .Net and Ajax for the Office of Technology and Information Services.
• Ad hoc Report Generation - Created specific­ purpose report generation application with Crystal Report version 9, Oracle 9i/10g and ASP .Net
• System Backup Plan and Process - Designed system backup plan and process to prevent any potential loss of system development and data.
• Disaster Recovery System (DRS) Development - Setup computing and network facilities operated far away from Washington DC to ensure that when a disaster were to destroy facilities at National Office, DRS could be used to restore the services and systems in support of National Office business functions.
• Remote Network Management - Controlled and managed remote network servers with Symantec pcAnywhere, Windows remote desktop web connection, Terminal Services Client and VPN.
• Microsoft Training on the using SharePoint Server 2007 with Microsoft Office 2007

Confidential, Reston, VA

Senior VB/COM, GIS and GPS Integration Application Consultant

Responsibilities:

• Oracle data modeling, table design and creation with ERWin and Microsoft Visio. Modified the Oracle database through Platinum ERWin ERX 3.5.2 forward engineer and reverse engineer. Create Oracle view object, stored procedure and PL/SQL programming.
• Full life­cycle GPS and GIS integration project architecture design and programming with Visual Basic 6.0, Oracle Database, GPS/GeoTrack, GIS, MapObject, ArcSDE, ArcView, ASP, MS Access/Excel, Crystal Report, VBA, VB Script and Java Scrip.
• Tablet/Handheld computer system setup and application design / development using wireless­keyboard mini­dock Stylistic Fujitsu Tablet computer
• Designed real­time GPS interface with GIS Application. Embed GPS properties in GIS application to enable the GIS application to communicate with GPS GeoTrack via a COM/DLL object. Designed and programmed GIS application to interact with a GPS receiver through a standard serial or USB port and add the real­time GPS data into the GIS application for data analysis and decision making process.
• ESRI MapObject GIS function design and programming. Created the DDL objects for various MapObject tracking layers of sketching functions.
• Database report function design and set up through Visual Basic 6.0 DataEnvironment and DataReport object programming. Visual Basic 6.0 class module design and programming for GIS graphic object modification and drawing function
• Web application design and programming utilizing Microsoft Visual InterDev 6.0 application tools, ASP VB Script and Java Script programming for Building Access application. ASP Server and Client side ADODB object programming for Oracle database connection and MS Access database connection
• Microsoft Visual InterDev programming for Microsoft Excel data module application connection. Microsoft Excel 97 interface design and VBA programming for Oracle Building Access database application

Confidential, New York, New York

Senior VB/COM, Web Application Consultant, Oracle DBA

Responsibilities:

• Full life cycle project architecture design and application development.
• Design and coding of VB COM object for financial function using Oracle 8i as backend database.
• Active X data object programming. ODBC programming for connection to back­end Oracle database
• InterDev VB/JAVA Script/ASP programming by using Financial Process Flow COM Object, Specific Comparison COM Object and Premium Rate Comparison COM Object.
• Database modeling and creation for financial application project. Created and modified database table using ERWin database tools. Create View, Query with Oracle PL/SQL programming for data manipulation.
• Installed Oracle 8i on server and client machines, configured client/server through SQL*NET.
• Heavy Visual Basic programming for Financial Process Flow COM Object, Specific Comparison COM Object and Premium Rate Comparison COM Object.

Confidential, Warren, New Jersey

Senior VB/COM, Client/Server Application Consultant

Responsibilities:

• Architecture design of Client/Server data­flow application for multiple­branch user through Internet
• VB/COM/ActivX Programming
• DB2 Client/Server database application design and programming
• Multi­users MS Access front­end design and development
• Heavy MS Access SQL coding and DB2 SQL programming and ODBC connection programming.
• DB2 data retrieve, update and modification through MS Access
• Surety financial statement and financial analytic function application design. Financial analysis report design and programming through client/server application

Confidential, Newark, New Jersey

Senior VB, Client/Server Application Consultant

Responsibilities:

• Visual Studio VB 6.0 design and programming
• Database design experience and SQL programming with project life cycle
• Designed client / server investment analysis system using MS Access as front­end application and Sybase as back­end database
• Integration of MS Access with MS Excel for data catalog, analysis and illustration.
• Programming of automatic function of transfer computed data and statistics results to Microsoft Excel and make report within Microsoft Excel dynamically

Confidential, Atlanta, Georgia

Senior GIS and GeoStatistics Analyst

Responsibilities:

• ArcView GIS image register/geo­referencing extension design and Avenue programming
• Performed geographically weighted statistical data analysis with various environmental data.
• Visual Basic 6.0 MSChart programming and GUI interface design Database
• Oracle 7.3.3 database administrator, database installation and setup, database backup and recovery
• Worked on EPA environmental supper list projects and provided guidance on the geospatial and statistics data analysis.
• Setup and Configure Unix Server and Workstation for 3-D data visualization and GIS project

Confidential, Atlanta, Georgia

GIS and GeoStatistics Analyst

Responsibilities:

• Generate Variogram and Perform spatial data predictive analysis with GeoStatistics Kriging application
• Data visualization application designed and development. MS Access and VB programming
• Design and implementation of GIS Internet/Intranet application using Internet Mapping Server (IMS)
• Worked on various environmental projects in air pollution, carbon emissions and water contamination, and performed spatial and statistics analysis on these data.