Job Description :
Job Title: Oracle/SQL Database Administrator
Location: Will start off remote and then move onsite to Dimondale, MI
Job Summary:
This Oracle/SQL Server Database Administration position supports the Department of Treasury's Oracle and SQL Server databases.
RESPONSIBILITIES:
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.
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 PLSQL Required 5 years
Knowledge of Oracle Advance Security Products
Required 5 years
Knowledge of SQL Server database administration
Required 5 years
Knowledge of SQL Server Management Studio (SSMS) and T-SQL
Required 5 years
Knowledge of PowerShell or similar scripting/automation
Required 5 years