Showing posts with label SQL. Show all posts
Showing posts with label SQL. Show all posts

Friday, 17 April 2015

DB2/WebSphere Database Administrator-1 Position, Chicago, IL

Job Title: DB2/WebSphere Database Administrator-1 Position
Location: Chicago, IL 
Duration: 1-3 years

Job Description:
A Database Administrator (DBA) is responsible for the documentation, design, implementation, and maintenance of the databases underlying the IBIS system. The DBA will support multiple instances of the IBIS database in several environments that are used throughout the application development and deployment lifecycle. In addition to the usual DBA skills, such as object design and creation, back-up and recovery, and bufferpool tuning, the DBA should be very familiar with database tools and utilities, physical data modeling, and SQL optimization and performance. Work with internal and external customers to analyze and determine information needs and elements; data relationships and attributes, data flow and storage requirements, and data output and reporting capabilities. Proven ability to take project requirements and the logical data model and create the following: A physical data model optimized for DB2/zOS and Websphere environment A document representing details how the implementation will conform to required agency standards In response to changes to the IBIS application the DBA will collaborate with the IBIS development team and be responsible for detailed DB design, implementation, testing, and deployment ensuring the technical integrity of the project. Provide SQL performance tuning on both OLTP and Data warehouse environments. Optimize DB2 Specialist utilization by tuning queries (static and dynamic), recommending indexes, and configuring database parameters. Engage in data mining activities needed to support management requests for information, assist in analysis of application errors, and define and execute queries needed to repair data in support of problem resolution. Provide trend analysis to management team to enable them to make informed decisions regarding Specialist management.  Responsibilities will span all aspects of DB design, maintenance, performance optimization, monitoring, and operational support. This includes DB disaster recovery and development of backup and archiving solutions. Provide on-call rotational 24/7 Incident Response to database alerts from production monitoring tools and Command Center personnel.

MANDATORY REQUIREMENTS:
Requires a Bachelor’s Degree with course work in computer science or directly related technical fields.  Please provide the relevant information below that fulfills this requirement.  Please provide information about any specialized training or certificates received in relation to this requirement. Requires at least six years of professional DB2 zOS database experience and production support in MVS z/OS environment within the last 9 years.  Please provide the job title and the description of the job duties or practical example during which the candidate utilized this skill to substantiate candidate claims of requisite knowledge/experience and technical expertise.  Please provide name of company or companies, title(s) of candidate, period(s) of employment, and roles and responsibilities. Please provide information about any specialized training or certificates received in relation to this requirement. Technical expertise in MVS-2 – z/OS.  Please provide all job title(s) for work performed within the last 9 years in which the candidate utilized this skill. Technical expertise in DB2 Version 8 and above.  Please provide all job title(s) for work performed within the last 9 years in which the candidate utilized this skill detailed knowledge of logical and physical DB design, performance-monitoring and tuning, definition of alert thresholds.  Please provide all job title(s) for work performed within the last 9 years in which the candidate utilized this skill. Detailed knowledge of stored procedures (COBOL and NATIVE), triggers and UDFs, RMF, and use of SMF data.  Please provide all job title(s) for work performed within the last 9 years in which the candidate utilized this skill.

PREFERRED  REQUIREMENTS:
Strong experience with DB2 Utilities, SPUFI, QMF, OSC, BMC-DB2Mon, PowerDesigner, and WebSphere.  Please provide all job title(s) for work performed within the last 9 years in which the candidate utilized this skill. Experience with J2EE environments and UDB on LUW. 
Please provide all job title(s) for work performed within the last 9 years in which the candidate utilized this skill. Previous experience with IDES/Agency Systems, methodologies.   Please provide all job title(s) for work performed within the last 9 years in which the candidate utilized this skill.


We have a very good relationship with the Hiring Manager and for the right candidate we can arrange an interview within a few days.
Look forward to connecting with you.

Thanks & Regards

Aravind
COMPQSOFT, Inc.
HUB Zone, SDB, MBE Certified
An ISO 9001:2008 & ISO 27001:2005 Certified
Phone: 281-978-4434  І  Fax: 281-657-6717

Wednesday, 12 November 2014

IT Developer / Sr JAVA Developer, Quincy,MA

Title: IT Developer/Engineer VI
Location: Quincy,MA
Start Date: Immediate
End Date: 03/31/2015
Client:  HP
  
Description:
Sr JAVA Developer
• Develop software application components requested by the functional team in accordance with the Solution Architecture Design
• Assists with the configuration of the software components (e.g. web server, app server, etc).
• Prepares component design documentation used internally and externally
• Represents that technical team in JAD sessions
• Able to identify potential technical challenges with proposed functional designs
• Provides bridge between the functional team (business SMEs) and the technical team (developers)
• Provides technical guidance to the functional and testing team
• Assists with creation of technical design documentation
• Expertise in Commonwealth and WCAG Accessibility standards
• Expertise in the Solution Architecture Design and the related components used by the technical team to build the RMVM solution
• Must be able to drive problem-solving strategies for complex issues that involve cross-functional disciplines
• Has the ability to read, understand and identify technical gaps in the Use Cases defined by the Functional Team. Once the gaps are identified, then this person will works with the technical/functional team members to identify a plan to resolve the gaps.
• The person will also work directly with the developers to answer technical questions about the Use Cases.
Skills Required: MUST HAVE ALL REQUIRED SKILLS TO BE CONSIDERED.

• 3-5 years of experience developing Web-based applications utilizing Java technologies
• Experience with the following technologies is required: JEE, JSP, JavaScript, CSS, HTML, Web Services, JPA, SQL, Oracle WebLogic, Hibernate
• Experience utilizing Rational Build Forge, Eclipse, Apache Ant, and Rational Team Concert to build projects is desired
• Experience with the following software: Oracle SOA Suite, Oracle Business Process Manager, Apache Web Server, Oracle Database is strongly preferred
• Strong problem solving and troubleshooting skills
• A minimum of 1 full life cycle custom software implementation
• Experience facilitating Joint Application Design sessions
• Experience developing screen mocks up for clients to review
• Ability to work independently and manage multiple task assignments
• Good oral and written communication skills

Thanks & Regards

Aravind
COMPQSOFT, Inc.
HUB Zone, SDB, MBE Certified
An ISO 9001:2008 & ISO 27001:2005 Certified

Phone: 281-978-4434  І  Fax: 281-657-6717

Tuesday, 28 January 2014

SAP BW/BI Business Functional Analyst, Cranberry Township, Pennsylvania



Position 2:           SAP BW/BI Business Functional Analyst
Location:             Cranberry Township, Pennsylvania
Duration:             Perm / Direct Hire
Pay      :               Best Market Price
Job Description:
Description of duties and responsibilities:
The successful candidate will be self-motivated with high energy and drive to excel. The ability to independently and intelligently reason and provide solutions is a must. The candidate should have a proven track record working collaboratively with customers and colleagues. Major responsibilities include, but are not limited to the following:
•         Partners with MSA Business leaders and executives to identify needs and opportunities for agile BW solutions with improved data analytics and delivery. 
•         Performs investigational analysis with the business to determine project feasibility, define value propositions, and establishes ROI for BW projects.
•         Drive SAP-BW projects, implementations, upgrades, and ongoing support.
•         Work closely with MSA Leadership Team, IT Departments and key business users of BW gathering business requirements.
•         Translates business requirements into functional specifications.
•         Work with architects to translate requirements into technical specifications.
•         Help prepare and maintain documentation, including procedures, system specifications, technical documentation, computer training materials and user manuals.
•         Help estimate resource requirements and create plans, timelines, milestones, user approvals, and charts/reports in BW projects.
•         Work closely with source system global team members to identify data in source systems and map data to the SAP Business Warehouse environment.
•         Pinpoint data quality gaps and develop a plan to close these gaps.
•         Maintain high degree of knowledge/understanding of SAP-BW technologies, business processes, and release levels.
•         Conducts end-user training, when needed.

Special knowledge, skills and abilities required:
Quickly establish credibility and foster collaborative relationships within business leaders.
Business knowledge and understanding of business processes.
Interface with internal customers and communicate complex ideas clearly and concisely.
Work with business and functional analysts to interpret business reporting requirements and design accurate and stable functional solutions.
Experience designing, developing and configuring in SAP Business Warehouse 7.x
Knowledge of data warehousing principles including Layered Scalable Architecture (LSA)
Experience in data extraction from SAP and non-SAP systems
Sound analytical, problem solving, planning and organizational skills.
Sound verbal and written communication skills, including presentations and business writing.
Prioritize and manage multiple requests or requirements to meet corporate business objectives.  Ability to adjust to changing priorities.
1% - 10% Global travel as required for education, conferences, on-site projects and implementations

Education and experience required:
This position is available at two different career levels based upon experience:
Level one: 3 years IT and 2 years relevant BW experience
Level two: 5 years IT and 5 years relevant BW experience
Preferred:
Bachelor’s Degree in Information Science, Computer Science, or related discipline.
Master of Business Administration
Experience in SQL or knowledge of relational databases
Experience in Microsoft SQL Server and/or Microsoft SQL Server Integration Services (SSIS)
Experience in SAP Business Explorer (BEx) or SAP BusinessObjects

If you are interested, please reply with an updated copy of your resume in .doc format along with a good time to call you back. If you are unavailable for work, then feel free to share my contact information with any of your friends/colleagues who might be interested. If you do not wish to be contacted for future jobs, please let me know and I will promptly modify our database accordingly.

Sincerely,

Arvind K
IT Recruiter
  

Friday, 27 December 2013

Oracle CRM Administrator | Sunrise, FL



Position:                                                             Oracle CRM Administrator
Type:                                                                  Full-time
Location:                                                            Sunrise, FL
Relocation Assistance Available:                         Yes
Bonus Eligible:                                                    Yes

Key elements from the Manager are: 
•                    CRM integration through web service
•                    CRM application administration and configuration
•                    Marketing on demand administration
•                    We use Marketing on demand for our campaign management, so we need someone with skills with that sub-module.

Description
The CRM Administrator will be the primary product owner of the Oracle CRM On Demand solution for Client.  Core responsibilities include the following:
•                    Work with business stakeholders across multiple departments to leverage CRM for campaign management, lead management, sales force automation, client implementations and vendor management opportunities.
•                    Gather scope and requirements from Stakeholders
•                    Design CRM solutions to meet business requirements
•                    Work with IT resources to develop integration points, including web services, ETLs and data load utilities.
•                    Configure and extend the CRM application user interface and workflow to support business solutions.
•                    Administer application security for the CRM application.
•                    Configure Oracle Marketing On Demand to support business campaign management objectives.
•                    Ensure user adoption by working with training and the business community to establish efficient workflows, job aids and a training program for new functionality releases.

In order to be successful at this role, a candidate will need the following skills and experience:
•                    5 plus years of hands on administrator level experience with Oracle CRM On Demand
•                    1 year experience with Oracle Marketing On Demand
•                    5 years of IT project experience
•                    A proven record of delivering CRM solutions that receive high adoption
•                    A technical background that includes exposure to web services, SQL, and data mapping principles.
•                    Ability to work independently and bring in other IT resources when needed.
•                    Ability to communicate effectively with the functional experts in the business as well as the technical resources in IT.
•                    Must be a team player

We have a very good relationship with the Hiring Manager and for the right candidate we can arrange an interview within a few days.
I look forward to connecting with you.

Sincerely,

Arvind K
IT Recruiter

Tuesday, 26 November 2013

Java Developer with ATG, Marysville, OH



Position:                                             Java Developer with ATG
Location:                                            Marysville, OH 
Job type:                                             Full Time / Permanent
Relocation Assistance:                        Yes
Candidate Experience:                        5+ to 7 years of experience

The client  is focused on a “Consumer First” strategy that underscores everything that we do.  In support of this strategy, the company provides multiple consumer-facing tools to help consumers better understand and properly use our products such as Consumer Call Centre, and other web properties, and mobile apps.  This position is responsible for supporting and improving the processes and systems that support these tools.

In this role, the Senior Analyst, eBusiness (Java Web Developer) will participate in the development, enhancement, maintenance, and testing of business applications and web sites for the eBusiness team.  Under the direction of the Manager, the Senior Analyst will work with customers, staff members, IT colleagues, and other stake holders to define detailed customer requirements and system interfaces, assess available technologies, and develop solutions to meet the business needs.  This includes knowledge of ATG web services, object oriented J2EE application development experience, and experience with project lifecycle processes.

Key Accountabilities and Responsibilities:
•                    Design, develop and implement technical solutions within a project team supporting internet web sites.  Troubleshoot application and/or data issues to satisfy business requirements.  Perform hands on technical tasks configuring the applications and working with software vendors to deliver results. Publish work plans and statuses of open activities with timelines.
•                    Partnership with customers to identify information and business process enhancement needs. 
•                    Lead and manage the efforts to create new and update existing internet web sites including working with the technical, business, and consulting resources to develop.
•                    Prepare detailed specifications from which programs will be written. Create and update required documentation about applications. Develop and adhere to detailed processes for all operational work.
•                    Foster and maintain good relationships with customers to ensure design requirements are integrated to support expected customer service levels.

Minimum Requirements:
•                    Bachelor’s degree in Information Services, Computer Science, Engineering or related work experience.
•                    5+ years web site development preferably with experience implementing ATG or other eCommerce packages.
•                    Experience with SQL and relational databases (Oracle, Access, etc.)
•                    Experience with structured design, development and implementation of new computing architecture.
•                    Experience desired in leading part of a project which includes success in managing deliverables and deadlines to implement new system solutions.
•                    Experience with programming in Java.

We have a very good relationship with the Hiring Manager and for the right candidate we can arrange an interview within a few days.
I look forward to connecting with you.


Sincerely,

Arvind K
IT Recruiter