Hi,
Hope you are doing great.
Kindly let me know your comforts on the following position and please do reply me with your updated resume sai@burgeonits.com
Position: SQL DBA Consultant
Location: Houston, TX
Duration: 6 months
Job Description:
· Extensive experience in installation and configuration of MS SQL Server 2000, 2005 and 2008,2012 and 2014 versions
· Experience in performing SQL server up-gradation activities.
· Experience in applying latest released SQL Server Patches (2000,2005,2008,2012,2014)
· Extensive Experience in SQL Server Migrations of various versions(2000,2005,2008,2012,2014)
· Monitoring the SQL server related services and using the SQL Configuration manager.
· Database Connectivity between the servers (Application servers, webservers, and database servers).
· SQL server Securitymanagement (creation of users, configuring permissions and assigning roles to users.)
· Creating tables, views, indexes, stored procedures, triggers, cursors.
· Experience in configuring and monitoring the High availability solutions in SQL:
a. SQL server Clustering
b. SQL server Mirroring
c. SQL server Log Shipping
d. SQL server replication
· Analyzing and defining capacity planning for maintenance of the Database backups.
· Configuring the Database maintenance plan as per thecapacity planning and priority/severity of the Database and defining the required retention period for the backup storage.
· Configuring and scheduling SQL server jobs as per the definition.
· Configuring Database mail and defining email alerts for any failures.
· Setting up linked servers and troubleshooting any issues related to ODBC connectivity.
· Experience in using SQL server Performance Monitoring tools
· Experience in Performance Tuning, Database consistency checks using DBCC Utilities.
· Extensive experience in trouble shooting database issues.
· Monitor SQL Error Logs/ Schedule tasks/data activity/ eliminate blocking and deadlocks/ user counts and connections/ locks
· Perform periodic checking of databases with DBCC command for maintaining data consistency and integrity and rebuilt indexes.
· Performing Database Refresh in production/Development/UAT environments.
· Knowledge on SQL server MSBI Tools(SSIS,SSRS,SSAS)
· Experience on Incident Management, Problem Management and Change Management.
· Coordination with different Teams (like Network Team and other application Teams).
· Coordination with Stake holders and customers.
· Experience on windows Server Administration (Start /Stopping of the Services, Virtual Memory Configurations, logical disk space management, folder permissions, user permissions, ensure patching the servers by coordinating with windows admin teams e.t.c)
· Joining Bridge Calls and should be there on the calls until resolution of the issues and documenting the RCAs for Team's future reference.
· Building knowledge documents on resolutions and issues.
· Experience on analyzing the log files on trouble shooting the issues.
· High Memory Consumption Processes, memory threshold values, and Ensure sufficient free disk space availability in all the servers.
· Providing proactive recommendations based on application usage.
· Work with internal/external audit requests/requirements to ensure compliance with audit requests
Preferred
• Microsoft Certified Professional (MCP) – Must
• ITIL V3/V2 – desired.
You received this message because you are subscribed to the Google Groups "US Jobs: Requirements, Clients and Consultants" group.
To unsubscribe from this group and stop receiving emails from it, send an email to recruiters-r-us+unsubscribe@googlegroups.com.
To post to this group, send email to recruiters-r-us@googlegroups.com.
Visit this group at http://groups.google.com/group/recruiters-r-us.
For more options, visit https://groups.google.com/d/optout.
No comments:
Post a Comment