Database Administrator III at IDEMIA Canada

, Tennessee, United States -

Full Time

Start Date

Immediate

Expiry Date

12 Jan, 26

Salary

0.0

Posted On

14 Oct, 25

Experience

5 year(s) or above

Remote Job

Yes

Telecommute

Yes

Sponsor Visa

Skills

Database Administration, SQL Server, PostgreSQL, T-SQL, Performance Tuning, AWS, Disaster Recovery, Automation, Cloud Integration, Security Compliance, Backup Management, Scripting, Monitoring Tools, CI/CD, Indexing Strategies, High Availability

Industry

Software Development

Description

Overview IDEMIA is the global leader in identity and security. Our mission is to create a safe and simple future where identity verification is indisputable, and only you can assert your identity. We are a distributed company leveraging the latest technologies to deliver world-class products in the private and public sectors of finance, telecom, identity, security, retail, sports entertainment, commercial, government, and IoT. We use a variety of technologies and approaches to deliver quality product and services to government agencies and technology companies. IDEMIA is a made up of a group of 14,000 diverse people from different nationalities, speaking over 20 different languages. Together, our solutions impact the everyday lives of citizens and nations. In this ever-changing world, protecting your identity is paramount. Join the team that is ensuring one person - one identity. Responsibilities Administration & Operations Manage and maintain SQL Server instances hosted on Windows EC2, including clustered and Availability Group configurations. Support and maintain PostgreSQL RDS instances in AWS. Perform regular SQL Server patching, version migrations, and availability group failover testing. Monitor database health and performance using performance monitoring tools such as; SQL Sentry, SQL Agent alerts, CloudWatch, and DataDog dashboards. Ensure TDE (Transparent Data Encryption) environments remain healthy and compliant. Manage SQL Agent jobs, alerts, and job history for all production and pre-production systems. Performance & Optimization Conduct index and query tuning, including execution plan analysis and wait statistics review. Perform server-level performance diagnostics (I/O bottlenecks, PAGEIOLATCH, CPU spikes, parameter sniffing, etc.). Collaborate with development teams to provide performance recommendations and identify query optimization opportunities. Security & Compliance Manage database-level permissions and access controls following internal least-privilege standards. Participate in periodic PCI and FISMA/FedRAMP compliance audits as they relate to database controls. Support auditing and logging for sensitive (PII) data environments. Backup & Recovery / Disaster Recovery Oversee backup configurations and retention policies. Perform disaster recovery validation and availability group failover testing. Manage RDS snapshots, point-in-time recovery, and restore procedures. Deployment & CI/CD Support Support schema and object deployments using Redgate SQL Source Control and SQL Change Automation. Troubleshoot deployment issues in TeamCity pipelines; assist in transition to GitLab CI/CD. Validate schema synchronization, environment drift, and rollback plans. Scripting & Automation Develop and maintain basic PowerShell scripts for administrative automation and reporting. Write and optimize SQL/T-SQL scripts for maintenance, troubleshooting, and ad-hoc analysis. Bonus: Exposure to Python, bash, or automation scripting within AWS environments. Cloud & Systems Integration Work within AWS GovCloud, managing RDS, EC2, and S3 integrations for database operations. Collaborate with infrastructure teams on IAM roles, instance sizing, and snapshot policies. Assist in the design and testing of cross-region disaster recovery and backup solutions. Qualifications Required 5-7 years of professional experience as a Database Administrator (SQL Server focus). Proven experience supporting SQL Server 2016+ in clustered and high-availability environments. Strong understanding of T-SQL, indexing strategies, and performance tuning. Experience with AWS RDS (PostgreSQL) administration and monitoring. Familiarity with Redgate SQL Source Control or other schema deployment tools. Working knowledge of Availability Groups, TDE, and PII-compliant data handling. Ability to manage multiple environments (Dev, QA, Staging, Prod) under change control processes. Excellent communication and documentation skills. Preferred / Bonus Skills Hands-on experience with SQL Sentry and/or CloudWatch / DataDog. Exposure to CI/CD pipelines (TeamCity, GitLab, or similar). Familiarity with Redgate SQL Source Control or other schema deployment tools. Familiarity with PostgreSQL tuning and monitoring on RDS. Understanding of FISMA, FedRAMP, or PCI compliance controls. Experience with SSRS installation and troubleshooting. Knowledge of AWS IAM, S3, snapshot management, and cross-account role usage.

How To Apply:

Incase you would like to apply to this job directly from the source, please click here

Responsibilities

The Database Administrator III will manage and maintain SQL Server and PostgreSQL instances, ensuring optimal performance and security. Responsibilities include monitoring database health, conducting performance tuning, and overseeing backup and recovery processes.