Database Administrator

The Database Administrator will support Barrow Wise's NYC Department of Social Services project and perform the following duties:

• Design, develop, and oversee the maintenance of system databases
• Design, develop, and maintain Oracle 12c and SQL Server database objects such as tables, views, indexes, packages, procedures, functions, and materialized views for the system (OLTP), and IBM Data Stage ETL process for the data warehouse system (OLAP)
• Build data exchange processes between different New York City agencies with secure file transfer (Crush FTP), job scheduler (Unix Cron Tab), and ETL processes (IBM Infosphere Data Stage, Oracle, and SQL Server)
• Tune database objects to address performance issues using advanced DB functions, hints, indexes, explain plans, Tkprof, and other mechanisms
• Develop database services for .Net and IBM Curam Java application teams
• Create complex queries involving advanced analytical functions, joins, and correlated sub‑queries to address diverse business requirements
• Design and develop software systems using scientific analysis and mathematical models to predict and measure outcomes and design consequences
• Implement and maintain database user control and security mechanisms using user permissions, roles, and OS user controls
• Periodically evaluate and recommend the latest proprietary and open‑source database products, cloud solutions (AWS, Azure, Oracle Cloud), DB tools, and job scheduling tools (Autosys, Control
  
  M, Cron Tab)
• Prepare flow charts and diagrams to illustrate the sequence of steps the program must follow and to describe logical operations involved using MS Visio
• Prepare and present conceptual, logical, and physical data models and data architecture using the Erwin data‑modeling tool
• Prepare technical and functional specification documents
• Build and maintain data warehouse components for operations and management reporting
• Perform DBA activities such as installing and configuring database software, creating database schemas, building security structures, table partitioning, data archival, monitoring system performance, code deployment, etc.
• Provide application support activities, including system migration, maintenance, and testing bug fixes in a production environment
• Provide comprehensive support to internal customers; achieve resolution of outstanding problems or issues
• Work on‑site in NYC

• U.S. Citizenship
• Bachelor’s degree in Computer Science, Information Technology, Computer Engineering, or a related field
• 4 years Cúram V6, Cúram Enterprise Framework Components, Cúram Intelligent Evidence Gathering (IEG2), Cúram Express Rules for Triage (CERT)
• 4 years of Curam V6 Certified Developer experience in the technical architecture field
• 4 years of experience with HTML, DHTML, JavaScript, open‑source Java framework (Struts/Spring), Ajax (JQuery, Dojo), SOA, and web services
• 4 years of experience with Web Sphere, ESB or Message Broker, Eclipse, JIRA, Webservice, and Oracle
• 4 years of experience with Oracle 9i, 10g, 11g, Sybase 12.5, SQL Server 2000/2012, DB2 UDB
• 4 years of experience with SQL, PL/SQL, UNIX shell scripting
• 4 years of experience with MS Visio, Star Schema modeling, and Snow Flake modeling
• 4 years of experience with SQL
  * LOADER, SQL Developer, TOAD, SQL
  * PLUS, DBArtisan, Perforce, PVCS, SSMA, RGS, SSIS, SSRS
• 4 years of experience with Business Objects X, XI, Oracle Reports, BM Cognos Version 10.2.2
• 4 years of experience with Linux, UNIX, Windows 2003/2000/NT

We offer competitive compensation packages, excellent benefits, and opportunities for growth and advancement.

Barrow Wise is an equal opportunity, drug‑free employer committed to diversity in the workplace. Minority/Female/Disabled/Protected Veteran/LBGT are welcome to apply.