Hello
Hope you are doing well.
My name is *Gagan *from *Elegant Solutions. *and I have job located in
Harrisburg,
PA *.* Client is looking for *SQL DBA *and the detailed description of the
job is mentioned below. If you have any consultant comfortable and
interested, please reply back with your updated resume and following
information:-
Full Legal Name:
Email id:
Phone Number:
Current Location:
Relocation:
Visa Status:
Availability to join:
Availability for Interview:
Rate:
Three Professional References:
*(Name/Title/Company/Contact/Email)*
*Position: SQL DBA*
*Duration: 1 Year*
*Location:Harrisburg, PA*
*Scope of the Project*
The various services needed are items such as (but not limited to)
maintaining the database backup/recovery script(s) so that the system can
be restored in the event of a major disaster, maintaining database
replication processes, performance tuning, software enhancements and
various support services required. PFBC is in need of someone to assist
PFBC staff in maintaining and debugging this complex and critical PFBC
system as we continue with the implementation of this system. Finally, an
interface needs to be developed between PFBC’s Pennsylvania Automated
Licensing System (PALS) and the RATS system previously mentioned. PALS is
a third-party developed system that handles the selling of Fishing
Licenses, Online boat registrations, and several other PFBC products; and
maintains the critical financial information associated with the sale of
these products. So far, this system has not been successfully integrated
with PFBC’s Registration and Titling System, thus requiring PFBC staff to
manually enter PALS boat registration data into RATS. PFBC requires
development of an efficient interface between these two systems to reduce
staff time spent manually inputting data that is already available in an
electronic format.
*Responsiblities:*
1. Provide Database Backup/Recovery support such as the following:
a. Maintain the nightly backup script used to export database data and
compress/remove old archive logs
b. Maintain database archive logs
c. Assist in implementation of hot backups or tablespace data file backups
d. Perform database crash recovery procedures when needed
e. Assist with making on demand database backups when needed
f. Assist with monitoring the nightly database export backup to tape
g. Assist with monitoring hot backups or tablespace data file backups
h. Assist with the monitoring and maintenance of Oracle Data Guard or other
database replication software and/or process
2. Provide all necessary Performance Tuning which will include:
a. Adjust the amount of disk space used by database data files, archive
logs and database exports as needed
b. Adjust the amount of memory allocated to individual databases as needed
c. Monitor RSIPLATE application table and index extent sizes and adjust as
needed
d. Monitor database configuration parameters and tune as needed
e. Monitor rollback segment usage and tune as needed
f. Assist with monitoring hard disk and RAM memory usage on the AIX server
3. Perform the following other tasks:
a. Perform database user account maintenance
b. Maintain database access privileges
c. Periodically change database system account passwords
d. Assist with the installation of Oracle software patches and upgrades on
both the client and the AIX server.
4. Run database modify scripts included with each new release of the RATS
application software. Pennsylvania has both a test and a production
database. This item does not include the running or scripts to modify any
other databases (a training database, for example) that may be configured.
The DBA tasks typically performed for a new software release are as follows:
a. Disable archive logs if needed
b. Enable restricted session
c. Warn database users and kill any remaining user sessions
d. Check nightly database backup or export database
e. For each alter script in the new release -
- Add database name and current date to alter script
- Uncomment state specific SQL statements as needed
- Execute alter script
- Review alter script output
- Correct any errors
f. Execute create view script, review output and correct any errors
g. Execute create script to create database procedures, functions and
triggers
h. Compile invalid procedures and functions
i. Execute create index/constraint script, review output and correct any
errors
j. Drop temporary tables
k. Rebuild indexes in the correct tablespace using a single extent
l. Execute script to modify table next extent sizes as needed
m. Execute script to grant RSIPLATE application database permissions
n. Enable archive logs if needed
o. Update database version document (DbVersion.doc)
p. Disable restricted session
q. Email database update notice, change log, data dictionary and data model
to interested parties
5. Provide all necessary assistance with the construction of ad hoc SQL
database queries for retrieval of data from the database.
6. Provide all necessary assistance in constructing SQL data modify and
delete statements beyond those covered under the software support contract.
*Required Skills*
5-7 Years experience giving production support of SQL Databases
*Gagandeep Purba*
Direct: *703-348-2872*
Fax:* 703-722-6628*
Email: gspu...@elegantsolutions.us
*Elegant Enterprise-Wide Solutions, Inc *
We Participate in E-Verify
An SBA 8(a), ISO 9001:2008 Company
*Prime on GSA Schedule 70, 8(a) STARS II, eFAST, Seaport-e & many
State/Local Contracts *http://www.elegantsolutions.us
--
You received this message because you are subscribed to the Google Groups
"CorptoCorp" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to corptocorp+unsubscr...@googlegroups.com.
To post to this group, send email to corptocorp@googlegroups.com.
Visit this group at http://groups.google.com/group/corptocorp.
For more options, visit https://groups.google.com/d/optout.
