Upgrade databases from lower version to latest version
Participate in project meetings, as necessary, to understand application and database requirements
Ability to work independently and to resolve complex Oracle issues
Run diagnostic tools to identify database performance bottlenecks, and take appropriate corrective actions to improve database performance. Work with development teams to tune SQL queries.
Proactive monitoring of the databases
Troubleshoot Oracle performance and non-performance related issues either independently or in conjunction with other DBAs
Manage backup/recovery for Oracle instances
Management of database and resource capacity planning.
Implement and enforce database security based upon best practice, SOX regulations, and company policies
Installation of new Oracle instances and upgrades
Provide after-hours support as required
Setting up and resolving issues with Oracle Data Guard environments
Experience in task automation
Scripting language (ksh, perl)
Experience Required:
Min. experience of 7+ yr. Oracle DBA required
Proficient and experienced with Oracle RAC (design, configuration, installations and tuning), including version Oracle 19c/12c.
Proficient and experienced with Golden Gate technology.
Proficient and experienced with ASM, RMAN and Active Data Guard database technologies.
strong production support experience & customer service skills
Oracle 19C, 12C and 11G Database Administration and Management on HP/Solaris and Linux environments
Oracle internals
Proven track record in supporting large number of db simultaneously
Oracle Database Tuning and Performance - usage of statspack, AWR, ADDM, ASH and UNIX native commands
Storage considerations for Oracle Database Performance
Oracle backup and recovery configuration and procedures
Oracle Enterprise Manager/Grid Control for environment standardization
Knowledge of enterprise data architecture principles
Ability to develop data requirements and configure database parameters accordingly
Takes the initiative to act on issues
EXADATA experience a huge plus
Key skills:
1. Good general, performance tuning, and troubleshooting skills for Oracle 19c/12c
Migrate databases from Solaris to Exadata (Oracle Enterprise Linux)/Red Hat Linux
Upgrade Databases from 12C to 19C - Exadata/Red Hat Linux Platform
Install, Configure Golden gate for data replication
Install, Configure RAC databases for high availability
Provide support on all the stages of database implementation and/or database related deployments
qualifications:
Experience level: Experienced
Minimum 7 years of experience
Education: Bachelors
skills:
Oracle
PostgreSQL
GOLDENGATE
exadata
SQL DBA
Equal Opportunity Employer: Race, Color, Religion, Sex, Sexual Orientation, Gender Identity, National Origin, Age, Genetic Information, Disability, Protected Veteran Status, or any other legally protected group status.