Senior Oracle Exadata Dba With Oracle Exacc Exp

Visa status: U.S. Citizens and those authorized to work in the U.S. are encouraged to apply.
Tax Terms: W2, 1099
Corp-Corp or 3rd Parties: Yes
Mandatory Skills:
•    At least 6 years' experience as Oracle DBA (10g, 11g,12c)  Oracle Exacc
•    Strong 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
•    A least three years of working knowledge of Oracle Real Application Clusters (Oracle RAC), Oracle Enterprise Manager (Oracle OEM/Grid Control), Oracle Automatic Storage Management (Oracle ASM) and Oracle Automatic Storage Management Cluster File System, Oracle Recovery Manager (RMAN), Oracle Data Guard and Oracle Database Security.
•    At least 2 plus years of experience with implementations, upgrades, conversions and consolidation projects with Oracle databases on Exadata Platform.
•    Good organizational and communication skills with the ability to handle multiple priorities
•    Experience in handling and supporting enterprise, high profile, mission critical and dynamic 24x7 large-scale Oracle environments with high availability and scalable performance requirements
•    Proven experience in Performance Tuning of Database and SQL
•    Knowledge of Backup and Recovery - RMAN including exposure to plan and strategize backup and recovery operations. Proven experience in Database backups and restores using RMAN
•    Excellent troubleshooting and performance tuning skills. Demonstrated knowledge and skills using tuning features like SQL Tuning Advisor, SQL Access Advisor, Automatic Workload Repository and Automatic Database Diagnostic Monitor.
•    Experience in supporting both Development and Production Database environments
•    The candidate must be able to drive Product issues to resolution and register all steps in document following ITIL processes.
•    Ability to provide L3 support.                                                                         
•    Working knowledge of operating systems such as Windows Server, Unix, Linux, AIX, etc.
Preferred Skills:
•    Oracle Certified Expert (RAC/ Performance Tuning)
•    Knowledge of applicable data privacy practices and laws.
•    Ability to conduct research into database issues, standards, and products as required.
•    Ability to effectively prioritize and execute tasks in a high-pressure environment.
•    Good written and oral communication skills
•    Strong technical documentation skills
•    Good interpersonal skills
•    Experience in SQL Server or MySQL technologies is a plus
•    Willingness to work a flexible schedule and be "on call” to accommodate project deadlines and business requirements
Roles & Responsibilities:
•    Help design and implement highly scalable, available, secure and elastic cloud ready Oracle DB solution on Oracle Exadata Cloud at Customer
•    Analyze on premise transactional Oracle DB environments, evaluate and plan migrations to Oracle Exadata Cloud at Customer
•    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
•    Requirements analysis, data architecture, integrated database design, data security, performance tuning, back-up and recovery specifications
•    Work to reduce complexity and cost in database environments through analysis and implementation of database consolidation and rationalization.
•    Consult for optimal design of DB environments, analyzing complex distributed production deployments, and making recommendations to optimize performance
•    Assist with the evaluation and implementation of new product features to tailor solutions for database requirements
•    Use optimization techniques such as projections and partitioning
•    Integration of on cloud  and on premise Oracle DB environment
•    IT compliance and risk management requirements (eg. security, privacy, SOX etc.)
•    Establish appropriate end-user database access control levels.
•    Respond to and resolve database access and performance issues.
•    Crash/Recovery of Databases 
•    Database Performance Analysis & Developing Tuning Approach
•    Monitor database system details within the database, including stored procedures and execution time, and implement efficiency improvements.
•    Documenting any Bad SQL Queries and support Application team for fine tuning.
•    Participate in Change Management Process 
•    Preparing Backup and Restore Strategy and implementation.
•    DR  Plan, Implementation and Management
•    Consultancy (if required) developers in optimizing SQL query and support to application development team during the development, testing, pre-production and post-production phase.
•    Create, or support creation of, required reports in response to business user needs.
•    Communicate with external teams including the biz clients on various issues and resolutions thereof to provide best customer experience 
•    Develop, implement, and maintain change control and testing processes for modifications to databases.
•    Analyze database system details within the database, including stored procedures and execution time, and implement efficiency improvements.
•    Consultancy for DB Upgrades and Enhancement.
•    Security Compliance Preparation and Implementation plan.
•    Perform database transaction and security audits.
•    Develop routines for end users to facilitate best practices database use.