Title: Database Administrator Consultant
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: 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.
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