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
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!