Major Position Responsibilities: Production/Application DBA
# Understand Data Modeling as it relates to both a logical and a physical model.
# Manage the Change Control process to insure that changes are being made at the appropriate times.
# Administer all DDL changes to application databases.
# Perform migrations of DDL changes from the test environments to the production environment.
# Establish, maintain and document an appropriate DB maintenance schedule via the Production scheduler, keeping the requirements of the application in mind.
# Perform database maintenance functions.
# Ensure the availability of the data through the development and installation of a disaster recovery strategy.
# Understand and research RDBMS related security issues.
# Serve as technical advisor, providing technical expertise and training to the application developers and end-users as needed, along with assisting with the development of RDBMS applications, including
o Be able to write, review and debug SQL.
o Establish and conduct training sessions on DBA related subjects.
o Provide database expertise for new proposals, services and products.
# Perform and document all ONCALL duties assigned
o 24 X 7 support for all Production environments and any mission critical test environments.
# Perform monitoring and trouble shooting of the application systems.
# Recommend performance improvements to the application teams.
# Monitor and implement performance improvements to DBA maintenance.
# Stay current on DBA knowledge.
# Participate in application meetings, change management and problem meetings as required (i.e. status meeting)
# Work with application developers to define, implement and maintain the best solution possible.
# Interface with appropriate vendors.
# Document and maintain the DB standards (ie database names).
# Evaluate RDBMS products and features.
# Evaluate, implement, support and use RDBMS support software
# Provide DA team with enforcing database standards (ie column names)
# Perform additional assignments as requested by supervisor or management
# Monitor the status of databases as needed, and notify appropriate personnel when there are concerns (e.g., growth limits).
# Perform all activities within the established plans and schedules
# Possesses above average problem solving skills.
# Analyzes and documents problems and requirements that are understandable at all levels.
# Communicate, both (verbally and in writing), with people at all levels of the corporation, in a clear and concise manner.
# Acts as integral member of team.
# Possesses good organizational skills and time-management skills.
# Sets challenging goals and works diligently to achieve or surpass them.
# Manage competing demands in a stressful environment.
# Possesses good work habits, including ability to work well with others.
# Take initiative, keeps promises, honors commitments, and takes responsibility for own actions or mistakes.
# Promotes change as necessary in a continually improving organization; is enthusiastic and optimistic in the face of change.
# Possesses a working knowledge of Data Center procedures and schedules, Turnover Control procedures, Programming productivity tools.
# 5+ Years experience with Oracle
# Advanced SQL and PL/SQL skills
# Oracle 9i and 10g
# SQL tuning experience
# Solid data loading skills (load scripts, import, export, etc.)
# UNIX experience
PREFERRED:
# 1+ year with MS/Sql Server/Sybase/DB2
# Relational and Data warehouse design knowledge
. Oracle Real Application Cluster (RAC), Oracle Data Guard
# Oracle GRID
# Knowledge of partitioning large databases
# Knowledge of Healthcare or MMIS
ACS is an Equal Employment Opportunity/Affirmative Action Employer and does not discriminate against any applicant on the basis of race, color, religion, national origin, age, gender, marital status, disability, sexual orientation, military/veteran status, or any other status protected by Federal or State law or local ordinance.
It is NOT ok to contact this poster with commercial interests.
 Relevant Posts:
Oracle Manufacturing
Senior Analyst EPL Oracle Planning Power User
Oracle Fin DBA
Oracle DBA
Oracle DBA
|
