*Locals highly preferred * *H1B Copy required *
*Job Title:* Oracle DBA *Location:* New York City, NY *Duration:* 6 Months+ Responsibilities The Senior Database will be a part of a team of DBA’s that supports some critical applications. This individual will be responsible for providing DBA services to application development teams, support multiple database environments, and manage the build-out of database infrastructure. S/he will serve as a key subject matter expert on Oracle database design & features. A primary focus will be to proactively analyze, identify, and implement performance improvements to custom and vendor applications. Good communication skills are necessary for this role as the candidate will need to interface with developers and business IT and management. Specific duties will include – • Install / configure new databases in both RAC and non-RAC environments • Install / configure new Data Guard physical standby databases • Install / configure Golden gate where needed • Troubleshoot database problems in both production and non-production environments; lead RCA process and ensure all fixes are fully implemented, collaborate across infrastructure teams to determine RCA • Use appropriate tuning methodology and tools (such as AWR, ADDM, ASH etc.) to triage and resolve performance problems • Collaborate with business units, application teams and administration teams to design, size and plan new environments • Research, plan and execute database upgrades • Plan for system growth and scalability • Support standard ‘mailbox’ type requests (create schemas, create objects, grant privileges, kill sessions, etc) • Support scheduled and emergency maintenance events • Participate in other infrastructure upgrades for servers, storage devices • Prepare / update storage diagrams for both ASM and non-ASM environments • Prepare / review performance reports and segment space reports • Prepare / update technical documentation including for the following: operational manual, backup / recovery, database maintenance, patching • Prepare / update non-technical documentation including for the following: system designs, operating procedures, system events and root cause analysis Qualifications/Requirements • Bachelor’s in Computer Science, Information Systems or Engineering (or equivalent relevant work experience) • Minimum of 4-6 years of experience in database administration using Oracle databases (10g, 11g, 12c) and/or Oracle Exadata; including installation, configuration, tuning, patching, upgrading, troubleshooting • Minimum of 1-3 years of experience in Sun Solaris / Linux platforms with storage and networking experience • Efficient at tuning SQL & improving Oracle performance • Experience working with Oracle Recovery Manager and Netbackup • Experience creating Unix shell scripts • Experience working with Oracle GRID Control • Strong hands on experience with RAC infrastructure, ASM, RMAN, and dataguard • Exceptional troubleshooting skills to analyze problems at all levels • Must be able to work off-hours and provide 24x7 support in on-call rotation • Must be detail-oriented and deliberate • Experience developing and documenting directions and operating procedures • Excellent communication • Exposure to big data, knowledge of HDFS, HBASE etc. *Warm Regards,* *Rohan Kumar* Sr. Executive – Resourcing Pyramid Consulting, Inc ------------------------------ *O: *770-255-3278 E: rohan.ku...@pyramidci.com Web: www.pyramidci.com -- You received this message because you are subscribed to the Google Groups "SAP BASIS" group. To unsubscribe from this group and stop receiving emails from it, send an email to sap-basis+unsubscr...@googlegroups.com. To post to this group, send email to sap-basis@googlegroups.com. Visit this group at https://groups.google.com/group/sap-basis. For more options, visit https://groups.google.com/d/optout.