Database AdministratorPosition: Database Administrator
Location: Markham
Reports To: Director of IT Applications
POSITION SUMMARYWe are seeking a Database Administrator with strong database engineering and operational expertise to manage secure, reliable, and high-performing enterprise database services. This role will support the databases and related backend components used by business applications, data integration, and analytics, with primary accountability for database availability, data integrity, recoverability, and security.
The administrator will manage database configuration, performance, backups, restoration, transaction and diagnostic logs, monitoring, access, and operational maintenance across assigned on-premises and cloud environments. Working with application owners, Infrastructure, IT Security, the Enterprise Data Architect, and data engineers, the role will strengthen backend operations, support integrations, and reduce the risk of disruption or data loss.
ATTRIBUTES- Deep database expertise and structured troubleshooting
- Operational ownership and attention to data integrity
- Strong security awareness and discipline change management
- Proactive monitoring, risk identification, and prevention
- Collaboration, clear documentation, and service focus
RESPONSIBILITIESOwn the operational health of assigned database services and coordinate dependent backend activities with the responsible application, infrastructure, security, and integration teams.
ACTIVITYDESCRIPTIONDatabase and Backend Administration
Install, configure, administer, and maintain assigned Database and Azure data lake services. Manage database settings, storage, scheduled jobs, statistics, indexes, maintenance, and environment configuration. Coordinate patches, upgrades, and migrations with tested rollback plans. Support service accounts and database connectivity with the appropriate platform owners.
Reporting for Different Levels
Build executive scorecards for strategic performance and exceptions; departmental dashboards for targets, trends, and drivers; and operational views for detailed transactions and follow-up actions. Enable a consistent path from enterprise summaries to region, site, product, customer, and transaction details where data and permissions allow.
Business Requirements and Insights
Lead discovery sessions, clarify business questions and decisions, and translate requirements into wireframes, report specifications, and acceptance criteria. Analyze trends, variances, and drivers; explain findings in business terms and help stakeholders identify actions supporting revenue growth, margin, and customer retention.
Model Collaboration and Accuracy
Use approved, reusable semantic models and KPI definitions. Develop report-specific measures within agreed standards and collaborate with the Data and Modeling Engineer on shared calculations and model changes. Reconcile results with source systems and business control totals, investigate discrepancies, and obtain business owner sign-off.
Delivery and User Adoption
Manage the reporting backlog and agreed priorities. Coordinate demonstrations, user acceptance testing, controlled releases, and documentation. Train users, support self-service reporting within governance standards, track usage and feedback, and continuously improve the reporting experience.
Security and Operational Support
Implement and test approved row-level security and report access. Support workspace and Power BI app publishing, refresh monitoring, performance tuning, incident resolution, and change control. Maintain report inventories, calculation documentation, access evidence, and support instructions; provide cross-training and backup coverage.
QUALIFICATIONS - Bachelor's degree in information systems, Computer Science, Business Analytics, Finance, Engineering, or a related field, or equivalent relevant experience.
- 5+ years of relevant business intelligence or analytics experience, including at least 3 years of substantial hands-on Power BI dashboard and report development.
- Advanced Power BI expertise with a strong portfolio demonstrating visual design, interactive analysis, executive dashboards, and business reporting. Candidates should be able to demonstrate their work using anonymized or sample data.
- Strong DAX, Power Query, SQL, dimensional modeling, and Power BI semantic model skills, including relationships, filter context, time intelligence, and performance optimization.
- Practical experience with Power BI Service, workspaces, apps, refresh and gateway configuration, row-level security, and controlled development and release processes.
- Ability to translate complex data into clear business insights and engage effectively with senior leadership, Marketing, Finance, and Customer Service across global locations.
- Experience validating and reconciling reporting results, documenting KPI logic, coordinating user acceptance testing, and delivering user training.
Preferred Experience - Manufacturing or global enterprise reporting; ERP, MES and CRM data, including QAD ERP, Plex MES, Salesforce CRM; Microsoft Fabric and Azure data platforms; Microsoft Power BI certification such as PL-300; financial, commercial, and customer service analytics.
The base salary range for this position is $100,000 - $115,000 annually. In determining the rate of pay, Amphenol considers a variety of nondiscriminatory factors, including but not limited to geographic location, relevant industry experience, qualifications, skills, and education. It would be rare for an individual to be hired at or near the top of the range for a given role. Base salary is one facet of Amphenol's total rewards package which includes participation in our comprehensive benefits program with medical, dental, and vision benefits, vacation, sick leave, paid holidays, life insurance, short/long term disability, and membership in our Defined Contribution Pension Plan.
