Architect, Applications and Database Administrator

Location: 

Chennai, Tamilnadu, IN

pSemi Corporation is a Murata company driving semiconductor integration. pSemi builds on Peregrine Semiconductor’s 30-year legacy of technology advancements and strong IP portfolio but with a new mission—to enhance Murata’s world-class capabilities with high-performance semiconductors. With a strong foundation in RF integration, pSemi’s product portfolio now spans power management, connected sensors, optical transceivers, antenna tuning and RF frontends. These intelligent and efficient semiconductors enable advanced modules for smartphones, base stations, personal computers, electric vehicles, data centers, IoT devices and healthcare. From headquarters in San Diego and offices around the world, pSemi’s team explores new ways to make electronics for the connected world smaller, thinner, faster and better.
 

This position is located in our India Design Center in Chennai, India

 

Job Summary

The Database Administrator / Applications Architect installs, design, develops, administers, upgrades, maintains and supports multiple Oracle database systems/applications; deploys customizations & packages, load data, and define and implement backup and recovery strategies; engages in performance tuning, data migration and business process analysis; troubleshoot, analyze & resolve database and application service issues. Duties also includes modifying programming systems including coding, testing, debugging and installing to support business and business intelligence applications as well as  engineering analysis systems.  The Database Administrator / Applications Architect consults with users to identify current operating procedures and to clarify program objectives and creates programs to solve business problems and support automation relying on extensive experience and judgment to plan and accomplish goals.   

 

Roles & Responsibilities

This position has responsibility for:

  • Implement backup and recovery strategies; engages in performance tuning, data migration and business process analysis; troubleshoot, analyze & resolve database and application service issues.
  • Modifying programming systems including coding, testing, debugging and installing to support business and business intelligence applications as well as engineering analysis systems. Administers, maintains, develops and implements policies and procedures for ensuring the security and integrity of the company database and ERP systems.
  • Implements data models and database designs, data access and table maintenance codes; resolves database performance issues, database capacity issues, replication, and other distributed data issues.
  • Plan and coordinate data migrations and integrations between systems.  Write code to achieve desired result.
  • Develop, implement, and maintain change control and testing processes for modifications to databases and applications.
  • Defines the technical architecture for custom and packaged-based Oracle Supply Chain applications (full order to cash cycles), Oracle Financials, and Supply Chain Planning. Creates comprehensive solutions which consider our entire technical landscape.
  • Develop and support application integration initiatives between pSemi, Murata, contract manufacturers and other partners.
  • Responsible for software development life cycle, relational databases (Oracle, SQL-Server, etc.), Workflow, concurrent manager, alert, systems administration and how they work
  • Work towards understanding and modifying operating interrelationships between the Datapower business applications and user / business processes.   
  • Develop reports and alerts for improving overall system management and improving overall system uptime. 
  • Suggest designs to meet network, database system requirements and selecting alternative measures to develop better security technologies.
  • Performs a variety of complicated tasks including those associated with application programming.

 

Competency Requirements

In order to perform the job successfully, an individual should demonstrate the following competencies:

  • Critical Thinking: Skilled at finding logical flaws in arguments and plans; identifies problems and solutions that others might miss; provides detailed insight and constructive criticism into problems and complex situations
  • Display Technical Expertise: Keeps his/her technical skills current; effectively applies specialized knowledge and skills to perform work tasks; understands and masters the technical skills, knowledge, and tasks associated with his/her job; shares technical expertise with others
  • Prioritizing and Organizing Work: Allocates time and attention based on what is the most important to achieve key goals and objectives; approaches work in an organized and systematic manner; effectively manages tasks, information, and requests
  • Solving Complex Problems: Breaks down large problems into smaller, more manageable components; identifies key factors that influence the viability of different solutions; clarifies information needed to solve problems
  • Working with Ambiguity: Achieves forward progress in the face of poorly defined situations and/or unclear goals; able to work effectively with limited or partial information

 

Minimum Qualifications (Experience and Skills)

  • 10+ years of professional experience working with Oracle e-business suite of which at least 2 years in release 12.x
  • 5+ years of experience in systems integration tools and methodology
  • 2 year of full cycle ERP Implementations experience
  • Experience working in a complex customized Oracle e-business suite implementation
  • 7+ years of experience with PL/SQL, forms 10.x, reports 10.x, XML Publisher, OA Framework,  workflow builder development skills
  • Strong technical experience developing and debugging Oracle workflows (PO, HRSS)
  • Experience with conducting fit/gap analysis, design, configuration and testing
  • Oracle EBS with Cloud or other SOA integration experience
  • Experience working with and leading business and IT team members
  • Strong collaboration skills; Experience working in a production support team
  • Toad, Unix Shell Script, Sun Solaris and Linux
  • Exceptional problem solving and project management skills
  • Strong technical understanding of the Oracle Applications data model.
  • Ability to provide on call support and resolve high priority incidents
  • Ability to capture business requirements and end to end business processes

 

Preferred Qualifications

  • 3+ years of experience in supporting semiconductor industry
  • Exposure to Talend Integration tools

 

Education Requirements

  • Bachelor's degree in Engineering; Master's degree in Computer Applications/Science or Information Systems preferred

 

Work Environment

This job operates in a professional office environment. This role routinely uses standard office equipment.

 

Physical Demands

The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. While performing the duties of this job, the employee is regularly required to talk or hear. The employee frequently is required to stand; walk; use hands to finger, handle or feel; and reach with hands and arms. Specific vision abilities required by this job include close vision, distance vision, color vision, peripheral vision, depth perception and ability to adjust focus. This position requires the ability to occasionally lift office products and supplies, up to 20 pounds.


pSemi Corporation supports a diverse workforce and is committed to a policy of equal employment opportunity for applicants and employees. pSemi does not discriminate on the basis of age, race, color, religion (including religious dress and grooming practices), sex/gender (including pregnancy, childbirth, or related medical conditions or breastfeeding), gender identity, gender expression, genetic information, national origin (including language use restrictions and possession of a driver’s license issued under Vehicle Code section 12801.9), ancestry, physical or mental disability, legally-protected medical condition, military or veteran status (including “protected veterans” under applicable affirmative action laws), marital status, sexual orientation, or any other basis protected by local, state or federal laws applicable to the Company. pSemi also prohibits discrimination based on the perception that an employee or applicant has any of those characteristics, or is associated with a person who has or is perceived as having any of those characteristics.

Note: The Peregrine Semiconductor name, Peregrine Semiconductor logo and UltraCMOS are registered trademarks and the pSemi name, pSemi logo, HaRP and DuNE are trademarks of pSemi Corporation in the U.S. and other countries. All other trademarks are the property of their respective companies. pSemi products are protected under one or more of the following U.S. Patents: http://patents.psemi.com