Database Administrator - PostgreSQL

Description : This position will be responsible for supporting new and existing database systems managed on AWS/Oracle/Other Cloud or on-prem deployments. The Database Administrator will help demonstrate and follow best practices in Database Administration, High Availability, Database Management, Database Design, Performance Optimizations and will introduce innovation with automation.The EDB & Postgres Database Administrator should have advanced knowledge of databases including creation and implementation of fully functional database instances on various platforms.Responsibilities : - Provide DBA services to internal and external clients in Linux and AWS/OCI/Other Cloud environments.- Designs, installs, and maintains complex database systems including data modeling, access, security, performance, and documentation.- Leads the designs, development and implementation of database backup and recovery procedures to insure reliability- Actively participate in the adoption of strategic platforms for EDB & Postgres database (and other open databases) - on-premises and Cloud Infrastructure- Collaborate on Database Automation activities to improve process efficiency and risk compliance- Drive Stability initiatives by proactively reviewing and addressing Database performance and capacity trends- Develop and execute database migration, change management and configuration management tasks for new releases of their products- Database Performance Tuning, Query analysis and optimization- Assist and mentor the development staff with SQL and PL/SQL tuning- Familiar in Transaction Logging, Connection Pooling , Security patching and Access control- Experience with Enterprise Failover Manager- Must be able to patch/upgrade PostgreSQL & EDB database.- Design, maintain and ensure high availability solutions including replication, clustering etc.- Should have knowledge to tune DB query.Requirements : - 2+ years of database development experience (preferably in Healthcare/Life Sciences domain)- 2+ years of experience with Postgres & EDB on Linux- 2+ years of experience in Database Tuning- 2+ years in AWS / Oracle OCI - 2+ years of experience in Database Platforms including Governance Integration, Security and Operations- Experience in all aspects of the software development lifecycle including requirements gathering, design, coding, testing and production support- Experience in transforming to and from on premise environment to cloud technology- Working experience in Healthcare Technology and knowledge of Argus Safety is a big plus- Knowledge of Strong problem-solving skills and willingness to roll up one's sleeves to get the job done- Excellent written and verbal communication skills- Degree in Computer Science, Engineering or equivalent preferred (ref: hirist.com