logo for information-management-architect.com
Home
Strategy
Framework
Business Case Analysis
Project Planning
Requirements Analysis
Architecture & Design
Build Phase
Quality Assurance
Transition to Production
Management Information
Business Intelligence
Data Warehouse
Tools
Jobs
Contact David Bowman
leftimage for information-management-architect.com

What are Database Administrator Jobs?

Need information management database administrator jobs and want some practical suggestions about responsibilities, qualifications and salaries?

An information management project data base administrator (DBA) isDatabase Administrator Jobs responsible for creating all development and test database environments and for building the development and test databases.

Development phase responsibilities include:
  • The creation and implementation of personal schema’s, development environments, integration test environment, quality assurance test and user acceptance test environments;
  • Executing data definition language (DDL) scripts, created by the data modeler, and creating the data base schemas;
  • Applying DDL changes to each environment as required;
  • Preparing data manipulation language (DML) scripts to backup and restore data that might be impacted by data model changes;
  • Creating test data from production data and manipulating it as necessary to meet data security requirements;
  • Creating back-ups of development and test databases and restoring as necessary to meet requirements;
  • Creating operations/infrastructure specifications;
  • Creating operations/infrastructure scripts; and
  • Working with development teams to optimize data base queries and performance.
Quality assurance testing responsibilities

The DBA is required to promote DDL and DML from the development environment to the quality assurance environment. 

They will usually be heavily involved with quality assurance testing, as the development team should not have access to this environment.

Typical tasks include creating scripts to prepare data for testing, executing DML scripts, creating back-up/restores of databases as appropriate and performance tuning.

Release to production

The project DBA is actively involved with release testing to ensure that all portions of the database change are tested prior to moving to production.

They are also responsible for preparing the DDL portion of the release package. This is handed over to a production DBA, as part of the release process.

The production DBA is responsible for executing scripts in the production environment.

What qualifications are required for database administrator jobs?

A DBA usually requires 6-8 years of database administration experience in a data-warehousing environment.

Certification courses are offered by leading relational database management vendors such as Oracle, Sybase and Teradata.

What are salaries expectations?

Experienced information management DBA’s, with 6-8 years of related experience, should expect to earn $60,000-90,000.

What are contract employee salary expectations?

Contract employees can expect to earn anywhere from $50 to $75 per hour. However, there are usually middlemen involved and this rate could be much lower than expected depending upon supply and demand and the resource staffing firm commission.

Can this work be done part time?

DBA project work can be done remote. The workload will peak during the early part of the development phase when they are needed to create the environments, and during quality assurance testing and release to production.

This role can be completed on a part time project basis.

Summary…


Information management projects are data centric and require highly skilled IT specialists to fill database administrator jobs.

A database administrator is a key resource required to support development, quality assurance and release to production.


footer for Information management page