SQL Server DBA Onsite - Boston, MA 3 day per week Long-term contract, possible conversion Primary Responsibilities:
•Provide database administration services in support of web and client server applications. Must be able to provide both production and development DBA support tasks.
•Creating and maintaining database documentation, such as data dictionaries, entity relationship diagrams, data models, and stored procedures.
•Install, configure, upgrade and maintain databases on Windows (preferred) or other platforms.
•Administer database users, manage database objects, and configure client network.
•Perform logical and physical database design.
•Implement and enforce security for all the databases.
•Perform database monitoring and tuning using DMVs, Perfmon, profiler and other tools.
•Perform database refreshes of Development and QA databases.
•Work with the application development team on production release deployments.
•Provide support and consultation to the application development team in all database related areas including table and index design and creation and SQL tuning.
•Install and configure DBA management tools.
•Troubleshoot and correct database issues in an efficient and timely manner.
•Perform backup and recovery of databases.
•Support all nightly database maintenance and administration jobs.
•Maintain all production job scripts assigned to the database team.
•Proactively monitor databases and identify potential problems.
•Enforce all database architecture and relevant procedures according to established policies.
•Create, troubleshoot and deploy SSIS/SSRS solutions for data exports/imports and reporting needs.
•Must have worked in Microsoft clustering of SQL databases, Always ON high availability solutions.
•Position will report to the Senior Database Administrator.
The selected candidate must be able to manage database related services from the planning phase through the implementation and management phases. He or she will interface with other team members, management, and end-users on a regular basis. After hours, availability is required in order to respond to emergencies, production releases, and to perform database maintenance that cannot be completed during normal business hours.
Qualifications/ Skills:
•5+ years Database Administration experience; should have experience in test, development and production instances.
•In-depth knowledge of SQL server versions 2012/2016 and above, with SSIS/SSRS
•Experience with databases migrations of SQL Servers from older to newer versions
•Experience in configuring and maintaining SQL Always ON is required.
•Ability to execute performance monitoring and necessary adjustments.
•Excellent knowledge of backup and recovery scenarios and backup tools.
•Highly self-motivated individual who has the ability to work independently as well as in a team environment.
•Excellent verbal and written communication skills; ability to think strategically with technical vision; proven project management and leadership skills; attention to detail and strong organizational skills.
•Oracle experience a plus.
Required Skills : 5+ years of SQL DBA experience (not looking for a dev - need someone who is doing back ups and restores, maintenance and monitoring) 3+ years of experience with Always On Nice-to-Have: SSIS / ETL Data migration experience (from 1 version of SQL Server to another)
Basic Qualification : Day-to-day: Typical DBA responsibilities - keeping the lights on, making sure backups are running correctly, checking on nightly jobs, if things failed, what's going on/how can they fix it, monitoring to make sure things look good Must Haves: 5+ years of experience DBA experience required (not looking for a dev - need someone who is doing back ups and restores, maintenance and monitoring) Nice-to-Have: SSIS / ETL Data migration experience (from 1 version of SQL Server to another) SQL Always On - required (In the process of getting a disaster recovery site up) +
Additional Skills : Day-to-day: Typical DBA responsibilities - keeping the lights on, making sure backups are running correctly, checking on nightly jobs, if things failed, what's going on/how can they fix it, monitoring to make sure things look good Must Haves: 5+ years of experience DBA experience required (not looking for a dev - need someone who is doing back ups and restores, maintenance and monitoring) Nice-to-Have: SSIS / ETL Data migration experience (from 1 version of SQL Server to another) SQL Always On - required (In the process of getting a disaster recovery site up) +
Background Check :Yes
Drug Screen :Yes
Notes :
Selling points for candidate :
Project Verification Info :
Candidate must be your W2 Employee :Yes
Exclusive to Apex :No
Face to face interview required :No
Candidate must be local :Yes
Candidate must be authorized to work without sponsorship :Yes
Interview times set : :No
Type of project :Administration/Support
Master Job Title :DBA: SQL Server
Branch Code :San Diego