Job Summary
- Company
- Comcast Cable West Division
- Location
- Englewood
- Industries
- Telecommunications Services
- Job Type
- Full Time
- Employee
- Years of Experience
- 1+ to 2 Years
- Education Level
- Bachelor's Degree
- Career Level
- Experienced (Non-Manager)
- Salary
- 0.00 - 0.00 USD /year
- Job Reference Code
- 55139410_310421937
Lead DBA
About the Job
West Division
* Design and maintain a shared SQL platform (both production and test) that services several applications and departments. Design should account for high availability and high performance across a large data warehouse, including active-active clustering and multisite failover. Monitor and optimize database performance through the creation of indexes, query tuning, and partitioning. Coordinate server and storage requirements with the Server Operations team.
* Create design documentation, configuration standards and operational procedures for the DBA team.
* Design and lead the team in the implementation of new database designs for application development, business intelligence and reporting departments.
* Assist in the analysis of business problems to create detailed requirements for new systems or system enhancements. Use requirements to develop detailed database specifications and designs. Design should include server, storage, partitions, table / entity relationships, indexes, security and disaster recovery.
* Responsible for the database environment, including monitoring for availability and performance, backup and recovery, growth projections, and security.
* Create SSIS packages and stored procedures for the routine import of data from several external sources, including Oracle and SQL databases. Tune packages for performance, monitor execution and ensure data integrity.
* Create and manage a variety of SQL Database jobs. Monitor the success and performance of daily tasks.
* Manage database security access. Manage security of sensitive data using encryption.
* Manage database backup and recovery process. Implement strategies for database redundancy, availability and performance.
* Follow change management procedures to test and implement new databases, SSIS packages, stored procedures, etc.
* Review and recommend new technologies to maintain teams position as technical leaders, and to address system issues. Incorporate new technologies into development standards. Train team members on the use of new technologies.
* Assist management in annual budgeting process, including software, hardware and staffing recommendations.
* Assist management in task assignment to ensure on-time project completion.
* Act as a committed team member to ensure a positive work environment and successful project / task completion.
* Works flexible hours as required, including participation in on-call rotation.
* Occasional travel required.
* Other duties as assigned by management.
* Punctual, regular, and consistent attendance.
Required Skills:
Education/Experience:
* Bachelor of Computer Science, related degree or equivalent experience required.
* Microsoft Certified Technology Specialist on SQL 2005 or 2008.
* Minimum of 5 years prior Microsoft SQL Server experience, including a strong understanding of relational database design, T-SQL, Analysis Services, high availability and SQL Reporting Services.
* Prior team leadership required, including both technical leadership and task assignment
* Familiarity with Oracle databases and data transformations between oracle and SQL.
* Demonstrated experience interpreting business requirements into technical requirements.
* Demonstrated understanding of software development lifecycle, and project management techniques.
Skills:
* Very strong communication skills (both written and verbal), including experience communicating with executive management.
* Highly motivated and takes responsibility for resolving business problems.
* Candidate must possess ability to quickly identify, analyze and recommend solutions to complex problems. Including the ability to troubleshoot high priority outages to quickly bring the issue to resolution.
* Uses strong personal organizational skills to efficiently handle multiple duties and remains flexible to the changing business needs.
* Design and maintain a shared SQL platform (both production and test) that services several applications and departments. Design should account for high availability and high performance across a large data warehouse, including active-active clustering and multisite failover. Monitor and optimize database performance through the creation of indexes, query tuning, and partitioning. Coordinate server and storage requirements with the Server Operations team.
* Create design documentation, configuration standards and operational procedures for the DBA team.
* Design and lead the team in the implementation of new database designs for application development, business intelligence and reporting departments.
* Assist in the analysis of business problems to create detailed requirements for new systems or system enhancements. Use requirements to develop detailed database specifications and designs. Design should include server, storage, partitions, table / entity relationships, indexes, security and disaster recovery.
* Responsible for the database environment, including monitoring for availability and performance, backup and recovery, growth projections, and security.
* Create SSIS packages and stored procedures for the routine import of data from several external sources, including Oracle and SQL databases. Tune packages for performance, monitor execution and ensure data integrity.
* Create and manage a variety of SQL Database jobs. Monitor the success and performance of daily tasks.
* Manage database security access. Manage security of sensitive data using encryption.
* Manage database backup and recovery process. Implement strategies for database redundancy, availability and performance.
* Follow change management procedures to test and implement new databases, SSIS packages, stored procedures, etc.
* Review and recommend new technologies to maintain teams position as technical leaders, and to address system issues. Incorporate new technologies into development standards. Train team members on the use of new technologies.
* Assist management in annual budgeting process, including software, hardware and staffing recommendations.
* Assist management in task assignment to ensure on-time project completion.
* Act as a committed team member to ensure a positive work environment and successful project / task completion.
* Works flexible hours as required, including participation in on-call rotation.
* Occasional travel required.
* Other duties as assigned by management.
* Punctual, regular, and consistent attendance.
Required Skills:
Education/Experience:
* Bachelor of Computer Science, related degree or equivalent experience required.
* Microsoft Certified Technology Specialist on SQL 2005 or 2008.
* Minimum of 5 years prior Microsoft SQL Server experience, including a strong understanding of relational database design, T-SQL, Analysis Services, high availability and SQL Reporting Services.
* Prior team leadership required, including both technical leadership and task assignment
* Familiarity with Oracle databases and data transformations between oracle and SQL.
* Demonstrated experience interpreting business requirements into technical requirements.
* Demonstrated understanding of software development lifecycle, and project management techniques.
Skills:
* Very strong communication skills (both written and verbal), including experience communicating with executive management.
* Highly motivated and takes responsibility for resolving business problems.
* Candidate must possess ability to quickly identify, analyze and recommend solutions to complex problems. Including the ability to troubleshoot high priority outages to quickly bring the issue to resolution.
* Uses strong personal organizational skills to efficiently handle multiple duties and remains flexible to the changing business needs.
Company Tools
Contact Information
Comcast Cable West Division
