Posted: Friday, February 9, 2018 1:17 AM
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,300 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
Seeking an exceptional SQL DBA with expertise in database technology
Position will be open until filled
Administers database technology and systems 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.
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 2008 and 2012.
: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 c
• Location: San Antonio
• Post ID: 35576402 sanantonio