We are currently looking a Sr. Database Engineer / DB2 - NYC
This position requires a senior level, hands-on database engineer. The ideal candidate will have a diverse background in database technologies and the architecture, design, development and optimization of large scale database implementations. The candidate will have a firm grasp of the various database architectures for OLTP, ODS and Data Warehouse databases and be able to identify and select architectural approaches that support high levels of availability, scalability, data integrity and performance. The candidate will possess an ‘end-to-end’ understanding of data management, enabling an appreciation of the infrastructure impact of database design decisions. Additionally, the candidate will have a breadth of experience working with application architects and engineers to optimize application data access methods. The candidate must possess the excellent communication and presentation skills that are required for socializing technical concepts and building consensus, as well as excellent problem-solving and teaming skills.
Responsibilities: • Perform hands-on database engineering tasks in the development of OLTP databases • Perform capacity planning activities as related to database storage, CPU, memory and network utilization • Optimize the database environments with respect to data access methods, access performance, storage, data integrity, system performance and system availability • Work closely with data modelers to assist with the conversion of logical models to physical models • Work closely with data warehouse developers to optimize for, and efficiently integrate with Informatica ETL platform • Work closely with application developers to optimize data access and integrate the database platforms with application server environments • Work closely with the technical infrastructure staff to optimize and integrate the database platforms with the storage subsystems • Develop stored procedures and shell scripts to automate data feeds from the source systems into the data warehouse • Develop DB monitoring utilities based on DB2 Snapshot data • Liaise with database vendors and external support on issues such as upgrades, technical problems and solutions • Develop and test database backup, restore and disaster recovery plans and procedures • Provide technical support to developers in the development of stored procedures/triggers/functions. • Document database environments and processes Required Skills and Experience: • 10+ years of database administration experience with DB2 for z/OS with extensive current experience with DB2 v8 • 5+ years of solid relational database administration and engineering on MPP database systems • 5+ years experience with DB2 Data Propagator experience including customization and performance and tuning • Proven experience in designing and configuring databases that scale in the terabyte range • Excellent experience with DB2 utilities, including DB2 Loader • Expert performance tuning skills for large MPP and non-partitioned databases • Excellent understanding of the effects of normalization and denormalization on data integrity and performance • Excellent SQL coding skills • Proficient with JCL • Experience with third-party products, e.g., Omegamon for DB2, Quest Central for DB2, Strobe • Excellent experience with Workload Management and Stored Procedure Access Space • Strong experience with DB2 Connect Gateway. Must possess architecture, performance tuning and troubleshooting experience • Strong experience writing and optimizing COBOL Stored Procedures • Strong experience accessing VSAM data with DB2 • Proficient with SPUFI • Solid understanding of dimensional data modeling, star and snowflake schemas • Excellent analytical ability, strong consultative and communication skills • Ability to work in a team environment • College degree in computer science/related fields from a recognized university with a strong engineering and/or math pedigree, or equivalent experience Required Management Skills: • Excellent verbal and written communication skills, as well as organizational skills • Experience with project management software • Ability to manage multiple high priority projects simultaneously
Highly Desirable Skills: • 5+ years experience with DB2 UDB ESE with current experience on v8.2 • 1 year+ experience with Informatica PowerExchange 7.x • 1 year+ experience with ChangeMan • 1 year+ experience with Telelogic Synergy
370 7th Avenue, 4th Floor
New York, NY 10001