Data Base Administrator

Summary of Position:
Responsible for designing methods to store, analyze, utilize, and organize data. Sets up computer databases after identifying user needs. Migrate data from old systems to new system.
Install, upgrade and patch, design backup and recovery procedures, import\export database schemas, stored procedures, packages, triggers, T/SQL. Write complex queries and perform SQL tuning and database performance tuning. Maintain responsibility for maintaining ERDs and data dictionaries, troubleshooting database-related issues, and deploying database changes to development, test, and production environments.
Duties & Responsibilities:
Responsible for all functions associated with the design, implementation and maintenance of SQL Server databases including security, back-up, logging, reporting and recovery procedures
Transform data via standardization, cleaning, data repair, matching, and de-duping
Manage data from multiple sources including internal, external, and 3rd party data
Assist in maintaining and improving database operational efficiency
Perform daily, weekly, and monthly data maintenance tasks
Assist in developing feeds to Data Warehouse and Marts
Ensure data can be provided to support OLAP reports and various reporting requirements
- Troubleshoot and resolving database integrity issues, performance issues, blocking and deadlocking issues, replication issues, log shipping issues, connectivity issues, security issues etc.
SQL database Performance Tuning, Query Optimization, using Performance Monitor, SQL Profiler and other related monitoring and troubleshooting tools
- Knowledge of backups, restores, recovery models, database shrink operations, DBCC commands, Clustering, Database mirroring, Replication.
- Create ETL packages from a variety of sources for database loading
- Strong knowledge of how indexes, index management, integrity checks, configuration, patching. How statistics work, how indexes are stored, how they can be created and managed effectively.
- SQL Development - ability to write and troubleshoot SQL Code and design ( stored procs, functions, tables, views, triggers, indexes, constraints )
- Documentation skills for processes and procedures ( creating KBs, runbooks, topology etc )
- May require off hours work for maintenance

BS degree (computer science or equivalent, MS preferred)
3 years of experience functioning as a DBA in a production SQL environment
Experience with MS SQL Server 2012/2014, including use of Query Analyzer, stored procedures, DTS, Jobs and Profiler
Experience creating and maintaining an extraction, transformation, and loading process from source systems or files into a data warehouse
Experience with managing data in Microsoft Access and Excel
Understanding of XML helpful
Project Management skills highly desired
Strong communication skills required
A desire to exceed project, client and co-worker expectations

Don't Be Fooled

The fraudster will send a check to the victim who has accepted a job. The check can be for multiple reasons such as signing bonus, supplies, etc. The victim will be instructed to deposit the check and use the money for any of these reasons and then instructed to send the remaining funds to the fraudster. The check will bounce and the victim is left responsible.

More Jobs

Communications and Project Administrator
Cambridge, MA Massachusetts Institute of Technology
Editor in Chief, Data Science Journal
Cambridge, MA RELX Group
Snr. Production Control Administrator/Analyst
Waltham, MA The Panther Group
Executive Director, Administration - Partners ...
Somerville, MA Partners HealthCare System
Outreach/School Based Clinician
Haverhill, MA Lahey Health