Job Description:
Trigyn's direct government client has an immediate need for Database Architect in Albany, NY.
Description:
• Provide support for the administration and maintenance of SQL Server databases.
• 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.
• Design and implement fast, scalable, and maintainable cubes.
• Monitor database usage, identify corrective actions when necessary and apply changes needed to handle data growth and performance degradation.
• Monitor database security and assign user access, grant permissions and roles, develop groups, audit access, etc.
• Perform impact analysis on hardware configurations, database schema, and application code, to offer recommendations on improving design and efficiency.
• Write SQL code via stored procedures and Transact-SQL to access data.
• Develop database design 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 SQL Server.
• 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 and development environments.
• Implement and manage SQL Server database replication.
• Monitor replication to ensure the data is being properly replicated.
• Assist in reviewing and modifying a disaster recovery plan that allows for continuation of service.
• Run database jobs, i.e. reorgs, imports and exports, backups, 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.
Mandatory Qualification:
• Determines database structural requirements by analyzing client operations, applications, and programming; reviews objectives with clients; evaluates current systems; provides database support by coding utilities, responding to user questions, and resolving problems.
• Candidate is able to provide guidance to large teams and/or has extensive industry experience and is considered at the top of his/her field.
• 84 Months of experience establishing, maintaining and troubleshooting SQL Server DBMS in an enterprise-wide database within a Windows environment
• 84 Months of experience establishing, maintaining and troubleshooting SQL Server DBMS that utilize High Availability in a Windows environment
• 84 Months of experience designing and implementing fast, scalable, and maintainable cubes.
• 60 Months of experience performing SQL Server optimization analysis and implementing resolutions.
• 60 Months of experience performing working with Transact SQL and SQL Server Data.
• 48 Months of experience working with end users providing DB support.
• 48 Months of experience performing optimization analysis and implementing resolutions in SQL Server Analysis Server.
• Bachelor's Degree.
For Immediate Response call 732-640-2404, or send your resume to RecruiterPK@Trigyn.com
TRIGYN TECHNOLOGIES, INC. is an EQUAL OPPORTUNITY EMPLOYER and has been in business for 35 years. TRIGYN is an ISO 9001:2015, , ISO 27001:2013 (ISMS),ISO 20000:2018 and CMMI Level 5 certified company.