Job Description :
POSITION : Oracle SDE/DBA – Database Administrator
LOCATION ; San Diego, CA
DURATION : FULLIME
JD :
Role
SDGE''s 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:
A) 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.

B) 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:
A) 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

B) 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.