icrunchdata Network Bakersfield, CA, USA
Nov 19, 2019Full-time
BASIC PURPOSE OF POSITION: The role the Senior Database Administrator (DBA)/Developer is to oversee, manage, monitor and grow the Sentinel Peak Resources (SPR) Data Environment. The overall goal of the Senior DBA/Developer is to facilitate a seamless flow of information throughout the company, considering both backend data structure and frontend accessibility for end-users through reporting and analytics. ESSENTIAL DUTIES AND RESPONSIBILITIES: Manage and maintain all SPR SQL Databases and the movement of data across multiple servers, various databases and environments. Implement and steward key processes in coordination with SPR Information Technology group related to change and configuration management Support the SPR Data Warehouse and corresponding ETL jobs within the ecosystem Coordinate, plan, and prioritize with other functional teams within SPR to ensure systems comply and align with corporate objectives. Must have experience with data and applications related to the upstream oil and gas industry Create models for new database development and/or changes to existing ones. Install and configure relevant network components to ensure database access as well as database consistency and integrity. Respond to and resolve database access and performance issues. Monitor database system details within the database, including stored procedures and execution time, and implement efficiency improvements. Monitor, optimize and allocate physical data storage for database systems. Plan and coordinate data migrations between systems. Develop, implement, and maintain change control and testing processes for modifications to databases. Create, or support creation of, required reports in response to business user needs. Perform database transaction and security audits. Establish appropriate end-user database access control levels. Work with End Users and IT Project Teams to facilitate best practices database use. POSITION SPECIFICATIONS: 5 or more years industry experience Bachelor’s Degree in Computer Science or related job experience Highly proficient in T-SQL, DAX, MDX Knowledge of SCADA Network Architecture including alignment to Perdue Reference Model Highly Proficient in Microsoft SQL Server, SSIS, SSAS, and Power BI Experience with Time Series Data Integration and Historians Knowledge of management methods, budget preparation/implementation and regulatory policies and practices to complete job functions and responsibilities.