Database Administrator 3-IT

  • Company:
  • Location:
  • Salary:
    negotiable / month
  • Job type:
  • Posted:
    4 weeks ago
  • Category:
    Software Services | IT-Software

Skill: information technology , dbms , oss , java , shell scripting , python , oracle , sybase , tuxedo , it , application support , unix , websphere , oracle application; Exp: 5-8 years; Database Administrator 3-IT-18000QLH Preferred Qualifications Department Description PeopleSoft Environment Operations International provides essential PeopleSoft Enterprise Environments and application support to the Quality Assurance (QAE), PeopleSoft Enterprise Development (Dev) teams and Oracle Support Center(OSS). Our environments are utilized within Oracle around the globe India, JAPAC, EMEA, and Americas. QAEDevOSS support is provided for New Development, Support Development (SD), Post release development (PRD) and Release Test (RT) release. The environment consists of the entire PeopleSoft tech stack and includes various 3rd party products, Oracle middleware, Mail and LDAP servers, application servers, web servers, process schedulers, and databases. The database environments are built primarily on Oracle, DB2/Unix, DB2/OS390, Informix, MS SQLServer, and Sybase across various OS platforms such as Windows, AIX, Solaris, Linux, and HP-UX. Brief Posting Description Administration and working on Automation of PeopleSoft Enterprise applications for internal customers primarily using Oracle on Windows, Linux, and UNIX. This position will provide the right candidate with opportunities to work with the latest technologies used by the PeopleSoft application. Some of the responsibilities will include as mentioned below Working on a highly automated peoplesoft environment like DEP/ASOD/EMS. Create and manage PeopleSoft database environments both Unicode and non-Unicode on Oracle, DB2/Unix, DB2/OS390 platforms Install Application, Web, Proxy and PeopleSoft gateway servers. Install, integrate, and troubleshoot third party and Oracle products with PeopleSoft applications on Windows, Linux, and Unix platforms. Work with development to troubleshoot application and database issues. Manage server applications, tune databases, and createmodify batchshell script Adapt various internal automation tools to build, manage and run PeopleSoft Enterprise applications for DEV & QAE Monitor database environments and servers through OEM/DEVCC. Knowledge of Python, Pearl, the frontrunner, java scripting,jsp, shell scripting and other automation language is a must. Detailed Description Provide Development and Production support and automation for databases. This includes creating primary database storage structures; designing and creating primary objects; modifying database structure as necessary for enhancements or performance; monitoring and optimizing performance of the database; planning for backup and recovery of the database; allocating system storage and planning future storage requirements; familiarization with automation tools which are primarily used for creating database ,enterprise application ,middle tier (weblogic ,tuxedo etc) and creating database-related scripts and programs to support development and production environments. Installing PeopleSoft Enterprise related software like Weblogic, Tuxedo, and 3rd Party software on the servers. Job Requirements Leading contributor individually and as a team member, providing direction and mentoring to others. Duties and tasks are standard with some variation. Complete own role largely independently within defined policies and procedures. We are looking for- BS degree in Computer Science (or related field) or comparable work experience. 4 years database administration experience on any Oracle or DB2. Knowledge of other RDMS or DB2/OS390 is a plus. Experience working with multiple Operating Systems including Windows Linux and Unix. Knowledge of BEA Tuxedo, Oracle application server, Oracle Enterprise Manager, Weblogic, or Websphere is a plus. Knowledge of third parties like OLM, SES, Advance Configuration & Controller, IBM Info-sphere Server is a plus A self-starter with excellent troubleshooting, interpersonal, communication, and documentation skills. Additional Details Install, integrate and troubleshoot PeopleSoft Enterprise applications on windows, Linux and Unix platforms. Create and manage PeopleSoft Enterprise database environments both Unicode and non-Unicode on Oracle RDBMS. Monitor servers and apply security patches to keep them up-to-date as necessary. Troubleshoot environment issues. Detailed Description and Job RequirementsWork with a world class team to provide enterprise-wide, Oracle Database Administration support for production systems and provide DBA services to application development teams, including database design, database generation, coding, and database production support. Provide DBA support with a high degree of customer service, technical expertise, and timeliness. Provide accurate and creative solutions to user problems of moderate nature to ensure user productivity. Provide Development and/or Production support. This includes creating primary database storage structures, designing and creating primary objects, modifying database structure as necessary for enhancements or performance, creating documentation, designing interfaces, database objects, and creating plans. Monitor and optimize performance of the database, plan for backup and recovery of the database, and allocate system storage and plan future storage needs. Create database-related scripts and programs to support development and production environments. Research, evaluate, design, test, recommend, and plan implementation of new or improved RDBMS, ETL and database tools. Job duties are varied and complex utilizing independent judgment. May have project lead role. 5 years of experience supporting relational databases as a DBA, with multiple distributed relational DBSM*s or a depth and focus in Oracle and related tools. Exposure and practice at using the DBMS to optimize performance of large databases for enterprise use is preferred. Experience with an organization with a key 24 X 7 reliance on its database is desirable. BS or equivalent desired. JobInformation Technology LocationIN-IN,India-Bengaluru Job TypeRegular Employee Hire OrganizationOracle

Software Engineer

Degree: ME/ M.Tech./ MS (Engg/ Sciences)

Experience: 5-8

Function: IT Software : Software Products & Services