At SDG&E, we are committed to the community we call home, delivering clean, safe and reliable energy to better the lives of the people we serve in San Diego and southern Orange counties. Our commitment means we are creating a sustainable future by providing almost 45 percent of its electricity from renewable sources; modernizing natural gas pipelines; accelerating the adoption of electric vehicles; supporting numerous non-profit partners; and, investing in innovative technologies to ensure safe and reliable operation of the region's infrastructure for generations to come.
Our highly trained and responsive employees with their diverse skills, talents and ideas are the reason we can deliver on our commitment and are building America's best energy company. They are also the reason why we have been recognized with the industry's most coveted awards. Our employees undertake challenging work, and receive highly competitive compensation and benefits. As one of the region's largest employers, we're always searching for talented and bright people to join our team. After all, it takes the best to build the best.
SDGE's IT division is seeking a hands-on Oracle DBA, whose primary role will be to provide database support for ESRI's GIS and Mapping software products.
Has primary responsibility for the definition, creation, and maintenance of the enterprise data model within the new computing environments (e.g., Unix, intranet, Web).
The ideal candidate will be experienced in large SDE deployments and production support for large and diverse geodatabase environments. Strong working knowledge of spatial performance monitoring and tuning, structured query language, operating systems and related tools.
Analyzes, tests, and implements physical database design supporting various business applications (including base definition, structure, documentation, long range requirements, and operational guidelines).
Ensures data recovery, maintenance, data integrity, and space requirements for physical database are met through formulations and monitoring of policies, procedures, and standards relating to database management.
Provides a high degree of coordination between users' (corporate and technical) and corporate entities to ensure effective data management as a corporate enterprise.
Above all, ensures solutions meet business objectives and establishes and maintains a high level of user trust and confidence in IT's knowledge of and concern for users' business needs. Has a willingness to work with customers of varying levels of technical expertise in a high pressure, complex environment.
Duties and Responsibilities
Provides first level applications support: Resolve problems and answer questions related to the RDBMS and platform environment (e.g., Unix, ESRI, Oracle); contact vendor support when necessary; facilitate application development and client problem resolution with optimum speed and efficiency.
RDBMS performance monitoring and tuning: Closely monitor performance; identify problems and implement solutions; ensure the database is running at optimum speed and efficiency.
Maintain database backup/recovery environment: Respond quickly to refresh data; verify implementation of correct backup strategy; develop recovery procedures; support recovery from loss of data caused by user or system error.
Installs and upgradesRDBMS and related products: Keep RDBMS at current release and maintenance levels; install supporting products; provide current, stable production and development environments.
Reorganizes database structures as needed: Automates procedures at regular intervals; use tools to v reorganize or defragment database table spaces, tables, and indexes; provide efficient database environment to maximize productivity and improve performance
Provides assistance in database design as needed: Researchs and recommends optimal design criteria; publish standards and work with development staff; standardize environment and improve efficiency Capacity planning and reporting: Monitors file system space, database allocation, etc.; verify efficient use of disk storage; reclaim dead space; optimize space allocation and avoid out of space conditions.
Creates, develosp, and reviews the physical model created from the logical model, ensuring the detailed physical design of data structures and databases complies with standards, guidelines, and procedures recommended for all aspects of data modeling, database design, and maintenance; ensure proper data modeling and design paradigms are applied.
Produces entity relationship diagrams, data flow diagrams, database normalization schemata logical to physical database mapping, data table parameters.
San Diego Gas And Electric Company