Syntricate Technologies
Database Administrator
Syntricate Technologies, San Jose, California, United States, 95199
Database AdministratorSan Jose, CA onsiteContractRole Description:
Experience in performance tuning of database, instances, SGA, I/O, and rollback segment.Experience in SQL Tuning, Wait Events, Histogram, Join Methods (Nested Loop, Hash Join, Merge join cartesian), Index scan Methods (Range Index scan, Fast full index scan, Skip scan index methods), oracle wait events ( DB file sequential read , db file scattered read , GC wait events), Top SQLs Analysis at database level ( CPU/Memory/load)Expertise in Plan change Analysis of the SQLs while upgradation of databases.SQL query optimization and instance tuning using TKPROF, SQL Trace, Explain Plan, AWR and ADDM reports, gathering statistics, pinning the objects, running scripts, troubleshooting, bug fixing.? Able to work with oracle support to create SR and troubleshooting and fix the issues.Competencies: Digital : EAS : Oracle Cloud InfrastructureExperience (Years): 6-8Essential Skills:
Minimum 8+ years' Experience in the Software IndustryUnderstanding of Software design patterns, SDLC, Continuous Integration and Continuous DeliveryA drive to get things done in a highly collaborative and agile development environment.Strong analytical and problem-solving skillsOracle database concepts and ArchitectureKnowledge on Oracle Cluster Ready services (CRS), Data Guard, RMAN backup/recovery methods and maintenance of ASMOracle RAC administration and performance analysis ? Overall system performance tuningSQL Tuning, Wait Events, Histogram, Join Methods (Nested Loop, Hash Join, Merge join cartesian)Index scan Methods (Range Index scan, Fast full index scan, Skip scan index methods)AWR report, TKPROF analysis and interpretationTroubleshooting Long running transactions and ERP concurrent requests
Regards,shutosh Pasbolssistant Manager
|
Syntricate Technologies Inc.Direct:
(781)-552-4332Email:
shutosh@syntricatetechnologies.com | Web: www.syntricatetechnologies.com
We're hiring! connect with us on LinkedIn nd visit our Jobs Portal
Minority Business Enterprise (MBE) Certified | E-Verified Corporation | Equal Employment Opportunity (EEO) Employer
This e-mail message may contain confidential or legally privileged information and is intended only for the use of the intended recipient(s). Any unauthorized disclosure, dissemination, distribution, copying or the taking of any action in reliance on the information herein is prohibited. Please notify the sender immediately by email if you have received this email by mistake and delete this e-mail from your system. You have received this email as we have your email address shared by you or from one of our data sources or from our member(s) or subscriber(s) list. If you do not want to receive any further emails or updates, please reply and request to unsubscribe .
Experience in performance tuning of database, instances, SGA, I/O, and rollback segment.Experience in SQL Tuning, Wait Events, Histogram, Join Methods (Nested Loop, Hash Join, Merge join cartesian), Index scan Methods (Range Index scan, Fast full index scan, Skip scan index methods), oracle wait events ( DB file sequential read , db file scattered read , GC wait events), Top SQLs Analysis at database level ( CPU/Memory/load)Expertise in Plan change Analysis of the SQLs while upgradation of databases.SQL query optimization and instance tuning using TKPROF, SQL Trace, Explain Plan, AWR and ADDM reports, gathering statistics, pinning the objects, running scripts, troubleshooting, bug fixing.? Able to work with oracle support to create SR and troubleshooting and fix the issues.Competencies: Digital : EAS : Oracle Cloud InfrastructureExperience (Years): 6-8Essential Skills:
Minimum 8+ years' Experience in the Software IndustryUnderstanding of Software design patterns, SDLC, Continuous Integration and Continuous DeliveryA drive to get things done in a highly collaborative and agile development environment.Strong analytical and problem-solving skillsOracle database concepts and ArchitectureKnowledge on Oracle Cluster Ready services (CRS), Data Guard, RMAN backup/recovery methods and maintenance of ASMOracle RAC administration and performance analysis ? Overall system performance tuningSQL Tuning, Wait Events, Histogram, Join Methods (Nested Loop, Hash Join, Merge join cartesian)Index scan Methods (Range Index scan, Fast full index scan, Skip scan index methods)AWR report, TKPROF analysis and interpretationTroubleshooting Long running transactions and ERP concurrent requests
Regards,shutosh Pasbolssistant Manager
|
Syntricate Technologies Inc.Direct:
(781)-552-4332Email:
shutosh@syntricatetechnologies.com | Web: www.syntricatetechnologies.com
We're hiring! connect with us on LinkedIn nd visit our Jobs Portal
Minority Business Enterprise (MBE) Certified | E-Verified Corporation | Equal Employment Opportunity (EEO) Employer
This e-mail message may contain confidential or legally privileged information and is intended only for the use of the intended recipient(s). Any unauthorized disclosure, dissemination, distribution, copying or the taking of any action in reliance on the information herein is prohibited. Please notify the sender immediately by email if you have received this email by mistake and delete this e-mail from your system. You have received this email as we have your email address shared by you or from one of our data sources or from our member(s) or subscriber(s) list. If you do not want to receive any further emails or updates, please reply and request to unsubscribe .