ChampaignRecruiter Since 2001
the smart solution for Champaign jobs

Database Systems Administrator

Company: Communications Data Group Inc
Location: Champaign
Posted on: August 4, 2022

Job Description:

Reports To: Information Technology Director MUST BE a US citizen and live in the United States. Relocation assistance is not being offered for this position. Job Summary The Database / Systems Administrator ensures the databases (DB2 & PostgreSQL) and underlying systems (primarily RHEL, some AIX) supporting CDGs technology platforms, are secure, perform efficiently and are highly available. They also provide second- and third-line technical support to local and remote staff and will be a key resource in a multi-year re-platforming project. Key Responsibilities and Accountabilities

  • Work with developers to create and modify database structures
  • Perform database maintenance tasks, including backups/restores, updating statistics, rebuilding indexes, insert/update/delete operations, etc.
  • Change database schemas using Database Modification Requests (DMR) via SQL scripts
  • Maintain system security and data integrity by developing access system policies; specify user access levels and database access
  • Manage and secure customer Personal Identifiable Information (PII) across all database environments
  • Patch and upgrade host systems and database platforms to ensure they're secure and remain compliant for vendor support
  • Ensure optimal hardware and storage subsystems by managing disk allocation and CPU allocation/performance
  • Maintain a data dictionary by revising and entering definitions based on information provided by development teams and for those areas the DBA is solely responsible
  • Assist with the development, implementation and reporting of KPIs and SLAs
  • Develop, manage, and maintain elements of the disaster recovery and high availability plan
  • Participate in departmental projects as required
  • In conjunction with other IT staff, work to continually improve platform services provided to the business
  • Anticipate customer needs and proactively identify solutions
  • Maintain knowledge of emerging technology
  • Communicate effectively, verbally and in writing with people at all levels of the organization
  • Effectively translate complex, technical concepts into easy-to-understand language to assist non-technically oriented customers
  • Establish and maintain effective relationships with staff members, customers, and vendors.
  • Work in a team environment making positive contributions to the organization.
  • Other duties as assigned or required Requirements:
    Qualifications and Skills
    • Associate's degree in Computer Science or Business Information Systems, a related degree or equivalent experience; Bachelor's preferred
    • 3 years of relevant work experience
    • Extensive experience with (minimum versions) DB2 10.5 and PostgreSQL 12
    • Strong working experience of Red Hat Enterprise Linux 6.10 and newer, and Shell Scripting
    • Certifications including Linux Foundation Certified Engineer (LFCE) and PostgreSQL Associate or Professional Certification preferred. Certification will be required within 12months of hire date
    • In-depth understanding of database engines and strong performance tuning skills
    • Experience building highly resilient, geographically separated database clusters
    • Understanding of and experience with Cloud hosting solutions (AWS, Azure, etc.) preferred
    • Experience with/exposure to VMWare and other virtualization technologies preferred
    • Ability to troubleshoot service outages as they occur, including after hours and weekends
    • Can work under pressure, prioritize multiple requests, meet deadlines, and achieve goals
    • Ability to work independently and with others in a team environment
    • Strong telephone, oral and written communication skills required
    • Must demonstrate accountability, willingness to accept responsibility and commitment to customer satisfaction
    • Excellent attention to detail Benefits
      • Vacation/Sick time off
      • Medical insurance
      • Dental insurance
      • Vision insurance
      • Life insurance
      • 401(k) with matching (up to 6%)
      • Flexible spending account PM22 PI186584307

Keywords: Communications Data Group Inc, Champaign , Database Systems Administrator, IT / Software / Systems , Champaign, Illinois

Click here to apply!

Didn't find what you're looking for? Search again!

I'm looking for
in category

Log In or Create An Account

Get the latest Illinois jobs by following @recnetIL on Twitter!

Champaign RSS job feeds