Hi Professionals, Hope you’re doing great !
Please find below the detailed Job Description and let me know if you have any suitable resource for this position. *Role:* Oracle DBA *Location: *Cincinnati, OH *JOB DESCRIPTION:* *Responsibilities: * The Oracle Database Administrator is a highly skilled technical position that involves intricate knowledge of the Oracle database internals. May also requires on call responsibilities. Database configuration, tuning, maintenance, patching, and problem diagnosis and resolution are all critical functions that the database administrator performs. 1. Manage all aspects of the physical database including schema’s, DDL, users, security, etc. in development, UAT and production environments 2. Identify and resolve problems occurring in all database environments including performance related issues (i.e. database & SQL tuning). 3. Perform database software installs, configurations, patches, and upgrades. 4. Support DBA utilities, reorgs, index builds, etc. and DBA tools, Oracle Enterprise Manager, etc. *Mandatory Technical / Functional Skills:* · 10+ years of hands-on experience as an Oracle Database Administrator. Working directly with Oracle 10g, 11g and 12c. · Database configuration, tuning, maintenance, patching, and problem diagnosis and resolution are all critical functions that the database administrator performs. 1. Install configure and troubleshoot Oracle and Grid Infrastructure on multi node RAC cluster with 11GR2 (11.2.0.4) 2. Rolling upgrade of Oracle and Grid Infrastructure on multi node RAC cluster with 11gR2 – Precisely from 11.2.0.3 to 11.2.0.4 3. Need to apply the latest patch in a rolling fashion for both the Clusterware home and Database home to confirm compliance to various versions of oracle databases. 4. Install configure and troubleshoot 12c OEM. 5. Expertise on SQL Plan Management (SPM) and DB profiles. 6. Monitor database performance, diagnose performance problems, and tune the database as necessary. Investigate, gather diagnostic data for, and report to Oracle Support Services any critical database errors. 7. Configure and manage memory allocation and adjust as needed. Calculate optimum values for database parameters such as amount of computer memory to be used by database. 8. Troubleshoot and monitor database integrity and performance using EM12c. 9. Hands-on experience with of Oracle Data Guard replication setup, maintenance and troubleshooting for high Availability. 10. Manage all aspects of the physical database including schema’s, DDL, users, security, etc. in development, UAT and production environments 11. Support DBA utilities, reorgs, index builds, etc. and DBA tools, Oracle Enterprise Manager, etc. 12. Uni-directional and Bi-directional replication with Oracle Golden Gate is a plus 13. Migrate a Non -RAC database to RAC with RMAN and Logical backup. 14. Proven ability in UNIX shell scripting, PL/SQL coding and Perl. 15. Experience in Disaster Recovery activities 16. Coordinate the implementation of technical controls to support and enforce defined security policies 17. Experience with IBM AIX, Linux, SUN Solaris UNIX operating systems. 18. Experience with Oracle Streams implementation and troubleshooting 19. Manage all aspects of physical database administration including schema management (DDL), security setup and enforcement, ID creation, installations, upgrades, patching, troubleshooting and instance tuning. 20. Support several application and support teams with numerous on-going projects 21. Maintain over 200+ Oracle production databases along with their corresponding development and test databases. 22. Be part of a large DBA team establishing database standards, monitors and automating support solutions 23. Manage regularly scheduled backups using Oracle’s RMAN and occasionally a database recovery. Thanks & Regards, *Raj Yadav* Email: rya...@sysmind.com Ph: 609-897-9670 x 2168 Fax: 609-228-5522 SysMind LLC Address: 38 Washington Road, Princeton Jn, NJ 08550 *[image: cid:image001.gif@01CD1E36.E1381A30]* <http://www.sysmind.com/> [image: cid:image002.png@01CF4A69.18319D80] [image: cid:image003.png@01CF4A69.18319D80] [image: cid:image004.png@01CF4A69.18319D80] NOTE: Under Bill s.1618 Title III passed by the 105th U.S. Congress this mail cannot be considered Spam as long as we include the contact information for removal from our mailing list. To be removed from our mailing list please reply with 'remove' in the subject heading and your email address in the body. Include complete address and/or domain/aliases to be removed. If you still get these emails, please call us at the number in the signature. -- You received this message because you are subscribed to the Google Groups "US_IT.Groups" group. To unsubscribe from this group and stop receiving emails from it, send an email to us_itgroups+unsubscr...@googlegroups.com. To post to this group, send email to us_itgroups@googlegroups.com. Visit this group at http://groups.google.com/group/us_itgroups. For more options, visit https://groups.google.com/d/optout.
