Select which account you would like to create.

     
Forgot Password
     
     
     

Featured Employers

Audobon

SunPower

Tesla Motors

The Body Shop

Sr. MS SQL Server DBA Job Details

Actions

  • Apply
  • Print
  • Email a friend
back to search results

Show me jobs like this one

Job Ref:  41296
Employer:  Nature Conservancy.
State/Province:  DC Metro Area
Type of Employment:  Full Time
Environmental Categories:  Other
Industries:  Computer/IT Services
Job Description: 
OFFICE LOCATION
Arlington, Virginia (VA)
ABOUT US
The Nature Conservancy is the leading conservation organization working to make a positive impact around the world in more than 30 countries, all 50 United States, and your backyard. Founded in 1951, the mission of The Nature Conservancy is to conserve the lands and waters on which all life depends. Visit www.nature.org/aboutus  to learn more.
TNC
ESSENTIAL FUNCTIONS
The Senior MS SQL Server DBA position will be acting as primary Database Administrator for the planning, installation, configuration, tuning, recoverability, and production rollout of TNC's BlackBaud CRM (BBCRM) system.  He or she will serve as one of TNC's primary technical resources for SQL Server database administration, architecture design and deployment practices, and must be capable of facilitating knowledge transfer throughout the department.  This individual must not only be able to collaborate effectively with both TNC's internal IT department and BlackBaud's external support staff, but they will also inherit joint-responsibility in meeting the implementation deadline.  This position reports directly to the Manager of Enterprise Database Operations and does not supervise any staff.  A summary of the individual's duties is listed below:

DUTIES

I.  DBA activities:
  • Work with the Enterprise Database Operations (EDO), Enterprise System Operations (ESO), and BlackBaud support teams to validate hardware architecture and perform SQL Server and BBCRM software configuration according to best practices and documented requirements. 
  • Devise, implement, and monitor backup/recovery procedures, ensure backup integrity, and verify recoverability of all databases and transaction logs.
  • Participate in the development of stored procedures, triggers, and other database objects necessary to support BBCRM in all development, test, staging, and production environments.
  • Validate and enhance database and application security.  Work closely with internal TIS Security staff and BlackBaud to define, modify, and implement MS SQL Server security procedures in accordance with the BBCRM application capabilities.
  • Provide recommendations on high-availability technologies such as database mirroring, clustering, and AlwaysOn.
  • Develop/monitor regularly scheduled maintenance jobs for all development, test, production, and supporting database environments. 
  • Monitor all Windows/SQL Server environments to ensure reliability and availability, including monitoring of storage and log space, scheduled maintenance jobs, connections, errors, etc. 
  • Report problems to Microsoft or BlackBaud support as appropriate, and be able to track and communicate the resolution status to impacted business users, developers, and testers.  Must be able to follow-up with vendors to ensure the successful and timely resolution of open tickets.

II.  Define & Develop DBA Processes & Operational Procedures
  • Define and develop written documentation for all database and application implementation and configuration activities.
  • Define and document the policies, standards, processes, and procedures necessary to support the production rollout.
  • Recommend or design/develop operations and/or database administration tools and scripts as required.

III.  Technical Advisory Role to TIS Staff and Internal Customers
  • Provide MS SQL Server technical expertise through all phases of the implementation life cycle, including analysis, planning, testing, implementation, and post-implementation efforts.
  • Work closely with the system administrators, application developers, and relevant BlackBaud personnel to identify operational and administration requirements, determine risks and issues, and define technical solutions as necessary during application deployment.
  • Work closely with performance test representatives to validate technical approaches, support resource reporting during performance tests, and make recommendations for system/database tuning and optimization of key application components.

BASIC QUALIFICATIONS
  • Bachelor's degree in Computer Science, MIS, Engineering, or in a non-technical discipline with work experience.
  • 6 years of technical experience with all aspects of MS SQL including SQL and PL/SQL development and Windows/SQL server architecture.
  • 3 years of experience administering large production applications, including capacity planning, performance monitoring, analysis, and tuning. 
  • Experience in medium-to-large off-the-shelf (OTS) package implementations
  • Experience using SQL Server Clustering/High-Availability (HA) technologies

PREFERRED QUALIFICATIONS

The individual must be able to oversee all SQL Server-related aspects of the BBCRM product installation in multiple database environments during the project deadline.  They should possess strong technical knowledge of all aspects of the MS SQL Server RDBMS, an understanding of the SQL Server database architecture and how it interacts with the host operating system, and the demonstrated ability to perform all types of administration activities including advanced troubleshooting.  Network configuration and connectivity between database environments, performance tuning activities, and the ability to administer and configure SQL Server backup and recovery operations is required.    Experience with data migration between SQL Server and other database architectures is highly desirable.  In addition, the following requirements will be necessary:
  • Experience with the BlackBaud CRM product and Blackbaud's Infinity Platform architecture is preferred.
  • Experience in client/server architectures and associated technical issues in a medium-to-large scale multiple database production environment.
  • The individual should have significant experience in administering MS SQL Server in various production and non-production environments, be adept at using the supporting utilities (SQL Server Management Studio (SMS), SQL Profiler, Tuning Advisor, Performance Monitor, etc.), as well as possess in-depth knowledge of at least one of the following components: SSRS, SSIS, SSAS, and/or SSCM. 
  • The individual should possess an understanding of MS Windows, NTFS, RAID and SAN storage, clustering and high-availability solutions, and the fundamentals of networking, memory utilization, and other technical concepts as they pertain to database server environments.
  • Proficiency in T-SQL and Windows PowerShell and/or other scripting languages required.

BENEFITS
The Nature Conservancy offers competitive compensation, 401k or savings-plan matching for eligible employees, excellent benefits, flexible work policies and a collaborative work environment. We also provide professional development opportunities and promote from within. As a result, you will find a culture that supports and inspires conservation achievement and personal development, both within the workplace and beyond.
TNC
TO APPLY
To apply to position number 41296, submit resume and cover letter as one document. All applications must be submitted in the system prior to 11:59 p.m. Eastern Time on August 9, 2013.

Failure to complete all of the required fields may result in your application being disqualified from consideration.

You must click "submit" to apply for the position. You may select "save for later" if you prefer to create a draft application for future submission. Once submitted, applications cannot be revised or edited.

If you are experiencing technical issues, please refer to our applicant  user guide or contact applyhelp@tnc.org .
EOE STATEMENT
 

The Nature Conservancy is an Equal Opportunity Employer.  Women, minorities, veterans and persons with disabilities are encouraged to apply.

The successful applicant must meet the requirements of The Nature Conservancy's background screening process
07/16/2013

Popular Locations: California | Los Angeles | Seattle | New York | San Francisco | Florida | Chicago | Boston | North Carolina | Virginia

Popular Job Titles: Analyst | Administrative Assistant | Program Manager | Billing Clerk | Business Development Manager | Data Entry Supervisor | Environmental Compliance Auditor


Home    About Us    Job Search    Employer Area    Contact Us    Terms of Use    Privacy Policy    Community Forum

Copyright © eco.ORG 2010 Job Board Software. Healthcare Jobs.