Skype Hire : SQL DBA | Round Rock TX
Rachit Khanna
Hi,
Please find the below mentioned JD.
Position : SQL DBA
Location : Round Rock TX
Duration : 6-12+ Months
MOI : Phone/Skype
MUST HAVE: We need well qualified SQL Server DBA’s that have experience in ecommerce, performance and replication.
Role Overview:
· Database Administration Sr. Advisor to support Production, Non Production Database Servers & Projects.
Role Responsibilities
· Admin skillset
· Database Administration for the SQL Server 2005 and above (Maintenance, Security, Upgrades, Performance Tuning, etc.)
· Installing, Configuring and Upgrading SQL Server/Applying Service Packs
· Server and Database Security Administration
· SQL Server Replication Designing SQL Server Systems and Implement
· A good knowledge of the physical database design
· Create database objects (tables, indexes, etc.)
· Write database procedures, functions and triggers
· Tune database queries, tuning and Monitoring SQL Server
· Code or data synchronization
· Ensure data consistency in the database through DBCC commands.
· Should have experience with using Trace flags / Profiler to solve Dead Locks/Long running queries.
· Should be very strong in replication concepts and troubleshooting replication issues with in SLA.
· Extensive experience in designing and handling Disaster recovery/high availability.
· Failover Clustering
· Data Modeling
· Implementation experience in Enterprise wide automation tools/custom automation.
· Data Transformation and Loading
· Experience with SSIS and SSRS troubleshooting
· Upgrade from DTS to SSIS packages
· Backup the current code for rollback purposes
· Analysis - Analyze the data to determine the core problems
· Testing - Test the various options to ensure they perform better and do not cause worse performance in other portions of the application
· Plan growth and changes (capacity planning)
· Perform general technical trouble shooting and give consultation to development teams
· Interface with Microsoft Corporation for technical support.
· Patch Management and Version Control
Tools
· Should have good understanding of the MS SQL, related utilities and tools Identification
· Use native tools like Profiler, Perfmon, system stored procedures, dynamic management views, custom stored procedures or third party tools
· Backing Up and Restoring SQL Server, Knowledge of ALL MS DB backup and recovery scenarios
· Establish and maintain sound backup and recovery policies and procedures
· Backup tools
· Performance tools
· Check for failed processes
· Research errors, Validate disk space is not low, validate none of the databases are offline or corrupt
· Perform database maintenance
· Perform both MS SQL and operating system performance tuning and monitoring
Automation:
· Monitor application related jobs and data replication activities (Automated)
· Setup custom scripts to query for particular issues and email the team
· Write error messages centrally in the application and review that data
· Setup Operators and Alerts on SQL Server Agent Jobs for automated job notification
SoftSkill
· Should have sound communication skills with management, development teams, vendors and systems administrators
· Setup and maintain documentation and standards
· Review the current process to understand what is occurring
· Determine what the business and technical problems are with the process
· Document the requirements for the new process
· Provide a strategic database direction for the organization
· Should have the ability to handle multiple projects and deadlines
· Should possess a sound understanding of the business
· Good understanding of the underlying operating system
Requirements
· At least 8-10 or more years