DATABASE ADMINISTRATOR D Decon

Job Description : Creates and maintain all oracle databases required for development, testing, patching, audit and production usage To perform the capacity planning required to create and maintain the databases. The DBA works closely with system administration staff because computers often have applications or tools on them in addition to the Oracle Databases. Perform ongoing tuning of the database instances. Proactively identify the long running sessions, or resource consuming sessions identify the queries causing the performance degrade, tune the query or given suggestions to developers for the same. Install new versions of the Oracle RDBMS and its tools and any other toolsthat access the Oracle database. Plan and implement backup and recovery of the Oracle database. Control migrations of programs, database changes, reference data changes and menu changes through the development life cycle. Implement and enforce security for all of the Oracle Databases. Performs database reorganization as required to assist performance and ensure maximum uptime of the database. Put standards in place to ensure that all application design and code is produced with proper integrity, security and performance. The DBA will perform reviews on the design and code frequently to ensure the site standards are being adhered to. Evaluate releases of Oracle and its tools, and third party products to ensure that the site is running the products that are most appropriate. Planning is also performed by the DBA, along with the application developers and System administrators, to ensure that any new product usage or release upgrade takes place with minimal impact. Provide technical support to application development teams. This is usually in the form of a help desk. The DBA is usually the point of contact for Oracle Corporation. Enforce and maintain database constraints to ensure integrity of the database. Administer all database objects, including tables, clusters, indexes, views, sequences, packages and procedures. Assist with impact analysis of any changes made to the database objects. Troubleshoot with problems regarding the databases, applications and development tools. Functional Competencies Must have expertise in Performance Tuning for at least 2 years Documentation of database related changes and to create and maintain Architecture document

Report this listing

Typical Pay for this Type of Work

Payscale

₹2.1L–10Lper year

Database Administrator (DBA)

Based on local employers

AmbitionBox

₹3.6L–6Lper year

Oracle Database Administrator

Based on local employers

Glassdoor

₹15L–16Lper year

Oracle Database Administrator

Based on local employers

Decon Jobs

More jobs at Decon Jobs

See web results for Decon Jobs

FeedbackLearn more

Turn on alerts for jobs like this

Get alerts for new jobs like this