Database Administrator (DB2)

Works on multiple projects as a project leader, or sometimes as a project advisor

Understands the principles, theories, practices and techniques of project management.

Providing assistance in the development of the conceptual and logical database design

Designing the physical data model

Developing and maintaining naming standards for RDBMS objects such as tablespaces, tables, indexes, views, and stored procedures

Defining and creating the RDBMS objects

Assisting application analysts in functional prototyping

Carrying out performance prototyping

Developing/scheduling batch jobs for database utilities

Developing backup/recovery procedures for application tables

Supporting application programmers in the design and testing of applications

Participating in the methodology design reviews

Providing technical assistance to other team members

Granting of appropriate authority to database objects

Reviewing and approving requested table changes for production

Assisting in product installation and defining initial installation options

Providing functional guidance to the system/application programmers and operations

Providing input to the organization's capacity planning function

Monitoring and tuning the database systems

Developing and implementing database administration policies and procedures

Evaluating and testing database related software and tools

Supporting databases ( DB2 z/OS, Oracle) development, QA, and production subsystems

Support after hour production installs

Setup or subscriptions for IBM CDC and Qrep along with monitoring of replication

Documentation of database related activities and strong team collaboration

Working knowledge for Oracle preferred but not required

Ability to solve database related problems and collaborate effectively with other IT disciplines

Possess multi-tasking skills and the ability to juggle projects, priorities, and workload on daily basis

Effective verbal and written communication skills

Willingness/desire to provide mentorship to IT personnel

Ideal candidate has 5 to 10 years experience in DB2 z/OS databases along with Power Designer data modeling skills.

Candidate should have strong experience in designing and creating database objects such as tables, views, indexes and IBM CDC and Qrep replication setup.

The candidate will provide the following support in DB2 z/OS (Database administration, production support, quality assurance, development) within OLTP and/or OLAP environments is required.

The candidate must support Oncall schedule 7/24 team rotation supporting DB2 z/OS and limited Oracle support.