Install/Configure/Administer SQL Server 2017/2016/2014/2012 on Windows 2008/2012 environment. Tune stored procedures, triggers, views and adding/changing tables for data load and transformation, and data extraction. Develop Complex Stored procedures, triggers, views and database designing. Automate Installation requirement gathering using PowerShell script. Migrate databases from SQL Server 2008/2012 to SQL Server 2014/2016. Configure Temp DB manually to increase the performance of SQL Server. Use database definition language (DDL) and control access to database objects using data control language (DCL). Use the third part tools such as REDGATE for comparing the databases and to overwrite any changes on the new servers. Develop T-SQL Scripts for database backup jobs and daily/weekly jobs. Use Dynamic Management Views (DMV) for monitoring the performance of the server. Create the reports with the SQL Server Reporting Services (SSRS). Product Design / Development/ Testing and Database Administration and Design using Windows 2008/2008R2/2012, SQL Server 2008/2008 R2/2012/2014, .NET, SSRS, SSIS, Visual Studio, VSS and TFS. SQL Server 2019/2017/2016/2014/2012 installation/administration, Migration, configuration, SSIS, SSRS and Development/Administration. Analyze and provide solution for mission critical application database performance issues. Identify the performance bottle necks using SQL Server Profiler and Perfmon and providing solution. Data Partitioning for large tables of data to increase performance. Develop Database Stored Procedures, Functions, Triggers and Design using latest technologies of SQL Server. Installation/ Configuration/ Providing Support for Software.
Master's Degree or foreign degree equivalent in Computer Science, Computer Information Systems, Computer Applications, Information Technology or Engineering and two years' experience in position or two years' experience in IT field (or Bachelor's Degree and five years' experience).
Experience with Windows environments, SQL Server administration, .NET, SSRS, SSIS, Visual Studio, VSS and TFS.
Any Applicant who is interested in this position may apply by regular mail (including Reference Number 10002) to:
Human Resources NetZoom, Inc. 2300 Cabot Drive, Suite 535 Lisle, IL 60532