Creates and maintains all databases required for development, testing, education and production usage.
Performs the capacity planning required to create and maintain the Sdatabases. The DBA works closely with system administration staff because computers often have applications or tools on them in addition to the Oracle Databases.
Performs ongoing tuning of the database instances.
Install new versions of the Oracle RDBMS and its tools and any other tools that access the Oracle database.
Plans and implements backup and recovery of the Oracle database.
Controls migrations of programs, database changes, reference data changes 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 assist performance and ensure maximum uptime of the database.
Puts 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.
Evaluates 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.
Provides 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.
Enforces and maintains database constraints to ensure integrity of the database.
Administers all database objects, including tables, clusters, indexes, views, sequences, packages and procedures.
Assists with impact analysis of any changes made to the database objects.
Troubleshoots with problems regarding the databases, applications and development tools.
Implement and maintain database security (create and maintain users and roles, assign - privileges).
Manage sharing of resources amongst applications.
Manage physical database design.
Perform database tuning and performance monitoring.
Work as part of a team and provide 24x7 support .
Why hire database dba
Cost Savings & Control
Less cost than the annual salary of a junior DBA, because you're sharing the resource with other companies
Subscription basis - scope and costs are defined up front.
Get exactly what you need
Outsource specific DBA functions without giving up control of the IT assets.
Provide monitoring, reporting, database restoration, recovery, maintenance and proactive tuning.
Staffing Efficiency
Manage your business critical systems with fewer people, and at a lower cost by providing remote support for the database environment on a 24 X 365 basis (or less).
Avoid the high turnover associated with DBAs. When a DBA leaves, they take your training investment and your peace of mind with them.
No need for over-staffing to provide redundancy.
Focus on Core Competencies, Speed to Market
Offload the burden of daily administration functions from existing staff and free time to focus on new development and strategic projects.
Avoid heavy investment of time and resources to build non-strategic technologies and processes in-house.
Experience rapid deployment and flexibility while ensuring non-stop system availability.
