What are the responsibilities and job description for the Database Administrator III position at IDEMIA?
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.
**The US base salary range for this position is $93,440 - $116,813 bonus benefits. Our salary ranges are determined by role and level. The range displayed on each job posting reflects the compensation target for the role across all US locations. Individual pay is determined by job-related skills, experience, and relevant education or training. Beyond offering a competitive total rewards package, we offer various opportunities to support team member growth and success**.
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.