*Dear Candidate,*
*We have an urgent opening for **DB2/DBA Database Administrator & System Analyst **and I have sent you a job description ,Please go through it and let me know if you are comfortable with it and also send me your updated resume ASAP as applicable **(Updated Resume with your Employer Details )* * .* *Job Title :* *DB2/DBA Database Administrator * *Work Location: Chicago | IL* *Interview Process: Phone screen then onsite interview (Have to be able to do a F2F; no negotiations with that)* *Manager Notes:* *· This person will be providing higher level production support; almost a “systems level” individual.* *· Experience with DB2, UDB, DPF, LUW* *o http://en.wikipedia.org/wiki/DB2_UDB <http://en.wikipedia.org/wiki/DB2_UDB>* *· It is a 24x7 environment; need to be comfortable with that* *· Will be responsible for determining root cause, styling and configuring DB2* *· Data Warehousing experience required.* *· Experience with Database Partitioning Feature ( DPF ) / EEE is required for this position* *· Communication is very important; need to be professional and speak clearly as they support individuals in both Chicago and D.C.* *· It is a team environment so need to be able to work well with others* *· Could sit in DC but preference is for Chicago.* *· Manager is “aggressively looking to hire” * *· Open ended contract for the duration; definitely long term (12+ months)* *Position Details:* *Job Description:* *This person provides Database Administration support for the DB2 UDB Data Warehouse. This person manages and maintains all production and non-production databases. Responsible for enforcing SDLC standards, maintenance, access and security administration, this person will perform backup and recovery on DBMS and configure database parameters, along with related activities. • 5 years of experience (minimum) as a database administrator with DB2 UDB Data Warehouse Enterprise Edition within an AIX operating environment. • Provide primary DBA design and support services for establishing, upgrading and maintaining the DB2 UDB Data Warehouse environments. • Experience with DB2 DPF desirable. • Implement backup and recovery procedures for DB2 UDB Data Warehouse databases and test regularly in conjunction with Operations. • In conjunction with the network security administrator, establish and manage user access, and design and implement security architecture. • Create, maintain and refresh required DB2 UDB Data Warehouse instances/databases for development, test and production environments. • As required, help resolve application problems. Act as liaison between application programmers to assist with resolving problems. • Monitor security breaches, error log(s), database and log space, user activity and resource utilization of production environment. Work with application programmers to insure that application problems do not adversely affect production operations. • Monitor system resources of database servers to assure production systems meet performance & availability requirements and hardware enhancements are scheduled in a timely fashion. • Provide after hours on-call support for deployments and critical database issues. • Provide expert assistance in database and SQL statement tuning to improve performance. This includes, but is not limited to, re-writing SQL statements, creating new indexes and altering existing indexes. • Using software packages (e.g., Idera & BMC Patrol) and/or local scripts, monitor performance, space, DB2 UDB Data Warehouse database parameters and tune as required. • Following BCBSA standards, write, maintain and document monitoring scripts needed in support of applications. • Monitor disk usage; plan acquisition and replacement of disk devices as needed. • Act as project liaison and coordinate with AIX system administrators for application of OS patches and maintenance required for database servers. • Provide DB2 UDB database administration on servers for mission critical applications. • Development, maintenance and documentation of procedures and standards for effective database software use. • Analysis and management of DB2 UDB Data Warehouse problems/defects with IBM and installation of patches. • Use of software and locally developed tools to monitor DB2 UDB Data Warehouse databases. • Communicate and collaborate effectively with staff of varying technical expertise. • Excellent oral and written communication skills. • Experience supporting 24x7 environments. • Data Warehousing experience required. • Experience with Database Partitioning Feature ( DPF ) / EEE is required for this position. * ** Deliverable:* *This is a pure staff augmentation position with no guaranteed/warranted deliverables. Resource(s) will act in accordance with the task orders provided to the consultant’s company by the FEP Project Manager. * *Location: Chicago IL* *Position: System Analyst Software Design Analyst III* *Interview Process: Phone Screen then an onsite (Have to be able to do a F2F; no questions asked)* *Position Details:* ***Good communication skills are huge for this manager and in these roles. * *Job Description:* *Senior System Analyst with experience delivering data warehouse solutions in Healthcare Insurance. The position will require interviewing SMEs to document structured business requirements, working with developers to translate business requirements to technical design, and working with testers to translate requirements/design into test plans. The Senior SA will also create and execute test plans that are traceable back to requirements. The Senior SA will manage small projects, prepare project plans, and communicate status to senior management. 10+ years of Systems Analysis or closely related experience. 5+ years of Project Management experience. Possesses strong core business and technical acumen along with exceptional communication skills and is able to leverage these capabilities to conceptualize, scope/estimate, and influence decisions regarding project direction. Primary Technical / Business Skills: • Demonstrated success delivering complex solutions in Healthcare Insurance • Functional understanding of business domains and supporting business processes • Ability to elicit, analyze, document application business functional and non-functional requirements, supporting data structures and technical platforms • Ability to collaborate with business SMEs, solution architects, designers, developers to translate business requirements into architecture and technical design • Ability to develop and execute test plans that are traceable back to requirements • Ability to estimate and manage small projects • Business and technical analysis skills required • Project management skills are required • Strong written and verbal communications skills required * ** Deliverable:* *System analysis and design artifacts. * Best Regards *Anupam Amita* Technical Recruiter P-201-285-8031 * 104 | F- 201-526-6869 [image: pppp]*APETAN CONSULTING LLC* 72 Van Reipen Avenue # 255 Jersey City, NJ 07306 *Email*: [email protected] <[email protected]> *Gtalk:[email protected] <gtalk%[email protected]>* http://www.apetan.com *Disclaimer: We respect your Online Privacy. This e-mail message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. If you are not interested in receiving our e-mails then please reply with a "REMOVE" in the subject line at * *[email protected]* <[email protected]>* and mention all the e-mail addresses to be removed with any e-mail addresses, which might be diverting the e mails to you. We are sorry for the inconvenience.* -- You received this message because you are subscribed to the Google Groups "Vendors" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/vendors. For more options, visit https://groups.google.com/d/optout.
