Job Description :
IT division is seeking a hands-on Oracle DBA, whose primary role will be to provide project support toward the implementation of ESRI’s GIS and Mapping software products.
The Oracle database runs on the Oracle Linux.
While working on a project team, the DBA will support all necessary efforts in the integration and testing of systems to meet evolving geospatial capabilities requirements.
Primary duties of the DBA will include database and ArcSDE administration involving spatial and geospatial capabilities, as well as application development support.
Required Qualifications:
Spatial Data Engineering Administrator
Manage and Maintain ESRI Spatial Data
Support and understand ESRI Versioning, Compression and Reconciliation
Manage ESRI Replication
Demonstrable understanding of geometrical networks, relationship classes and spatial indexes.
Proficiency in ArcSDE configuration and upgrades
Resolve database performance issues as they relate to data distribution and replication
Daily tasks include:
Initial setup and configuration of new database:
Set DBTUNE for storage of data: lobs, rasters, longraws, tables
Configure the settings of internal GDB tables
Configure the settings of internal ArcFM tables
Assign Roles to the Feature Data Set, Feature Classes, Table
Memory allocation for predicted workflow support.
Maintenance of existing database:
ArcSDE Compress, make sure it is running correctly and rows are moving to base tables
Manage Data Statistics
Monitor and Rebuild Indexes
Configure users and permission changes
Debug issues with performance
Debug issues where a -51 or -10 is returned to the client application.
Add system capacity or re-allocate memory to support a change in client side workflow.
Oracle DBA:
Expertise in Oracle 12c and newer RAC
Proficient in installing, patching and upgrading Oracle DBMS software
Demonstrable understanding of Oracle’s ASM and ASO options
Solid skills in quickly diagnosing issues causing database performance bottlenecks or unplanned outages
Expertise in RMAN Backup / Recovery set-up
Demonstrable experience with Oracle’s Grid Control (formerly Enterprise Manager)
Daily tasks include:
Production Support:
Conduct daily error checking and overall database health; ensure backups were successful
Be available on-call to respond to any database production support issues 24/7
Ensure Database Recoverability through continuous improvement of backup and restoration processes
Adhere to policies, procedures and controls as they pertain to change management, license compliance and information protection; provide guidance to Application Peers as needed
Support audit requests for information and / or testing of controls
Perform periodic maintenance of database to ensure sustainability and availability
Ensure the DBMS is at a reasonably proper patch set level
Ensure hardware capacity is adequate through rigorous capacity planning activities
Project and Development Support:
Assist Application teams in delivering high-quality solutions on time and on-budget
Provide guidance on IT DBA standards and Information Security policies around access privileges, data classification and protection, as well as separation of responsibilities
Support application testing cycles and schema changes as needed to meet deadlines
Provide expert SQL tuning advice to project team
Add system capacity or re-allocate existing capacity to overcome project performance bottlenecks
Requirements:
The candidate will be experienced in large SDE deployments and production support for large and diverse database environments.
Strong working knowledge of database recovery, spatial performance monitoring and tuning, structured query language, operating systems and related tools.
A working knowledge of UNIX is also required.
The candidate shall also be proficient in several RDBMS-specific middleware tools and utilities to facilitate such activities as monitoring (such as Enterprise Manager), database migration, DDL (data description language) management, and replication; full knowledge of SQL, including programming and optimization; ability to provide production database administration, production support and 7 day/24 hour call-out responsibility.
We also value strong interpersonal and excellent teamwork skills, as well as a willingness to work within a high-performing project team meeting an aggressive schedule.
Ability to establish and maintain a high level of user trust and confidence in IT''s knowledge of and concern for users'' business needs.
Ability to present and explain technical information to diverse types of audiences (management, users, vendors, and technical staff) in a way that establishes rapport, persuades others, and gains understanding.