A reputed software house requires services of following IT professionals on urgent basis;
Designation: Senior SQL Developer
Required Experience and Skill Set
· 4+ years of relevant experience in database design and programming in a SQL Server 2008 R2 environment required.
· Strong understanding of SQL, Transact SQL, stored procedures, functions, triggers, etc. specific to Microsoft SQL Server
· Strong SQL data access skills including demonstrated experience with complex SQL queries
· Experience dealing with Big Data and ETL
· Experience with SSRS and SSIS.
· Experience working with.NET developers to develop tools and API for data base access,
· 2 + year experiencing administrating MS SQL Servers in a production environment;
· Ability to work independently and also in a collaborative team environment
· Ability to prioritize, multi-task, and meet individual deadlines and team goals
· Excellent verbal and communication skills. (Working for U.S./U.K. based clients directly would be an advantage)
· Feasible to work in rotating and Modified shifts on requirement basis
· Strong documentation skills
Job Description/Responsibilities
o Create complex analytic queries on large data sets
o Create stored procedures, triggers, and functions
o Analyze trends in key metrics
o Generate code to extract, transform and load data from production data sources to the data warehouse
o Develop new SSIS/SSRS packages to meet business needs
o Migrate existing Access reports to SSIS/SSRS
o Provide business users the data required for metrics and analysis
o Partitioning, indexing query optimization
o Backups, performance and transaction monitoring, performance tuning and recommendations;
o Partitioning, indexing query optimization
o SQL Server replication, mirroring / log shipping, DTS and SQL Server clusters;
o Create and maintain database policies, standards and overall documentation;
o Test and documents best practices, and conduct proactive performance, capacity and availability audits
o Experience with Microsoft networking Windows 2008 Servers, SQL Server 2008 R2, .NET frame work is preferred
Note: Please do not apply if you are not qualifying for this position.
Please forward your resume at: jobs@swiftem.com