Social Security Administration IT Specialist (APPSW/DATAMGMT) in Woodlawn, Maryland
About the Agency
Do you have a desire to:
- help SSA manage its Social Security programs?
- analyze and solve problems?
- help and advise millions of retired and disabled individuals?
- work on a team to make a difference in people's lives and your own? Join SSA, one of the top 10 Best Places to Work in the Federal Government!
As an Information Technology (IT) Specialist, you are a valued member of a dynamic team. IT Specialists contribute to the agency's mission by producing logical, concise and efficient systems and providing software that is cost beneficial and responsive to the needs of the agency. IT Specialists are an important aspect of the Federal Government. They help with exciting initiatives and facilitate the successful implementation of cutting edge technology solutions.
This position is located in SSA's Deputy Commissioner for Systems/Office of Software Engineering/Office of Systems Architecture. The employee serves as a recognized technical authority and expert in a major agency-wide area of specialized data base management related support software. The incumbent is responsible for the design, development or procurement, analysis, implementation, and maintenance of SSA's database software covering major programmatic master files and data base design and technical support for auxiliary programmatic applications files and data bases.
This position is located at SSA Headquarters in Woodlawn, Maryland.
This position is telework eligible.
NOTE: Your resume must specifically address the evaluation criteria for the position. This information is instrumental in determining the highest quality candidates to be referred to the Selecting Official. If your application materials do not demonstrate the competencies and experience needed for this position, your application will be ineligible for consideration.
- Initiates, develops, coordinates, tests, validates and implements data base management projects including file consolidation, storage media selection and related data migration, conversion from batch sequential processing to interactive random processing and other projects required to implement modern data base management practice at SSA. Develops proposals, prepares written impact papers, work plans, studies and reports associated with data base integration projects in order to achieve improvements in efficiency, cost and levels of service.
- As a technical authority in support systems software, attends meetings with applications personnel to provide advice on systems software capabilities and limitations. Presents project status briefings and major recommendations concerning long range data base management systems plans to top levels of ADP management in SSA. Assists in developing overall systems software design and programming techniques for use by systems and application programmers in SSA; and has responsibility for developing and maintaining guidance for use of the data repository system.
- Plans, designs, develops, implements and maintains the Agency's data repository system. This system provides automated support for data related activities, which are an integral part of the software design, development and maintenance process. These functions include the standardization of data names, definitions, usage and structures, the definition of data base access controls, the management of metadata, data element synonyms and configuration management. Develops user training and automates interface capabilities between this system and other management systems to support the administration of the Agency's programmatic data.
- Performs studies or analysis on factors such as amount of storage space consumed and needed, access time statistics, frequencies of reads and writes, and unusual problems encountered by applications programmers using support systems software. Designs and analyzes databases which include the physical design of the database, schema and subschema, definitions and space allocations. Develops and uses specialized evaluation techniques to monitor data base performance and defines modifications necessary to improve the performance of the database.
- Not Required
- U.S. Citizenship Required
- Selective Service Registration, if applicable (www.sss.gov)
- Background and/or Security Investigation Required
- Selectees are required to serve a 1 year probationary period
- Relocation expenses will not be paid
- Job offers are contingent on background / security investigation results
Applicants must qualify for the series, grade, and selective placement factor of the posted position.Experience must be IT related; the experience may be demonstrated by paid or unpaid experience and/or completion of specific, intensive training (for example, IT certification), as appropriate. Your resume must provide sufficient experience and/or education, knowledge, skills, abilities, and proficiency of any required competencies to perform the specific position for which you are applying. Your resume is the key means we have for evaluating your experience, education, knowledge, skills, abilities and competencies as they relate to this position. Please submit a thorough resume that directly relates to this position.
To qualify for the 2210 IT Specialist series, applicants must demonstrate the following competencies:
Attention to Detail- Is thorough when performing work and conscientious about attending to detail. 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. 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. Problem Solving - Identifies problems; determines accuracy and relevance of information; uses sound judgment to generate and evaluate alternatives, and to make recommendations.
To qualify for the GS-13, applicants must have 52 weeks of experience at the GS-12 level, or equivalent, which is in or related to the work of the position to be filled which has equipped applicant with the particular knowledge, skills, and abilities to successfully perform the duties of the position. Such experience involves the design, documentation, development, modification, testing, installation, implementation, and support of new or existing applications software as well as the planning, development, implementation, and administration of systems for the acquisition, storage, and retrieval of data.
To qualify for the position, the applicant must demonstrate both Selective Placement Factorsbelow:
1) Skill in PostgreSQL or Oracle database administration. To meet this requirement, the applicant must demonstrate seven (7) out of the following nine (9) experiences:
- Experience performing PostgreSQL or Oracle database backup and recovery.
- Experience installing and administering PostgreSQL or Oracle user authentication and access control.
- Experience analyzing and resolving PostgreSQL or Oracle database availability issues.
- Experience creating and administering PostgreSQL or Oracle databases in a cloud environment.
- Experience defining and administering PostgreSQL or Oracle database storage objects.
- Experience installing and administering PostgreSQL or Oracle database clusters.
- Experience creating and administering PostgreSQL or Oracle multi-tenant database configurations.
- Experience defining and executing DDL to implement PostgreSQL or Oracle databases.
Experience using database utilities to maintain PostgreSQL or Oracle databases. 2) Skill in PostgreSQL or Oracle performance tuning. To meet this requirement, the applicant must demonstrate four (4) out of the following five (5) experiences:
Experience using database management tools to monitor PostgreSQL or Oracle database activity and performance.
- Experience analyzing and tuning complex PostgreSQL or Oracle SQL statements.
- Experience analyzing and resolving PostgreSQL or Oracle database lock contention.
- Experience tuning PostgreSQL or Oracle databases to improve performance (e.g. partitioning data and clustering, and allocating storage pools; defining database startup parameters that influence memory structures, such as data buffers, SQL cache, etc.).
- Experience working with PostgreSQL or Oracle database object statistics. NOTE: Your resume must specifically address the experiences needed for each selective placement factor. This information is instrumental in determining the highest quality candidates to be referred to the Selecting Official.
For information on qualifications, visit http://www.opm.gov/policy-data-oversight/classification-qualifications/general-schedule-qualification-standards/2200/information-technology-it-management-series-2210-alternative-a/.
All qualification requirements must be met by the closing date of the announcement.
Public Trust - Background Investigation
What To Expect Next
**Once you have successfully submitted your application materials, you can expect to receive at least two or more of the following email notifications concerning your application status: (1) Receipt of application; (2) Qualifications status and whether your application has been Referred/Not Referred to the selecting official; and (3) Selection status for the position.
Selection interviews may be conducted with one or more of the referred candidates, but there is no requirement that interviews be conducted. The hiring office will contact candidates directly for interviews; the announcement contact person is not involved in the interview process at all and will have no information to provide about interviews.**
Review our benefits
Selective Service: If you are a male applicant born after December 31, 1959, you must certify that you have registered with the Selective Service System, or are exempt from having to do so under the Selective Service Law. See www.sss.gov.
Additional selections may be made for this vacancy six months from the closing date of this announcement.
This job originated on www.usajobs.gov. For the full announcement and to apply, visit www.usajobs.gov/GetJob/ViewDetails/472408300. Only resumes submitted according to the instructions on the job announcement listed at www.usajobs.gov will be considered.
Salary Range: $94,796.00 to $123,234.00 / Per Year
Series & Grade: GS-2210-13/13
Supervisory Status: No
Who May Apply: U.S. Citizens
Control Number: 472408300
Job Announcement Number: SH10018015