DCY - Senior Database Architect 1 - SDA1

We are seeking an experienced Oracle database administrator who will drive high-caliber database design solution deliveryand support in a fast-paced and collaborative environment.

PL/SQL experience Transparent Data Encryption experience & database partitioning experience is very crucial to this position. RAC experience is preferred to manage complex system which runs on Unix with RAC architecture. Shell scripting & experience with Oracle Data Guard is a must.

The candidate will be working with other database administrators across different agencies that manage several database platforms including (but not limited to) Azure Cloud platform Oracle Databases.

This DBA will be responsible for managing Oracle databases on the UNIX platform. They will ensure the best practices in database planning design configuration performance and capacity planning and growth ensure our Oracle databases offer the highest reliability and performance possible. They will work with the DBA ITM1 to ensure that team goals and metrics are met.

• 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.

. Willalso work with project management to support and ensure timely and effectiveclient communications about deployments and upgrades.