SUMMARY:

• Over 10 years of UNIX system admin/Oracle DBA experience, including 5 years as Oracle E - business Suite DBA in development and production environments.
• Implemented database security using Oracle's Transparent Data Encryption based on Database Security technical Implementation Guide (STIG) developed by Defense Information Systems Agency (DISA)
• More than 4 years experience as a SQL Server 2005/2008 database administrator.
• Skilled in designing and implementing complete life cycle client servers and database applications with various development tools.
• 3 years of installing, implementing and maintaining Oracle Goldengate 11g.
• Manage internal databases, from planning to testing stages and through implementation and support.
• In-depth understanding of security and backup procedures to ensure database integrity.
• Background in developing backup and disaster recovery plans for nationwide offices.
• Superior communication, presentation, analytical and problem solving skill. Work well with all levels of business.
• More than 5 years experience in Oracle standby and RAC database environments that includes installation, configuration, maintenance and troubleshooting.
• More than 4 years experience in MYSQL environments that includes installation, configuration, maintenance and troubleshooting.

TECHNICAL SKILLS:

Databases: Oracle 7.3.4, 8, 804, 8i, 9i, 10G, 11.2, 12c, SQL Server 2000/2005/2008, MySql5.1

Oracle Applications: 1103, 11.5.8, 11.5.10.2, Oracle RAC 10G

Middleware: Oracle ATG Web Commerce 4.5.1, Oracle Application technology stack, Kerberos Authentication single sign on, Oracle Golden Gate 11G.

Tools: ASM, VERITAS LVM 2.6, TOAD, OEM, AWR, ASH, ADDM, TKPROF, Splunk, BigdataOperating Systems: Solaris, Hp-UX, Linux, Window XP, Window 2000/2003

Protocols: SMTP, SNMP, ICMP, TCP/IP, FTP, TELNET, UDP, and RIP

Naming Services: DNS, NIS, NIS+, LDAP

Backup Tools: VERITAS NetBackup 5/6/6.5, Ufsdump, Ufsrestore, tar, dd, cpio

Script Languages: Shell Scripts (Korn/Bourn)

PROFESSIONAL EXPERIENCE:

Confidential, Santa Clara, CA

Performance Support Engineer

Responsibilities:

• Analyze java and apache log files to determine root cause of performance problem related to Java based applications.
• Work with Implementation teams, Engineering, Product, and System Operations to triage and address production issues.
• Gather and analyze information, evaluate impacts, resolve or escalate issues as needed.
• Troubleshoot issues and participate in on-call support, ensuring stability and performance of the client’s production environment.
• Ensure support service level agreements (SLAs) are managed and met.
• Work on special projects to help improve processes, documentation, and overall client experience.
• Provide initial assessment and possible workaround of production websites and databases issues.

Confidential, Fairfield, CA

Oracle Database Administrator

Responsibilities:

• 24/7 support for 200+ Production/Development/Testing databases.
• Worked on Database upgrades from 10g to 11g for 30 databases in span of 3 months.
• Creating the database, tables, tablespaces, data objects, setting privileges, indexes, user logins, password (security).
• Creating new databases, configuring backups and maintaining the databases. Tune the databases and SQL queries. Backups using vendor specific tools and Oracle utilities like RMAN. The tuning and indexing the database and schema for efficient query execution plan.
• Works with application developers to optimize and tune programmatic database access.
• Monitor production systems and databases daily using Enterprise Manager.
• Audit and update Database Security User Management, Privileges, Roles, Profiling, and Authentication.
• Convert existing database tablespaces to Oracle Transparent data encryption (TDE).
• Maintained Data Guard environment, able to manage many schemas, create DDLs when needed, optimize and develop complex queries and execute weekly deployments to various environments.
• Executed and provided ADDM, AWR and database health check reports to information owners and recommended solutions for improved performance.
• Designed, developed, tested, deployed and maintained database security and audit solutions
• Took ownership of complex database incidents and problems and provided resolutions in a speedy and timely manner.
• Engaged subject matter experts and information owners to provide assistance to resolve more complex incidents as required for maximum availability of Oracle applications.
• Monitoring the availability of system, listener, database, alter log file, trace file.
• Installed GoldenGate software in Test and dev instances
• Configured Goldengate on production servers by preparing GoldenGate parameter files for Extraction and Replication.
• Investigate, trace fix and report replication failures using LogDump.

Confidential, Las Vegas, NV

Sr. Oracle Database Administrator

Responsibilities:

• Created and maintained the technical infrastructure of the test, QA and Production environments.
• Proactive monitoring, identifying areas that need to be improved in the application and database using AWR, ADDM and OEM Grid Control.
• Database performance tuning at system and application levels, for dev and production databases.
• Design and Implement disaster recovery plans for production databases.
• Implement Database User Security that includes Privileges, Roles, Auditing, and Authentication.
• Convert existing database tablespaces to Oracle Transparent data encryption(TDE)
• Increased the audit ability of the database to insure compliance with Sarbanes Oxley reporting requirements.
• Develop scripts for database task scheduling, monitoring and maintenance.
• Help other developers to understand and best utilize the Oracle database.
• Work with DEV, QA, Ops and IT on all Oracle related database and application projects.
• Moved multiple production databases from non ASM to Oracle ASM file system.

Sr. Oracle DBA

Confidential

Responsibilities:

• Creates strategic (3-5) year plans to improve and mature the DB environments.
• Design database physical and logical layout and procedures for PROD, UAT, Dev, QA, Test and Training servers.
• Proactive Database tuning to keep hit ratios at a minimum standard guideline using Stats-pack and AWR reports
• Designed, developed, tested, deployed and maintained database security and audit solutions.
• Convert existing database tablespaces to Oracle Transparent data encryption (TDE).
• Configured Goldengate on production servers.
• Test impact of multiple Extract and Replicat processes on a Single Node
• Prepare GoldenGate parameter files for Extraction and Replication
• Investigate, trace fix and report replication failures using LogDump.
• Work closely with systems engineers and developers to test planned databases upgrades, including definitions, structures, and documentation, as well as provide input into long-range database requirements and operational guidelines.
• Troubleshoot and resolve database and application problems encountered by end users.
• Responsible for maintenance and 24x7 Support of multi-terabyte databases (Oracle 8i, 9i, 10g,11g) in production, testing and development environments hosted on Unix servers (HP, Linux) and Windows servers
• Review system logs to determine usage levels, performance, and security posture of systems. Report misuse or security breaches immediately to the network management.
• Responsible for implementation and release of database changes as submitted by the development team.
• Deployed/Maintain Oracle Kerberos Authentication single sign on for Oracle Production databases.
• Plan and execute database upgrades and migrations across all supported database platforms.
• Plan and execute database cloning cycles from production to non-production databases.
• Responsible for providing trend analysis to the service management team to enable them to make informed decisions regarding resource management.
• Deployed/Maintain Oracle Data Guard as a DR for all Production databases.
• Responsible for problem escalation to Oracle Development team and third parties as appropriate.
• Formulate monitoring and alert policies, procedures and standards relating to database management.
• Propose and implement enhancements that will improve the performance and reliability of all production landscape system.
• Proactively research and locate necessary tools and processes to identify and proactively avert troublesome trends, as they develop in order to ensure a stable and high performance environment for the Chevron production systems.

Sr. Oracle DBA

Confidential

Responsibilities:

• Lead a global team of DBAs that are responsible for implementation and management of I- many enterprise applications and infrastructure built for hosting Service.
• Administer UNIX systems used to run infrastructure, e.g. website, backups, etc. Manage the inventory process and inventory database.
• Deployed/Maintain Oracle Data Guard as a DR for all Production databases.
• Use Oracle grid control/Automated scripts to verify and monitor the health and integrity of databases.
• Migrate multiple production databases from file system to Oracle ASM.
• Successfully set up a four-node cluster and RAC data warehouse on Linux (Oracle UBL) using ASM/OCFS2.
• Work actively on new 11g features such as AWR, ADDM, and ASH, performance statistics collection, and fine tuning database wait events. Provide on-call support for enterprise databases.
• Started and managed biweekly optimization meetings with enterprise user groups to address and resolve performance-related issues with a high degree of success.
• Refresh test and development database environments from production database
• Analyze upcoming changes to database/applications for their impact on customers and products.
• Research, evaluates and recommends new technologies.
• Responsible for configuration, customizations, and integration of applications for current and future business needs of the company.
• Provide architectural guidance and planning for implementation and enhancement of projects.
• Assist project management and program management personnel in incorporating development project plan into overall project plan.
• Ensure that customizations and integrations are designed in accordance with the work plan and company standards.
• Installed GoldenGate software in Test and production system instances
• Configured Goldengate on production servers
• Test impact of multiple Extract and Replicat processes on a Single Node
• Prepare GoldenGate parameter files for Extraction and Replication.
• Investigate, trace fix and report replication failures using LogDump
• Assist programmers in the development process where appropriate database design efforts are required.
• Used scripting to automate daily database health check where oracle grid control is not used.
• Work cooperatively with project team members, including IT, development, and contractor and customer, to ensure task completion is proceeding on schedule.
• Day-to-day management activities of production databases for online system operations including monitoring, troubleshooting, backup, restore and storage management
• Participate in planning and design of the database architecture for large scale, production-quality services.

Sr. Oracle Applications DBA

Confidential

Responsibilities:

• Patched, configured, and maintained production, development, and testing instances.
• Enhanced and maintained 11i clone procedure.
• Enhanced and maintained 11i disaster recovery procedure.
• Successfully upgraded Oracle Applications from 11.5.9 to 11.5.10.2.
• Successfully upgraded Oracle Applications database from 11.0.3 to 11.5.9.
• Aggressively worked with Oracle Support to solve open Service Requests.
• Supported the development team and enforced change control.
• Deployed/Maintain Oracle Kerberos Authentication single sign on for Oracle Production databases.
• Implement and maintain database security.
• Oracle Enterprise manager and Quest tools for Database monitoring & management
• Troubleshooting skills of technical issues with the ERP applications configuration
• Monitored concurrent processes / spawned processes so that performance of the system is maintained.
• Manage Microsoft sql server day-to-day management activities of production databases for online system operations including monitoring, troubleshooting, backup, and restore.
• Managing and controlling security for various projects in Oracle Database
• Refresh of databases from backup of production databases
• Handled team leader role to manage and delegate various syadmin tasks for global production and review of each task.
• Day-to-day management activities of production databases for online system operations including monitoring, troubleshooting, backup, restore and storage management.

Sr. Oracle Applications DBA

Confidential

Responsibilities:

• Perform database administration and maintenance functions in support of PROD, TEST, UAT and development environments
• Share key learning experiences with team members to help them avoid known pitfalls
• Direct and assists in review of present systems and methods to determine appropriate changes that effect improvements, reduce costs and enhance efficiency.
• Apply applications and databases patches to proven and stable releases.
• Use Quest Spotlight /Automate scripts to verify and monitor the health and integrity of databases.
• Set up and Maintain users accounts and security.
• Work with vendors to identify and resolve technical problems.
• Provide access to database environments for project and testing staff.
• Automate routine database administration tasks.
• Conduct regularly scheduled environmental assessments and recommend corrective action based on the findings.
• Develop and test backup and disaster recovery plans / scenarios, and generate required documentation to execute the recovery plan.
• Work with SOX administrator and product managers to develop and execute relevant security policies.
• Perform application/database cloning.
• Manage software and operating system version control across all environments.