*Hello,*
*This is Vijay kumar from Pronix Inc.* *Please submit Candidates for the below Requirement with Resume, Rate and Contact details. Make sure the Candidate's skills match the requirement below.* *Visa Copy is mandatory at the time of submission.* *Please share suitable profiles towards below position to [email protected] <[email protected]>* Job Title: MS SQL Server DBA Location: Pontiac, MI Duration: 12 months Minimum of 10 years of experience working as a SQL Server database administrator in a production environment Microsoft Certified Professional – SQL Server Excellent English spoken and written communication – must work with HPE, client, 3rd party vendors and make presentations to the Senior level client. Attend and document requirement gathering sessions. Extensive SQL Server performance tuning experience. Including, but not limited to, explain, plan, analysis, index recommendations, query monitoring, identifying badly behaved queries and providing recommendations. Monitor overall system performance to ensure that the entire system (not only queries) is running efficiently and able to make adjustments as needed. Ability to develop or review in detail, SQL code, created by 3rd party or Leveraged team, prior to being deployed into Dev/QA/Prod Experience defining data partitioning strategy and implementation with on-going projects. Ability to work with 3rd parties (RJRT, IM, Brock) to understand their data and its usage in order to effectively design the partitioning implementation of active projects. Work with the hosting dba team (HPE) to implement effective and efficient partitioning and ensure that the SQL Server server/instance is configured appropriately for the data volumes. Work with 3rd party system dba team to create an appropriate data backup implementation that will permit restoration that will meet defined RTO & RPO. Recommend system architecture e.g. clustering, mirroring, replication as appropriate. Work with the 3rd party storage administration team to correctly define required files and file systems on the appropriate tier of disk storage. Create or modify all necessary scripts to efficiently maintain various databases and their 18 months of data. Production Support activities to maintain the systems as business SLA’s require. 7x24 on-call support coverage shared with Leveraged DBA resource (.5 FTE). Respond to incident tickets using existing tool sets. Collect, maintain and create DB metric reports, analyze data, provide recommendations for improvements, provide trending analysis and recommendations Support/Enhance the HPE developed database code deployed to various servers, which include o Partition management o Index reorg/rebuild o Check database process o File group management o Database backups o Filegroup/database size management o Coordinate Custom Maintenance plans with HP ITO DBAs *Thanks&Regards* *Kumar* *Pronix Inc * *[email protected]* <[email protected]> *Work : 732 947 4816 |Fax : 732 909 2000* *www.Pronixinc.com* <http://www.pronixinc.com/>* |E-verfiy company*
