工作地址:and various, unanticipated locations throughout the U.S.
工作城市:Chicago
工作州:ILLINOIS
工作邮编:60606
工作职位:Senior Consultant (Database Services 040)
最低学历:Bachelor's
其他教育学历:
对应专业:See H.14
所需培训:N
培训时长:
所需培训领域:
前置经验:Y
经验时长（月）:36
替代领域学历:Y
替代专业:See H.14
可替代教育及经验组合:N
所需教育层级:
其他可替代教育层级:
认可经验年限:
境外教育背景:Y
可替代职业:Y
可替代职业时长（月）:36
可替代职业名称:See H.14
是否为正常职业要求:N
是否需要外语:N
特殊技能:Employer will accept Bachelors degree in Computer Science, Engineering, Business, or related field; and three years of work experience in job offered or three years of work experience in a related occupation. Experience must include one year of experience with each of the followingbr 1. Code review and performance analysis for SQL code;br 2. Tuning SQL queries for better performance using Indexes, hints, SQL profiles, SQL baselines, SQL Plan management, and SQL Tuning advisor;br 3. Monitoring performance of databases;br 4. Working with AWR, ASH, and ADDM reports to identify poor performing SQLs and tune them;br 5. Rewriting complex SQLs and locking the execution plan for poor performing queries;br 6. Working with Golden gate replication between two databases using DDL and DML replication;br 7. Checking user access, roles, auditing for different users and objects;br 8. Supporting database migrations, upgrades, and patching;br 9. Supporting RAC databases and Stand by databases using data guard;br 10. Working with data pump exportimport logical backup, guaranteed restored points using RMAN backup;br 11. Maintaining production database;br 12. Designing new structures procedures views functions for development and data migration; andbr 13. Writing LinuxUnix shell scripting.br Must be available to work on projects at various, unanticipated sites throughout the United States.