• Job Description

  Req#: JPC - 10182833

  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.

  Job Title: Database Architect

  Location: Columbus, OH (Remote/Hybrid)

  Employment Type: Contract

  Must be very dependable and experienced ORACLE DBA to manage complex systems like Ohio SACWIS system which uses ORACLE (runs on UNIX with RAC architecture) as the database

  Job Description:

  • The Department of Children and Youth (DCY),Office of Information Services (OIS), is seeking an experienced Oracle databaseadministrator who will drive high-caliber database design, solution delivery,and support in a fast-paced and collaborative environment. The successfulcandidate must be an influential technical leader with deep database expertiseand a collaborative style that promotes a culture of innovation and wellmanaged excellence. We are seeking an experienced Oracle DBA who is verycapable of managing the ORACLE databases for complex systems like Ohio SACWISsystem that uses the RAC (Real time Application Clustering) architecture on theUNIX platform.
  • PL/SQL experience, Transparent Data Encryptionexperience & database partitioning experience is very crucial to thisposition. RAC experience is preferred to manage complex Ohio SACWIS systemwhich runs on Unix with RAC architecture. Shell scripting & experience withOracle Data Guard is a must.
  • The candidate will be working with otherdatabase administrators across different agencies that manage several databaseplatforms, including (but not limited to) Azure Cloud platform, Oracle Databases.

  This DBA will be responsiblefor managing Oracle databases on the UNIX platform. They will ensure the best practices indatabase planning, design, configuration, performance and capacity planning andgrowth ensure our Oracle databases offer the highest reliability andperformance 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-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.
  • Will also work with project management to support and ensure timely and effective client communications about deployments and upgrades.

  Skill:	Required / Desired	Amount	of Experience
  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

  Regards,

  Kabeer Singh

  Email: kabeer.singh@usgrpinc.com

  Phone: 614 495 9222 EXT 471

  USG Inc. | Vivid Soft Global Inc.

• About the company

  United Software Group, Inc. (USG) is a Global Information Technology Consulting Company established in the year 2002 with its Headquarters in Columbus-Ohio, USA. USG is operating a business in 6 countries USA, Mexico, Canada, UK, Ireland and India. USG is a Minority Owned Enterprise (MBE) offering IT consulting, Talent Management and Staff Augmentation Solutions to its Clients. USG is recognized by INC5000 as Americas Fastest-Growing Private Companies and is honored with A+ rating by BBB as a mark of a trustworthy customer-oriented organization. USG’s services are based on requirements specified by operational business users from different industries such as Banking & Financial, Consumer Good and Distribution, Telecommunication, Insurance, Engineering, Healthcare, Life Sciences, Retail, Manufacturing and Automotive.

Notice