Sr. Database Administrator, Progression

Title: Sr. Database Administrator, Progression

Company : Tampa Electric Company

Location: Bearss Operations Center

State and City: Florida - Tampa

Shift: 8 Hr. X 5 Days

Hiring Manager: Nathan Campbell

Recruiter: Mark Koener

TITLE: Sr. Database Administrator, Progression

PERFORMANCE COACH: Manager, Application Development & Support (AD&S)

COMPANY: Tampa Electric, TECO Services Inc.

DEPARTMENT: Information Technology & Telecommunications/Enterprise & Business Solutions

POSITION CONCEPT

Designs, implements, and maintains all components of Database Management Systems (DBMSs). Responsible for planning, organizing, coordinating, and monitoring database–related projects and maintenance activities. Develops and implements database strategies that support corporate-wide access to business data.

Please note that this position can be hired at any level within the job family progression, but ideally at this time, we are seeking to fill it at the Sr. level.

TITLE: Associate Database Administrator

REPORTS TO: Manager, Application Development & Support (AD&S); Lead Database Administrator

Entry-level Database Administrator (DBA) position that supports a limited number of databases with frequent supervision.

PRIMARY DUTIES AND RESPONSIBILITIES

1. Perform database-related activities in support of development projects or off-the-shelf software implementations. Identify opportunities to reduce data-redundancy and utilize single sources of data.

2. Support systems development staff in understanding application data requirements and developing logical database models. Convert logical database designs to physical database models and develops the Data Definition Language (DDL) to create appropriate database objects.

3. Implement appropriate database backup and recovery strategies with oversight from more senior DBA staff. Perform database recovery and restoration as instructed.

4. Provide on-call support to troubleshoot database problems on a twenty-four hours a day, seven days a week basis. Participate with other members of the Database Administration (DBA) staff in ensuring primary and secondary/backup support is always available for critical TECO Energy databases.

5. Perform database monitoring and tuning activities to ensure optimal performance and response time. Provide support to systems development staff (and others performing similar functions outside of IT) in efficient SQL coding techniques for optimum database and application performance.

6. Maintain knowledge of existing and emerging database technologies. Maintain sufficient knowledge of TECO Energy business processes and systems.

7. Participate in upgrades to DBMSs including impact analysis, testing, data conversion, and implementation.

8. Participate in data integration tasks for application-specific data access and data warehousing.

9. Enforce database standards and procedures for primary DBMS products in use at TECO Energy.

10. Maintain requisite knowledge of all standard operating systems in use at TECO Energy necessary to perform the DBA function.

SUPERVISION

Direct Supervision: None

Indirect Supervision: None

RELATIONSHIPS

Key Internal: Interacts with company employees at all levels and frequently interacts with other IT&T support groups/personnel.

Key External: May interact with hardware and software vendors, contractors, and external consulting firm personnel.

QUALIFICATIONS

Education

Required: Bachelor’s degree in Computer Science, Management Information Systems, or a related discipline is required.

Preferred: N/A

Licenses/Certifications

Required: None

Preferred: Holds an industry-level database administration certification from Microsoft or Oracle.

EXPERIENCE

Direct Experience

Required: A minimum of four years of direct work experience in database administration is required, however other IT experience may be considered in lieu of specific DBA experience.

Preferred: N/A

Related Experience

Required: N/A

Preferred: N/A

Supervisory Experience

Required: N/A

Preferred: N/A

Knowledge/Skills/Abilities (KSA)

See the “Technical Skills Matrix” for specific required technical skills for this position.

Required: Experience with Microsoft SQL Server or Oracle RDBMS.

Preferred: N/A

WORKING CONDITIONS

Working in an office environment

TITLE: Database Administrator

REPORTS TO: Manager, Application Development & Support (AD&S); Lead Database Administrator

PRIMARY DUTIES AND RESPONSIBILITIES (in addition to those of Associate Database Administrator)

1. Perform database-related activities during application system evaluations and subsequent implementations. Identify opportunities to reduce data-redundancy by integration of systems through database design and access methods.

2. Review, test, and recommend appropriate revisions to vendor-supplied DDL to ensure database integrity.

3. Design and implement appropriate database backup and recovery strategies based on requirements provided by systems development personnel and IT Business Partners with oversight from more senior DBA staff. Perform database recovery and restoration as needed.

4. Plan and perform database monitoring and tuning activities to ensure optimal performance and response time.

5. Perform upgrades to DBMSs including impact analysis, testing, data conversion, and implementation.

6. Participate in data integration tasks for application-specific data access and data warehousing and promote the appropriate use of integration products by systems development staff and Business Partners.

EXPERIENCE

Direct Experience

Required: A minimum of six years of direct work experience in database administration is required. Other IT experience as a Programmer or Systems Analyst may be considered in lieu of specific DBA experience.

Preferred: Previous experience as a Programmer or Systems Analyst preferred.

TITLE: Senior Database Administrator

REPORTS TO: Manager, Application Development & Support (AD&S); Lead Database Administrator

Supports multiple databases with limited direction. Competent to work in most phases of database management.

PRIMARY DUTIES AND RESPONSIBILITIES (in addition to those of Database Administrator)

1. Coordinate and prioritize work assignments based on business and technical requirements; may act as project lead within the Database Administration department.

2. Provide consulting and support to systems development staff (and others performing similar functions outside of IT) in efficient SQL coding techniques for optimum database and application performance. Considered an expert in Structured Query Language (SQL) for relevant DBMS products.

3. Maintain knowledge of existing and emerging database technologies and recommend adoption of new technologies where appropriate. Evaluate and recommend database-related products, services, and procedures to enhance productivity and effectiveness. Must maintain sufficient knowledge of TECO Energy business processes and systems.

4. Participate in projects that ensure the ongoing integrity of all corporate-wide databases and database architecture. Perform upgrades to DBMS and data integration products, including impact analysis, testing, data conversion, and implementation.

5. Implement and support data integration products for application-specific data access and data warehousing. Provide technical leadership in the appropriate use of integration products by systems development staff and Business Partners.

6. Enforce database standards and procedures for primary DBMS products in use at TECO Energy. Develop, implement, and maintain database standards and procedures for relevant DBMS products.

7. Maintain requisite knowledge of all standard operating systems in use at TECO Energy necessary to perform the DBA function.

EXPERIENCE

Direct Experience

Required: A minimum of eight years of direct work experience in database administration is required. Other IT experience as a Programmer or Systems Analyst may be considered in lieu of specific DBA experience.

Preferred: Previous experience as a Programmer or Systems Analyst preferred.

Knowledge/Skills/Abilities (KSA)

Required: Expert with Microsoft SQL Server or Oracle RDBMS.

Preferred: Working knowledge of an additional DBMS (DB2, Oracle, SQL Server)

TITLE: Database Administrator Consultant

REPORTS TO: Manager, Application Development & Support (AD&S); Lead Database Administrator

Supports multiple complex and business-critical databases with limited direction. Competent to work independently on all phases of database management.

PRIMARY DUTIES AND RESPONSIBILITIES (in addition to those of Senior Database Administrator)

1. Perform all database-related activities during application system evaluations, development projects, and subsequent implementations. Identify opportunities to reduce data-redundancy and utilize single sources of data with integration of systems through database design and access methods. Coordinate and prioritize work assignments based on business and technical requirements; may act as project lead within the Database Administration department. Mentor junior members of the Database Administration staff.

2. Support systems development staff in understanding application data requirements and developing logical database models. Convert logical database designs to physical database models and develop the Data Definition Language (DDL) to create appropriate database objects. Review, test, and make appropriate revisions to vendor-supplied DDL to ensure database integrity.

3. Design and implement appropriate database backup and recovery strategies based on requirements provided by systems development personnel and IT Business Partners. Perform database recovery and restoration as needed.

4. Provide on-call support to troubleshoot and resolve database problems on a twenty-four hours a day, seven days a week basis. Participate with other members of the Database Administration (DBA) staff in ensuring primary and secondary/backup support is always available for critical TECO Energy databases.

5. Plan and perform database monitoring and tuning activities to ensure optimal performance and response time. Provide consulting and support to systems development staff (and others performing similar functions outside of IT) in efficient SQL coding techniques for optimum database and application performance. Considered an expert in Structured Query Language (SQL) for the DBMS products they support.

6. Maintain knowledge of existing and emerging database technologies and recommends adoption of new technologies where appropriate. Evaluate and recommend database-related products, services, and procedures to enhance productivity and effectiveness. Must maintain sufficient knowledge of TECO Energy business processes and systems.

7. Participate in technical projects that ensure the ongoing integrity of all corporate-wide databases and database architecture. Perform upgrades to DBMS and data integration products, which include impact analysis, testing, data conversion and implementation.

EXPERIENCE

Direct Experience

Required: A minimum of ten years of direct work experience in database administration is required. Other IT experience as a Programmer or Systems Analyst may be considered in lieu of specific DBA experience.

Preferred: Previous experience as a Programmer or Systems Analyst preferred.

Knowledge/Skills/Abilities (KSA)

Required: Expert with Microsoft SQL Server or Oracle DBMS and working knowledge of an additional DBMS (DB2, Oracle, SQL Server) is required.

Preferred: N/A

TITLE: Lead Database Administrator

REPORTS TO: Manager, Application Development & Support (AD&S)

Competent to work independently at the highest level of all phases of database management. Supervises other members of the Database Administration team.

PRIMARY DUTIES AND RESPONSIBILITIES (in addition to those of Senior Database Administrator)

1. Perform all database-related activities during application system evaluations, development projects, and subsequent implementations. Identify opportunities to reduce data-redundancy and utilize single sources of data with integration of systems through database design and access methods. Coordinate and prioritize work assignments based on business and technical requirements; may act as project lead within the Database Administration department. Leads and supervises other members of the Database Administration staff.

2. Support systems development staff in understanding application data requirements and developing logical database models. Convert logical database designs to physical database models and develop the Data Definition Language (DDL) to create appropriate database objects. Review, test, and make appropriate revisions to vendor-supplied DDL to ensure database integrity.

3. Design and implement appropriate database backup and recovery strategies based on requirements provided by systems development personnel and IT Business Partners. Perform database recovery and restoration as needed.

4. Provide on-call support to troubleshoot and resolve database problems on a twenty-four hours a day, seven days a week basis. Participate with other members of the Database Administration (DBA) staff in ensuring primary and secondary/backup support is always available for critical TECO Energy databases.

5. Plan and perform database monitoring and tuning activities to ensure optimal performance and response time. Provide consulting and support to systems development staff (and others performing similar functions outside of IT) in efficient SQL coding techniques for optimum database and application performance. Considered an expert in Structured Query Language (SQL) for the DBMS products they support.

6. Maintain knowledge of existing and emerging database technologies and recommends adoption of new technologies where appropriate. Evaluate and recommend database-related products, services, and procedures to enhance productivity and effectiveness. Must maintain sufficient knowledge of TECO Energy business processes and systems.

7. Participate in technical projects that ensure the ongoing integrity of all corporate-wide databases and database architecture. Perform upgrades to DBMS and data integration products, which include impact analysis, testing, data conversion and implementation.

SUPERVISION

Direct Supervision: Members of the Database Administration team. May also supervise contractors.

Indirect Supervision: None

EXPERIENCE

Direct Experience

Required: A minimum of ten years of direct work experience in database administration is required. Other IT experience as a Programmer or Systems Analyst may be considered in lieu of specific DBA experience.

Preferred: Previous experience as a Programmer or Systems Analyst preferred.

Knowledge/Skills/Abilities (KSA)

Required: Expert with Microsoft SQL Server or Oracle DBMS and working knowledge of an additional DBMS (DB2, Oracle, SQL Server) is required.

Preferred: N/A

TECO offers a competitive Benefits package!!

Competitive Salary 401k Savings plan w/ company matching * Pension plan * Paid time off Paid Holiday time * Medical, Prescription Drug, & Dental Coverage *Tuition Assistance Program * Employee Assistance Program * Wellness Programs * On-site Fitness Centers * Bonus Plan and more!

#LI-SC1

Nearest Major Market: Tampa

Job Segment: DBA, Testing, Database, Systems Analyst, Data Warehouse, Technology