Database Architect

Must have working knowledge of more than one relational database system, such as Oracle, DB2, Sybase, Informix, Access and NOSQL such as MongoDB and others Have good understanding of architectural patterns and alignment with Enterprise Architecture and customer Vision Must have good communication and team oriented skills Must have Active IRS MBI

Leads and plans complex database design, development, implementation, administration, tuning, ETL, and backup and recovery Write up to 5000 lines of complex database code in one package Works with Team Leads, database team members, software engineers and system administrators on design, development and support issues Coaches and mentors other database team members Job duties include requirements gathering, design and maintenance documentation, following CM processes and working with other Team members Install and upgrade Oracle Create and maintain development, test, and production databases Create users, tables, tablespaces, triggers, and stored procedures Develop SQL, PL/SQL, and Unix shell scripts to automate DB tasks Duplicate existing databases Perform exports and imports Troubleshoot problems Implement cold and hot backup and recovery procedures Tune for performance Estimate space needed for new or expanded databases Have good understanding of architectural patterns and alignment with Enterprise Architecture and customer Vision May work directly with customer representative to obtain and refine functional requirements Satisfies requirements, meets agreed to completion date, and performs unit and integration tests for products developed Must have good communication and team oriented skills May work independently on specific projects