Category Archives: Jobs

IT Jobs: Two Database Consultant jobs in Maine

Database Production Support Consultant (1 year)

  • At least 4-5 years combined using both MSSQL and Oracle RDBMS
  • Experience with performance tuning and integrity via indexing, normalization/de-normalization, constraints, triggers, etc.
  • Understanding of database security and implementation using views, column level permissioning, and roles.
  • Experience with DTS, creation/maintenance of SQL jobs, and security from server to database (including use of NT Authentication as well as standard SQL login/password security)
  • Excellent debugging and communication (both written and verbal) skills required
  • Excellent organizational skills
  • Windows command line scripting and UNIX shell scripting including Awk
  • Ability to communicate technical issues in an understandable way to non-technical end users, and keep management informed of the status of issues.
  • Database maintenance including backup and recovery, space management, and consistency checks
  • Responsibilities to include monitoring existing production processes, identification of performance improvement opportunities in existing processes, completion of audits (daily through monthly), creation/maintenance of desktop procedures/instruction manuals for existing processes, assisting during testing of new processes, and maintenance of data dictionaries

 

Database Consultant (1 year)

  • At least 4-5 years combined using both MSSQL and Oracle RDBMS
  • Creation and maintenance of large data warehouse databases (up to 1TB)
  • Extensive development of stored procedures (containing complex business logic) and views
  • Experience with performance tuning and integrity via indexing, normalization/de-normalization, constraints, triggers, etc.
  • Understanding of database security and implementation using views, column level permissioning, and roles.
  • Excellent debugging and communication (both written and verbal) skills required
  • Excellent project management and organizational skills
  • Experience creating and updating technical documentation and following development methodology
  • Windows command line scripting and UNIX shell scripting including Awk
  • Experience acting as a liaison between non-technical business users to create appropriate business requirements
  • Data analysis experience helpful
  • Database maintenance including backup and recovery, space management, and consistency checks
  • Responsibilities to include monitoring existing processes to populate data warehouse, improving performance of existing SQL processes, assisting in the development of new processes for data gathering, completing project documentation, and development and maintenance of data dictionaries

 

For immediate consideration, please contact:

Anne Keehan

Partner

Brandywine Technology Partners

Phone: 302.656.6100 x225

Email: akeehan@btpartners.net

http://www.AcehAid.org

Two Vermont IT Jobs: .NET Programmer and EDI Support Specialist

A national leader for more than 30 years, A.N. Deringer offers turnkey logistics solutions to shippers around the world. From global transportation to international trade consulting, our team of logistics specialists optimizes import and export operations.  We currently seek the following Information Technology professionals in our St. Albans, Vermont location:

Programmer Analyst
The successful candidate will work with existing programming staff to support web based and other customer systems, and will be experienced in .Net, C#, SQL 2000, Visual Basic and Visual Studio. An ability to manage multiple tasks concurrently, a results driven and organized approach, and the ability to communicate with clients and vendors, round out key job requirements. 3-5 years experience and a Bachelor’s degree preferred.

EDI Support Specialist
In this role the ideal candidate will work with the existing EDI team to convert customers from manual entry to EDI entry. Skills required include XML, EDI – standards 810, an organized, structured approach to work, and the ability to manage multiple conversions simultaneously.  Strong interpersonal skills are a must when working with customers and technical colleagues.  3-5 years experience and a Bachelor’s degree preferred.

Interested applicants should send a cover letter and resume directly to our search firm in care of:    kathy@vermontdatabase.com

http://www.AcehAid.org

Vermont IT Jobs – .NET Business Analyst/Programmer

Technical Connection, in partnership with a major national corporation with offices in Vermont, seeks a Professional Programmer and Business Analyst with demonstrated proficiency in .Net software development.  Starting as a contract, the position is slated to morph into a direct, benefited position with the Corporation.
 
Interested parties can Chris Johnson or Kathie Taft.  Email resumes are preferred.
 
Technical Connection, Inc.
Vermontjobs@aol.com
802-658-TECH

http://www.AcehAid.org

SQL Server Expert Job in Connecticut

(If you are a vermont.net member, you are not allowed to apply for this job and move away. :-))

SQL Server 2000 Expert

** Full-time position, Location is Connecticut, Salary is negotiable and highly competitive **
Responsibilities:
• Maintain production SQL server environment which supports a substantial base of mostly custom applications
• Serve as subject matter expert in working with Database/Software Developers and Data Analysts to define data models, schemas and database application architectures
• Implement and Manage best practice based security model and auditing including delegation, Kerberos and encryption
• Gain intimate familiarity with normal usage and operations of database applications in order to troubleshoot real-time issues and optimize databases, indexing and data allocations for efficiency and issue avoidance
• Design, development and installation of SQL monitoring systems and solutions
• Responsible for the implementation and operation of disaster recovery strategy, architecture, and detailed plan for all database applications
• Design and implement high availability, clustered, and replicated SQL environments where desirable and feasible
• Establish and document coding standards and best practices for schema design and T-SQL queries
• Establish and monitor procedures and technologies for creating and maintaining data dictionaries
• Establish and monitor procedures and technologies for change management within SQL Server
• Research and advance new technologies affecting SQL Server development that may provide value to enterprise applications
• Lead SQL Server in-house training efforts through the development of syllabi, course materials, and core knowledge requirements
Experience:
• Expert level experience with Microsoft SQL 2000 – including usage, administration, monitoring, optimization, architecture, etc
• Substantial experience with large data sets – over 100GB in size
• Expert in profiler, real-time analysis, monitoring solutions
• Expert in Performance Optimization of queries and SQL code
• Significant experience in resolving complex, multi-component failures
• Must be able to create all aspects of documentation that follows traditional systems design methodologies
• Must have excellent organization, communication, teamwork and leadership skills.
• Must have demonstrated, strong attention to detail and quality.
• Must provide examples of analyzing and optimizing business processes in past roles
• Experience with OLAP services is desired
Near-term Projects in Addition to Ongoing Responsibilities:
• Baseline and gap analysis of current SQL environment vs. ideals and best practices
• Develop short and long term strategy for SQL environment monitoring and alerting
• Design and implement a SQL basic training course for in house developers to ensure a minimum threshold of consistent and appropriate SQL knowledge
• Create and begin the preparation process for an eventual migration to the SQL 2005 platform

For immediate consideration, please contact:
Anne Keehan
Partner
Brandywine Technology Partners
Phone: 302.656.6100 x225
Email: akeehan@btpartners.net

http://www.AcehAid.org

Slew of off-site consulting projects

by way of programmer-jobs@yahoogroups.com (which I must admit I NEVER subscribed myself to, but I will leave myself on it…)

Here is an example (just came through my inbox)

THIS IS A WORK-AT-HOME PROGRAMMING JOB:
Program database driven web app for small entertainment company.  Project will iinvolve any and all technologies that are appropriate with emphasis on SQL, asp (or .net), java, vbscript, html.  Web application will handle 1. searching for live entertainment (bands, DJs, motivational speakers, magicians, etc), 2. booking entertainment, 3. setting up an entertainers press kit file (so it can be searched) and 4. production management of an event.  Some modules are complete while others exist in MS Access and must be converted web apps.            

APPLY ONLINE AT:
http://www.programmingfromhome.com/Job.cfm/202729

http://www.AcehAid.org