• Us Citizen

• Green Card

• Corp-Corp

• Consulting/Contract

• UG :- - Not Required

• PG :- - Not Required

• No of position :- ( 1 )

• Post :- 16th Nov 2020

Position: Oracle - SQL Admin

Location: Lansing MI

Need Senior Profile - 10 Years

This Oracle/SQL Server Database Administration position supports the Department of Treasury's Oracle and SQL Server databases.This Oracle/SQL Database Administration position supports the Department of Treasury's Oracle and SQL Server databases. This database administration position supports the future implementation and conversion to new database technologies that have statewide impact on the Department of Treasury.  This position is the expert on database performance tuning: - identifying and solving minor and major bugs, and issues on a twenty-four by seven basis; providing ongoing productions support regarding creating database objects.  In addition this position works with developers and others to support their ability to use the data to further the interests of the agencies.  This includes data cleanup, conversions, running scripts, synchronizing versions, database upgrades and providing expertise in Structure Query Language (SQL) and Procedure Language/ Structure Query Language (PL/SQL) coding to other agency Information Technology (IT) staff. 

Skills Required: 

Knowledge of Oracle Enterprise Manager 19c (OEM)Required 5 Years 

Experience in relational database administration, tools, and related activities.Required 5 Years 

Knowledge of the fundamental principles, theories, techniques, and methodologies of data processing systems analysis.Required 5 Years 

Knowledge of computer programming, data modeling, and object oriented programming procedures, techniques and applicable tools.Required 5 Years 

Ability to prepare detailed written instruction and documentation.Required 5 Years 

Ability to express complex technical concepts at a level appropriate to the audience, both verbally and in writing.Required 5 Years 

Knowledge of UNIX scripting and UNIX system administration.Required 5 Years 

Knowledge of Oracle database administration.Required 5 Years 

Knowledge of SQL and PLSQLRequired 5 Years 

Knowledge of Oracle Advance Security ProductsRequired 5 Years 

Knowledge of SQL Server database administrationRequired 5 Years 

Knowledge of SQL Server Management Studio (SSMS) and T-SQLRequired 5 Years 

Knowledge of PowerShell or similar scripting/automationRequired 5 Years