Database Administrator

barrowwise; New York (NY); On-site; USD 120,000 - 180,000; Full time

Job summary

Barrow Wise Consulting, LLC seeks an experienced Database Administrator for its NYC-based project with the NYC Department of Social Services. You will design and maintain databases, implement secure data exchanges, and optimize performance.

Collaborate with .Net and Java teams, develop complex queries, and ensure robust security controls. On-site in NYC, with a focus on reliability and scalable data warehousing.

Qualifications

• Bachelor's degree required in a related field.
• 4+ years with Cúram V6 and related components.
• 4+ years in Curam Certified Developer experience in architecture.
• 4+ years of experience with HTML, JavaScript, and open-source Java frameworks.
• 4+ years of experience with Oracle, SQL Server, and ETL/BI tools.
• 4+ years of experience with UNIX/Linux environments and scripting.

Responsibilities

• Design, develop, and oversee the maintenance of system databases.
• Build data exchange processes between NYC agencies with secure file transfer.
• Tune database objects to address performance issues and optimize queries.
• Develop database services for .Net and Java application teams.
• Create complex queries addressing diverse business requirements.
• Provide on-site DBA support in NYC.

Skills

Database design

Performance tuning

Data warehousing

Security management

Team collaboration

Education

Bachelor's degree in Computer Science/Information Technology/Computer Engineering

Tools

Oracle 9i/10g/11g

SQL Server 2000/2012

DB2 UDB

Sybase 12.5

Oracle DataStage Infosphere

Unix Cron Tab

TOAD

SSIS/SSRS

WebSphere

JIRA

Job description

Enjoy problem-solving, need a venue to display your creativity, and emerging technologies pique your interest; if so, Barrow Wise Consulting, LLC is for you. As a multi-disciplined leader, you understand the gifts that set you apart from everyone else. Demonstrate innovative solutions to our clients. Join Barrow Wise Consulting, LLC today.

Responsibilities

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 like Table, View, Index, Package, Procedure, Function, and Materialize View for the system (OLTP), IBM DataStage ETL process for Data warehouse system (OLAP)
• Build data exchange process between different New York City agencies with secure file transfer (Crush FTP), Job Scheduler (Unix Cron Tab), ETL Process (IBM Infosphere DataStage, Oracle, and SQL Server)
• Tune database objects to address performance issues using DB advanced functions, Hints, Indexes, Explain Plan, Tkprof, and other mechanisms.
• Develop database services for .Net, IBM Curam Java application team
• Create complex queries involving DB 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, Azur, Oracle Cloud), DB Tools, and Job Scheduling Tools (Autosys, ControlM, Cron Tab)
• Prepare flow charts and diagrams to illustrate a 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 Specifications documents
• Build and maintain data warehouse components for operations and management reporting
• Responsible for DBA activities like installing and configuring database software, creating database schema, creating security structure, building schema, data archival, table partitioning, monitoring system performance, code deployment, etc
• Responsible for various application support activities, which include system migration, maintenance, and testing bug fixes in a production environment
• Provide comprehensive support to internal customers; achieve resolution to outstanding problems or issues
• Work on-site in NYC

An ideal candidate has the following

• 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 working in the technical architecture field
• 4 Years of experience with HTML, DHTML, JavaScript, open-source Java framework (Struts/Springs), Ajax (JQuery, Dojo), SOA, and web services
• 4 Years of experience with Websphere, 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, SSMA, 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

Join the team at Barrow Wise Consulting, LLC, for a fulfilling and engaging experience! Our team is dedicated to providing innovative solutions to our clients in an ethical and diverse work environment. 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.

Our employees stand behind Barrow Wise's core values of integrity, quality, innovation, and diversity. We are confident that Barrow Wise's core values, business model, and team focus create positive career paths for our employees. Barrow Wise will continue to lead the industry in delivering new solutions to clients and persevere until the client is overjoyed.