Job Description :
Senior Application Oracle/Exadata DBA Consultant
Horsham , Pennsylvania
12 Month(s)
Skype
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.
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.