Looking for Oracle/Exadata DBA in Horsham, PA

[Varada chari]

Greetings from Prospect Infosys Inc.

 

We are looking for Oracle/Exadata DBA in Horsham, PA. If interested to apply share your updated resume to ch...@prospectinfosys.com

 

Job Title: Oracle/Exadata DBA

Location: Horsham, PA

 

In Person Interview

Pay Rate: $65/hr on C2C

Description:

 

Job Description :

As an Oracle DBA you will be part of Core DBA team providing Development DBA services for applications development teams. The application databases supported are a wide variety of vendor provided and in-house developed apps.

 

Major Responsibilities

•       Work closely with development and architecture teams to properly engineer effective database solutions that ensure reliability, quality, and scalability.

•       Assist with design, development and implementation of database architecture and database solutions for new “Speed-to-Market” SOA based Agile projects underway.

•       Perform analysis and end-to-end execution from roadmap to implementation of database consolidations, migrations, conversions and upgrades.

•       Drive design, build and management of large, complex Oracle databases running on Oracle 11g/12c environments on Linux and Exadata with features for data compression, partitioning, RAC, RMAN, Data Guard.

•       Lead analysis of business and application requirements to translate into new or modified database or data capabilities.

•       Educate and influence stakeholders to promote an understanding of the environments, increase simplification, risk management, and promote reuse and innovation.

•       Work to reduce complexity and cost in database environments through analysis and implementation of database consolidation and rationalization.

•       Collaborate and participate in application release planning and implementation.

•       Work with onshore and offshore database partners to ensure availability, performance, quality, and Service Level Agreement specifications.

•       Resolve complex incidents (e.g. Data issues, performance tuning, security).

•       Create and maintain roles, and assign privileges.

•       Review and deploy database related application code.

•       Troubleshoot failed code deployments.

•       Write code using Oracle’s PL/SQL language.

•       Review database log files and daily reports to identify possible issues.

•       Support developers with answering database related questions, as necessary.

•       Maintain database related documentation and standards.

•       Write shell scripts to automate routine tasks.

 

Qualifications

•       Solid knowledge of Oracle 11g/12c and technical database concepts, such as: logical relational data modeling, physical data modeling, tuning large instances, resource management, data replication and backup/recovery techniques.

•       Requires at least 8 plus years of experience with implementations, upgrades, conversions and consolidation projects with Oracle databases.

•       Requires strong organizational skills with the ability to handle multiple priorities.

•       Production DBA experience with ability to work with Development teams on DB architecture and design.

•       Experience administering Oracle 12c RAC Exadata.

•       Strong proficiency in Oracle RDBMS database management in Linux

•       Strong command of structured query languages (Oracle SQL, PL/SQL, ANSI-SQL)

•       Strong command administering database security, data recovery, performance monitoring and tuning

•       Proficient in writing and optimizing SQL statements.

•       Ability to troubleshoot and debug complex technical problems.

•       Ability to plan resource requirements from high level specifications.

•       Familiarity with other databases such as MySQL, MS SQL Server, MongoDB, etc.