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) is
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.
|