Go Back

IT Database Analyst-Williams

Posted on: 26-Jun-2012

Reply to: http://www.energy.williams.com/Careers

Bookmark this: Add

Career Opportunities: IT Database Analyst (19162)

Requisition Number 19162 - Posted 06/19/2012 - Tulsa, OK
 

Seeking a highly motivated hands-on Database Analyst responsible for implementing and maintaining Oracle & SQL Server database systems.  This position works closely with the Application Development team to provide solutions to satisfy complex business needs and provide production database support.

 

Responsibilities:

  • Monitors daily operations of Oracle and SQL Server databases for reliability, performance, and accessibility.
  • Write proactive scripts, stored procedures, and jobs to insure databases are running efficiently.
  • Create/Maintain data models
  • Manage Oracle application schemas for applications; maintain table structures, create/maintain database triggers, create indexes, sequences, and procedures as needed.
  • Responsible for promotion of database objects to production.
  • Unload/load data as needed.
  • Run schema downloads from production to non-production environments.
  • Run schema compares and manage schema synchronization.
  • Maintain database statistics.
  • Maintain security; create roles as needed, create/manage user accounts, manage data object permissions.
  • Writes scripts and jobs supporting database backup and recovery, maintenance, and integrity.
  • Create and test backup and recovery plans to insure Oracle and SQL Server databases are recoverable from daily and disaster situations.
  • Advises, educates, and works with application developers explaining SQL queries, changing SQL code, and reviewing database parameters in support of performance problems and troubleshooting.
  • Advises, educates, and works with application developers to implement physical database designs and migrate database changes supporting project related efforts.
  • Installation, updating and configuring the databases in support of business changes.
  • Provides, documents, and maintains database standards, policies and procedures for effective operation, access, and control of all Oracle and SQL Server databases.     

 

 

QUALIFICATIONS

 

Required:

  • Bachelor’s degree in computer science or MIS
  • 7+ years of Oracle (versions 9 – 11) experience
  • Working knowledge of MS SQL 2000/05/08
  • Working knowledge of configuration, installation, patching, and upgrades of relational databases
  • Working knowledge of database performance tuning and backup/recovery processes
  • Working knowledge of stored procedures, scripts, etc.
  • Must be able to mentor and provide technical guidance to Application Developers
  • Strong troubleshooting skills
  • Must be results-driven, able to multi-task, and have the ability to execute efficiently on a variety of projects concurrently

 

Preferred:

  • Experience with PODS Database, ArcSDE and ArcServer
  • Experience creating/managing geodatabases
  • Experience managing security/versioning in geodatabases
  • Experience troubleshooting geodatabase issues
  • Experience creating/maintaining spatial views and multi-versioned views

 

Williams Corporation will not pay relocation costs associated for this position.