CPS Energy

Administrator Database 3

LocationSan Antonio, TX

About This Job

We are engineers, high line workers, power plant managers, accountants, electricians, project coordinators, risk analysts, customer service operators, community representatives, safety and security specialists, communicators, human resources partners, information technology technicians and much, much more. We are 3,500 people committed to enhancing the lives of the communities we serve. Together, we are powering the growth and success of our community progress every day!


Position Summary

The Administers Database position is responsible for backup, recovery, server architecture, performance tuning, security, auditing, metadata management, optimization, statistics, capacity planning, connectivity and other data solutions of mission critical database systems. Develops databases with SQL, stored procedures, triggers, transactional modeling, dimensional modeling, normalization, indexing methods, constraints and object usage.


Grade: 15

Qualifications may warrant placement in a different job level.


Deadline to apply: Open until filled


Tasks and Responsibilities

Builds and maintains the ongoing operational functionality and efficiency of CPS Energy databases ensuring system performance, availability, reliability, security, recoverability and efficient usage of server infrastructure resources.

Performs the capacity planning required to create and maintain corporate databases and processing demands.
Provides all facets of database administration to production, development and quality assurance systems.
Ensures database system security, change management, backup and recovery are maintained in compliance with corporate, state and federal regulations.
Provides database solutions to solve complex business issues including data processing, loading, performance improvements, data storage and data replication.
Diagnoses, troubleshoots and resolves database related issues including storage, performance, availability, data integrity and database security.
Performs and automates database management, maintenance and data processing activities.
Applies understanding of modern networks and operating systems as they pertain to database system architecture and functionality.
Develop scripts to perform system maintenance, monitor systems, automate tasks, etc.
Performs as technology subject matter expert for relational database management systems such as MS SQL Server 2019 and 2022.
Modifies existing databases and database management systems or directs programmers and analysts to make changes with appropriate database objects such as indexes, tables, partitions, triggers, constraints, stored procedures, large objects, views, etc.
Works as part of a project team to coordinate database development and determine project scope and limitations.
Writes and codes logical and physical database descriptions and specifies identifiers of database to management system or directs others in coding descriptions.
Trains users, documents systems and answers questions.
Specifies users and user access levels for each segment of database.
Reviews project requests describing database user needs to estimate time and cost required to accomplish project.
Develops standards and guidelines to guide the use and acquisition of software and to protect vulnerable information.
Administers all database objects, including tables, clusters, indexes, views and sequences, packages and procedures.
Assists with impact analysis of any changes made to database objects.
Evaluates releases of MS SQL Server and its tools, and third party products to ensure that the organization is running the products that are most appropriate.
Troubleshoots issues associated with databases, applications and development tools and provides technical support to application development teams.
On-call rotation is required to support 24/7 environment and is also expected to be able to work outside business hours to support corporate needs.
Performs other duties as assigned.
Minimum Skills


Minimum Knowledge and Abilities

Strong knowledge of MS SQL Server database administration in Windows and virtual environments.

Possess knowledge of performing detailed performance analysis and resource utilization of systems.

Experience with backups, restores and recovery models.

Knowledge of High Availability (HA) and Disaster Recovery (DR) options for SQL Server.

Experience working with Windows server, including Active Directory.

Experience and knowledge in migrating code and database changes through the various stages of the development life cycle.

Moderate troubleshooting and performance tuning skills.

Working knowledge of project management concepts, tools and techniques.

Strong ability to organize information, manage tasks and use available tools to effectively contribute to a team and the organization.

A valid Class C driver’s license with a history of a safe driving record in accordance with CPS policies, procedures, safety standards, and applicable laws and regulations.

Makes independent recommendations.

Proficient in Microsoft Office Package, including word processing, spreadsheets, database, presentation software, electronic mail and scheduling.Preferred Qualifications

Master’s degree in Information Systems or related field from an accredited university.

Image MCTS, MCITP, and/or MVP certifications a plus.
Utility Industry experience.
Competencies

Demonstrating Initiative

Communicates Effectively

Serving Customers

Learning Quickly

Using Computers and TechnologyMinimum Education

Bachelor's Degree in Information Systems, Engineering, Computer Science, or related field from an accredited university.Required Certifications


Working Environment

Indoor work, operating computer, manual dexterity, talking, hearing, repetitive motion. Use of personal computing equipment, telephone, multi-functioning printer and calculator.

Ability to travel to and from meetings, training sessions or other business-related events. After hours will be required. Overnight travel may be required.Physical Demands

Exerting up to 10 pounds of force occasionally, and/or a negligible amount of force frequently or constantly to lift, carry, push, pull or otherwise move objects, including the human body.

Sedentary work involves sitting most of the time. Jobs are sedentary if walking and standing are required only occasionally, and all other sedentary criteria are met.

CPS Energy does not discriminate against applicants or employees. CPS Energy is committed to providing equal opportunity in all of its employment practices, including selection, hiring, promotion, transfers and compensation, to all qualified applicants and employees without regard to race, religion, color, sex, sexual orientation, gender identity, national origin, citizenship status, veteran status, pregnancy, age, disability, genetic information or any other protected status. CPS Energy will comply with all laws and regulations.



#IN_TECH


Similar Jobs

Trending Jobs

company-logo

Nuclear Technical Intern - Mid Atlantic

Constellation
Job TypeInternship
 
Lusby, MD
24 days ago
company-logo

Apprentice Lineman

Brink Constructors, Inc.
Job TypeFull-time
 
Rapid City, SD
23 days ago
company-logo

Deckhand (Houston)

John W. Stone Oil Distributor, LLC
 
Houston, TX
24 days ago
company-logo

Electrical Engineer

Dudley Staffing
Job TypeFull-time
Salary
$55 - $75
Canonsburg, Pennsylvania
3 months ago
company-logo

Director, Financial Planning & Analysis - Energy (Enterprise)

Pilot Thomas Logistics
Job TypeFull-time
 
Grapevine, TX
24 days ago
company-logo

Quality Engineer

Jedco Inc.
Job TypeFull-time
 
Grand Rapids, MI
18 days ago
company-logo

Solar Electrician

MN8 Energy
Job TypeFull-time
 
California, United States
22 days ago
company-logo

Sr. Polymer Scientist

ExxonMobil
Job TypeFull-time
 
Baytown, TX
22 days ago
company-logo

Gas Foreman

Peak Utility Services Group
Job TypeFull-time
 
Lawton, OK
23 days ago
company-logo

Apprentice Lineman I

San Patricio Electric Cooperative, Inc.
Job TypeFull-time
 
Sinton, TX
8 days ago
company-logo

Apprentice Line Worker I

Tampa Electric
Job TypeFull-time
 
Ruskin, FL
about 1 month ago
company-logo

Finishing Helper Entry Level- Dayshift

Bonnell Aluminum
Salary
$41600 - $41600
Carthage, TN
18 days ago
company-logo

contract landman

HPS Oil & Gas Properties
Job TypeFull-time
 
Lafayette, Louisiana
about 2 months ago
SD

Service Manager

Supertech Diesel Truck Specialists
Job TypeFull-time
 
Langley, BC
21 days ago
company-logo

Meter Technician

ONEOK
Job TypeFull-time
 
Odessa, TX
24 days ago
company-logo

Apprentice Power Lineman

Proline Power Corp.
Job TypeFull-time, Apprenticeship
 
Red Deer, AB
28 days ago
SD

Service Manager

Supertech Diesel Truck Specialists
Job TypeFull-time
 
Nanaimo, BC
21 days ago
company-logo

Senior Landman

Greenlake Energy
Job TypeFull-time
 
Austin, Texas
15 days ago
company-logo

Senior Investigator

Dominion Energy
Job TypeFull-time
 
Norfolk, VA
24 days ago
company-logo

Assembler/Production

Uptalent
Job TypeContract
Salary
$37440 - $49920
Oklahoma City, OK
17 days ago