This Position Is No Longer Available
  1. Overview
  2. Duties
  3. Qualifications & Evaluations
  4. Benefits & Other Info
  5. How to Apply

Job Title:Lead IT Specialist (DATAMGT)(Database Administrator)

Department:Department Of The Treasury

Agency:Treasury, Departmental Offices

Job Announcement Number:13-DO-444P

This position is closed and no longer accepting online applications through USAJOBS.

The contents of the announcement can still be viewed.

SALARY RANGE:

$100,499.00 to $141,482.00 / Per Year

OPEN PERIOD:

Wednesday, April 24, 2013 to Tuesday, May 07, 2013

SERIES & GRADE:

OR-2210-53

POSITION INFORMATION:

Position is at the full performance level. - This is a full-time permanent position.

PROMOTION POTENTIAL:

53

DUTY LOCATIONS:

1 vacancy in the following location:
Washington, DC, USView Map

WHO MAY APPLY:

U.S. citizens; no prior Federal experience is required.

Current permanent Federal employees in competitive positions, former Federal employees who have reinstatement eligibility, and individuals who are eligible to apply under special appointing authorities may wish to apply for this same vacancy under Merit Promotion Vacancy Announcement 13-DO-443. Please refer to that vacancy announcement for details on eligibility and how to apply.

JOB SUMMARY:

The Office of Financial Research (OFR or Office) is a new organization established by the Dodd-Frank Wall Street Reform and Consumer Protection Act in the Treasury Department to provide data and analysis to the Financial Stability Oversight Council (the Council) and its member agencies, improve the quality and transparency of financial information, conduct and sponsor research related to financial stability, and promote best practices in risk management.

Applications will be accepted from all individuals until the scheduled closing date or until 50 applications have been received, whichever comes first.  Any required documents should be submitted at the time that you apply as documents will not be accepted after the vacancy closes.

The U.S. Department of the Treasury has a distinguished history dating back to the founding of our nation. As the steward of U.S. economic and financial systems, Treasury is a major and influential leader in today's global economy. We have over 100,000 employees across the country and around the world. Come Join the Department of the Treasury and Invest in Tomorrow.

Treasury Headquarters, the Departmental Offices, has responsibility for formulating policy and the overall management of the Department of the Treasury. The Office of Financial Research is recruiting to fill a key Database Administrator position. This position is in a small office with top staff members who work on a wide array of interesting subjects. We offer both flexible work schedules and an opportunity for challenging and interesting work. We are located in the heart of Washington, DC with offices on 15th and Pennsylvania, next door to the White House, a few blocks from the McPherson Square and Metro Center metro stations, and close to shops, museums, and restaurants.

This is an excellent opportunity to advance your career and your salary!

Key Information: 

  • We offer opportunities for flexible work schedules.
  • Click "Print Preview to review the entire announcement before applying.
  • We may offer opportunities for telework.
  • You may be considered for incentives or programs as part of the initial offer of employment.
  • KEY REQUIREMENTS


      DUTIES:

      Back to top

      As a Database Administrator, you will:

      * Lead the team in identifying, distributing and balancing workload and tasks among employees in accordance with established work flow, skill level and/or occupational specialization; make adjustments to accomplish the workload in accordance with established priorities to ensure timely accomplishment of assigned team tasks; and ensure that each employee has an integral role in developing the final team product.

      * Employ, maintain and manage a database that includes planning, developing, designing, coding, testing and maintaining applications that interface with the data base.
      * Be responsible for all database/table design, performance tuning, SQL optimization, stored procedures programming and all tasks necessary for the creation, population and usage of OFR’s databases.
      * Develop, modify, and amend data in systems using SQL commands, hand-editing, and bulk import.

      * Oversee the scheduling of data base projects, database and transaction log backups, notification, and database replication between multiple SQL Servers and remote sites.


      QUALIFICATIONS REQUIRED:

      Back to top

      In order for your application to be considered, you must meet the following requirements by the closing date of this announcement:


      For this position individuals must have IT-related experience demonstrating each of the four competencies listed below.

      1. Attention to Detail - Is thorough when performing work and conscientious about attending to detail.
      2. Customer Service - Works with clients and customers (that is, any individuals who use or receive the services or products that your work unit produces, including the general public, individuals who work in the agency, other agencies, or organizations outside the Government) to assess their needs, provide information or assistance, resolve their problems, or satisfy their expectations; knows about available products and services; is committed to providing quality products and services.
      3. Oral Communication - Expresses information (for example, ideas or facts) to individuals or groups effectively, taking into account the audience and nature of the information (for example, technical, sensitive, controversial); makes clear and convincing oral presentations; listens to others, attends to nonverbal cues, and responds appropriately.
      4. Problem Solving - Identifies problems; determines accuracy and relevance of information; uses sound judgment to generate and evaluate alternatives, and to make recommendations. In addition to the above, you must have one year of specialized experience at a level of difficulty and responsibility equivalent to the next lower grade level in the Federal service.

      AND

      SPECIALIZED EXPERIENCE

      You must have one year of specialized experience at a level of difficulty and responsibility equivalent to the GS-12 grade level in the Federal service. Specialized experience for this position includes all of the following and must be reflected in your resume:

      * Hands-on experience with computer systems life cycle processes including ETL and database development, testing, deployment and operations for research and analytics purpose;
      * Hands-on experience as a database administrator or ETL developer with the installation, monitoring, development and administration of Microsoft SQL Server 2008 or beyond, Hadoop, or full featured ETL tool (i.e., SAS EDI, Informatica, etc);
      * Hands-on experience with the design, development, and administration of a Big Data (>10TB+) for research and analysis purposes;
      * Experience providing oral and written communication such as recommendations, analysis, justifications, instructions, etc., to superiors, co-workers, subordinates, etc.

      The experience may have been gained in either the public or private sector.

      One year of experience refers to full-time work; part-time work is considered on a prorated basis.

      HOW YOU WILL BE EVALUATED:

      Your application includes your:
      1. Resume,
      2. Responses to the online questions, and
      3. Required supporting documents.

      We use a multi-step process to evaluate and refer applicants:
      1. Minimum Requirements: Your application must show that you meet all requirements, including the education and/or experience required for this position. You may be found "not qualified" if you do not possess the minimum competencies required for the position. If your application is incomplete, we may rate you as ineligible.

      2. Rating: Your application will be evaluated in the following areas: Knowledge of data management, metadata, data architecture and modeling, Knowledge of information systems, security principles, concepts, methods, and practices, Interpersonal communication, and Ability to work with others in the workplace
      . We may lower your rating if your responses to the online questions are not supported by the education and/or experience described in your application. Category rating will be used to rank and select eligible candidates. If qualified, you will be assigned to one of three categories, A, B or C, depending on your experience and education related to this position. Veterans' preference is applied after applicants are assessed. Preference-eligibles will be listed at the top of their assigned category and considered before non-preference-eligibles in that category. Qualified preference-eligibles with a compensable service-connected disability of 10% or more will be listed at the top of the highest category.

      3. Referral: If you are among the top qualified candidates, your application may be referred to a selecting official for consideration and possible interview. If you are a displaced or surplus Federal employee (eligible for the Career Transition Assistance Plan (CTAP)/Interagency Career Transition Assistance Plan (ICTAP)), you must be assigned the middle category or better to be rated as well qualified to receive special selection priority.

      We recommend that you preview the online questions for this announcement before you start the application process.


      To preview questions please click here.


      BENEFITS:

      Back to top
      We offer a workplace that is respectful, fair, and values diversity. Our comprehensive benefits are very generous - helping you to reach your personal goals by supporting your professional growth, health, well-being, and your family needs. Our benefits package includes:
      • Challenging work, opportunities for advancement, competitive salaries, bonuses and incentive awards;
      • Ten paid holidays, 13 days of sick leave, and 13 to 26 days of vacation time each year;
      • Access to insurance programs that may be continued after you retire;
      • A wide choice of health insurance plans, coverage for pre-existing conditions, and no waiting periods. We pay a substantial amount (up to 75%) of the health insurance premiums.

      To learn more about Federal benefits programs, Click here.

      In addition to these standard Federal benefits, OFR employees will also be provided with access to:

      • Supplemental dental and vision coverage at no cost to the employee, Long term disability coverage, Domestic partner subsidies, where applicable, and 24-hour Business Travel accident insurance.
      • Additional benefits related to short term disability coverage and enhanced life insurance coverage are also available.
      • OFR employees will also be a part of a performance-based merit pay program designed to reward employees for excellent performance.


      OTHER INFORMATION:

      • We may select from this announcement or any other source to fill one or more vacancies.
      • We will not pay relocation expenses.
      • This is a non-bargaining-designated position.

      CONDITIONS OF EMPLOYMENT:  If selected for this position, you will be required to: 

      • Complete a one-year probationary period (unless already completed).
      • Complete a Declaration for Federal Employment to determine your suitability for Federal employment.
      • If you are a male applicant born after December 31, 1959, certify that you have registered with the Selective Service System or are exempt from having to do so.
      • Have your salary sent to a financial institution of your choice by Direct Deposit/Electronic Funds Transfer.
      • Go through a Personal Identity Verification (PIV) process that requires two forms of identification from the Form I-9 (http://www.uscis.gov/files/form/I-9_IFR_02-02-09.pdf). Federal law requires verification of the identity and employment eligibility of all new hires in the U.S.
      • Successfully complete a background investigation.
      • Obtain and maintain a security clearance at an appropriate level for this position.
      • File a Confidential Financial Disclosure Report within 30 days of appointment and annually thereafter, if applicable.
      • Undergo an income tax verification, if applicable.


      HOW TO APPLY:

      Back to top

      The following instructions outline our application process. You must complete this application process and submit any required documents by 11:59 p.m. Eastern Time (ET) on the closing date of this announcement. We are available to assist you during business hours (normally 8:00 a.m. - 5:00 p.m., Monday - Friday). If applying online poses a hardship, please contact us by noon ET on the announcement's closing date.

      If you are experiencing system issues with your application, please contact the CareerConnector Help Desk at careerconnectorhelp@treasury.gov and/or the USAJobs Help Desk.

       

      Treasury provides reasonable accommodation to applicants with disabilities on a case-by-case basis. Please contact us if you require this for any part of the application and hiring process.

      Step 1 - Create or Upload a resume with USAJOBS (www.usajobs.gov)
      -We suggest you go to the end of the Qualifications & Evaluation section of the job announcement to preview the online questions that you will answer in Step 3. You may need to customize your resume to ensure that it supports your responses to these questions. For more resume tips click here.
      - You may create a resume in USAJOBS or upload one of your own choosing. Although you must enter your Social Security Number (SSN) for USAJOBS, we will only see the last four digits for identification purposes.

      Step 2 - Apply Online
      Click the "Apply Online" link of this announcement and then select the resume you wish to submit with your application. You will be redirected to the Department of the Treasury's CareerConnector website to complete the application process.

      Step 3 - Answer the Online Questions and Submit Your Online Application
      If this is your first time on Treasury's CareerConnector website, you will be prompted to register by answering questions related to your eligibility for Federal employment. The system will save these responses and take you back to the main screen so that you can answer the job-specific questions. Select "Take me to the assessment" and click on the "Continue" button to answer the job-specific questions. You must answer all the questions and click the "Finished" button.

      Step 4 - Review and Confirm Your Submission
      You will now have the option to upload a document or print fax cover-sheets for your required documents (see step 5 for details). Once you click "Done," you will see a summary of your application for your review. You may also print a copy for your records. When you click "Finished" at the bottom of the page, you will then be directed back to USAJOBS where you can confirm that your application has been submitted and track your application status.

      Step 5 - Submit Required Documents
      You can submit any required documents (discussed below) by document upload or fax. Whichever method you choose, please include the job announcement number with your documents. To protect your privacy, we encourage you to remove your SSN from any documents that you submit.

      Document Upload:
      You may upload supporting documents in one of two ways:

      1. Once you finish answering the questions in the job announcement, you will be prompted to upload your document(s) to your application. You will be given the choice to either upload the document as part of the application process or you can select a document that you've already loaded on USAJOBS. or

      2. You can upload a document to an existing application by logging into your USAJOBS account profile. Click on "My Applications" and search for the vacancy. Once you've located the vacancy, click on the vacancy and select "Apply Online." Move through your existing application to the Documents page and select Upload in order to add a document to your application. Be certain to review your complete application for confirmation that the document uploaded.

      In the Application Review section, you may verify acceptance of your documents in CareerConnector if you see them listed on the "Vacancy Documents" screen. Then, click on "Finished" to be returned to USAJOBS.

      Fax: Create a fax cover-sheet in CareerConnector by following the "Faxing Supporting Documentation" instructions. The fax number will be on the cover-sheet.



      REQUIRED DOCUMENTS:

      Please note that if you do not provide all required information, as specified in this announcement, you may not be considered for this position (or may not receive the special consideration for which you may be eligible).

      VETERANS' PREFERENCE DOCUMENTATION
      If you are claiming veterans' preference, you must submit a copy of your Certificate of Release or Discharge From Active Duty, DD-214 (Member 4 copy), or other official documentation from a branch of the Armed Forces or the Department of Veterans Affairs showing dates of service and type of discharge.

      10 point preference eligibles must also submit an Application for 10-point Veteran Preference, SF-15, along with the required documentation listed on the back of the SF-15 form. An SF-15 may be found at: http://www.opm.gov/forms/pdf_fill/SF15.pdf. For more information on veterans' preference, click here.

      CTAP/ICTAP DOCUMENTATION
      If you are a displaced or surplus Federal employee eligible for consideration under the Career Transition Assistance Plan (CTAP) or Interagency Career Transition Assistance Plan (ICTAP), you must submit proof of eligibility. For a detailed list of documents, click here.

      AGENCY CONTACT INFO:

      Applicant Call Center
      Phone: 304-480-7300
      Fax: 000-000-0000
      TDD: 304-480-8725
      Email: doinquiries@bpd.treas.gov
      Agency Information:
      Departmental Offices (DO)
      Please see "How to Apply" section
      Parkersburg, WV
      00000
      US
      Fax: 000-000-0000

      WHAT TO EXPECT NEXT:

      You may check the status of your application for this position at any time by logging onto the USAJOBS "My Account" tab and clicking on "Application Status." We will also send you notification of your application status. Please notify us if your contact information changes after the closing date of the announcement. Also, note that if you provide an email address that is inaccurate, or if your mailbox is full or blocked (e.g., spam-blocker), you may not receive important communication that could affect your consideration for this position.

      Back to top
      Dock
      Print Preview

      Job Announcement Number:

      13-DO-444P

      Control Number:

      342400100