Raye IT Consulting, LLC is a 8a certified minority woman-owned IT consulting and technology firm. Raye IT brings over 20 years experience in delivering mission-critical programs and support for the Federal Government and large agencies. We specialize in program and project management, capital planning and IT investment portfolio management, infrastructure support and application development deployment to include IT operations and maintenance. We deliver value through technical and managerial expertise – innovation, efficient processes, executable strategies, and methodologies that generate tangible and measurable results to our clients across the Federal, Civilian and DoD sectors.
Microsoft Access Database Developer
Location
United States
Posted
21 hours ago
Salary
0
Seniority
Mid Level
No structured requirement data.
Job Description
Microsoft Access Database Developer
Raye IT Consulting
Role Description Raye IT Consulting is seeking a Senior MS Access Database Developer to serve as the lead technical resource responsible for the maintenance, development, and optimization of a federal client's Financial Management Tool (FMT). - Lead development and ongoing maintenance of the MS Access front-end application, including forms for data entry and retrieval, queries for reporting and data updates, local reporting tables, and automation of recurring data processes. - Design and maintain the ODBC connectivity layer between the MS Access front end and the cloud-hosted MariaDB/MySQL backend, ensuring stable, performant communication between application tiers. - Develop and maintain queries, stored procedures, and data workflows that support budget formulation, spend approvals, funding allotments, vendor and contract management, inter- and intra-agency agreement tracking, and obligation of funds. - Perform bulk data loads and updates to maintain accurate financial data across multi-year budget cycles containing thousands of rows of plan data, contract records, agency agreements, and fund obligations. - Build, maintain, and refresh MS Excel-based reports using Pivot Tables connected via ODBC to MS Access front-end queries; ensure daily refresh of standard reports and develop new reports as requirements evolve. - Document all reporting processes, including data sources, query logic, refresh schedules, and output formats, to ensure continuity and auditability. - Manage version and environment control for the MS Access file, ensuring changes are tracked, tested, and deployed in a controlled manner across the user community. - Perform ongoing performance tuning, error resolution, and data integrity monitoring; respond to user-reported issues and proactively identify system anomalies. - Maintain role-based access management across the user base; ensure appropriate permissions are assigned, documented, and audited. - Store and distribute the MS Access file, Excel reports, and user documentation via a SharePoint site; maintain organized and accessible repositories for all tool-related materials. - Produce and maintain technical documentation for all forms, queries, tables, automation processes, and data management procedures. - Support requirements management by translating stakeholder needs into technical specifications and implementing changes in alignment with governance and budget timelines. - Conduct new technology research to identify opportunities to improve tool performance, scalability, or functionality within the federal IT environment. Qualifications - 8+ years of hands-on MS Access development experience, including forms, queries, macros, VBA automation, and table architecture in an Office 365 (64-bit) environment. - Demonstrated expertise with MariaDB or MySQL, including database design, query optimization, stored procedures, and ODBC integration with MS Access front-end applications. - Strong SQL skills; experience writing complex queries for reporting, data validation, and bulk data operations across large, multi-year datasets. - Experience building and maintaining MS Excel reporting solutions using Pivot Tables with live ODBC connections to database back-ends. - Proven ability to manage the full development lifecycle of a database application — from requirements gathering and design through testing, deployment, documentation, and ongoing support. - Experience supporting federal IT financial data systems, including budget execution, obligations tracking, inter-agency agreement management, or similar financial workflows. - Strong written communication skills; ability to produce clear technical documentation and present findings to both technical and non-technical federal stakeholders. - Experience with SharePoint as a document repository and file distribution platform. - U.S. Citizenship required; ability to obtain and maintain a federal Public Trust clearance and HSPD-12 credentials. - Ability to complete mandatory federal training requirements, including annual Information Security Awareness Training (ISAT). Requirements - Prior experience supporting the USDA FPAC Business Operations Branch (BOB) Financial Management Tool (BOB FMT) or equivalent federal agency financial management database system. - Familiarity with FPAC's multi-agency shared-cost IT budget model spanning FSA, NRCS, RMA, and FPAC-BC. - Experience integrating MS Access applications with AWS-hosted cloud databases using Oracle MySQL ODBC driver (v8.0.x or higher). - Knowledge of USDA IT security and privacy policies, including FISMA compliance, NIST SP 800-53, and federal system Authority to Operate (ATO) requirements as they apply to database development. - Experience with the USDA AgMAX capital planning tool and data loading processes for CPIC reporting. - Familiarity with federal IT financial terminology including obligations, accruals, commitments, spend plans, Working Capital Fund (WCF), and inter-agency agreement (IAA) structures. - Section 508 / WCAG 2.0 compliance awareness for database-integrated application development. - CompTIA Security+, Microsoft Certified: Data Analyst Associate, or equivalent certification. Benefits - 401(k) - 401(k) matching - Health Insurance - Dental Insurance - Disability Insurance - Flexible Spending Account (FSA) - Life Insurance - Paid Time Off Security Clearance Requirements Public Trust Schedule Monday - Friday (remote U.S. Based) - must be available during Kansas City core hours.
Related Guides
Related Categories
Related Job Pages
More Database Administrator Jobs
Financial Aid File Administrator
Full Sail UniversityHeadquartered in Winter Park, Florida, Full Sail University is a leading educational institution for students pursuing careers in the entertainment and media in
Title: Financial Aid File Administrator locations Full Sail time type Full time job requisition id R00002929 Job Description: If you're looking for the chance to learn, grow, and make a contribution to the community, look at employment opportunities with Full Sail University. You'll find your choice of career opportunities, great benefits, an environment that welcomes and values creativity, and a work experience that is both challenging and rewarding! Administer all financial aid for online students from becoming active through to graduation; ensure compliance with all Title IV regulations; and create a positive and stress-free experience for all students. Positions are located on and worked from campus in Winter Park, Florida. Essential Duties and Responsibilities: - Process Reports with timeliness and accuracy - Repackage Subsequent Academic Year Financial Aid - Process Verifications on new ISIRs - Package Private, SFCA and Plus loans as needed - Process Audit Corrections - Respond to Student Advisor Requests - Adjust students’ packaging for Credits for Previous Training Other Responsibilities: - Adheres to the policies and procedures of Full Sail University - Maintains strict confidentiality of company and personnel information - Demonstrates a strong commitment to the mission and values of the organization - Adheres to company attendance standards - Performs other duties as assigned Supervisory Responsibilities: No Competencies: - Highly developed sense of integrity and commitment to student satisfaction. - Ability to communicate clearly and professionally, both orally and in writing. - Strong decision making and analytical abilities. - Strong attention to detail. - Demonstrated time management and organizational skills. - Ability to manage multiple, competing tasks and deliver accurate and courteous service in a fast-paced and time sensitive environment with the ability to adapt to changing and competing priorities. - Ability to work within the scope of Title IV regulations. - Proficiency with all Microsoft Office Suite software. - Demonstrate initiative and adaptability to change. - Ability to work independently and efficiently. - Ability to maintain highly sensitive, confidential academic and financial information in accordance with FERPA guidelines. Education and/or Experience: - Bachelor's degree preferred or two years of Administrative/Financial aid or other relevant experience. - Must be in good standing in all Federal Title IV programs and remain current with federal, state, and institutional financial aid regulations. Computer/Equipment Skills: - Microsoft Office Suite proficiency. Environmental Factors/Physical Demands: Physical requirements include remaining seated for potentially more than 8 hours per day, computer operation/data entry and minor lifting. Must be flexible and able to work a 40 hour work week. May include some overtime, nights and weekends. This position is based on Full Sail University’s campus in Winter Park, Florida and can be performed on a hybrid basis to work from home and from campus. Full Sail management reserves the right to end hybrid positions at any time and require employees to work from campus permanently. Full Sail is an Equal Opportunity Employer.
Role Description Overlake Medical Center & Clinics is seeking a Senior Database Administrator with experience in Healthcare and EPIC system to partner with application, reporting, and analytics teams to support data integration and ETL processes, enforce database security and access controls, and maintain high availability and business continuity across enterprise database environments. The Senior Database Administrator – Epic Cogito is responsible for the configuration, monitoring, and support of Epic's enterprise reporting systems and data infrastructure. This role ensures optimal performance of reporting databases and analytics solutions, serving as a key technical resource for data availability, system reliability, and continuous improvement across the organization. Full Time - Exempt Remote (Requires Washington State Residency) Core Responsibilities - Cogito Platform Administration: Administer Epic Cogito platforms including Clarity, Caboodle, SlicerDicer, and Radar. Install, configure, and maintain data warehouse databases and reporting environments. - ETL & Data Pipeline Management: Monitor, maintain, and troubleshoot ETL processes and data pipelines to ensure data accuracy and timeliness. Manage data extraction jobs, resolve ETL failures, and address data quality issues. - Database Performance & Capacity Planning: Support capacity planning, performance tuning, and database optimization, including SQL Server indexing strategies and database growth management. - Reporting & Analytics Support: Partner with report developers and BI teams to ensure data availability and support the development and maintenance of data models, dashboards, and analytics use cases. - System Maintenance & Upgrades: Coordinate system patches, Epic upgrades, environment refreshes, release cycles, and migration activities while ensuring system uptime, proactive monitoring, and effective incident response. - Security & Compliance: Implement and maintain security controls, access management, and audit compliance across reporting environments. - Documentation & Standards: Maintain technical documentation, runbooks, and operational standards to support consistency and knowledge sharing. - On-Call Support: Provide on-call support for critical reporting or data issues as needed. Qualifications - Bachelor's Degree or equivalent combination of education and related experience may be considered in lieu of degree. - Minimum of five (5) years of experience as DBA required, preferably in a healthcare environment. - Epic Cogito Certification – Clarity and/or Caboodle (required). - 3+ years of experience supporting Epic reporting environments. - Strong proficiency in SQL Server and relational databases, including stored procedures, query optimization, and indexing. - Hands-on experience with ETL tools, workflows, and data integration. - Solid understanding of data warehousing concepts (EDW, star schema, dimensional modeling). - Working knowledge of Epic Cogito tools, including Clarity, Caboodle, SlicerDicer, and Radar. - Experience with healthcare data models and familiarity with clinical and operational data structures. - Understanding of healthcare workflows and regulatory requirements. - Experience with BI/reporting tools such as Power BI, Tableau, SAP BusinessObjects, or similar enterprise analytics platforms. Benefits - Medical insurance premiums as low as $0 per month. - Many Overlake services covered at 100%. - Tuition reimbursement up to $10,000 per year. - Generous retirement plan matching starting at 5% and increasing to 7% after five years with immediate vesting. - Pre-tax and Roth after tax retirement savings plans. - An expanded Employee Assistance Program. - A caregiver support program to help with everything from childcare to eldercare. - Free parking and Orca transit passes.
Senior Database Administrator
University of Texas SystemHeadquartered in Dallas, Texas, the University of Texas Southwestern Medical Center is part of the University of Texas higher education system. Founded in 1943,
Role Description The Senior Database Administrator for the UT Data Hub improves university outcomes and advances the UT mission to transform lives for the benefit of society by increasing the usability and value of institutional data. The position builds and maintains cloud database infrastructure and automates database processes for the UT data ecosystem. It covers database and system administration across Oracle, PostgreSQL, and Databricks, and devises optimal database configurations to meet university needs for high-performance data systems and ensures compliance with UT information security requirements. The role requires strong troubleshooting skills and the ability to build effective working relationships across technical and non-technical teams. Main tech stacks include: Databricks, AWS, Cognos, Oracle, PostgreSQL, and Tableau. Responsibilities - Cloud Database Administration: - Contribute to all day-to-day operations of PostgreSQL databases in a 24x7 production environment. - Demonstrate progressive troubleshooting and analytical skills through timely problem resolution. - Define database architectures to meet application performance and security requirements. - Implement tuning improvements and advise developers on SQL tuning options. - Provide technical guidance on integration, design and testing on production system databases. - Develop process for Performance Monitoring of database servers and individual databases. - Develop, implement and improve backup and disaster recovery strategies. - Develop and implement high availability solutions. - Perform PostgreSQL server updates, upgrades and installations. - Demonstrate an ability to write SQL scripts and stored procedures. - Advise teams on best practices for database deployment and management. - Collaborate with support teams on various IT projects. - Contribute to improving and creating database application processes and procedures. - Participate in on-call rotation. - Systems Administration: - Provide Windows and Linux system administration as needed for database applications. - Configure and maintain (including patching) legacy Oracle database instances. - Participate in change management processes to coordinate and communicate systems administration activity. - AWS & Databricks Platform Administration: - Hands-on administration of AWS services supporting database workloads (RDS, S3, EC2, IAM, VPC). - Databricks workspace administration including cluster management, access controls, and Unity Catalog. - Experience with dbt (Data Build Tool). - Use Infrastructure as Code tools, specifically AWS CDK and Terraform, to provision and manage database infrastructure. - Set up and maintain database monitoring and alerting using AWS CloudWatch or equivalent tools. - Other Responsibilities: - Communicate status of activities and findings through verbal, written, and/or visual reporting. - Support credential and secrets management practices in alignment with team security standards. - Other related functions as assigned. Qualifications - Bachelor’s degree in Computer Science, Information Systems, Engineering, or equivalent professional experience. - Average of 4-10 years of professional experience in a DBA role with PostgreSQL or similar databases. - Experience in SQL scripting and database tuning. - Skilled at database design, installation, migration and conversion. - Experience with Databricks and AWS administration is also a requirement for this position. - Demonstrated experience with automation of database processes. - Strong aptitude for troubleshooting and problem solving. - Team player, comfortable communicating cross-functionally and across management levels. - Self-motivated and able to organize work independently in a rapidly changing environment. - U.S. Citizen, resident, or officially recognized asylee. - Equivalent combination of relevant education and experience may be substituted as appropriate. Preferred Qualifications - Bachelor’s degree with three years of experience with automation of cloud-based workloads. - Four years of experience working in a cloud-based data warehouse environment. - Four years of DBA experience with Amazon Web Services and Databricks. - Experience with multiple types of databases. - Experience with high availability database implementations. - Experience with Windows and Linux system administration. - Basic networking knowledge as it relates to database systems. - Experience with implementing and maintaining database infrastructure to support all aspects of the software development cycle (SDLC). - AWS/Databricks certification is a strong plus. - Strong knowledge of Quality Assurance processes, test case development and execution. - Knowledge of Agile software development methodologies (Kanban, Scrum). - Experience with issue tracking systems (JIRA). Salary Range $105,000 + depending on qualifications Working Conditions - May work around standard office conditions. - Repetitive use of a keyboard at a workstation. - Use of manual dexterity (ex: using a mouse). - Up to 100% remote at employee discretion with office work environment is also an option. - Majority of team is located in Austin, TX, and working remotely with infrequent in-office presence. Work Shift Monday – Friday 8am-5pm; Occasional nights or weekends may be required. Required Materials - Resume/CV - 3 work references with their contact information; at least one reference should be from a supervisor. - Letter of interest.
Role Description We are looking for a qualified Database Developer to design stable and reliable databases, according to our company’s needs. You will be responsible for developing, testing, improving, and maintaining new and existing databases to help users retrieve data effectively. As part of our IT team, you will work closely with developers to ensure system consistency. You will also collaborate with administrators and clients to provide technical support and identify new requirements. Communication and organization skills are keys for this position, along with a problem-solution attitude. Ultimately, you should be able to ensure our database systems run effectively and securely on a daily basis. - Design stable, reliable and effective databases - Optimize and maintain legacy systems - Modify databases according to requests and perform tests - Solve database usage issues and malfunctions - Liaise with developers to improve applications and establish best practices - Gather user requirements and identify new features - Develop technical and training manuals - Provide data management support to users - Ensure all database programs meet company and performance requirements - Research and suggest new database products, services and protocols Qualifications - Proven work experience as a Database developer - In-depth understanding of data management (e.g. permissions, recovery, security and monitoring) - Knowledge of software development and user interface web applications - Hands-on experience with SQL - Familiarity working with .Net Framework, JavaScript, HTML and Oracle - Excellent analytical and organization skills - An ability to understand front-end users requirements and a problem-solving attitude - Excellent verbal and written communication skills - BSc degree in Computer Science or relevant field