The Database Administrator is responsible for ensuring the proper management of all company database management systems. The Database Administrator works with developers to properly architect database systems, and also works with the infrastructure group to address issues related to database servers.
Position Responsibilities:
Ensure all database servers, applications toolsets and ERP, CRM and Financials applications are running properly by referencing system maintain procedures and monitoring the status of the corporate database systems.
Develop and implement long-term strategies to address database performance issues under the direction of the DBA Manager.
Monitor the regularly scheduled provider, eligibility and third-party vendor data load processes and communicate to the team status of these scheduled loads.
Review logs of all nightly batch processes, data refreshes, backup of the DBMS and notify status of such logs to the database system group.
Routinely verify that the RMAN database backups can successfully by restored and rolled forward, to proactively determine if the backup process is working properly.
Execute the data scrubbing mechanism when the production databases are used to refresh the QA and development testing environments.
Assist developers in tuning SQL queries for optimal performance.
Apply system patches and upgrades under the direction of the DBA Manager.
Attend data modeling and system design sessions to maintain understanding of the system infrastructure.
And any and all responsibilities
as assigned by management.
Skills and Competencies:
Bachelor’s Degree.
3-5 years of Oracle DBMS environment including installation, sizing, tuning, troubleshooting and overall management.
Working knowledge of Oracle Tools (Enterprise Mgr. Diagnostics & tuning packs).
Able to demonstrate strong SQL competency.
Competent in working with triggers, stored procedures, and all other schema objects.
Experience using SQLLoader and PL/SQL.
Hands on experience with Oracle RAC preferred.
Hands on experience with Oracle Data Guard preferred.
We would like to thank everyone who submits
their résumé for this opportunity. Due to the
volume of résumés we receive, only those candidates
selected for interviews will be contacted. LifeCare is an
AA/EEO employer.
