Database Administrator Consultant

Title: [[extTitle]] Company : [[filter4]] Location: [[reqphysicallocation]] State and City: [[filter1]] - [[filter2]] Shift: [[jobSchedule]] Hiring Manager: [[hiringManagerName]] Recruiter: [[recruiterName]] 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