Spruce InfoTech, a leading IT firm, offers innovative and cost-effective solutions to help clients manage and transform their businesses. Our services are designed to guide companies of all sizes, from small businesses to Fortune 500 organizations, in maximizing their IT investment while reducing technology costs. Our team of experts has extensive technical knowledge in enterprise solutions, which helps organizations transform these solutions into a strategic asset that can drive new revenue and improve business operations.

Website

http://www.spruceinfotech.com

Designation: Senior Oracle DBA

Location: 100% Remote, anywhere in Canada

Type: Contractor

Term: 6 – 12 months

Required Experience and Skills

• Minimum 8 years of production database support.

• Hands-on experience supporting large database environments.

• Proven experience with database replication techniques, complexities, automation, monitoring, and high-availability strategies--use of 3rd party solutions in these techniques is encouraged.

• Previous experience working with Systems Admins in the areas of storage, backups, and database operations processes preferred.

• Excels in a collaborative environment and is willing to own all database related activities.

• Experience with Oracle Multitenant (CDB/PDB).

• Working experience with Golden Gate, desired.

• Working experience with RAC.

• Working experience with ERP systems on Oracle databases (JDE/E1 desired).

• Experiences in disaster recovery and Data Guard setups.

• Experience working in UNIX, Linux, and Windows platforms.

• Public Cloud Oracle database experience with OCI required (OCI certifications desired).

• Public Cloud Oracle database experience with AWS desired (AWS certifications desired).

• Migrate Oracle databases.

• Provision Oracle databases.

• Backup and restore databases.

• Implement high availability and disaster recovery.

• Monitor and optimize the performance of cloud databases.

• Understand services consumed by each client's organization.

• Deep understanding of the value of a client's data and take appropriate measures to keep this value intact.

• Build and maintain highly distributed data pipelines that are high-performance.

• Explore internal and external threat sources.

• Automate common management tasks.

Essential Functions

• Design, document, and monitor the database servers.

• Develop standards and procedures for maintenance and modification of database platforms.

• Provide systems architecture guidance in creating high availability systems.

• Provide direction in capacity planning, performance improvement, and storage management in partnership with other client and internal resources.

• Plan and support the implementation of major architectural changes.

• Develop back-up and recovery procedures, including testing back-ups and data integrity.

• Proactive and reactive performance analysis, monitoring, troubleshooting and resolution of issues.

• Assist Business functions on delivery of timely business metrics data.

• Assist the company in developing a data driven business culture.