Job Summary:

• Review and understand the structure of the database.
• Review publications identified by the project lead, and break these down into their constituent database components (i.e., database normalization).
• Identify dataset issues (e.g., duplicate primary keys, missing foreign keys) into their constituent database components (i.e., database normalization)
• Ability to edit and write new python scripts would be ideal.
• Submit formatted datasets to project lead for import into the database.
• Ensuring changes and/or customizations to program/application objects and processes are clearly identified and packaged for migration and documented in adherence to standards. 
• Oversee, develop, and validate disaster recovery and business continuity infrastructure. 
• Participate in strategic planning of client/server database development. 
• Evaluate database-related products such as report writer, file management utilities, and security software. 
• Participate in database-related procurement processes including budget, requisition, and costs. 
• Participate in the Emergency Response Team (ERO) 
• Support the biennial refueling outage.

Skills on Resume:

• Database Review (Hard Skills)
• Issue Identification (Hard Skills)
• Script Writing (Hard Skills)
• Data Submission (Hard Skills)
• Migration Documentation (Hard Skills)
• Disaster Recovery (Hard Skills)
• Strategic Planning (Soft Skills)
• Procurement Participation (Soft Skills)

Job Summary:

• Design and manage database warehouse, check database logic error and verify indexes
• Conduct data cleansing, data verification, data standardization during the project implementation
• Efficiently process the collected data to figure out the valuable information and conduct the in-depth analysis
• Based on the analysis results, provide advice for software developers to improve the user experience and satisfaction of Fantuan’s application
• Provide regular communication to site Operations and internal / external customers regarding operational issues, process flows, customer requirements, account specific issues, etc. Includes analysis, insight, and recommendations.
• Use spreadsheets, databases, and other tools to provide ongoing analysis of inventory and operational activities (such as slotting optimization for new and existing product, buying pattern fluctuation across multi commodity environment etc.). 
• Assists site operations in identifying areas for improving service levels, reducing transportation costs, and providing other operational enhancements.
• Monitor, document and analyze the operational data of Fantuan’s platform, locate problems and provide solutions.
• Coordinate with Information Technology groups to ensure technical issues and problems are being identified, addressed, and resolved in a timely manner.
• Coordinate with the business group on issues related to modeling customer solutions, including providing “subject matter” expertise for process improvement workshops.
• Develop standardized and ad hoc site and/or customer reporting.
• Investigate and recommend new technologies and information systems.
• Partner with Operations to develop financial models to analyze productivity and payroll.

Skills on Resume:

• Database Management (Hard Skills)
• Data Cleansing (Hard Skills)
• Data Analysis (Hard Skills)
• UX Consulting (Soft Skills)
• Process Communication (Soft Skills)
• Inventory Analysis (Hard Skills)
• Operational Enhancement (Soft Skills)
• Technology Coordination (Soft Skills)

Job Summary:

• Works with other M3 departments to resolve problems within domain of responsibility. Provide timely resolution to advanced problems.
• Write T-SQL statements, stored procedures and views using industry best practices for security and efficiency.
• Work with application developers to test, create, and troubleshoot applications.
• Reviews, evaluates, implements and maintains company databases.
• Identifies data sources, constructs data decomposition diagrams, provides data flow diagrams and documents the process.
• Writes codes for database access, modifications, and constructions including stored procedures.
• Performs thorough impact analysis and risk assessment of intermediately complex database changes.
• Implement configuration changes, data corrections and new database items in a deadline driven environment.
• Interact with clients and other departments to define requirements and suggest database design changes.
• Handle multiple project and work streams in a highly dynamic environment.
• Understands M3 business and the role of Database Analyst.
• Provide best practices, backup/recovery strategies, capacity planning, security and performance tuning.

Skills on Resume:

• Problem Resolution (Soft Skills)
• SQL Development (Hard Skills)
• Application Testing (Hard Skills)
• Database Maintenance (Hard Skills)
• Data Architecture (Hard Skills)
• Risk Assessment (Hard Skills)
• Design Consultation (Soft Skills)
• Capacity Planning (Hard Skills)

Job Summary:

• Independently work with business customers and members of the EDS team to create solutions that support reporting, analytic and warehouse needs using the appropriate platforms and tools.
• Analyze business requirements and work with client areas to produce functional specifications for use as reference in creation of reporting and analytical solutions.
• Perform the first level of testing for a new and/or enhanced functionality and provide support for user acceptance testing.
• Analyze source data to understand relationships and determine business rules.
• Assist in designing the data warehouse and assure that data is stored and maintained in consistent formats.
• Create source to target mapping documents to transform the source data into the target warehouse and test final transformations.
• Develop and/or maintain relationships with business customers to identify and acquire additional data sources to incorporate into the warehouse.
• Train and assist users with retrieving data from the warehouse.
• Provide guidance in the creation of reporting and analytical solutions.

Skills on Resume:

• Solution Development (Hard Skills)
• Requirements Analysis (Hard Skills)
• Functional Testing (Hard Skills)
• Data Analysis (Hard Skills)
• Data Warehouse Design (Hard Skills)
• Data Mapping (Hard Skills)
• Relationship Management (Soft Skills)
• User Training (Soft Skills)

Job Summary:

• Administers databases, using a database management system to organize and store data. 
• Ascertains user requirements, creates computer databases, and tests and coordinates changes
• Defines, designs, and/or develops relational and/or multi-dimensional databases for warehousing of data
• Review current data structures and recommends optimizations and reconfigurations as warranted
• Interacts with development and end-user personnel to determine application data access requirements, transaction rates, volume analysis, and other pertinent data required to develop and maintain integrated databases
• Providing technical and architectural subject matter expertise to the various development teams including communicating architectural decisions and mentoring other technical staff around the various development technologies and decisions  
• Working collaboratively with all stakeholders to ensure end to end success  
• Ensuring the architecture is aligned with business requirements  
• Architecting project integration solutions on behalf of the platform, aligned to Enterprise Architecture design standards  
• Identifying and proposing specific strategies, initiatives, and remedies necessary to align technology infrastructure with organizational objectives  
• Building data architecture and integration efforts related to defining, developing, and delivering capabilities  

Skills on Resume:

• Database Management (Hard Skills)
• Requirements Analysis (Hard Skills)
• Database Design (Hard Skills)
• Data Optimization (Hard Skills)
• Stakeholder Collaboration (Soft Skills)
• Technical Leadership (Soft Skills)
• Architectural Alignment (Soft Skills)
• Integration Solutions (Hard Skills)

Job Summary:

• Provide strategic vision and plan for the implementation and use of databases in support of ERP applications. 
• Provide technical administration of Oracle and SQL client/server databases which be corporate-wide databases critical to the business and technical operation of Energy Northwest. 
• Include database tuning/troubleshooting, documentation of database upgrades/patches, database procedures development, and documentation. 
• Provide consultative support and technical expertise to the organization
• Provide mentoring support to the staff in the ongoing administration of database environments. 
• Apply expert database development and design skills in the execution of corporate-wide information technology projects
• Perform formal technical analysis and document subsequent conclusions to compose documented feasibility studies. 
• Proactively monitor client/server databases to identify, resolve, and/or make recommendations for the resolution of potential failures or performance issues. 
• Interface with vendor's technical support center, search the vendor's website, research the software architecture of application functionality
• Learn to use the application tools to assist/coach customers in the implementation of new functions or troubleshooting process and data problems. 
• Coordinate or assist in the implementation of application changes into production with customers and EN peers

Skills on Resume:

• Strategic Visioning (Soft Skills)
• Database Administration (Hard Skills)
• Performance Tuning (Hard Skills)
• Technical Consultancy (Soft Skills)
• Database Mentoring (Soft Skills)
• Design Expertise (Hard Skills)
• Feasibility Analysis (Hard Skills)
• Proactive Monitoring (Hard Skills)