Sr Datastore Admin Full-time Job

Full Job DescriptionJob Description for PostgreSQL Database Administrator

Full time database engineer, working as both development and Production Postgres DBA. The database engineer role seeks to maximize uptime and performance of databases, utilize query proxies, connection caches, and other technologies as needed to produce clean interfaces to work with and protect data, account management, backup and disaster recovery setups. The Engineer works as a subject matter expert providing consultation to end-users and project team members on database management, query development, system requirements and database change management initiatives and providing technical guidance to other DBAs.

Qualifications Detailed understanding of Postgresql database server architecture, concepts, features, and high-availability technologies.Expert knowledge of PL/PgSQL, triggers, and stored procedures in PostgreSQL.Minimum 5 years of practical hands-on experience with database administration, backup and recovery, performance tuning and high-availability solutions.Experience with database replication, hot stand-by, clustering, and table partitioning.Linux platform familiarity, system resource monitoring and tuning. Shell scripting knowledge is a must.Excellent analytical, organizational and project management skills.Experience in setting up EnterpriseDB Replication.Experience with Barman.Experience with Encryption set up.Be assertive and have good communication skills.Comfortable working in an informal, high-energy team environment.Experience with automation tools. Responsibilities Responsible for implementing, managing, and tuning high-availability 24x7 Postgresql databases.Responsible for designing, deploying and maintaining high-availability 24x7 MongoDB databases.Establish policies and procedures pertaining to data management, security, maintenance and utilization.Develop, manage, and test database backup amp; recovery strategies, verifying data integrity.Perform database installations, configurations, upgrades, and migrations.Proactively monitor and tune for performance.Responsible for capacity planning and recommending paths to account for application growth that are in line with industry best practices.Consult with development and architecture teams to help meet continued application growth.Define and implement database schema and configurations working with our development teams.Create and maintain documentation of procedures, schemas and guides for troubleshooting database systems. Preferences Hands on experience on at least one other database technology, Oracle, SQLserver, MongoDB, MySQL, Hadoop.Understanding of ITIL with Change Management, Problem Management experience.Other technology experience for example, Python, ETL tech, Docker, Kubernetes, Splunk, DataDog, BlueStripe, Orion, Solr, TomCat, Java. IQVIA is a leading global provider of advanced analytics, technology solutions and clinical research services to the life sciences industry. We believe in pushing the boundaries of human science and data science to make the biggest impact possible – to help our customers create a healthier world. Learn more at https://jobs.iqvia.com