CBIS Developer -DBA - Top Secret
Description
CBIS Dev- DBA
Xcelerate Solutions is currently seeking a CBIS Dev-DBA to join our Team. Come join our award-winning organization and work with some of the most talented and brightest minds in the GovCon industry.
Location:
Remote
Clearance:
Top Secret
Responsibilities:
- Provide CBIS application development per customer requirements and provide solutions to
- requirement needs
- Perform development changes to existing features and program requested new features, reports, queries, and modules
- Monitor and update project tables with date ranges within application
- Resolves application tickets submitted for issued users encounter
- Resolves user account issues
- Test and install Oracle quarterly patches
- Refresh AWS IP range
- Install, maintain and update SSL/TLS certificates for IIS and Apache TomCat
- Reset UAT user accounts regularly
- Connect to all three CBIS schemas (CBIS, CBIS Datamart, and CBIS Report) for UAT and Production to prevent accounts expiring
- Pull audit and archived case listings weekly
- Review logs for error messages daily
- Sync cases with data mart that feeds dashboard and provide manual reset when necessary
- Check backup for completion daily and ensure exported
- Perform Java and Tomcat updates weekly/monthly as needed
- Provides development for new features, updates, and changes based on government clients’ request
- Create and maintains database reports and dashboard features
- Provides required security functions of the database (including weekly audit, weekly purge review, updating application procedure documents).
- Submit change requests (CRs) as required
- Troubleshoot application issues
- Perform maintenance on Database
- Ensure log files are purged as necessary
- Review RMAN backup and determine plan to reimplement (jobs\database_backup.ps1 and ensure archive logs are purged daily to ensure drives do not fill up
- Analyzes customer requirements and provides technical solutions, write complex code, and optimize database performance
- Advises on data-based solutions to business problems
- Supports the design, customization, development, build, analysis, evaluation, installation, and administration of database management systems
- Translate requirements into customized applications using PL/SQL, Java, and XML
- Knowledge with Oracle Application Express (APEX)
- Modify and enhance existing Oracle application
- Write, troubleshoot, and tune SQL queries, stored procedures, and triggers for optimal performance
- Perform Testing and Debugging and ensure data integrity
- Supports the preparation of system requirements, source analysis and process analyses and design throughout the database
- Defines database organizations, standards, controls, procedures, and documentation
- Create technical documentation and security documentation for inspections as requested
- Familiarity with software development lifecycle and Agile methodologies.
- Database management – install, upgrade, and patch Oracle
- Manage database tables, indexes, and views
- Monitor database health and optimize SQL queries and system configurations for maximum speed and scalability
- Perform regular backups and periodic data restorations to guarantee data availability
- Implement and enforce database security policies and manage role-based access controls
- Perform schema changes and deploy code through development, test, and production environments.
- Deep understanding of Oracle 19c, APEX, SQL, PL/SQL, Java, and Tomcat
Minimum Requirement:
- Active TS clearance
- Hands on Experience with DBA and as a Developer
About Xcelerate Solutions:
Founded in 2009 and headquartered in McLean, VA, Xcelerate Solutions (www.xceleratesolutions.com) is one of America's fastest-growing companies. Xcelerate’s culture is defined by our diversified workforce of dynamic and versatile professionals, supported with growth and development opportunities that contribute to individual and company growth. This strong commitment to our employees has been recognized by our inclusion on the Washington Business Journal’s “50 Best Places to Work” list as well as being a “Great Place to Work” certified company with a 4.6 star, and a 99% CEO approval Glassdoor rating. Come find out why Xcelerate Solutions is one of the DC Metro top employers!
Founded in 2009 and headquartered in McLean, VA, Xcelerate Solutions (www.xceleratesolutions.com) is one of America's fastest-growing companies. Xcelerate’s culture is defined by our diversified workforce of dynamic and versatile professionals, supported with growth and development opportunities that contribute to individual and company growth. This strong commitment to our employees has been recognized by our inclusion on the Washington Business Journal’s “50 Best Places to Work” list as well as being a “Great Place to Work” certified company with a 4.6 star, and a 99% CEO approval Glassdoor rating. Come find out why Xcelerate Solutions is one of the DC Metro top employers!
Xcelerate Solutions is an Equal Employment Opportunity/Affirmative Action Employer. We evaluate qualified applicants without regard to race, color, national origin, religion, age, equal pay, disability, veteran status, sex, sexual orientation, gender identity, genetic information, or expression of another protected characteristic. As part of this commitment to the full inclusion of all qualified individuals, Xcelerate provides reasonable accommodations if needed because of an applicant's or an employee's disability.
Pay Transparency Notice: Xcelerate Solutions will not discharge or in any other manner discriminate against employees or applicants because they have inquired about, discussed, or disclosed their own pay or the pay of another employee or applicant.
Pay Transparency Notice: Xcelerate Solutions will not discharge or in any other manner discriminate against employees or applicants because they have inquired about, discussed, or disclosed their own pay or the pay of another employee or applicant.