Job Description :
Duties:
Must be capable of providing highly technical expertise and support in the use of DBMS.
Must be able to evaluate and recommend available DBMS products to support validated user requirements.
Defines file organization, indexing methods, and security procedures for specific user applications.
Develops, implements, and maintains database back-up and recovery procedures for the processing environments, and ensures that data integrity, security, and recoverability are built into the DBMS applications.
Education:
A Bachelor''s Degree from an accredited college or university with a major in Computer Science, Information Systems, Engineering, Business, or other related scientific or technical discipline or three (3) years of equivalent experience in a related field.
General Experience:
Must have six (6) years of experience in DBMS systems analysis and programming.
Specialized Experience:
At least three (3) years of experience in using current DBMS technologies, application design utilizing various database management systems and experience with DBMS internals.
Minimum Requirement
Four (4) years of experience deploying software installations and upgrades for Oracle 11g / 12c Release 1 on a Windows OS environment
Four (4) years of experience creating scripts for backing up data
Four (4) years of experience deploying applications that utilize Oracle Connection Manager
Four (4) years of experience configuring OEM tools and Oracle Grid Management Server
Four (4) years of experience creating database backups and recovery
Three (3) years of experience configuring RMAN for database backup and repository maintenance
Three (3) years of experience configuring SMTP
Four (4) years of experience deploying and configuring Oracle Data Guard on Windows OS
Three (3) years of experience configuring Quest TOAD DBA SUITE for Oracle
Three (3) years of experience configuring Quest SPOTLIGHT ON ORACLE RAC
Two (2) years of experience configuring data integration scripts with TALEND
Two (2) years of experience deploying and configuring Microsoft SQL Server 2016
One (1) year of experience deploying and configuring SQL Server Reporting Services (SSRS)
GEO Spatial Database Administration:
Install, configure and setup of ArcSDE GEO Spatial Database software.
Apply ArcSDE patches.
Create ArcSDE instances.
Configure External Procedure to ensure that SQL Functions of ST_Geometry and ST_Raster work with full functionality.
Configure backup of SDE users using the SDE Backup Utility.