The Bureau of Economic Analysis (BEA) is one of the world's leading statistical agencies, recognized throughout the United States and around the world as a key source for the best and most comprehensive economic statistics available. The data produced by BEA are among the most important tools used in decision-making by policy-makers in the Congress and the executive agencies, including the Council of Economic Advisers, the Federal Reserve, the Office of Management and Budget and the Treasury. BEA's data are also used extensively by private businesses and a wide range of regional organizations, state and local governments, businesses and educational institutions.
Applications under this vacancy announcement will be considered under external competitive procedures only. This vacancy is also being advertised under merit promotion procedures as (BEA-OAD-2013-0001). Each announcement requires a separate application using the Census Bureau's on-line application system by logging into http://www.usajobs.opm.gov/ and clicking on "Search Jobs." Merit promotion procedures apply to current or previous Federal employees in the competitive service who are eligible for transfer, promotion, reassignment, or reinstatement. Merit promotion procedures MAY also apply to applicants seeking consideration through a special appointing authority such as Veterans Recruitment Act (VRA), Veterans Employment Opportunities Act (VEOA), Schedule A, etc. Please read the vacancy announcement to determine who may apply. This vacancy is for an IT Specialist (Data Management) position in the Office of the Chief Information Officer, Office of Application Development, located at the U.S. Department of Commerce, Bureau of Economic Analysis in Washington, DC.
BEA is currently seeking a highly experienced and certified Microsoft SQL Server System Administrator(SA)/Database Administrator(DBA) to serve in BEA’s Office of the Chief Information Officer. As a senior SA/DBA, the incumbent will provide day-to-day database administration of the Bureau’s Microsoft SQL Server v2008+ servers, including development, test, and production environments.
Candidate must be certified in Microsoft SQL Server system/database administration, i.e., Microsoft Certified Solutions Associate (MCSA), Microsoft Certified Solutions Expert (MCSE), or Microsoft Certified Solutions Master (MCSM).
BEA has been ranked by its employees as one of the top federal agencies for which to work. It has a dynamic and motivated staff, and encourages professional growth. BEA has an unparalleled location in the heart of downtown D.C., only blocks from the White House and within walking distance to three Metro lines. The Penn Quarter, Logan and Dupont Circles, and the Kennedy and Verizon Centers are all within walking distance. This location provides for a unique balance of intellectual pursuit during the day and wealth of cultural and social activities after work.
This position is in the competitive service.
One year probationary/trial period may be required.
Relocation expenses WILL NOT be paid.
This is a non-bargaining unit position.
The Full Promotion Potential of this position is: ZP-05.
If this position is filled at a level below the full performance level, the selectee may be promoted without further competition. This implies no promise or guarantee of a promotion.
This position may be filled through means other than the competitive promotion process.
As a senior SA/DBA, the incumbent will provide day-to-day database administration of the Bureau’s Microsoft SQL Server v2008+ servers, including development, test, and production environments. Administration refers to all aspects of managing the SQL Server database management systems including but not limited to:
*Major Duty 1: Ensuring SQL database systems availability, functionality, integrity, and efficiency by analyzing and resolving database server issues, application performance and connectivity issues, and other infrastructure problems, and monitoring and managing of SQL database systems resources, including performance tuning, capacity, availability, serviceability, and backup and recoverability;
*Major Duty 2: Installing, configuring, and maintaining SQL database systems software, including evaluating , recommending, planning and scheduling the upgrade/installation of new database technologies and architectures, as well as analyzing and planning for anticipated changes in data capacity requirements;
*Major Duty 3: Supporting application development teams and other database users, including user account maintenance, database object permissioning, code analysis and reviews, query tuning, database design, resolving connectivity issues, and answering questions/requests for information;
*Major Duty 4: Developing and documenting SQL systems administration procedures, data standards, and policies; and
*Major Duty 5: Implementing SQL database system security procedures and tools, and ensuring the rigorous application of information security/information assurance policies, principles, and best practices.