* HI All, Please let me know if you have any one for below position. * * Title : DB2 DBA Location : INDIANAPOLIS, IN Duration : 6 Months +*
* JOB DESCRIPTION: Database Manager/Administrator EAM6 Duties Employee is required to manage, plan, organize, and control all operations and activities of a large computerized data-processing system. Employee reports to the agency head, Information Technology Director, or agency designated manager, depending on the size, organization, complexity, and potential impact of the work on the agency. Representative Duties Include: • Plans, manages, organizes, and controls all operations and activities of agency database projects; • Ensures that supported databases have well documented maintenance plans and recovery procedures and that qualified staff are available to maintain current database systems; • Evaluates and selects infrastructure components; • Consults with agency users on functional aspects of requirements, schedules, and implementation strategy. • Determines staffing needs and arranges for manpower assignments to meet schedule requirements; • Creates and maintains a team atmosphere and work environment to promote project work productivity; • Ensures concurrence with organization's standards and procedures including system development methodology, design and programming standards, reporting standards, work standards; • Reviews and approves database project documentation, measures progress against project schedule and budget, takes corrective action and resolves issues as appropriate; • Prepares database project activity and status reports regarding the database management section and advises higher level management of problem areas requiring their action; • Regularly meets with agency management to discuss project status, prioritization of changes and/or enhancements, and project concerns; • Performs related duties as assigned. • SQL File-tuning of development application code. • Perform binds and access-path checking of SQL changes in application code. • Help Development and Maintenance team with SQL standards and efficiencies in application code. • Capacity planning and reporting including periodic space requirements and growth trending. • Ad-hoc reporting requests from Management, Development and Maintenance team members. • Monitoring of backup jobs. • Perform OS upgrading including installation and testing. Job Requirements • Broad knowledge of cost project management, benefit analysis, risk analysis, risk determination, budgeting, funding, and estimation resources; • Broad knowledge in the technology of both the DBMS and the operating system chosen for the data warehouse or data mart; • Broad knowledge in software and utilities related to supported DBMS such as Reorg, Backup, Recovery, Load, Unload; • Broad knowledge of capacity planning and disaster recovery; • Broad knowledge of relational database and/or data warehouse design techniques and dimensional modeling processes; • Broad knowledge of computer hardware/software capabilities and configurations; • Basic knowledge of computer programming, including computer languages and testing of programs; • Broad knowledge of data communications, including networking, Mainframe Connectivity, and Communications Server; • Broad knowledge of the most recent technical developments in the database administration field; • Ability to perform logic analysis; • Ability to read and understand complicated technical manuals; • Ability to apply theories, principles and methodologies to existing computer software; • Ability to supervise and manage diverse human resources; • Ability to lead, encourage and influence others to perform; • Ability to communicate effectively orally and in writing; • Working knowledge of database systems development, information technology, computer terminology, systems analysis and design, programming, and tools and approaches to systems analysis and design; • Thorough knowledge of database project management theories and practices. • Knowledge and experience of Visual Explain. • Knowledge and experience of ASG-TMON. Difficulty of Work Employee applies established agency guidelines for systems development and generally establishes database project management practices and techniques to insure computer systems under development for a variety of program areas are delivered per user specifications, on time, and within the allocated budget. Employee exercises good technical and administrative judgment in determining the appropriate resources and in determining the allocation of those resources in order to coordinate completion of a database project to meet the database project plan. Assignments involve managing the development of database systems that may require adoption of technologies new to the state. All database projects vary in complexity and are situation dependent. Employee must constantly monitor for potential problems and develop contingencies for unexpected problems to insure the completion of the project within established timetables. Responsibility Employee is provided objectives and boundaries and is responsible for ensuring work is in compliance with the policies, programs, and practices of the agency and IT division. Employee's work has an extensive impact on the IT division's operations and other major agency programs and operations. Problems that may impact the agency's operations, significantly, may be discussed with the manager. Personal Work Relationships Employee works with the agency executive management, IT Division management, division director, systems users, agency personnel, consultants, vendors, representatives from other agencies, and any other individual or group involved with the project to effectively manage project related efforts. Contacts are for the purpose of directing, managing, supervising, problem solving, sharing, describing, troubleshooting and analyzing. Employee communicates program progress to management. * *============================= Santhosh [EMAIL PROTECTED] [EMAIL PROTECTED] 201-255-0319 Ext 274 * --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "USITSOFT" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/usitsoft?hl=en -~----------~----~----~----~------~----~------~--~---
