Job description

Requirements:

-Minimum of 5 years of experience as a SQL Server DBA in SQL server 2005 or above.

-Excellent understanding of SQL with experience with performance monitoring, analysis, and tuning of relational databases. This includes the use of T-SQL, profiler, tuning advisor, indexes, statistics, query plan analysis.

Experience with:
-Creating triggers, stored procedures, and complex join statements

-Migrating data to/from other data sources using DTS/SSIS/SSRS and deploying/maintaining packages/jobs.

-Engineering DR/BC and backup solutions including full, differential, transactional backup, backup mirroring, and automated maintenance jobs with alerting.

-Experience with Azure

-DP300, specifically in the areas listed below

• Plan and implement data platform resources
• Implement a secure environment
• Monitor and optimize operational resources
• Optimize query performance
• Perform automation of tasks
• Plan and implement a High Availability and Disaster Recovery (HADR) environment
• Perform administration by using T-SQL

*

- AZ104 or az-104

-Database Administration for SQL Server installations including capacity planning, installing, upgrading, configuration and patching, and all functions to provide high availability, high performance, and high security.

-Implement and support housekeeping procedures such as backups, integrity checking
Production and maintenance of high-quality documentation.

-Providing overnight and off-hours support as part of a support team.

-Experience with setup and support database clustering, mirroring, replication, and log shipping in Windows 2003/2008 enterprise environment.

-Knowledge of table partitioning and archiving mechanisms.

-Ability to function well in a virtual team working independently while managing time and priorities in a 24 X 7 DBA remote support environment.

-Must possess strong interpersonal skills. Previous consulting experience is a plus.

-Must be eligible to work in the United States

Job Type: Full-time

Pay: $120,000.00 - $148,000.00 per year

Benefits:

• 401(k)
• Dental insurance
• Health insurance
• Paid time off
• Vision insurance

Schedule:

• 8 hour shift

Work Location: Remote

gatheringourvoice.org is the go-to platform for job seekers looking for the best job postings from around the web. With a focus on quality, the platform guarantees that all job postings are from reliable sources and are up-to-date. It also offers a variety of tools to help users find the perfect job for them, such as searching by location and filtering by industry. Furthermore, gatheringourvoice.org provides helpful resources like resume tips and career advice to give job seekers an edge in their search. With its commitment to quality and user-friendliness, gatheringourvoice.org is the ideal place to find your next job.