Principal Database Architect (50054520 - Herndon, VA at Comcast
Posted in Information Technology about 1 month ago.
Type: Full time
Location: Herndon, Virginia
CET
EA&T
We are seeking business focused database technologist to work with the various technology teams. This position is responsible for the end-to- end design and development of database architectures including physical data modeling and database design, continuous improvement and optimization of current database with respect to monitoring, performance, availability, stability and reliability at Comcast.
Database Architecture is a key element of the Enterprise Architecture function at Comcast. Database Architecture is concerned with Physical Data Modeling and Initial Database Optimization, Performance Monitoring and Consultation, High-Availability Design including multi-master replication topologies, Database Security Design, Data and Database Standards Enforcement, Backup/ Recovery, ILM planning, Integration with ITIL services,etc . Under the guidance of the Chief Enterprise Database Architect, the enterprise data architect will participate in the definition, and creation of architecture 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. Specifically, the enterprise data architect will perform the following tasks on the Oracle platform, and equivalent tasks on other DBMS platforms including mySQL, MS SQL Server, etc., at Comcast:
- 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
- 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
- Work closely with the development teams to explore all areas of data persistence including caching technologies, in memory databases, columnar databases, etc.
- 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
Required Skills:
- Must be technically competent in databases, including Oracle 9, 10g, 11g, mySQL, MS SQL Server, Teradata, Vertica
- Must have experience in advanced features of Oracle including RAC, Golden Gate, Oracle Enterprise Manager, Compression, Materialized Views, Partitioning, Data Guard, Advanced Queuing, etc.
- 5+ years of core Oracle database administration experience including installation, monitoring, maintenance, etc.
- 3+ years of core database architecture (Oracle, MySQL, SQL Server) experience including designing for high availability, scalability, etc
- 2+ years of data modeling and/or application database design experience
- 2+ years of leadership or management experience
Must have strong understanding of physical database schema design for OLTP and analytical purposes, including relational and dimensional modeling,
database monitoring, performance management, capacity planning, database security, database scalability, and availability.
- Must have demonstrated leadership experience in designing and architecting database solutions.
- Candidates must excel in communication, design and delivery of complex database designs in very large data systems. S/he must be familiar with the strategies, concepts, rationale, challenges, and best practices of physical database modeling and design in a large high volume low latency environments.
- Must be technically competent in databases and directories (e.g. x.500, LDAP)
- Demonstrated technical competency of several data storage platforms (EMC, HP-UX, etc) and how constraints effect development and operations of systems.
- Demonstrated experience integrating data storage systems in multi-user, multi-platform, multitasking operating systems environments.
- Should have a basic understanding of web services (SOAP, WSDL, UDDI) and SOA architectures (ESB, BPM)
- Experience with Windows (for MS SQL Server), Solaris, Linux and HP UX
- Experience with storage replication technologies like (e.g. Veritas VVR, EMC SRDF, etc )
- Strong understanding of RAID technologies and their impact on database storage layers
- Relevant experience with large scale BSS/OSS implementations in a telecom company is preferred.
- Should have basic understanding customer-facing systems such as email, voicemail, web, and video services or the implications these outward facing systems have on end user experience.
- Ability to analyze, learn, and apply rapidly changing technologies and apply them as part of integrated solutions to business requirements.
- Ability to establish and maintain a high level of customer trust and confidence in the overall technology architecture, the architecture team's knowledge of and concern for customer requirements, and the change process to enhance the architecture.
- Ability to work with executives regarding
- technology issues.
- Ability to codify different approaches, strategies, and expectations into a unified architectural blueprint. Understands issues and details of integrating diverse technology to deliver scaleable, robust, and high performance solutions.
- Basic systems, network and telecommunications knowledge and solid systems design skills
Superior project management/consulting and leadership skills. Demonstrated ability to lead or facilitate complex, mission critical projects and to develop, participate in and lead multi-disciplinary work teams.
- Strong negotiation and group facilitation skills; ability to move a process forward, while meeting the needs of a variety of clients.
- Excellent managerial skills; collaborative, imaginative, resourceful, reliable, technically savvy.
- Excellent oral, written, and presentation communication skills.
Bachelor's degree in Computer Science, Engineering, or related discipline, or equivalent. Master's degree desirable
- Oracle Certification (Oracle 11g DBA OCM, OCP)
- MS SQL Certification (MCDBA, MCM)
- MySQL Certification
Physical Job Requirements:
Standing, Bending, Manual Dexterity-Use of hands, Pedal Dexterity-Use of feet, Ability to Travel, Walking, Sitting, Communicative Skills
To Apply:
Signup for an account or login to get information on applying for a job.
