At PCA, you’ll find the best people in the industry operating in a “golden rule” culture. We actively promote mutually rewarding relationships with each other and our customers by advocating respect for every individual, ethical and fair practices, and the highest standards in what we say and do. PCA is proud to have a highly skilled and experienced team leading the way.
As a Fortune 500 company and one of the largest producers of containerboard and corrugated packaging products in the U.S., PCA offers customers broad expertise and economies of scale, while our multiple plant locations let us rapidly meet the local needs of our customers.
Senior Database Analyst is responsible for developing, implementing and providing ongoing support of relational database technology, systems, services and business applications throughout Packaging Corporation of America with the end goal of ensuring that all database management systems are running at peak performance, are secure, recoverable and fully upgraded. This involves assessing new technology, determining opportunities and coordinating all aspects of development to ensure effective support of the business functions.
Develop and maintain efficient physical database models and identify/resolve data structure issues to meet both Corporate and plant business requirements.
Provide and manage support for database systems and services to ensure data is available 24x7, which includes maintenance, capacity planning, data recovery and structural and data integrity.
Monitor and optimize system performance and identify and resolve any defects or deficiencies in a proactive manner to ensure the business applications are operating properly.
Interface with the business development teams during the data modeling efforts, logical and physical, to clarify the application design and ensure the best possible database structure.
Work with software vendors to address issues regarding databases and management software to ensure the business application is functioning according to the user’s expectations.
Demonstrate an understanding of project methodology to report and prioritize work to ensure all tasks and projects are completed in a timely manner and meet the business groups’ needs.
Establishes and maintains relationships with corporate application and development teams as well as plant level system engineers to ensure operational efficiency.
Acts as a database advisor to proprietary application development project team for front and back end development.
Knows and follows policies and procedures of the company, shares information that would benefit other members of the team and finds ways to improve the delivery of service to our customers.
Strives to continually strengthen PCA’s business philosophy of meeting needs and exceeding expectation for customers, specifically, supporting PCA’s Commitment to Service, which involves doing what’s right for our customers, focusing on strategies that add value and support growth, and keeping the promises that we make.
Bachelor’s degree in Computer Science or related degree.
Work experience requires 10+ plus years of system development with Oracle 10G or higher running in a Client Server environment.
Strong database optimization, troubleshooting and performance tuning skills are required.
Technical skills require knowledge of a variety of technologies including RDBMS, specifically, Oracle along with Oracle RAC architecture, database partitioning, Oracle Active Data Guard, Oracle RMAN, LINUX and Windows, SQL and PL/SQL relevant to the database environment including a basic understanding of TCP/IP networking protocol. Knowledge of SQL Server RDBMS, Service-Oriented Architecture, Java and XML are desired along with the ability to implement Industry Best Practices.
Below listed experiences are a must:
Experience with the installation of Oracle database software in RAC environment on Linux nodes.
Ability to perform database rolling upgrades and apply rolling upgrade patches on RAC Linux nodes.
Experience working with Oracle Support in resolving complex/difficult problems/cases, the setup of Active Data Guard on primary and standby RAC Linux nodes.
Previous experience with the backups of databases in RAC and Active Data Guard environment as well as restoring databases in RAC and Active Data Guard environment.
Strong troubleshooting and performance tuning skills.
Strong problem solving, organizational, and decision making skills oriented on obtaining desired results.
Ability to work independently as well as part of a team and to have strong project organization and communication skills.
Achiever, self-motivated, self-responsible, and accountable.
Willing to provide support in evenings and weekends and be available by company supplied phone.
Competitive pay and benefit package.
PCA is an Equal Opportunity Employer – Veterans/Disabled and other protected categories.
All qualified applicants must apply at https://www.packagingcorp.com/ or https://usr54.dayforcehcm.com/CandidatePortal/en-us/pca