Senior Oracle Database Architect

• Should be able to provide DBA support for distributed servers in a multi-datacenter environment.
• Monitor daily activities and performance of complex application environments, analyzes technical problems, recommend adjustments, creates, and implements approved solutions using established tools and techniques.
• Provide technical assistance to the application development area and co-workers about database design and programming.
• Develop technical documents, project plans and tasks, interact with customers for proposed solutions.
• Provide non-production and production support for deploying code and assist in trouble shooting and resolving application issues.
• Support DevOps tools (Ansible, Jenkins, Nexis, Mavin, Bitbucket, Kony Mobile, Nginx etc.)
• Any other tasks assigned by the management team based on project/application needs.
• Provide technical Tier III support, develops project plans with project manager, or recommends approach through defining tasks.
• Leading meetings relating to design, implementation, operation, and ongoing maintenance of databases systems.
• Designs/plans of cluster nodes hardware selection and recommendations, configures/sets- up cluster nodes, sets-up interconnects, and configures cluster- aware storage; installs cluster and database management system (DBMS) software on all nodes.
• Monitoring load balance and tunes cluster parameters for high performance, configuring standby servers.
• Configuring and implements log shipping, configures, and implements replication etc.
• Provide technical leadership that fosters database innovation and champions automation.
• Support strategic planning for database architecture, resource management and capacity planning and growth.
• Ensures best practices in database planning, design, configuration, performance, and resilience.
• Evaluate and proposes design and process improvements to achieve performance and cost optimization.
• Identify inefficiencies in current database designs and oversees the implementation of improved solutions.
• Plans and implements capacity and resource expansion to ensure scalability of databases.
• Implements effective risk management controls and owns adherence to all compliance related items (exceptions, waivers, risks, technical compliance, and access control)
• Leads incident resolution efforts and engages appropriate resources to complete corrective actions as quickly as possible.
• Conducts research and provides recommendations on database products, services, protocols, and standards in support of procurement and development efforts.
• Virtualized Infrastructure running various Unix, Linux, and AIX operating systems.
• Altering storage structures to meet the evolving needs of the Organization.
• Regularly updating the database security protocols, patching.
• Provides leadership and work guidance to less experienced personnel.

PL/SQL experience, Transparent Data Encryption experience & database partitioning experience

Required

RAC experience is preferred to manage complex Ohio SACWIS system which runs on Unix with RAC architecture

Highly desired

Shell scripting & experience with Oracle Data Guard is a must.

Required