Designs, builds, and integrates applications and platforms to support Intel's business needs. Responsible for application packaging deployment that meets IT standards.
Responsible for understanding various client and / or server architectural blueprints, operating system build technologies, system patching, system management & auditing;
automation, as well as server build processes. Designs and appropriately builds out all environments, which includes use of external application landing zones (DMZ), Network Load Balancing (NLB), Storage Area Networks (SAN), Microsoft OS and SQL clusters, and data encryption.
Provides these services on both internal and externally facing applications, and interacts with customers, IT partners, system architects, product managers, design engineers, service and support teams, and other system users who require input regarding their planned or existing system.
DB Developer (Microsoft SQL Server Developer) Job Description
The candidate must have advance SQL Server Developer skills including broad understanding of advance SQL Functions, expertize in DDL, DML, SQL / Dynamic SQL, and SSIS.
DB Developer is responsible for the design, development and maintenance of high quality, efficient and effective solution in MS SQL Server T-
SQL, ETL, Integration and related tools to support several large-scale MW projects. This includes developing and managing SQL database processes and services, identifying and problem-
solving for issues, interpreting and presenting program results.
Key Responsibilities :
Involve in technical design, development and unit test phases of development life cycle.
Work with functional and technical teams to understand requirements and provide technical design
Provide level of effort estimates
Design, configure, develop, and troubleshoot technical issues
Deliver developments within project timelines
Resolve production issues / fixes
Capable of working individually or as a team member
Partners with peers across the IT organization to solve complex business problems including taking a lead role on the high level solution options and approach
The work load is split, 40% on support and 60% on business requirements / enhancements
Experience with full life-cycle application development.
5 to 7 years of experience with Microsoft SQL Server 2008 R2 and above.
Design, develop and maintain appropriately-scaled, effective solutions to support data quality, migration and reconciliation activity in Microsoft SQL Server T-
SQL, Integration Services and related tools. Support customer experience, architecture, security and operations.
Very strong T-SQL skills and strong knowledge of ETL techniques. Creating and analyzing complex queries, store procedures, tables, views, triggers, functions, SQL Jobs.
Ability to write reusable, robust, and clean code to do almost anything.
Design and implementation of SSIS, and ETL based on business requirements.
Good understanding of Database Design, Integrity, and optimization process.
In depth experience of performance-tuning SQL Server databases code and environments, and SQL profiling.
Strong background in data modelling, data management and data manipulation, code management and version control (GIT).
Strong problem-solving and analytical skills. Able to understand business requirements and develop SQL Server solutions that work within the technical boundaries.
Working directly with the business teams to understand their needs, identify and resolve data issues.
Knowledge of table replications.
Knowledge of security management such users and object permission.
Knowledge of active directory and security groups.
Writing technical design and supporting documentation.
Excellent written and verbal communication and presentation skills.
Accurately estimate the time and materials required to complete the development work within project timelines.
Ability to work in an Agile environment. The candidate can manage multiple tasks and independently manage his / her own time.
Candidate must be intellectually curious, be adept in database technologies, have the ability to mine data to answer complex questions and clearly communicate findings.
EMB2 - India - Bangalore Embassy Golflinks