| Sr. MS SQL DBA-SLG - 19 - 9423-Albany,NY at Albany, New York, USA |
| Email: [email protected] |
| From: Srikanth Vanam, Sligosoft [email protected] Reply to: [email protected] Greetings from Sligo Software Solutions, Inc. !! SLIGO is a Software Development & IT Consulting company. We have around 100+ IT associates working with our esteemed clients across several domains such as IT, Banking, Healthcare, and Government. We have an urgent requirement for Sr. MS SQL DBA position with our client. Role: Sr. MS SQL DBA Location: Albany, New York Duration: 24 Months Job ID: SLG - 19 - 9423 Client: NY State Description Based on Governors Office priorities, there are crucial initiatives that benefit New York State Higher Education Services (HESC) and are part of the ITS/HESC project portfolio. This position will supplement the GLP DB staff for governor initiatives resulting from the 2024 NYS Budget and that effect HESCs Grants and Scholarship programs. Duties Build and maintain a data architecture based on the requirements. Design and develop Logical and Physical Data Model using ER Studio Data Architect. Create DDL scripts to establish and maintain necessary databases. Write complex SQL queries against SQL Server and DB2 databases. Create DML scripts to manipulate data. Work with project managers, solution architects, business analysts, application development teams and QA to ensure the quality of DDL and DML scripts. Performance tuning SQL to improve efficiency. Working with NYS Agency representatives to develop gap analysis specifications and understand Agency business rules. Provide guidance and hands-on development for developing and maintaining queries in QMF for Workstation. Create clear and accurate documentation on data models, and description of data usage in the application process flow. Mandatory Requirements Experience (10+ Years) Database Administrator Uses specialized software to store and organize data, which may include capacity planning, installation, configuration, database design, migration, performance monitoring, security, and troubleshooting, as well as backup and data recovery. Requirements This is an 100% Onsite 84 months of Experience designing and developing logical and physical data models, and creating DDL scripts for tables, views, indexes, triggers, stored procedures. 84 months of Experience designing and developing Data Conversion Strategy Plan, Data Mapping Documents, Gap Analysis. 84 months of Experience writing complex DML SQL against enterprise SQL Server and DB2 databases. 84 months of Experience working with the tools like SQL Server Management Studio, SSMS Job Scheduler, SSIS, SSRS, Export/Import, ER Studio Data Architect, QMF for Workstation, Redgate SQL Compare, TSO. 84 months of experience using programming languages such as SQL, PL/SQL. 60 Months of experience performance tuning complex SQL against enterprise SQL Server and DB2 databases. Rsum Please submit a copy of resume which details relevant experience AND identifies a BS or MS Computer Science Degree and the School / Graduation Date obtained from. Srikanth Vanam Sr Talent Acquisition Specialist Sligo Software Solutions Inc. [email protected] www.sligosoft.com Keywords: quality analyst database information technology microsoft procedural language Idaho New York Sr. MS SQL DBA-SLG - 19 - 9423-Albany,NY [email protected] |
| [email protected] View all |
| Fri Apr 26 22:23:00 UTC 2024 |