eTeam
Job Details:
Must Have Skills
MS SQL serverPostgreSQL administration and maintenance
Required Qualifications: • Candidate must be located within commuting distance or willing to relocate to any of the hub locations area of'Tempe, AZ, Richardson, TX; Raleigh, NC; Hartford, CT; Indianapolis, 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. • 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
Preferred Qualifications: • Worked on tools like Qlik Attunity, SolarWinds DPA and Delphix. • PowerShell programming • Backup and restore tools like EClient Networker, CommVault • Planning and Co-ordination skills • Experience of Mergers and Acquisitions will be an added advantage • Good Communication and Analytical skills
Required Qualifications: • Candidate must be located within commuting distance or willing to relocate to any of the hub locations area of'Tempe, AZ, Richardson, TX; Raleigh, NC; Hartford, CT; Indianapolis, 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. • 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
Preferred Qualifications: • Worked on tools like Qlik Attunity, SolarWinds DPA and Delphix. • PowerShell programming • Backup and restore tools like EClient Networker, CommVault • Planning and Co-ordination skills • Experience of Mergers and Acquisitions will be an added advantage • Good Communication and Analytical skills