Lead - Sql server
by CSS Corp Private Limited in Chennai
Experience: 5 to 10 yrs.Posted on: 21 Jan
Job DescriptionSend me Jobs like this
Database Design and Development
· Reviews business requirements and technical design documents to develop effective database solutions
· Logical and Physical Data Modeling for the Green Dot internal and external facing applications using database normalization and de-normalization methods.
· Developing, documenting and performance tuning of effective data access routines such as stored procedures, views, triggers and functions
· Developing effective heavy duty data solutions for Database Archiving, Data Conversion and Batch Data interface using SQL Server Integration Services (SSIS)
· Provide technical leadership for large-scale database projects
· Reviews business requirements and technical design documents to develop effective database solutions
· Logical and Physical Data Modeling for the Green Dot internal and external facing applications using database normalization and de-normalization methods.
· Developing, documenting and performance tuning of effective data access routines such as stored procedures, views, triggers and functions
· Developing effective heavy duty data solutions for Database Archiving, Data Conversion and Batch Data interface using SQL Server Integration Services (SSIS)
· Provide technical leadership for large-scale database projects
Database Management
· Installation and configuration of SQL Server in database servers in both stand alone and clustering environments.
· Monitoring and Managing System Performance, Security and Capacity, taking Proactive actions to increase capacity to meet demand by upgrading hardware including disk, memory and processor
· Management of the database environment by defining database maintenance tasks, such as backup & restore, indexing, statistics, alerts and notification for database servers.
· Maintaining documentation related to database server configuration and database change management.
· Providing User and Develop support for data needs.
· Installation and configuration of SQL Server in database servers in both stand alone and clustering environments.
· Monitoring and Managing System Performance, Security and Capacity, taking Proactive actions to increase capacity to meet demand by upgrading hardware including disk, memory and processor
· Management of the database environment by defining database maintenance tasks, such as backup & restore, indexing, statistics, alerts and notification for database servers.
· Maintaining documentation related to database server configuration and database change management.
· Providing User and Develop support for data needs.
OTHER
· Works on project deliverables while supporting day-to-day production activities.
· Enforces established documentation guidelines and best practices.
· Maintains a high degree of business functional knowledge and current automated technologies and tools.
· Adheres to all policies and procedures concerning all confidential information including but not limited to internal use and restricted information, including Protected Consumer Information (PCI) and Protected Health Information (PHI).
· Adheres to all Company Health and Safety policies and procedures.
· Administers duties as defined by the Green Dot performance review plan within the required deadlines.
· Other duties as assigned by supervisor.
· Works on project deliverables while supporting day-to-day production activities.
· Enforces established documentation guidelines and best practices.
· Maintains a high degree of business functional knowledge and current automated technologies and tools.
· Adheres to all policies and procedures concerning all confidential information including but not limited to internal use and restricted information, including Protected Consumer Information (PCI) and Protected Health Information (PHI).
· Adheres to all Company Health and Safety policies and procedures.
· Administers duties as defined by the Green Dot performance review plan within the required deadlines.
· Other duties as assigned by supervisor.
Salary:
Not Disclosed by Recruiter
Industry:
IT Software, Software Services
Functional Area:
Application Programming, Maintenance
Role Category:
Programming & Design
Role:
Database Architect/Designer
Keyskills:
ssis,ssrs,sql
Desired Candidate Profile
Education:
(UG - Any Graduate - Any Specialization, Graduation Not Required) OR (PG - Any PG Course - Any Specialization, Post Graduation Not Required)
REQUIRED
· A minimum of 5 years or more of hands-on experience with MS SQL Server Database design, development and administration
· A thorough understanding of relational databases and SQL
· Experience with MS SQL Server 2005 and 2000 environments with some emphasis in Database Administration, including management tools.
· Advanced knowledge of SQL query development using MS SQL-Server 2005
· Strong Experience in SQL Performance Tuning using various performance matrix gathering techniques.
· Strong Experience in SSIS and heavy duty SQL Development using SQL Server internal database metadata structures, XML and Encryption
· Experience with database communication mechanisms: .NET, ODBC and TCP/IP
· Experience in code migration, database change management and data management through the various stages of the development life cycle
· Understanding of logical and physical modeling concepts
· Experience with the MS SQL Clustering architecture
· Excellent communication, interpersonal and organizational skills
· Ability to prioritize, meet deadlines and to work well under pressure
· Must enjoy working in a fast-paced teamwork environment and dealing with a variety of people
· Will work with both minimal supervision and in a collaborative team environment
· BS degree in Information Technology/Computer Science or equivalent work experience
· A minimum of 5 years or more of hands-on experience with MS SQL Server Database design, development and administration
· A thorough understanding of relational databases and SQL
· Experience with MS SQL Server 2005 and 2000 environments with some emphasis in Database Administration, including management tools.
· Advanced knowledge of SQL query development using MS SQL-Server 2005
· Strong Experience in SQL Performance Tuning using various performance matrix gathering techniques.
· Strong Experience in SSIS and heavy duty SQL Development using SQL Server internal database metadata structures, XML and Encryption
· Experience with database communication mechanisms: .NET, ODBC and TCP/IP
· Experience in code migration, database change management and data management through the various stages of the development life cycle
· Understanding of logical and physical modeling concepts
· Experience with the MS SQL Clustering architecture
· Excellent communication, interpersonal and organizational skills
· Ability to prioritize, meet deadlines and to work well under pressure
· Must enjoy working in a fast-paced teamwork environment and dealing with a variety of people
· Will work with both minimal supervision and in a collaborative team environment
· BS degree in Information Technology/Computer Science or equivalent work experience
ADDITIONAL SKILLS DESIRED (all of these would be pluses, but none is absolutely required)
· Banking and/or credit card systems (stored value systems) experience.
· Knowledge of new database technologies a plus
· Experience in architecture and configuration of MS SQL database mirroring, partitioning, Service Broker and Notification Services
· Experience in Microsoft Operating System – Windows Server 2003
· Experience in SQL Server 2008
· Microsoft SQL Certification will be a plus.
· Banking and/or credit card systems (stored value systems) experience.
· Knowledge of new database technologies a plus
· Experience in architecture and configuration of MS SQL database mirroring, partitioning, Service Broker and Notification Services
· Experience in Microsoft Operating System – Windows Server 2003
· Experience in SQL Server 2008
· Microsoft SQL Certification will be a plus.
Company Profile
CSS Corp is a global information and communications technology company with an impeccable record for designing, developing, deploying and managing end-to-end IT and network services. From application development, testing and optimization through to enterprise-level cloud enablement and round the clock technical support services, CSS Corp provides a truly impressive range of quality services that focus on delivering strategic value and operational efficiency for its customers.
CSS Corp proudly works with some of the world's best known customer and partner brands. And, with a global multi-cultural workforce of more than 5000 staff across 8 countries worldwide, the company has established a strong global foundation to continue supporting its international customers and growth aspirations.'
CSS Corp proudly works with some of the world's best known customer and partner brands. And, with a global multi-cultural workforce of more than 5000 staff across 8 countries worldwide, the company has established a strong global foundation to continue supporting its international customers and growth aspirations.'
Contact Details
Executive Name:
Ramya
Contact Company:
CSS Corp Private Limited
Address:
19&21, Sir Thyagaraya Road T.Nagar CHENNAI,Tamilnadu,India 600001
Email Address:
Telephone:
91-44-66768170
