*Hi all * *Job Title : SQL DBA. * *Location: Columbus OH* *Interview: phone then skype* *18 month contract*
*Experience must include: * *1. Managing and administering SQL Server 2008 R2 or above database servers; * *2. administering Windows Server 2008 R2 or above servers; * *3. designing, implementing and supporting packages using SQL Server Integration Services (SSIS); * *4. designing and implementing reports using SQL server Reporting Services (SSRS); * *5. writing TSQL queries and Stored Procedures; and * *6. designing and implementing high availability solutions like local resiliency through Windows Failover Clustering, site resiliency through Database Mirroring, and disaster recovery capability through Log shipping.* *Must be available for rotating on-call production support (twice every eight weeks, primary for the first and secondary/backup for the second).* *1. Being part of a rotating on-call production support team (twice every seven weeks, primary for the first and secondary/backup for the second),* *2. Establishing and executing Microsoft and JPMC Corporate SQL Server best practices.* *3. Fulfilling database related requirements through project work. Specifically, testing programs and/or databases, to correct errors and make necessary modifications. * *4. Modify existing databases and database management systems or direct programmers and analysts to make changes. * *5. Plan, coordinate, implement and document security measures to safeguard information in computer files against accidental or unauthorized damage, modification or disclosure. * *6. Work as part of a project team to coordinate database development and determine project scope and limitations. * *7. Write and code logical and physical database descriptions and specify identifiers of database to management system or direct others in coding descriptions.* *-- * *Thanks & Regards* *Ranjith Kumar* *Ph:(925) 973-0000 x 232(Off) * *Email: ranj...@allianceit.com <ranj...@allianceit.com>* -- Thanks & Regards Ranjith Ph:(925) 973-0000 x 232(Off) Email: ranj...@allianceit.com -- You received this message because you are subscribed to the Google Groups "Powerbuilder Assignments" group. To unsubscribe from this group and stop receiving emails from it, send an email to powerbuilder-assignments+unsubscr...@googlegroups.com. To post to this group, send email to powerbuilder-assignments@googlegroups.com. Visit this group at https://groups.google.com/group/powerbuilder-assignments. For more options, visit https://groups.google.com/d/optout.