7 Tkprof Jobs

Location: Mumbai Designation: Consultant Entity: Deloitte Touche Tohmatsu India LLP Oracle core DBA with Golden Gate Experience Need a candidate having 3-6 years exp in Oracle DBA activities and also having hands-on exp in Golden gate configuration and implementation

As a senior SAP Consultant, you will serve as a client-facing practitioner working collaboratively with clients to deliver high-quality solutions and be a trusted business advisor with deep understanding of SAP Accelerate delivery methodology or equivalent and associated work products. You will work on projects that assist clients in integrating strategy, process, technology, and information to enhance effectiveness, reduce costs, and improve profit and shareholder value. There are opportunities for you to acquire new skills, work across different disciplines, take on new challenges, and develop a comprehensive understanding of various industries. Your primary responsibilities include: Strategic SAP Solution FocusWorking across technical design, development, and implementation of SAP solutions for simplicity, amplification, and maintainability that meet client needs. Comprehensive Solution DeliveryInvolvement in strategy development and solution implementation, leveraging your knowledge of SAP and working with the latest technologies. Required education Bachelor's Degree Preferred education Master's Degree Required technical and professional expertise Overall industry experience of 3-5 years Oracle Apps DBA (EBS), Unix/Linux/AIX, General Cloning, Patching, Backup Skills & Performance Tuning Knowledge, must have experience in Oracle Apps DBA (EBusiness Suite versions like R12.1 and R12.2) as a primary skill. Must have Knowledge of configuration, administrating, monitoring, troubleshooting, cloning, Patching in Oracle Apps 12.2 Preferred technical and professional experience Basic WebLogic server administration needed, must be expertise in AD utilities, EBS Maintenance activities. Responsible for reviewing application/databases, health checks and identify performance bottlenecks and fixing those. Knowledge hot and cold backups and recovery for Oracle EBusiness suite database and application of PLSQL, and SQL, Oracle Workflow, Oracle Forms, Knowledge of traces, TKPROF and find poorly performing SQL/PLSQL and ability to tune those using explain plan, or using statistics method

Must Have Skills: Minimum 6+ years of e xperience in support and operation process with below skills- DB PL/SQL Oracle SQL and PL/SQL (performance tuning of SQL queries) Servers Linux (must)- Understanding and through knowledge of Linux server environment (bash) Script Bash/Python/PL/SQL Application Server Apache Tomcat Production Support Troubleshoot application problems, analyse logs and provide details Good to Have Skills Report PowerBI /Webfocus report ETL tools ODI/OWB Good knowledge of system security, update OS process, analyse vulnerability, apply patches Communication Should have good analytical and communication skills. Create any necessary Documentation: Create necessary documentation as part of the support activity, RCA and process. Job Roles / Responsibilities\u202F Support running production application, validate data, validate data replication between multiple databases and data processing with client. Analyse application logs to validate if application is running as expected. Support QA Platformvalidate deployment package provided by dev team, deploy application to QA platform, validate application is running as expected in QA environment. Identified potential issues in QA and report to dev team. Develop required script which will help in day-to-day support activity LSQL - Procedures/Functions, bash/python scripts and Windows bat script. Deploy application to staging and production environment. Validate deployment, test application, debug application. Coordinate support activity across support team and getting job done. PL/SQL Development: Design, develop, and maintain PL/SQL packages, procedures, functions, triggers, and scripts. Write efficient and optimized PL/SQL code for business logic and data manipulation. Database Design and Management: Create and manage database objects such as tables, views, indexes, sequences, and synonyms. Normalize database schema and enforce data integrity using constraints. Understanding on OLTP and OLAP Performance Tuning: Analyze and optimize existing PL/SQL code and queries for performance. Use tools like SQL Trace, TKPROF, and Explain Plan to identify bottlenecks. Data Integration: Develop ETL (Extract, Transform, Load) processes using PL/SQL to migrate and transform data. Work with external systems for data import/export. Debugging and Troubleshooting Debug PL/SQL code and resolve run-time errors. Conduct unit testing and participate in integration testing. Collaboration with Other Teams Work with front-end and middleware developers to integrate PL/SQL logic with applications. Collaborate with data analysts, DBAs, and business analysts to understand data requirements. Support: Support production environments and handle on-call support for PL/SQL-based issues. Ability to check and simulate the production tickets and provide the fix in a timeline Shell Scripting: Monitoring the crontab jobs to validate the smooth process of daily loads Ability to write and understand the shell script Conduent is an Equal Opportunity Employer and considers applicants for all positions without regard to race, color, creed, religion, ancestry, national origin, age, gender identity, gender expression, sex/gender, marital status, sexual orientation, physical or mental disability, medical condition, use of a guide dog or service animal, military/veteran status, citizenship status, basis of genetic information, or any other group protected by law. People with disabilities who need a reasonable accommodation to apply for or compete for employment with Conduent may request such accommodation(s) by submitting their request through this form that must be downloaded:click here to access or download the form. Complete the form and then email it as an attachment toFTADAAA@conduent.com.You may alsoclick here to access Conduent's ADAAA Accommodation Policy. At Conduent we value the health and safety of our associates, their families and our community. For US applicants while we DO NOT require vaccination for most of our jobs, we DO require that you provide us with your vaccination status, where legally permissible. Providing this information is a requirement of your employment at Conduent.

company name=Apptad Technologies Pvt Ltd., industry=Employment Firms/Recruitment Services Firms, experience=4 to 10 , jd= Oracle Apps DBA, Golden Gate Oracle RAC Oracle version 19c Oracle Data GuardPerformance Tuning All above mentioned skills are mandate Secondary - SQL, scripts, Comms, scripting language , Title=Oracle Apps DBA, ref=6566456

Role Purpose The purpose of this role is to provide solutions and bridge the gap between technology and business know-how to deliver any client solution Do 1. Bridging the gap between project and support teams through techno-functional expertise For a new business implementation project, drive the end to end process from business requirement management to integration & configuration and production deployment Check the feasibility of the new change requirements and provide optimal solution to the client with clear timelines Provide techno-functional solution support for all the new business implementations while building the entire system from the scratch Support the solutioning team from architectural design, coding, testing and implementation Understand the functional design as well as technical design and architecture to be implemented on the ERP system Customize, extend, modify, localize or integrate to the existing product by virtue of coding, testing & production Implement the business processes, requirements and the underlying ERP technology to translate them into ERP solutions Write code as per the developmental standards to decide upon the implementation methodology Provide product support and maintenance to the clients for a specific ERP solution and resolve the day to day queries/ technical problems which may arise Create and deploy automation tools/ solutions to ensure process optimization and increase in efficiency Sink between technical and functional requirements of the project and provide solutioning/ advise to the client or internal teams accordingly Support on-site manager with the necessary details wrt any change and off-site support 2. Skill upgradation and competency building Clear wipro exams and internal certifications from time to time to upgrade the skills Attend trainings, seminars to sharpen the knowledge in functional/ technical domain Write papers, articles, case studies and publish them on the intranet Deliver No. Performance Parameter Measure 1. Contribution to customer projects Quality, SLA, ETA, no. of tickets resolved, problem solved, # of change requests implemented, zero customer escalation, CSAT 2. Automation Process optimization, reduction in process/ steps, reduction in no. of tickets raised 3. Skill upgradation # of trainings & certifications completed, # of papers, articles written in a quarter Mandatory Skills: Oracle Database Admin. Experience8-10 Years.

As a senior SAP Consultant, you will serve as a client-facing practitioner working collaboratively with clients to deliver high-quality solutions and be a trusted business advisor with deep understanding of SAP Accelerate delivery methodology or equivalent and associated work products. You will work on projects that assist clients in integrating strategy, process, technology, and information to enhance effectiveness, reduce costs, and improve profit and shareholder value. There are opportunities for you to acquire new skills, work across different disciplines, take on new challenges, and develop a comprehensive understanding of various industries. Your primary responsibilities includeStrategic SAP Solution FocusWorking across technical design, development, and implementation of SAP solutions for simplicity, amplification, and maintainability that meet client needs. Comprehensive Solution DeliveryInvolvement in strategy development and solution implementation, leveraging your knowledge of SAP and working with the latest technologies. Required education Bachelor's Degree Preferred education Master's Degree Required technical and professional expertise Overall industry experience of 3-5 years Oracle Apps DBA (EBS), Unix/Linux/AIX, General Cloning, Patching, Backup Skills & Performance Tuning Knowledge, must have experience in Oracle Apps DBA (EBusiness Suite versions like R12.1 and R12.2) as a primary skill. Must have Knowledge of configuration, administrating, monitoring, troubleshooting, cloning, Patching in Oracle Apps 12.2 Preferred technical and professional experience Basic WebLogic server administration needed, must be expertise in AD utilities, EBS Maintenance activities. Responsible for reviewing application/databases, health checks and identify performance bottlenecks and fixing those. Knowledge hot and cold backups and recovery for Oracle EBusiness suite database and application of PLSQL, and SQL, Oracle Workflow, Oracle Forms, Knowledge of traces, TKPROF and find poorly performing SQL/PLSQL and ability to tune those using explain plan, or using statistics method

Project Role : Infra Tech Support Practitioner Project Role Description : Provide ongoing technical support and maintenance of production and development systems and software products (both remote and onsite) and for configured services running on various platforms (operating within a defined operating model and processes). Provide hardware/software support and implement technology at the operating system-level across all server and network areas, and for particular software solutions/vendors/brands. Work includes L1 and L2/ basic and intermediate level troubleshooting. Must have skills : Oracle Database Administration (DBA) Good to have skills : NA Minimum 7.5 year(s) of experience is required Educational Qualification : 15 years full time education Summary :As an Infra Tech Support Practitioner, you will provide ongoing technical support and maintenance of production and development systems and software products, both remote and onsite. You will work within a defined operating model and processes, implementing technology at the operating system-level across all server and network areas. Roles & Responsibilities: Installation of Oracle on Linux /IBM-AIX / Sun Solaris / Windows & HP-UX. A minimum of 7 years' experience as DBA with experience in automation and scripting. Strong knowledge of infrastructure in general including Operating System, Clustering, Storage, network etc Provide Architecture design and support for development projects from a database perspective. Experience in handling multiple databases medium to large databases (multi terabyte). Plans and implements backup and recovery of the Oracle database. Excellent knowledge of Oracle backup and recovery scenarios. Repair corrupts databases (logical exports and imports, restore from backups). Upgradations, applying new patches Developed backup & restore strategies for Hot & offline backups. Disaster Recovery planning & Implementation Oracle Dataguard. Strong knowledge of Oracle RAC Database , Datagaurd, Exadata , Partitioning Compression, RMAN, ASMM and AMM. Should have excellent knowledge of tools like AWR, ADDM, OEM, SQL Plan baselining, Trace files , tkprof and autotrace. SQLT ASH , expdp / Impdp SQL loader SQL Plus. Knowledge and experience in Oracle Golden gate and basic understanding of VCS is desirable. Hands on experience of PL/SQL coding. Should have experience in developing in DevOPS automation tools like Jenkins, Ansible Unix shell, GITHUB, API development using Mule/Kong framework, Go-LANG, Python and PowerShell with working knowledge of AI/ML technology and tools. Working - - knowledge of SRE framework Experience in working on other databases, like Postgres , MongoDB, SQL Server, Public cloud AWS , GCP etc. Coordinate the implementation of process controls in the team. Basic understanding of Change management process and raise the change orders on need basis. Provide L3 production support analyse cases reported by L1, possible solutions and fixes. Creates and maintains all databases required for development, testing and production usage. Administers all database objects, including tables, indexes, views, sequences, packages and procedures. Participate in Production Release and Changes during Weekends. (on a need basis ) Additional Information: The candidate should have a minimum of 7 years of experience in Oracle Database Administration (DBA) This position is based at our Noida office A 15 years full time education is required Qualifications 15 years full time education