SAM- Software Asset Management

Required Qualifications:

• Prior Experience in ServiceNow development and administration in an enterprise environment.
• Ability to configure, develop, and implement functionality within ServiceNow.
• ServiceNow System Developer, Administrator Certification.
• Ability to relate to software engineering challenges and practices.

Preferred Education/Experience:

• Education: BS degree in Computer Science or Engineering or equivalent on the job, hands-on experience.
• Minimum of 4+ years of overall IT experience, with a practical understanding of various technologies and processes such as operations systems, storage, networking, monitoring, and discovery.
• Experience delivering automated solutions and impl12ementation of highly scalable, highly available services.
• Other ServiceNow Micro Certifications.

smartShift Technologies is looking for a seasoned Database Administrator - Oracle to join our Bangalore team.

 Responsibilities

• Perform regular Database administration tasks.
• Perform HA and DR setup maintenance tasks
• Analyze the performance metrics and provide tuning recommendations
• Analyze the repetitive support requests and provide the automation feasibility
• Handle incidents and problems
• Perform trend analysis of the incidents/events and help in finding the resolution

 Skills & Experience

• Strong experience in Database Administration  in Oracle database 
• Have strong knowledge on Oracle SQL and PL/SQL 
• Expertise in writing and analysing Stored procedure , packages and triggers. 
• Exposure to AWS Cloud RDS is required
• Experience in Database Patching/Upgrade/Migrations
• Experience in managing the HA and DR setups ( Standby, DataGuard)
• Experience in performance tuning ,query optimisation
• Experience with client interaction is preferred
• Exposure to other MySQL database is preferred
• Excellent written and verbal communication skills. 
• Real time experience in DB administration (Installation/Tablespace Management/Object Management
• Expertise in RMAN and other backup(Expdp/Impdp) methodology implementations
• Experience in Database Patching/Upgrade/Migrations
• Knowledge on GoldenGate is desirable
• Knowledge on Oracle 12C/19C new features
• Experience with client interaction is preferred
• Knowledge on RAC & ASM is desirable
• Exposure to AWS Cloud is desirable
• Excellent written and verbal communication skills

1.           4-6 years experience as oracle apps technical consultant (techno functional is preferred )

2.           should have worked on interfaces , OAF, form personalization’s ,workflow builder, oracle reports and xml publisher...

3.           Should have good understanding of Order to cash and Procure to pay technical flow of Ebiz

4.           should have worked on 2-3  implementation projects and have strong technical knowledge

5.           Strong in Pl/sql , Unix and worked on custom solutions

6.           Able to provide  technical solutions

7.           Good communication skills

REQUIRED SKILLS

• 2+ years of experience with ServiceNow ITSM, ITBM
• Experience in creating, updating, and maintaining CMDBs, Asset Management Databases, and other asset/configuration management repositories in a complex environment
• Experience in identifying and tracking CIs, implementing change control, and accounting for discovered/manual CIs in a complex system.
• Open to work on different modules. Knowledge of additional modules is preferred

IN THIS ROLE, YOU WILL HAVE THE OPPORTUNITY TO:

• Design and implementation of a solution for maintaining CI data integrity across the CI lifecycle with due consideration to the ITSM process like Incident, Problem, and Change.
• Managing CMDB health to support Assets and Configuration and CI relationships, as coming from discovered sources, manual sources from like relationship data from network team.
• Reconcile solution of the CMDB data when exceptions are noted between CMDB, discovery information, and other authoritative production data repositories.
• Work with process owners to understand the process requirements related to the capture of configuration data and develop technical specifications and solutions
• Work closely with various stakeholders to provide guidance in the management of CI’s and the relationships between them
• Collaborate with Infrastructure Architects to understand IT technology strategy that guide which requirements need to be gathered
• Work with Application SMEs and stakeholders to perform gap analysis and provide solutions.

GOOD TO HAVE
• ServiceNow Certified System Administration

Roles and Responsibilities:

• Installation, configuration and upgrading of Oracle server software and related products.
• Establish and maintain sound backup and recovery policies and procedures.
• Take care of the Database design and implementation, including Patch Management and Version Control. Implement and maintain database security (create and maintain users and roles, assign privileges).
• Perform database/application tuning and performance monitoring.
• Setup and maintain documentation and standards.
• Plan growth and changes (capacity planning).
• Work as part of a team and provide 24x7 support when required.
• Perform general technical troubleshooting and give consultation to development teams.
• Interface with Oracle Corporation for technical support.
• Analyse potential impact of problem resolution and take corrective measures when needed.
• Root Cause Analysis.

Education, Skills and Experience required:

• Engineering or Technical Degrees (BE/ B.Tech/ ME/ M.Tech/ M.Sc / MCA)
• Minimum 4 years of relevant industry experience.
• Must have experience on multiple Hardware and Software Environments and be comfortable with complex heterogeneous systems environments.
• Must be an Oracle Certified Professional DBA (11g or above) with hands-on experience of RAC, RMAN.
• Good understanding of the Oracle database, related utilities and tools and underlying operating system.
• Excellent knowledge of the physical database design and all Oracle backup and recovery scenarios.
• Developing, managing and testing back-up and recovery plans. Data archival and space management.
• Ability to perform both Oracle and operating system performance tuning and monitoring.
• Good knowledge of Oracle security management and Oracle data integrity.
• Experience in code/data migration, database change management and data management through the various stages of the development life cycle.
• Sound knowledge of both database and system performance tuning and implemented application systems.
• Should have the ability to handle multiple projects and deadlines.
• Male candidates preferred as the role requires working in shifts.