PROFESSIONAL EXPERIENCE

Confidential

Lead System Consultant

Responsibilities:

• Expert Knowledge of using AWR, ADDR, SQL and segment advisors, Explain Plan, OEM for DB and SQL tuning.
• Supported Oracle CRM and BRM applications. Tuned SQL queries and improved performance of existing reports. Gathered requirements and Delivered new reports for various group such as finance, operations and marketing.
• Wrote complex PL/SQL programs to extract data from five different billing systems (Oracle CRM, BRM and POS) and compare data to reconcile these transaction amounts among these different systems to make sure that no payments are missing.
• Work with internal and external clients in Finance, Billing, Marketing and operations as well as end users on day to day issues
• Install, configure and manage all enterprise database environments, including: development, test, training, sandbox and production.
• Installed EM12c to monitor both databases and other Oracle applications.
• Wrote detailed documents, run books and share knowledge with junior team members.
• Have strong problem solving skills and be able to develop quick and sound solutions to resolve complex issues.
• Installed and deployed Oracle Business Intelligence Applications (7.9.6.x) including Weblogic from scratch on Linux,
• Implemented large scale projects and work with internal and external clients in Finance, Billing, Marketing and operations as well as end users on day to day issues.
• Gave guidelines to system administrator on how to build server infrastructure for database applications. Have deep understanding on database concepts and architecture.
• Wrote UNIX Shell Scripts to read files and call Oracle PL/SQL procedures. Served as key resource for software developers on database questions and PL/SQL issues.
• Extensive Experiences in integrating Oracle OBIEE with Oracle Applications.

Confidential

Oracle DBA

Responsibilities:

• Installed databases on more than 50+ servers from development to production environments. Also, performed from many database upgrades.
• Install, configure and manage all enterprise database environments, including: development, test, training, sandbox and production.
• In conjunction with enterprise application and server administrators, designs, implements and manages HA and DRP capabilities for enterprise applications. Leverages database utilities where appropriate to support HA.
• Monitor and tune performance, working across application, server/storage, database and functional support areas to tune system for optimal performance. Build and maintains a comprehensive performance management toolkit focused on proactive performance management.
• Work with management and security team to assist in implementing and enforcing security policies. Creates and manages user and security profiles, ensuring application security policies and procedures are followed.

Confidential

SENIOR DATABASE ADMINSTRATOR

Responsibilities:

• Monitor database and application performance using different tools and tune database and application as needed. Control workload through concurrent manager. Automated routing jobs such as rebuilding tables and index and monitoring database usage to reduce and simplify daily tasks. Add space and data files when it is necessary.
• Worked with a team upgrade E - Business Suite from 11i to R12. Went through multiple cycles of testing and deployment starting from installations,
• Perform regular DBA duties, such as apply patches for Database, E-Business Suite. To streamline of testing and deployment, merge multiple patches together. Trouble shoot and solve issues related to the patches.
• Clone production database to setup development and test instances. Support developers in test environment and helped them write PL/SQL scripts.
• Supported functional team and end users in production environment. Work with both end users and developer to resolve complex problems and issues. Sometimes also get Oracle support involved.
• Wrote detailed documents procedures and processes so other people can perform the same task when it is necessary. Also draw diagrams to describe architectures.
• Installed 10g RAC Environment to host mobile application. Utilized ASM technology. Perform and monitor backup using RMAN.
• Projects and Task Related Data Warehousing (OBIEE OWB & Discoverer)
• Installed Fusion Middleware 11gR1, including Weblogic 11g. Upgrade Oracle Discoverer from 10g to 11gR1 (11.1.3) in 2010.
• Installed OBIEE 11g on Linux system, setup development and test environment for upgrade OBIEE from 10g to 11g. Integrated Weblogic LDAP authentication with Microsoft Active Directory Authentication.
• Set up brand new Oracle Data Warehousing Environment by using pure Oracle Technology in 2008. Installed Oracle Business Intelligence Enterprise Edition (OBIEE formerly Siebel Analytics) 10gR3 independently including Oracle Application Server configured authentication integration with E-Business Suit R12. Users can launch dashboard and drill down the results within E-Business Suit.
• Upgraded data warehouse environment from Oracle 10gR2 to Oracle 11gR2, including Oracle Ware house Builder and Oracle Discoverer.
• Have Setup OBIEE scheduler on 10gR3 and have uprated it Oracle 11g.
• Wrote detailed documents about data warehouse environment, draw diagrams to describe architectures

Confidential

SENIOR DATA ANALYST

Responsibilities:

• Analyze, design, and develop Data Warehouse database and application to host data from different Telecom Companies and match customer’s data with Confidential credit files for the purpose of credit and identity verification. The application produces multi-million dollar revenue each year.
• Load data from flat text files sent by customers each day. Using an ETL Tools to do data validation and transformation.
• Write Oracle queries for large-scale and sophisticated data analysis and reporting required by the clients and internal customer using Oracle PL/SQL, Toad, SQL/Loader, SQL/Plus.
• Mentor junior staff in Oracle PL/SQL, UNIX Shell Scripting writing, and Oracle query tuning.
• Work with team set up standard on naming and implementation conventions.
• Wrote UNIX Shell Scripts to read files from file system and call Oracle PL/SQL procedures and Oracle WorkFlow from the UNIX operating system. Served as key resource for software developers on database questions and PL/SQL issues.

Confidential

ORACLE DBA/DEVELOPER

Responsibilities:

• Developed and modified existing response file to install Oracle 10g software silently on clients’ sites, also wrote scripts to upgrade database from 9i to 10g automatically.
• Supported Clients’ database remotely, such as purge unwanted data or trash data and re-build indexes. Now and then, have to recover databases for them.
• Wrote test cases, test scripts and related documents and facilitated QA department to do testing.
• Designed and Implemented new features to existing administration tools using PL/SQL and JavaScripts.