*SQL Server DBA* *Philadelphia, PA* *LONG TERM* *F2F MANDATORY – LOCALS OR NEAR BY’s ONLY*
*Job Description: * - Providing support for pre-production and production database servers. - Installing and configuring SQL Server and Oracle database server. - Creating database and assigning proper security rights to users. - Auditing, user permissions and checking for non-compliances. - Coordinate with other functions for service requests and resolutions of issues - Implementing High Availability solutions like SQL Mirroring in SQL 2008. - Patching, upgrading and migrating databases. - Creating backup strategies for maximum databases availability. - Use red gate SQL backup for SQL and RMAN for Oracle, - Tuning Oracle database SGA/PGA parameters and analyzing AWR and ASH reports for database performance, - Using SQL profiler to collect trace and tune SQL databases. - Use Performance dashboard reports and Insight for tuning SQL databases. - Monitoring constant database growth and shrinking the files to release the unused space. - Capacity planning the database for future growth. - Documenting various database changes and logging database requests. - Administering in house applications database and providing resolutions to the problems - Managing & Administering WinDSX security application. *Thanks & Regards,* *Ashok Kumar* *Siyaton Global Solutions, Inc.* *as...@siyaton.com* <as...@siyaton.com>* | **ashok.siya...@gmail.com* <ashok.siya...@gmail.com> 1590 S. Milwaukee Ave | STE # 317 | Libertyville, IL 60048 *Desk: 703 468 1867 | Mobile: **929 249 4938 **| Fax: 703 738 7887* -- You received this message because you are subscribed to the Google Groups "Oracle-HRMS-India" group. To unsubscribe from this group and stop receiving emails from it, send an email to oracle-hrms-india+unsubscr...@googlegroups.com. To post to this group, send email to oracle-hrms-india@googlegroups.com. Visit this group at http://groups.google.com/group/oracle-hrms-india. For more options, visit https://groups.google.com/d/optout.