Oracle and MS SQL Server Database Engineer
10001 Jack Finney Blvd. Greenville TX 75402
Seeking an Oracle and MS SQL Server Database Engineer/Analyst. The candidate must be able to analyze and understand business/functional requirements in order to design, model, develop, validate and implement logical and physical data models including relational and dimensional models in a Data Warehouse enterprise environment. The candidate must be able to assist with the conversion from Oracle to MS SQL Server which includes understanding the Oracle design/implementation in place and being able to model or adapt that to an MS SQL Server implementation.
Bachelor’s degree with a minimum of six years of relevant experience.
Desired experience includes the following:
o 12c version and higher Database Administration experience in the LINUX environment.
o Database Administration of an Oracle Enterprise Database.
o Tuning Oracle 12c Databases and queries.
MS SQL Server
o Linked Servers
o Tuning databases and queries
Solid understanding of Data warehouse principles and methodology including design, dimensional data models, data dictionaries, and Meta data.
Ability to articulate complex concepts in a clear concise fashion; verbally and in writing.
Ability to work cooperatively with internal team members, external project customers, infrastructure architects, and system/security administrators.
Must be able to develop and maintain database and design documentation.
Understand the logical and conceptual relationship of data and the needs of a complex application.
Familiarity with Database DISA security concepts.
Familiarity with PL/SQL, TSQL, SQL, and XML.
Experience with terabyte + databases in a Database Grid environment.
Strong hands-on experience using data modeling tools.
Strongly proficient with SQL queries.
Strongly proficient with Enterprise Database tunings concepts for SQL, Data Modeling and Physical Modeling.
Familiarity with OEM Grid tools.
$48.00 - $70.00 /Hour
IT & Technical