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: [email protected]

http://www.AcehAid.org

  Sign up for my newsletter so you don't miss my conference & Pluralsight course announcements!  

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.