Comcast shapes the future at the intersection of media and technology. We create world-class experiences that people love and trust and drive innovation that builds value. We bring millions TV and Internet, entertainment, sports and news, communications and home management, theme parks, television and movies. Comcast brings to life the best of what's to come.
In this role you will take the lead on databases which contain all the vital information required to provision our customer accounts. You will take responsibility for the end-to- end design and development of database architectures including physical data modeling and database design, continuous improvement and optimization of current databases with respect to monitoring, performance, availability, stability and reliability at Comcast.
The Senior Database Architect will participate in the definition creation architectural artifacts associated with reference architectures, blueprints, patterns, information as a service, physical data and database models, standards, technical stacks, governance, and technology obsolesce planning and management.
Using the Oracle, SQL/mySQL platforms and servers you will:
Ensure proper monitoring and capacity planning framework is in place
Monitor Database Capacity and assist in growth estimations
Review database and SQL performance as part of the development lifecycle and provide support in resolving issues
Review physical data models, data access patterns, and database design as part of the development lifecycle
Work closely with development teams to identify any potential issues in their design or SQL
Work closely with development teams to ensure that the design/solution are appropriate
Work closely with the development teams to explore all areas of data persistence including caching technologies, in memory databases, columnar databases, etc.
Work closely with Operational teams or Operations DBA's to identify potential issues in production and guide them to the conclusion or resolution.
Review weekly database capacity and performance reports ensuring ongoing health of database design.
Provide a final health checks as part of database deployments to ensure that database is ready for release, this will include Database structures (indexes, statistics, etc) Ensure proper capacity and performance of (memory, CPU, disk space, and I/O performance)
Ensure proper database configuration parameters, i.e. Oracle init.ora
Ensure monitoring criteria and thresholds is properly setup
Requirements:
5+ years of core Oracle database administration experience including installation, monitoring, maintenance, etc.
3+ years of core database architecture (Oracle, MySQL, SQL Server)
3+ experience including designing databases for high availability, scalability, environments
2+ years of data modeling and/or application database design experience
2+ years experience working with RAC, Golden Gate, Oracle Enterprise Manager, Manager, Compression, Materialized Views, Partitioning, Data Guard, Advanced Queuing, etc.
Technical Experience with the following:
Data storage platforms (EMC, HP-UX, etc)
Oracle 9, 10g, 11g, mySQL, MS SQL Server, Teradata, Vertica
Databases and directories (e.g. x.500, LDAP)
Web services (SOAP, WSDL, UDDI) and SOA architectures (ESB, BPM)
Windows (for MS SQL Server), Solaris, Linux and HP UX
Storage replication technologies (e.g. Veritas VVR, EMC SRDF, etc
RAID technologies and their impact on database storage layers
big data technologies such as Apache Hadoop, Cassandra, Couldera or Mongo DB
Do you?
Have a strong understanding of physical database schema design?
Understand relational and dimensional modeling, database monitoring, performance management, capacity planning, database security, database scalability availability?
Have experience steering design and architecture database solutions?
Do you know the strategies, concepts, rationale, challenges, and best practices of physical database modeling and design in a large high volume low latency environments?
Have you architected Virtual DB enterprise solutions?
Have you integrated data storage systems in multi-user, multi-platform, multitasking operating systems environments?
General Requirements:
Bachelor's degree in Computer Science, Engineering, or related discipline, or equivalent (Master's degree desirable)
Excellent oral, written, and presentation communication skills
Strong negotiation and group facilitation skills
Highly Desirable:
Telecom industry
Comcast is an Affirmative Action/EEO employer M/F/D/V
