Database Administrator IV - INSPYR Solutions
Berkeley Heights, NJ 07922
About the Job
Title: DB2 DBA
Location: Berkeley Heights, NJ or Greenwood Village, CO
Duration: Contract to Hire
Compensation: $70 HR and $130,000 Conversion
Work Requirements: US Citizen, GC Holders or Authorized to Work in the U.S.
Database Administrator IV
Experienced DB2 z/OS SR Database Administrator to work on a government application that requires a timely delivery within a tight schedule. Candidate should have strong DB2 experience in designing and creating database objects such as tables, views, indexes and replication subscriptions. The DBA will support multiple Development, QA and production environments throughout the SDLC cycle.
Daily activities include:
• 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
Candidate Requirements
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.
Our benefits package includes: (EXCLUDE on perm placements)
· Comprehensive medical benefits
· Competitive pay
· 401(k) retirement plan
· …and much more!
About INSPYR Solutions
Technology is our focus and quality is our commitment. As a national expert in delivering flexible technology and talent solutions, we strategically align industry and technical expertise with our clients' business objectives and cultural needs. Our solutions are tailored to each client and include a wide variety of professional services, project, and talent solutions. By always striving for excellence and focusing on the human aspect of our business, we work seamlessly with our talent and clients to match the right solutions to the right opportunities. Learn more about us at inspyrsolutions.com.
INSPYR Solutions provides Equal Employment Opportunities (EEO) to all employees and applicants for employment without regard to race, color, religion, sex, national origin, age, disability, or genetics. In addition to federal law requirements, INSPYR Solutions complies with applicable state and local laws governing nondiscrimination in employment in every location in which the company has facilities
#LI-MP2
#LI-ONSITE