765834-DCY - Senior Database Architect 1 - SDA1

S M Software Solutions Inc; Columbus (OH); Remote; USD 109,000 - 184,000; Full time

Job summary

A leading IT consulting firm seeks a Senior Database Architect to drive database management and solution delivery for its clients. The successful candidate will work with Oracle databases on the UNIX platform and ensure optimal performance and security. The role requires a deep understanding of database systems, strong leadership, and proven expertise with critical database technologies. Join a collaborative environment focused on delivering innovative IT solutions.

Qualifications

• Proven experience with Oracle DBA on UNIX platforms.
• Expertise in PL/SQL, Transparent Data Encryption, and database management.
• Leadership skills and ability to guide less experienced personnel.

Responsibilities

• Manage Oracle databases ensuring high reliability and performance.
• Provide DBA support for distributed servers in a multi-data center environment.
• Lead incident resolution efforts and oversee database design and architecture.

Skills

PL/SQL

Database Partitioning

Shell Scripting

Transparent Data Encryption

Oracle Data Guard

Education

Bachelor's degree in Computer Science or related field

Tools

Oracle Databases

Azure Cloud

Job description

765834-DCY - Senior Database Architect 1 - SDA1

765834-DCY - Senior Database Architect 1 - SDA1

13 hours ago Be among the first 25 applicants

Requisition Class: SDA: Senior Database Architect 1

Work Location: Columbus, OH, US, (Remote)

Estimated Start Date: 07/01/2025

Estimated End Date: 06/30/2026

Note: Only candidates who are legally authorized to work in the United States should apply. Candidates without valid work authorization are strictly advised not to apply, as they will not be considered or submitted to the client.

Overview

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 who is very capable of managing the ORACLE databases for complex systems like Ohio SACWIS system that uses the RAC (Real time Application Clustering) architecture on the UNIX platform.

PL/SQL experience, Transparent Data Encryption experience & database partitioning experience is very crucial to this position. RAC experience is preferred to manage complex Ohio SACWIS 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 workwith 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-data center 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.
  
  

How To Apply

If you are interested in this exciting opportunity, please submit the following documents to [e-mail]:

• Updated Resume in Word format (Mandatory)
• Expected hourly rate (Mandatory)
  
  

Note: Applications without the mandatory documents cannot be processed.

If this role is not suitable for you, please feel free to forward this message to anyone who may be interested.

Thank you for considering this exciting opportunity with us!

If you have any questions or need further clarification, feel free to call or text at [phone].

Seniority level

• Seniority level

  Mid-Senior level

Employment type

• Employment type

  Full-time

Job function

• Job function

  Information Technology

• Industries

  IT Services and IT Consulting

Referrals increase your chances of interviewing at S M Software Solutions Inc by 2x

Get notified about new Senior Database Architect jobs in Columbus, OH.

Columbus, Ohio Metropolitan Area 11 hours ago

Columbus, OH $109,900.00-$183,100.00 22 hours ago

Columbus, OH $109,900.00-$183,100.00 1 day ago

Senior Backend Software Developer (Remote)

We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.