Designs and builds relational databases. Develops strategies for data acquisitions, archive recovery, and implementation of a database. Cleans and maintains the database by removing and deleting old data. Must be able to design, develop and manipulate database management systems, data warehouses and multidimensional databases. Requires a depth and breadth of database knowledge that will help with formal design of relational databases and provides insight into strategic data manipulation. Database Architect capabilities with 6+ years of experience, independently designs and builds relational databases. Develops strategies for data acquisitions, archive recovery, and implementation of a database. Cleans and maintains the database by removing and deleting old data. Familiar with a variety of the field's concepts, practices, and procedures. Relies on extensive experience and judgment to plan and accomplish goals. Performs a variety of tasks. A wide degree of creativity and latitude is expected.
This position will participate in a feasibility study for the Department of Safety and Professional Services, to document the data structures for their two largest business systems, ICE and Regulated Objects, and then make recommendations for a future road map for the two applications (which could include integration, redesign, or COTS solution). The position will work with a business analyst, who will be responsible for documenting the business functionality for each application. Technical platforms and integration with other applications will also be documented.
Administration - Business Analysis
Gather and document requirements 5+ Yrs.
Interview subject matter experts 3+ Yrs.
Select, synthesize and organize pertinent information to meet user needs 5+ Yrs.
Working directly with business users 3+ Yrs.
Administration - Business Writing
Prepare written reports * 5+ Yrs.
Ability to be self directed 8+ Yrs.
Ability to work independently utilizing critical thinking and discretionary decision-making skill se 8+ Yrs.
Excellent organization, analytical, and communication skills
Information Technology - Databases
Data analysis * 6+ Yrs.
Data Flow & Structure Modeling * 6+ Yrs.
Data structure diagrams 6+ Yrs.
Identify high-level business rules for data model 6+ Yrs.
Knowledge of Oracle PL/SQL * 6+ Yrs.
Logical database design * 6+ Yrs.
Oracle * 6+ Yrs.
Physical database design * 6+ Yrs.
Validate conceptual and logical model with customer 6+ Yrs.