Database Administrator IV (PostgreSQL Experience)

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

• Help establish standards and practices to configure and maintain database servers and processes, including monitoring of system health and performance, to ensure high levels of performance, availability, and security.
• Independently analyze, solve, and correct issues in real time, providing problem resolution end-to-end.
• Identify new opportunities and help refine automation of regular processes, track issues, and document changes.
• Ensure efficiency improvements and changes to operations processes are implemented. Automate everything possible for environment-wide consistency.
• Work in an Agile Scrum model.
• Ability to work with and assist software application development groups to provide database setup, configuration, optimization, and modification support.
• Assist developers with complex query tuning and schema refinement. Conduct systematic performance tuning (i.e., server, database and query performance tuning, index tuning, database-related component tuning, and product-specific database request tuning).
• Assist in development, efficiency improvements and implementation of database policies and procedures for data security and integrity. Maintain environment metadata reporting frameworks and identify trends within the environment to further increase efficiency.
• Expert in troubleshooting performance issues.
• Join the on call rotation with other DBAs. Provide guidance and support working with the 24x7 database administration team for all Postgres and SQL Server production databases, services, and infrastructure, both in house and cloud resident. The team also supports development and quality testing environments as needed.
• Provide 24x7 support for critical production systems.
• Share domain and technical expertise, providing technical mentorship and cross-training to other peers and team members.
• Administer and maintain production and test databases ensuring high availability and recoverability standards.
• Manage Postgres and SQL Server databases through multiple product lifecycle environments, from development to mission-critical production systems.

• Configure and maintain database servers and processes, including monitoring of system health and performance, to ensure high levels of performance, availability, and security.
• Conduct database DR failover testing in production environments.
• Perform scheduled maintenance and support release deployment activities after hours.
• Provide architectural review and recommendations for new processes, applications and products requiring database integration and/or ETL. Drive the team to provide appropriate solutions, not simple short-term fixes to escalated issues.

Qualifications

• Bachelor's degree in Computer Science, Information Technology or related discipline, or equivalent experience required.
• 5+ years PostgresSQL experience required.
• 5+ years MS SQL Server Administration experience required.
• Experience in architecting and deploying AWS RDS Aurora Postgres.
• Expert knowledge of monitoring, query tuning and performing DB maintenance tasks in AWS.
• Proven extensive experience with MS SQL Server (2008 to 2019 versions), knowledge of SQL Server Internals, wait types, scheduling, etc and a passion to learn required.
• Experience with backups, restores and recovery models.
• Knowledge of High Availability (HA) and Disaster Recovery (DR) options for SQL Server. Strong knowledge on clustering, TDE, AlwaysOn, LogShipping, Replication.
• Cloud-based experience such as SQL Server in Microsoft Azure, AWS, or equivalent platform required.
• Expert experience with scripting tools such as PowerShell, batch, and T-SQL.
• Expert knowledge of Query Optimizer and query performance tuning
• Ability to work flexible hours as required by business priorities.
• Excellent verbal and written communication skills, and customer service.
• Advanced analytical and creative skills and demonstrate resourcefulness in problem solving and optimization of design.
• Ability to communicate information and issues clearly and succinctly with both technical and non-technical personnel.

• Self-manage work and complete systems and database related projects independently, on a team, and while leading a team.
• AWS Postgres certifications a plus.
• MCTS, MCITP, and/or MVP certifications a plus.