Senior Oracle Exadata DBA with Oracle Exacc Exp

Posted: 5 months ago


• 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

dy>