Duration:
33 months to start
Job Description:
Required Tasks to be performed:
- Establishing and maintaining databases used for development, test, production, data warehousing, and public access. Monitoring and reviewing the department’s database systems to ensure efficiency, integrity, and security of operation and to eliminate problems related to hardware, software, and procedural error.
- Recording, tracking, and investigating problems reported by users and keeping management informed of potential trouble areas, taking corrective actions to resolve and mitigate issues.
- Monitoring database performance across the development, beta, and production services; acting to resolve issues that affect these services to ensure that the maximum possible uptime availability is achieved.
- Administration and maintenance of DB Systems and database related VM instances in the Oracle Cloud Infrastructure (OCI) tenancy.
- Identifying and meeting the needs of customers and provide excellent customer service
Required Knowledge, Skills & Abilities (KSAs):
- 5+ years of experience managing Oracle Enterprise version 19c database instances.
- 5+ years of experience troubleshooting Oracle database administration and connection problems.
- 5+ years of experience monitoring Oracle performance metrics.
- 3+ years of experience reviewing physical schema models.
- 3+ years of experience with Oracle EM.
- 3+ years of experience working with Red Hat Linux or Oracle Linux command line syntax and crontab files.
- 1+ years of experience with Oracle Cloud Infrastructure (OCI).
- Knowledge of computer operations, systems and procedures.
- Knowledge of Unix commands and concepts.
- Knowledge of Oracle RDBMS administration tools and processes.
- Knowledge of database structures and theories.
- Knowledge of current database technologies.
- Knowledge of data analysis techniques.
- Ability to process information logically.
- Ability to develop short-range and long-range database storage/growth estimations.
- Ability to plan, organize and coordinate work assignments.
- Ability to communicate technical information effectively.
- Ability to establish and maintain effective working relationships with others.
- Ability to assess future information needs so that the databases can evolve in an appropriate manner.
- Ability to develop reports and cross references from the data dictionary.
Education:
- Bachelor’s Degree in Computer Science, Information Systems or other Information Technology major, or equivalent work experience.
