Job Details: SQL Server Database Administrator
| Job Title: | SQL Server Database Administrator |
| Job ID: | DBAd |
| Company: | Collaborative Staffing Solutions |
| Position Type: | Permanent |
| Pay Rate: | BOE |
| Skills: | SQL Server |
| Date Posted: | Sep-16-08 |
Reporting to the Manager of Database and Architect, this senior level DBA would assist in providing world class support and leadership to our developers, application support and business teams.
PRIMARY RESPONSIBILITIES
- Manage a production environment consisting of 300+ databases, and 30 production SQL Server's, most of which are read-intensive databases with a large data load cycle while some are OLTP-based mission critical trading systems
- Spearhead the restructuring and management of the production level backup and restore processes
- Manage HA solutions such as MS Cluster Server, XOSoft, PolyServe, SQL Replication, etc
- Manage DR solutions such as Database Mirroring, Log Shipping, Double-Take GeoCluster, SQL Replication
- Assist in the development of a GDOC (Global Database Operations Center) where our systems will be continuously monitored via 3rd party products, in-house scripts and a operational dashboard
- Manage the database security models, both in-house developed as well as Windows Auth (AD) based security. Also develop policies to restrict over-privileging and enforce it
- Provide 24x7 support to all mission critical production level systems
- Develop custom scripts to automate various database management processes (e.g. programmatically searching for non-indexed tables)
- Leverage 3rd party tools (e.g. Red-Gate) or in-house developed tools to troubleshoot
- Safeguard our production systems by implementing the right security policies as well as managing the MS service pack/hotfix deployment process
- Assist in the migration of SQL Server 2000 to SQL Server 2005 and/or 2008
- Assist in the database release management process, be the “gate-keeper” and ensure only QUALITY code is released into production
- Help troubleshoot performance problems using a variety of methods (tracing, query optimization review, error logs, etc)
- Assist in the build out of our SQL Server Analysis Services 2005 (SSAS) OLAP databases
- Provide development and production support for complex SSIS packages
- Architect and implement reports within SQL Server Reporting Services 2000/2005
- Define and maintain critical documentation including: Database Standards, Naming Conventions, Administrative Techniques, Troubleshooting Techniques, Processes, Rules and Regulations, Change Management, Best Practices, etc.
MANDATORY REQUIREMENTS
- An average of 5-6+ years total IT experience
- An average of 4-5+ years Database Administration (Includes Development, QA experience)
- An average of 1-2+ years Systems / Network / Application Administration
- Knowledge of the financial industry is preferred
Please contact Albert Barsoumian with qualified resumes via email at albert@collabstaff.com or via phone at 508-872-7402.
| Location: [rss] | US-MA-Boston |
| Telecommute: | No (Onsite Position) |
| Contact Name: | Albert Barsoumian |
| Contact Phone: | 508-872-7402 |
| Contact Email: | albert@collabstaff.com |
| URL: | http://bostonfinancialjobs.blogspot.com |
Principals only. Recruiters, please do not contact this job poster.
View other jobs in US-MA-Boston »
View other jobs in US-MA »
View other SQL Server Database Administrator jobs, Database Administrator jobs, Tech jobs
View other jobs requiring these skills: SQL Server
View other postings by Collaborative Staffing Solutions »
