* Role: Oracle DBA * Number of Positions -- 1 * Location: Minneapolis, MN * Start: ASAP. * Duration: 6+ Months * Rate: $55 to $58/hr c2c All inclusive. * Expenses/Relocation: Included in rate above. * Face-to-Face: May be required.
*DESCRIPTION:* *** *Client is seeking a Oracle DBA to come in and assist their existing DBA group for ~ 6 months. Production environment is very model centric so background in similar setups is ideal. In addition, candidates with strength in both DB modeling and working with application development teams has been key in the past. *ROLE DETAILS:* ----- Collaborates with application development team(s) in the analysis of applications requirements, design and construction processes ----- Creates and maintains physical data models that meet the business and systems requirements ----- Constructs and supports transactional, operational, and informational data stores in the development and testing environment. Manages changes to the application data model and generates DDL from the model. ----- Scripts changes into package to be promoted though the environment stack. ----- Develops and maintains stored procedures, database triggers, packages, and functions as required by the application design. ----- Manages users* accounts and roles in the development and testing environment. ----- Assists development teams with achieving optimal application performance. ----- Partners with developers and data analysts to develop test data for unit testing ----- Copies or moves data from one database to another as required ----- Partners with Operations DBA in applying database patches and upgrades to application databases, including coordination of testing, data conversion, and migrations as required ----- Complies with the established company-wide database standards, best practices, SOPs and the governing directives of the Enterprise Data Architect. *SKILLS SPECIFICALLY REQUIRED:* * Oracle DBA. * DB Modeling Tools * Data Modeling of OLTP and/or OLAP systems using ERD and/or UML modeling techniques * PL/SQL development and debugging * Shell scripting. * Writing build/maintenance scripts that allow databases and their corresponding objects to be created/modified in different environments * Monitoring and optimizing system performance using index tuning, disk optimization, and other methods * Making tuning recommendations to developers related to PL/SQL * Working in a multi-tier architecture in client/server environment * Diagnosing and troubleshooting application and database issues * Ability to operate in unstructured environment (assess, establish plan of action, execute) *NICE TO HAVE:* * SQL, Transact SQL, PL/SQL development and debugging * Making tuning recommendations to developers related to TSQL * Sybase DBA (5 years) * SQL Server DBA (5 years) Thanks Ravi 302.994.6789 Techno Soft Inc r...@globaltechnosoft.com -- *************************************************************************************** For all SAP related tutorials,Articles,Faqs,Tips www.sapbrainsonline.com **************************************************************************************** You received this message because you are subscribed to the Google Groups "sapbrains" group. To post to this group, send email to sapbrains@googlegroups.com To unsubscribe from this group, send email to sapbrains-unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/sapbrains?hl=en