Oracle Database Administrator (Dba)

Viavi Solutions San Jose , CA 95111

Posted 5 months ago

VIAVI (NASDAQ: VIAV) has a 90 year history of technical innovations that have evolved to keep pace and address our customer's most pressing business issues. We make equipment, software, and systems that help to plan, deploy, certify, monitor, and optimize all kinds of networks - like those for mobile phones, service providers, large businesses and data centers. And, we are also at the forefront of optical security we bend light to develop and deliver optical solutions that provide security to the world's currencies and safety and performance applications for consumer electronics and spectrometry.

We are the people behind the products that help keep the world connected at home, school, work, at play, and everywhere in between. VIAVI employees are fierce about supporting customer success and we welcome people who bring their best every day to the company - to question, to collaborate and to push for solutions that will delight our customers.

Oracle Application Database Administrator

Oracle Application database administrator will provide operational support for Oracle Applications and EBS boundary application systems in production and non-production environments.

Duties & Responsibilities:

  • Provide operational support for the organization's Global Oracle E-Business Suite ERP applications including production support and project support

  • Work with the US and India based teams to manage regularly scheduled clones of ERP, other supporting environments

  • Provide production support for Oracle Applications 11i/12c and development instances and day-to-day operations: AD utilities, Concurrent Managers and Processes, setting up and diagnosing printing issues, stopping and starting of application and configuration, Oracle workflows, forms server, apacheetc

  • Perform database and ERP tech stack upgrades and evaluating/testing/applying appropriate quarterly cumulative patch updates (CPU)

  • Managing a 7x24 Production support environment, on-call support, including coordinating and managing maintenance activities

  • Responsibilities include troubleshooting, recovery, tuning of the database, software installation, resolving Oracle errors and failures, auditing activities, and resource utilization. Also responsible for service level availability for all production and non-production Oracle environments

  • Responsible for managing and providing support for periodical external and internal audit activities

  • Administer web servers to support external applications running WebLogic and Apache

  • Configure Oracle API gateways to support external applications

  • Perform deployment and administration of Microsoft Dynamics 365 Customer Engagement

  • Work in day shifts during week days and weekends, and open to night shifts when required

Skills & Experience:

  • Required:

o 4 to 6 years of experience with Oracle database administration activities

o 4 to 6 years of experience working with Oracle Applications 11i database and application administration

o Extensive knowledge of underlying Oracle Applications database architectures and concepts

o Experience in installing, configuration and administration of Oracle SOA environments

o Extensive knowledge and experience in RMAN, Oracle Single-Sign-On, OID,OIM and Shared Appltop

o Installation, configuration and administration of Oracle Grid Control (OEM) 11g or 12c

o Knowledge of cloning Operations for Oracle Apps EBS including pre/post and rapid clone and other advanced options

o Experience with patching operations for Oracle Apps including analysis of patches, patching including maintenance packs, post patch testing and validations, similar experience in supporting is essential

o Experience with performance tuning of both Application Tier and Database Tier, process and query optimization, troubleshooting of locking issues, monitoring of resource contention, analysis of queries, log files, trace files etc will be highly valued

o Experience managing a 7x24 Production support environment, and on-call support, including coordinating and messaging required for maintenance windows

o Experience in applying HR patches

o Experience in configuring and maintaining physical and logical standby environments

o Experience in performing Disaster Recovery Drills

o Good exposure to managing and coordinating activities with Infrastructure team

o Proficient in change management process and utilization of incident/issue management tools, code promotion

o High proficiency working with Linux/AIX operating systems, shell scripting, and cron job

o Performance tuning skills, database as well as SQL & PL/SQL tuning (wait events, tkprof)

o Skills with the ability to communicate complex technical solutions with different technical as well as functional groups

o Prior support experience in a worldwide user based environment is must

o Good verbal and written communication skills

o Self-starter with solid interpersonal skills and ability to learn new technologies quickly is critical

o Ability to work under pressure and easily adapt to ever changing environment

o Must be a US Citizen or Permanent Resident

  • Preferred:

o Experience with MarkView and Sabrix applications

o Oracle 10g/11g/12c certification

o Exposure to Service Now, JIRA Service Desk and JIRA Software ticketing systems

o Exposure to OBIEE and Informatica Administration

o Knowledge of Microsoft Dynamics 365 Customer Engagement Deployments and Administration

o Knowledge of Microsoft SQL Server Administration

o Background in Enterprise Application Development

If you have what it takes to push boundaries and seize opportunities, apply to join our team today.

VIAVI Solutions is an equal opportunity and affirmative action employer minorities/females/veterans/persons with disabilities.

icon no score

See how you match
to the job

Find your dream job anywhere
with the LiveCareer app.
Mobile App Icon
Download the
LiveCareer app and find
your dream job anywhere
App Store Icon Google Play Icon

Boost your job search productivity with our
free Chrome Extension!

lc_apply_tool GET EXTENSION

Similar Jobs

Want to see jobs matched to your resume? Upload One Now! Remove
Sr Database Administrator

Sage Intacct

Posted Yesterday

VIEW JOBS 10/15/2019 12:00:00 AM 2020-01-13T00:00 The Sr. Database Administrator manages our ever growing farm of production databases and other technologies that are essential to the operation of Sage Intacct's cloud service. Work closely with operations engineers and application developers to ensure database integrity, availability, and performance. Responsibilities: * Configure and maintain Oracle database servers * Participate in the team's 24x7 on call rotation and provide occasional off-hours support when required * Design and execute overall database architecture strategy, standards and practices as part of a team. * Proactively identify areas for optimization and troubleshoot database performance issues * Work closely with Application Development team to ensure database changes adhere to best practices and are properly prioritized and scheduled. * Develop and optimize complex SQL and PLSQL code * Manage database schema maintenance and migrations * Improve service availability and scalability through tuning, automation, tools, and process * Administer different technologies and tools like MongoDB, Postgres DB, AWS, QlikSense, OBIEE * Implement and maintain database backup and recovery, disaster recovery procedures Requirements: * Bachelor's degree in Computer Science, Engineering, or related field * 10+ years of Oracle database administration experience * Oracle administration skills, preferably in a Linux/UNIX environment * Understanding of backup and recovery concepts and Oracle RMAN * Good knowledge of Oracle Data Guard implementation and support * Ability to analyze and optimize complex SQL queries and PLSQL code * Experience administering MongoDB, Amazon Web Services (AWS) * Use EM, Confio Ignite, Toad and other tools to identify areas for optimization * Ability to produce quality work on tight schedules * Ability to solve problems, make sound decisions and use good judgement * Must be able to provide 24x7 on-call support on rotation schedule * Understanding of software development processes and ability to work well with the development team * Good written and oracle communication skills * Familiarity with administering OBIEE, QlikSense or ElasticSearch is a plus Sage Intacct San Jose CA

Oracle Database Administrator (Dba)

Viavi Solutions