SUMMARY:

• I have over 19 years of IT experience with extensive background in database management, design/modeling and development, which includes Oracle, MS SQL, Sybase, DB2 database and data warehouse/data mart. Proven technical leadership and performed the roles of database Architect, production DBA, and development DBA in large scale and complex operation environment.
• Hands - on experience database/warehouse and application design including development of data modeling
• (logical, physical), web application, metadata, establishment of key business processes.
• Expert Database Administration for production & development Servers with outstanding troubleshooting capabilities included database/warehouse performance tuning. Quickly and actually identify the cause and fix it in OS, database configuration, design, application module, data retrieval or related SQL/TSQL code.
• Exceptional programming skill sets in Unix shell script (Perl/Sh/Ksh), Java/C#, PL/SQL stored procedure.
• Working experience of ETL process using Informatics, SSIS (MS SQL) and SSRS.
• Working knowledge of RAC, ASM, DataGuard, Replication, Mirror, Cluster Database in Linux/Unix/Windows.
• Strong hands-on experience with Spring MVC, Spring Security, Spring JDBC/JPA/Hibernate, Spring Boot,
• Restful service / Microservices, Servlet, JSP, JMS, AJAX, Soap, JavaScript, CSS, AngularJS, Node.js, XML.

TECHNICAL SKILLS:

Database: ORACLE 12c/11g/10g, (OEM/Grid, RMAN, RAC, ASM, Data Guard, PL/SQL, Data Pump, SQL LoaderOracle Data warehouse/BI/, Oracle Stream/GoldenGate) MS SQL 2014/2012/2008 (T-SQL, replication, mirroring, log shipping, SSMS, SSRS, SSIS, SSAS), MS AccessDB2 UDB/AS 400, Confidential MQ, SYBASE ASE, (Sybase Central/DB DBartisan), MySQL, PostgreSQL, MongoDBDatabase design, ETL tool: Erwin/ER studio, Microsoft Visio, ER Studio, SSIS/DTS, Informatica, Pentaho

Application Server & language: Java/C#, Net/ASP.net, ADO.net, Python, VB.Net, XML, HTML, Restful, MS Report, SAS. Confidential MQ, C/C++, Webogic/WebSphere/Tomcat/JBoss, CSS, Excel, CVS, Tableau, Business Object

Operation system and network: Unix/Linux/Solaris/AIX, Windows, Mainframe, SAN/VMware, NetApp, TCP/IP.

Operation Language: PowerShell, Unix shell script (Perl, ksh, sh, csh, awk), C/C++, DBI, SAN, NetApp

PROFESSIONAL EXPERIENCE:

Confidential

Sr. Database Engineer/Architect

Responsibilities:

• Responsible for administering multiple database and application in varied operation environments: Oracle (RAC, ASM), and Sybase ASE in Solaris and SQL Server in Window OS.
• Responsible to web application / database architecture/design, modeling, application integration and PL/SQL implementation. Perform configuration, deployment of web application and database server.
• Write complex PL/SQL or TSQL stored procedure packages for web application and implementeddatabase related process modules with Java/C#/Python.
• Write Peral/Unix/Linux shell (ksh, csh, awk) script to create tools for Trade application Murex monitoring, and automation process and database maintenance job of Oracle, Sybase such as configuration, audit and database refresh.
• Attention to detail. Quickly identify and respond to application/database incident (improperconfiguration parameters, issues of connectivity, application hang, query optimization, process blocked, indexes or table fragmentation…) in a short time. Optimize SQL query/PL/SQL stored procedure to improve response time.
• Lead planning, design, and development tasks/projects to meet business requirements such as audit and security enhancement, initiatives of logical & physical data models, access method (index or partition), database environment change, set new server environment and disk/resource allocation, creating stored trigger to audit the sensitive data change and initiatives of databases to AWS migration,
• Perform development daily support, such as support data conversion and ETL process, work on data structure change and tune the application code, rebuild index and update Statistics. Work on optimizing or restructuring the complicate stored procedure packages.
• Perform Data Analysis for end user data request, attention to detail, provide actual ad-hoc queryr SQL script or stored procedure. Write database automation scripts for database maintenanceprocess, audit, data load, and management.
• Troubleshot database\application performance issues in system, instance and code level. Identify andresolve the issues, such as database/data warehouse design, configuration, SQL query, transaction log, blocking/lock, system throughput, concurrency, latch, and replication latency, check performance related workload using SQL Profile and trace. fix the related scripts by modify SQL code and stored procedures using SQL nest queries, join order, right lock mode, quick commit, adding enough filters to speed up high volume transaction data processing. Modify the existed stored procedures or query to improve response time.
• Maintain high availability/high volume of databases/warehouse and application in 24/7 environment
• (Oracle Data Guard, MSSQL Failover Clustering, replication, mirroring, log shipping, backup and restore, database software installation and upgrade in production, development and UAT environments.
• Create Database/Data Warehouse associated physical data structure and environment architecture.
• Ensure adequate database resources allocated to the business, consistent with priorities to delivery effective and efficient design and required data sets.
• Migrate SQL and Oracle Database/Warehouse to AWS cloud using EC2, S3, RDS and Redshift.
• Install and configure Hbase and setup Spark in HDFS. Write programming of Hive, Spark/Scala for big data analysis in Hadoop environments.
• Worked closely with users for data and functional requirements. Gathered and defined the requirements
• Participated in application design. Created application component diagram, class diagram, processdiagram and sequence diagram (UML) to capture business logic for real time Network engine web service architecture.
• Implemented the core components (run multithreading in daemon to store, extract data from the serversocket through multithread concurrency and bulk data load into near real time Oracle database and generate the failed process to network Center using Spring Boot, microservices / Restful Servicemultithread, Spring JDBC/JPA/Hibernate to create Net Call Service with GUI AngularJS 2.
• Created JDBC stored procedure modules. Worked on query optimization.
• Reponding to client requests in a timely manner. Analysized alternative to develop recommenation, quick troubleshoot, or effective design and implemeation new capibilities in various level.
• The application started from ground up: independently installed window server 12R2, installed database Server 2017, Visual Studio 2017, and Microsoft Reporting Server, designed and developed database and application which allows secured user to manipulate data and generate reports with *.pdf, doc or excel format. Completed IIS application server configuration and publish to intranet.
• Designed layout of web pages. Generate mockup for user to view the application presentation layer.
• Designed classes and application modules using C# and developed GUI based on Razor, Asp.net.
• Implemented web applications code using Microsoft MVC controller/Razor, C#/Asp, AJAX, LINQBootstrap, and JQuery in Visual Studio 2017 and .NET 4.0 framework environment.
• Created management module for adding user, grant roles and view user role status.
• Created application security control, or using Dashboard for team user to access and perform tasks.
• Deployed application in dedicated server and VM server. Deploy application to Intranet. When testthere are only few format fix. All users appraised that processing data reliable and user - friendly .
• As a key person, responsible to design and develop Centralized Enterprise Data warehouse which isincluded legacy system and other RDBMS with consistent central view.. Reviewed existing warehousing models and architecture leading to new development that improved existing warehouse and reporting loading. Define roadmap.. Identify the existing system and business processes associated with line operational activity in each of the key service areas with operations staff and system users to gather requirements.. . Develop specifications for data warehouse configurations, storage, security and network.. Translate business requirements to detail design. Architect data systems and business processesperational data store and warehouse models for centralized reporting customer.
• Developed business process models, E/R models, dimensional data Models, and naming standards.. Refine and implemented ETL process (data Extract, Transform and Load for warehouse and
• Operational Data Store (ODS) included analyzing the cause of data inconsistence and data incompletion and perform de-dup, look up and data clean to ensure data quality.
• Created Database/Data Warehouse associated physical structure (table, view, keys, index and partition) environments. Ensured adequate database resources allocated to delivery effective and efficient database process.. Highlighted gaps in reporting and data management capabilities, developed mitigation strategies.. Created multiple business level documents around data and business processes and metadataManagement including data dictionaries, data flow diagram, database policies and update operational procedures .. Support OLAP data requirements to develop customer analysis & reporting.. Enhance data warehouse database performance tuning including configuration and loading process.

Confidential

Database Architect Leader

Responsibilities:

• Lead designing efficient Information Management and warehouse Solutions from data to presentation layer on-time and on-budget. Provide leadership to team including mentorship, web application data process, RDMBS data management and batch control.
• Wrote the boundle of Perl/sh script, PL/SQL and RMAN script to automate for database refresh.
• Implement JDBC PL/SQL module to retrieve and update data from web application to databases.
• Worked closely with the development team to fix the bugs in prioritizing the issues in a daily basis.
• Communicated and supported the customer and application development teams. Provided advice and effective solution on design, development, and system integration to meet business requirements.
• Solve the problems related data design, data retrieve and SQL code optimazation. Coordinate with cross-functional teams related operation maintanence jobs, release management and deployment.
• Make continuous improvement efforts to enhance database performance efficiency. Identify the root cause and tune database from OS level, instance level, physical design and related PL/SQL codeT-SQL, SSIS/SSAS/SSRS package or stored procedure or in ETL load processing from Informatics.
• As a lead data architect/Sr. Data Engineer was responsible for gathering requirements from the users, facilitate sessions and delivering the strategies for the proposed solutions. Designed and Implemented robust Pension Tracking System which had batch and reporting processes.
• Worked on Business Process and Data Flow Analysis, initiate logical and physical data models creation using Erwin.
• Involved in design and implement a data-cleansing algorithm; Extended the OLAP database to support required data (aggregated and transactional) including star schema design, worked on
• ETL process using Informatics and generated Cognos reporting.
• Analyzed and found the performance issues in E*file replication software. Provided the modified script to Confidential development team by restructuring the poor designed programming.
• Monitored system, database utilization, scheduled job execution. Identify and troubleshoot day to day and application issues related backgorund process: database hang or lock, long wait event because f memory, diskspace, I/O, Undo, CPU, database configuration, SQL/TSQL problems.
• Provided the suggest to infrastructure director that DBA team had to migrate selected databases to ther servers to solve serious memory problems which impacted 32 databases servers.
• Project: Developed Missing System Java web application
• Worked as database and application architect. Developed and maintained large scare, complex enterprise application for PBGC using J2ee/Java, Spring frame work. The system processes documentation authorization, reconciliation, payment and debit management.
• Responsible to identify requirement and application detail design. Provided effective solution on integration to meet business requirements.
• Throughly understand the system processes included system documentation authorization, reconciliation, payment, debit and archive management. Create Java class diagram and process diagram and presentaion tire UML diagram.
• Designed the data modeling for payment and debit system and generated physical model.
• Implemented components of payment system and debit management Debit using core Java, Severlet, JMS, JavaScript, Jsp, CSS, XML and their backend stored procedures of “Invoice” and ‘Debit’.
• Configured and deployed application in Tomcat server.
• Reponding to client requests in a timely manner. Analysize alternative to develop recommenation, quick troubleshoot or effective design and implemeation new capibilities in various levels for production enhancement.
• Responsible for code view and helping junior developer.

Confidential

Lead Database Administrator / Sr. Developer

Responsibilities:

• Conducted one-on-one sessions with business users to gather data warehouse regarding to data warehouse customization including detailed descriptions of business entities and attributes. Analyzed business process and rules, translated them into technical specification. Developed strategies to consolidated diverse data sources from different system.
• Created dimensional modeling by identifying required dimensions and facts using Erwin included conform data mart. Using DDL to create along with Physical Data Model in forward engineering, or created data objects with naming standard, data optimizing storage and index option.
• Worked with database engineers for target data mapping, transformation, loading, which conducteddata flow and control flow in processes of SQL SSIS (ETL package) by create T-SQL store procedures, function, etc. Prepared document for smooth transition from testing to implementation.
• Maintained stable Oracle, SQL Server, and Sybase operating environment. Performeddatabase configuration, capacity planning, backup and service packs/Patch. Identified the issues and rapidly resloved the issues reported from pager and got database back and running.
• Administered all database objects and database security. Implemented users privileges, and wrote
• SQL script / stored procedure/trigger to perform database backup, refresh, file compressing and audit critical table value change. Tested data migration and integration.
• Performed data warehouse performance tuning. Solved the problem of batch job slowness. Tuned thequeries that fact table joins with dimension table and memory setting.
• Migrated databases from platform Sun Solaris to Linux.
• Installed, configured, maintained Oracle RAC, and setup ASM instance.
• Participated in upgrading all of 10g databases to 11g.
• Performed DBA support for development teams. Worked on the request related database refreshbackup, script execution, configuration, and T-SQL code optimation.
• Write script used in CRONTAB to monitor database performance and execute maintenance tasks
• Completed the design documentation.

Confidential

Sr. Database Administrator/Architect

Responsibilities:

• Defined, analyzed and prepared data and information for the planning and execution of strategicplans, and work breakdown structure. Coordinated project members, documented developmentmanaged changes and tracked problems
• Consulted with customers to identify and specify requirements, as well as needed assessment.
• Worked with team to gather and analyze detail information from source system, identify internal and external data sources, performed complex implementation analyses between SAP and Oracle Financial system, conducted data conversion, interface strategy, and process flow.
• Communicated with users intensively related the requirement of data maps between SAP financials (MS SQL Server based) and Oracle financial system. Ensured integration of all systems components.
• Lead the team to perform migration tasks used Oracle Financials framework for inbound and outbound communications. Implementing Oracle stored procedure, control file, shell script to handle data extracting, cleaning, transformation, and integration and load to the stage tables,and then populate the accounting base tables using Oracle financials GL/AP/AR/PO modules.
• Resolved and traced critical issues to minimize the risk. Followed up with clients to verify satisfaction.
• Performed Database Management tasks include: installing, upgrading, maintaining database server software and hardware, managing data security, backups/recovery and performance. Troubleshooting of problems on a daily basis.
• Worked on remedy tickets.
• Performed database health check: proactive and reactive responses to monitor/tune database performance. Diagnosed complex issues or bottleneck in system, database, application processing included SAS program using a variety of diagnostic and performance tools, such as DBartisan, Microsoft EM, Grid Control, AWR, Tuning Advisor, MS system performance counter, sysperfinfo, or rebuild index and schedule table defragmentation in proper timeframe.
• Implemented database administration utilities using Unix, SQL or stored procedure provided by vendors for database backup, monitoring, and DBMS job schedule.
• Completed the tasks upon called by Confidential DBA team head to help the other Confidential development team to rewrite the created stored packages which many returned data is incorrect. Got Confidential as helping other project to meet the deadline.
• Created stored procedures and shell script to extract the scanned files stored in Oracle Blob, and convert PL/SQL format into window format for being displayed in website.
• Participated in the project of migrating corporation accounting system from SAP financials to Oracle Fusion Financials. Provided data mapping support and recommendation of application integration.
• Performed after- hours troubleshooting and scheduled off-hour maintenance operations., such as

Confidential

Database Administrator/ / Sr. Developer

Responsibilities:

• Initiated and developed relation databases design. Provided logical and physical data modeling and Entity Relationship(ER) diagrams.
• Created near real time database, implemented security control and Backup & recovery strategies.
• Create database schema, objects, indexes, constraints, and triggers.
• Designed and implemented Backup & recovery strategies and Security policy
• Wrote complicated Perl and Java network programming to extract data from internet, categorize by VOIP types and load into near real time database.
• Developed and implemented web application database retrieval modules using JDBC and stored procedure.
• Performed maintenance, monitoring and tuning of database instances/servers to maintain optimal server health allowing maximum throughput and minimal resource contention.
• Performed query optimization, capacity analysis and database performance tuning. Reviewed and recommended improvements to meet user expectations.

Confidential

Oracle/DB2 Data Modeler / Software Engineer

Responsibilities:

• Worked with the function analysts to understand the business process, prioritize and rationalize the tasks. Identifying and documenting the business, technical, product and process requirements.
• Participated in application architecture design, detail design and test plan. Developed an integrated system included six subsystems to process travel document, reservation, invoice, payment, debt management, and archive.
• Reverse and forward engineered the data structures of the newly system. Created data modelsf following subject areas: travel document, payment, and debt management.
• Viewed system design and application UML diagrams. Provided technical oversight and input.
• Supported web application development team. Created stored packages and wrote JDBCdata modules to retrieve the data for the application components of INVOICE and PAYMENT.
• Troubleshot the performance issues in database and application.
• Worked on database analysis, security requirement, data structure change for customer

Confidential

Computer Scientist (Perl programmer/Oracle DBA)

Responsibilities:

• Participated in design and implementation of the components of acquisition, storage, distribution,maintenance of materiel and transport of personnel
• Responsible to write Perl modules for the most complex transportation background processes
• Developed and performed data conversion ETL program which handled imported files fromdisparate legacy formats, operational data store, data cleansing and business rule enforcement.
• Created aggregation tables for geographic and demographic account periodic snapshots based n the requirements.
• Created index, trigger and wrote shell script to automatically execute script on remote server.
• Administered database objects and security. Performed database backup, migration, and patch.
• Worked on database health check (proactive and reactive); Provided impact information onproposed changes to application and its database structure.
• Converted the CGI Perl based web application to Java based web application in an intense and