Overview of salaries statistics of the profession "Oracle Database Administrator in Canada"

DescriptionFortinet is looking for an enthusiastic and talented DevOps Engineer to join our DevOps team to work with developers and other operational specialists to automate and modernize our hybrid infrastructure. You will be involved with working in a wide variety of cloud and on premises computing technology in both the development and operational stages. Responsibilities: - Writing specifications and documentation - CI/CD management and automation - Work with automation services and platforms - Scripting and coding - System administration - Infrastructure management - Security, performance and availability assessment - Monitoring Experience and skills: - Over 3 years of profession experience as developer / system administrator / DevOps engineer - TCP/IP networking, firewalls, switching, and packet sniffers - Unix/Linux, Windows platform system installations, configurations, and troubleshooting - Open-source automation tools (Git, Chef, Puppet, Jenkins, Ansible, Docker, Terraform) - Cloud services (Amazon AWS, Google Cloud Platform, IBM Cloud, Microsoft Azure, Oracle Cloud Infrastructure) - Strong Virtualization experience (VMware, KVM) - Programming languages (PHP, Javascript) - Scripting languages (Bash, Powershell, Python, GO) - SQL or NoSQL databases Personal attributes: - Strong communication and leadership skills - Ability to deliver against several initiatives simultaneously - Ability to work as an individual or as part of a cross-functional team - Excellent language skills in English - oral and written Educational Requirements: - A degree or technical diploma in Computer Science, Engineering or demonstrable industry experience - Certifications in networking (NSE/CCIE/CCNP/CCSP), cloud platforms and or other relevant certifications would be highly desirable # LI-MIMI

Our client is looking for Sr. Oracle Application Administrator to manage and maintain the Globalscape Secure File Transfer Platform.Overview:You will be responsible for managing and maintaining the Globalscape Secure File Transfer platform to ensure the secure exchange of data both internally and externally. This position may also include administering other tools and utilities which work with Oracle.Must Have's:5+ years as an Application AdministratorExperience with Globalscape Secure File Transfer platformKnowledge of file transfer protocols (FTP, SFTP, HTTPS)Experience with encryption technologies (PGP, SSL, TLS)Understanding of networking protocols (TCP/IP, DNS, DHCP)Experience with Microsoft Windows Server and Active DirectoryOracle EBS technical experience in integration/development with Oracle SaaS applications i.e. HCM & Procurement will be preferable. Experience working with complex enterprise applications, preferably in an ERP environment such as Oracle e-Business Suite 12.1/12.2.Nice to Have's:Experience working with one or more of the following application technologies, tools and frameworks: APEX, OAF, Oracle Workflow, OIC (Oracle Integration Cloud), and Oracle HDL (HCM Data Loader)Bachelor's degree in computer science or related fieldResponsibilities:GlobalscapeManage and maintain the Globalscape Secure File Transfer platform.Design, implement, and support file transfer and encryption systems.Work with stakeholders to develop and implement data exchange policies and procedures.Monitor and troubleshoot file transfer and encryption systems.Perform software updates and patches following our release management process.Collaborate with other IT staff to ensure system integration and compatibility.Ensure compliance with industry standards and regulations, including SOX.Oracle Integration CloudManage the day-to-day operations of Oracle Integration Cloud.Monitor integrations for performance, errors, and availability.Perform troubleshooting and resolve issues that arise.Manage security settings and access controls for integrations. Apply

Our client is looking for Sr. Functional Consultant to work on the enhancement of Oracle E-Business Suite Financials.Overview:This position would involve collaborating with the business analysts and technical development teams to gain a deep understanding of requirements; performing functional analysis & design; and collaboratively involve themselves in producing the functional solution design, configurations, and functional specifications for building the extensions to meet the requirements following our solution delivery framework. This role will primarily oversee, configure, and design functional solutions as the functional subject matter expert in Oracle EBS Financials. The Functional Developer will provide an interactive gateway with end user groups on helping align business processes with Oracle EBS functionalities, adopt best practices and keep abreast of Oracle EBS relevant module enhancements, directions, and updates. Must Have's:5+ years as a Functional Developer5+ years as an Oracle Financials ImplementerExperience with Oracle General Ledger (GL), Subledger Accounting (SLA), Intercompany Processing, Financial Reporting, Receivables (AR), Fixed Assets (FA), Cash Management (CE), E-Business Tax (EBTAX) and Advanced Collections (IEX) Experience with software development and systems implementations Involvement in one or more major upgrades and/or module implementation projects with focus on General Ledger, Subledger Accounting, Intercompany Processing, Receivables, Fixed Assets, E-Business Tax (EBTAX), Cash Management, and Advanced CollectionsCreative problem solver with good understanding of accounting business processes. Nice to Have's:Functional experience with Oracle EBS R12.Responsibilities:Recommend Oracle EBS functionalities and capabilities to help meet new business requirements, improve existing business processes and/or address application problems. Be part of a team responsible for recommending solution designs to the business based on Oracle best practices leveraging out-of-the-box functionality and extensions, where appropriate, to address gaps. Develop impact analysis and implement strategies to manage change for large new system implementations or small functionality changes. Develop functional design documents in collaboration with developers and other analysts. Contribute to the end-to-end delivery of E-Business solutions along with developers, testers, database administrators, and application support analysts. Monitor, analyze, and advise on testing of application patches/upgrades. Configure application to meet business requirements. Work closely with developers on extensions and custom applications to translate business requirements into detailed system requirements and design. Work closely with quality assurance analysts to develop and execute appropriate test strategies/plans. Work closely with Business Analysts to understand business requirements and present/discuss technical solutions with the business. Monitor patch releases from Oracle and provide impact assessment to management. Provide post-implementation support and functional abilities to assist the Operations Teams. Apply

Position: Sr. Data Modeler to implement Oracle Fusion Analytics Warehouse (FAW) data models and schemas for a major insurance client-778Duration: 4 months with possible extensionLocation: Hybrid (Toronto or Montreal)Must haves:5+ yrs exp as a Data Modeler implementing Oracle Fusion Analytics Warehouse (FAW) PL/SQL and BI reportingFunctional understanding of Oracle Fusion Applications (ERP and EPM modules), Oracle Fusion Cloud’s Financial Management (FCFM)SQL Query and debugging expNice to haves:Oracle Fusion Financial Reporting Studio (FRS)This role will offer you the chance to: Design and implement data models and schemas to support analytical reporting requirements, reports, and dashboards, manage data model and data pipelines.Build Analytics and provide support on aspects such as data model changes and security configuration.Enable Fusion Analytics Warehouse (FAW) augmentation to support external data integration with other data platforms.Collaborate with data engineers and ETL developers to design, implement, and optimize data integration processes for loading data from various source systems into the Oracle Fusion Analytics data warehouse.Monitor and optimize the performance of the Oracle FAW, including database queries, data pipelines, and system resources. Identify and address performance bottlenecks and optimization opportunities. Requires close collaboration with Oracle product support team.Implement data modeling best practices and standards to ensure data consistency and integrity.Provide data modeling expertise and support to cross-functional teams.May prepare or review product documentation, written instructions or technical literature for accuracy and completeness.Participate in the fulfillment of ad-hoc data requests from internal business owners.Participate and guide vendor teams in implementing solutions to fit current architecture. Apply

Oracle Database AdministratorLine of Business: Capital Market, PBBT, and Retail BankingDuration: 12 MonthsRemote/Hybrid: Hybrid 3 days in office.Office Location: 81 Bay 16th Floor What project will this contractor be working on? Migration to cloud ORACLE DBAJob Description:• Manage Oracle databases through multiple product lifecycle environments, from development to mission-critical production systems.• Configure and maintain database servers and processes, including monitoring of system health and performance, to ensure high levels of performance, availability and security.• Independently analyze, solve, and correct issues in real time, providing problem resolution end-to-end.• Ensures strategic design, implementation, and documentation of current and future projects within Database environments.• Maintain technical/process documentation as required.• Perform scheduled maintenance and support release deployment activities after hours.• Ability to complete tasks and produce appropriate deliverables within project time schedules.• Identify and participate in automation opportunities.• Provide 24x7 support for critical production systems; enforce and support the change management process. Must Have Skills: - 3-10 years' experience working as an Oracle Database Administrator (DBA) - 5 years of performance tuning (DB system and SQL tuning) - 5 years' experience installing and, configuring, administering Oracle products and patches, including Oracle Standalone and RAC Databases 11g/12c/18c/19c, ASM, Oracle Clusterware, DataGuard, Active DataGuard and GoldenGate Nice To Have Skills: - 5 years' experience with Postgres - 3 years' experience with financial applications - Oracle Certified/ Performance Tuning Certification - Transparent Data Encryption experience - Oracle t-vault experience Apply

Posting Title CLK 15R - Recoveries Team Lead - amended Position Classification Clerk R15 Union GEU Work Options Hybrid Location Castlegar, BC V1N 4P5 CAKamloops, BC V2H 1B7 CAMultiple Locations, BC CA (Primary)Parksville, BC V9P 2H7 CAPrince George, BC V2N4P7 CASmithers, BC V0J 2N0 CAVictoria, BC V9B 6X2 CAWilliams Lake, BC V2G 5M1 CASalary Range As of April 7, 2024 - $59,015.56 - $66,749.47 annually $37.64 bi-weekly isolation allowance for Smithers Close Date 4/23/2024 Job Type Temporary (Auxiliary) Temporary End Date 11/2/2024 Ministry/Organization BC Public Service -> Ministry of Forests Ministry Branch / Division BC Wildfire Service Job Summary Bring your strong administrative experience and superior organizational skills to this position - amended April 22The BC Wildfire Service (BCWS) is the Province of BC's primary emergency response organization. It operates year-round to deliver its mandate for wildfire management and response to natural hazard emergencies. The BCWS operates provincially, delivering services through six fire centres, thirty-three zones and two provincial centres in Kamloops and Victoria.This position is responsible for verification and processing of financial transactions and reporting within BC Wildfire Services.Job Requirements: Secondary School graduation or equivalent Experience specific to financial analysis and reconciliation Experience in an office setting and computerized systems Experience with Microsoft Excel Preference statement(s) One (1) year of supervisory experience Two (2) years of experience in CFS Oracle AP module For questions regarding this position, please contact [email protected] .About this Position:Flexible work options are available; this position may be able to work up to 2 days at home per week subject to an approved telework agreement. Flexible work options may not be available during emergency operations response periods. This temporary opportunity starts in approximately May 2024 and ends in November 2024, with possibility of recall on a yearly basis. An eligibility list may be established to fill both current and/or future permanent vacancies. Employees of the BC Public Service must be located in BC at the time of employment.Working for the BC Public Service:The BC Public Service is committed to creating a diverse workplace to represent the population we serve and to better meet the needs of our citizens. Consider joining our team and being part of an innovative, inclusive and rewarding workplace.The Indigenous Applicant Advisory Service is available to applicants that self-identify as Indigenous (First Nations, status or non-status, Métis, or Inuit) seeking work or already employed in the BC Public Service. For guidance on applying and interviewing, please contact [email protected] or 778-405-3452.This is your opportunity to live in one of the most beautiful regions in British Columbia and work for the BC Public Service. We offer a healthy work/life balance, excellent benefits and much more . How to Apply:Your application must clearly demonstrate how you meet the job requirements listed above.Cover Letter: NO - Please do not submit a cover letter as it will not be reviewed.Resume: YES - A resume is required as part of your application, however, it may not be used for initial shortlisting purposes.Questionnaire: YES - You will need to complete a comprehensive questionnaire to demonstrate how you meet the job requirements. Include all relevant information about your educational accomplishments and employment history including job titles, start and end dates (month and year) of your employment, and how you obtained your relevant experience. The questionnaire will take approximately 60 minutes to complete.Helpful tips, videos and more regarding the application process can be found on the Your Job Application page of MyHR. If you are experiencing technical difficulty applying, e-mail [email protected] , before the stated closing time, and we will respond as soon as possible.Additional Information:A Criminal Record Check (CRC) will be required.Applicants selected to move forward in the hiring process may be assessed on the Knowledge, Skills, Abilities and Competencies as outlined in the attached Job Profile located at the bottom of the posting.Applications will be accepted until 11:00 pm Pacific Standard Time on the closing date of the competition.Job Category Administrative Services

Location: Help Headquarters Job Type: Full Time myWork Options: Hybrid or Remote Background Screening Requirement: Enhanced Criminal Record Check (every 5 years) Credit Check (every 5 years) Identity Verification Education Verification Employment Verification References What's the job? Are you looking to apply your expertise to drive the growth for one of the Canada's best managed and BC's top employer companies? Then you are in the right place. The Database Administrator (DBA) is responsible for the overall management and maintenance of information databases used to operate the infrastructure and technology platform. The DBA will collaborate with technical and business user groups to ensure that databases are performing optimally, and service level agreements set by the enterprise are adhered to. What you'll get to do: Collaborate with development, architecture, and infrastructure teams to design data management and governance protocols, manage the information lifecycle, design infrastructure and data integration controls. Understands business strategy and cascades business intelligence needs to the database level. Plan, design, configure, implement, and administer all databases for the respective parties involved. Develop and maintain complex models and logical database designs. Identify and resolve all issues related to database systems to ensure that systems are online and without service interruption. Build and manage the database disaster recovery and backup plan. Develop new and enhance existing database standards, processes, procedures, and guidelines. Analyze and report the performance of database operations against the key database performance metrics. Meet performance standards in accordance with service level agreements set by the company. Who are we looking for? Minimum 5 years' experience in Database Administration. University degree, diploma or certificate in IT or a related field. Proficient with relational and non-relational databases and in-depth knowledge of database coding for various platforms (e.g. Oracle, SQL Server, MySQL, Mongo DB). Experience in designing and implementing database structures and automating DBA tasks. Experience with data modeling and schema design. Strong analytical, problem solving and prioritization skills. Strong attention to detail with an ability to anticipate risks and mitigate it. Adept at managing multiple deadlines and shifting priorities. Advanced communication skills: ability to facilitate discussions and communicate technical concepts and recommendations to non-technical staff. Equity, Diversity & Inclusion at Coast Capital Don't meet every single requirement? At Coast Capital, we believe everyone has potential. We are committed to building better, brighter, more inclusive futures for everyone - including our employees. We see the potential in our employees to achieve amazing things and want to invest in your future. If you're excited about this career opportunity and your experience may not perfectly align with every qualification in this job posting, we still encourage you to apply. You may be just the right candidate for this or other opportunities at Coast Capital. At Coast Capital, we are committed to equity, diversity and inclusion. We strongly encourage applications from Indigenous Peoples, Black, and racialized persons, persons with disabilities, people of diverse sexual and gender identities and women. We value applicants who have demonstrated a commitment to equity, diversity and inclusion and recognize that diverse perspectives, experiences and expertise benefit of our employees, our members, and our community. We strive to provide an accessible candidate experience for our candidates with different abilities. If you require any accommodations, please contact [email protected] or call 778-391-5836. We will work with you to meet your needs. Why join Coast Capital Savings? Purpose is our North Star. We look at everything through our purpose. It informs the advice we provide our members, the experiences and products we create, and the programs we build to support our employees and communities. Committed to inclusion and engagement. We have an ongoing focus on equity, diversity, and inclusion and routinely track how we're doing, and what we need to do to keep improving. We foster a culture where everyone can feel safe to be who they really are and thrive. A career that grows with you. We believe in developing our people and promoting from within. Many employees have spent decades, and sometimes their entire careers, with Coast Capital and have progressed from the frontlines to senior leadership. Work where you're most effective. In 2020 the world changed, and that includes how we work. In response to COVID-19 we launched myWork, which gives employees flexibility in where they work based on the nature of their role. Benefits that flex to the needs of you and your family. We offer comprehensive, customizable benefits for you and your family, so you can choose what fits best for you and your lifestyle. Retirement options. We also take care of our employees once they retire. That's why we offer the choice of a defined contribution or defined benefit pension plan or RSP's. Mortgage and auto financing benefits. Employees save thousands on their mortgages and auto loans with best-in-category benefits. Real Recognition. We recognize excellence throughout the year, through an online community that lets employees give kudos and thanks throughout the year. We're human, which means we like to have fun with events, celebrations, and recognition throughout the year. An award winning culture. We're a Platinum member of Canada's Best Managed Companies and are regularly recognized by Canada's Most Admired Corporate Cultures and the BC Top Employers Awards. We reinvest 10% back into the community. When we do well, our communities do well. That's why since 2000 we've invested over $90 million into our member's communities. Double your impact. Through our employee volunteer program, Coast Capital donates $10 for every hour you volunteer to a Canadian charity or non-profit of your choice. D&I at Coast At Coast Capital, we value diversity, equity and inclusion. We're not all the same and we like it that way. We don't just accept differences - we celebrate, support, and we thrive on them for the benefit of our employees, our members, and our community. We are committed to building a team that represents a variety of backgrounds, perspectives, and skills.

Are you a seasoned Data Cloud expert with a passion for managing dynamic and modern data-intensive applications? We're seeking a highly skilled and motivated senior snowflake database developer to join our talented team. In this role, you'll play a pivotal part in optimizing our data infrastructure, ensuring scalability, and fostering a data-driven culture within our organization. The data platform is the foundation to any AI platform and it enables teams and customers to self-serve via data models and real-time streams. A self-serve approach and domain-focused management of analytical data is crucial to continue to scale our operations. Applying the data mesh architecture model, we empower individual domain teams to conduct their own cross-domain data analysis and reporting and establish connections between data domains. What makes this opportunity exciting? Our team has built a reliable, efficient and scalable data processing pipeline sitting on top of Snowflake. With our large list of customers and use-cases, our data volumes increase and our processes are more complex. To stay ahead of the game, we are looking for a Snowflake expert that can help us manage our Snowflake instances and integrate Snowflake features and capabilities into our environments. In this role, you will be expected to:  Design, implement, and manage the Snowflake Data Cloud environment to support our SaaS platform and ML operations at scale. Collaborate with cross-functional teams to understand data requirements and implement efficient solutions. Optimize and tune database performance to ensure high availability and responsiveness. Develop and enforce data security best practices, ensuring the integrity and confidentiality of our data. Provide technical leadership and mentorship to junior team members. Stay current with industry trends and emerging technologies, contributing to the continuous improvement of our data architecture. Here is what will qualify you for the role Proven experience as a Snowflake Data Cloud Administrator or in a similar data cloud infrastructure role.  Good understanding of Cloud, CI/CD and DevOps and you’re familiar with cloud services, like KMS key, VPC/VPN, SSO, AWS S3, AWS SNS, or Terraform. Experience with modern data-intensive applications and a solid understanding of data modeling and architecture principles. What will make you stand out Excellent problem-solving skills and the ability to work in a fast-paced, collaborative R&D environment. Strong technical leadership capabilities and a get things done attitude Do you want to take on this challenge? Send us your CV, we want to get to know you! You don’t need to check every single box; passion goes a long way and we appreciate that skillsets are transferable.Join the #Coveolife!  We encourage all qualified candidates to apply regardless of, for example, age, gender, disability, gaps in CV, national or ethnic background. We know that applying for a new role is a lot of work and we really appreciate your time.

We help the world run better At SAP, we enable you to bring out your best. Our company culture is focused on collaboration and a shared passion to help the world run better. How? We focus every day on building the foundation for tomorrow and creating a workplace that embraces differences, values flexibility, and is aligned to our purpose-driven and future-focused work. We offer a highly collaborative, caring team environment with a strong focus on learning and development, recognition for your individual contributions, and a variety of benefit options for you to choose from. About the SAP Internship Experience Program The SAP Internship Experience Program is SAP's global, strategic, paid internship program that provides university students with opportunities to find purpose in their careers. Three reasons to intern at SAP Culture of collaboration:meet with mentors, make new friends across the globe and create a thriving personal network. Project-driven experience:gain cross-functional skills from our virtual and in-person learning sessions, diverse subject matter experts, and project deliverables. Gain visibility:with SAP Internship Experience Program in your title, you'll have a global network of SAP leaders, entrepreneurs and career development opportunities at your fingertips. What you'll do Position Title:SAP iXp Intern - Technical Support, Support Associate for SAP MDG Location: Toronto Expected Start Date: July 2024 Internship Duration: 8 months Experience what a day in a life of an SAP iXp intern looks like: You get know business processes and transactions in the area of SAP Master Data Governance applications in On-Premise & Cloud environments Engaging with customers by utilizing real-time channels like SAP Expert Chat and tools to support them in this area Analyzing cases, perform in-depth troubleshooting to identify and solve complex technical and business issues Collaboration with fellow support colleagues and other internal organizations to provide superior customer service What you bring We're looking for someone who takes initiative, perseveres, and stay curious. You like to work on meaningful innovative projects and are energized by lifelong learning. Required Excellent English communication skills (written and oral) Excellent diagnostic and technical analysis skills Ability to work in teams of multicultural nature Growth Mindset Fast learner with IT affinity Ability to assess, plan and troubleshoot while collecting information about the customer issue At least one of the following subject matter knowledge is desired Databases (SAP HANA, Oracle, DB2, SQL Server, SQL Anywhere, ASE, MySQL, etc.) Operating systems (Windows Server, Linux, AIX, etc.) Object-oriented programming (Java, C++, ABAP, etc.) and programming logic SAP Products & Solutions (SAP NetWeaver, SAP Business Suite, etc.) Meet your team We are a Global Team located across regions in Toronto (Canada), Dublin (Ireland), Budapest (Hungary) & Dalian(China) and work as ONE team. We are highly skilled, collaborative, professional and fun to work with. Bring out your best SAP innovations help more than four hundred thousand customers worldwide work together more efficiently and use business insight more effectively. Originally known for leadership in enterprise resource planning (ERP) software, SAP has evolved to become a market leader in end-to-end business application software and related services for database, analytics, intelligent technologies, and experience management. As a cloud company with two hundred million users and more than one hundred thousand employees worldwide, we are purpose-driven and future-focused, with a highly collaborative team ethic and commitment to personal development. Whether connecting global industries, people, or platforms, we help ensure every challenge gets the solution it deserves. At SAP, you can bring out your best. We win with inclusion SAP's culture of inclusion, focus on health and well-being, and flexible working models help ensure that everyone - regardless of background - feels included and can run at their best. At SAP, we believe we are made stronger by the unique capabilities and qualities that each person brings to our company, and we invest in our employees to inspire confidence and help everyone realize their full potential. We ultimately believe in unleashing all talent and creating a better and more equitable world. SAP is proud to be an equal opportunity workplace and is an affirmative action employer. We are committed to the values of Equal Employment Opportunity and provide accessibility accommodations to applicants with physical and/or mental disabilities. If you are interested in applying for employment with SAP and are in need of accommodation or special assistance to navigate our website or to complete your application, please send an e-mail with your request to Recruiting Operations Team: [email protected]. For SAP employees: Only permanent roles are eligible for the SAP Employee Referral Program, according to the eligibility rules set in the SAP Referral Policy. Specific conditions may apply for roles in Vocational Training. EOE AA M/F/Vet/Disability: Qualified applicants will receive consideration for employment without regard to their age, race, religion, national origin, ethnicity, age, gender (including pregnancy, childbirth, et al), sexual orientation, gender identity or expression, protected veteran status, or disability. SAP believes the value of pay transparency contributes towards an honest and supportive culture and is a significant step toward demonstrating SAP's commitment to pay equity. SAP provides the hourly base salary rate range applicable for the posted role. The targeted range for this position is 18.00 - 35.00 CAD. The actual amount to be offered to the successful candidates will be within that range, dependent upon the key aspects of each case which may include education, skills, experience, scope of the role, location, etc. as determined through the selection process. SAP offers limited benefits for employees hired into hourly or like roles subject to appliable plan/policy terms. A summary of benefits and eligibility requirements can be found by clicking this link: www.SAPNorthAmericaBenefits.com Requisition ID: 393721 | Work Area: Information Technology | Expected Travel: 0 - 10% | Career Status: Student | Employment Type: Intern | Additional Locations: #LI-Hybrid Requisition ID: 393721 Posted Date: Apr 23, 2024 Work Area: Information Technology Career Status: Student Employment Type: Intern Expected Travel: 0 - 10% Location: Toronto, ON, CA, M5K 1B7

Sr. Oracle JD Edwards Administrator to install, configure, upgrade, and manage Oracle JD Edwards ERP for our public sector client. Location: Ajax, Ontario (Hybrid 1-2 days per week on-site)Duration: 1 year (possibility of extension)Responsibilities of a CNC in JD Edwards ERPInstallation and ConfigurationInstalling and configuring Deployment ServerApply planner ESUExecute special instructionsInstalling and configuring Enterprise ServerInstalling and configuring Web ServerSetup JAS/HTML Server instances on Web ServerSetup BSSV Server instances on Web ServerSetup AIS Server instance(s) on Web ServerServer Manager installation and configurationServer Manager Agent installations and configurationsCreate and run installation planPost installation, log analysis and surface testingUpgrade ActivitiesPerform application release upgradePerform tools release upgradeNormal upgradeMulti foundation upgradeUpgrading different environmentsSurface testing of upgraded instancePromotion and testing of objects in upgraded ERPUser/Role ManagementCreation of user IDsCreation of test and production rolesAssigning environments to rolesAssigning roles to usersPassword reset for user IDsManagement of users and rolesSetup role sequencingSecurity ManagementSetup security for different roles i.e. test and production rolesConfiguring different types of securities such as application, action, row, column, etc.Promoting security changes from test to productionSynchronizing test and production rolesIdentify security conflicts and resolve themImplementing SOD based on the provided requirementObject Management ConfigurationSetup and define status flows for object promotionConfiguring roles for status changeSetup transfer activity rules (from-to status)Setup allowed actions (related to objects and OMW roles)Package ManagementBuild and deploy full packagesBuild and deploy update packagesBackup objects to a different pathcode or as PAR filesExecute special instructions like table/index generation, backup, generate & restore tables, etc.Change ManagementOMW project promotion to promote regular and ESU changesPromoting retrofitted objects to custom pathcodeToken managementProject demotionOMW logging and trackingMenu (Task View) ManagementMenu/task view creation and deletionSetup role based menu filteringPromoting tasks and task views from one environment to anotherPromoting/synchronizing menu filtering between test and production rolesJob SchedulingImplement JDE or third party schedulerCreate job schedulesDeactivate unused job schedulesPurging scheduler job recordsHold and release job schedules based on requirementStopping/starting scheduler (mostly before/after downtime)Web Client ManagementSetup a web client/fat client which involves database and JDE setup on a windows server machinePackage installation (deployment) on different web clientsEnabling different types of logging on a fat clientLog managementTroubleshooting fat client related issuesESU/ASU ManagementInstallation of ESUs or paper fixesImplementation of POCs, if any, obtained from OraclePerform impact analysisIdentify and execute, pre and post installation tasksObject promotion related to ESUPackage management related to ESUData Source Management and Object Configuration MappingsSetup new data sourcesSetup connection settings (for e.g. tnsnames.ora)OCM configurationCustom pathcode and environmentCreating custom pathcodes and environmentsDefining and configuring custom data sourcesOCM configuration and setupSurface testing of the pathcode and environmentAssigning environment to roles and management of the sameDefining tablespaces and schemasDefining process for environment refreshCarrying out environment refresh/coordinating with DBAsJob Queue SetupsCreate and modify single and multithreaded job queuesAssociating job queues to ports and serversHold and release job queues based on requirementPrinter SetupsCo-ordinate with network team/carry out printer setups on enterprise serversSetup printer definitions in JDEDefining and configuring default printer based on user/role/host/reportTesting printer setupInfrastructure SetupsAdmin ID setup on various nodesNetwork access setup (or coordinating with network team)Firewall openings for ports (or coordinating with network team)Installation of mandatory softwares on different nodesMonitoring ActivitiesMonitoring CPU, Disk I/O and memory usage on different nodesMonitoring overall system healthMonitoring HTML, AIS, BSSV server instancesMonitoring various kernelsMonitoring database for resource extensive queries and table locksMaintenance ActivitiesService restarts for enterprise serversService restarts for web components like JAS, AIS and BSSV instancesClearing stale logs for enterprise servers and web componentsDisk space management on different nodesPurging scheduler records, work center messages, etc. Apply