Database Systems Administrator

Description

Reports To: Vice President Information Technology

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