Sr. Oracle Developer/DB Developer Contract

VTRAC Consulting Corporation

“Intelligent Resources”

Thank you for applying to VTRAC opportunities. Please e-mail your resume as a MS-WORD document in confidence Subject: Sr. Oracle Developer/DB Developer, position number: 20-06563, Attention: [email protected] or call: 416-366-2600 Ext. 230

Position No.:                           20-06563

Title:                                           Sr. Oracle Developer/DB Developer

Type:                                          Contract

No. of Positions:                  1

Location:                                Toronto, ON

Position Description: 

This is a great opportunity for a DBA/Developer to join a trusted Canadian firm that focuses on connecting the investment industry.  The DB Developer will join an environment built on teamwork, flexibility and respect. Aside from the great company culture, the organization offers professional growth and development programs to help advance your career and competitive benefits that include fitness reimbursement and discount programs.

Responsibilities:

• Design and build secure, scalable, and high performing databases to support the creation, deployment, and maintenance of business applications running on Oracle and Open-Source databases.
• Provide guidance and support to development teams with database design, query optimization, proper stored procedure usage, indexing optimization, and schema optimization.
• Analyze third party APIs and develop PL/SQL stored procedures and use packages to integrate systems both in the cloud and on-premise.
• Partner with business and development teams to design, develop, test, and deploy applications.
• Populate development and QA environments with test data.
• Provide extended support for applications using SQL Server.
• Analyze and sustain capacity, availability, and performance requirements.
• Proactively maintain database systems at the most current versions of database servers including latest security patch levels for Oracle and MySQL databases.
• Establish and maintain access controls and security for all database environments.
• Monitor database systems for availability, performance, and data security.
• Troubleshoot and improve slow-running SQL scripts.
• Perform database backups and refreshes and maintain data replications for Oracle and MySQL databases.
• Support business continuity planning (system disaster recovery planning, implementation, as well as backup and recovery).
• Create metadata and audit data capture in support of data management strategy activities.
• Provide production and non-production database support, including troubleshooting, problem resolution, and on-call after hours and weekend support if needed.

Must Have:

• 12+ years of working experience preferably within an Infrastructure or Software.
• 10+ years of experience as a database developer/administrator and PL/SQL coding.
• 3+ years of experience working with Oracle RAC.
• Recent experience (within last 2 years) with Continuous Integration and Delivery CI/CD including use of Jira, Git, and Jenkins or other similar CI/CD tools and platforms.
• Oracle DBA certification would be an asset.
• Deep knowledge and experience designing and maintaining mission-critical production database systems with Oracle including completing Oracle DB upgrades. Knowledge of MySQL, Postgres or SQL Server is also valuable.
• Strong experience in PL/SQL, including developing database objects – writing and tuning SQL and PL/SQL code for stored procedures, functions, views, and triggers.
• Working knowledge with Oracle APEX.
• Experience in SQL performance tuning, resolving database, systems, and infrastructure-related issues, and working in a Unix and Linux environment with writing, designing, and automating scripts.
• Working knowledge with Agile and DevOps methodologies.
• Knowledge of cloud systems such as AWS and Microsoft Azure and integration technologies such as REST and/or SOAP would be an asset.
• Working knowledge within a LAMP software stack.
• Experience importing data into a relational database from various sources.
• Liaising with application developers to aide in query construction.
• Linux administration experience is an asset.
• Experience with cloud containerization environments (Docker, Kubernetes) is a nice to have.
• Great team player with strong interpersonal and verbal and written communication skills.
• Interested in working in an agile team environment.
• Ability to analyse and provide solutions to complex database performance issues.
• Demonstrates understanding of Data Warehouse and Data Hub architecture and the Software Development Life Cycle (SDLC), Quality Assurance requirements, and software development control and release procedures.
• Fully competent to provide technical guidance to other team members.
• Self-motivated with the ability to handle and prioritize multiple tasks within a team environment.
• Ability to meet tight timelines, be sensitive to confidentiality, and participate in a rotational on-call schedule during peak operational periods and for business critical processes.
• 4 year Bachelor’s Degree in Computer Science or Management Information Systems (MIS) or equivalent combination of education and working experience.

We thank all candidates in advance. Only selected candidates for interviews will be contacted. For other exciting opportunities, please visit us at www.vtrac.com. VTRAC is an equal opportunity employer.

Toronto                .                  New York                         .                Houston                    .                  Palo Alto

Tagged as: Agile, Database Developer, DevOps, Infrastructure, Oracle Developer, Oracle RAC, QA, Senior Oracle Developer, Software Development, SQL