Job Description :
GC GCEAD Citizen H4EAD L2EAD TN visa only Oracle DBA Max Rate $35 Nashville, TN
Role: Orace DBA
Duration: 12+months
Location: Nashville, TN
GC, USC, GC-EAD, H4-EAD
Oracle Database Administrator
The Oracle Database Administrator creates and maintains Oracle 11g and 12c databases hosted on multiple physical platforms.
Functions
Performs general database administrative tasks including user account management, access control, database optimization and error resolution
Participates on project teams and works cooperatively with other IT professionals to achieve project results
Interacts with a diverse group of database users including end users as well as IT management
Utilizes a help desk and ticketing system for tracking issues to resolution
Works with application developers to optimize and tune programmatic database access
Requirements
Five years of professional experience in administering Oracle databases
A bachelor''s degree in Information Technology, Computer Science or a related field of study
Must be able to perform the following DBA tasks:
o Monitor production systems and databases daily using Enterprise Manager
o Create or copy databases as needed
o Promote data model changes through multiple test and production environments
o Create and manage documentation for databases and processes
o Follow established processes to perform daily and ad hoc tasks
o Partition databases based on growth and performance
o Grant, control and delete database access based on security requests
o Maintain secure databases including periodic password changes
o Ensure that database backups are working properly and perform ad-hoc backups as needed
o Recommend run-time improvements (RTIs) for batch processes
o Interact with stakeholders from various groups on database-related matters
o Develop and distribute database performance reports
o Restore databases to a prior backups or to a point in time
o Monitor database performance through (AWR) Automated Workload Repository and optimize when appropriate
o Monitor system for invalid objects
o Create or modify backup scripts
o Plan for and monitor database space usage
o Assist developers with coding, performance and system issues
o Perform SQL tuning and optimization
Preferred
Oracle certified in Oracle 11g
Oracle certified in Oracle 12c
Experience in a health care environment
Experience in utilizing the RedHat Linux and Oracle Solaris operating systems
Experience with Oracle Enterprise Manager Cloud Control, RAC, and GoldenGate