Technology Operations Specialist II

Job Description:
Sr DBA position; 10+ years Experience with Oracle Database Administration with experience in implementing multimaster replication using Golden Gate. DBA must be thorough with Active Active Active setup of replication and must have supported complex replication and must have a sound understanding of conflict resolution. This Oracle DBA will be responsible for installation, configuration, upgrading, administrating, monitoring, performance tuning, maintenance, and handling database security of Oracle databases running on a Linux platform. Must also
used autosys and should be extremely comfortable creating, modifying, moving jobs etc. Knowledge in Wide IP or 3 DNS is a plus. Exercises judgment within broadly defined practices and policies in selecting methods, techniques, and evaluation criterion for obtaining results.
Required Skills:

• Proficiency in Oracle database Backup/Recovery, Cloning, Maintenance, Datapump, Performance monitoring /tuning, Security management, PL/SQL Programming, with work experience on Oracle 11g/12c databases.
• Install, configure and support Golden Gate Deployments.
• Implement Golden Gate multi-master replication, must have implemented veridata and worked extensively on conflict resolution and complex replication strategy
• Applying Oracle patches and maintain ASM
• Sound knowledge of Autosys and must have created and supported jobs in autosys
• Troubleshoot complex systems to identify bottlenecks (SQL, IO, hardware, query related, etc.); Resolve database related issues.
• Provide production support in time sensitive situations in addition to providing support for multiple high profile applications /projects.
• Support release rollouts/builds for application teams. This requires client management skills and a comfort with change management concepts.
• Support project teams. This requires time management skills, comfort with bank processes, judgment regarding when to escalate issues to leads and management, and the ability to work as the SQL expert in part of a team Decisions/Actions must be in compliance to our internal standards and policies.
• Assist clients with fine tuning indexing and tune queries.
• Generate performance and efficiency metrics and offer expert advice to clients.
• Perform regular security and access reviews; Remediate as needed.

Desired Skills:

• Prior Bank of America Oracle DBA experience a plus

Shift:
1st shift (United States of America)
Hours Per Week:
40