Journey Database Administrator

SMUD•Sacramento, CA

7d•Hybrid

About The Position

We’re looking for a Database Administrator who can keep our data environment running smoothly and securely. In this role, you will be the subject matter expert of SMUD’s database systems, making sure they’re fast, reliable, and scalable. You’ll design, configure, maintain and support critical enterprise database systems including Oracle and SQL Server. You’ll lead efforts to provide the most reliable, robust, and secure solutions, working closely with IT teams and business units. If you’re ready to make a real impact and help power a brighter future, we want to hear from you! We are posting this opportunity for the Journey level along with our Senior level position. The department will be filling one position at either of those levels. If you are interested in the Senior level position you will need to apply to that position separately.

Requirements

High School diploma or equivalent
Three or more (3+) years of progressively responsible work in establishing criteria, formulating projects planning and design end assessment of database with two or more of the following databases: IDMS, IMS, DB2, Sybase SQL Server, Oracle, and MS SQL Server.
Certificates in information technology and/or a products/technology related field from educational institutions or vendor certified programs.
Principals and concepts of relational and network data base management; DBMS performance tuning and troubleshooting techniques; network and mainframe configuration and design; principals and concepts of data management; operating concepts for multi-user, multitasking operating systems; concepts and principles related to implementing technology solutions; methods and techniques of data access; techniques and practices for problem research and resolution; techniques and practices for resolving complex technical issues; concepts of centralized and distributed computing; characteristics and operational needs of various organizational units; methods and techniques for planning, organizing and overseeing work activities; procedures and practices for monitoring and managing projects; methods and techniques for training staff; basic principles and practices of budget preparation and administration; office procedures, methods, and equipment including computers and applicable software applications such as word processing, spreadsheets, and databases; English usage, spelling, grammar, and punctuation; safety policies, practices and procedures.
Plan, develop and implement automated solutions for business functions; build, maintain and test corporate database environments; plan the installation of new releases of database software; install and maintain database management software such as DB2, MS SQL Server and Oracle; ensure the integrity of all physical database objects; establish database procedures; create storage groups, databases, tables and views; assist in establishing backup, recovery and restart procedures; analyze procedures/systems and develop/implement operational improvements using information technology systems software, tools and processes; utilize logic and analysis to identify the advantages and disadvantages of different approaches; read and interpret plans, diagrams specifications, program languages and contracts; develop an estimation of how a system should work under ideal conditions; analyze and model business processes and data; conduct feasibilities studies; identify and assess training needs for staff; express ideas/facts clearly and concisely to individual or groups, taking into account the audience and nature of information; stay abreast of new IT technology, tools and methods to develop and support business applications; plan and organize work to meet changing priorities and deadlines; operate office equipment including computer terminal, systems and software relevant to the job; compile and prepare technical, statistical and/or analytical reports and presentations; communicate effectively orally and in writing internally/externally; establish and maintain effective working relationships internally.

Nice To Haves

BA/BS degree from an accredited college or university majoring in Computer Science, MIS, or related field or equivalent
Three or more (3+) years of experience Architecting, implementing and maintaining SQL Server solutions including but not limited to: SQL Server installation and upgrades, SQL Server Licensing and its various types, SQL Server backup and restore including full and partial recovery and point in time restores, SQL Server security including server level and database level permissions and roles, Implementing SQL Server HA solutions including AlwaysOn Availability Groups, AlwaysOn Failover cluster instances and Windows Server Failover Clusters, Performance and Troubleshooting, SQL Server Agents, DR offerings
Three or more (3+) years of experience in: Windows Server basic administration for purposes of DBA work, Using VMware vCenter to monitor VMs and troubleshoot issues, Linux or Unix experience, Oracle administration (Installation and upgrades, Licensing, DR offerings)
Automation and scripting (SQL, Bash, shell, PowerShell, T-SQL, PL/SQL)
Active Directory concepts (user/computer accounts, Service Principal Names, managed service accounts)
Managing VLDBs (Very Large Databases)
Linked Servers
SQL Server cloud offerings
PostgreSQL
DB2

Responsibilities

Supports SMUD’s strategic information technology goals and direction by serving as a technical lead on application database projects; designs, develops, implements and maintains the database systems; identifies potential database management projects.
Ensures SMUD’s database systems meet and serve SMUD’s current and future business needs; conducts feasibility and needs assessment studies; defines functional system requirements and specifications including conducting business process and data analysis; develops technical standards and procedures and system design; recommends improvements and modifications to new and existing database system software to improve business processes.
Prepares procurement and bid documents; evaluates proposals and hardware/software products; procures IT hardware, software and services; develops system and user acceptance tests; plans the integration of new technologies and applications; installs and integrates applications and systems; performs post-implementation reviews.
Maintains and operates systems; monitors and troubleshoots moderately complex problems using established processes and methods.
Provides technical solutions, support and user training on software issues to ensure database users optimize the database infrastructure; provides technical consultation to business units to minimize downtime; troubleshoots hardware, software and applications problems; documents problems and fixes; provides 24-hours on-call support.
Establishes training needs; develops training plans, procedures and materials; conducts training sessions, and performs post-training evaluations.
Assists in planning, reviewing and conducting work activities and researching required project information associated with department internal/external projects in accordance with established task objectives and schedule as outlined in the project plan/contract.
Performs related duties as required.