Title Principal Architect
Cablevision Division Cablevision Corporate
Department Name EIT-Architecture
Job Location NY / Nassau County / 1111 Stewart Avenue
Requisition ID 18990BR
Position Type Full Time
Description The successful applicant will be responsible for identifying database technologies that will keep the Enterprise IT department a proactive participant in business critical technology solutions, and will become new standards for the enterprise. The Architect will be responsible for proving out those technologies through hands-on proofs of concept; defining best practices for relational and non-relational databases; assisting the Data Warehouse and Database Administration teams with the planning and designing of relational, non-relational and big data" database systems; and reviewing both database-centric and non-database centric projects for adherence to Enterprise Architecture Standards.
The Architect will define and implement new database reference architectures and document them fully, including new standards for RDBMSs, DBaaS, and NoSQL databases such as MongoDB, Cassandra, and Hadoop. The candidate must have the ability to define reference architectures, develop written specifications, install and configure the underlying technologies independently, develop, document and execute test cases, make recommendations supported by findings, develop and execute operational readiness tests, and fully document the configurations, tests, results and recommendations. Must have the ability to work with database administrators, and present to technical executive-level management.
While this position is database-centric, the candidate must also have the ability to review proposed project implementations for adherence to Architecture Standards, and write Architecture Reviews and Recommendations based on findings. This work will be done independently or in conjunction with other Architects.
Qualifications . Excellent interpersonal, oral, written and presentation skills required. Proven ability to develop and maintain relationships with decentralized technology and business unit management and staff, as well as major industry vendors.
. Expert knowledge of and extensive experience with Oracle RDBMS is required, including its architecture, administration, backup/recovery (RMAN) and performance tuning. Oracle Enterprise Manager Grid Control and Oracle Internet Directory (OID) a plus.
. Familiarity with emerging commercial and/or open source database technologies (such as MariaDB, PostgreSQL, NoSQL), and data warehouse appliance architectures. Netezza experience a plus.
.Ten or more years of experience as an Oracle DBA and expert in the use of SQL and PL/SQL. Experience with MicroStrategy, Informatica, and real-time heterogeneous database replication technologies (GoldenGate, SharePlex) desired.
. Five or more years of experience with various database design architectures including OLTP, OLAP, and ROLAP.
. Two or more years of experience in the implementation and support of Oracle Real Application Clusters (RAC).
.Two or more years of experience in the administration of Microsoft SQL Server.
.Experience working with VLDB (Very Large Data Base) architectures a plus (5TB or above).
.Solid understanding of server and storage technologies (SAN, NAS, iSCSI, etc.), and database backup strategies.
.Proven ability to document complex systems, infrastructure and process flows, using Microsoft Visio and Microsoft Office tools.
We are an Equal Opportunity Employer and maintain a drug-free and smoke-free workplace.