DBA at Boise

Job Description

Database Administrator - Peoplesoft
Boise, ID
Start Date: Immediately
End Date: 12/6/2013

Assist developers troubleshooting code issues, optimizing/tune SQL, environment variable issues, etc.
Resolve outstanding incidents, service tickets, and work orders (customers first please, project work second)
Typical service tickets include: managing DB security, rebooting servers, file retrieval, assisting with App Designer or STAT questions, server performance, server directories filling up, copying table data from one environment to another, etc.
Assist production support monitor and address production performance issues.
Perform database clones (including rename process)
Monitor system alerts, DB and application performance, logs, core dumps, etc.
Troubleshoot outages/incidents that occur on your shift escalate to team member in Boise when necessary.
Perform backup and recovery procedures as necessary
Review events that occur during the business day and identify areas for improvement.
Develop long term solutions for reoccurring events (example: file systems that fill up, IB errors, jobs that run too long, DB locking issues, processes that can be automated)
Assist with maintenance/outages that occur
Conversion activities which include exporting and importing tables, migrating code, running special backups and statistics, rebooting PeopleSoft servers, etc.
Performs highly complex data management functions at an enterprise level; installs, integrates, upgrades and manages PeopleSoft database environments and structures; monitors and evaluates PeopleSoft database environments to optimize performance; plans, organizes, tests and executes migration of databases from development and test to production environments; installs and tests new releases, bundles and fixes; ensures data security protocols are maintained and backup/recovery processes are completed as scheduled.
Performs PeopleSoft database administration functions for enterprise databases, including setting up and running database management utilities to backup, reorganize and restore databases and resolve production and operational problems; monitors utilization and manages available database resources.
Performs PeopleSoft data and systems architect duties; analyzes data resource and server capacity and forecasts growth requirements; recommends server, hardware and RDBMS upgrades and enhancements to meet long-term needs; provides enterprise-level short- and long-term planning advice on technical enterprise database and systems management and utilization issues; promotes the effective sharing and utilization of common data across applications and departments/business units; researches and recommends software, hardware and other tools for data warehousing and data mining solutions; develops and deploys software to support data extraction, manipulation and reporting.
Administers PeopleSoft enterprise database security processes and procedures; develops, recommends and implements security permissions, privileges, standards and guidelines.
Installs, configures and integrates PeopleSoft application software over data management systems and supporting components and services; installs, upgrades and implements application fixes and patches; administers enterprise application software to ensure security and performance optimization.
Works in coordination and collaboration with other information technology (IT) staff as needed.
Performs highly complex systems management functions at an enterprise level; installs, configures, integrates, tests, maintains and administers enterprise operating system software, including system monitoring and management software, for production, development and supplemental servers running enterprise applications and supporting components; installs and monitors system level security structures and protocols; ensures disaster response and recovery processes are followed.
Provides advanced technical support to PeopleSoft developers and users including advice and guidance on complex processes and system interdependencies; troubleshoots operational and systems issues ranging from difficult to highly complex, including problems with multiple solutions and potential significant consequences
Oversees reviews and responds to developers on PeopleSoft application customization and security requests, ensuring that development standards are followed, application changes are documented, change control procedures are strictly enforced and change projects are migrated across applications environments in an orderly manner.
Develops and maintains schematics and other documentation of PeopleSoft database and systems architectures and administration processes.
Performs other related duties as required.#CBRose#

Rose International is an Equal Employment Opportunity Employer-M/F/D/V

About Rose

• Founded in 1993
• 21 office locations across the U.S.
• 130+ Customers; corporations and government agencies
• Employee Oriented Company
• Challenging Assignments across the U.S.
• Continuous Professional Development
• Challenging, Exciting and Professional Atmosphere
  

Join Our Team Today!

Employee Comments

We want you to work with us, but dont take our word for it. Take a look at this sampling of employee comments. They speak for themselves.
Each time I contacted Rose, I was completely satisfied with the great attention and customer service I received. Each person was extremely knowledgeable and patient with my concerns or questions. Diana, Consultant
Find Rose on Facebook
Follow Rose on LinkedIn 2011 Rose International. All rights reserved.

Job Requirements

 
Country: USA, State: Idaho, City: Boise, Company: Rose International.