Conduent Oracle DBA in East Lansing, Michigan

Oracle DBA

Description

Conduent is the world's largest provider of diversified business process services with leading capabilities in transaction processing, automation, analytics and constituent experience. We work with both government and commercial customers in assisting them to deliver quality services to the people they serve.

We manage interactions with patients and the insured for a significant portion of the U.S. healthcare industry. We are the customer interface for large segments of the technology industry and the operational and processing partner of choice for public transportation systems around the world.

Whether it's digital payments, claims processing, benefit administration, automated tolling, customer care or distributed learning - Conduent manages and modernizes these interactions to create value for both our clients and their constituents. Learn more at www.conduent.com .

General Summary of Function/Purpose of Position:

The Database Administrator is responsible for the integrity and availability of all of DHHS’s Human Services statewide critical and complex Oracle databases. In conjunction with Database Administrators (DBA’s) who are responsible for specific databases, this position sets policy for managing databases. This includes: backup/recovery, startup, and shutdown; monitoring, estimating, and planning. In addition this position is responsible for working with the Server Group regarding space utilization and requirements. This position performs performance tuning: - identifying and solving minor and major bugs and issues on a 24/7 basis; providing ongoing production support regarding creating new tables, columns, indexes, scripts, etc. In addition this position works with developers and others to support their ability to use the data to further the interests of the department. This includes data cleanup, conversions, running scripts, synchronizing versions, database upgrades, and providing expertise in SQL and PLSQL coding to developers and other Database Analysts and Database Administrators.

Database architectural design and performance management technical authority. Responsible for database modeling and design in support of the development and performance of mission critical agency applications. Provides resolution to escalated database support issues. Technical subject matter expert in the areas of database management, performance, security, modeling and design concepts. Oversight of Database security on an ongoing basis to prevent unauthorized database access. Authorize developers and user access to database in a controlled environment.

Tasks may specifically include but are not limited to:

  • In direct collaboration with the Information Technology Solutions Architect, design information technology solutions and serve as architectural leader for database design and functionality in support of software applications and system interfaces across multiple hardware and software platforms.

  • Plans and designs the database hosting architecture in compliance with State standards, strategic direction, and the system business requirements.

  • Design and provide technical leadership for the management of the physical structure of development and production databases providing acceptable performance.

  • Responsible for the development, documentation, and enforcement of database models, designs and management, access controls.

  • Oversee the creation and validation of the physical database (tables, columns, indexes, partitions, table spaces, triggers, constraints, stored procedures, etc.); initial setup of all database instance and schema parameters; server and file system setup; space allocation; working with data warehouse staff on writing and maintaining scripts that transfer transactional data to the warehouse; etc.

  • Provide technical leadership for the development and organization of the databases.

  • Provide technical leadership for software installations, upgrades, patches and configuration changes of relational database management systems.

  • Planning and determining impacts for scheduling changes in the operations of the database management systems.

  • Responsible for the resolution of escalated support issues surrounding database management, system monitoring, tuning, and optimization to ensure that the database management system is working to meet data performance requirements.

  • Serve as an expert in designing and identifying effective use of shell scripting as it relates to database administration and overseeing its implementation.

  • Provides management with a long-term perspective on the relationship of database technology to supported systems.

  • Using available DBMS management tools available to DTMB staff, regularly analyze access to the department’s data; investigate and eliminate all unauthorized data access.

  • Ensure End users’ access to data is via the applications only.

  • Ensure data security policies and procedures are adhered to at all times.

  • Ensure the enforcement of database security standards.

  • Provide authoritative consultation and direction to the Server Group System Administrators to conduct regularly scheduled data backup and data recovery as needed.

  • Provide authoritative consultation and direction to developers and their supervisors to ensure relevant development data is backed up and recoverable when needed.

  • Provide authoritative consultation and direction to the EBUR unit to ensure the backup process has the correct policy and the policies are working correctly.

  • Report all unauthorized activity to immediate supervisor.

  • Provide database access to new users and remove unauthorized users from the system

  • Mentor DBA’s with lesser experience on database security related issues.

  • Provide SQL and PL/SQL coding expertise: includes writing functions, procedures, and packages; reviewing, analyzing, and testing code written by others, for database performance reasons; etc.).

  • Assessment and implementation of new technologies to database administrators and application development.

  • Oversee regularly scheduled data recovery to ensure backed up data is recoverable.

  • Perform regular tests of recovery process to ensure data recovery is possible without data loss.

  • Provide authoritative consultation and direction to the EBUR unit to ensure the backup process has the correct policy and the policies are working correctly.

Required Education:

A Bachelor’s degree in Computer Science, Software Engineering, or equivalent degree.

Conduent is an Equal Opportunity Employer and considers applicants for all positions without regard to race, color, creed, religion, ancestry, national origin, age, gender identity, gender expression, sex/gender, marital status, sexual orientation, physical or mental disability, medical condition, use of a guide dog or service animal, military/veteran status, citizenship status, basis of genetic information, or any other group protected by law. People with disabilities who need a reasonable accommodation to apply for or compete for employment with Conduent may request such accommodation(s) by clicking on the following link, completing the accommodation request form, and submitting the request by using the "Submit" button at the bottom of the form. For those using Google Chrome or Mozilla Firefox please download the form first: click here to access or download the form at https://downloads.conduent.com/content/usa/en/file/conduent-applicant-adaaa-referral-form.pdf .

Job Service Delivery Client Network Services

Primary Location United States-Michigan-East Lansing

Organization Government

Unposting Date Ongoing

Req ID: 18026296