Ryan Consulting Charlotte, NC
- Expired: over a month ago. Applications are no longer accepted.
This job is for a senior-level SQL Server DBA providing operational database management tasks for select customers. The DBA will be self-sufficient in terms of their abilities to exceed customer expectations while being part of a team to lend support and assistance when needed.
Database support will include day-to-day duties for proper database maintenance along with proactive measures to maximize the database availability and performance.
This job will provide the flexibility to work from a home office a majority of the time with occasional visits to customer locations.
Job includes aspects of 24x7 support in conjunction with other team members.
-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.
-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
The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.
While performing the duties of this job, the employee is frequently required to use hands to finger, handle, or feel and talk or hear. The employee is required to stand; walk; sit; reach with hands and arms; climb or balance and stoop, kneel, crouch, or crawl. Additionally, the employee must occasionally lift and/or move up to 50 pounds.
Specific vision abilities required by this job include color vision, depth perception, and ability to adjust focus.
Ryan ConsultingWhy Work Here?
Fortune 100 client, remote work, great culture, opportunity to be converted into a full-time employee!
TechnologyView all jobs at Ryan Consulting