Database Administration - DB2

SUMMARY:
Responsible for performance, integrity and security of databases. The Specialist: Database Administration is involved in the planning and development of a database, as well as in troubleshooting any issues on behalf of the users. 

POSITION INFO:
Key areas of responsibility: The Specialist: Database Administration will be required to perform the following duties, amongst others: · Ensure all database servers are backed up in a way that meets the business's Recovery Point Objectives (RPO) · Test backups to ensure we can meet the business' Recovery Time Objectives (RTO) · Troubleshoot Database Server service outages as they occur, including after-hours and weekends · Configure Database Server monitoring utilities to minimize false alarms · As new systems are brought in-house, choose whether to use clustering, log shipping, mirroring, or other technologies · Install and configure new Database Servers · Deploy database change scripts provided by third party vendors · When performance issues arise, determine the most effective way to increase · Performance including hardware purchases, server configuration changes, or index\/query changes · Document the Department's database environment · Tuning platform queries to improve performance · Troubleshooting hardware using tools like Dell Open Manage, HP System Insight Manager, and IBM Director · Failover clustering, SAN replication, and other high availability technologies · Managing IBM Server components such as Analysis Services, Integration Services, or Reporting Services · Root cause analysis of production-related database issues · Daily maintenance, monitoring, problem resolution and internal customer\/development support · Review, design and develop data models in conjunction with the application development teams · The role will be required to travel extensively nationally and work after hours as and when required POSITION REQUIREMENTS Education and experience required: · Diploma \/ Bachelor's degree in Computer Science, Information Systems, Business Management, Electrical Engineering, Electronics Engineering, or related discipline from an accredited tertiary institution is · Certification on at least one enterprise grade database product such, IBM, Oracle, Server, DB2, Redis, MongoDB, CouchDB, Cassandra, and Ingres. · 6+ years of experience developing data management systems, tools and architectures using IBM · Server, DB2, and Oracle databases, Redshift and\/or other distributed computing systems. · Familiarity with new advances in the big data space such as Hadoop\/ EMR and other technologies like Dynamo DB, MongoDB, CouchDB, Redis, HBASE, and Cassandra. · Experience designing and operating very large Data Warehouses and web facing online transaction processing databases. · Demonstrable proficiency and experience in IBM Server, DB2, Oracle, Linux, and programming languages such as R, Python, Ruby or Java. Skills and Competencies · Demonstrated experience with database technologies and API interfaces to WebApps and Administration in one or more of the following - IBM, Oracle (minimum of 5 years) · A results oriented individual who thrives working in a fast paced environment. · Strong written and oral communication skills · Strong organizational and project management skills with effective results focus within an information systems environment. · Strong analytical and problem solving skills. · Self-motivated with the ability to manage changing priorities and meet deadlines. · Proven ability to be flexible and work hard, both independently and in a team environment, in a high priority · customer service, on-call environment with changing priorities. · Willingness to work occasionally outside of normal business hours in response to needs of the systems being supported.