RESPONSIBILITIES INCLUDE:
•Designs and develops database structures and processes to satisfy critical business data requirements
•Analyzes business data requirements and design effective database/data warehouse solutions and/or analytical reports
•Assists development team on data integration and data warehouse projects
•Assist in the development of internal IT service architecture, including data integration, relational database management, and business intelligence services
Required
• At least 5 years experience in SQL server, PL/SQL
• 2-5 years of experience in database development, including development of data structures, stored procedures, and SQL DDL/DML.
• At least 5 years experience in large data file handling, experience, time variant data handling, partition maintenance, materialized views and query
• At least 5 years experience in DBA (creation and maintenance of the database, DDL/DML, back-up/restore strategy, replication strategy) and Data developer (creating stored procedures, triggers, supporting application development team
• Experience in performing operation DBA duties is a plus
Preferred
• Bachelor's Degree
• At least 2 years of experience in writing DAO classes in Java is preferable
• At least 8 years experience in SQL server, Oracle, PL/SQL
• At least 8 years experience in large data file handling, experience with insert only systems, time variant data handling, partition maintenance, materialized views and query
• At least 8 years experience in DBA (creation and maintenance of the database, DDL/DML, back-up/restore strategy, replication strategy) and Data developer (creating stored procedures, triggers, supporting application development team
• At least 1 year experience in data modeling concepts (and IDA tool) and rational products
• At least 1 year experience in Informatica and ETL concepts
• At least 1 year experience in Application Clustering development
• At least 1 year experience in AGILE iterative development experience and the ability to create technical documentation content and templates