Estimated Length: 3 months Full-Time 8 hour works days 

Mandatory Requirements

Skill Level:  Junior (12-36 months)

Desired Requirements

• 36 Months of experience establishing, maintaining and troubleshooting Sybase ASE (Version 11.9.2 or later) DBMS.
• 36 Months of experience performing Sybase optimization analysis and implementing resolutions.
• 36 Months of experience working with Transact SQL and Sybase Data.
• 36 Months of experience working with end users providing DB support.
• Bachelor’s Degree

Responsibilities

• Provide support for the administration and maintenance of all Sybase databases and user accounts.
• Monitor applications use of the databases and make recommendations to improve efficiency and response time.
• Set up, monitor, and update jobs performing data backups and recoveries.
• Monitor database usage, identify corrective actions when necessary and apply changes needed to handle data growth and performance degradation (data archival, DB size increase, indexing, etc.)
• Perform impact analysis on hardware configurations, database schema, and application code, to offer recommendations on improving design and efficiency.
• Develop database designs by performing needs analysis, creating logical model, and implementing the physical model.
• Follow/develop sound database practices.
• Ensure databases are available to users during business working hours and any routine maintenance is performed off hours.
• Install, configure, patch, and upgrade Sybase ASE.
• Monitor disk space utilization and logs and notify appropriate staff when additional resources are needed.
• Assist staff in setting up, maintaining, backing up and restoring databases in test environments.
• Assist in reviewing and modifying a disaster recovery plan that allows for continuation of service using our hot site.
• Run database jobs, i.e. reorgs, imports and exports, backups, etc.
• Monitor database security and assign user permissions, develop groups, assign roles, audit access, etc.
• Troubleshoot issues and take corrective actions as needed.
• Monitor data integrity to ensure data is not damaged and/or corrupt.
• Create and maintain documentation related to all tasks and provide mentoring/knowledge transfer to other staff within the Database group.

Founded in 1995, IIT is a leading provider of Workforce Solutions to Government and Fortune-1000 organizations. IIT is a winner of Inc-500 award. IIT's core services include:

Headquartered in New York, IIT has over 400 consultants deployed at Client Sites. Other IIT highlights include

Our Consultants love working for IIT

Follow us on LinkedIn or Twitter or Facebook

IIT is an Equal Opportunity Employer