*Dear Candidate,* *We have an urgent opening for and I have sent you a job description please go through it and let me know if you are comfortable with it and also send me your consultant's updated. *
*Title:-Senior SQL Server DBA & Oracle DBA (needs experience with both)* *Duration6+ month * *Indianapolis, IN* *Phone and In-Person* *Significant experience & demonstrated proficiency in all aspects of database programming and analysis, including Cursors, Ref-cursors, Procedures, Functions and Packages, Oracle Supplied Packages, Collections, Partitioned Tables, Triggers, Table Indexing. Extensive experience in Complex SQL Queries, Dynamic SQL, Analytical function, various Oracle Objects, etc. Experience on database design, best architecture practices, normalization and dimensional modeling etc. Solid facilitation skills to gather the necessary (functional & technical) information to document and/or develop a strategic/tactical plan. Able to properly document (functional & technical) source to target mappings, process flows, data flows, technical specification and unit test document Design, develop and deploy business rules and requirement into PL/SQL and ETL code for data analysis, transformation, and cleansing. Experienced in writing efficient and complex Ab Initio components such as graphs, parameters, transformations such as expression, filter, lookup, join, router, normalizer, partitions, update strategy etc. Expert in Query optimization, Debugging, and Tuning for improving performance • Experience in Database Administration of Oracle 7, 8, 8i, 9i, 10g, 11g and 12c Pluggable databases on Operating systems HP-UX, IBM AIX, RHEL, Solaris and Windows.* *• Experience in working with database sizes ranging from < 500GB to 11TB VLDBs.* *• Exposure to OEM 10 and 12c to configure and monitor alerts, blackouts, install and administer agents. * *• Experience in administering and maintaining Oracle Real Application Clusters (RAC), Oracle Datagaurd and Streams Replication Environments. * *• Experience in installing Oracle Homes, creating normal databases and 12c Container & Pluggable databases as per client standards.* *• Experience in applying Quaterly Security patches manually and also automatically using BMC BladeLogic Database Automation Tool (BDA) after the approval from client.* *• Experience in upgrading databases from Oracle 7 and above versions to latest Oracle 12c.* *• Experience in using BDA to Prepare Patch Packages for Client’s environment, test prepared packages in Lab Environment, perform upload, edit and export packages in the repository and push packages to Databases.* [image: logo] *Rohit Bhasin |* lead Recruiter | Apetan Consulting LLC Tel: 201-620-9700* |121| Fax:2015266869 | *Mail *: 72 van reipen ave pmb#255, Jersey City, NJ 07306| *Corp. Office:* 15 Union Avenue, office # 6, Rutherford, New Jersey 07070| ro...@apetan.com| www.apetan.com | *“Forget all the reasons why it won’t work and believe the one reason it will work**"* [image: https://s3.amazonaws.com/images.wisestamp.com/icons/facebook.png] <http://www.facebook.com/Apetanconsulting> [image: https://s3.amazonaws.com/images.wisestamp.com/icons/linkedin.png] <http://www.linkedin.com/company/apetan-consulting-llc?trk=top_nav_home> [image: https://s3.amazonaws.com/images.wisestamp.com/icons/twitter.png] <http://twitter.com/ApetanLLC> [image: e verify] *Disclaimer:* We respect your Online Privacy. This e-mail message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. If you are not interested in receiving our e-mails then please reply with a "REMOVE" in the subject line at rem...@apetan.com and mention all the e-mail addresses to be removed with any e-mail addresses, which might be diverting the e mails to you. We are sorry for the inconvenience. -- You received this message because you are subscribed to the Google Groups "OracleD2K" group. To unsubscribe from this group and stop receiving emails from it, send an email to oracled2k+unsubscr...@googlegroups.com. To post to this group, send email to firstname.lastname@example.org. Visit this group at https://groups.google.com/group/oracled2k. For more options, visit https://groups.google.com/d/optout.