Hi All *Location : GREENSBORO, North Carolina
Rate : $50/hr Duration : 3+months * Experience in Data Administration, creating logical and physical data modeldiagrams and modeling complex relational databases. Expertise in determining and managing consistent corporate wide data definitions and providing the infrastructure needed to make the meta data accessible to users. Provides technical expertise in the use of flat file and Database Management Systems (DBMS)/ Relational Database ManagementSystems (RDMS). Defines organization and indexing methods for specific application databases. Works closely with customer security specialists to define required security procedures for backup and recovery and to control access to the data. Monitors and fine-tunes databases performa * * Support the development teams in analyzing system requirements to develop logical and physical entity relationship models and deploy modeled objects. Support the production systems, and be responsible for physical database changes and additions on multiple platforms (iSeries (AKA AS/400), pSeries (AKA RS/6000)). Mentor other DBA team members when appropriate. Provide project team support for query optimization. * * 1) DB2/400 - Oracle Database Analyst Job Duties o Design database objects (Logical and Physical) and processes in IDA o Creation of any database object in DB2/400 Database o Help resolve RI conflicts and record deadlock problems in Oracle and DB2/400 o Execute and monitor data fixes as necessary o Participate in Business Recovery tests at remote sites for both iSeries and Oracle platforms. o Communicate effectively with Project Leaders and team members in IT&S Department o Mentoring and Cross Training other DBA team members o Liaison between external resources and internal resources for database projects. o Follow current standard Change Management policies for the department, as well as standards, policies and procedures that are specific to the Information Management Team. o Create and implement database portions of project plans. o Provide project estimates for DBA skills to project managers. o Turnover change management promotion process for all iSeries objects including IFS objects. o CVS change management processes relating to IDA. o Manage security on iSeries and Oracle platforms, including object security and authorization lists o Creation of any database object in Oracle Database o Help resolve communication issues between Oracle and DB2/400 (Access Manager & Oracle Transparent Gateway) * * * * 2) Oracle and DB2/400 Administration Job Duties o Monitor daily Oracle backups o Monitor Oracle Table Spaces and Data file status for space constraints o Monitor Oracle database performance as needed o Execute and monitor data fixes as necessary o Troubleshoot remote database connections (to other Oracles and to iSeries) o Recover Oracle database from RMAN/TSM system at DR test site o Tuning of queries for better performance on iSeries and Oracle. o Coordinate multi-platform promotions. o Maintain appropriate level of communication with UGs vendor of choice for Oracle Support * * 3) A Senior Database Administrator should have the following skills DB2/400 experience (5 or more years) Relational Modeling Experience Experience with both command line and Ops Navigator database functionality. Exposure to Oracle. Experience with system and application monitoring tools. Experience in a software development environment. Experience with RPG/CL for the iSeries environments. Experience with SQL/DDL and DDS for both iSeries and Oracle environments. Experience and knowledge of Change control systems. Familiarity with Web Based Development Technologies and Web Applications Must be willing to work on all platforms and databases in use at United Guaranty Ability to adapt to a rapidly changing environment Experience mentoring and cross training Working knowledge of the IFS on iSeries and transferring IFS objects using Turnover. Working knowledge of journals on iSeries and how to use them for audit purposes. Time management, planning, and organization skills. Excellent oral, written communication skills. * * -- Please send the resumes to ke...@ifuturistics.com Regards, Kevin | iFuturistics Inc | Direct: 919-521-4127 | ke...@ifuturistics.com | www.ifuturistics.com | "Note: We respect your on-line privacy. This is not an unsolicited mail. Under Bill 1618 Title III passed by the 105th US Congress this mail cannot be considered Spam as long as we include contact information and a method to be removed from our mailing list. If you are not interested in receiving our e-mails then please reply with a "REMOVE" in the subject line. I am sorry for the inconvenience caused to you" -- You received this message because you are subscribed to the Google Groups "SAP ABAP" group. To post to this group, send email to sap-a...@googlegroups.com. To unsubscribe from this group, send email to sap-abap+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/sap-abap?hl=en.
