What are the responsibilities and job description for the Database Administrator V - Hybrid position at IBSS?
Job Title: Database Administrator V - Hybrid
Location: Silver Spring MD
Clearance Required: Public Trust
Description
The NWS provides weather, hydrologic, and climate forecasts and warnings for the United States, its territories, adjacent waters and ocean areas, for the protection of life and property and the enhancement of the national economy. NWS data and products form a national information database and infrastructure which can be used by other Governmental agencies, the private sector, the public, and the global community.
The NWS Office of Observations (OBS), Surface and Upper Air Division (SUAD) Logistics Management Branch provides overall management of the NWS logistics life cycle program. Additionally, NWS is the focal point for multi-agency logistics management and serves as a designated Primary Inventory Control Activity (PICA) for the Department of Defense (DOD) and the Federal Aviation Administration (FAA) for observations systems such as the Next Generation Radar (NEXRAD), the Automated Surface Observation System (ASOS) and the Advanced Weather Interactive Processing System (AWIPS).
This position provides Database Management expertise within the NWS OBS logistics process.
Key Responsibilities:
Since 1992, IBSS, a woman-owned small business, has provided transformational consulting services to the Federal defense, civilian, and commercial sectors. Our services include cybersecurity and enterprise information technology, environmental science and engineering (including oceans, coasts, climate, and weather), and professional management services.
Our approach is to serve our employees by investing in their growth and development. As a result, our employees bring greater capabilities and provide exceptional service to our clients. In addition to creating career development opportunities for our employees, IBSS is passionate about giving back to the community and serving the environment. We strive to leave something better behind for the next generation.
We measure our success by the positive impact we have on our employees, clients, partners, and the communities we serve. Our tagline, Powered by Excellence, is a recognition of the employees that make up IBSS and ensures we deliver results with quality, applying industry best practices and certifications.
IBSS offers a competitive benefits package that includes medical, dental, vision, and prescription drug coverage with a company-paid deductible, paid time off, federal holidays, a matching 401K plan, tuition/professional development reimbursement, and Flex-Spending (FSA)/Dependent Care Account (DCA) options.
IBSS is an affirmative action and equal opportunity employer. All qualified applicants will be considered for employment without regard to race, color, religion, sex, disability, age, sexual orientation, gender identity, national origin, veteran status, or genetic information. Click https://www.eeoc.gov/poster to see that the EEO is the law. Please direct any inquiries to the HR Department email at HR@ibsscorp.com.
If you require reasonable accommodation in completing this application, interviewing, completing any pre-employment testing, or otherwise participating in the employee selection process, please direct your inquiries to the Talent Acquisition department at Recruiting@ibsscorp.com
Location: Silver Spring MD
Clearance Required: Public Trust
Description
The NWS provides weather, hydrologic, and climate forecasts and warnings for the United States, its territories, adjacent waters and ocean areas, for the protection of life and property and the enhancement of the national economy. NWS data and products form a national information database and infrastructure which can be used by other Governmental agencies, the private sector, the public, and the global community.
The NWS Office of Observations (OBS), Surface and Upper Air Division (SUAD) Logistics Management Branch provides overall management of the NWS logistics life cycle program. Additionally, NWS is the focal point for multi-agency logistics management and serves as a designated Primary Inventory Control Activity (PICA) for the Department of Defense (DOD) and the Federal Aviation Administration (FAA) for observations systems such as the Next Generation Radar (NEXRAD), the Automated Surface Observation System (ASOS) and the Advanced Weather Interactive Processing System (AWIPS).
This position provides Database Management expertise within the NWS OBS logistics process.
Key Responsibilities:
- Automates existing manual processes such as routine reports and queries in the division.
- Coordinates with budget, finance, and NWS Regional offices to provide consolidated spreadsheets.
- Provides support on the Inspection Report Database for surface and upper air programs, through custom queries of this database including station-specific data such as equipment information, weather elements observations details, observer details, master data information, inspection information, and reporting system.
- Develops and integrates observing system data sets including sensor configuration data, implementation schedule data, and database report development.
- Maintains ORACLE system and database for optimum performance and reliability of hardware and software development tasks. This includes providing ORACLE database administrative support for the following Logistics database applications systems: UIS, WUS and the Provisioning and Cataloging (PROCAT) System.
- Ensures the reliability of interfaces with the Consolidated Logistics System (CLS); the Military Standard Requisitioning and Issuing Procedures (MILSTRIP); Military Standard Billing System (MILSBILS); the General Services Administration (GSA) Inter fund billing system and also ensures that existing financial routines interface with the Commerce Administrative Management System (CAMS).
- Provides support on program data sets through custom queries of the assigned database, including station and logistics specific data such as equipment information, weather elements observations details, observer details, master data information, inspection information, and other queries.
- Daily work consists of maintaining the LMB Oracle system and database for the optimum Performance and reliability of hardware and software development. This includes: providing Oracle database administrative support for the Weather Logistics Information System (WLIS) database application components: Provisioning and Cataloging (PROCAT) and Military Standard Requisitioning and Issuing Procedures (MILSTRIP)
- Provide regular patching of the WLIS servers Ensure the reliability of interfaces and connections between WLIS and the NLSC.
- Consolidated Logistics System (CLS) and DLA related to the Military Standard Requisitioning and Issuing Procedures (MILSTRIP) requisitions and messages Work with NLSC and NRC so that WLIS database is up and running Get familiar with the Interfund and IPAC Billing process at NWS and carry out the Interfund and IPAC Billing on a monthly basis. Get familiar with the NLSC Inventory reporting and carry out NLSC Inventory reporting on a quarterly basis
- Run various standard LMB logistics reports, run ad hoc logistics reports and provide various logistics analysis, continue to automate the existing manual processes such as routine reports and queries in the division, Submit NSI, SIC and DEL requests to DLA and maintain various DLA accounts (WebVLIPS., MILSINQ, EDAASINQ, E-Cat, etc.), Do mass uploads of NSI records to WLIS, Provide customer support to the WLIS use.
- Education: BS/BA degree and/or certification in IT, Engineering, or related field
- Functional: Demonstrated experience in administration of large data bases and their interfaces. Experience with Oracle and MS database protocols.
- Experience: 5 years of related experience
- A Database Administrator (DBA) is responsible for the management, maintenance, and security of an organization's databases. Below are the key desired skills for a Database Administrator:
- Technical Expertise
- Proficiency in relational databases like: Oracle, Microsoft SQL Server, MySQL and PostgreSQL. Familiarity with NoSQL databases like MongoDB, Cassandra, or DynamoDB.
- Database Design and Architecture:
- Designing efficient and scalable database schemas. Knowledge of data normalization and denormalization.
- Performance Optimization:
- Experience with database tuning, indexing, and query optimization. Monitoring and resolving performance bottlenecks.
- Backup and Recovery:
- Implementing reliable backup strategies and disaster recovery plans. Expertise in recovery tools and techniques.
- Scripting and Automation:
- Proficiency in SQL, PL/SQL, or T-SQL. Knowledge of scripting languages like Python, PowerShell, or Bash for automation tasks.
- 2. Data Security and Compliance
- Implementing database security measures, including: User authentication and role-based access controls. Encryption of data at rest and in transit. Ensuring compliance with regulations (e.g., GDPR, HIPAA, PCI-DSS). Experience with audit logging and monitoring tools.
- 3. Operational and Maintenance Skills
- Capacity Planning: Estimating storage and resource needs based on current and future requirements.
- Monitoring Tools: Using tools like Nagios, Zabbix, or SolarWinds for monitoring database health.
- Upgrades and Patches: Keeping DBMS updated with the latest patches and updates.
- 4. Problem-Solving and Troubleshooting
- Strong analytical skills to diagnose and resolve database issues. Familiarity with debugging tools and logs for root cause analysis.
- 5. Collaboration and Communication
- Working closely with developers to: Optimize database interactions in applications and implement database migrations. Clear documentation of database structures, processes, and changes. Communicating technical concepts to non-technical stakeholders.
- 6. Emerging Technologies
- Familiarity with cloud databases (e.g., AWS RDS, Azure SQL Database, Google Cloud Spanner). Understanding of big data technologies like Hadoop, Spark, or Apache Hive.
- Knowledge of containerization and orchestration (e.g., Docker, Kubernetes) as applied to databases.
- 7. Project and Time Management
- Managing multiple database environments (development, testing, production). Balancing short-term operational tasks with long-term database improvement projects.
Since 1992, IBSS, a woman-owned small business, has provided transformational consulting services to the Federal defense, civilian, and commercial sectors. Our services include cybersecurity and enterprise information technology, environmental science and engineering (including oceans, coasts, climate, and weather), and professional management services.
Our approach is to serve our employees by investing in their growth and development. As a result, our employees bring greater capabilities and provide exceptional service to our clients. In addition to creating career development opportunities for our employees, IBSS is passionate about giving back to the community and serving the environment. We strive to leave something better behind for the next generation.
We measure our success by the positive impact we have on our employees, clients, partners, and the communities we serve. Our tagline, Powered by Excellence, is a recognition of the employees that make up IBSS and ensures we deliver results with quality, applying industry best practices and certifications.
IBSS offers a competitive benefits package that includes medical, dental, vision, and prescription drug coverage with a company-paid deductible, paid time off, federal holidays, a matching 401K plan, tuition/professional development reimbursement, and Flex-Spending (FSA)/Dependent Care Account (DCA) options.
IBSS is an affirmative action and equal opportunity employer. All qualified applicants will be considered for employment without regard to race, color, religion, sex, disability, age, sexual orientation, gender identity, national origin, veteran status, or genetic information. Click https://www.eeoc.gov/poster to see that the EEO is the law. Please direct any inquiries to the HR Department email at HR@ibsscorp.com.
If you require reasonable accommodation in completing this application, interviewing, completing any pre-employment testing, or otherwise participating in the employee selection process, please direct your inquiries to the Talent Acquisition department at Recruiting@ibsscorp.com
