Database Administrator
EmergencyMD
- New York, New York, United States
- New York, New York, United States
À propos
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 DataStage ETL processes for the data warehouse system (OLAP)
Build data exchange processes between different New York City agencies with secure file transfer (Crush FTP), job scheduling (Unix Cron Tab), and ETL processes (IBM Infosphere DataStage, Oracle, and SQL Server)
Tune database objects to address performance issues using advanced 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 permissions, roles, and operating‑system user controls
Periodically evaluate and recommend the latest proprietary and open‑source database products, cloud solutions (AWS, Azure, Oracle Cloud), database tools, and job scheduling tools (Autosys, ControlM, Cron Tab)
Prepare flow charts and diagrams to illustrate the sequence of steps the program must follow and to describe logical operations 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, creating security structures, building schemas, data archival, table partitioning, monitoring system performance, and code deployment
Perform application support activities, including system migration, maintenance, and testing bug fixes in a production environment
Provide comprehensive support to internal customers and achieve resolution to outstanding problems or issues
Work on‑site in NYC
Qualifications:
U.S. citizenship
Bachelor’s degree in Computer Science, Information Technology, Computer Engineering, or a related field
4 years of experience with Cúram V6, Cúram Enterprise Framework Components, Cúram Intelligent Evidence Gathering (IEG2), and Cúram Express Rules for Triage (CERT)
4 years of experience as a Cúram V6 certified developer in technical architecture
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, web services, 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, and 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, SSIS, and SSRS
4 years of experience with BusinessObjects X, XI, Oracle Reports, and BM Cognos version 10.2.2
4 years of experience with Linux, UNIX, and 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, and LGBT applicants are welcome to apply.
#J-18808-Ljbffr
Compétences linguistiques
- English
Avis aux utilisateurs
Cette offre provient d’une plateforme partenaire de TieTalent. Cliquez sur « Postuler maintenant » pour soumettre votre candidature directement sur leur site.