| SQL Database Architect - Albany, NY (Hybrid) at Albany, New York, USA |
| Email: [email protected] |
| From: Yogesh Dahiya, SSPEARHEAD INC [email protected] Reply to: [email protected] Hi, Hope you are doing good. Please have a look on below position and let me know if you are interested Required Documentation : Make sure you if you are fine with this job then please share the below details at the time submission time. If you are not going to provide these details then please dont apply for this job. 1: Passport mandatory for these visas ( EAD, GC and H1B) 2: Visa stamping copy required for H1 B 3: Must be provide 3 references with full name, email id, client name and phone number. Job Description: Job Id: HBITS-06-13600 Role: Database Architect Client: NYS DOH Duration: 30 months Location: Albany, NY (50% Onsite) There is only 1 round interview direct client. Qualifications Database Architect: CIPS project 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. Expert 84+ months: 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 Daily tasks will include: 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. E-mail is the best way to reach me, if I dont pick your call. Thanks & Regards Yogesh Dahiya Sspearhead Inc Keywords: database green card Idaho New York SQL Database Architect - Albany, NY (Hybrid) [email protected] |
| [email protected] View all |
| Tue Oct 01 20:45:00 UTC 2024 |