Database Administrator III

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.

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.

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.