Hi,
Hope you are doing great. If you have anyone with you, please respond with suitable resume to r...@somasoftsol.com along with Contact Details, Current Location, Visa Status, Availability, Pay Rate (all inclusive) and Employer Details for the following requirement. ================================================ Title: *Oracle Apps DBA* Duration: 8 Months Location: Rochester, MN - ONSITE Rate: Need Best *Responsibilities:* 1) Controls migrations of scripts, stored procedures, schema changes, reference data changes and menu changes through the development life cycle. 2) Works closely with the data architect to ensure data definition fit within client's IT team. 3) Provides technical support to application development teams. 4) Enforces and maintains schema constraints to ensure data integrity. 5) Administers all schema objects, including tables, clusters, indexes, views, sequences, packages and procedures. 6) Assists with impact analysis of any changes made to the schema objects. 7) The Apps DBA is responsible for monitoring and optimizing the performance of the application within the schema and offering assistance to developers in optimizing their applications, queries, etc., Works with the SysDBA in tuning database/instance. 8) First point of contact for development staff with problems regarding databases & schemas. 9) The Apps DBA is responsible for the batch loading of data into official production ORACLE tables from approved data files, etc. given by development staff of vendors of applications. The Apps DBA will ensure that the data loaded into ORACLE tables is as accurate as the data source. The Apps DBA IS responsible for the data exception-handling process. 10) The Apps DBA will propagate data from test/development to production in a controlled process. 11) Works as part of a team and provides 7x24 support when required. 12) Writes Packages, PL/SQL, Scripts 13) Understands Cursors and performance tuning 14) Understands Oracle session locks and caching 15) Ensures that client's change management standards are adhered to Behavior Characteristics: Ability to work in a team environment, sharing workload and responsibilities while taking initiative to perform *Required / Desired Skills:* Skill Required / Desired Amount of Experience PL/SQL Required 5 years Optimizing/Tuning SQL Required 5 years Oracle Required 5 years Deploying DDL/Schemas Required 5 years Performing DB Loads Required 5 years Application development Highly desired 3 years UNIX Required 5 years DB design Required 5 years Shell scripting or Perl Required 4 years Searching content/text Highly desired 3 years ================================================ Thanks and regards, *Ram * SOMASOFT Phone: *650-690-8030* Email: r...@somasoftsol.com URL: www.somasoftsol.com Note: If you are not interested in receiving our emails, please reply with "REMOVE" in the subject line. We are sorry for the inconvenience caused to you.