Monitored database activities, performance, and size.Wrote extensive SQL and PL, SQL Procedures, Functions.Managed Table spaces, Database structure and storage allocation, Undo segments, etc.Created schemas for new users and managed the security and access the database by granting appropriate privileges and roles to the users based on client policy.Used SQL Loader to load data from external files into Oracle Database.Interacted with users and business experts to determine their requirements and needs.Java and Eclipse: Created jsp web pages, java backing classes, struts action classes, java Dao business classes, and pojos that access database packages with varray outputs.Linux: Creation of Web logic Domains, removal of nohup.out log files, and deployment of EARs.Unix: Scripts for the calling of packages, sql, or sql loader.Oracle ddl scripts for the creation of tables, indexes, constraints, and types. Oracle pl-sql using cursors, for, next and open fetch loops, select into, raise application error, pragma exception in it, and autonomous transactions. Toad and Oracle PL-SQL Developer: Oracle advanced sql using analytical functions, aggregate functions, and case statements.On the view layer, used ADF Rich Server Faces components extensively, java backing beans, page definition xml files for bindings, task flows (for page flow scopes), faces-config.xml, and layout work. Oracle Developer Mistake #2 click here11g Developer: On the model layer, created web services from database packages, data-controls, ADF view objects, and application modules and parameters.BEA Web logic 10.3: Experienced with the installation and configuration of Web logic 10.3 Domains, including: the creation of jdbc connection pools, the modification of connection pool parameters, the maintenance of deployments (stop, start, delete, and re-deploy), server parameters such as tunneling, port setting, and the modification of startup scripts.Oracle Real Application Clusters ( RAC ) on Oracle 10g R1-R2 and 11g.PL, SQL, SQL Development and Tuning Skills, Process Automation using Shell Scripting.Systems Migrations, 9i to 10G Upgrades.Grid Control and Oracle Enterprise Manager ( OEM ).Performance Tuning, Optimization using TKPROF, STATS PACK, ADDM and Cost Based Optimizer.Oracle Database Design, Systems Analysis, Database Partitioning and Oracle parallel query.Backup, Disaster Recovery ( RMAN ) and Data Replication ( Oracle Streams ).OLTP Production 24×7 DBA Support, Testing and Development Databases Support.Strong DBA skills of 24X7 Production environment, Development background, ability to work in teams and independently, and with individuals of different skill levels, ability to grasp new concepts quickly and strong commitment to get the job done under pressure. Specializes in Oracle Mistake #1 click heredatabase administration on 11g, 10gR2-R1, 9i, 8i ,Performance Tuning, Backup and Recovery using RMAN, 9i to 10g Migration issues, Real Application Clusters (RAC), GRID, OEM, Data Guard, Physical and logical database design, Development using SQL, PL-SQL, Database triggers and Procedures.
Home: (999) 999-9999, Mobile: (999) 999-9999 RICHARD MILLERġ0+ years of extensive Oracle experience as an Production Oracle DBA supported by strong experience in the analysis, Design, development and implementation of variety of complex business systems under various platforms (Linux, Solaris, HP Unix, AIX and Windows).