USA Jobs, Careers and Recuitements
Job Target Job Search
[x]

Contact Information

Company: ACRO STAFF
Contact Name: DAVE
Website: http://www.acrostaff.com

Job Details: Database Administrator Date: Feb 19 2020

Job Reference: 2322
Job Category: IT Jobs [ View All IT Jobs Jobs ]
Company Type Recruiter
Employment type: Full Time, Contract
Salary: 65 USD / Contract
Degree: Masters
Experience: 3 years
Location: Albany, New York, 12206
Job Skills: Database Administrator
Share Job with Others

Job Tools

Job Description

Direct End Client: State of New York
Job Title: Database Administrator
Duration: 24 Months
Location: Albany, NY
Position Type: Contract

60 Months of experience establishing, maintaining and troubleshooting SQL Server Database Management Systems in an enterprise-wide database within a Windows environment.
60 Months of experience establishing, maintaining and troubleshooting SQL Server Database Management Systems that utilized High Availability solutions in a Windows environment.
60 Months of experience designing and implementing fast, scalable, and maintainable cubes.
48 Months of experience performing SQL Server optimization analysis and implementing resolutions.
48 Months of experience working with Transact SQL and SQL Server Data.
30 Months of experience working with end users providing DB support.
30 Months of experience performing optimization analysis and implementing resolutions in SQL Server Analysis Server.
Bachelor’s Degree

Description:
The Division of Nutrition (DON) manages programs designed to improve the health and nutritional status of the residents of New York State. Improving the diet of the public is a key factor in improving public health among those most at risk for serious illness.

The Division of Nutrition relies heavily on custom software applications in order to effectively and efficiently support many nutritional programs, including:

• Women, Infant, and Children Food Nutritional Program (WIC)
• Commodity Supplemental Food Program (CSFP)
• Child and Adult Care Food Program (CACFP)

A DBA is needed for support and maintenance of the databases used by the software applications. The DBA is also needed for the successful development of database cubes.

1. Provide support for the administration and maintenance of all SQL Server data bases.
2. Monitor applications use of the data bases and make recommendations to improve efficiency and response time.
3. Set up, monitor, and update jobs performing data backups and recoveries.
4. Design and implement fast, scalable, and maintainable cubes.
5. 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.)
6. Monitor database security and assign user access, grant permissions and roles, develop groups, audit access, etc.
7. Perform impact analysis on hardware configurations, database schema, and application code, to offer recommendations on improving design and efficiency.
8. Write SQL code via stored procedures and Transact-SQL to access data.
9. Develop database designs by performing needs analysis, creating logical model, and implementing the physical model.
10. Follow/develop sound database practices.
11. Ensure databases are available to users during business working hours and any routine maintenance is performed off hours.
12. Install, configure, patch, and upgrade SQL Server.
13. Monitor disk space utilization and logs, and notify appropriate staff when additional resources are needed.
14. Assist staff in setting up, maintaining, backing up and restoring databases in test and development environments.
15. Implement and manage SQL Server database replication.
16. Monitor replication to ensure the data is being properly replicated to HotSite.
17. Assist in reviewing and modifying a disaster recovery plan that allows for continuation of service using our hot site.
18. Run database jobs, i.e. reorgs, imports and exports, backups, etc.
19. Troubleshoot issues and take corrective actions as needed.
20. 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.

Copyright © 2020 Jobxoom All rights reserved. Use of this site is subject to certain Terms and Conditions.