195 applicants

Company

IDEMIA · 2 days ago

Database Administrator IV (PostgreSQL Experience)

United States

Full-time

Remote

Senior Level

5+ years exp

Maximize your interview chances

Identity ManagementInformation Technology

No H1B

U.S. Citizen Only

Insider Connection @IDEMIA

Discover valuable connections within the company who might provide insights and potential referrals.
Get 3x more responses when you reach out via email instead of LinkedIn.

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.

Qualification

Find out how your skills align with this job's requirements. If anything seems off, you can easily click on the tags to select or unselect skills to reflect your actual expertise.

PostgresSQLMS SQL Server AdministrationAWS RDS Aurora PostgresQuery Performance TuningBackupsRecoveryHigh Availability (HA)Disaster Recovery (DR)Cloud-based ExperienceScripting ToolsAWS Postgres CertificationsMCTS CertificationMCITP CertificationMVP Certification

Required

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.

YOU MUST BE A US CITIZEN