We Are Professional

Home / Current Job / Job Detail

ETL/Microsoft SQL Server Architect Back

Job Title ETL/Microsoft SQL Server Architect
Gender Preference Any
Number Of Vacancy 1
Industry Area IT Services & Consulting
Key Skills ETL, SQL, Server Architect, PL/SQL, SQL Server, T-SQL, DDL, DML, DCL, DTS, ETL, SSIS, SSRS, Power BI,
Qualification Any
Salary (Per Annum) 30.00 LPA
Work Experience 12 - 15 Years
Job Requirement
Over 12 to 25 years of IT experience in Database Administration and System Administration.
Expert in installation, configuration and maintenance of MS SQL Server2019/2012/2008 R2/2008/2005/2000 in standalone and clustered servers.
Highly experienced in investigating and applying necessary SQL Server database service packs, hot fixes and Security Patches.
Experience of Upgrading and migration from earlier version of SQL Server to SQL Server 7 à 2000 à 2005 à 2008 à 2012 à2019 in different environments
Experience in installing SQL 2012 and above
Good knowledge in creating SQL objects like Databases, tables, views, stored procedures, Indexes, Triggers, and User defined data types, cursors and Functions. In-depth knowledge of T-SQL, SQL (DDL, DML, and DCL), PL/SQL. Written queries 5 to 7 level deep Experience in T-SQL programming skills. Experience in writing and debugging Stored Procedures and Triggers.
DTS (Data Transformation Services) and SSIS Packages from SQL Server. Hands on Experience in ETL (Extracting, Transforming and Loading) development using DTS and SSIS.
Deployment of SSIS on SQL agent, scheduling maintenance and optimization tasks on SQL agent.  
Experience on working with Windows 2000/2003/2008R2 environments.
Hands on experience in troubleshooting Database/data Issues
Expertise in database Backup, Recovery and Disaster recovery procedures (Log shipping, Mirroring, clustering, Replication and SRDF). Experience in implementing different types of Replication Models like Snapshot, Merge and transactional. Expert in designing disaster recovery model for corporate databases. 
Experience in Performance Tuning for slow/long running stored procedures and server level tuning, Query Optimization, Client/Server Connectivity, Database consistency checks using DBCC Utilities.
Expert in utilizing different Monitoring tools including third party tools.
Maintained Database Authentication Modes, Creation of Users, Configuring Permissions and assigning roles to users.
Experience in extracting and transforming transactional information using DTS Import/Export wizard, BCP (Bulk Copy Program) 
Using Performance Monitor/Profiler to solve Blocking, Dead Locks/Long running queries.
Experience in PowerBI - SQL Server Reporting Services (SSRS).
Experience in working with remote teams
Experience in using different Transformation tools like DTS Packages, SSIS, BCP and BULK INSERT.
Experience in Installation of SSRS 2005/2008 .Hands on generating different types of Reports using SQL Server Reporting Services (SSRS).
Trouble shooting SSRS issues. 

Job Location
Job Country India
Job State / U.T. Gujarat
Job City Gandhinagar
Company Profile
Company Name Our Reputed Client
About Company

Our reputed client is a US based IT company that supports the full insurance lifecycle workflow, managing all insurance products from quote to enrollment to engagement.

Contact Details
Contact Person Ms. Jinal Karkada
Mobile 9974237872
Email ID
Share & Apply
Apply Now Back