Sr PeopleSoft DBA
Must be a W2 employee : Full-time Description Candidate must have Database Administration (DBA) experience in a PeopleSoft environment and experience with Change Assistant and Integration Broker. Candidate would be responsible for providing technical support for maintenance of complex database structures and associated applications, which includes development of databases, performance tuning, backup and recovery, release of upgrades, and post-upgrade validation reviews. PeopleSoft Certified in Database Administration for Oracle and Peoplesoft Service Administration & Installation. Experience in PeopleSoft(TM) database design and administration or equivalent, experience in the analysis/tuning of databases for PeopleSoft(TM) applications, UNIX experience, shell scripting experience, procedural language (PL/SQL) knowledge and experience, thorough understanding of current database releases. It is preferred, but not required that candidate have experience in at least one implementation or upgrade project. Primarily works in an O&M environment, responsible for production support and management of the PeopleSoft environments from the web server/middleware perspective. Works in close collaboration with the PeopleSoft development and DBA teams as well as hardware and network areas as required. Researches, analyzes, evaluates, and stays current on industry best practice standards for these technologies. Installs, maintains, monitors and reports on web/application server tier components in a complex redundant, load balanced environment. Performs migrations, applies bundles/Maintenance packs/ Tax updates Essential Job Functions Participates in client/project meeting(s) for highly complex project definition, needs assessment and design review. Evaluates the needs and requirements of the users and provides technical expertise in the development of technical, structural and organizational specifications. Determines appropriateness of data for storage and optimum storage organization. Designs, develops, and integrates highly complex database systems for internal and external users/clients. Creates, documents and implements standards and/or complex modeling to monitor and enhance the capacity and performance of the database. Codes complex programs and derives logical processes on technical platforms. Designs user interfaces and business application prototypes. Performs complex analyses and reviews applications being released into production. Develops and oversees the implementation of test application code in client server environments to ensure that software conforms to build management practices. Remains abreast of and analyzes new and emerging technologies and tools for applicability to field. Prepares recommendations and presentation to management. Provides leadership and work guidance to less experienced personnel. Qualifications Basic Qualifications Bachelor's degree or equivalent combination of education and experience Bachelor's degree in engineering, computer science, business administration, software engineering or related field preferred Nine or more years of database engineering, design, development experience Experience working with relational data modeling Experience working with data warehousing Experience working with relational databases such as SQL, PL/SQL, Oracle, etc. Experience working with database development methodologies, design and implementation Other Qualifications Desired Skills: Knowledge of Business continuity and disaster recovery Knowledge of Financials 9.x, EPM 9.x, HCM 9.x and Interaction Hub 9.1 applications Knowledge of Oracle Secure Enterprise Search. Knowledge of PeopleTools Test Framework. Knowledge of PeopleSoft Update Manager, STAT, Foglight, Infosphere Good analytical and problem solving skills Other Qualifications 9 to 10 years of experience Advanced experience performing Admin tasks and managing an enterprise PeopleSoft 9.x applications with PeopleTools 8.53 Advanced experience managing critical corporate applications in a multitier enterprise environment Ability to leverage tools to troubleshoot these environments with emphasis on SQRs, PeopleCode, application engine, process schedulers, application messaging and app/web servers Should be skilled in shell scripts and be able to develop scripts for automation of tasks Should be skilled in documentation of the environments using industry standard tools and methodologies Ability to work in a dynamic 24x7 production support environment Ability to work in an on call rotation and provide afterhours support Should be skilled in Application Upgrades/PeopleTools upgrades using Change Assistant Integration Broker setup and administration Experience with Solaris SPARC, Windows 2008 R2, Understand Oracle database structures as related to PeopleSoft applications Good programming skills for database management and general software Good communication skills Leadership skills to guide work teams Ability to work in a team environment Ability to anticipate problems and take decisive action Strong analytical and problem solving skills Strong communication skills Strong personal computer and business solutions software skills Strong, demonstrated skills in using a Windows development language, programming or scripting such as VBScript, COM, COM+, XML, Java, Perl, etc. Strong interpersonal and human relations skills to interact with clients and less experienced personnel Ability to comprehend and integrate business unit/client needs into appropriate database system .