\xc2\xb7 Job Title: SQL Server Development Engineer \xc2\xb7 Location: Chicago, IL(Need Local Candidates) \xc2\xb7 Tax Term (W2, C2C): C2C/W2 \xc2\xb7 Job Type (Permanent/Contract) : Contract \xc2\xb7 Duration: 12 MonthsPay rate: $65/hr. C2C: RESPONSIBILITIES/TASKS: \xc2\xb7 Analyze current environment based on monitoring tools, logs, SQL \xc2\xb7 Assist with design and specification of SQL Database environment based on load requirements \xc2\xb7 Present options and collaborate with stakeholders and DBA team on best approaches \xc2\xb7 Identify dependencies and changes requires for database migration in Stored Procs, SSIS Packages, SSRS Reports, Triggers, etc. \xc2\xb7 Help in building up new Database environment with HA, Read Only Replica, Reporting, etc. \xc2\xb7 Propose a database migration plan based on effort and dependencies \xc2\xb7 Assist in support and troubleshooting of complex data issues with product support and productions support teams. \xc2\xb7 Serve as the Technical lead for Database Activities and lead a team of database Developers and Administrators Must Have \xc2\xb7 Extensive knowledge of SQL Server and SQL server tools \xc2\xb7 Deep experience in database performance and health monitoring and maintenance using built in tools and/ or third party tools. \xc2\xb7 Demonstrable experience in SQL Server design, topology, capacity planning and high availability \xc2\xb7 In-depth understanding of database setup, security, and backup/ recovery \xc2\xb7 Familiarity with relational database design and development \xc2\xb7 Working experience in SQL server tuning and performance optimization by recommending and implementing changes in infrastructure design, database and table design, query/ sp tuning, etc. \xc2\xb7 Experience with SSAS, SSIS, and SSRSNice to have: Knowledge of PowerShell Experience with PostgresSQL, DynamoDB Experience in Kafka CDC Job Type: Contract Salary: Up to $65.00 per hour Experience level:
8 years
Schedule:
8 hour shift
Ability to commute/relocate:
Chicago, IL: Reliably commute or planning to relocate before starting work (Required)
Experience:
SSAS: 1 year (Required)
SQL: 1 year (Required)
Kafka: 1 year (Required)
SSRS: 1 year (Required)
SSIS: 1 year (Required)
PowerShell: 1 year (Required)
Work Location: One location
Beware of fraud agents! do not pay money to get a job
MNCJobz.com will not be responsible for any payment made to a third-party. All Terms of Use are applicable.