Oracle Database Administrator

Zylog Systems (Canada) Ltd. is currently seeking an Oracle Database Administrator (DBA).  Key responsibilities include:

DB Administration Activities:
1. Monitor and maintain the DB server and instances for all environments (Production, QA/REF, DEV, and Disaster Recovery).
2.Monitor and maintain the routine business cron jobs setup on the DB instances of various types, adjust them according to their usage.
3. Routinely refreshing non-production DB instances with Production DB data.

DB Programming Activities:
1. Provide Production Support, i.e., solve bugs reported about DB operations, extract data/reports according to business/customer requests, integrate with external customers through FTP/SCP file transfer to process batch job posting and other business processes using DB cron jobs calling stored procedures.  Most requests come in the form of issue tracking tickets opened by the Technical Support Team, Account Manager and Business Analyst.
2. Participate in the Design and Development of enhancement/customization requests.  Work with the BA and Developers to understand the new features. Work out the required DB changes including table changes, trigger changes, stored procedure/function changes, DB cron job changes, and create/maintain reports in the MS reporting server, loading translated content into DB.
3. Provide support for external customers running the Talentflow system, through their VPN connection.

DBA tasks can be performed relatively independently (Working closely with the IT Infrastructure Team).  However, the DB programming level tasks require working closely with the BA, Account Manager, Technical Support and lead Developer(s) to provide support/solutions both to the business and to the development team, on a daily basis. 

The opportunity will often present itself for the DBA to interact directly with the Customer to obtain specific requirements related to the database.  The DBA will work with a BA (Business Analyst) and PM (Project Manager) at the time of Business Requirements Gathering.

Minimum Qualifications:

• Certified as an Oracle DBA
• Degree in Computer Science or equivalent work experience
• Minimum 6 years of DBA working experience building, deploying and administering distributed Oracle database management systems
• Sound knowledge of database auditing, audit logging, creating benchmark for audit points
• Experience with database security and database encryption
• Sound knowledge of users access and database privileges
• Experience with deploying database security patches and remediation of database vulnerabilities.
• Experience with installation, configuration and maintenance for 9i/10g/11g RAC and 10g/11g ASM
• Experience with the building, configuring, monitoring, and implementation of Oracle DataGuard technology.
• Good Database Programming experience in SQL and PLSQL
• Programming experience in building and parsing the XML files
• Experience in Data Migration tools and methodologies
• Expertise in managing Oracle databases in Linux/Solaris Environments
• Experience with UNIX shell scripting
• Strong RMAN backup/recovery experience on very large databases
• Strong skills in writing stored procedures/functions
• Hands-on experience with Oracle performance analysis using Statspack, SQL tracing, etc.
• Expert experience in troubleshooting and resolving urgent/critical incidents on production systems
• Experience with performing back-up and recovery for both application tablespaces and catalogue table spaces
• Comfortable with working in a rapidly changing, technically complex environment
• Proficiency with MS office product suite (Word, Excel, PowerPoint etc.)
• Excellent communication (both written and oral)
• Strong interpersonal and relationship building skills
• Organized, such as the ability to plan project and deliver development work
• Goal-oriented/self motivated
• A proven team player
• The ability to participate in knowledge transfer of information with peers and all levels of management

If you are interested in the above position, please send a covering letter and your resume via email to Barry.Bruce@zylog.ca  no later than 5:00pm on February 27, 2012.  We would like to thank all applicants for their interest in the position