PostgreSQL DBA

• It is 100% Onsite Position.
  
• Candidate must be located within commuting distance or willing to relocate to Providence RI
  
• Candidate must be available to work on a rotating shift schedule to provide 24/7 support including early mornings late nights weekends and on-call coverage.
  

• The job entails sitting as well as working at a computer for extended periods of time.
  
• Should be able to communicate by telephone email or face to face.
  

Requirements

• Bachelor s degree or foreign equivalent required from an accredited institution. Will also consider three years of progressive experience in the specialty in lieu of every year of education
  
• At least 7 years of Information Technology experience
  
• At least 6 years of experience in MS SQL server on Azure/PostgreSQL administration and maintenance
  
• Understanding of Azure framework MS SQL Server in Azure is a must
  
• Able to install and configure the MS SQL Server configure the SQL clustering SQL Always On Availability Groups
  
• Able to do the capacity planning based on the growth pattern of the databases
  
• Have expert troubleshooting skills on the SQL Clustering environment and Postgres environment
  
• Monitor maintain database systems and troubleshoot problems that may arise
  
• Strong Analytic skills Data Modelling & Performance tuning in MS SQL server/PostgreSQL
  
• Perform Upgrade of databases to different versions of SQL and migration of databases from SQL server to PostgreSQL
  
• Maintain data integrity and security (manage roles and permissions of database users)
  
• Use tools like SQL Profiler Database tuning advisor Execution plans for database tuning and Index recommendations
  
• Generate traces execution plans identify performance issues deadlocks/contention and resolve them
  
• Develop strategies and implement solutions for managing back-ups restoration and replication
  
• Strong knowledge of SQL Server Integration Services (SSIS) Reporting Services (SSRS) and Analysis Services (SSAS)
  
• Should be well versed with the SQL replication functions and Change Data capture process
  
• Ensure timely completion of the Databases regular refreshes keeping all the reporting environment in sync
  
• Create detailed documentation including diagrams of database infrastructure
  
• Learn relevant business processes and understand the data flow criticality and dependencies
  
• U.S. citizens and those authorized to work in the U.S. are encouraged to apply. We are unable to sponsor at this time
  

• Worked on tools like Qlik Attunity SolarWinds DPA and Delphix.
  
• PowerShell programming
  
• Backup and restore tools like EMC Networker CommVault
  
• Planning and Co-ordination skills
  
• Experience of Mergers and Acquisitions will be an added advantage
  
• Good Communication and Analytical skills