Database Administrator

San Diego Gas And Electric Company San Diego , CA 92140

Posted 1 week ago

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.

Primary Purpose

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.

icon no score

See how you match
to the job

Find your dream job anywhere
with the LiveCareer app.
Mobile App Icon
Download the
LiveCareer app and find
your dream job anywhere
App Store Icon Google Play Icon

Boost your job search productivity with our
free Chrome Extension!

lc_apply_tool GET EXTENSION

Similar Jobs

Want to see jobs matched to your resume? Upload One Now! Remove
Database Administrator

Solar Turbines Incorporated

Posted 3 weeks ago

VIEW JOBS 3/5/2020 12:00:00 AM 2020-06-03T00:00 Job Description This is a senior level position with responsibility and accountability for managing database environments and to ensure optimal performance under all possible conditions and scenarios Areas of focus include: data environments data architecture, data integration, backups, restorations and all operational aspects around data environments. The individual will be part of a highly motivated,dynamic, integrated, and global business-technology. More specifically, the team includes employees such as Diagnostic Engineers, Functional Architects, Technical Architects, Fleet Managers, Software Engineers, Data Scientists, and Network Engineers. Minimum Qualifications * Bachelor's degree in MIS or CS. Alternatively Bachelor's degree in engineering. * Minimum 7+ years of experience designing, developing and maintaining databases for complex software eco systems Preferred Qualifications * Hands on expert with logical/physical database designs with uncanny abilities for managing large to very large data growth and systems * Hands on experience with operational issues for data environments * Cloud experience is desirable * Expert database objects/SQL query tuning for better performance * Experience in PostgreSQL * Experience in MySQL * Experience in Oracle * Experience in SQL Servers Solar Turbines Incorporated San Diego CA

Database Administrator

San Diego Gas And Electric Company