ActioNet logo
.
[logo] ActioNet. Click here to return to ActioNet home.
 
Current Opening

Click on 'Apply Now' to submit your application for this position.

Sr. SQL Server DBA / Developer
EducationBachelor's Degree
Experience08 - 10 years
Citizenship RequirementSole US Citizenship
Clearance RequiredDOE Badge Access Only
LocationDC - Washington
  
Job Responsibilities
Senior SQL Server DBA / Developer 

ActioNet is seeking a senior SQL DBA to support a Cognos data warehouse environment. The candidate will also be responsible for developing ETL packages and providing data modeling support.

 

Responsibilities

  • Design, implement and maintain SQL databases with respect to access methods, access time, device allocation, validation checks, organization, security, documentation and statistical methods
  • Support software development and systems integration teams for Cognos data warehouse environment
  • Support the daily operations of the data warehouse, including maintaining and administering database systems and related environments (hardware, system and application software, and all configurations).
  • Develop standards for use of software and to protect information as it pertains to maintaining, upgrading, installing, configuring, testing, and deploying, and performing other database/application systems tasks.
  • Design, develop and test ETL (extract/transform/load) processes using SQL Server Integration Services (SSIS).
  • Monitor the performance of databases/applications, and coordinate access and use.
  • Perform data modeling, database optimization, and interpret/write complex SQL queries.

     

     

Skills Required

  • Bachelor’s degree in computer science or related field
  • 8+ years’ experience working as a DBA
  • 5+ years’ experience working with SQL Server 2012/2014,  and SSIS in Windows 2008 R2 and 2012 R2
  • Expertise in designing, building, administering, and maintaining SQL Server databases for complex systems
  • Experience with:
    • Building/configuring new SQL servers
    • Patching and upgrading SQL servers from older versions
    • SQL backup, data recovery, and disaster recovery
    • Tuning databases to improve query performance
    • Setting up security, auditing, monitoring performance and capacity constraints
    • Automating daily DBA manual tasks using jobs or scripts
    • Writing T-SQL or PL-SQL including stored procedures, functions and triggers
  • Proficiency with developing/troubleshooting ETL packages
  • Familiarity with IDERA SQL Diagnostic Manager or similar tools
  • Working knowledge of Windows Server administration, IIS and virtual server technology
  • Experience in creating technical and architectural documentation
  • Skilled at reviewing query performance and optimizing table indexes and structure to improve database performance.
  • Experience with data modeling to visualize database structure, and designing and coding tables to store the application’s data. 
Skills Preferred
  
    
Photo of a woman
Did You Know? ActioNet has a mentor program designed to get you up to speed in your new job quickly...helping you succeed and grow with the company.

 

ActioNet Inc. is an Equal Opportunity/Affirmative Action Employer.