Journey Database Administrator

Title Journey Database Administrator Department IT Infrastructure Location Sacramento, CA, US Category Information Technology/Telecommunications Pay Rate Minimum Pay Rate: $119,308.80 Maximum Pay Rate: $158,059.20 Civil Service Status Civil Service Apply By Date 05/18/2026 Posting Type Open Job Description 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. Duties and 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. Required Education High School diploma or equivalent Required Experience Qualifications 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. Required Licenses/Certificates Certificates in information technology and/or a products/technology related field from educational institutions or vendor certified programs. Knowledge Of Principals and concepts of relational and network database management; database management system 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. Skills To 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. Desirable Qualifications 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) Knowledge of Linked Servers SQL Server cloud offerings PostgreSQL DB2 Physical Requirements Applicants must be able to perform the essential job functions with or without a reasonable accommodation. Equal Employment Opportunity SMUD provides equal employment opportunities (EEO) to all employees and applicants for employment without regard to race, color, religion, gender, sexual orientation, gender identity or expression, national origin, age, disability, genetic information, marital status, amnesty, or status as a covered veteran in accordance with applicable federal, state and local laws. SMUD complies with applicable state and local laws governing non‑discrimination in employment in every location in which the company has facilities. This policy applies to all terms and conditions of employment, including, but not limited to, hiring, placement, promotion, termination, layoff, recall, transfer, leaves of absence, compensation, and training. SMUD expressly prohibits any form of unlawful employee harassment based on race, color, religion, gender, sexual orientation, gender identity or expression, national origin, age, genetic information, disability, or veteran status. Improper interference with the ability of SMUD employees to perform their expected job duties is absolutely not tolerated. #J-18808-Ljbffr Sacramento Municipal