P&J Consulting Washington Dc Work Values

Daily Duties at P&J Consulting Washington Dc:

P&J Consulting, Washington DC Jan 2012 – Present Role: Oracle Database Administrator ⦁ Oracle DBA for two major projects involving periodic administration, troubleshooting & tuning of multiple Oracle databases ( 10g & 11g single instances running on both IBM AIX 5.3, SunOS 5.8 & HP-UX B.11.11) ⦁ Create oracle databases on configured servers using both the DBCA & Database creation scripts. ⦁ Manage, tune and troubleshoot database issues both on UNIX command line, SQL*Plus, OEM client, Oracle 11g database control, oracle 11g Grid Control as well as other third party tools (TOAD, SQLDeveloper, DBArtisan and dbXpert for Oracle). ⦁ Monitor database systems and provide technical support for database system issues and application performance enhancement/improvement using both OEM (client), Oracle 11g database control & SQL*Plus, as well as pre-developed UNIX shell scripts. ⦁ Data migration between databases using both Oracle 10g and 11g export/import utility and Oracle 11g exp/imp data pump. ⦁ Database refreshes using expdp, impdp, RMAN Duplicate and cloning. ⦁ Experienced in cloning the databases using HOT and COLD backups. ⦁ Used RMAN Duplicate and HOT/COLD backups to migrate the data from 11.1.0.7 to 11.2.0.3. ⦁ Created a stand by database by using RMAN Duplicate in order to reduce the down time for the PROD database during the migration process. ⦁ Planning Backup/Restoration Strategy, Planning and scheduling Backups, taking Logical Backups (with Export/Import Data pump utilities). ⦁ Creating & Managing Database Structures, Storage Allocations, Table/Index segments, Rollback segments, Constraints, Database Access, Roles and Privileges. ⦁ Performed SQL and PL/SQL tuning, oracle contention and monitored production database using automatic workload repository (AWR), automatic database diagnostic monitor (ADDM) and Active Session History (ASH). ⦁ Worked closely with the Oracle developers for the better performance in Applications in writing the Packages, Triggers and Indexes on the tables. ⦁ Used Secure SCP & FTP extensively for the File transfers from machines to remote server. ⦁ Application of Oracle software patches when/where necessary. ⦁ Backup/Recovery monitoring and reporting using Oracle RMAN ⦁ Technical documentation of all configurations, installations, implementations, monitoring and testing projects for future utilization. ⦁ Work closely with Systems Analysts, Systems Engineers/Admins & Application Developers through the SDLC from Development to Production, via Tech-Test in Needs Assessment, Requirements Gathering (Server hardware/OS specifications for Oracle Installs), Database Designing (Physical & Logical) and Implementation, database user creation and database access both at role & table levels, as well as final Project Performance Assessment/Evaluation. ⦁ Create database Objects, Tablespaces, Schemas as needed. ⦁ Schema migrations from Development to Production via Tech Test environments. ⦁ Database refresh from Production to Tech Test as needed. Tools Used: Oracle RMAN, Oracle 10.2.0.1, Oracle 11g, DBMS STATS, Datapump, SQL TRACE, TKPROF, EXPLAIN PLAN

What they like about P&J Consulting Washington Dc:

A hiring company that offers alternative approaches to pay, performance bonuses, and/or equity in the firm is very attractive to you. You're generally less interested in working for an organization offering only traditional, salary-based compensation, one with limited opportunity to acquire equity in the firm, or one that does not actively promote skill development. In addition, you are more likely to choose a company that offers a variety of internal career options, with defined career paths. You view the learning of new skills and development of your expertise as key to your career advancement. These aspects of an organization may become even more important to you as you progress in your field, and are especially critical if you change career or occupation.

Tags

MySQL, Java, HTML, XML, RMAN, DBCA, DBUA, DATAGUARD, SHELL SCRIPT, UNIX, BASH AND PERL SCRIPTING, PL/SQL, OEM, REAL APPLICATION CLUSTER (RAC), SQL*PLUS SQL NAVIGATOR, TOAD, DATA PUMP(export and import), SRVCTL, ORACLE 11g/10g, Red Hat Linux RHEL, 5x and Windows XP, ORACLE MANAGEMENT SERVICES(OMS)

Skills

I have work in many diferent environment and also work with group of developers and sysadmin,l have work project support as well as production support. I have work as a Single DBA and a member of a team, l have done performance tuning using different dat

These are some of the questions we asked our climbers about their experiences with P&J Consulting Washington Dc: