Oracle Database Administrator III & IV
Job Description .
SHift - Ok to work in rotaional shift ( including night)
Experince - 12+ yrs of relevant exp.
The Oracle Database Administrator is responsible for configuring, administering, and maintaining the Oracle database environments. Responsibilities include database upgrades, patching, security, troubleshooting and issue resolution, backup procedures, and performance tuning. In addition, application DBA’s will provide support and direction to developers and other support personnel as needed. Daily responsibilities include monitoring production environment, providing acceptable system performance, and assuring data is protected and recoverable as required and assuring data is protected and recoverable as required.
Key Responsibilities
• Installation, configuration, tunning, patching, refreshes and upgrading database environment using different utilities.
• Setting up and monitoring standby databases, DR-Drill, backup and recovery techniques, diagnose and correct performance problems.
•Proven experience managing database configurations.
• Managing database Users, Roles, Profiles, Permissions and Security. •Create and publish database health check reports.
• Perform regular maintenance activities.
• Monitoring Space management, user's activities, and resource utilization. •Ability to independently maintain and administer databases.
• Ability to learn and adapt procedures, processes, and new technologies quickly.
• Good logical and analytical skill.
• Good communication skill.
• Collaborate with other team members and stakeholders
• Good understanding of Oracle database concepts and structures on various in-house and cloud platforms.
• Oracle database skills and Unix operating system understanding is required.
• Good Knowledge of architecture and configuration of latest Oracle versions. •Good experience of patching, cloning, security, backup and recovery procedures, node addition, deletion, replication setup and DR-Drill activities. •Good understanding of Performance Tuning, Query Optimization, Client/Server Connectivity.
• Experience of implementing operational automation using Ansible playbooks or any other tools.
• Experience of writing shell scripts as well as knowledge in general system administration tasks.
• Experience of setting up Oracle high availability [RAC, Dataguard] environment using various tools.
• Experience of database administration, development, maintenance, and production support.
• Experience of managing Oracle databases on various cloud environments. •Experience of identifying performance problems and optimization of database performance.
• Experience on planning and Performing optimal Backup and Recovery solutions.
• Good knowledge of RAC, ASM, RMAN, Dataguard, Datapump and other Oracle utilities.
• Good understanding of SQL and PLSQL Procedures, Functions, triggers. •Good in providing guidance to the development team in optimizing SQL statements.
• Good understanding on deploying code moves as part of change management.
• Proficient in performing the recovery of the Oracle database files in various recovery scenarios.
• Basic understanding of goldengate replication.
• Strong trouble shooting and problem-solving skills.
• Ability to work well in teams with good oral, written, and interpersonal skills.
• Ability to provide FANATICAL support.
About Rackspace Technology
We are the multicloud solutions experts. We combine our expertise with the world’s leading technologies — across applications, data and security — to deliver end-to-end solutions. We have a proven record of advising customers based on their business challenges, designing solutions that scale, building and managing those solutions, and optimizing returns into the future. Named a best place to work, year after year according to Fortune, Forbes and Glassdoor, we attract and develop world-class talent. Join us on our mission to embrace technology, empower customers and deliver the future.
More on Rackspace Technology
Though we’re all different, Rackers thrive through our connection to a central goal: to be a valued member of a winning team on an inspiring mission. We bring our whole selves to work every day. And we embrace the notion that unique perspectives fuel innovation and enable us to best serve our customers and communities around the globe. We welcome you to apply today and want you to know that we are committed to offering equal employment opportunity without regard to age, color, disability, gender reassignment or identity or expression, genetic information, marital or civil partner status, pregnancy or maternity status, military or veteran status, nationality, ethnic or national origin, race, religion or belief, sexual orientation, or any legally protected characteristic. If you have a disability or special need that requires accommodation, please let us know.