Database Management Support
Education: BS Minimum
Location: Baltimore
Hours: Personnel shall work an eight-hour day (normal
business hours, but actual work hours to be changed), Monday through Friday
Personnel may be required to work past this time, on evenings,
overnight, weekends, or Holidays as the work dictates.
Salary: 41 to $51/Hour
Minimum Requirement
The candidate shall:
·
Have at least 5 years of practical experience as a database management
resource.
·
Have
a minimum of 5 years managing Oracle
databases including, oracle databases on windows and Linux platform with Oracle
10g and 11g with, installation, configuration, deploying, migrating, backup and
recovery, including oracle architectures replication/Streams; Oracle
connection manger installation and configuration; experience with PL/SQL
programming using SQL developer, Toad; experience in Microsoft SQL Server 2005
and 2008 database management; experience in working in virtualization
environment with Oracle and VMware infrastructure.
·
Possess five (5)
years of expertise in at least one the following types of systems:
o
Financial
Management Systems
o
Management
Reporting
o
Document
Management
o
Business
Process/Workflow Automation
o
Human
Resource Systems
o
Law
Enforcement Systems
Duties
and Responsibilities of the Database Support Candidate
The work to be accomplished shall include but not
limited to the following subtasks:
a. Propose and implement database
management policies, procedures and standards.
b. Provide database monitoring
and statistical reports using Oracle Enterprise manager Grid control 11g.
Monitor alerts, schedule daily, weekly, and monthly backups.
c. Coordinate the installation
and implementation of database management system software and related software
tools with vendors, other data processing staff and systems users.
d. Maintain security and
integrity of data access policies, standards, and method, by establishing
recovery plans to minimize data losses and system downtime and by performing
back up routines for the database management system software and for the stored
data.
e. Monitor database performance
and make modifications and adjustments to database architecture, storage
methods and management system software to fine tune the database.
f. Monitor database capacity and
allocate space according to overall needs of systems users, available data
storage and database management system requirements.
g. Maintain and hourly, daily,
weekly, monthly and yearly test backup and recovery process for Disaster
Recovery readiness using Oracle RMAN, data pump and cold & hot backups.
h. Provide knowledge of using
MAXIID TWIC card reader devices, configuration and develop interface program
between MAXID handheld device and existing Oracle database systems.
i.
Provide hands on working experience in Oracle streams configuration,
implementation and conflict resolutions for data replication.
j.
Monitor streams capture, propagation and apply jobs and fix the errors
encountered if any.
k. Perform periodic database
refreshes, cloning from Production to Development and Test environments.
l.
Provide database support during full development cycle of application from
design to testing and implementation, on-call production, test and development
support.
m. Proactively research the
latest database technologies and perform lab tests as needed/requested,
document and make recommendations by performing return on investment analysis
for higher management.
n. Create new Oracle databases
using DBCA, as per the standards, and upgrade existing 10g databases to 11g;
apply the latest Oracle Security patches.
o.
Upgrade existing Oracle 10g application to 11g application server with
Oracle web logic server.
