Wednesday, July 30, 2014

Comcast - Oracle Database Architect

Comcast strives to hire the best and the brightest for our rapidly growing technical teams. We are currently looking for a Sr. Oracle Database Architect to support our Database team. In this role you would be directly employed by Comcast and would work in our Englewood, CO office. 

Here is a quick snap shot of what we are looking for:
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)
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 experience
 
Comcast is an Affirmative Action/EEO employer M/F/D/