MARKET TITLE: SQL Server DBA with MongoDB skills
LOCATION: Remote - based anywhere in the USA
W2 Only

Primary Skill SQL Server ; Secondary Skill - MongoDB
8-10+ Years of Database Administration experience in the SQL Server 2005 to SQL Server 2019 (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
- Familiarity with SQL Always-on technologies and the latest versions of SQL Server

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

All your information will be kept confidential according to EEO guidelines.