Job Title: Oracle Database Architect
Location: Columbus OH (hybrid)
Duraion : 12 months
- Should be able to provide DBA support for distributed servers in a multi-datacenter environment.
- Monitor daily activities and performance of complex application environments analyze technical problems recommend adjustments create and implement 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 troubleshooting 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 develop project plans with the project manager or recommend an approach through defining tasks.
- Leading meetings relating to design implementation operation and ongoing maintenance of database 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 tuning 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 propose design and process improvements to achieve performance and cost optimization.
- Identify inefficiencies in current database designs and oversee 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.