Archive for the ‘SQL’ tag
SQL Server Developer Job in Dallas, Texas US
One of our direct clients has an opportunity for a SQL Server Developer; their ideal candidate will meet the following description: 4 years of experience with the following: SQL Server 2000 SQL Server 2005/2008 Integration Services (SSIS), Relational Database Management Systems (RDMS), Reporting services (SSRS) Analysis Services (SSAS) data mining SQL queries (T-SQL.
MDX & DMX query languages Access and Excel Minimum of 4 years experience as a Neural Network forecasting professional M …
Senior Oracle Consultant Job in Philadelphia 19121, Pennsylvania US
Modis is seeking an experienced Oracle Developer for one of their clients: Our Client, located in Philadelphia, PA is the leader in their Industry.
The client is seeking a PL/SQL Developer / Oracle Consultant with the following experience and credentials: Responsibilities include: Looking for an individual to join their team to assist in design, development, and maintenance of complex ETL procedures within an Oracle environment.
Ideal candidate will have a broad understandi …
Senior Oracle Consultant Job in Philadelphia 19121, Pennsylvania US
SQL Server DBA Job in JOhns Creek 30097, Georgia US
Overview: Under general direction, designs, implements and maintains complex databases with respect to JCL, access methods, access time, device allocation, validation checks, organization, protection and security, documentation, guidelines and statistical methods.
Includes maintenance of database dictionaries, overall monitoring of standards and procedures and integration of systems through Database design.
Proficient on multiple database platforms.
Provides guidance/training for less experienced Database Analysts.
Competent to work at the highest level of all phases of Database management.
Macy's Systems & Technology (MST) is the information technology division of Macy's Inc. Macy's Inc. is the nation's largest operator of department stores with over 800 department store locations in 46 states.
In addition, we operate major catalog and internet operations for Bloomingdale's and Macy's.
Macy's Systems & Technology is headquartered in Johns Creek, a suburban setting northeast of Atlanta, Georgia.
We offer competitive salaries, comprehensive benefits, employee fitness center and a merchandise discount.
Key Accountabilities: Perform SQL Server software new installs and upgrades Monitor and optimize the performance of the databaseWrite and maintain batch jobs and automate day-to-day tasks Maintain and support SQL Server Transactional and merge replicationReview overall physical database structures for overall stabilityImplement Database Disaster Recovery and Planning Skills Summary: 5+ years of expert level SQL DBA experience in SQL Server 2K5, preferably 2K8Experience working with large databaseExperience working with merge and transactional replication is a huge plusProficient in writing and optimizing T-SQL code and Stored ProceduresExpert DataLoading and ETL experienceSQL Server 2005 and 2008 and Windows 2003 experience will be requiredMust be able to perform SQL Server software new installs and upgradesMust have backup/recovery strategies and competently implement themMust have strong Transact SQL skillsMust be able to maintain and support SQL Server Transactional and merge replicationMust be able to review overall physical database structures for overall stabilityMust be able to implement Database Disaster Recovery and PlanningMust be able to use tools like SQL Server profiler and Windows performance monitorMust have a thorough understanding of Disk and Server configuration for SQL ServerMust have Experience with Software Development LifecycleMust be able to monitor and optimize the performance of the databaseMust be able to write and maintain batch jobs and automate day-to-day tasksMust have great problem solving skillsMust be available for rotating on-call pagerMust have good written and verbal skillsMust to able to work stand-alone; if necessary Macy's is an equal opportunity employer, committed to a diverse and inclusive work environment.
VB.NET Programmer Analyst Job in New York 10004, New York US
Top Downtown Manhattan Healthcare Firm has an immediate need for a senior VB.NET Programmer Analyst with Strong SQL Server.
The ideal candidate will also have experience with some Data Warehousing tools such as SSIS ETL OLAP & others.
This is a full time permanent position which offers a great base salary of $85-100K, bonus, excellent benefits, 3-4 weeks of paid vacation, growth, training, & stability.
It is a critical hire for the firm.
If you qualify, please APPLY NOW or email a MS WORD resume to alex [at] jmd-partners [dot] com for immediate consideration.
You will be contacted soon.
Position Summary: The Senior Programmer Analyst within our IS Software Development Client/Server Group is responsible for designing and developing desktop and web-based solutions.
Essential Duties and Responsibilities
1. Develop programs.
Demonstrate a proficiency in at least one of the firm’s programming languages.
Convert designs and specifications into computer programs following programming standards and best practices.
Create test scenarios and run tests to find errors and confirm computer programs meet specifications.
Analyze code to find causes of errors and revise code.
2. Perform analysis and design.
Coordinate meetings and interactions with the business users to define requirements.
Participate in the analysis, definition and documentation of requirements.
Lead the creation and documentation of solution designs that are in-line with the existing technical environment3.
Manage Projects.
Maintain project status and related documentation.
Coordinate project related activities, including planning timelines, scheduling meetings, coordinating resources, and tracking performance4 Test and Document.
Perform testing and review of code and related documentation as required5 Support production applications.
Monitor performance of production applications and provide necessary support.
Provide technical assistance by responding to inquiries from others regarding errors, problems or questions about programs.
Train any required technical support staff to use, test, and support programs.
Other Duties and Responsibilities
1. Program Deployment.
Create deployment packages and deployment related documentation.
Facilitate the transition of programs from development into production2 Research and evaluate software and hardware to enhance the development environment and process.
Requirements: Knowledge and Skills Required: Formal eduction or training in .Net development.
At least 3 years of VB.net experience in a WinForms environment.
Background must also include: – Experience delivering solutions with Microsoft SQL Server 2005- Experience with requirements gathering, analysis & design of ETL processes using SQL Server Integration Services (SSIS), multi-dimensional dtabases & OLAP cubes.
- Experience with Visual Studio 2005/2008- Ability to effectively present information to top management, client groups, and/or the firm’s user community.
- Ability to analyze codes and application programs.
- Ability to calculate figures and amounts such as discounts, incentives, surcharges, interest, commissions, proportions, and percentages.
- Ability to define problems, collect data, establish facts, and draw valid conclusions.
- Ability to interpret an extensive variety of technical instructions in mathematical or diagram form and deal with several abstract and concrete variables.
- Knowledge of Sharepoint or BizTalk.
Education Requirements: Bachelor’s degree in Computer Science, MIS or related major from a 4-year college or university.
Equivalent combination of education and experience acceptable.
Technical Skills: To perform this job successfully, an individual should have knowledge of advanced SQL Server Integration Services (SSIS), Winforms, Visual Basic.Net and SQL/TSQL.If you qualify for this position please APPLY NOW or send a MS WORD resume to alex [at] jmd-partners [dot] com for immediate consideration.
PLEASE NO 3RD PARTY AGENCIES OR CORP TO CORP CONSULTANTS.
VB.NET Programmer Analyst Job in New York 10004, New York US
Middleware Administrator (MABED110) Job in Bedford, New Hampshire US
DescriptionSeeking a Systems Support professional to join a cross-functional support team.
This candidates main focus will be the end to end installation and support of Health Dialogs middleware products, primarily made up of Oracle Fusion Middleware.
Environments include development, QA, staging, and production.
Must be able to work independently and collaboratively with little direction, and handle changing priorities of a support team.
Primary ResponsibilitiesInstallation, configuration, and support of the following products: Oracle/BEA WebLogicOracle Service BusOracle SOA SuiteOracle Service RegistryOracle RepositoryOracle BAMOracle BPEL Process ManagerRelease into staging and production code run on above productsSecondary ResponsibilitiesInstallation, configuration, and support of the following products: Microsoft SQL ServerMicrosoft SSISRequired SkillsStrong English communication skillsRequired ExperienceStrong understanding of all aspects of WebLogic Suite or Oracle SOA Suite (install/configuration/admin/problem resolution/testing)Strong understanding of SOA best practicesExperience supporting Java applicationsUnderstanding of SDLC (ideally in an Agile environment)SQL programming (Oracle PL/SQL or SQL Server T-SQL)Systems support for Windows or Unix/Linux environmentsScripting languages (Unix/Linux, Windows)Support of Microsoft SQL Server
Middleware Administrator (MABED110) Job in Bedford, New Hampshire US
Software Developer Job in Baton Rouge 70806, Louisiana US
Company Description: Enta USA, LLC is a privately owned US based company that is a world leader in providing ticketing solutions and services to colleges and universities, arenas, theatres, stadiums, museums, festivals in North America.
Offerings include managed solutions, stand- alone solutions, consulting, implementation and training services around the ENTA software product.
In development and use in the for over 15 years, the ENTA Ticketing Solution is the worlds most advanced box office / event / venue management solution.
With over 540 venues worldwide, the ENTA Ticketing Solution has been proven in the demanding UK theatre market, United States university market, Premier League soccer stadiums as well as other major events and venues in the United States, Europe, Middle East, and Australia.
Position Description: In this exciting and meaningful role, you will use your strong technical and industry background working in a balanced Agile team environment on cutting edge VS 2010 projects including Windows Presentation Foundation (WPF) kiosks and ASP MVC applications.
Duties: Develop custom software integration components for the ENTA productDevelop custom plug-ins for the enhancement of the ENTA productDevelop reports customizationsAssist with estimation and planning activitiesHelp identify and resolve gaps between requirements and technical designAssist implementation, support, and training teams as needed Qualifications / Skills: BDD / TDD, C# 3 years +, .ne
2. 0 an
3. 5, WCF, WPF (Preferable), ASP MVC (Preferable), WINForms, Web Forms, LINQ CI, IOC / DI,SOLID Principals, Patterns and Practises Web, Win, Framework, SOA Principals and Architecture design considerationNUnit, Pair Programming,ReSharper Bachelors degree in CS, EE, or Management Information Systems from an accredited four-year institution3+ years experience with Microsoft .
NET, .NE
3. 5, ASP.NET, C#, IIS, and/or ASP3+ years experience with T-SQL, SQL Server 2000+, Visual StudioWorking knowledge of VB6Excellent communication skills both oral and writtenAbility to work in a team environment as well as individually.
Other preferred (although not required) skills include: Masters degree in CS or EE from an accredited four-year institution Visual Studio 2005SQLCrystal Reports for the WebSSL and E-Commerce This is a full time salary position with full benefits including health, dental and vision, life and disability insurance, paid vacation, 401k, and competitive salary.
For immediate consideration, qualified candidate should email their resume to USCareer [at] entausa [dot] com Candidates must be eligible to work in the United States.
EOE Keywords: bachelor degree, technical, arts, entertainment, media, box office, ticket, ticketing, CRM, marketing, customer relationship management, patron, venue, performing arts, college, athletics, fundraising, arena, web design, SQL, SQL Server 2005, report writer, data conversion, scripts, Microsoft, .
NET, ASP, Active Server Pages, ASP.NET, IIS, Visual Studio, Crystal Reports, Javascript, SQL Server, SSL, e-commerce, Database Administrator, Database, .NE
3. 5, C#, VB6
SQL Applications Developer – E-Commerce Job in Chicago, Illinois US
In this role, you will triage Production Incidents and resolve to defects or create scripts to run against SQL DB to fix data.
You will be required to provide day to day production support of the in-house applications from a MS SQL perspective.
This demands intense troubleshooting/problem-solving skills in a dynamic environment.
SQL script writing will be required to mitigate issues resulting from data conditions and analysis of issue due to defects in stored procedures, views, and functions.
You will be part of the on-call rotation with limited shift and weekend work and will be expected to handle a variety of support including application and file transfers while on call.
This role is generally responsible for the design, development, coding, testing, debugging, and documentation of applications to satisfy the requirements of one or more user areas.
Duties may include hands-on new development as well as support, maintenance or enhancement of existing applications.
The Applications Developer works closely with client management to identify and specify complex business requirements and processes, as well as researches and evaluates alternative solutions and makes recommendations.As the qualified individual, you will be skilled in troubleshooting production incidents, incident management, and SQL authoring/script writing.
Any relevant education and/or training will be considered a plus.
SQL Applications Developer – E-Commerce Job in Chicago, Illinois US
PL/SQL Developer Job in ATLANTA, Georgia US
Industry leader is seeking a Database Engineer to join the conversion team.
The Database Engineer will be responsible for reviewing and creating complex Entity Relationship Diagrams as well as create/update sequence diagrams .
In this role you will also create/execute unit and integration test scripts, and design/develop SQL Server 2008 database objects (ie tables, views, stored procedures, triggers, etc.). The Database Engineer will create SQL queries using PL/SQL and T-SQL that will be used by the conversion applications and design/develop conversion applications utilizing SQL Server Integration Services (SSIS) as well as design/develop conversion reports using SQL Server Reporting Services (SSRS).
Must have strong skills in: Relational Data Base concepts; Reviewing and/or creating ERDs; Writing complex T-SQL queries and procedural logic; Designing and developing SQL Server database objects; Performing complex data analysis.
This is a high profile project and looking for candidates you have the make it happen attitude.
Application RequirementsClient will only consider local candidates.
Not accepting third party candidates for this position.
Required Qualifications: SSRST-SQLEntity-relationship diagramsPL/SQLSQL ServerRelational DatabasesSSIS (SQL Server Integration Services)Benefits/PerksSupplemental Disability and Long-Term Care Insurance, Dependent Care Assistance401(k) with Roth feature529 Educational Savings PlanFree e-Learning CoursesMedical, Dental, Vision, and Life Insurance for Full-time W2 Consultants.
mtxHdr {font-size
1. 5em; color: #004E61; font-weight: bold}About MATRIXFor more than 25 years, MATRIX has placed talented contract and permanent IT professionals like yourself at thousands of top-notch organizations throughout the U.
S., ranging from Fortune 50 to small IT shops across all industries.
MATRIX surrounds you with personal services from assistance with your resume and interviewing skills, to background information on the companies you will interview with, and more.
Once you are onboard as a TeamMATRIX consultant, we offer outstanding benefits, a 401(k) program (or plan), discounted training, and other valuable incentives.
www.MyMATRIXjobs.com, our Job Search Portal, features hundreds of jobs that we update hourly.
Unique functionality helps you streamline your job search and job application process.
You will benefit from productive job search tools such as: – Advanced Job Search- Job Alerts- Job Watches- Job Status TrackingPut the Power of Collaboration to work for you! Apply today at MATRIX.
Please Note: Your resume will never be submitted to a client company without your prior knowledge and consent to do so.
Sr. ETL Tester Job in Chicago 60606, Illinois US
Modis is currently seeking a Sr. ETL Tester for several exciting contract opportunities with our client in the Downtown Chicago / Loop area.
JOB DESCRIPTION The ETL Tester will be working in a team environment, responsible for developing and executing formal test plans for enterprise IBM DataStage / ETL and Cognos Applications.
Primary responsibilities will include: – Test planning, writing test cases and scripts, test case automation and test execution for ETL and Cognos Reports.
- Working with Winrunner, LoadRunner and QTP to perform QA Testing on ETL and Cognos Reports.
- Creating custom, complex SQL Scripts- Creating automation test programs using UNIX Shell Scripts and Perl- Reviewing system use cases and functional specs w/ the Business and Systems Analyst teams- Identifying areas of process improvement REQUIRED QUALIFICATIONS – Required Bachelors Degree in a Computer Science related field- 5-7 years IT Experience- Expert SQL skills (SQL, Stored Procedures) – Expert ETL /DataStage Testing- Expert Cognos 8 Testing- Experience with UNIX Shell Scripting and Automation Testing using Shell / Perl Scripts- HOW TO APPLY Qualified individuals are invited to apply for immediate consideration! Please send your most recently updated MS Word resume, contact information and compensation expectations to heather.thompson [at] modis [dot] com Location: Downtown ChicagoDuration: 3 + months with high likelihood of extensionRate: Negotiable
Database – Global Form Designer Job in San Francisco 94105, California US
PLEASE NOTE: ONLY LOCAL SAN FRANCISCO BAY AREA CANDIDATES WILL BE CONSIDERED Look no further!! Come check this company out!! This small software company, with a national clientele, continues to grow and seeks a talented GLOBAL FORM DESIGNER to join their team. The company, located in San Francisco, offers an energetic, dynamic and fun business casual work environment. It is close to BART and close to the Ferry Building and Muni. The individual chosen will work with a skilled, experienced and respected team and become an integral part of their success. This position includes an outstanding benefits package and the opportunity for continued education, additional certifications and strong career growth. Non-exempt position – eligible for overtime. Ready to hire NOW!! TO APPLY: Please email your cover letter and resume as a WORD document attachment and your target hourly salary requirements. Interviews will take place in our clientâs San Francisco office. SF Bay area candidates only. POSITION OVERVIEW The ideal candidate will be motivated, enthusiastic and ready for new challenges and opportunities. Candidateâs primary task will be to create and maintain immigration-related forms and questionnaires (for US and many other countries) using proprietary methodologies and established protocols. Candidate will map data between database and specific form and questionnaire fields using SQL stored procedures. A critical eye for formatting and layout is required, as well as meticulous attention to detail. Candidate will test his or her work, identify possible issues, and document solutions for bugs & fixes. In addition, candidate will participate on project teams for new and revised product interfaces, complete special projects involving online government forms, test new database and application software prior to release, and will optimally draft and proof tutorials and quick reference guides for end-users. REQUIREMENTS: â¢Bachelor’s or Associateâs degree with a preference for Computer Science, Information Technology or a related technical degree. â¢Intermediate knowledge of Adobe Acrobat Pro 8.0 and Adobe LifeCycle Designer a plus.â¢Familiarity with XML desired.â¢Familiarity with Visual Basic formatting functions desired.â¢Familiarity with HTML and Visual Studio desired.â¢Intermediate knowledge of Microsoft Word (2003 and newer) desired.â¢Requires excellent oral and written interpersonal communication skills with a strong positive team-oriented attitude. Must be able to speak effectively with both non-technical end-users as well as IT professionals. â¢Demonstrated experience in problem resolution and technical problem identification. â¢Help-desk and / or technical customer support representative ( CSR / TSR ) experience a strong plus. â¢SQL experience – intermediate skill level required. The right candidate must be comfortable working in Management Studio in SQL 2005 / SQL 2008, writing queries, and writing stored procedures.â¢Must understand database structures and relationships.â¢Requires strong attention to detail, outstanding resourcefulness, flexibility, and the ability to work independently as well as within a team setting. â¢Comfortable with working in a large shared office space with individual work-stations. â¢Typical work hours are 8:30â 5:00, Monday- Friday. Some OT required. â¢Familiarity with U.S. and / or global immigration a big plus.
Database – Global Form Designer Job in San Francisco 94105, California US