19 Nov
|
Info-Ways
|
Brampton
19 Nov
Info-Ways
Brampton
OverviewRole: Oracle performance tuning expertLocation: Brampton, ONDuration: 6+ MonthsEmployment type: ContractIndustry: ITBGV will be done for the selected candidates.ResponsibilitiesProvide expertise on performance tuning, Oracle GoldenGate, and the ability to configure GoldenGate and troubleshoot related issues independently.With broad and expert-level database technical knowledge, provide database technical evaluation and recommendations on database design and architecture, integration, and database high-availability solutions.Monitor and proactively manage mission-critical production databases with strong database administration skills.Experience with PL/SQL development, implementing recent stored procedures and scripts, resolving complex PL/SQL compilation issues, and fixing errors due to object grants/dependencies.Work with SQL queries and SQL Trace/Explain plans, perform SQL performance tuning, set Oracle parameters, and optimize options.Knowledge of creating and maintaining tables, partitioning, indexes, triggers, and stored procedures in a large-terabyte database environment.Hands-on experience with installation, configuration, and troubleshooting 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, and experience with database links and Oracle heterogeneous services.Produce database documentation, including data standards, procedures,
and definitions for the data dictionary.Plan growth and changes (capacity planning) and apply sound SDLC knowledge; experience in code migration, database change management, and data management.ProfileOracle Performance tuning expertPrimary FunctionsEngagement Experience: Systems Design and Architecture (Performance Tuning, Maximum Availability Architecture, GoldenGate administration, RAC clustering, ASM, Database & Application Server, Disaster Recovery using Data Guard, 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 environmentsQualificationsMinimum ten (13) years' database administration experience with recent experience in the following areas: Performance Tuning, Oracle GoldenGate, Oracle RAC, Oracle ExadataExperience with Oracle 9-12c (Oracle 12c, Oracle 11g, Oracle 10g R2, Oracle 9i); GoldenGate, RAC, Grid Control under HP-UX, AIX or Red Hat LinuxDesirableOracle technical certifications with rich experience in performance tuning and GoldenGateApplication/Response DetailsPlease respond with your word resume and requested details:Full NameWork AuthorizationContact NumberEmail IDSkype IDCurrent locationWilling to relocateRate/hrAll your information will be kept confidential according to EEO guidelines.
📌 Oracle Performance Tuning Expert - Brampton, On
🏢 Info-Ways
📍 Brampton