Provide architectural leadership and guidance on the design, installation, configuration and operation of databases (Oracle 10g moving to 11g) for Tier-1 CEMP applications. This individual will be embedded within the delivery team and will participate in the evolution of systems from concept to design to delivery to production support. Will be responsible for ensuring the ongoing health of databases by collecting key metrics and leveraging various operational support organizations (e.g., Tier 1-3, DB Operations, Storage Operations, Network Operations, Security Operations and System Administration Operations) to resolve critical issues. Responsibilities will span application design (e.g. table, queries, indexes, etc), database design (e.g. clustering, storage infrastructure, high availability, etc), and operational design (e.g. monitoring, scheduled maintenance activities, capacity planning, etc), and will, again, leverage relationships with various support organizations to ensure optimal design, performance and stability. DBA-level proficiency with database technologies is required to be successful in this role. The job includes carrying a pager on a rotational basis involving all aspects of database management for Oracle instances in a 24/7 operations environment. As strategic sourcing alternatives are implemented routine administrative response will be covered by others. This role requires a strong understanding of the database structure, theories, principles and practices, as well as having experience in providing high levels of data availability, scalability and security for a large transaction environment. This is an extremely fast paced, technical work environment.
Major Duties:
-Be the single point of contact for the group for all cross-organization database-related initiatives, including executive reviews enterprise architecture initiatives and operations audits.
-Collaborate with the delivery team to ensure that database designs (DDL) and application code (DML) are optimal from a performance, maintainability and stability perspective.
-Create, organize, distribute and summarize key database performance and stability metrics, leveraging other operational support teams, and actively manage all open issues to successful resolution.
-Table designs, triggers, indexes, partitions, etc
-SQL queries, PLSQL programs, etc
-Database archiving and purging policies, practices and scripts
-Database, Storage Array and Network capacity, performance and high-availability
-Maintain the complete inventory of group-wide physical databases, logical entity-relationship diagrams and related data dictionaries to accurately capture data structures, data and application context.
-Contribute to the overall strategic roadmap for the group, in terms of logical, functional and physical application database designs, and the adoption of new database technologies or practices.
-Ensure optimal processes and communications between the delivery teams and the operational support teams to ensure proper planning and design, timely construction and on-going availability of databases.
-Fulfill a Tier 3 support role when there are database-related Production issues, up to and including managing operational support resources on the bridge to resolve critical issues.
-Manage the production databases including monitoring, planning, tuning, backups, data archival, and restores.
-Maintain a log of Production issues with root cause analysis and recommendations to address gaps in database design or configuration, application design or operational support.
-Acquire and maintain a thorough functional knowledge of the Comcast Digital Voice, Video, Wireless Data Card and High Speed Data applications/implementations
