Hello Hope you are fine. I would appreciate it if you could go through the description and let me know if you are interested in discussing this role further. If so, please let me know a good time and a number to connect. While replying, kindly send me an updated copy of your resume. Role : Database Architect Location: (HYBRID) Job Description The Department of Children and Youth (DCY), Office of Information Services (OIS), is seeking an experienced Oracle database administrator who will drive high-caliber database design, solution delivery, and support in a fast-paced and collaborative environment. The successful candidate must be an influential technical leader with deep database expertise and a collaborative style that promotes a culture of innovation and well-managed excellence. We are seeking an experienced Oracle DBA capable of managing the ORACLE databases for complex systems like Ohio SACWIS system that uses RAC (Real-time Application Clustering) architecture on the UNIX platform. PL/SQL experience, Transparent Data Encryption experience, and database partitioning experience are crucial for this position. RAC experience is preferred to manage the complex Ohio SACWIS system which runs on Unix with RAC architecture. Shell scripting and experience with Oracle Data Guard are essential. The candidate will work with other database administrators across different agencies managing various database platforms, including (but not limited to) Azure Cloud platform and Oracle Databases. This DBA will be responsible for managing Oracle databases on the UNIX platform, ensuring best practices in database planning, design, configuration, performance, and capacity planning and growth to ensure high reliability and performance. They will collaborate with the DBA ITM1 team to meet team goals and metrics. 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, and implement solutions. Assist application development and co-workers with database design and programming. Develop technical documents, project plans, and interact with customers for proposed solutions. Support deployment of code in non-production and production environments, troubleshooting, and resolving application issues. Support DevOps tools (Ansible, Jenkins, Nexus, Maven, Bitbucket, Kony Mobile, Nginx, etc.) Perform other tasks as assigned by management based on project needs. Provide technical Tier III support, develop project plans, or recommend approaches by defining tasks. Lead meetings related to database design, implementation, operation, and maintenance. Design and plan hardware for cluster nodes, configure/setup nodes, interconnects, and storage; install cluster and DBMS software. Monitor load balancing, tune cluster parameters for performance, and configure standby servers. Configure and implement log shipping, replication, and other strategies. Provide technical leadership to foster innovation and automation. Support strategic planning for database architecture, resource management, and capacity planning. Ensure best practices in database design, configuration, performance, and resilience. Evaluate and propose design and process improvements for performance and cost optimization. Identify inefficiencies and oversee implementation of improvements. Plan capacity and resource expansion for scalability. Implement risk management controls and ensure compliance with standards and access controls. Lead incident resolution efforts and coordinate corrective actions. Research and recommend database products, services, and standards. Manage virtualized infrastructure across Unix, Linux, and AIX OS. Update storage structures and database security protocols regularly. Provide leadership and guidance to less experienced staff. Collaborate with project management for deployments and upgrades. Skills and Experience Required: PL/SQL, Transparent Data Encryption, and database partitioning experience. Preferred: RAC experience for managing complex systems like Ohio SACWIS on Unix with RAC architecture. Highly Desired: Shell scripting and Oracle Data Guard experience. #J-18808-Ljbffr
United Software Group