Monday, June 11, 2007

Oracle DBA in Dallas, TX

Perform database administration on all database systems. Install, configure, upgrade, and maintain all client databases which include performance monitoring, troubleshooting and client support. Continue to seek improvements in product performance that can be achieved through changes in database schema, logical and physical data organization, and RDBMS tuning and configuration. a. For new development efforts, provide technical expertise and participate in the design and implementation of a database schema that conforms to industry standards yet meets all application specific requirements b. Maintain development and production database environments and provide centralized control over database schema and RDBMS product versions. c. Act as primary development and production support contact for database administration and tuning. Support application and development teams as required. Specific Duties: Responsible for ensuring all database system operational processes are managed according to established service level agreements. Specifically; a. Administration of database objects such as indexes, tables, views, constraints, stored procedures b. Archiving, backup / recovery, replication, cloning, import/export and refresh c. Administration of database users d. Tuning and optimization e. Capacity Management and storage management f. Design, test, and optimize/tune RDBMS components g. Contribute to design, maintenance, and documentation of integrated database security and components in relation to SOX and SAS70 compliance. h. Review and assess database changes as a result of application updates due to new features, enhancements or bug fixes. Implement the changes to staging and production environment appropriately with minimum impacts to the clients i. Review and assess new features of upgrades to existing RDBMS components. j. For databases that may be supported in the future, reviews product literature to assess RDBMS differences and unique features. When possible, test new technologies and report results Develop, maintain, and optimize programming code for maintenance jobs and application reporting tools. Develop shell scripts as required. Responsible for accurately documenting and communicating all work related activities in a clear and concise manner to the business users and customers. Perform all additional duties as required by manager. Follow up on pending issues and keeps manager and other group members aware of unresolved problems or potential schedule problems. Education and Experience: 1. A Four year degree in computer science or information systems or equivalent experience. 2. **Minimum of six years experience as a DBA in a production and development environment** Oracle required. Additional database experience (e.g. DB2, MS SQL Server, SybaseIQ, etc.) preferred. 3. Experience in heterogeneous computing environments required, including platforms that support Windows/DOS and UNIX/LINUX (SUSE preferred). Strong knowledge of Sun Solaris, AIX and Linux environment is a must. 4. Extensive experience in Oracle 10g RAC, Dataguard and Grid Control (e.g. Peoplesoft and Oracle Financials a plus) ASM configuration and management with raw devices ADDM and AWR configuration and management RMAN backup and recovery Grid Control configuration and management Skills: 1. Able to identify performance issues and design/implement solutions in an effective manner. 2. Able to complete assignments that are defined in general terms. Self motivated to direct own work flow in a manner that maximizes results and meets division goals/schedules. 3. Able to prepare and maintain comprehensive and accurate documentation. Must be able to adapt presentation to a specific target audience (i.e., client or ACS management/personnel). 4. Able to transfer conceptual knowledge from current skill set in order to quickly develop expertise in new databases, platforms, or networks. Attributes: 1. Strong verbal and written communication skills. Present information in a logical manner consistent with the needs of the audience. Able to discern critical issues and questions to be discussed with management. 2. Strong team orientation, open-minded, able to listen to other's ideas. Good understanding of his/her role, his/her Manager's role, and is able to w To Apply to this job go to http://www.GadBall.com or click here