Database Administrator IV

LocationBurnaby, BC
Job CategoryInformation Technology
SP-ID25761
Position TypeContract
Application Deadline November 6, 2020
Experience Required5+ years
Job Duration6 months
Education RequiredN/A

Our client is looking for a “Database Administrator IV” to work in Burnaby, BC.
 
JOB DESCRIPTION:
 
• Create Database architecture
• Design and Build databases from business requirements
• Develop innovation, strategies, processes, and best practices
• Work with development team on database design to meet business requirements
• Write and troubleshoot complex stored procedures
• Develop Oracle Replication solution
• Develop Oracle DR solution
• Develop Oracle Backup and Recovery solution
• Oracle Database configuration management (Memory, CPU, storage)
• Oracle Performance Tuning
• Oracle Perforce Testing with Applications
• Create Oracle Maintenance plans
• Create and maintain Oracle Build documentation
• Create and maintain Oracle maintenance and sustainment documentation
• Create Oracle escalation process and documentation
• Manage Oracle operations for all Client-Based Application in all environments
• Create and maintain Oracle reporting – Daily, Health, and Exception requirements (project)Installing, configuration and upgrading of database servers
• Planning storage requirements for the database system
• Modifying the database structure, as necessary, from information given by application developers
• Reviewing PL/SQL code done by developers and proposes improvements
• Reviewing system and programming designs to ensure efficient use of database resources
• Controlling and monitoring user access to the database
• Monitoring and optimizing the performance of the database
• Backing up and restoring databases
• Contacting database vendor for technical support
• Developing and testing database backup procedures
• Identifying improvements to existing databases by determining users’ information requirements and system performance and functional requirements
• Performing daily system monitoring, verifying the integrity and availability of all hardware, server resources, systems and key processes, reviewing system and application logs, and verifying completion of scheduled jobs such as backups
• Writing complex scripts for data manipulation and management as well as report generation
• Following all established procedures
• Writing technical documentation and deliverables
• Understanding of business processes supported by these systems
Mandatory Experience:
• 5+ years Oracle DBA skills on UNIX/Linux platform
• 5+ years Oracle Developer skills
• Expertise with building HA solutions
• Demonstrated work experience with application development and support
• Excellent communication skills.
• Positive, flexible, open-minded approach towards work assignments
• Good interpersonal skills with a natural ability to work with and support colleagues, ability to adapt to and work effectively with clients and co-workers with different styles and levels of technical knowledge
• Must be able to work in a team environment, as well as independently with minimal supervision and work well under pressure
• Good analytical, troubleshooting, debugging skills and proven ability to discern critical from minor problems
• Ability to prioritize, manage, and handle multiple tasks at one time.

 
To apply, send your resume to:
r.jeon@maxsys.ca