Description

Job DescriptionTo install, tailor and maintain the organizations Relational DatabaseManagement Systems (RDBMS).Roles and ResponsibilitiesCreates and maintains all databases required for development,testing, Education and production usage.Performs the capacity planning required to create and maintain theDatabases. The DBA works closely with system administration staffbecause computers often have applications or tools on them inaddition to the Oracle Databases.Performs ongoing tuning of the database instances.Install new versions of the Oracle RDBMS and its tools and anyother tools that access the Oracle database.Plans and implements backup and recovery of the Oracle database.Controls migrations of programs, database changes, reference datachanges and menu changes through the development life cycle.Implements and enforces security for all of the Oracle Databases.Performs database re-organizations as required to assistperformance and ensure maximum uptime of the database.Puts standards in place to ensure that all application design andcode is Produced with proper integrity, security and performance.The DBA will perform reviews on the design and code frequently toensure the site standards are being adhered to.Evaluates releases of Oracle and its tools, and third party productsto ensure that the site is running the products that are mostappropriate. Planning is also performed by the DBA, along with theapplication developers and System administrators, to ensure thatany new product usage or release upgrade takes place with minimalimpact.Provides technical support to application development teams. Thisis usually in the form of a help desk. The DBA is usually the point ofcontact for Oracle Corporation.Enforces and maintains database constraints to ensure integrity ofthe Database.Administers all database objects, including tables, clusters,indexes, Views, sequences, packages and procedures.Assists with impact analysis of any changes made to the databaseobjects.Troubleshoots with problems regarding the databases, applicationsand Development tools.Create new database users as required.Manage sharing of resources amongst applications.The DBA has ultimate responsibility for the physical databasedesign.The Senior DBA should Liaise with other member of DBA Team andshould mentor as and when requiredEducational Qualifications & certificationsBachelor s or Master s in Information Systems, ComputerScience/IT, or a related fieldOracle Certified Database Professional is a mustExperienceMinimum 3 years of experience in Database Administration in 24 7Environment.Required SkillsGood experience and knowledge with Oracle databaseInstallation, migration, up-gradation and administration (10g,11g,12c)Very Good experience and knowledge in Implementations andUpgrade projects of Oracle Application Servers and OracleDatabase 10g /11g / 12c with RAC.Good experience and knowledge with Oracle 10g Applicationserver and Oracle Weblogic server Administration.Good experience and knowledge in Oracle Database 10g/11g/12cPerformance Tuning.Good experience and knowledge in High Availability Environments(Using Oracle MAA) Real Application Clusters (RAC) and DataGuard.Good experience and knowledge with Oracle RAC and OracleGrid Infrastructure.Good experience and knowledge in Grid Infrastructure, OEM-Gridcontrol and Oracle enterprise Manager.Good experience and knowledge in Automatic StorageManagement (ASM) and RAW Device shared storage in RACEnvironment.Good experience and knowledge with RMAN, and other backupand recovery technologies.Good experience and knowledge with Oracle with different Linux,Solaris, HP-Unix, IBM-AIX and Windows Platforms.Good experience and knowledge in Database Designing,Installation, Cloning, Migration, Patching, Space management,ASM, ADDM, AWR, Security management, Performance tuningand Troubleshooting any inconsistencies in the database.Very good experience and knowledge about Oracle ServerInternals.

Skills

• DATABASE ADMINISTRATOR