To apply for any of the following positions, please send resume to: careers@aspect-consulting.com

Aspect Consulting, Inc. is seeking a Sourcer for a Contract Opportunity located in King of Prussia, PA.

The Sourcer will strategically identify and engage top talent. S/he will work closely with hiring managers to define and execute against creative and methodical search strategies.

JOB DESCRIPTION

  • Partner with hiring managers and recruiters to identify high-quality and diverse talent pools/leads through proactive research techniques
  • Screen and qualify prospective candidates against defined requirements, and convert qualified passive leads to active candidates
  • Develop methodical, creative sourcing strategies for open positions
  • Pipeline passive talent by leveraging research, complex Internet searches and networking
  • At least 1+ years of experience as a Sourcer, preferably in a high growth environment in with a focus on software and technology
  • Ability to source passive candidates through various avenues including: LinkedIn, social media sites/campaigns, events and other unique means to engage candidates
  • Experience with an applicant tracking system

Aspect Consulting, Inc. is seeking an Lawson Analyst for a Direct Hire Opportunity located in Queens, NY.

The Lawson Analyst will maintain & support end users with the use of Lawson procurement and supply chain modules. 

Requirements: 

  • Bachelor's degree in Business, Information Systems or Healthcare 
  • 4-5 years Lawson experience in procurement. 
  • Healthcare experience strongly preferred. 
  • Knowledge of Microsoft products and Crystal Reports 
  • Excellent communication and organizational skills and the ability to train end users.

Aspect Consulting, Inc. is seeking a APP/BI Developer for a Direct Hire Opportunity located in New York, NY.

Assist in the development, implementation and maintenance of the Corporate Finance BI applications and reporting. This role requires a service oriented mentality, high sense of ownership of the issues and requests assigned, focus on managing and resolving issues in alignment with established SLAs; maintaining communication with the affected stakeholders to keep them updated with status of their requests; and initiating and performing changes on production systems and proactively escalating issues.

ROLES/RESPONSIBILITIES

  • Minimum 3 years application development / data warehouse / data quality, business intelligence reporting development experience
  • Solid knowledge of SQL and Transact SQL with a minimum 3 years of hands-on experience,
  • MDX /DAX   knowledge a plus
  •  Experience with MS SQL Server and Analysis Services (Star schema and Cube design)
  • Moderate knowledge of data warehousing principles, data base design, data cleansing and data integrity techniques
  • Working knowledge of SAS software tools (SAS/VA, base SAS, SAS/FM) highly desirable
  • Moderate working knowledge of ETL processes and tools
  • Knowledge of MS business tools (Access / Excel / Word / PowerPoint / Visio / SharePoint)
  • Knowledge of business intelligence reporting tools ( SQL Server Reporting Services, Performance Points

EDUCATION

  • Minimum 4 year degree in Computer Science/Information Systems (or equivalent experience)

 

Aspect Consulting, Inc. is seeking a PeopleSoft DBA for a Direct Hire Opportunity located in Long Beach, CA.

GENERAL PURPOSE

Under direction, performs highly complex duties in the development, installation, configuration, maintenance, tuning and administration of PeopleSoft systems (Student and Financials) version 8.3 or higher enterprise-wide data management systems and software and in the installation, configuration, maintenance and administration of operating system and other core software and support systems; serves as an expert technical advisor on complex data, applications and systems management and administration issues; and performs related duties as assigned. Contributes to the reliable and secure operation of the PeopleSoft software, SQL Server database, and related software components underlying the PeopleSoft Student, HR, and Financials applications. Installs, implements, and supports PeopleSoft application software, acts as a primary technical resource for the campus administrative computing applications and provides ongoing support, including software tuning, installing upgrades and fixes, and maintaining software for 24/7 availability.

DISTINGUISHING CHARACTERISTICS

Senior PeopleSoft Database Administration/Systems Managers perform highly complex duties at an advanced professional mastery level in the development, maintenance and administration of data and systems management software and database structures which provide the foundation for delivery of enterprise-wide technology services to meet the needs of District departments and business areas for achievement of their academic, business, operational, service and productivity objectives. The incumbents are responsible for PeopleSoft enterprise architecture strategies for data and systems and ensure that database and systems environments are secure and kept up-to-date. Work requires deep technical knowledge of PeopleSoft data and systems architectures and the ability to apply that knowledge in the resolution of highly complex issues and problems. Incumbents are expected to exercise sound expert independent judgment in managing the delivery of high quality, customer-focused products and services, efficiently and cost-effectively.

Senior PeopleSoft Database Administration/Systems Manager is distinguished from other data management and systems administrator classes in that incumbents in the former class are recognized enterprise experts and provide technical advice and consulting to other professional technology staff and managers in their professional disciplines.

Duties

ESSENTIAL DUTIES AND RESPONSIBILITIES

The duties listed below are intended only as illustrations of the various types of work that may be performed. The omission of specific statements of duties does not exclude them from the position if the work is similar, related or a logical assignment to this class.

  • Performs highly complex data management functions at an enterprise level; installs, integrates, upgrades and manages PeopleSoft database environments and structures; monitors and evaluates PeopleSoft database environments to optimize performance; plans, organizes, tests and executes migration of databases from development and test to production environments; installs and tests new releases, bundles and fixes; ensures data security protocols are maintained and backup/recovery processes are completed as scheduled.
  • Performs PeopleSoft database administration functions for enterprise databases, including setting up and running database management utilities to backup, reorganize and restore databases and resolve production and operational problems; monitors utilization and manages available database resources.
  • Performs PeopleSoft data and systems architect duties; analyzes data resource and server capacity and forecasts growth requirements; recommends server, hardware and rdbms upgrades and enhancements to meet long-term needs; provides enterprise-level short- and long-term planning advice on technical enterprise database and systems management and utilization issues; promotes the effective sharing and utilization of common data across applications and departments/business units; researches and recommends software, hardware and other tools for data warehousing and data mining solutions; develops and deploys software to support data extraction, manipulation and reporting.
  • Administers PeopleSoft enterprise database security processes and procedures; develops, recommends and implements security permissions, privileges, standards and guidelines.
  • Installs, configures and integrates PeopleSoft application software over data management systems and supporting components and services; installs, upgrades and implements application fixes and patches; administers enterprise application software to ensure security and performance optimization.
  • Performs highly complex systems management functions at an enterprise level; installs, configures, integrates, tests, maintains and administers enterprise operating system software, including system monitoring and management software, for production, development and supplemental servers running enterprise applications and supporting components; installs and monitors system level security structures and protocols; ensures disaster response and recovery processes are followed.
  • Provides advanced technical support to PeopleSoft and web team developers and users including advice and guidance on complex processes and system interdependencies; troubleshoots operational and systems issues ranging from difficult to highly complex, including problems with multiple solutions and potential significant consequences; works with other ACIT staff to develop and implement or recommend the implementation of appropriate solutions to complex problems.
  • Oversees, reviews and responds to developers on PeopleSoft application customization and security requests, ensuring that development standards are followed, application changes are documented, change control procedures are strictly enforced and change projects are migrated across applications environments in an orderly manner.
  • Collaborates with other ACIT staff to develop and implement technology standards, policies and procedures.
  • Develops and maintains schematics and other documentation of PeopleSoft database and systems architectures and administration processes.

OTHER DUTIES

  • Keeps abreast of advancements and emerging trends in data management and storage systems, networking and multi-platform communication technologies; consults with vendors and other sources on industry and product direction, functionality and capabilities.

QUALIFICATIONS

  • Principles, practices and techniques of information systems management, including applications design, hardware and software options for administrative, business and academic functions and the cost-benefit of systems alternatives.
  • Relational database theory, design rules and development practices.
  • Data storage, warehousing and mining principles, methods and technology solutions.
  • Database management systems and software, including architectures, diagnostic tools, commands and utilities.
  • Tools and utilities used in monitoring and tuning database, applications and systems performance.
  • Operating system architectures, characteristics, components and commands applicable to enterprise information systems and platform operating systems.
  • Network architectures and theory and principles of network design and integration, including topologies and protocols.
  • Principles, practices and methods of systems/network administration and maintenance, including configuration, performance tuning and diagnostic tools.
  • Systems integration design concepts as they apply to areas of responsibility.
  • Principles and practices of sound business communication.
  • Principles, practices and methods of project management as they apply to information technology projects.

Ability to:

  • Plan, organize, integrate and manage a broad range of complex data and systems management, upgrade, administration and maintenance activities.
  • Establish and maintain project and production schedules and balance responsibilities for multiple activities to ensure timely, high-quality results.
  • Identify information and technology management issues and opportunities, analyze complex problems and alternatives and develop sound conclusions and recommendations.
  • Perform PeopleSoft database and systems troubleshooting and tuning to resolve complex data and systems management, communication and interpreting problems.
  • Assess customer needs, set priorities and allocate resources to most effectively meet needs in a timely manner.
  • Develop and implement appropriate procedures and controls.
  • Understand and apply functional requirements to the development of systems proposals, specifications and recommendations for cost effective information systems and technology solutions.
  • Communicate clearly and effectively to diverse audiences of technical and non-technical personnel, both orally and in writing.
  • Prepare clear, concise and accurate proposals, reports, documentation and other written materials.
  • Read, interpret, explain and apply technical information on systems processes, software and hardware for technical and non-technical users.
  • Exercise sound expert independent judgment within general policy guidelines.
  • Keep technical skills current to meet continuing work responsibilities.
  • Use tact and diplomacy when dealing with sensitive, complex and/or confidential issues and situations.
  • Establish and maintain highly effective working relationships with District managers, power and other users, consultants, vendors, employees and others encountered in the course of work.

Education, Training and Experience:

A typical way of obtaining the knowledge, skills and abilities outlined above is graduation from a four-year college or university with a major in Computer Science or a related technical field; and aminimum of 5-8 years of hands on experience as a PeopleSoft DBA (SQL Server or Oracle).or an equivalent combination of training and experience. Database administration and PeopleSoft formal technical training is preferred. Hands-on experience with multiple PeopleSoft implementations (version 8 or higher) and through working knowledge of Change Assistant, PeopleTools and PeopleCode. Working knowledge of n-tier architectures required.

Licenses; Certificates; Special Requirements:

A valid California driver's license and the ability to maintain insurability under the City's vehicle insurance policy.

Aspect Consulting, Inc. is seeking a Higher Education DBA for a Contract to Hire Opportunity located in Bronx, NY.

  • Database Administration of Oracle, MySQL and SQL Server Relational Database Management Systems includingplanning, analysis, coordination, support and maintenance of ERP systems such as Banner, ISSM, Luminis, Portal, Blackboard EDW, Talend ESB/SOA.
  • Provide detailed planning information to project coordinators to assist in planning of service requests, implementation steps, corrective actions, upgrade recommendations and optimization steps.
  • Coordinate physical and logical changes to enterprise databases and Banner applications; and codes, tests, and implements databases by performing the following duties which may include but not limited to the following:
  • Designs logical and physical databases structures and/or reviews description of database design changes to understand how they affect the physical database structure.
  • Establishes physical database initialization parameters for effective performance tuning.
  • Calculates optimum values for database parameters such as amount of computer memory to be used by each instance.
  • Develop and implement the backup and recovery of all databases using various methodologies.
  • Specify the user access level for each segment of one or more data items such as insert, replace, retrieve, or delete data to ensure the database integrity.
  • Monitors the database access security and specifies which users can have specific privileges and which data can be accessed outside the ERP applications.
  • Monitor and optimize system performance using index tuning, disk optimization, and other methods. Answers user questions.
  • Confers with co-workers to determine impact of database changes on other systems and staff cost for making changes to database.
  • Modifies database programs to increase processing performance, referred to as performance tuning.
  • Other duties may be assigned as needed

 QUALIFICATIONS:

  • Bachelor’s degree and 2 or more years experience with Oracle Relational Database Administration
  • Oracle 11g Internet Application Server/11g Fusion. Middleware experience.
  • MySQL experience
  • SQL Server experience
  • Strong SQL with performance tuning experience
  • Solid Linux/Unix experience and shell scripting
  • Strong interpersonal and customer service skills
  • Superior verbal and written skills
  • Banner products and technologies experience desired
  • Work within a Business Intelligence environment and work with TomCat and/or RabbitMQ
  • Microsoft SQL Server experience, PL/SQL, ProC
  • Oracle Forms and Reports

 

Join Our Team of Talented IT Professionals

We pride ourselves on the quality of our talented team.

We hire driven, self-motivated professionals who thrive in a dynamic, flexible environment, and we reward you for making direct contribution to our growth.

 

About Aspect

Aspect Consulting specializes in helping clients better utilize their data by providing qualified IT consulting services and supplemental staffing for customers in the pharmaceutical, healthcare, higher education, construction, retail, financial, and manufacturing industries.