SUMMARY

• Reliable, Responsible, Trusted, Proactive & Reactive Oracle Database Administrator, Engineer, Data and System Analyst, and most importantly as It professional with expertise in crisis management, performance tuning, and high availability to increase reliability, maximize productivity and ensure system efficiencies.
• Adept at all stages of project lifecycle, from business requirements and technical definitions to testing, documentation, production support, training and completion.

TECHNICAL SKILLS

• Proficient in all DBA responsibilities such as Installation, Configuration, Upgrades, Patches, Performance Tuning, Schedule Backup in both archived and non - archived mode, RMAN Recovery Catalog, Cloning, Space management, Database Security, Auditing, Troubleshooting, Database Design, Unix Shell Scripting and Documentation.
• Implement Oracle Enterprise Manager Grid Control (OEM 11g/10g) for centralized monitoring and administration.
• SQL server Reporting Services and other business intelligence tools
• Configure oracle middleware fusion suite, and different applications (weblogic, SOA suite, oracle form and report, etc)
• Extremely detail-oriented and able to follow standard methodologies for troubleshooting and development
• Comprehensive knowledge of database administration (design, installation & troubleshooting)
• Planned and implemented high availability solutions using Oracle 11g/10g RAC; Standby Database using Oracle Data Guard and
• Experience using TOAD, Oracle SQL developer for data Modeling and movement.
• Operating Systems: Installation and Configuration of Unix/Linux, Windows 2003-08 for Oracle database, ASM and Oracle discoverer installation.
• Provided 24x7 production support for Oracle 11g/10g databases
• Tools: SQL*Plus, Enterprise Manager Grid Control, SQL Loader, Oracle Recovery Manager(RMAN), SQL Advisor, Control Advisor, DBMS Xplain Plan Automated Workload Repository (AWR), Scheduler, Data Pump, Real Application Clusters (RAC), Partitioning, Active Data Guard, Unix Shell Scripting, Automatic Storage Management (ASM), Data Archiving, TOAD, FTP,SFTP,MobaxTerm, SecureCRT, Enterprise Reporting with Oracle Forms and Reports, EMC Avamar, Microsoft Offices, Networking, Weblogic Application Deployment
• Advance PL/SQL, development of store procedure, functions and packages for Business intelligence and logic.
• Experience working with EMC to provide high-speed backup and recovery to multiple DBs to ensure high availability
• Business Analyst, Software Development Life Circle (SDLC) Agile methodology, Agile Scrum, V-model and Water fall, software testing skill
• Understanding how to transact data across different (heterogeneous) environment in real time using Golden Gate
• Understanding of Total Quality Management, Quality analysis and its application
• Fundamental of project Managements, Civil & environmental engineering, hydrological/geotechnical engineering, Highway/Hydrological/Dam Engineering Design
• Refinery Piping Instrumentation& Design/schematics, Refinery Operation and Management, Reservoir and well operation
• OSHA training online /environmental law and ethics training
• Chinese Design & Construction Schematics,
• Proficiency in AutoCAD Schematics, with strong Mechanical aptitude, Strong mathematical skill in Algebra, Pre-calculus, Calculus and Statistics using Calculator and Minitab, SPSS,C#, HTML

PROFESSIONAL EXPERIENCE

 Oracle Database Administrator

• Installing and configuring Oracle Enterprise Confidential Linux operating system versions and Windows 2008/2012 servers for Relational (RDB) and Multidimensional Databases (MDB) installation and creation, configuring real application cluster, installing Oracle grid infrastructures & Oracle database software to meet the current needs and upgraded as required to meet the expansion needs of the company.
• Creating, migrating and backing up database for various clients.
• Work on a project with a team of 5 and successfully analyzed, recommended and implemented an active Oracle Data Guard, Real application Cluster to improve Oracle data protection, data availability and disaster recovery to enable easier monitoring and management system in both OLTP and data warehousing environment
• Part of a team of 3 to execute a project to configure multiple databases for different Counties Confidential for basic backup and disaster recovery that resolved data loss problems for the entire county database.
• Part of a team of 3 who successfully upgrade multiple databases and carried out short term performance tuning, maintenance and training for continuous operation 
• Carrying out Oracle Database maintenance base lining, performance tuning, alert configuration, using snap shots taking by Automatic Database Diagnostic Monitor  to generate performance reports, monitoring database performance, securing & protecting information/database with unique secure configurations, data encryption and masking

Database Engineer 

• Building test strategies, backup & recovery models for Oracle. Refreshing test databases.
• Managing backup & Recovery for Oracle on Confidential Linux using RMAN
• Team work with the developer and other project team member to achieve the goal of each project within the time frame
• Going through the day-to-day user requests and troubleshooting the database related problems.
• Linux shell scripting for monitoring oracle Database status, security & backups.
• Monitored tablespace size, resizing tablespace, relocating data files for better disk I/O.
• Created user, allocation of appropriate tablespace quotas with necessary privileges and roles for Oracle databases.
• Carry out SQL Server database backup (full and differential)
• Perform Data and Database object replication on SQL server database
• Part of the team of four, create backup plan design and implementation using cold/hot backups, Flash copy, RMAN backup, ASM and RAC technology.
• Monitoring Performance and running trace using SQL profiler
• Using activity monitor to monitor Processes, Data file I/O, Resources Waits, Recent Expensive Queries
• Middleware Installation and deployment of multiple application for business success of our clients
• Used OEM Grid Control Diagnostic and tuning packs to tune the application and SQL queries
• Running queries to retrieve data from multiple tables, ensuring fast and secure access to business application for different users in remote location round the clock, use data to perform business intelligence analysis.
• Deploy, Monitor and Manage different applications performance and prepare report accordingly.
• Keep good relationship with the management to better help the performance of every group, team and the entire organization performance
• Upgrading Oracle Databases from 10g to 11g with team of DBAs
• Provide support for desktop, server and mobile technology
•  Experience configuring network, building server system,  and installing  (both Unix and Window)

Confidential

Industrial attaché Internship

• Part of the team that carried out turn around maintenance at Siemens Power Plant
• Ground water monitoring wellhead installations and soil vapor survey at Confidential Refinery while generating data for impact analysis.
• Provide database report based on every site casing/tubular operations
• Introduction to Database Backup and Recovery
• Seismic and geological data collection and analysis using different geological mining tools
• Assist team operation and perform troubleshooting of servicing equipments
• Soil and groundwater sampling for environmental analyses at Ore Depot
• Hydro-geological analysis and geotechnical investigations for Dam Design and Construction Environmental Remediation, Well drilling data analysis
• Above-ground and underground storage tank management
• Interpretation of piping and instrumentation schematic drawings
• Introduction to Database Design and Administration
• Server Implementation and Configuration Concept
• Interpretation of Network Schematics and IP/Network Adapter configuration
• Perform all duties as assigned