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 pr...