Empowering federal agencies with innovative IT solutions to drive transformation, efficiency, and secure modernization.
Database Administrator
Location
District Of Columbia + 1 moreAll locations: District Of Columbia | Virginia
Posted
1 day ago
Salary
$125K - $145K / year
Seniority
Senior
Job Description
Database Administrator
Basecamp Consulting and Solutions LLC
• Provide support of mission-critical Oracle databases and the DLA Financial Website by developing code and performing Oracle database analysis in RHEL and Windows development and production environments; continually perform database object creation and performance tuning • Develop, test, and implement the organization's physical databases across multiple platforms, technologies, and computing environments • Develop PL/SQL, stored procedures, and triggers, and manage SQL Loader / ETL processes for loading data into Oracle on RHEL and Windows • Design and document logical and physical data models for all Oracle instances using Erwin; build data marts and dimensional models, including aggregation, partitioning, and indexing strategies • Perform database backup and recovery (hot and cold), apply Oracle Critical Patch Updates, and execute major-release Oracle upgrades • Implement Oracle security management and data-integrity controls • Provide application database analysis support throughout the project life cycle, including code and data-related object promotions and database change management • Act as backup to the Senior DBA, and as backup to monitor and service the components of Oracle WebLogic, as needed • Manage application log communication with ArcSight and Splunk • Build and maintain reports using data visualization and business intelligence tools to meet DLA customer needs; assist team members with data imports and other areas as needed • Participate in migration of Oracle database application servers to Military and Government Azure environments • Produce required deliverables — scripts and source code supporting the database and financial application, and performance/tuning evaluation reports • Attend and participate in DLA Information Operations status meetings and meetings with DLA Financial Management Office personnel • Maintain currency with new Oracle technology releases annually and provide the COR verification of related annual training
Job Requirements
- Active Secret Clearance
- Oracle Certified Professional (OCP) certification
- Minimum five (5) years relevant experience
- At least three (3) years Financial Website experience within the Federal Government
- At least three (3) years Federal Government Audit Readiness & Reconciliation experience
- Relevant certification from a nationally recognized technical authority
- DoD 8570.01-M / 8140 IAT Level I baseline certification (e.g., CompTIA A+ CE, Network+ CE, SSCP, or another DoD-approved IAT Level I baseline)
- Appropriate Computing Environment (CE) certification as outlined by the Cybersecurity Computing Environment Certification Working Group, applicable to the platform administered (Oracle database)
- Proficiency in Java, Python, WebLogic scripting, Linux shell scripting, C#, and HTML/JavaScript
- Strong Oracle RDBMS experience — SQL and PL/SQL, stored procedures, triggers, and data-access optimization; SQL Loader and ETL into Oracle on RHEL and Windows
- Data modeling with Erwin (logical and physical) and analytical, large-scale data model experience; data-mart population and dimensional modeling (aggregation, partitioning, indexing)
- Database performance and tuning; backup and recovery (hot and cold); Oracle Critical Patch Update maintenance; major-release upgrades; physical database design; and data warehousing features
- Oracle security management and data-integrity implementation
- Oracle Enterprise Manager experience
- Red Hat Enterprise Linux (RHEL) experience, including shell scripting (Bourne, Korn)
- Experience with ArcSight and Splunk
- Full project life-cycle experience in code migration, database change management, and data management; ability to manage multiple projects
- Demonstrated experience migrating Oracle database application servers to Military and Government Azure environments
- Additional stack familiarity: Visual Basic, Java, Java scripting, current Oracle version, and RHEL
- Strong problem-solving, documentation, and customer-communication skills
Benefits
- 401(k) matching
- Bonus based on performance
- Competitive salary
- Dental insurance
- Health insurance
- Paid time off
- Parental leave
- Training & development
- Vision insurance
Related Guides
Related Categories
Related Job Pages
More Database Administrator Jobs
Database Administrator, Oracle
Highmark HealthCreating remarkable health experiences, freeing people to be their best.
• Create, develop, and review the physical model created from the logical model, ensuring that the detailed physical design of data structures and databases complies with standards, guidelines and procedures recommended for all aspects of data modeling, database design, and maintenance. • Provide support for application staff and business areas regarding database implementations, which could include a customized in-house database and/or a third party application package. • Establish automated monitor mechanism for space and database availability conditions. • Establish best practices for database and application high availability through the use of third party technologies and through the exploitation of various database features. • Provide applications support for staff, as well as, outside division to answer questions and resolve problems related to the DBMS technology and computing platform such as Z/OS, UNIX, Linux, and Windows. • Conduct root cause analysis to identify and resolve problems impacting application and/or database availability and service levels. • Contact vendor support when necessary to facilitate application development and client problem resolution with optimum speed and efficiency. • Provide after hours and weekend support as required for on call responsibilities, database refreshes, testing, technology upgrades, and other off hour assignments. • Participate in establishing and maintaining technical standards, departmental procedures, and other technical documentation as required. • Assure compliance to required Corporate standards, procedures, guidelines and processes, including audits. • Assist in identifying, developing, and providing technology training to the application developers of the organization (formal and informal). • Participate in staff training opportunities (formal and informal) relative to rules, procedures, and standards for the access and maintenance of shared data resources. • Participate as assigned to intra and inter-departmental project initiatives. • Participate as assigned in the testing and recommendation of tools and utilities to improve the effectiveness of managing and supporting the database environments. • Maintain contacts with other DBA professionals externally in other Health Insurance/Health Care industries and/or other industries to maintain a perspective of current trends and best practices. • Other duties as assigned or requested.
Role Description We are looking for experienced DBA support following the departure of their internal DBA. The role provides hands-on administration for a mixed estate of legacy and modern databases spanning Oracle and SQL Server, running across a hybrid environment - cloud (primarily Azure) and on-premise. The estate grew through acquisitions, so it is fragmented, has little existing documentation, and currently lacks modern tooling and monitoring. The right person can investigate an unfamiliar environment and get to grips with it quickly. This is a flexible, remote service engagement rather than a full-time permanent seat. Qualifications - Oracle database administration (essential) - SQL Server database administration (essential) - Azure cloud database experience, alongside on-premise - comfortable working across both - Performance tuning & troubleshooting - diagnosing slow queries and debugging issues across multiple platforms - Monitoring & health checks - able to establish good practice where modern tooling is currently absent - Legacy system adaptability - supporting older business applications (AX 2009, Bifold, GUP, Dynamics 365, MTMS, and others); ability to investigate and reverse-engineer an undocumented estate - Incident response - calm and effective under pressure, with rapid response during major/high-severity incidents that can occur at any time Requirements - Onboarding / discovery (approx. first 5 days) - investigate the current state of the systems and databases to understand what is there; begin building a knowledge base. - Routine BAU - regular health checks and proactive monitoring. - Reactive troubleshooting - resolving performance issues and debugging problems across the different database platforms. - Major incident support - handling high-severity incidents, potentially out-of-hours via on-call / standby arrangements. - Knowledge capture - documenting the environment to ensure continuity and reduce reliance on any single individual (pod model). Benefits - Opportunities for certification and training - Internal referral bonus up to EUR 1.000 - Gym allowance - Medical Reimbursement - Full salary covered up to 20 days of sickness - Flexible working hours - Loyalty scheme - Team-building activities, special events and conferences - UK/EU Travel opportunities - Snacks and drinks in the office
Senior Database Administrator – DBA
CasheaCompra ahora y paga después, en cuotas sin interés. El impulso que mereces.
• Poseer la salud, rendimiento y fiabilidad de nuestra propiedad de PostgreSQL (alrededor de 60 bases de datos en Cloud SQL) • Actuar como el principal punto de contacto entre el Core Platform y otros equipos de ingeniería • Definir y abogar por estándares de bases de datos para diseño de esquemas, migraciones, indexación y gestión de conexiones • Educar y orientar a los desarrolladores a través de revisiones, documentación y sesiones internas, dejando equipos más autosuficientes con datos • Apoyar nuestros pipelines de datos, manteniendo el flujo de PostgreSQL a BigQuery a través de Datastream (CDC) saludable
Database Administrator III
Rheserva ConsultoriaHá 18 anos trabalhando para potencializar resultados de empresas através das pessoas
• Serve as a Database Administrator III. • Performance optimization (query tuning, execution plans, indexes and statistics). • Manage backup and restore routines. • Monitor the environment, perform troubleshooting and analyze locks and deadlocks to ensure system stability.



