Data Architect

Portland, OR, United States

With more than 120 operations and approximately 20,000 employees worldwide, Precision Castparts Corp. is the market leader in manufacturing large, complex structural investment castings, airfoil castings, forged components, aerostructures and highly engineered, critical fasteners for aerospace applications. In addition, we are the leading producer of airfoil castings for the industrial gas turbine market. We also manufacture extruded seamless pipe, fittings, and forgings for power generation and oil & gas applications; commercial and military airframe aerostructures; and metal alloys and other materials for the casting and forging industries. With such critical applications, we insist on quality and dependability – not just in the materials and products we make, but in the people we recruit.

PCC is relentless in its dedication to being a high-quality, low-cost and on-time producer; delivering the highest value to its customers while continually pursuing strategic, profitable growth.

In 2016, Berkshire Hathaway, led by Chairman and CEO Warren E. Buffett, acquired Precision Castparts Corp.

Job Description 1 Mission:

Designs and builds relational databases in a multi-system 24x7 environment. Develop strategies for data acquisitions, backups, archive recovery, and general implementation of a database for testing and production use. Cleans and maintains databases by removing and deleting old data, building indexes, installing updates, and optimizing for performance. Evaluate software tools to facilitate database support. Act as liaison with vendors and interface with MIS staff for application development and daily support activities. Keep informed of current information technology and business applications.

Duties:

1. Create, maintain, document, and manage a stable database environment for production and development systems including Process Control, ERP, HR, data collection, and miscellaneous applications.

2. Administration of relational database software including:

- Version installation, patches, and upgrades.

- Create database structures, design and implement files, tables, security, and processes.

- Provide problem resolution in routine and emergency situations.

- Develop and monitor procedures for database backup and recovery.

- Support data conversions.

- Capacity planning, performance optimizing and monitoring.

3. Assist with HP-Unix system administration including:

- Version installation, patches, and upgrades.

- 3rd party software support.

- Create and maintain shell scripts.

- Maintain directories and file systems for test and production environments utilizing SAN technology and data backup/restore systems.

- Migration of applications from test to production environments.

- System security.

- Capacity planning, performance optimizing and monitoring.

- Provide problem resolution in routine and emergency situations.

4. Consulting with MIS Management on strategic directions.

5. Contribute and conform to the development and execution of MIS policies and procedures including SOX.

5. Contributes to the applications development standards and procedures at the department and division level.

6. Off-shift and weekend database, application, and systems support.

7. Disaster recovery planning and testing.

Requirements:

1. Education: B.S. degree in Computer Science or equivalent training and experience. Formal training and certification in Oracle database administration.

2. Preferred Six years of experience as an Oracle DBA in medium to large information technology infrastructure. Formal training and/or experience in application development.

3. Demonstrated experience in Process Control & MRP systems, emphasis placed on working knowledge of Visibility and PCC’s custom process control applications.

4. Demonstrated ability to apply new technology and concepts to existing infrastructure.

5. Proven project management skills.

6. Proven problem solving skills.

7. Excellent typing skills.

8. Extensive background with the following environments, hardware, and software:

- Hardware: HP4000, HPRP7410, HPRP7420, EMC Clariion, Fiber switches, PCs.

- Operating Systems: HP-UX 11.x, Windows, Windows Server

- Databases: Oracle, SQL server.

- Support Tools: Data Protector, Glance Plus, Perfview, Navisphere.

- Languages: Micro Focus Cobol, Powerhouse, HP-UX shell scripts, PL/SQL, MS.net, Visual Basic, Delphi.

9. Confidentiality

1 All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or status as a protected veteran.

This position requires use of information or access to production processes subject to national security controls under U.S. export control laws and regulations (including, but not limited to the International Traffic in Arms Regulations (ITAR) and the Export Administration Regulations (EAR)). To be qualified to work in this facility, a successful applicant must be a U.S. Person, as defined in those regulations, and able to supply evidence of that qualification prior to starting work or be authorized to receive controlled information under a specific license or permission from the relevant government agency. The U.S. export control regulations define a U.S. person as a U.S. Citizen, U.S. National, U.S. Permanent Resident (i.e. 'Green Card Holder'), and certain categories of Asylees and Refugees.

We are constantly searching for the best talent and offer excellent development programs for recent graduates as well as meaningful work experience for those still studying.

#J-18808-Ljbffr