1 G/ C7 c) e" I+ a9 |& i# K BWe are looking for a new member for our development team that supports the Energy Compensation System (ECS) for the Division of Energy Employees Occupational Illness Compensation (DEEOIC) at the US Department of Labor (DOL). The position is on site at the DOL facility at 3rd and Constitution in Washington DC and is conveniently located near the Judiciary Square Metro station. This is a full time Application SQL Server DBA position.6 e* E+ `/ m4 g0 J' q: \
The selected candidate will perform the following: V0 n* S0 F6 X. z! F) q( `
$ c6 J, O2 H5 e* E+ G
Provide guidance to database and systems management personnel on use and administration of SQL Server DBMS software,% m7 s9 |# j3 F! A
Evaluate and recommend SQL Server DBMS products and tools;" ?. q4 i9 k0 q6 w! F8 p! z
Implement and maintain SQL Server database structures, monitor and recommend tuning strategies for the SQL Server database environments for improved system performance; w$ H1 @1 p6 J
Provide guidance and recommendations for efficient use of database resources.
5 D0 b4 g/ ^. M* U7 B( z6 i Support databases in both development and production environments.
5 r7 s( V% [" M) P& M5 w Provide guidance and assistance in the development, maintenance, administration and enforcement of SQL Server database management standards and guidelines.8 j, E4 q9 y+ h. b. P2 L8 m+ f" ~
Participate in walkthrough with development staff and conduct DBA training and presentations./ n& o" I: R- v
Analyze database requirements. V) V9 G4 l6 T
Review physical data models for design integrity and adherence to standards
. ~; o! k5 \7 v: m Make recommendations for, and implement underlining storage and security structures9 O; U# W/ r; q: J* H; F- R
Review and approve application based scripts, utilities, stored procedures, functions and triggers.7 R1 C1 q) a4 I* X6 Q
Develop and execute appropriate Data Definition Language (DDL) to support the project8 ]) r6 W9 s5 D3 z8 i
Provide query performance monitoring and tuning recommendations.! j7 v* j' {0 \7 n5 _0 K4 v. E
Provide input on database and environment parameter settings and tuning.
! Y$ n; f. C/ V Provide general database expertise to application developers.
' h0 T* c: z* W1 B+ k Responsible for database capacity planning for adequate database storage.( Q0 O9 A4 P8 E! G# V9 G# v2 N
Insure change management and documentation for database changes
' o0 v; k- R( n! ?4 t! U$ m" w Will serve as the lead for the Data Engineering team and be responsible for the team’s performance and reporting weekly status.
! T/ v1 [, @* v8 q& [ L8 S In addition to the aforementioned responsibilities, the Data Engineering team is also responsible for the analysis of all data-related issues, determining solutions to address those issues, and application of any scripts or programs to fix those issues.4 B5 T$ F) N, ^( A5 n* g
/ }5 U- D5 X- @3 c, E+ g
- F* ~2 M% U' v7 r s% D
Qualifications: z! t: T( b5 n+ t; L
Must have expert technical knowledge and 7 to 10 years demonstrated experience as an Application DBA with specific experience using IBM DB2 and SQL Server 2008 or higher.3 g2 u) Z, r# ]3 |$ s0 s
$ s5 Z# R4 ?2 n7 E! i
Expertise with Physical database design issues. `6 V$ B" w \7 M& k7 y
Must be able to operate in an Agile-based development and maintenance environment.
/ T/ y5 i. g5 `; i+ B Expertise with SQL tuning and SQL development including development of stored procedures.# Y: K7 _6 G/ P& ~5 p0 {
Candidates must be detail oriented and have the ability to perform in high pressure situations: h# p# k7 o; b7 k w2 |! }6 x
Knowledge of Case Management and Financial systems preferable& c6 [1 q9 ~1 w
Must be a Team Player and have experience working closely with developers.$ W- }! V4 H- @% P. c/ A6 S
Must possess a well developed ability to communicate verbally and in written form with both technical and non technical audiences7 B6 O0 A+ f0 H1 l3 d% z
U.S. Citizen or U.S. Permanent Resident
$ ~" S8 A! L4 x Candidate is required to possess or successfully complete a National Agency Check with Inquiries (NACI) and FBI Criminal History Check1 \' n9 D Q8 Y2 S& \
Bachelor’s Degree in Computer Science or Information Technology* d" ~& d8 X8 j
+ i9 ^) s$ A# r
2 A# |: O6 d$ v& _3 e3 @) Z5 D4 J& U) y1 O, c
If you are interested in the DBA position, please send your resume to my email newlifeindc@hotmail.com. |