I’ve been acting as the part time DBA around here since the company started. I know way more than I care to about things like backups, indexing, clustering, replication, etc. Now the company needs things like OLAP, Report Server and all sorts of other fun things that I just don’t have the time for since my job as Chief Software Architect already keeps me busy enough. So, if you’ve got the skillz, are interested in working for one of the fastest growing technology companies out there and would love to be the lead DBA for the whole company, drop me a line and I’ll let you know where to send your resume. Here’s what we’re looking for:
Primary Responsibilities:
- Support multiple databases in development and production environments
- Working with other teams in ongoing design, testing and support of business database needs
- Troubleshoot day to day database and related application issues
- Assist in security of databases to ensure accurate and appropriate use of resources and data
- Perform scheduled tests to assess the database backup plan and the integrity of the backups
- Create hardware specs for new server purchases by using trends and benchmarking evidence
- Traditional database maintenance tasks: back ups, restores, indexing, replication/job monitoring, etc.
Required Skills:
- Relational Database Design / Normalization
- OLAP Design
- Performance Analysis and Tuning
- Database security
- Data access (application level) security
- Review of developer created SP’s, triggers and user defined functions
- Excellent troubleshooting skills
- Experience with Analysis Services
- Experience with MSSQL Reporting Services (writing and maintaining reports)
Additional Skills desired:
- Clustering Experience
- Experience with SQL 2005 and Database mirroring
- SQL Disaster recovery planning and execution
- Experience with Disaster Recovery Planning and Testing
- Knowledge of server hardware and capacity planning
- Experience with .NET
- Replication configuration, maintenance, and monitoring
Required background:
- Five years or more experience as a MS SQL Server DBA
- Extensive knowledge of MS SQL Server (2000 / 2005)
- Proficient with Windows 2003 Server
- Ability to work in a 24×7 support environment
- Excellent verbal and written communication skills
- Must be a self starter who is able to work independently as well as within a team
- Experience in an eCommerce, medium business environment