DB2 DBA // DIRECT CLIENT
-- I have a very urgent DIRECT CLIENT requirement for *DB2 DBA* in *Salem, OR*. Please Let Me Know If you have available candidate, please reply with their word resume, location, rate and contact number. Please send the resumes at alb...@cncconsulting.com *Job Title: DB2 DBA* *Location: Salem, OR* *Duration: Salem, OR* *Client: State of OR* *Need 1 reference* Develops, implements, administers, and maintains policies and procedures for ensuring the security and integrity of the company database. Implements data models, database designs, data access and table maintenance codes. Resolves database performance and capacity issues, and replication and other distributed data issues. May require a bachelor's degree in a related area and at least 6 years or equivalent experience in the field or in a related area. Familiar with advanced concepts, practices, and procedures within a particular field. Relies on experience and judgment to plan and accomplish goals. Performs a variety of tasks. A certain degree of creativity and latitude is required. Software (Operations) • Coordinate, for the supported ODOT business area, the installation of vendor-developed and ODOT built software, which may be new to ODOT. In some cases, new installation of software may impact systems external to ODOT. • Support distributed systems within multiple sites/branches. • Ensure version compatibility between new releases of supported business application data and current operating environments. • Contact multiple vendors regarding data-related problems and resolve or escalates problems as needed; coordinate with vendors, external agencies, customers and IS to schedule resources to implement solutions. • Analyze and identity corrupt or problematic data issues for mission critical system; evaluate and execute actions to resolve errors as needed. Assess compatibility issues and recommends options for system upgrades. Software (Customer Assistance) • Respond to system crashes that are critical to the agency and/or other State agencies. These systems maybe time critical, support reporting of regulatory requirement, and/or public safety. Solving the problem usually requires a high level of coordination with other IS staff, vendors and involves situations requiring conflict resolutions and/or negotiating the resolution process. Provide technical assistance and/or develop and deliver formal training to customers, developers, project managers and system analysts. Software (Construction) • Perform business analysis and requirements-gathering that will automate current, new or changing/re-engineered business processes. This may include conducting joint application development sessions with other section personnel and user representatives. • Responsible for overall development, performance and maintenance of physical models of relational databases Consider system features, configuration, and compatibility and performance issues to recommend business operation changes to effectively use system data resources. Data (Operations) • Develop and manage relational databases, as well as VSAM files. They may be multiple, distributed databases. • Maintain relational integrity of Agency databases. This includes, but is not limited to the constraints, linked tables and consistency. • • Make recommendations on performance tuning, considering the cost, specifications, and organizational policies on expansion. Establishes and enforces data security policy definition and administration. Skills Data Modeling Proficient Yes Skills Data Warehousing Proficient Yes Skills DBA Expert Yes Skills MAINFRAME IBM ZOS DB2 Expert Yes Skills TEAM FOUNDATION SERVER TFS Proficient Yes Very Truly, Albert Smith CNC Consulting, Inc The enterprise resource for staff augmentation 201-588-9137 P 201-541-9128 F alb...@cncconsulting.com www.cncconsulting.com -- You received this message because you are subscribed to the Google Groups "SAP BASIS" group. To unsubscribe from this group and stop receiving emails from it, send an email to sap-basis+unsubscr...@googlegroups.com. To post to this group, send email to sap-basis@googlegroups.com. Visit this group at https://groups.google.com/group/sap-basis. For more options, visit https://groups.google.com/d/optout.
DB2 DBA - Direct Client
*DB2 DBA - **Direct Client* *Immediate Interview and Start ASAP!!!* *Please send resume to **s...@cncconsulting.com <s...@cncconsulting.com>* Job Title: DB2 DBA Location: Salem, OR Duration: 8 months Direct Client Position Client: State of OR Note: Need 1 reference Develops, implements, administers, and maintains policies and procedures for ensuring the security and integrity of the company database. Implements data models, database designs, data access and table maintenance codes. Resolves database performance and capacity issues, and replication and other distributed data issues. May require a bachelor's degree in a related area and at least 6 years or equivalent experience in the field or in a related area. Familiar with advanced concepts, practices, and procedures within a particular field. Relies on experience and judgment to plan and accomplish goals. Performs a variety of tasks. A certain degree of creativity and latitude is required. Software (Operations) Coordinate, for the supported ODOT business area, the installation of vendor-developed and ODOT built software, which may be new to ODOT. In some cases, new installation of software may impact systems external to ODOT. Support distributed systems within multiple sites/branches. Ensure version compatibility between new releases of supported business application data and current operating environments. Contact multiple vendors regarding data-related problems and resolve or escalates problems as needed; coordinate with vendors, external agencies, customers and IS to schedule resources to implement solutions. Analyze and identity corrupt or problematic data issues for mission critical system; evaluate and execute actions to resolve errors as needed. Assess compatibility issues and recommends options for system upgrades. Software (Customer Assistance) Respond to system crashes that are critical to the agency and/or other State agencies. These systems maybe time critical, support reporting of regulatory requirement, and/or public safety. Solving the problem usually requires a high level of coordination with other IS staff, vendors and involves situations requiring conflict resolutions and/or negotiating the resolution process. Provide technical assistance and/or develop and deliver formal training to customers, developers, project managers and system analysts. Software (Construction) Perform business analysis and requirements-gathering that will automate current, new or changing/re-engineered business processes. This may include conducting joint application development sessions with other section personnel and user representatives. Responsible for overall development, performance and maintenance of physical models of relational databases Consider system features, configuration, and compatibility and performance issues to recommend business operation changes to effectively use system data resources. Data (Operations) Develop and manage relational databases, as well as VSAM files. They may be multiple, distributed databases. Maintain relational integrity of Agency databases. This includes, but is not limited to the constraints, linked tables and consistency. Make recommendations on performance tuning, considering the cost, specifications, and organizational policies on expansion. Establishes and enforces data security policy definition and administration. *Required Skills* *Data Modeling -* *Data Warehousing -* *DBA -* *MAINFRAME IBM ZOS DB2 -* *TEAM FOUNDATION SERVER TFS -* *Please send resume to s...@cncconsulting.com <s...@cncconsulting.com> * *Thanks,Sam CNC Consulting, inc.201-546-3096...@cncconsulting.com <s...@cncconsulting.com>* -- You received this message because you are subscribed to the Google Groups "SAP BASIS" group. To unsubscribe from this group and stop receiving emails from it, send an email to sap-basis+unsubscr...@googlegroups.com. To post to this group, send email to sap-basis@googlegroups.com. Visit this group at https://groups.google.com/group/sap-basis. For more options, visit https://groups.google.com/d/optout.
Lead DB2 DBA -Direct Client
*Lead DB2 DBA -**Direct Client* *Immediate Interview and Start ASAP!!!* *Please send resume to **s...@cncconsulting.com <s...@cncconsulting.com>* Job Title: Lead DB2 DBA Location: Columbia, SC Duration: 12 Months Direct Client Position Client: State of SC CANDIDATE SHOULD POSSESS A PROJECT LEAD LEVEL OF KNOWLEDGE OF MULTIPLE DATABASE MANAGEMENT SYSTEMS TO INCLUDE IBM DB2 AND PREFERABLY CA-IDMS. CANDIDATE MUST BE ABLE TO INSTALL, MAINTAIN AND TROUBLESHOOT DB2 IN AN IBM Z/OS ENVIRONMENT AS WELL AS ARCHITECT AND IMPLEMENT SOLUTIONS. KNOWLEDGE OF UTILITY PROGRAMS, ASSEMBLERS, DATABASE TROUBLE SHOOTING PRACTICES AND THE ABILITY TO IDENTIFY AND RESOLVE PROBLEMS IS REQUIRED. ABILITY TO WORK INDEPENDENTLY AND TO WORK OUTSIDE OF THE NORMAL WORK HOURS AS NEEDED IS REQUIRED. DAILY DUTIES / RESPONSIBILITIES: PROJECT LEAD LEVEL ARCHITECTURE, IMPLEMENTATION, SUPPORT AND ADMINISTRATION OF THE IBM DB2 IN AN IBM Z/OS ENVIRONMENT. EMPLOYEE MUST WORK INDEPENDENTLY AND LEAD THE PLANNING AND COMPLETION OF DIVERSE DATABASE AND INFRASTRUCTURE TASKS, MEETING IMPOSED TIMELINES. DAILY DUTIES WILL INCLUDE, BUT ARE NOT LIMITED TO THE FOLLOWING: Install, modify and maintain database software. Coordinate installation of maintenance and migration to new database releases with outside agency customers. Assist the DB2 and IDMS customer agencies with database related issues. Help them to successfully implement their databases and address database related issues. Formalize database standards, working with all groups to insure that all phases of the database and client/server interfaces adhere to documented standards. Work with all groups to insure that database functions and interfaces meet standards. Design database integrities so as to insure that system security is maintained. Ensure the protection of user databases and systems from unauthorized or accidental use or destruction. REQUIRED EDUCATION: BACHELOR’S OR MASTER’S DEGREE IN A RELEVANT FIELD OF WORK OR EQUIVALENT WORK EXPERIENCE. REQUIRED CERTIFICATIONS: NONE REQUIRED. IBM DB2 CERTIFICATION V9 OR ABOVE PREFERRED Database PlatformsDB2Yes 1 Lead Currently Using 6 + Years Database PlatformsCA-IDMS No 1 Lead Currently Using 6 + Years Database PlatformsDatabase UpgradesNo 1 Expert Currently Using 6 + Years Development ToolsIDMS - NETWORKNo 1 Expert Currently Using 6 + Years Miscellaneous Database Administration Yes 1 Lead Currently Using 6 + Years Operating Systems/APIs IBM z-Series mainframe Yes 1 Lead Currently Using 6 + Years Operating Systems/APIs CICS No 1 Expert Currently Using 6 + Years Specialties IBMNo 1 Expert Currently Using 6 + Years *Please send resume to s...@cncconsulting.com <s...@cncconsulting.com> * *Thanks,Sam CNC Consulting, inc.201-546-3096...@cncconsulting.com <s...@cncconsulting.com>* -- You received this message because you are subscribed to the Google Groups "SAP BASIS" group. To unsubscribe from this group and stop receiving emails from it, send an email to sap-basis+unsubscr...@googlegroups.com. To post to this group, send email to sap-basis@googlegroups.com. Visit this group at https://groups.google.com/group/sap-basis. For more options, visit https://groups.google.com/d/optout.
DB2 DBA -Direct Client
*DB2 DBA -**Direct Client* *Immediate Interview and Start ASAP!!!* *Please send resume to **s...@cncconsulting.com <s...@cncconsulting.com>* Job Title: DB2 DBA Location: Tallahassee, FL Duration: 11 Months Direct Client Position Client :State of FL/Dept of Corrections Project Scope and Deliverables The scope of work to be performed includes the following: • Analyzing developer’s needs for new objects and making recommendations as to the most efficient way to implement the requirements and making changes as needed to ensure optimization. • Coding stored procedures, triggers, and views using Ansii standard SQL and SQL Server Transact SQL. • Develop and maintain technical specifications, standards, procedures, and techniques for collecting, processing, storing, and distributing data. • Develop and maintain processes that optimize databases and queries to ensure timely response times are kept to a minimum. • Analyze DB2 and SQL database issues and the ability to troubleshoot and resolve the issues to minimize impact on users. • Create SQL Server Integration Systems (SSIS) Packages to push data to SQL server databases from IBM mainframe DB2 databases. • Write SQL Server Powershell scripts to be used to monitor SQL Server database activity. • Create Linked Servers to obtain data from multiple SQL databases. Qualification Requirements for the Contractor • Minimum of 5 years DB2 administration experience. • Minimum of 5 years SQL Server administration experience. • Minimum of 3 years of BMC utilities experience. • Minimum of 3 years SQL Server Integration Systems (SSIS) Packages experience. Preferred Qualifications: • Experience with data administration in a multi-tiered environment (DB2 and SQL). • Minimum of 2 years of experience with DB2 Version 10. • Minimum of 3 years of experience administering SQL server 2005 / 2012 databases. • Experience migrating legacy databases to SQL 2012. • Experience with writing, testing, and executing SQL and T-SQL code. • Experience analyzing SQL and DB2 database objects to include indexes, stored procedures, and views for optimization purposes. • Experience preparing status reports and providing management briefings. *Please send resume to s...@cncconsulting.com <s...@cncconsulting.com> * *Thanks,Sam CNC Consulting, inc.201-546-3096...@cncconsulting.com <s...@cncconsulting.com>* -- You received this message because you are subscribed to the Google Groups "SAP BASIS" group. To unsubscribe from this group and stop receiving emails from it, send an email to sap-basis+unsubscr...@googlegroups.com. To post to this group, send email to sap-basis@googlegroups.com. Visit this group at https://groups.google.com/group/sap-basis. For more options, visit https://groups.google.com/d/optout.