Please Note:
- It is 100% Onsite Position.
- Candidate must be located within commuting distance or willing to relocate to Hartford, CT
- 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.
Description:
- 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
Required Qualifications:
- 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
Preferred Qualifications:
- 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