SQL Database Developer

Location
Washington D.C.
Posted
Oct 13, 2019
Closes
Nov 14, 2019
Function
IT
Hours
Full Time

SQL Database Developer

- ENSURE ALL SQL DATABASE SERVERS ARE BACKED UP ACCORDING TO THE PRE-DEFINED MAINTENANCE SCHEDULE

- BUILD, MAINTAIN, AND ENHANCE PACKAGES, PROCEDURES AND FUNCTIONS IN PL/SQL USING TOAD, SQL*PLUS, SQL DEVELOPER AND OTHER UTILITIES

- WRITE EFFICIENT SQL QUERIES; - DEVELOP OVERALL INTEGRATION TESTS TO ENSURE CODE DOES NOT ADVERSELY AFFECT EXISTING PROGRAMS

- TEST BACKUPS TO ENSURE WE CAN MEET BUSINESS' RECOVERY TIME OBJECTIVES (RTO)

- TROUBLESHOOT SQL SERVER SERVICE OUTAGES AS THEY OCCUR

- CONFIGURE SQL SERVER MONITORING UTILITIES

- CONFIGURE, TROUBLESHOOT AND MAINTAIN SQL SERVER ACCORDING TO CUSTOMER SPECIFICATIONS

- CONFIGURE, TROUBLESHOOT AND MAINTAIN SQL CLUSTERING

- DEPLOY DATABASE CHANGE SCRIPTS PROVIDED BY THIRD-PARTY VENDORS

- PERFORMANCE TROUBLESHOOTING, TUNING, INDEXING & QUERY CHANGES

- DOCUMENT THE COMPANY'S DATABASE ENVIRONMENT

- DEBUG PL/SQL PROGRAMS TO FIX AND MAINTAIN EXISTING CODE

- DEVELOP CODE USING BEST PRACTICES FOR MODULARITY, ERROR HANDLING, AUDITING, MULTI-USER AND PERFORMANCE

 - ATTEND PROJECT MEETINGS AND CONTRIBUTE TO VARIOUS DISCUSSIONS

 - DELIVER HIGH-QUALITY CODE WITHIN PUBLISHED DELIVERY DATES

 - DEVELOP UNIT TESTS TO ENSURE THE CODE WORKS AS DESIGNED

Requirements – Master’s Degree in Computer Science. KNOWLEDGE OR EXPERIENCE IN USE SQL SERVER TOOLS TO DIAGNOSE SERVER RELIABILITY AND PERFORMANCE ISSUES; KNOWLEDGE OR EXPERIENCE IN SCRIPTING TECHNOLOGIES; KNOWLEDGE OR EXPERIENCE IN ERWIN DATA MODELER, DYNAMIC SQL(T-SQL)AND WINDOWS OPERATING SYSTEMS.

Job location: Washington, DC Resumes to: ActioNet Inc., Attn: L. Jimenez, 2600 Park Tower Drive, Suite 1000, Vienna VA 22180

Similar jobs