Database Administrator
Location
Canada
Posted
3 days ago
Salary
$75K - $115K / year
Seniority
Senior
Job Description
Database Administrator
Jones Lang LaSalle Americas, Inc.
• Administer the Corrigo CMMS platform to ensure optimal system performance, data integrity, and adherence to operational standards through configuration management, system audits, and database maintenance protocols • Configure system settings including user access controls, property/asset hierarchies, work order scheduling processes, and system integrations to meet specific client requirements • Partner with client teams as the primary CMMS technical advisor and subject matter expert, processing data requests efficiently while maintaining accurate time tracking for reimbursable services • Develop reporting solutions and analytics that deliver performance insights, support account teams with complex data analysis, and maintain comprehensive database accuracy through regular validation • Analyze client change requests, provide impact assessments to support decision-making, and deliver system training and knowledge transfer to maximize platform adoption • Document and deploy configuration changes following change management protocols, explore innovative solutions within existing system capabilities, and implement process improvements based on industry best practices
Job Requirements
- Corrigo Platform certification with demonstrated hands-on experience administering the system
- Advanced Microsoft Excel proficiency including complex formulas, pivot tables, data analysis functions, and reporting capabilities
- Strong analytical and problem-solving capabilities with exceptional attention to detail and data accuracy
- Excellent verbal and written communication skills with ability to translate technical concepts for diverse audiences
- Proven ability to manage multiple complex projects simultaneously while maintaining quality standards and meeting deadlines
Benefits
- Professional development activities including Corrigo training
- Knowledge sharing sessions
- Continuous learning opportunities
Related Guides
Related Categories
Related Job Pages
More Database Administrator Jobs
Database Administrator
Jahnel Group, an Inc. 5000 companyWorld Class Software Creators Ready To Hustle For You
• Investigate and resolve application and data-related support tickets. • Write, test, and execute SQL scripts to perform data updates, corrections, and maintenance activities. • Troubleshoot production and UAT issues by analyzing data, stored procedures, and application behavior. • Identify root causes of system issues and work with development teams to implement solutions. • Support reporting and operational data requests across multiple business functions. • Modify and maintain existing stored procedures, queries, and database processes. • Collaborate with developers, business analysts, and stakeholders to understand system workflows and business rules. • Participate in ongoing application support, maintenance, and enhancement initiatives.
Microsoft Access Database Developer
Raye IT ConsultingRaye 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.
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.
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.

