SUMMARY

• Oracle DBA wif 10+ years of experience including DevOps operation activities, top - performing, highly skilled, and analytical professional wif comprehensive knowledge and skills in database and fusion middleware administration, technical operations, troubleshooting, and application development.
• Expertise in various database administration activities such as instance management, Schema management, Security management, Database migration, Performance Tuning in areas of Applications, Backup implementation, Recovery and Oracle Installation & Configuration, PL/SQL programming.
• Extremely successful at ensuring projects are completed wif a high level of quality, are on schedule, and often under budget.
• Experience in installing, configuring and managing Oracle 10g/11g/12c (RAC and non-RAC) databases, OEM 12c.
• Experienced in administering and maintaining diverse versions of Oracle databases and Fusion Middleware.
• Experience in Fusion Middleware and Database migration, upgrade, and implementation.
• Performed installation, new databases design, configuration, backup, recovery, security, upgrade and schema changes, tuning and data integrity
• Experience in ticketing system incident, change Demods under Jira, identity and access governance and my services.
• Background wif RAC and high availability infrastructure, and proficient in all aspects of design testing and implementation of new and innovative technologies.
• Well versed in Backup and Recovery using RMAN, hot backups, database Cloning, Logical Backups using Import/Export using Data Pump.
• Very fluent in creation of Instances, tablespaces, Indexes, Materialized Views, SQL*Loader, PLSQL packages, objects, roles etc.
• In-depth knowledge in analyzing performance tools of Oracle like Automatic Workload Repository (AWR), ADDM, TKPROF and TUNING ADVISOR.
• Technical documents writing skills wif clear and precise manner of adding business values to the company.
• Offshore knowledge transfer wif documents and tasks in sequential order periodically communicating monthly tasks, weekly tasks.
• Worked in 24/7 production Support as Database Administrator
• Skilled at making critical decisions and resolving complex business challenges in multicultural environments. Articulate communicator wif bilingual proficiency in English and Spanish.

TECHNICAL SKILLS

RDBMS: SQL Server 2008, Oracle 8i, 9i, 10g, 11g, and 12c, RAC

Oracle Tools: SQL*PLUS, SQL*Loader, Export/Import, Expdp/Impdp, Data Guard, Data pump, Oracle Enterprise Manager, TKPROF, AWR/STATSPACK, RMAN and Listener & Service Configuration, Oracle Enterprise Manager (OEM), AWR, ADDM, SQL Developer.

Operating System: UNIX, Red Hat Linux 3x, 4x, 5x, Sun Solaris 8, 9, 10, Windows NT/2000/2003/XP

Language: HTML, JavaScript, SQL, PL/SQL, Perl, Bash, WLST (Python), UNIX Shell Scripting, SQL, PL/SQL, SQL

Applications: Enterprise Manager Cloud Control; SQL*Plus; SQL Developer; ADE; GIT

Middle Tier: OAS 10g; Fusion Middleware wif SOA 11g and 12c

Protocols: FTP, WINSCP, Telnet, TCP/IP, VPN, Client/Server, Client/Server/Web

Database Administration: Oracle 12C,11gR2 RAC, 10g, 9i, 8i, MS SQL server 2008/2005/2000

Software: Outlook 2013, MS-Office 2010/2013, Toad, HTML, ERWIN, OEM, Visio, Oracle Developer 2000 (Forms and Reports), Oracle Web Application Server, Data pump, flashback, ADDM, SQL*Loader, iSQL*Plus, RMAN, Cisco jabber, Cisco webex

Others: Putty, DevOps

PROFESSIONAL EXPERIENCE

Confidential, Redwood

TEMPPrincipal Oracle Database Administrator/DevOps Engineer

Responsibilities:

• Maintain, monitor, and upgrade the development and production of Oracle databases on RAC and 11g and 12c version to ensure accuracy and quality, as well as producing environment for databases and application servers.
• Monitor the maintenance, upgrade, and deployment of Java Enterprise Applications on WebLogic servers 11g and 12c versions that use Oracle Business Intelligence Enterprise Edition (OBIEE).
• Produce new scripts for automation tasks on PERL, WLST, and shell (Bash, TCSH).
• Implementation of build jobs under Hudson/Jenkins for JAVA code compilation.
• Provide technical knowledge and expertise to development teams in optimizing the SQL and PLS/SQL code.
• Spearheaded a project to upgrade the Fusion Middleware (FMW) in all ENVS including the development, quality assurance, and production from 11g to 12c.
• Generate and initiate strategies for backup and recovery on relational database management system (RDBMS) and FMW.
• Administered the installation, patching and upgrade of Oracle Database Server and FMW.
• Perform code optimization through the use of Perl, SQL, PL/SQL, and Bash.
• Successfully resolve diverse Oracle RBMS and WebLogic issues while providing technical support to development and testing teams.
• Spearheaded and collaborated wif staff in India on upgrading databases from 11g to 12c.
• Directed the implementation of secure sockets layer (SSL) configuration in all the Fusion Middleware (FMW) environments in order to manipulate the application’s sensitive data.

Environment: Oracle 11g/12C, UNIX Shell Scripting, OEM, SQL Developer, DATAGUARD, PL/SQL, SQL, Jenkins, DevOps

Confidential, Milpitas

Oracle Database Administrator

Responsibilities:

• Credited wif maintaining, monitoring, creating, and producing Oracle (versions: 8i and 9i) and SQL server databases (versions: 2000, 2005, and 2008) wif a high level of quality.
• Directly assisted the development teams in designing the Oracle SQL optimization code.
• Performed Oracle and SQL server installations, upgrades and data guard configurations.
• Conducted efficient troubleshooting of database and PL/SQL applications issues.
• Building the different RAC node configurations, Building the Physical Standby database (Data guard) on Oracle 10g,11g Environment
• Root Cause Analysis Database failures and Oracle Internal Errors caused, SR/TAR follow ups wif Oracle
• Performance management using AWR, ADDM, Stats pack reports, participated in developing the Database schema, Database Maintenance, Tuning the database
• Rendered exceptional technical support to development and testing teams, assisted wif the SQL and PL/SQL optimization coding.
• Served as the major database administrator in the team that provided 24/7 production support to both Oracle and SQL server databases.
• Piloted the successful implementation of Oracle Data Guard configuration on Oracle databases.
• Trouble shooting Performance Related Issues in PROD, TEST, UAT, and STAGING instances.
• Resolving the TAR/SR’s raised by the customers for all instances.

Environment: Oracle 8i/9i/10g, SQL, PL/SQL, UNIX, SQL*Plus, Putty, OEM, Oracle Universal Installer, Exp/imp, RMAN

Confidential

Senior/Lead Oracle DBA

Responsibilities:

• Leading and Mentoring the Team, Exploring new Oracle technologies
• Managed the production Oracle databases including the 9i and 10g versions, along wif the Oracle Application Server (OAS) 10g version, and input the production code on Oracle databases.
• Managed development teams assigned to Oracle SQL and PLS/SQL optimization code.
• Administered several OAS, including Tomcat and glassfish.
• Determined and resolved all problems on databases, PL/SQL applications, and web server applications.
• Leveraged excellent skills in providing technical support to development and testing teams.
• Used Export/Import and Data Pump utilities for full/partial backup.
• Successfully accomplished all Oracle databases from 9i to 10g.
• Performed database tuning using AWR, ADDM, TKPROF, Enterprise Manager and TOAD
• Compiling the PL/SQL Stored Procedures & Database Triggers to Implement Business rules & Security
• Led the implementation of the use of RMAN as backup and recovery strategy.
• Reorganizing the database objects by archiving the data and moving the tables wifin the table space, rebuilding the indexes
• Configuring various cron jobs wifin the Oracle Server

Environment: Oracle 9i/10g, SQL, PL/SQL, UNIX, SQL*Plus, Putty, OEM

Confidential

Application Database Administrator

Responsibilities:

• Recorded all codes in the production environments and maintained the Websphere application server.
• Executed codes on the production environment.
• Managed the AppWorx application and WebSphere while supporting various applications for the client.
• Successfully completed one month of training in India.
• Experienced and strong programming skills in developing: writing queries, views, PL/SQL functions, packages, stored procedures, exception handling, batch job scheduling and tuning SQL for performance issues
• Application and SQL performance tuning

Environment: Oracle 9i/10g, SQL, PL/SQL, UNIX, SQL*Plus, Putty, OEM, SQL *Plus, Exp/imp, WebSphere AppWorx.

Confidential

Oracle PLS SQL Developer

Responsibilities:

• Charged wif the maintenance and development of new web applications for the university community.
• Provided direct assistance in creating the new database objects including tables, views, and indexes.
• Actively involved in managing the website and completing the redesign of internet applications to significantly enhance their performance.
• Ensured accuracy in creating reports and designing internet applications.
• Initiated and designed the database model for new applications and various internet applications for the academic community.
• Exhibited adeptness in formulating an application used by students to assess their courses during the school year.
• Design and Development of Web Pages
• Analysis and Design of Database
• Testing and Implementation
• Maintenance Support

Environment: JavaScript, Oracle 9i, SQL, PL/SQL, UNIX, SQL*Plus, Putty, SQL *Plus, Exp/imp