Database Systems Administrator

Company: Communications Data Group Inc
Location: Champaign
Posted on: June 25, 2022

Job Description:

Description:
Reports To: Information Technology DirectorMUST BE a US citizen and live in the United States. Relocation assistance is not being offered for this position.Job SummaryThe 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 AccountabilitiesWork with developers to create and modify database structuresPerform 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 scriptsMaintain system security and data integrity by developing access system policies; specify user access levels and database accessManage and secure customer Personal Identifiable Information (PII) across all database environmentsPatch and upgrade host systems and database platforms to ensure they're secure and remain compliant for vendor supportEnsure optimal hardware and storage subsystems by managing disk allocation and CPU allocation/performanceMaintain 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 planParticipate in departmental projects as requiredIn conjunction with other IT staff, work to continually improve platform services provided to the businessAnticipate customer needs and proactively identify solutionsMaintain knowledge of emerging technologyCommunicate effectively, verbally and in writing with people at all levels of the organizationEffectively translate complex, technical concepts into easy-to-understand language to assist non-technically oriented customersEstablish 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 SkillsAssociate's degree in Computer Science or Business Information Systems, a related degree or equivalent experience; Bachelor's preferred3 years of relevant work experienceExtensive experience with (minimum versions) DB2 10.5 and PostgreSQL 12Strong working experience of Red Hat Enterprise Linux 6.10 and newer, and Shell ScriptingCertifications including Linux Foundation Certified Engineer (LFCE) and PostgreSQL Associate or Professional Certification preferred. Certification will be required within 12months of hire dateIn-depth understanding of database engines and strong performance tuning skillsExperience building highly resilient, geographically separated database clustersUnderstanding of and experience with Cloud hosting solutions (AWS, Azure, etc.) preferredExperience with/exposure to VMWare and other virtualization technologies preferredAbility to troubleshoot service outages as they occur, including after hours and weekendsCan work under pressure, prioritize multiple requests, meet deadlines, and achieve goals Ability to work independently and with others in a team environmentStrong telephone, oral and written communication skills requiredMust demonstrate accountability, willingness to accept responsibility and commitment to customer satisfactionExcellent attention to detailPM22PI183251395

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