Database Administrator

SUMMARY:
You will be responsible for the performance, integrity and security of the client’s databases. You will plan and develop databases, support users, and troubleshoot issues across a large data environment. National travel and after-hours work are required.

Key responsibilities

• Back up all database servers to meet Recovery Point Objectives (RPO), and test restores to confirm Recovery Time Objectives (RTO)
• Troubleshoot database service outages, including after hours and weekends
• Configure monitoring tools to minimise false alarms
• Choose high-availability and DR approaches (clustering, log shipping, mirroring, SAN replication, failover) for new systems
• Install and configure new database servers
• Deploy database change scripts from third-party vendors
• Diagnose performance issues and recommend the best fix: hardware, server configuration, or index/query changes
• Tune platform queries
• Troubleshoot server hardware using tools such as Dell OpenManage, HP SIM and IBM Director
• Manage database server components, including integration, analysis and reporting services
• Perform root cause analysis on production database incidents
• Handle daily maintenance, monitoring, problem resolution and developer/internal customer support
• Review, design and develop data models with application development teams
• Document the database environment
• Travel nationally and work after hours as required

POSITION INFO:
Minimum requirements Diploma or Bachelor's degree in Computer Science, Information Systems, Electrical\/Electronics Engineering, Business Management or a related field Certification in at least one enterprise database product (e.g. IBM Db2, Oracle, MongoDB, Cassandra, Redis, CouchDB, Ingres) 6+ years' experience developing data management systems, tools and architectures on Db2, Oracle and\/or similar platforms Minimum 5 years' database administration and API\/web-app interface experience on IBM and\/or Oracle Proven proficiency in Db2, Oracle and Linux, plus a programming language such as R, Python, Ruby or Java Experience designing and operating very large data warehouses and web-facing OLTP databases Advantageous Familiarity with big data technologies: Hadoop\/EMR, Redshift, DynamoDB, MongoDB, CouchDB, Redis, HBase, Cassandra