Off-shore Dedicated DW DBA Lead

03 Oct 2016
04 Feb 2017
Oil and Gas
Contract Type
Full Time
The Oracle Data Warehouse DBA Lead will serve as technical expert responsible for the design / implementation of Data Warehouse technology and set / administer standards for overall organization's Data Warehouse database structure and architecture for our Oracle database environment. Individuals in this role will research data warehouse technology, determine requirements, propose changes, and be heavily involved in database performance and tuning for very large data warehouse databases in Power

Essential Responsibilities

The Power & Water Data Services team is looking for an individual to lead strategic project improvement implementations across P&W for Oracle data warehouse database technologies. This is a highly technical role for a senior DBA with excellent leadership & communication skills, broad architectural understanding, and strategic thinking.
In addition, you will:
• Set and administer data warehouse database standards for overall organization's Oracle relational database structure/architecture
• Provide database architecture and technical project leadership for new projects
• Maintain, tune, monitor and administer both development and production Oracle application data warehouse databases and application-tier technology components
• Designs, tests and installs database management systems for use with business applications
• Ensures appropriate linkages with applications to other data processing systems
• Monitor, resolve and implement incidents, service requests, changes and problem tickets requested by the applications teams providing hands on DBA support
• Active daily monitoring of the server and DB, using heath check reports and tools such as OEM, ADDM, AWRRPT, Server Stats, DML Log report, etc. Identify possible issues and/or fine tuning opportunities
• Ensure that proper root cause analysis is completed on all Database Problem tickets and that solutions are implemented across the enterprise of servers.
• Constructs database specifications, provides fault isolation and resolution, tunes database applications for optimum performance, and implements disaster recovery and contingency plans as required by the business
• Responsible for the control, integrity, and accessibility of the database file structure of one or more databases with multiple concurrent users
• Research database technologies, determine business requirements, propose changes, and develop migration and implementation plans, may execute projects based on these activities
• Ensure plans for database technologies integrate effectively with other aspects of the technical infrastructure


• Bachelor's Degree in Information Systems, Information Technology, Computer Science or Engineering (or a High School Diploma / GED with a minimum of 4 years of experience in the application of information technologies to business solutions)
• Minimum of 5 additional years of experience with Oracle as a professional Oracle Data Warehouse DBA in a large business environment
• Solaris, Linux, and Windows experience with some system administration skills.
• Knowledge & understanding of multi-tier system architectures
• Strong oral and written communication skills

Desired Characteristics

• Self-directed
• Ability to work in a virtual team without day to day managerial oversight
• Database Administrative experience with one or more database technologies including DB2 or PostgreSQL
• Knowledge & understanding of multi-tier system architectures
• Experience with complex Database environments including hardware and supporting infrastructures
• Experience with Oracle Enterprise manager and other performance and tuning tools like ADDM and ADR reports
• Systems Administration background in Solaris, Linux, and/or Windows
• Experience with RAC, Veritas, or Windows clustering
• Experience with Tableau, Informatica, Cognos and other DW ETL and Reporting tools
• Experience with database automation leveraging Ruby, Python, Chef or other programming tools
• Proficiency in PowerShell scripting specific to database administration and automation
• Project Management experience & proven track record
• Provide consulting support to Database application teams, Solutions Architect in complex systems design
• Understanding of open source business models & applications
• Provides leadership to identify practical solutions to improve performance and availability for support applications and infrastructure
• Proven analytical and problem resolution skills
• Quality and cost driven
• Proactive responsible individual, able to set own action plans
• Ability to influence and build consensus with other IT teams and leadership