SUMMARY

I have over 15 years of IT experience with extensive background in database management, design and development, which includes Oracle, MS SQL, Sybase database and data warehouse/data mart. Proven technical leadership and performed the roles of production DBA and development DBA in large scale and complex operation environment.

Summary of Experience

• . Expert Database Administration for production development Servers with outstanding troubleshooting
• capabilities included database performance tuning. Quickly and actually identify the cause and fix the issues
• in OS, database configuration, application module, data retrieval or related SQL / TSQL code.
• . Working knowledge of RAC, ASM, DataGuard, Replication, Mirror , Cluster Database in Linux/Unix/Windows.
• . Exceptional programming skill sets in Unix shell script Perl/Sh/Ksh , PL/SQL stored procedure, Java.
• . Hands-on experience design and develop data modeling logical, physical, and multidimensional , metadata
• and establishment of key business processes.
• . Working experience of ETL process of Informatics and SSIS MS SQL .

CONFIDENTIAL

Technical Skill

• ORACLE 11g/10g/9i, OEM/Grid, RMAN, RAC, ASM, Data Guard, PL/SQL, Data Pump, Oracle Financials, Oracle Stream/GoldenGate, SQL Loader, Oracle Data warehouse/BI/, Exadata, peopleSoft
• MS SQL 2012/2008/2005/2000 T-SQL, replication, mirroring, log shipping, SSMS, SSRS, SSIS, Profiler, Idera
• DB2, SYBASE ASE, Sybase Central/DB DBartisan , MySQL, NoSQL
• Database design and ETL tools: Erwin, Oracle Designer, Visio, SSIS/DTS, Informatica
• Operation system: Windows, Unix/Linux/Sun Solaris 8, 9, 10/AIX, TSO/Mainframe MVS 390 ,
• Operation Language: PowerShell, Unix shell script Perl, ksh, sh, csh, awk , SAN, NetApp, SAN
• Application Server language: SAS, Weblogic/WebSphere/Tomcat MicroStrategy/JBoss, Java/C , C/C , .Net/ASP.net, ADO.net, VBScript, XML, HTML. CSS, SAN/VMware, NetApp, Excel, CVS/PVCS, TCP/IP.

CONFIDENTIAL

Sr. Database

• Provide operation support to EQUINOX Enterprise database data warehouse environments Oracle 11g, Microsoft SQL Server 2012/2008/2005 Troubleshoot and promptly respond to database alerts and warnings. Hands-on performance tuning and corporation multi- projects supporting.
• Maintain high availability/high volume of databases in 24/7 environment by using RAC, clustering,
• replication, mirroring, log shipping, Data Guard, Failover Cluster, backup and restore.
• Manage production and development Oracle and SQL Server database infrastructure OLTP
• and OALP . Monitor database replication status, stored procedure and job execution times,
• troubleshoot and respond to database incident included On-call rotation, alerts and warnings quickly.
• Identify and resolve RAC/database performance issues, blocking/deadlocking, connectivity, and data
• replication issues using OEM, DMV,AWR, SSMS, SQL Profile traces, window system counter,
• DBCC and third party monitoring tools.
• Monitor database warehouse storage usage and capacity planning. Troubleshoot database Server
• related CPU, memory, I/O, disk space and other resource contention issues. Move temp databases to
• other driver for easy control and better performance.
• Develop and maintain database maintenance plans, index management and database/replication
• tuning. Perform database planning, database security principles, and general database management
• optimization best practices included adjusting DB server configuration.
• Work with application development staff to view design and tune the application code and help them
• to modify the complicate stored procedures called by SSIS/DTS package and add necessary
• partitions/indexes. Check performance related workload using SQL Profile and trace. Make the chance
• effective to the results. Work under multi task/requests across production, UAT, and development team
• under pressure.
• Manage and implement backup, recovery, and high-availability processes using RMAN. Perform
• database restore/refresh, build database schema, tables, procedures, permissions and SQL jobs based
• on functional specifications and user requirements.
• Review database infrastructure for efficiency improvement opportunities and implement where
• applicable plan, coordinate and execute data migrations.
• Install and configure new database Server for EmPower to test application upgrade
• Provide SQL guidance to operations and development teams.
• Execute database scripts, stored procedures, queries and import export that accompany deployments.
• Provide off hours emergency response support.
• Formulated policies, standards, and procedures with best practise. Wrote SOP document.

CONFIDENTAIL

Sr. Database Administrator / Database Architect Leader

• Maintenance, configuration, and troubleshooting database application issues in Windows platform.
• Lead planning, design, and development tasks/projects to meet business requirements, it is included
• CONFIDENTAIL production and development databases/data warehouse Oracle 11g, SQL Server 2008 in mission critical environments of RAC/ASM, Data guard, CRM, CFS, SAS, mirroring and replication. On-
• Installed, configured and maintained Oracle 11g/12c RAC databases and SQL 2005/2008 databases
• in Cluster, replication and mirror environments.
• Monitored system, database utilization, scheduled job execution and DataGuard log shipping. Identify
• and troubleshoot day to day database and application issues related backgorund process: database
• hang or lock, long wait event because of memory, diskspace, I/O, CPU, database configuration, or
• SQL/TSQL problems using Grid control, AWR, ADDM, TKPROF, DMV, SSMS, IDERA.
• Handled remedy tickets and performed On-call rotation, Determine incidents cause and provide
• solution in a timing manner, which included RAC performance blocking/lock , data warehouse
• database configuration issues.
• Fulfilled the requests, such as database hardening, security enhancement, resource allocation, data
• structure change, creating new database, refreshing/cloning production database o development
• database, data export/import, data load, database restore and recovery. Perform software installation,
• upgrade and patch. Participate in on-call rotation and maintenance schedule.
• developing database implementation/upgrading, create development environments, initiatives of
• logical and physical data models, access method index or partition , and security requirements.
• Setup and configurated Data Guard, test switchover/failover and log shipping.
• Tuned performance of Replication latency
• Made continuous improvement efforts to enhance database performance efficiency. Identify the root
• cause and tune database from OS level, instance level, physical design and related SQL code, PL/SQL
• or T-SQL stored procedure. I have solved many performance issues in database/ data warehouse
• configuration, shared memory, transaction log, concurrency, latch, data retrieve and application code.
• For SQL code optimization, I apply nest queries, join order, right lock mode, quick commit, adding
• enough filters to speed up high-volume transaction data processing.
• Wrote the boundle of shell script, PL/SQL and RMAN script to automate for oracle database refresh.
• Helped to design and create JDBC JAVA modules
• Communicated and supported the customer and application development teams. Provide advice and
• effective solution on design, development, and system integration to help them meet business
• requirements. Solve their problems related data design, data retrieve and SQL TSQL code
• optimazation using grid control, AWR Statspack . Coordinate with cross-functional teams related
• operation maintanence jobs, release management and deployment.
• Analyzed and found the performance issues in E file replication software. Provided the modified
• script to IBM development team by restructuring the poor designed programming.
• Provided the suggest to infrastructure director that DBA team had to migrate selected databases to
• other servers to solve serious memory problems which impacted 32 databases servers.
• Implemented database operation documentation.
• Helped junior DBAs in trouble-shoot and identifing the root cause.

CONFIDENTAIL

Lead Database Administrator

• Worked with database engineers to define data flow, control in processes of ETL using SQL Server SSIS. Prepared the documentation transitioned to production.
• Prepared data modeling fact and dimension tables , logical and physical database design. Star
• Maintained operations of large production and development databases to support online bid auctions to the world's largest 50 retails Wal-Mart, Safeway, Best Buy, etc . Provided database administration and lead warehousing customization., or design and developing new data marts.
• Implemented and maintained stable Oracle, SQL Server, and Sybase operating environment.
• Performed database 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 reference integration.
• 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 data warehouse performance tuning. Solved the problem of batch job slowness Tuned the
• queries that fact table joins with dimension table and memory setting.
• Involved in multiple projects. Communicated with customers about SQL Server data warehouse
• customization. Analyzed business process and rules, translated them into requirements technical
• specification. Developed strategies to consolidated diverse data sources from different system.
• schema included conform data mart with naming standard, data optimizing storage, partition and
• index option.
• Performed DBA support for development teams. Worked on the request related database refresh
• backup, 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.

.

CONFIDENTAIL

Sr. Database Administrator

• and then populate the accounting base tables using Oracle financials GL/AP/AR/PO modules.
• 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.
• Consulted with customers to identify and specify requirements, as well as needed assessment.
• managed changes and tracked problems
• plans, and work breakdown structure. Coordinated project members, documented development,
• Defined, analyzed and prepared data and information for the planning and execution of strategic
• principles and methods.
• system. Managed operational and technological aspects of project by applying project management
• Worked as Project leader. Responsible for full migration from SAP's financial to Oracle Financials
• Project: Oracle Financials Project ERP
• Worked as SQL Server/Oracle/ Sybase databases DBA in client's data center. My responsibility was to setup and maintain data center's production development databases with high availability and provide support to application development.
• 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.
• 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,
• Resolved and traced critical issues to minimize the risk. Followed up with clients to verify satisfaction.

Production database support

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.

Installed RAC and ASM. Using Grid Control to manage instances and services. Monitored cluster

instance inter-connection and analyzed GV view. Diagnosed and fixed the issues in Enqueue.

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 IBM DBA team head to help the other IBM development team to rewrite the created stored packages which many returned data is incorrect. Got IBM award 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

database patching, upgrading, installation and configuration

CONFIDENTAIL

Database Administrator

• Performed the tasks of creating AOL Voice IP real time database architecture. Interacted with AOL Network Operations to analyze business process related network incoming data. Defined and documented overall functional, database requirements, application design and implementation. Provided application baseline infrastructure JAVA and Oracle application under company's architecture and data solution: opening socks to receive transmit large volumes of network incoming data and load into near real time databases to support AOL network numerous interconnections and data storage.
• Responsible to maintaining and development Aol Network application databases SQL Server, Oracle, Sybase and lead VOICE IP projects to design and implement near real time database.
• Performed maintenance, monitoring and tuning of database instances/servers to maintain optimal server health allowing maximum throughput and minimal resource contention.
• 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 query optimization, capacity analysis and database performance tuning. Reviewed and recommended improvements to meet user expectations.

CONFIDENTAIL

Oracle DBA / Software Engineer 5

• Designed and developed the large scale travel system for DOD financial division.
• 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 models of 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 PL/SQL stored packages and wrote JDBC data 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 need. Mentored junior members how to identify the issues.

CONFIDENTAIL

Computer Scientist

• Worked on CONFIDENTAIL application for Defense Logistics System combat service support which is a
• large scale distributed architecture.
• 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 and PL/SQL stored procedures for web database application modules.
• Developed and performed data conversion ETL program which handled imported files from disparate legacy formats, operational data store, data cleansing and business rule enforcement.
• Created aggregation tables for geographic and demographic account periodic snapshots based on 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 on proposed changes to application and its database structure.
• Converted the CGI Perl based web application to Java based web application in an intense and multi - tasking environment using Java, JDBC, Servlet and Jsp.