POSITION MISSION: The Oracle DBA is responsible for managing CBQ Oracle DB infrastructures span across multiple sites. The responsibilities include administrating the day-to-day technical activities related to
maintaining reliable and effective DB environments responsive to the requirements of Information Systems , keep running DB with best performance and making sure that system is secured and Data is well protected by having proper secure mechanism and well tested backup procedures.
MAIN DUTIES AND RESPONSIBILITIES:
Monitor the daily alerts and take necessary action day to day.
DBA should be skilled in all DBA related tasks such as DB Monitoring, Backup/restores, DB refresh (cloning, export/import), DB Migrations, Encryption, Performance Tuning using various tools such as AWR/ADDM/ASH , sql patch , SPM, stats pack etc.
Apply PSU/SPU/BP/RU patches regularly in phase manor DEV/UAT/PROD Environment.
Designing, and delivering a successful Oracle RAC project to build Enterprise Oracle RAC (12c/11g) Clusters and Standalone RAC Clusters. Good hands-on for Building the Disaster recovery Site.
Analyze project requirements and design solutions to ensure that databases are functionally appropriate, technically valid, and well-integrated in accordance with the business user requirements, methods and standards throughout the project lifecycle.
Experience on Oracle Replication technologies like Oracle Data Guard to ensure copy at a remote location that is open read-only while replication is active and Oracle Golden Gate/Streams for DB migration over heterogeneous hardware platforms and database management systems and for DB Upgrade with different versions of Database (10g to 11g , 11g to 12c and vice versa).
Experience on implementing and maintaining OEM 12c/13c.Oracle Enterprise Manager (OEM) Engineer providing the technical design and delivery role in the Engineering and Infrastructure Delivery lifecycles from installation, integration, maintenance, currency and upgrades of database software and features as it relates to theOracle platform.
Perform annual DR Test. Disaster recovery (DR) mechanisms for all components of these solutions, In the event of a failure, service must be resumed within a very short period of time, with minimal or no data loss.
Working with application team for their requirements and provide better suggestions to them
Extensive PL/SQL development experience.
Automation or daily and repeated tasks using the Job schedule and Cron. Experience is Bash or Shell scripting to understand the end-user requirement and design accordingly.
Experience with Unix/Linux in a multi domain environment and handle basis administration tasks.
Upgradation or migration of DB by having lesser down time
Implementing new concepts which are available from oracle New versions. It will make DBA to manage DB easily
Oracle Database capacity planning using OEM and with DBMS_SPACE PL/SQL package. Send periodic update to stake holder on DB growth and future planning’s need to be addressed.
Data purging and space reclaim regularly using different methodologies (Purging from tables/Trim the Datafiles/Rebuilding the indexes, drop the table partitions
Provide necessary security setups to DB
Coordinate with vendors, technology partners in selecting new solutions and maintaining the existing device
Ensure systems meets the PCI standards and ensure meet as per external and internal audit requirements
Make sure that backups for all DB are fine by doing backup testing atleast every quarterly.
Engineering in Computers by Affiliated University or Master
Oracle Database 12c Administrator Certified Professional (OCP)
Oracle Database 12c: RAC and Grid Infrastructure Administration (Grid)
Oracle Enterprise Manager 12c Certified
Oracle Database 12c: Performance Management and Tuning
English – Upper-Intermediate Oral & Written
Excellent Computer literacy
Minimum 6 Years of experience as Oracle RAC DBA/DBM
Working knowledge of event, incident & problem management processes and tools
Strong organizational skills.
Ability to work on own initiative and make decisions,
Self-motivated with an ability to work in a dynamic environment.