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 24×7 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 use of tSQL, 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 and deploying/maintaining packages/jobs.
-engineering DR/BC and backup solutions including full, differential, transactional backup, backup mirroring and automated maintenance jobs with alerting
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 of 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 in table partitioning and archiving mechanisms
Ability to function well in a virtual team working independent 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.