IT
Job DescriptionRole: Oracle performance tuning expert
Location: Brampton, ON
Duration: 6+ Months
BGV will be done for the selected candidates.
Candidate should be expert in Performance Tuning, Golden Gate administration, RAC clustering, ASM, Database & Application Server, Disaster Recovery using DataGuard, Backup and Recovery.
Profile: Oracle Performance tuning expert
Primary Functions:
Engagement Experience: Systems Design and Architecture (Performance Tuning, Maximum Availability Architecture, Golden Gate administration, RAC clustering, ASM, Database & Application Server, Disaster Recovery using DataGuard, Backup and Recovery)
Systems Analysis and Performance tuning (Oracle Database 12c,11g,10g, 9i, Application SQL and PL/SQL code tuning),
Provide ORACLE engineering, design and administration services to several large scale mission-critical ORACLE-based applications and environments.
Duties & Responsibilities:
Provide expertise on performance tuning, Oracle Golden Gate and be able to configure Golden Gate and troubleshoot the issues related to Golden Gate independently.
With broad and expert-level database technical knowledge and skills on Oracle databases, be able to provide database technical evaluation and recommendation on database design and architecture, integration, database high availability solution, database replication architecture, With strong database administration skills, be able to monitor and manage proactively of mission-critical production and
Experience with PL/SQL development, implementing new stored procedures and scripts, resolve complex PLSQL compilation issues, and fix errors due to object grants/dependencies.
Experience and knowledge of SQL queries and SQL Trace/Explain plans, SQL performance tuning. Setting Oracle parameters, and options.
Knowledge of creating and maintaining Tables, Partitioning, indexes, Triggers, stored procedures, etc. in a large terabyte database environment.
Hands-on experience on installation and configuration and trouble shooting of Oracle products and patches, including Exadata, RAC, ASM, Clusterware, Data Guard, OID, Grid/Cloud Control and DBaaS environments.
Solid experience in Linux, Linux Shell scripting Experience with Database links and Oracle heterogeneous services.
Writes database documentation, including data standards, procedures and definitions for the data dictionary.
Plan growth and changes (capacity planning) Sound knowledge of the SDLC, and experience in code migration, database change management and data management.
Qualifications
Minimum ten (13) years’ database administration experience with recent experience in the following areas:
Performance Tuning
Oracle Golden Gate
Oracle RAC
Oracle Exadata
Experience with Oracle 9-12c, (Oracle 12c, Oracle 11g, Oracle 10g R2, Oracle 9i) Golden Gate, RAC, Grid Control under HP-UX, AIX or Red Hat Linux.
Desired
Oracle technical certifications with rich experience in performance tuning and Golden Gate
Please respond with your word resume and requested details:
Full Name :
Work Authorization:
Contact Number :
Email ID :
Skype ID:
Current location:
Willing to relocate :
Rate/hr :
All your information will be kept confidential according to EEO guidelines.
Skills Required
- Minimum 13 years database administration experience
- Experience with performance tuning
- Expertise in Oracle Golden Gate
- Experience with Oracle RAC and Exadata
- Strong knowledge of PL/SQL and SQL
What We Do
Infoways specializes in providing comprehensive consulting, implementation, migration, upgrade, solution development, customizations, functional testing, user training, interface development, and support services for Infor solutions. Our expertise extends to Extensibility, ION, and Report Designer, enabling us to tailor solutions precisely to your requirements. We pride ourselves on our client-centric approach, ensuring that your needs are at the forefront of everything we do. Our services include functional and technical support, admin support, system availability management, incident support, trend analysis, and ticket reduction, among others, all aimed at enhancing your experience and maximizing the value of your Infor investments. Furthermore, our software development capability is at the forefront of innovation. For instance, we are currently enhancing applications in the Financial Services sector using Blockchain technology, showcasing our commitment to leveraging the latest technologies to drive meaningful change for our clients. Infoways offers flexible engagement models and has cultivated a robust talent pool of global resources with expertise in various technologies, including BaaN/LN, M3, Lawson S3, and more. Our team is well-versed in Agile methodology and SDLC best practices, ensuring that projects are delivered on time and within budget. If you are interested in knowing more about how Infoways can support your business and enhance your Infor experience, please let us know. We would be delighted to schedule a meeting with our team at your convenience to discuss Let's Connect We believe in the power of collaboration. Whether you're a client, partner, or future team member, let's embark on this journey together. ? [email protected] ☎ 609-718-0720 Join us at Infoways as we navigate the digital landscape, create meaningful solutions, and build a future where innovation knows no bounds.
